eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_PSIG_PAGE_FLOW dependencies on EDR_ESIGNATURES

Line 211: from EDR_ESIGNATURES

207:
208: BEGIN
209:
210: SELECT count(*) INTO l_count
211: from EDR_ESIGNATURES
212: WHERE EVENT_ID = P_event_id
213: AND SIGNATURE_STATUS <> 'APPROVED';
214:
215: IF l_count = 0 THEN -- All Are Approved

Line 219: from EDR_ESIGNATURES

215: IF l_count = 0 THEN -- All Are Approved
216: P_SIGNATURE_STATUS := 'SUCCESS';
217: ELSE -- Not All are Approved
218: SELECT count(*) INTO l_count
219: from EDR_ESIGNATURES
220: WHERE EVENT_ID = p_event_id
221: AND SIGNATURE_STATUS = 'REJECTED';
222: IF l_count > 0 THEN
223: /* Means Some one is rejected */

Line 227: from EDR_ESIGNATURES

223: /* Means Some one is rejected */
224: P_SIGNATURE_STATUS := 'REJECTED';
225: ELSE
226: SELECT count(*) INTO l_count
227: from EDR_ESIGNATURES
228: WHERE EVENT_ID = p_event_id
229: AND SIGNATURE_STATUS = 'TIMEDOUT';
230: IF l_count > 0 THEN
231: /* Means Timeout SKARIMIS*/

Line 258: from edr_esignatures

254: --Change related to bug 4577122
255: if (p_voting_regime = ame_util.firstApproverVoting) then
256:
257: select count(*) into l_approver_count
258: from edr_esignatures
259: where event_id = p_event_id
260: and signature_status = 'APPROVED';
261:
262: if (l_approver_count > 0) then

Line 270: from EDR_ESIGNATURES

266: end if;
267: --Change related to bug 4577122
268:
269: SELECT count(*) INTO l_count
270: from EDR_ESIGNATURES
271: WHERE EVENT_ID = P_event_id
272: AND SIGNATURE_STATUS <> 'APPROVED';
273:
274: IF l_count = 0 THEN -- All Are Approved

Line 278: from EDR_ESIGNATURES

274: IF l_count = 0 THEN -- All Are Approved
275: P_SIGNATURE_STATUS := 'SUCCESS';
276: ELSE -- Not All are Approved
277: SELECT count(*) INTO l_count
278: from EDR_ESIGNATURES
279: WHERE EVENT_ID = p_event_id
280: AND SIGNATURE_STATUS = 'REJECTED';
281:
282: IF l_count > 0 THEN

Line 287: from EDR_ESIGNATURES

283: /* Means Some one is rejected */
284: P_SIGNATURE_STATUS := 'REJECTED';
285: ELSE
286: SELECT count(*) INTO l_count
287: from EDR_ESIGNATURES
288: WHERE EVENT_ID = p_event_id
289: AND SIGNATURE_STATUS = 'TIMEDOUT';
290: IF l_count > 0 THEN
291: /* Means Timeout SKARIMIS*/

Line 616: UPDATE EDR_ESIGNATURES

612: and ORIGINAL_RECIPIENT = l_username;
613:
614: --update the edr_esignature tables for correct ntf history rgn
615: --information
616: UPDATE EDR_ESIGNATURES
617: SET USER_NAME = nvl(l_overriding_approver,l_username) ,
618: SIGNATURE_OVERRIDING_COMMENTS = l_overriding_comments
619: where event_id = l_event_id
620: and ORIGINAL_RECIPIENT = l_username;

Line 772: SELECT distinct USER_NAME from EDR_ESIGNATURES where to_char(event_id)=l_item_key;

768: GET_RESPONSE_ATTR_REC GET_RESPONSE_ATTR%ROWTYPE;
769:
770: /* This Cursor is to build the temporary group for sending rejection notification */
771: CURSOR GET_USER is
772: SELECT distinct USER_NAME from EDR_ESIGNATURES where to_char(event_id)=l_item_key;
773:
774: l_userlist VARCHAR2(4000) ;
775: l_requester VARCHAR2(4000) ;
776: l_user varchar2(32);

Line 787: SELECT ORIGINAL_RECIPIENT from EDR_ESIGNATURES where

783: --Bug 3214398: start
784: /*Get User_Name alongwith original recipient*/
785: /*
786: CURSOR original_recipient is
787: SELECT ORIGINAL_RECIPIENT from EDR_ESIGNATURES where
788: signature_id=l_esign_id;
789: */
790: CURSOR signer_detail is
791: SELECT ORIGINAL_RECIPIENT, USER_NAME from EDR_ESIGNATURES where

Line 791: SELECT ORIGINAL_RECIPIENT, USER_NAME from EDR_ESIGNATURES where

787: SELECT ORIGINAL_RECIPIENT from EDR_ESIGNATURES where
788: signature_id=l_esign_id;
789: */
790: CURSOR signer_detail is
791: SELECT ORIGINAL_RECIPIENT, USER_NAME from EDR_ESIGNATURES where
792: signature_id = l_esign_id;
793: l_user_name varchar2(200);
794: l_overriding_approver varchar2(200);
795: l_overriding_comments varchar2(4000);

Line 829: FROM EDR_ESIGNATURES

825:
826:
827: CURSOR CURR_LIST_SIGNERS IS
828: SELECT event_name, SIGNATURE_ID,NVL(ORIGINAL_RECIPIENT,USER_NAME) USER_NAME
829: FROM EDR_ESIGNATURES
830: WHERE EVENT_ID = lp_itemkey
831: --Bug 4272262: Start
832: --Convert signature sequence to a number value.
833: AND to_number(SIGNATURE_SEQUENCE,'999999999999.999999') = L_CURR_SIGN_LEVEL

Line 922: from EDR_ESIGNATURES

918:
919: --Bug 4272262: Start
920: --Convert signature sequence to a number value.
921: SELECT MIN(to_number(SIGNATURE_SEQUENCE,'999999999999.999999')) INTO L_CURR_SIGN_LEVEL
922: from EDR_ESIGNATURES
923: WHERE EVENT_ID =lp_itemkey
924: AND SIGNATURE_STATUS = 'PENDING' ;
925: --Bug 4272262: End
926:

Line 974: FROM EDR_ESIGNATURES

970: -- Bug 3170251 : End
971:
972: --Bug 2674799 : Start
973: /* SELECT count(*) INTO l_count
974: FROM EDR_ESIGNATURES
975: WHERE EVENT_ID = l_item_key
976: AND SIGNATURE_STATUS = 'REJECTED';
977:
978: IF l_count > 0 then

Line 1274: UPDATE EDR_ESIGNATURES

1270: l_ignore_wfattr_notfound);
1271: --Bug 4577122: End
1272:
1273: IF p_funcmode = 'RUN' THEN
1274: UPDATE EDR_ESIGNATURES
1275: SET SIGNATURE_STATUS = 'APPROVED' ,
1276: SIGNATURE_TYPE = l_SIGNER_TYPE,
1277: SIGNATURE_REASON_CODE = l_signer_reason,
1278: SIGNATURE_TIMESTAMP = SYSDATE,

Line 1285: from EDR_ESIGNATURES

1281:
1282: /* Verify all are Approved */
1283:
1284: SELECT count(*) INTO l_count
1285: from EDR_ESIGNATURES
1286: WHERE EVENT_ID = l_event_id
1287: AND SIGNATURE_STATUS <> 'APPROVED' ;
1288:
1289: --Bug 4577122: Start

Line 1303: --clear out the status etc fields of rest of the edr_esignatures

1299: WHERE EVENT_ID = l_event_id;
1300:
1301:
1302: --Bug 4577122: Start
1303: --clear out the status etc fields of rest of the edr_esignatures
1304: if (l_voting_regime = ame_util.firstApproverVoting) then
1305: update edr_esignatures
1306: set signature_status = null
1307: where event_id = l_event_id

Line 1305: update edr_esignatures

1301:
1302: --Bug 4577122: Start
1303: --clear out the status etc fields of rest of the edr_esignatures
1304: if (l_voting_regime = ame_util.firstApproverVoting) then
1305: update edr_esignatures
1306: set signature_status = null
1307: where event_id = l_event_id
1308: and signature_status = 'PENDING';
1309: end if;

Line 1378: UPDATE EDR_ESIGNATURES

1374:
1375: /* Skarimis */
1376:
1377: /* Change following code to derieve Timezone info */
1378: UPDATE EDR_ESIGNATURES
1379: SET SIGNATURE_STATUS = 'REJECTED' ,
1380: SIGNATURE_TYPE = l_SIGNER_TYPE,
1381: SIGNATURE_REASON_CODE = l_signer_reason,
1382: SIGNATURE_TIMESTAMP = SYSDATE,

Line 1451: FROM EDR_ESIGNATURES

1447: L_CURR_SIGN_LEVEL NUMBER ;
1448: CURSOR CURR_LIST_SIGNERS IS
1449: /*Changed the Cursor to get ORIGNIAL RECIPIENT instead of USER_NAME SKARIMIS */
1450: SELECT event_name, SIGNATURE_ID,NVL(ORIGINAL_RECIPIENT,USER_NAME) USER_NAME
1451: FROM EDR_ESIGNATURES
1452: WHERE EVENT_ID = p_itemkey
1453: --Bug 4272262: Start
1454: --Convert signature sequence to a number value.
1455: AND to_number(SIGNATURE_SEQUENCE,'999999999999.999999') = L_CURR_SIGN_LEVEL

Line 1482: from EDR_ESIGNATURES

1478: if p_funcmode='RUN' then
1479:
1480: --Bug 4272262: Start
1481: SELECT MIN( to_number(SIGNATURE_SEQUENCE,'999999999999.999999')) INTO L_CURR_SIGN_LEVEL
1482: from EDR_ESIGNATURES
1483: WHERE EVENT_ID = p_itemkey
1484: AND SIGNATURE_STATUS = 'PENDING' ;
1485: --Bug 4272262: End
1486:

Line 1875: SELECT distinct USER_NAME from EDR_ESIGNATURES where to_char(event_id)=l_item_key;

1871: l_message VARCHAR2(2000);
1872:
1873: /* This Cursor is to build the temporary group for sending timeout notification */
1874: CURSOR GET_USER is
1875: SELECT distinct USER_NAME from EDR_ESIGNATURES where to_char(event_id)=l_item_key;
1876:
1877: l_userlist VARCHAR2(4000);
1878: l_requester VARCHAR2(4000);
1879: l_user varchar2(32);

Line 1934: UPDATE EDR_ESIGNATURES

1930:
1931: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,
1932: 'ESIG_GROUP' ,
1933: 'EDRPSIG_ROLE');
1934: UPDATE EDR_ESIGNATURES
1935: SET SIGNATURE_STATUS = 'TIMEDOUT'
1936: WHERE SIGNATURE_ID = l_ESIGN_ID;
1937: p_resultout := 'COMPLETE:Y';
1938: ELSE