DBA Data[Home] [Help]

APPS.HR_APPROVAL_SS dependencies on AME_API2

Line 1904: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);

1900: aname => 'TRANSACTION_ID');
1901: if(c_transaction_type is not null) then
1902: begin
1903: if g_debug then
1904: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
1905: hr_utility.set_location('c_application_id:'||c_application_id,5);
1906: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
1907: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
1908: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);

Line 1910: ame_api2.getNextApprovers4

1906: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
1907: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
1908: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
1909: end if;
1910: ame_api2.getNextApprovers4
1911: (applicationIdIn => c_application_id
1912: ,transactionTypeIn => c_transaction_type
1913: ,transactionIdIn => c_transaction_id
1914: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

Line 1919: hr_utility.set_location('returned from ame_api2.getNextApprovers4, number records fetched:'||c_next_approvers.count,9);

1915: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
1916: ,nextApproversOut => c_next_approvers);
1917:
1918: if g_debug then
1919: hr_utility.set_location('returned from ame_api2.getNextApprovers4, number records fetched:'||c_next_approvers.count,9);
1920: end if;
1921:
1922: -- Parallel Approvers case
1923: if(c_next_approvers.COUNT >1 ) then

Line 2281: ame_api2.getNextApprovers4

2277: end if;
2278:
2279: l_current_forward_to_username := original_forward_to_user;
2280:
2281: ame_api2.getNextApprovers4
2282: (applicationIdIn => c_application_id
2283: ,transactionTypeIn => c_transaction_type
2284: ,transactionIdIn => c_transaction_id
2285: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

Line 2316: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);

2312: itemkey => p_item_key,
2313: aname => 'RETURN_TO_USERNAME'));
2314:
2315: if g_debug then
2316: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
2317: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
2318: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
2319: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2320: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);

Line 2374: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);

2370: return;
2371: end;
2372:
2373: if g_debug then
2374: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);
2375: end if;
2376:
2377: --result := wf_engine.eng_trans_default;
2378: result := 'COMPLETE:'||'SUCCESS';

Line 2510: ame_api2.getNextApprovers4

2506: ignore_notfound=>true);
2507: if(l_is_parallel = 'PARALLEL') then
2508:
2509: --------------
2510: ame_api2.getNextApprovers4
2511: (applicationIdIn => c_application_id
2512: ,transactionTypeIn => c_transaction_type
2513: ,transactionIdIn => c_transaction_id
2514: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

Line 2525: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

2521:
2522: if c_next_approvers.count > 0 then
2523: for l_index in 1 .. c_next_approvers.count
2524: loop
2525: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2526: transactionTypeIn =>c_transaction_type,
2527: transactionIdIn=>c_transaction_id,
2528: approvalStatusIn =>ame_util.notifiedStatus,
2529: approverNameIn =>c_next_approvers(l_index).name,

Line 2567: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);

2563: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR');
2564: if(l_curr_fwd_to_orig_system_id is not null) then
2565:
2566: if g_debug then
2567: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2568: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2569: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2570: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);

Line 2575: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);
2572: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2573: end if;
2574:
2575: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2576: transactionTypeIn =>c_transaction_type,
2577: transactionIdIn=>c_transaction_id,
2578: approvalStatusIn =>ame_util.notifiedStatus,
2579: approverNameIn =>l_current_forward_to_username,

Line 2673: ame_api2.getNextApprovers4

2669:
2670:
2671: if(l_is_parallel = 'PARALLEL') then
2672:
2673: ame_api2.getNextApprovers4
2674: (applicationIdIn => c_application_id
2675: ,transactionTypeIn => c_transaction_type
2676: ,transactionIdIn => c_transaction_id
2677: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

Line 2682: hr_utility.set_location('returned from ame_api2.getNextApprovers4, number records fetched:'||c_next_approvers.count,9);

2678: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
2679: ,nextApproversOut => c_next_approvers);
2680:
2681: if g_debug then
2682: hr_utility.set_location('returned from ame_api2.getNextApprovers4, number records fetched:'||c_next_approvers.count,9);
2683: end if;
2684:
2685: if(c_next_approvers.COUNT >1 ) then
2686:

Line 2696: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

2692: hr_utility.set_location('Approver Orig system : ' || c_next_approvers(l_index).orig_system,115);
2693:
2694: if(c_next_approvers(l_index).orig_system = 'PQH_ROLE' OR c_next_approvers(l_index).orig_system = 'POS') then
2695: for c in c_get_users_from_role(c_next_approvers(l_index).name) loop
2696: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2697: transactionTypeIn =>c_transaction_type,
2698: transactionIdIn=>c_transaction_id,
2699: approvalStatusIn =>ame_util.noResponseStatus,
2700: approverNameIn =>c.user_name,

Line 2711: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

