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.

[Home] [Help]

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_requester VARCHAR2(4000) ;
775: l_user varchar2(100);
776: l_userlist WF_DIRECTORY.UserTable;

Line 788: SELECT ORIGINAL_RECIPIENT from EDR_ESIGNATURES where

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

Line 792: SELECT ORIGINAL_RECIPIENT, USER_NAME from EDR_ESIGNATURES where

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

Line 830: FROM EDR_ESIGNATURES

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

Line 935: from EDR_ESIGNATURES

931:
932: --Bug 4272262: Start
933: --Convert signature sequence to a number value.
934: SELECT MIN(to_number(SIGNATURE_SEQUENCE,'999999999999.999999')) INTO L_CURR_SIGN_LEVEL
935: from EDR_ESIGNATURES
936: WHERE EVENT_ID =lp_itemkey
937: AND SIGNATURE_STATUS = 'PENDING' ;
938: --Bug 4272262: End
939:

Line 995: FROM EDR_ESIGNATURES

991: -- Bug 3170251 : End
992:
993: --Bug 2674799 : Start
994: /* SELECT count(*) INTO l_count
995: FROM EDR_ESIGNATURES
996: WHERE EVENT_ID = l_item_key
997: AND SIGNATURE_STATUS = 'REJECTED';
998:
999: IF l_count > 0 then

Line 1296: UPDATE EDR_ESIGNATURES

1292: l_ignore_wfattr_notfound);
1293: --Bug 4577122: End
1294:
1295: IF p_funcmode = 'RUN' THEN
1296: UPDATE EDR_ESIGNATURES
1297: SET SIGNATURE_STATUS = 'APPROVED' ,
1298: SIGNATURE_TYPE = l_SIGNER_TYPE,
1299: SIGNATURE_REASON_CODE = l_signer_reason,
1300: SIGNATURE_TIMESTAMP = SYSDATE,

Line 1307: from EDR_ESIGNATURES

1303:
1304: /* Verify all are Approved */
1305:
1306: SELECT count(*) INTO l_count
1307: from EDR_ESIGNATURES
1308: WHERE EVENT_ID = l_event_id
1309: AND SIGNATURE_STATUS <> 'APPROVED' ;
1310:
1311: --Bug 4577122: Start

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

1321: WHERE EVENT_ID = l_event_id;
1322:
1323:
1324: --Bug 4577122: Start
1325: --clear out the status etc fields of rest of the edr_esignatures
1326: if (l_voting_regime = ame_util.firstApproverVoting) then
1327: update edr_esignatures
1328: set signature_status = null
1329: where event_id = l_event_id

Line 1327: update edr_esignatures

1323:
1324: --Bug 4577122: Start
1325: --clear out the status etc fields of rest of the edr_esignatures
1326: if (l_voting_regime = ame_util.firstApproverVoting) then
1327: update edr_esignatures
1328: set signature_status = null
1329: where event_id = l_event_id
1330: and signature_status = 'PENDING';
1331: end if;

Line 1400: UPDATE EDR_ESIGNATURES

1396:
1397: /* Skarimis */
1398:
1399: /* Change following code to derieve Timezone info */
1400: UPDATE EDR_ESIGNATURES
1401: SET SIGNATURE_STATUS = 'REJECTED' ,
1402: SIGNATURE_TYPE = l_SIGNER_TYPE,
1403: SIGNATURE_REASON_CODE = l_signer_reason,
1404: SIGNATURE_TIMESTAMP = SYSDATE,

Line 1473: FROM EDR_ESIGNATURES

1469: L_CURR_SIGN_LEVEL NUMBER ;
1470: CURSOR CURR_LIST_SIGNERS IS
1471: /*Changed the Cursor to get ORIGNIAL RECIPIENT instead of USER_NAME SKARIMIS */
1472: SELECT event_name, SIGNATURE_ID,NVL(ORIGINAL_RECIPIENT,USER_NAME) USER_NAME
1473: FROM EDR_ESIGNATURES
1474: WHERE EVENT_ID = p_itemkey
1475: --Bug 4272262: Start
1476: --Convert signature sequence to a number value.
1477: AND to_number(SIGNATURE_SEQUENCE,'999999999999.999999') = L_CURR_SIGN_LEVEL

Line 1504: from EDR_ESIGNATURES

1500: if p_funcmode='RUN' then
1501:
1502: --Bug 4272262: Start
1503: SELECT MIN( to_number(SIGNATURE_SEQUENCE,'999999999999.999999')) INTO L_CURR_SIGN_LEVEL
1504: from EDR_ESIGNATURES
1505: WHERE EVENT_ID = p_itemkey
1506: AND SIGNATURE_STATUS = 'PENDING' ;
1507: --Bug 4272262: End
1508:

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

1894: l_message VARCHAR2(2000);
1895:
1896: /* This Cursor is to build the temporary group for sending timeout notification */
1897: CURSOR GET_USER is
1898: SELECT distinct USER_NAME from EDR_ESIGNATURES where to_char(event_id)=l_item_key;
1899:
1900: l_requester VARCHAR2(4000);
1901: l_user varchar2(100);
1902: l_userlist WF_DIRECTORY.UserTable;

Line 1959: UPDATE EDR_ESIGNATURES

1955:
1956: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,
1957: 'ESIG_GROUP' ,
1958: 'EDRPSIG_ROLE');
1959: UPDATE EDR_ESIGNATURES
1960: SET SIGNATURE_STATUS = 'TIMEDOUT'
1961: WHERE SIGNATURE_ID = l_ESIGN_ID;
1962: p_resultout := 'COMPLETE:Y';
1963: ELSE