APPS.EDR_PSIG dependencies on EDR_UTILITIES

Line 474: l_doc_req_disp_name := edr_utilities.getuserdisplayname(p_psig_requester);

470: l_XML:=P_PSIG_XML;
471:
472: -- Bug 3604783 : Start
473: -- Find the document requester's display name
474: l_doc_req_disp_name := edr_utilities.getuserdisplayname(p_psig_requester);
475:
476: --Bug 4672801: start
477: EDR_UTILITIES.getWhoColumns
478: ( creation_date => l_creation_date ,

Line 477: EDR_UTILITIES.getWhoColumns

473: -- Find the document requester's display name
474: l_doc_req_disp_name := edr_utilities.getuserdisplayname(p_psig_requester);
475:
476: --Bug 4672801: start
477: EDR_UTILITIES.getWhoColumns
478: ( creation_date => l_creation_date ,
479: created_by => l_created_by ,
480: last_update_date => l_last_update_date ,
481: last_updated_by => l_last_updated_by ,

Line 634: EDR_UTILITIES.getWhoColumns

630: --Generate a new Document ID
631: select EDR_PSIG_DOCUMENTS_S.nextval into l_document_id from dual;
632:
633: --Bug 4672801: start
634: EDR_UTILITIES.getWhoColumns
635: ( creation_date => l_creation_date ,
636: created_by => l_created_by ,
637: last_update_date => l_last_update_date ,
638: last_updated_by => l_last_updated_by ,

Line 920: l_doc_req_disp_name := edr_utilities.getuserdisplayname(p_psig_requester);

916: l_XML:=P_PSIG_XML;
917:
918: -- Bug 3604783 : Start
919: /* Recieve the document requester's display name */
920: l_doc_req_disp_name := edr_utilities.getuserdisplayname(p_psig_requester);
921:
922: update EDR_PSIG_DOCUMENTS
923: set
924: PSIG_XML=l_xml,

Line 1465: EDR_UTILITIES .getUserRoleInfo(p_user_name, l_user_display_name, l_orig_system, l_orig_system_id);

1461: =nvl(P_ORIGINAL_RECIPIENT,P_USER_NAME);
1462: */
1463:
1464: --Bug 3101047 : Start
1465: EDR_UTILITIES .getUserRoleInfo(p_user_name, l_user_display_name, l_orig_system, l_orig_system_id);
1466: UPDATE EDR_PSIG_DETAILS
1467: SET
1468: EVIDENCE_STORE_ID=P_EVIDENCE_STORE_ID,
1469: USER_RESPONSE=P_USER_RESPONSE,

Line 1867: DECODE(SIGNATURE_TIMESTAMP,NULL,EDR_UTILITIES.GETUSERDISPLAYNAME(USER_NAME), USER_DISPLAY_NAME)USER_DISPLAY_NAME

1863: LAST_UPDATE_DATE,
1864: LAST_UPDATE_LOGIN,
1865: LAST_UPDATED_BY,
1866: --Bug 3101047 : Start
1867: DECODE(SIGNATURE_TIMESTAMP,NULL,EDR_UTILITIES.GETUSERDISPLAYNAME(USER_NAME), USER_DISPLAY_NAME)USER_DISPLAY_NAME
1868: --Bug 3101047 : End
1869: FROM EDR_PSIG_DETAILS
1870: where DOCUMENT_ID=P_DOCUMENT_ID;
1871: BEGIN

Line 2003: DECODE(SIGNATURE_TIMESTAMP,NULL,EDR_UTILITIES.GETUSERDISPLAYNAME(USER_NAME), USER_DISPLAY_NAME)USER_DISPLAY_NAME

1999: LAST_UPDATE_DATE,
2000: LAST_UPDATE_LOGIN,
2001: LAST_UPDATED_BY,
2002: --Bug 3101047 : Start
2003: DECODE(SIGNATURE_TIMESTAMP,NULL,EDR_UTILITIES.GETUSERDISPLAYNAME(USER_NAME), USER_DISPLAY_NAME)USER_DISPLAY_NAME
2004: --Bug 3101047 : End
2005: FROM EDR_PSIG_DETAILS
2006: where SIGNATURE_ID=P_SIGNATURE_ID;
2007: BEGIN

Line 2465: EDR_UTILITIES.GETUSERROLEINFO(P_USER_NAME => l_user_name,

2461: LOOP
2462: FETCH GET_PSIG_USER_NAME INTO l_user_name;
2463: EXIT WHEN GET_PSIG_USER_NAME%NOTFOUND;
2464:
2465: EDR_UTILITIES.GETUSERROLEINFO(P_USER_NAME => l_user_name,
2466: X_USER_DISPLAY_NAME => l_user_display_name,
2467: X_ORIG_SYSTEM => l_orig_system,
2468: X_ORIG_SYSTEM_ID => l_orig_system_id);
2469: