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_DETAILS

Line 33: SIGNATURE_ID EDR_PSIG_DETAILS.SIGNATURE_ID%TYPE,

29:
30: TYPE DocumentTable is TABLE of Document INDEX by Binary_INTEGER;
31:
32: TYPE Signature is Record (
33: SIGNATURE_ID EDR_PSIG_DETAILS.SIGNATURE_ID%TYPE,
34: DOCUMENT_ID EDR_PSIG_DETAILS.DOCUMENT_ID%TYPE,
35: EVIDENCE_STORE_ID EDR_PSIG_DETAILS.EVIDENCE_STORE_ID%TYPE,
36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,
37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,

Line 34: DOCUMENT_ID EDR_PSIG_DETAILS.DOCUMENT_ID%TYPE,

30: TYPE DocumentTable is TABLE of Document INDEX by Binary_INTEGER;
31:
32: TYPE Signature is Record (
33: SIGNATURE_ID EDR_PSIG_DETAILS.SIGNATURE_ID%TYPE,
34: DOCUMENT_ID EDR_PSIG_DETAILS.DOCUMENT_ID%TYPE,
35: EVIDENCE_STORE_ID EDR_PSIG_DETAILS.EVIDENCE_STORE_ID%TYPE,
36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,
37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,
38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,

Line 35: EVIDENCE_STORE_ID EDR_PSIG_DETAILS.EVIDENCE_STORE_ID%TYPE,

31:
32: TYPE Signature is Record (
33: SIGNATURE_ID EDR_PSIG_DETAILS.SIGNATURE_ID%TYPE,
34: DOCUMENT_ID EDR_PSIG_DETAILS.DOCUMENT_ID%TYPE,
35: EVIDENCE_STORE_ID EDR_PSIG_DETAILS.EVIDENCE_STORE_ID%TYPE,
36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,
37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,
38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,
39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,

Line 36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,

32: TYPE Signature is Record (
33: SIGNATURE_ID EDR_PSIG_DETAILS.SIGNATURE_ID%TYPE,
34: DOCUMENT_ID EDR_PSIG_DETAILS.DOCUMENT_ID%TYPE,
35: EVIDENCE_STORE_ID EDR_PSIG_DETAILS.EVIDENCE_STORE_ID%TYPE,
36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,
37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,
38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,
39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,
40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,

Line 37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,

33: SIGNATURE_ID EDR_PSIG_DETAILS.SIGNATURE_ID%TYPE,
34: DOCUMENT_ID EDR_PSIG_DETAILS.DOCUMENT_ID%TYPE,
35: EVIDENCE_STORE_ID EDR_PSIG_DETAILS.EVIDENCE_STORE_ID%TYPE,
36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,
37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,
38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,
39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,
40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,
41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,

Line 38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,

34: DOCUMENT_ID EDR_PSIG_DETAILS.DOCUMENT_ID%TYPE,
35: EVIDENCE_STORE_ID EDR_PSIG_DETAILS.EVIDENCE_STORE_ID%TYPE,
36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,
37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,
38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,
39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,
40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,
41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,
42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,

Line 39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,

35: EVIDENCE_STORE_ID EDR_PSIG_DETAILS.EVIDENCE_STORE_ID%TYPE,
36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,
37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,
38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,
39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,
40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,
41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,
42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,
43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,

Line 40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,

36: USER_NAME EDR_PSIG_DETAILS.USER_NAME%TYPE,
37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,
38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,
39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,
40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,
41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,
42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,
43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,
44: LAST_UPDATED_BY EDR_PSIG_DETAILS.LAST_UPDATED_BY%TYPE,

Line 41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,

37: USER_RESPONSE EDR_PSIG_DETAILS.USER_RESPONSE%TYPE,
38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,
39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,
40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,
41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,
42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,
43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,
44: LAST_UPDATED_BY EDR_PSIG_DETAILS.LAST_UPDATED_BY%TYPE,
45: LAST_UPDATE_LOGIN EDR_PSIG_DETAILS.LAST_UPDATE_LOGIN%TYPE,

Line 42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,

38: SIGNATURE_TIMESTAMP EDR_PSIG_DETAILS.SIGNATURE_TIMESTAMP%TYPE,
39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,
40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,
41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,
42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,
43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,
44: LAST_UPDATED_BY EDR_PSIG_DETAILS.LAST_UPDATED_BY%TYPE,
45: LAST_UPDATE_LOGIN EDR_PSIG_DETAILS.LAST_UPDATE_LOGIN%TYPE,
46: --Bug 3101047 : Start

Line 43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,

39: SIGNATURE_TIMEZONE EDR_PSIG_DETAILS.SIGNATURE_TIMEZONE%TYPE,
40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,
41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,
42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,
43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,
44: LAST_UPDATED_BY EDR_PSIG_DETAILS.LAST_UPDATED_BY%TYPE,
45: LAST_UPDATE_LOGIN EDR_PSIG_DETAILS.LAST_UPDATE_LOGIN%TYPE,
46: --Bug 3101047 : Start
47: USER_DISPLAY_NAME EDR_PSIG_DETAILS.USER_DISPLAY_NAME%TYPE

Line 44: LAST_UPDATED_BY EDR_PSIG_DETAILS.LAST_UPDATED_BY%TYPE,

40: SIGNATURE_STATUS EDR_PSIG_DETAILS.SIGNATURE_STATUS%TYPE,
41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,
42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,
43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,
44: LAST_UPDATED_BY EDR_PSIG_DETAILS.LAST_UPDATED_BY%TYPE,
45: LAST_UPDATE_LOGIN EDR_PSIG_DETAILS.LAST_UPDATE_LOGIN%TYPE,
46: --Bug 3101047 : Start
47: USER_DISPLAY_NAME EDR_PSIG_DETAILS.USER_DISPLAY_NAME%TYPE
48: --Bug 3101047 : End

Line 45: LAST_UPDATE_LOGIN EDR_PSIG_DETAILS.LAST_UPDATE_LOGIN%TYPE,

41: CREATION_DATE EDR_PSIG_DETAILS.CREATION_DATE%TYPE,
42: CREATED_BY EDR_PSIG_DETAILS.CREATED_BY%TYPE,
43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,
44: LAST_UPDATED_BY EDR_PSIG_DETAILS.LAST_UPDATED_BY%TYPE,
45: LAST_UPDATE_LOGIN EDR_PSIG_DETAILS.LAST_UPDATE_LOGIN%TYPE,
46: --Bug 3101047 : Start
47: USER_DISPLAY_NAME EDR_PSIG_DETAILS.USER_DISPLAY_NAME%TYPE
48: --Bug 3101047 : End
49: );

Line 47: USER_DISPLAY_NAME EDR_PSIG_DETAILS.USER_DISPLAY_NAME%TYPE

43: LAST_UPDATE_DATE EDR_PSIG_DETAILS.LAST_UPDATE_DATE%TYPE,
44: LAST_UPDATED_BY EDR_PSIG_DETAILS.LAST_UPDATED_BY%TYPE,
45: LAST_UPDATE_LOGIN EDR_PSIG_DETAILS.LAST_UPDATE_LOGIN%TYPE,
46: --Bug 3101047 : Start
47: USER_DISPLAY_NAME EDR_PSIG_DETAILS.USER_DISPLAY_NAME%TYPE
48: --Bug 3101047 : End
49: );
50:
51: TYPE SignatureTable is TABLE of Signature INDEX by Binary_INTEGER;

Line 459: -- Function : Update the user details of those users in EDR_PSIG_DETAILS table

455:
456: -- Start of comments
457: -- API name : UPDATE_PSIG_USER_DETAILS
458: -- Type : Private Utility
459: -- Function : Update the user details of those users in EDR_PSIG_DETAILS table
460: -- : for the specified document_id and whose signature status is pending.
461: -- Pre-reqs : None.
462: -- Parameters :
463: -- IN : P_DOCUMENT_ID IN NUMBER