APPS.EDR_PSIG_PAGE_FLOW dependencies on EDR_ERECORDS

Line 185: FROM EDR_ERECORDS

181: L_event_name Varchar2(80);
182: L_event_disp_name VARCHAR2(240);
183: BEGIN
184: SELECT event_name into l_event_name
185: FROM EDR_ERECORDS
186: WHERE event_id = p_event_id;
187: select display_name into L_event_disp_name
188: from wf_events_vl
189: where name = l_event_name;

Line 360: UPDATE EDR_ERECORDS

356: IF (p_funcmode = 'RUN') THEN
357:
358: /* Update workflow STATUS to Cancel */
359:
360: UPDATE EDR_ERECORDS
361: SET ERECORD_SIGNATURE_STATUS = 'CANCEL'
362: WHERE EVENT_ID = P_itemkey;
363:
364: --Bug 3634954 : Start

Line 502: UPDATE EDR_ERECORDS

498: edr_psig.clear_pending_signatures(l_doc_id);
499: end if;
500: --Bug 4577122: End
501:
502: UPDATE EDR_ERECORDS
503: SET ERECORD_SIGNATURE_STATUS = L_SIGNATURE_STATUS
504: WHERE EVENT_ID = l_event_id;
505:
506:

Line 626: UPDATE EDR_ERECORDS

622: END LOOP;
623: -- Bug 4213923 : End
624:
625: IF L_DEFER_MODE_ALLOWED <> 'Y' THEN
626: UPDATE EDR_ERECORDS
627: SET ERECORD_SIGNATURE_STATUS = 'FAILURE'
628: WHERE EVENT_ID = p_itemkey;
629:
630: p_resultout := 'COMPLETE:PSIG_INCOMPLETE';

Line 645: UPDATE EDR_ERECORDS

641: ELSE
642: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_CURRENT_MODE','OFFLINE');
643: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_PAGEFLOW_STATUS','PENDING');
644:
645: UPDATE EDR_ERECORDS
646: SET ERECORD_SIGNATURE_STATUS = 'PENDING'
647: WHERE EVENT_ID = p_itemkey;
648:
649: IF l_doc_id IS NOT NULL THEN

Line 1294: /* if all signers are approved set the status of edr_erecords to presuccess.

1290: --IF l_count = 0 THEN
1291: IF (l_count = 0 or l_voting_regime = ame_util.firstApproverVoting) THEN
1292: --Bug 4577122: End
1293:
1294: /* if all signers are approved set the status of edr_erecords to presuccess.
1295: this will be used on list of signer screen to handle done button. */
1296:
1297: UPDATE EDR_ERECORDS
1298: SET ERECORD_SIGNATURE_STATUS = 'PRESUCCESS'

Line 1297: UPDATE EDR_ERECORDS

1293:
1294: /* if all signers are approved set the status of edr_erecords to presuccess.
1295: this will be used on list of signer screen to handle done button. */
1296:
1297: UPDATE EDR_ERECORDS
1298: SET ERECORD_SIGNATURE_STATUS = 'PRESUCCESS'
1299: WHERE EVENT_ID = l_event_id;
1300:
1301:

Line 1386: /* set the status of edr_erecords to pre rejected. this will be used on list of signer screen.

1382: SIGNATURE_TIMESTAMP = SYSDATE,
1383: SIGNER_COMMENTS = l_signer_comment
1384: WHERE SIGNATURE_ID = l_ESIGN_ID;
1385:
1386: /* set the status of edr_erecords to pre rejected. this will be used on list of signer screen.
1387: to handle done button. */
1388:
1389: UPDATE EDR_ERECORDS
1390: SET ERECORD_SIGNATURE_STATUS = 'PREREJECTED'

Line 1389: UPDATE EDR_ERECORDS

1385:
1386: /* set the status of edr_erecords to pre rejected. this will be used on list of signer screen.
1387: to handle done button. */
1388:
1389: UPDATE EDR_ERECORDS
1390: SET ERECORD_SIGNATURE_STATUS = 'PREREJECTED'
1391: WHERE EVENT_ID = l_event_id;
1392:
1393: -- p_resultout := 'COMPLETE:';

Line 1805: /* UPDATE EDR_ERECORDS

1801: --Bug 3903471 : End
1802:
1803: -- BUG 3271711 : End
1804:
1805: /* UPDATE EDR_ERECORDS
1806: SET EVENT_TIMEZONE = fnd_timezones.GET_SERVER_TIMEZONE_CODE
1807: Replaced the profile option to EDR_SERVER_ZONE
1808: SET EVENT_TIMEZONE = fnd_profile.VALUE('EDR_SERVER_TIMEZONE')
1809: WHERE event_id = p_itemkey;*/

Line 1988: from EDR_ERECORDS

1984: --Bug 4074173 : end
1985:
1986: --get the status of the signature process
1987: select ERECORD_SIGNATURE_STATUS into l_signature_status
1988: from EDR_ERECORDS
1989: WHERE EVENT_ID = l_event_id;
1990:
1991: if (l_signature_status = G_SUCCESS_STATUS and L_CURR_MODE='OFFLINE') then
1992: l_return_status := G_YES;