eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_PSIG dependencies on EDR_PSIG_DOCUMENTS

Line 11: DOCUMENT_ID EDR_PSIG_DOCUMENTS.DOCUMENT_ID%TYPE,

7: Param_Value VARCHAR2(4000),Param_displayname varchar2(240));
8: TYPE params_table is TABLE of params_rec INDEX by Binary_INTEGER;
9:
10: TYPE Document is Record (
11: DOCUMENT_ID EDR_PSIG_DOCUMENTS.DOCUMENT_ID%TYPE,
12: PSIG_XML EDR_PSIG_DOCUMENTS.PSIG_XML%TYPE,
13: PSIG_DOCUMENT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENT%TYPE,
14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,
15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,

Line 12: PSIG_XML EDR_PSIG_DOCUMENTS.PSIG_XML%TYPE,

8: TYPE params_table is TABLE of params_rec INDEX by Binary_INTEGER;
9:
10: TYPE Document is Record (
11: DOCUMENT_ID EDR_PSIG_DOCUMENTS.DOCUMENT_ID%TYPE,
12: PSIG_XML EDR_PSIG_DOCUMENTS.PSIG_XML%TYPE,
13: PSIG_DOCUMENT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENT%TYPE,
14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,
15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,
16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,

Line 13: PSIG_DOCUMENT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENT%TYPE,

9:
10: TYPE Document is Record (
11: DOCUMENT_ID EDR_PSIG_DOCUMENTS.DOCUMENT_ID%TYPE,
12: PSIG_XML EDR_PSIG_DOCUMENTS.PSIG_XML%TYPE,
13: PSIG_DOCUMENT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENT%TYPE,
14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,
15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,
16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,
17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,

Line 14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,

10: TYPE Document is Record (
11: DOCUMENT_ID EDR_PSIG_DOCUMENTS.DOCUMENT_ID%TYPE,
12: PSIG_XML EDR_PSIG_DOCUMENTS.PSIG_XML%TYPE,
13: PSIG_DOCUMENT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENT%TYPE,
14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,
15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,
16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,
17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,
18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,

Line 15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,

11: DOCUMENT_ID EDR_PSIG_DOCUMENTS.DOCUMENT_ID%TYPE,
12: PSIG_XML EDR_PSIG_DOCUMENTS.PSIG_XML%TYPE,
13: PSIG_DOCUMENT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENT%TYPE,
14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,
15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,
16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,
17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,
18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,
19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,

Line 16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,

12: PSIG_XML EDR_PSIG_DOCUMENTS.PSIG_XML%TYPE,
13: PSIG_DOCUMENT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENT%TYPE,
14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,
15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,
16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,
17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,
18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,
19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,
20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,

Line 17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,

13: PSIG_DOCUMENT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENT%TYPE,
14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,
15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,
16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,
17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,
18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,
19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,
20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,
21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,

Line 18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,

14: PSIG_DOCUMENTFORMAT EDR_PSIG_DOCUMENTS.PSIG_DOCUMENTFORMAT%TYPE,
15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,
16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,
17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,
18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,
19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,
20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,
21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,
22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,

Line 19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,

15: PSIG_TIMESTAMP EDR_PSIG_DOCUMENTS.PSIG_TIMESTAMP%TYPE,
16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,
17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,
18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,
19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,
20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,
21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,
22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,
23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,

Line 20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,

16: PSIG_TIMEZONE EDR_PSIG_DOCUMENTS.PSIG_TIMEZONE%TYPE,
17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,
18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,
19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,
20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,
21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,
22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,
23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,
24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,

Line 21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,

17: DOCUMENT_REQUESTER EDR_PSIG_DOCUMENTS.DOCUMENT_REQUESTER%TYPE,
18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,
19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,
20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,
21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,
22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,
23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,
24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,
25: LAST_UPDATE_DATE EDR_PSIG_DOCUMENTS.LAST_UPDATE_DATE%TYPE,

Line 22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,

18: PSIG_STATUS EDR_PSIG_DOCUMENTS.PSIG_STATUS%TYPE,
19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,
20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,
21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,
22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,
23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,
24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,
25: LAST_UPDATE_DATE EDR_PSIG_DOCUMENTS.LAST_UPDATE_DATE%TYPE,
26: LAST_UPDATED_BY EDR_PSIG_DOCUMENTS.LAST_UPDATED_BY%TYPE,

Line 23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,

19: PSIG_SOURCE EDR_PSIG_DOCUMENTS.PSIG_SOURCE%TYPE,
20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,
21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,
22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,
23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,
24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,
25: LAST_UPDATE_DATE EDR_PSIG_DOCUMENTS.LAST_UPDATE_DATE%TYPE,
26: LAST_UPDATED_BY EDR_PSIG_DOCUMENTS.LAST_UPDATED_BY%TYPE,
27: LAST_UPDATE_LOGIN EDR_PSIG_DOCUMENTS.LAST_UPDATE_LOGIN%TYPE

Line 24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,

20: EVENT_NAME EDR_PSIG_DOCUMENTS.EVENT_NAME%TYPE,
21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,
22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,
23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,
24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,
25: LAST_UPDATE_DATE EDR_PSIG_DOCUMENTS.LAST_UPDATE_DATE%TYPE,
26: LAST_UPDATED_BY EDR_PSIG_DOCUMENTS.LAST_UPDATED_BY%TYPE,
27: LAST_UPDATE_LOGIN EDR_PSIG_DOCUMENTS.LAST_UPDATE_LOGIN%TYPE
28: );

Line 25: LAST_UPDATE_DATE EDR_PSIG_DOCUMENTS.LAST_UPDATE_DATE%TYPE,

21: EVENT_KEY EDR_PSIG_DOCUMENTS.EVENT_KEY%TYPE,
22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,
23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,
24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,
25: LAST_UPDATE_DATE EDR_PSIG_DOCUMENTS.LAST_UPDATE_DATE%TYPE,
26: LAST_UPDATED_BY EDR_PSIG_DOCUMENTS.LAST_UPDATED_BY%TYPE,
27: LAST_UPDATE_LOGIN EDR_PSIG_DOCUMENTS.LAST_UPDATE_LOGIN%TYPE
28: );
29:

Line 26: LAST_UPDATED_BY EDR_PSIG_DOCUMENTS.LAST_UPDATED_BY%TYPE,

22: PRINT_COUNT EDR_PSIG_DOCUMENTS.PRINT_COUNT%TYPE,
23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,
24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,
25: LAST_UPDATE_DATE EDR_PSIG_DOCUMENTS.LAST_UPDATE_DATE%TYPE,
26: LAST_UPDATED_BY EDR_PSIG_DOCUMENTS.LAST_UPDATED_BY%TYPE,
27: LAST_UPDATE_LOGIN EDR_PSIG_DOCUMENTS.LAST_UPDATE_LOGIN%TYPE
28: );
29:
30: TYPE DocumentTable is TABLE of Document INDEX by Binary_INTEGER;

Line 27: LAST_UPDATE_LOGIN EDR_PSIG_DOCUMENTS.LAST_UPDATE_LOGIN%TYPE

23: CREATION_DATE EDR_PSIG_DOCUMENTS.CREATION_DATE%TYPE,
24: CREATED_BY EDR_PSIG_DOCUMENTS.CREATED_BY%TYPE,
25: LAST_UPDATE_DATE EDR_PSIG_DOCUMENTS.LAST_UPDATE_DATE%TYPE,
26: LAST_UPDATED_BY EDR_PSIG_DOCUMENTS.LAST_UPDATED_BY%TYPE,
27: LAST_UPDATE_LOGIN EDR_PSIG_DOCUMENTS.LAST_UPDATE_LOGIN%TYPE
28: );
29:
30: TYPE DocumentTable is TABLE of Document INDEX by Binary_INTEGER;
31:

Line 313: P_DOC_ID IN edr_psig_documents.document_id%TYPE,

309: );
310:
311:
312: PROCEDURE updatePrintCount (
313: P_DOC_ID IN edr_psig_documents.document_id%TYPE,
314: P_NEW_COUNT OUT NOCOPY NUMBER
315: );
316:
317: --Bug 3330240 : start

Line 430: --This procedure gets the PSIG_XML from EDR_PSIG_DOCUMENTS table

426: --Bug 3330240 : end
427:
428: -- Bug 3170251 - Start
429: -- Added a getter to get PSIG_XML (eRecord XML ) in CLOB.
430: --This procedure gets the PSIG_XML from EDR_PSIG_DOCUMENTS table
431: --for the given p_document_id i.e. eRecordId
432:
433: -- Start of comments
434: -- API name : getERecordXML