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.PV_AME_API_W dependencies on PV_GE_TEMP_APPROVERS

Line 60: FROM PV_GE_TEMP_APPROVERS

56: SELECT source_name FROM jtf_rs_resource_extns WHERE user_id = pc_user_id;
57:
58: CURSOR lc_prior_approvers IS
59: SELECT APPROVER_ID
60: FROM PV_GE_TEMP_APPROVERS
61: WHERE ARC_APPR_FOR_ENTITY_CODE = p_approval_entity
62: AND APPR_FOR_ENTITY_ID = p_referral_id;
63:
64: cursor lc_lock_approvals is

Line 66: FROM pv_ge_temp_approvers

62: AND APPR_FOR_ENTITY_ID = p_referral_id;
63:
64: cursor lc_lock_approvals is
65: SELECT entity_approver_id
66: FROM pv_ge_temp_approvers
67: WHERE arc_appr_for_entity_code = p_approval_entity
68: AND appr_for_entity_id = p_referral_id
69: FOR UPDATE NOWAIT;
70:

Line 129: -- pv_ge_temp_approvers.

125: END IF;
126:
127: -- This is to make sure that no other thread of execution
128: -- can try to update the rows for this referrral in
129: -- pv_ge_temp_approvers.
130: -- Bug 4628929
131: OPEN lc_lock_approvals;
132:
133: OPEN lc_referral_info(p_referral_id);

Line 197: UPDATE pv_ge_temp_approvers

193: AME_API2.clearAllApprovals(applicationIdIn => 691,
194: transactionTypeIn => p_approval_entity,
195: transactionIdIn => p_referral_id);
196:
197: UPDATE pv_ge_temp_approvers
198: SET approval_status_code = 'PRIOR_APPROVER'
199: WHERE arc_appr_for_entity_code = p_approval_entity
200: AND appr_for_entity_id = p_referral_id;
201:

Line 231: * This loop makes sure that if an approver from AME already exists in pv_ge_temp_approvers

227: END IF;
228:
229:
230: /**
231: * This loop makes sure that if an approver from AME already exists in pv_ge_temp_approvers
232: * then that approver must be removed from pv_ge_temp_approvers so that he/she is not added
233: * again into the table.
234: */
235: FOR l_prior_appr IN lc_prior_approvers

Line 232: * then that approver must be removed from pv_ge_temp_approvers so that he/she is not added

228:
229:
230: /**
231: * This loop makes sure that if an approver from AME already exists in pv_ge_temp_approvers
232: * then that approver must be removed from pv_ge_temp_approvers so that he/she is not added
233: * again into the table.
234: */
235: FOR l_prior_appr IN lc_prior_approvers
236: LOOP

Line 240: DELETE FROM pv_ge_temp_approvers

236: LOOP
237: FOR x IN 1..approverUserIds.COUNT
238: LOOP
239: IF ( approverUserIds(x) = l_prior_appr.APPROVER_ID) THEN
240: DELETE FROM pv_ge_temp_approvers
241: WHERE arc_appr_for_entity_code = p_approval_entity
242: AND appr_for_entity_id = p_referral_id
243: AND approver_id = approverUserIds(x);
244: END IF;

Line 263: INSERT INTO pv_ge_temp_approvers

259: END IF;
260:
261: BEGIN
262: FORALL i IN 1..approverUserIds.COUNT
263: INSERT INTO pv_ge_temp_approvers
264: (
265: ENTITY_APPROVER_ID
266: ,OBJECT_VERSION_NUMBER
267: ,ARC_APPR_FOR_ENTITY_CODE

Line 281: pv_ge_temp_approvers_s.NEXTVAL

277: ,LAST_UPDATE_LOGIN
278: )
279: VALUES
280: (
281: pv_ge_temp_approvers_s.NEXTVAL
282: ,1
283: ,p_approval_entity
284: ,p_referral_id
285: ,approverUserIds(i)

Line 308: ,'Sucessfully inserted users into pv_ge_temp_approvers...'

304:
305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
307: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
308: ,'Sucessfully inserted users into pv_ge_temp_approvers...'
309: );
310: END IF;
311:
312: IF p_change_cntry_flag = 'Y' THEN

