APPS.EDR_EINITIALS_PVT dependencies on EDR_PROCESS_ERECORDS_T

Line 106: SELECT COUNT(*) INTO X_ERECORD_COUNT FROM EDR_PROCESS_ERECORDS_T WHERE ERES_PROCESS_ID = P_PROCESS_ID;

102:
103: BEGIN
104:
105: --Fetch the number of e-records associated with the specified ERES process ID.
106: SELECT COUNT(*) INTO X_ERECORD_COUNT FROM EDR_PROCESS_ERECORDS_T WHERE ERES_PROCESS_ID = P_PROCESS_ID;
107:
108: --If more than one e-record is present, then an invalid process ID parameter has been used.
109: --Hence just return.
110: IF X_ERECORD_COUNT > 1 OR X_ERECORD_COUNT = 0 THEN

Line 118: SELECT STATUS INTO L_ERECORD_STATUS FROM EDR_PROCESS_ERECORDS_T WHERE ERES_PROCESS_ID = P_PROCESS_ID;

114: END IF;
115:
116:
117: --Obtain the status of the e-record.
118: SELECT STATUS INTO L_ERECORD_STATUS FROM EDR_PROCESS_ERECORDS_T WHERE ERES_PROCESS_ID = P_PROCESS_ID;
119:
120: --Set the ESIGN completed flag based on the e-record status.
121: IF L_ERECORD_STATUS IS NOT NULL THEN
122:

Line 134: FROM EDR_PROCESS_ERECORDS_T

130: END IF;
131:
132: --Fetch the workflow item type and item key values.
133: SELECT WF_ITEM_TYPE,WF_ITEM_KEY INTO X_ITEMTYPE,X_ITEMKEY
134: FROM EDR_PROCESS_ERECORDS_T
135: WHERE ERES_PROCESS_ID = P_PROCESS_ID;
136:
137: --Get the e-record details.
138: GET_ERECORD_DETAILS

Line 474: UPDATE EDR_PROCESS_ERECORDS_T

470: CLOSE FETCH_ERECORD_STATUS;
471:
472: --Update the ORES temp tables based on the flag.
473: IF P_UPDATE_ORES_TEMP_TABLES = FND_API.G_TRUE THEN
474: UPDATE EDR_PROCESS_ERECORDS_T
475: SET STATUS = X_ERECORD_STATUS
476: WHERE ERECORD_ID = L_ERECORD_ID;
477: END IF;
478:

Line 536: UPDATE EDR_PROCESS_ERECORDS_T

532: END IF;
533:
534:
535: IF P_UPDATE_ORES_TEMP_TABLES = FND_API.G_TRUE THEN
536: UPDATE EDR_PROCESS_ERECORDS_T
537: SET STATUS = EDR_CONSTANTS_GRP.G_ERROR_STATUS
538: WHERE ERECORD_ID = L_ERECORD_ID;
539:
540: UPDATE EDR_ERESMANAGER_T

Line 543: FROM EDR_PROCESS_ERECORDS_T

539:
540: UPDATE EDR_ERESMANAGER_T
541: SET OVERALL_STATUS = EDR_CONSTANTS_GRP.G_ERROR_STATUS
542: WHERE ERES_PROCESS_ID IN (SELECT ERES_PROCESS_ID
543: FROM EDR_PROCESS_ERECORDS_T
544: WHERE ERECORD_ID = L_ERECORD_ID);
545: END IF;
546:
547: COMMIT;