DBA Data[Home] [Help]

APPS.GMO_CBR_GRP dependencies on EDR_PSIG

Line 69: AND b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'

65: FROM
66: wf_events_vl a,
67: wf_event_subscriptions b
68: WHERE a.GUID = b.EVENT_FILTER_GUID
69: AND b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
70: AND a.name = l_event_name
71: and b.owner_tag <> 'GMO'
72: and b.status = 'ENABLED';
73:

Line 365: l_document EDR_PSIG.DOCUMENT;

361: END;
362:
363: PROCEDURE CBR_PREPROCESS (P_BATCH_ID IN NUMBER) IS
364: -- local variables
365: l_document EDR_PSIG.DOCUMENT;
366: l_docparams EDR_PSIG.PARAMS_TABLE;
367: l_signatures EDR_PSIG.SIGNATURETABLE;
368: l_error NUMBER;
369: l_error_msg VARCHAR2(4000);

Line 366: l_docparams EDR_PSIG.PARAMS_TABLE;

362:
363: PROCEDURE CBR_PREPROCESS (P_BATCH_ID IN NUMBER) IS
364: -- local variables
365: l_document EDR_PSIG.DOCUMENT;
366: l_docparams EDR_PSIG.PARAMS_TABLE;
367: l_signatures EDR_PSIG.SIGNATURETABLE;
368: l_error NUMBER;
369: l_error_msg VARCHAR2(4000);
370: l_event_name varchar2(80) := NULL;

Line 367: l_signatures EDR_PSIG.SIGNATURETABLE;

363: PROCEDURE CBR_PREPROCESS (P_BATCH_ID IN NUMBER) IS
364: -- local variables
365: l_document EDR_PSIG.DOCUMENT;
366: l_docparams EDR_PSIG.PARAMS_TABLE;
367: l_signatures EDR_PSIG.SIGNATURETABLE;
368: l_error NUMBER;
369: l_error_msg VARCHAR2(4000);
370: l_event_name varchar2(80) := NULL;
371: l_event_key varchar2(80) := NULL;

Line 463: edr_psig.getdocumentdetails(GMO_BATCH_PROGRESSION_REC.ERECORD_ID,l_document,l_docparams,l_signatures,l_error,l_error_msg);

459: -- we can mark row as completed once ERES is success.
460: --
461: FOR GMO_BATCH_PROGRESSION_REC IN GMO_BATCH_PROGRESSION_CUR
462: LOOP
463: edr_psig.getdocumentdetails(GMO_BATCH_PROGRESSION_REC.ERECORD_ID,l_document,l_docparams,l_signatures,l_error,l_error_msg);
464: IF l_document.PSIG_STATUS = 'ERROR' THEN
465: DELETE FROM GMO_BATCH_PROGRESSION WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
466: ELSIF l_document.PSIG_STATUS in ('COMPLETE','REJECTED','TIMEDOUT') then
467: UPDATE GMO_BATCH_PROGRESSION

Line 1286: EDR_PSIG.GET_EVENT_XML(P_EVENT_NAME =>null,

1282: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP
1283: l_eleNode := dbms_xmldom.item(l_eleNodeList, i);
1284: -- import Erec Header node and signature node
1285: l_erecID := TO_NUMBER(DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_eleNode)));
1286: EDR_PSIG.GET_EVENT_XML(P_EVENT_NAME =>null,
1287: P_EVENT_KEY => null,
1288: P_ERECORD_ID => l_erecID,
1289: P_GET_ERECORD_XML =>'F',
1290: P_GET_PSIG_DETAILS =>'T',