Line 497: select approval_status_code from pv_ge_temp_approvers

493: l_resp_count NUMBER;
494: l_curr_appr_level NUMBER;
495:
496: cursor lc_is_default_approver (pc_user_id number, pc_benefit_type varchar2, pc_entity_id number) is
497: select approval_status_code from pv_ge_temp_approvers
498: where arc_appr_for_entity_code = pc_benefit_type
499: and appr_for_entity_id = pc_entity_id
500: and approver_type_code = 'USER'
501: and approver_id = pc_user_id

Line 532: from pv_ge_temp_approvers

528: where rownum = 1;
529:
530: cursor lc_first_level_apporver is
531: select count(entity_approver_id)
532: from pv_ge_temp_approvers
533: where arc_appr_for_entity_code = p_approval_entity
534: and appr_for_entity_id = p_referral_id
535: and approval_status_code in ('APPROVED','REJECTED');
536:

Line 539: FROM pv_ge_temp_approvers

535: and approval_status_code in ('APPROVED','REJECTED');
536:
537: cursor lc_lock_approvals is
538: SELECT entity_approver_id
539: FROM pv_ge_temp_approvers
540: WHERE arc_appr_for_entity_code = p_approval_entity
541: AND appr_for_entity_id = p_referral_id
542: FOR UPDATE NOWAIT;
543:

Line 546: FROM PV_GE_TEMP_APPROVERS

542: FOR UPDATE NOWAIT;
543:
544: CURSOR lc_prior_approvers IS
545: SELECT APPROVER_ID
546: FROM PV_GE_TEMP_APPROVERS
547: WHERE ARC_APPR_FOR_ENTITY_CODE = p_approval_entity
548: AND APPR_FOR_ENTITY_ID = p_referral_id;
549:
550:

Line 582: -- pv_ge_temp_approvers.

578: -- ********* End Standard Initializations *********
579:
580: -- This is to make sure that no other thread of execution
581: -- can try to update the rows for this referrral in
582: -- pv_ge_temp_approvers.
583: -- Bug 4628929
584: OPEN lc_lock_approvals;
585:
586: x_approval_done := 'N';

Line 872: -- Update pv_ge_temp_approvers to set the values of approval status to

868: END IF;
869:
870: END IF; -- If current user is in AME system.
871:
872: -- Update pv_ge_temp_approvers to set the values of approval status to
873: -- APPROVED/REJECTED/FORWARDED depending on the case for the approver id who
874: -- took the action.
875: UPDATE pv_ge_temp_approvers
876: SET approval_status_code = l_approval_status

Line 875: UPDATE pv_ge_temp_approvers

871:
872: -- Update pv_ge_temp_approvers to set the values of approval status to
873: -- APPROVED/REJECTED/FORWARDED depending on the case for the approver id who
874: -- took the action.
875: UPDATE pv_ge_temp_approvers
876: SET approval_status_code = l_approval_status
877: WHERE arc_appr_for_entity_code = p_approval_entity
878: AND appr_for_entity_id = p_referral_id
879: AND approver_id = p_approver_user_id

Line 905: UPDATE pv_ge_temp_approvers

901: * all others will be marked as PEER_RESPONDED
902: */
903: IF l_approver_current_status = 'PENDING_APPROVAL' THEN
904:
905: UPDATE pv_ge_temp_approvers
906: SET approval_status_code = 'PEER_RESPONDED'
907: WHERE arc_appr_for_entity_code = p_approval_entity
908: AND appr_for_entity_id = p_referral_id
909: AND approval_status_code IN ('PENDING_APPROVAL');

Line 1003: UPDATE pv_ge_temp_approvers

999: , p_mode => 'CHECK_PENDING_APPROVERS'
1000: , p_approval_level => l_curr_appr_level
1001: , x_approver => l_approver) AND l_approverInList)
1002: THEN
1003: UPDATE pv_ge_temp_approvers
1004: SET approval_status_code = 'PEER_RESPONDED'
1005: WHERE arc_appr_for_entity_code = p_approval_entity
1006: AND appr_for_entity_id = p_referral_id
1007: AND approval_status_code = 'PENDING_APPROVAL';

