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 1316: /* if all signers are approved set the status of edr_erecords to presuccess.

1312: --IF l_count = 0 THEN
1313: IF (l_count = 0 or l_voting_regime = ame_util.firstApproverVoting) THEN
1314: --Bug 4577122: End
1315:
1316: /* if all signers are approved set the status of edr_erecords to presuccess.
1317: this will be used on list of signer screen to handle done button. */
1318:
1319: UPDATE EDR_ERECORDS
1320: SET ERECORD_SIGNATURE_STATUS = 'PRESUCCESS'

Line 1319: UPDATE EDR_ERECORDS

1315:
1316: /* if all signers are approved set the status of edr_erecords to presuccess.
1317: this will be used on list of signer screen to handle done button. */
1318:
1319: UPDATE EDR_ERECORDS
1320: SET ERECORD_SIGNATURE_STATUS = 'PRESUCCESS'
1321: WHERE EVENT_ID = l_event_id;
1322:
1323:

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

1404: SIGNATURE_TIMESTAMP = SYSDATE,
1405: SIGNER_COMMENTS = l_signer_comment
1406: WHERE SIGNATURE_ID = l_ESIGN_ID;
1407:
1408: /* set the status of edr_erecords to pre rejected. this will be used on list of signer screen.
1409: to handle done button. */
1410:
1411: UPDATE EDR_ERECORDS
1412: SET ERECORD_SIGNATURE_STATUS = 'PREREJECTED'

Line 1411: UPDATE EDR_ERECORDS

1407:
1408: /* set the status of edr_erecords to pre rejected. this will be used on list of signer screen.
1409: to handle done button. */
1410:
1411: UPDATE EDR_ERECORDS
1412: SET ERECORD_SIGNATURE_STATUS = 'PREREJECTED'
1413: WHERE EVENT_ID = l_event_id;
1414:
1415: -- p_resultout := 'COMPLETE:';

Line 1828: /* UPDATE EDR_ERECORDS

1824: --Bug 3903471 : End
1825:
1826: -- BUG 3271711 : End
1827:
1828: /* UPDATE EDR_ERECORDS
1829: SET EVENT_TIMEZONE = fnd_timezones.GET_SERVER_TIMEZONE_CODE
1830: Replaced the profile option to EDR_SERVER_ZONE
1831: SET EVENT_TIMEZONE = fnd_profile.VALUE('EDR_SERVER_TIMEZONE')
1832: WHERE event_id = p_itemkey;*/

Line 2013: from EDR_ERECORDS

2009: --Bug 4074173 : end
2010:
2011: --get the status of the signature process
2012: select ERECORD_SIGNATURE_STATUS into l_signature_status
2013: from EDR_ERECORDS
2014: WHERE EVENT_ID = l_event_id;
2015:
2016: if (l_signature_status = G_SUCCESS_STATUS and L_CURR_MODE='OFFLINE') then
2017: l_return_status := G_YES;