2707: updateItemIn =>false);
2708: end loop;
2709: else
2710:
2711: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2712: transactionTypeIn =>c_transaction_type,
2713: transactionIdIn=>c_transaction_id,
2714: approvalStatusIn =>ame_util.noResponseStatus,
2715: approverNameIn =>c_next_approvers(l_index).name,

Line 2736: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);

2732: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
2733: ,itemkey => p_item_key
2734: ,aname => 'FORWARD_TO_USERNAME');
2735: if g_debug then
2736: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2737: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2738: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2739: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);

Line 2744: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);
2741: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2742: end if;
2743:
2744: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2745: transactionTypeIn =>c_transaction_type,
2746: transactionIdIn=>c_transaction_id,
2747: approvalStatusIn =>ame_util.noResponseStatus,
2748: approverNameIn =>l_current_forward_to_username,

Line 3216: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);

3212: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => p_item_type ,
3213: itemkey => p_item_key,
3214: aname => 'RETURN_TO_USERNAME'));
3215: if g_debug then
3216: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
3217: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
3218: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
3219: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
3220: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);

Line 3240: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

3236: hr_utility.set_location('new approver person id:'|| l_new_fwd_person_id, 7);
3237:
3238:
3239:
3240: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
3241: transactionTypeIn =>c_transaction_type,
3242: transactionIdIn=>c_transaction_id,
3243: approvalStatusIn =>ame_util.forwardStatus,
3244: approverNameIn =>l_current_forward_to_username,

Line 3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);

3257: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3258: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USER',getToString(p_item_key) || wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3259:
3260: if g_debug then
3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
3262: hr_utility.set_location('c_application_id:'||c_application_id,5);
3263: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
3264: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
3265: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);

Line 3268: ame_api2.getNextApprovers4

3264: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
3265: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
3266: end if;
3267:
3268: ame_api2.getNextApprovers4
3269: (applicationIdIn => c_application_id
3270: ,transactionTypeIn => c_transaction_type
3271: ,transactionIdIn => c_transaction_id
3272: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

Line 3288: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);

3284: return;
3285: end ;
3286:
3287: if g_debug then
3288: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);
3289: end if;
3290:
3291:
3292:

Line 3492: hr_utility.set_location('calling ame_api2.getAllApprovers7', 2);

3488: aname => 'NOTE_FROM_APPR');
3489:
3490: if(c_transaction_type is not null) then
3491: if g_debug then
3492: hr_utility.set_location('calling ame_api2.getAllApprovers7', 2);
3493: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3494: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3495: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3496: end if;

Line 3498: ame_api2.getAllApprovers7(applicationIdIn =>c_application_id,

3494: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3495: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3496: end if;
3497:
3498: ame_api2.getAllApprovers7(applicationIdIn =>c_application_id,
3499: transactionTypeIn =>c_transaction_type,
3500: transactionIdIn => c_transaction_id,
3501: approvalProcessCompleteYNOut =>c_approvalprocesscompleteynout,
3502: approversOut =>c_all_approvers);

Line 3556: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);

3552: hr_utility.set_location('c_match_found :' || c_match_found,111);
3553:
3554: IF (c_rfc_initiator = 'Y' OR (c_rfc_initiator = 'N' AND c_match_found = 'Y' ) ) THEN
3555:
3556: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
3557: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3558: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3559: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3560: hr_utility.set_location('approvalStatusIn:'|| null, 6);

Line 3582: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

3578: forwardeeIn =>ame_util.emptyApproverRecord2,
3579: updateItemIn =>false);
3580: ELSE
3581:
3582: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
3583: transactionTypeIn =>c_transaction_type,
3584: transactionIdIn=>c_transaction_id,
3585: approvalStatusIn =>null,
3586: approverNameIn =>c_all_approvers(i).name,

Line 5912: ame_api2.getadminapprover(applicationidin => c_application_id

5908: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
5909: itemkey => p_item_key,
5910: aname => 'HR_AME_TRAN_TYPE_ATTR');
5911:
5912: ame_api2.getadminapprover(applicationidin => c_application_id
5913: ,transactiontypein => c_transaction_type
5914: ,adminapproverout => c_approver_to_notify_rec);
5915:
5916: l_aprv_routing_username := c_approver_to_notify_rec.name;

Line 6092: ame_api2.getNextApprovers4

6088:
6089: l_current_forward_to_username := original_forward_to_user;
6090: l_current_forward_to_username1 := original_forward_to_user;
6091:
6092: ame_api2.getNextApprovers4
6093: (applicationIdIn => c_application_id
6094: ,transactionTypeIn => c_transaction_type
6095: ,transactionIdIn => c_transaction_id
6096: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

Line 6160: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);

6156: end ;
6157:
6158:
6159: if g_debug then
6160: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);
6161: end if;
6162:
6163: if(l_is_parallel = 'PARALLEL') then
6164: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(l_current_forward_to_username1));