Line 1037: ,'Inserting users into pv_ge_temp_approvers...'

1033: THEN
1034: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1036: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1037: ,'Inserting users into pv_ge_temp_approvers...'
1038: );
1039: END IF;
1040:
1041: BEGIN

Line 1045: INSERT INTO pv_ge_temp_approvers(

1041: BEGIN
1042: FORALL i IN 1..l_approval_list.COUNT
1043:
1044:
1045: INSERT INTO pv_ge_temp_approvers(
1046: ENTITY_APPROVER_ID
1047: ,OBJECT_VERSION_NUMBER
1048: ,ARC_APPR_FOR_ENTITY_CODE
1049: ,APPR_FOR_ENTITY_ID

Line 1060: pv_ge_temp_approvers_s.NEXTVAL

1056: ,LAST_UPDATED_BY
1057: ,LAST_UPDATE_DATE
1058: ,LAST_UPDATE_LOGIN
1059: )VALUES(
1060: pv_ge_temp_approvers_s.NEXTVAL
1061: ,1
1062: ,p_approval_entity
1063: ,p_referral_id
1064: ,l_approval_list(i)

Line 1258: * the current set of approvers in pv_ge_temp_approvers. (Consensus case)

1254: * validations.
1255: * - CHECK_CURRENT_APPROVER: Validate if the current logged in user is a
1256: * a valid approver in AME.
1257: * - CHECK_PENDING_APPROVERS: Check if AME is waiting for response from any of
1258: * the current set of approvers in pv_ge_temp_approvers. (Consensus case)
1259: */
1260: FUNCTION VALIDATE_APPROVAL (p_transaction_id IN NUMBER
1261: , p_transaction_type IN VARCHAR2
1262: , p_user_id IN NUMBER

Line 1271: FROM fnd_user A , pv_ge_temp_approvers appr

1267: RETURN BOOLEAN IS
1268:
1269: CURSOR c_user(pc_person_id NUMBER) IS
1270: SELECT 'Y'
1271: FROM fnd_user A , pv_ge_temp_approvers appr
1272: WHERE A.employee_id = pc_person_id
1273: AND ( A.end_date IS NULL OR A.end_date > sysdate-1)
1274: AND A.user_id = appr.approver_id
1275: AND appr.approval_status_code = 'PENDING_APPROVAL'

Line 1496: * before saving to PV_GE_TEMP_APPROVERS. All of the queries in this

1492: * Persons, Users , Workflow Roles
1493: *
1494: * Persons are always internal users so Refereals can support all PER.
1495: * However Referral/Deal module convers all person_id to user_id
1496: * before saving to PV_GE_TEMP_APPROVERS. All of the queries in this
1497: * module is centered around the assumption that approver column will always
1498: * have a USER_ID. Also in order to approve referrals and deals the user
1499: * has to login to the system and approve. It is not possible to do it
1500: * from an email or any other way without logging into the system. So

Line 1631: FROM PV_GE_TEMP_APPROVERS

1627: , p_approval_list IN JTF_NUMBER_TABLE)
1628: IS
1629: CURSOR lc_prior_approvers IS
1630: SELECT APPROVER_ID
1631: FROM PV_GE_TEMP_APPROVERS
1632: WHERE ARC_APPR_FOR_ENTITY_CODE = p_approval_entity
1633: AND APPR_FOR_ENTITY_ID = p_referral_id;
1634:
1635: BEGIN

Line 1648: DELETE FROM pv_ge_temp_approvers

1644: LOOP
1645: FOR x IN 1..p_approval_list.COUNT
1646: LOOP
1647: IF ( p_approval_list(x) = l_prior_appr.APPROVER_ID) THEN
1648: DELETE FROM pv_ge_temp_approvers
1649: WHERE arc_appr_for_entity_code = p_approval_entity
1650: AND appr_for_entity_id = p_referral_id
1651: AND approver_id = p_approval_list(x)
1652: AND approval_status_code IN ('PRIOR_APPROVER');