Package IKB_TRASHBIN
Method Summary |
|
DELETEFROMTRASHBIN(P_DOCUMENT_REFERENCES IN CT_DOCUMENT_REFERENCE, P_EXECUTION_USER IN OT_USERREFERENCE)
Remove documents from the trash bin. |
|
MOVETOTRASHBIN(P_DOCUMENT_REFERENCE IN OT_DOCUMENT_REFERENCE, P_EXECUTION_USER IN OT_USERREFERENCE)
|
VARCHAR2 |
REMOVEEXPIREDTRASH()
Remove expired documents from the trash bin. |
|
RESTOREFROMTRASHBIN(P_DOCUMENT_REFERENCES IN CT_DOCUMENT_REFERENCE, P_EXECUTION_USER IN OT_USERREFERENCE)
Restore documents from the trash bin. |
SYS_REFCURSOR |
VIEWTRASHBIN(P_EXECUTION_USER IN OT_USERREFERENCE, P_START_ROW IN NUMBER DEFAULT 1, P_NUM_ROWS IN NUMBER DEFAULT 50, P_DOCUMENT_TYPE_ID IN NUMBER DEFAULT NULL, P_SEARCH_STRING IN VARCHAR2 DEFAULT NULL, P_SORT_FIELD IN VARCHAR2 DEFAULT 'DELETED_DATE', P_SORT_FIELD_DIR IN VARCHAR2 DEFAULT 'ASC')
|
DELETEFROMTRASHBIN
public DELETEFROMTRASHBIN(P_DOCUMENT_REFERENCES IN CT_DOCUMENT_REFERENCE,
P_EXECUTION_USER IN OT_USERREFERENCE)
- Remove documents from the trash bin. It will delete the document with all its attributes from the trash bin
-
- Parameters:
-
P_DOCUMENT_REFERENCES
-
Array of document references to be deleted from the trash bin
-
P_EXECUTION_USER
-
Reference to the authenticated user executing the statement
MOVETOTRASHBIN
public MOVETOTRASHBIN(P_DOCUMENT_REFERENCE IN OT_DOCUMENT_REFERENCE,
P_EXECUTION_USER IN OT_USERREFERENCE)
-
REMOVEEXPIREDTRASH
public VARCHAR2 REMOVEEXPIREDTRASH()
- Remove expired documents from the trash bin. It will delete all documents that have stayed in numDays as given on the information type
-
RESTOREFROMTRASHBIN
public RESTOREFROMTRASHBIN(P_DOCUMENT_REFERENCES IN CT_DOCUMENT_REFERENCE,
P_EXECUTION_USER IN OT_USERREFERENCE)
- Restore documents from the trash bin. It will recreate the document with all its attributes
-
- Parameters:
-
P_DOCUMENT_REFERENCES
-
Array of document references to be restored from the trash bin
-
P_EXECUTION_USER
-
Reference to the authenticated user executing the statement
VIEWTRASHBIN
public SYS_REFCURSOR VIEWTRASHBIN(P_EXECUTION_USER IN OT_USERREFERENCE,
P_START_ROW IN NUMBER DEFAULT 1,
P_NUM_ROWS IN NUMBER DEFAULT 50,
P_DOCUMENT_TYPE_ID IN NUMBER DEFAULT NULL,
P_SEARCH_STRING IN VARCHAR2 DEFAULT NULL,
P_SORT_FIELD IN VARCHAR2 DEFAULT 'DELETED_DATE',
P_SORT_FIELD_DIR IN VARCHAR2 DEFAULT 'ASC')
-