APPS.EDR_EINITIALS_PVT dependencies on EDR_PSIG

Line 73: FROM EDR_PSIG_DOCUMENTS

69: EDR_CTX_PKG.SET_SECURE_ATTR;
70:
71: --Fetch the e-record document.
72: SELECT PSIG_DOCUMENT INTO X_ERECORD_TEXT
73: FROM EDR_PSIG_DOCUMENTS
74: WHERE DOCUMENT_ID = L_ERECORD_ID;
75:
76: --Adjust the CLOB document for rendering in the OA page.
77: --Primarily we would be converting all instances of '<' to '<' and '>' to '>'.

Line 229: L_SIGN_PARAMS EDR_PSIG.PARAMS_TABLE;

225: L_SIGNATURE_ID NUMBER;
226: L_SIGNATURE_SEQUENCE NUMBER;
227: L_ERROR_CODE NUMBER;
228: L_ERROR_MSG VARCHAR2(4000);
229: L_SIGN_PARAMS EDR_PSIG.PARAMS_TABLE;
230: L_RESPONSE_MEANING VARCHAR2(400);
231: L_EVENT_ID NUMBER;
232: L_OVERRIDING_COMMENTS VARCHAR2(4000);
233: L_ORIGINAL_RECIPIENT VARCHAR2(100);

Line 285: --we need to first request signature in EDR_PSIG_DETAILS before posting the signer response

281: WHERE SIGNATURE_ID = L_SIGNATURE_ID;
282:
283:
284: --Since the role name is either null or contains a responsibility,
285: --we need to first request signature in EDR_PSIG_DETAILS before posting the signer response
286: --details.
287: EDR_PSIG.REQUESTSIGNATURE(P_DOCUMENT_ID => L_ERECORD_ID,
288: P_USER_NAME => UPPER(P_SIGNER_NAME),
289: P_ORIGINAL_RECIPIENT => NULL,

Line 287: EDR_PSIG.REQUESTSIGNATURE(P_DOCUMENT_ID => L_ERECORD_ID,

283:
284: --Since the role name is either null or contains a responsibility,
285: --we need to first request signature in EDR_PSIG_DETAILS before posting the signer response
286: --details.
287: EDR_PSIG.REQUESTSIGNATURE(P_DOCUMENT_ID => L_ERECORD_ID,
288: P_USER_NAME => UPPER(P_SIGNER_NAME),
289: P_ORIGINAL_RECIPIENT => NULL,
290: P_OVERRIDING_COMMENTS => NULL,
291: P_SIGNATURE_SEQUENCE => L_SIGNATURE_SEQUENCE,

Line 307: EDR_PSIG.POSTSIGNATURE(P_DOCUMENT_ID => L_ERECORD_ID,

303: --Fetch the signer response meaning from FND LOOKUPS.
304: EDR_STANDARD.GET_MEANING('EDR_SIGN_RESPONSE_TYPE', P_SIGNER_RESPONSE,L_RESPONSE_MEANING);
305:
306: --Post the signature details into evidence store.
307: EDR_PSIG.POSTSIGNATURE(P_DOCUMENT_ID => L_ERECORD_ID,
308: P_EVIDENCE_STORE_ID => NULL,
309: P_USER_NAME => UPPER(P_SIGNER_NAME),
310: P_USER_RESPONSE => L_RESPONSE_MEANING,
311: P_ORIGINAL_RECIPIENT => NULL,

Line 344: EDR_PSIG.POSTSIGNATURE(P_DOCUMENT_ID => L_ERECORD_ID,

340: OPEN FETCH_OVERRIDING_DETAILS;
341: FETCH FETCH_OVERRIDING_DETAILS INTO L_ORIGINAL_RECIPIENT,L_OVERRIDING_COMMENTS;
342: CLOSE FETCH_OVERRIDING_DETAILS;
343:
344: EDR_PSIG.POSTSIGNATURE(P_DOCUMENT_ID => L_ERECORD_ID,
345: P_EVIDENCE_STORE_ID => NULL,
346: P_USER_NAME => upper(P_SIGNER_NAME),
347: P_USER_RESPONSE => L_RESPONSE_MEANING,
348: P_ORIGINAL_RECIPIENT => L_ORIGINAL_RECIPIENT,

Line 373: EDR_PSIG.POSTSIGNATUREPARAMETER(P_SIGNATURE_ID => L_SIGNATURE_ID,

369: EDR_STANDARD.GET_MEANING('EDR_SIGN_REASON_TYPE',P_SIGNING_REASON,L_SIGN_PARAMS(3).PARAM_VALUE);
370: EDR_STANDARD.GET_MEANING('EDR_SIGN_PARAMS_DISPLAY_TYPE','REASON_CODE',L_SIGN_PARAMS(3).PARAM_DISPLAYNAME);
371:
372: --Post the signature parameters into evidence store.
373: EDR_PSIG.POSTSIGNATUREPARAMETER(P_SIGNATURE_ID => L_SIGNATURE_ID,
374: P_PARAMETERS => L_SIGN_PARAMS,
375: P_ERROR => L_ERROR_CODE,
376: P_ERROR_MSG => L_ERROR_MSG);
377: --If the error code is not null then an unexpected error has occurred.

Line 458: WF_ENGINE.SETITEMATTRNUMBER(P_ITEMTYPE,P_ITEMKEY,'EDR_PSIG_DOC_ID',L_ERECORD_ID);

454: --Get the event ID in number format.
455: L_EVENT_ID := TO_NUMBER(P_ITEMKEY,'999999999999.999999');
456:
457: --Set the e-record ID in workflow.
458: WF_ENGINE.SETITEMATTRNUMBER(P_ITEMTYPE,P_ITEMKEY,'EDR_PSIG_DOC_ID',L_ERECORD_ID);
459:
460: --Move the workflow blocked activity as required.
461: FND_WF_ENGINE.COMPLETEACTIVITY(P_ITEMTYPE, P_ITEMKEY, 'LITE_MODE', 'DONE');
462:

Line 522: WF_ENGINE.SETITEMATTRNUMBER(P_ITEMTYPE,P_ITEMKEY,'EDR_PSIG_DOC_ID',L_ERECORD_ID);

518: --Get the e-record ID value in number format.
519: L_ERECORD_ID := TO_NUMBER(P_ERECORD_ID,'999999999999.999999');
520:
521: --Set the e-record ID in workflow.
522: WF_ENGINE.SETITEMATTRNUMBER(P_ITEMTYPE,P_ITEMKEY,'EDR_PSIG_DOC_ID',L_ERECORD_ID);
523:
524: -- Bug 5158510 : start
525: l_signature_mode := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,EDR_CONSTANTS_GRP.G_SIGNATURE_MODE);
526: IF(EDR_CONSTANTS_GRP.G_ERES_LITE = l_signature_mode) then