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.HR_APPROVAL_SS dependencies on AME_UTIL

Line 194: c_next_approvers ame_util.approverstable2;

190: -- Variables required for AME API
191: c_application_id integer;
192: c_transaction_id varchar2(25);
193: c_transaction_type varchar2(25);
194: c_next_approvers ame_util.approverstable2;
195: c_approvalprocesscompleteynout ame_util.charType;
196: l_current_forward_to_username wf_users.name%type;
197: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
198: lv_result_display varchar2(250);

Line 195: c_approvalprocesscompleteynout ame_util.charType;

191: c_application_id integer;
192: c_transaction_id varchar2(25);
193: c_transaction_type varchar2(25);
194: c_next_approvers ame_util.approverstable2;
195: c_approvalprocesscompleteynout ame_util.charType;
196: l_current_forward_to_username wf_users.name%type;
197: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
198: lv_result_display varchar2(250);
199: lv_test_result_code varchar2(250);

Line 713: p_approver_rec out nocopy ame_util.approverRecord2)

709:
710: procedure getNextCustomApprover(p_item_type in varchar2,
711: p_item_key in varchar2,
712: p_approvalprocesscompleteynout out nocopy varchar2,
713: p_approver_rec out nocopy ame_util.approverRecord2)
714: is
715: -- local variables
716: c_proc constant varchar2(30) := 'getNextCustomApprover';
717: l_creator_person_id per_people_f.person_id%type;

Line 806: p_approvalprocesscompleteynout := ame_util.booleanTrue;

802: (p_forward_to_person_id => ln_last_def_approver
803: ,p_person_id => l_creator_person_id );
804:
805: IF lv_response <>'N' THEN
806: p_approvalprocesscompleteynout := ame_util.booleanTrue;
807: return;
808: else
809: p_approvalprocesscompleteynout := ame_util.booleanFalse;
810: END IF;

Line 809: p_approvalprocesscompleteynout := ame_util.booleanFalse;

805: IF lv_response <>'N' THEN
806: p_approvalprocesscompleteynout := ame_util.booleanTrue;
807: return;
808: else
809: p_approvalprocesscompleteynout := ame_util.booleanFalse;
810: END IF;
811:
812: -- check if we have reached the max limit on the approvers level
813: -- the level is based on the heirarchy tree.

Line 858: p_approvalprocesscompleteynout := ame_util.booleanFalse;

854: THEN
855: IF( ln_curr_def_appr_index < ln_approval_level)
856: THEN
857:
858: p_approvalprocesscompleteynout := ame_util.booleanFalse;
859: ELSE
860: p_approvalprocesscompleteynout := ame_util.booleanTrue;
861: END IF;
862: ELSE

Line 860: p_approvalprocesscompleteynout := ame_util.booleanTrue;

856: THEN
857:
858: p_approvalprocesscompleteynout := ame_util.booleanFalse;
859: ELSE
860: p_approvalprocesscompleteynout := ame_util.booleanTrue;
861: END IF;
862: ELSE
863: lv_response := hr_approval_custom.Check_Final_approver
864: (p_forward_to_person_id => ln_last_def_approver

Line 867: p_approvalprocesscompleteynout := ame_util.booleanTrue ;

863: lv_response := hr_approval_custom.Check_Final_approver
864: (p_forward_to_person_id => ln_last_def_approver
865: ,p_person_id => l_creator_person_id );
866: if lv_response <>'N' then
867: p_approvalprocesscompleteynout := ame_util.booleanTrue ;
868: else
869: p_approvalprocesscompleteynout := ame_util.booleanFalse;
870: end if;
871: END IF;

Line 869: p_approvalprocesscompleteynout := ame_util.booleanFalse;

865: ,p_person_id => l_creator_person_id );
866: if lv_response <>'N' then
867: p_approvalprocesscompleteynout := ame_util.booleanTrue ;
868: else
869: p_approvalprocesscompleteynout := ame_util.booleanFalse;
870: end if;
871: END IF;
872:
873: -- get the next approver details

Line 874: if(p_approvalprocesscompleteynout = ame_util.booleanFalse) then

870: end if;
871: END IF;
872:
873: -- get the next approver details
874: if(p_approvalprocesscompleteynout = ame_util.booleanFalse) then
875:
876: l_current_forward_from_id:=null;
877: l_current_forward_to_id:=null;
878: ln_addntl_approvers:= null;

Line 1053: p_approver_rec.approver_category:=ame_util.approvalApproverCategory;

1049: ,p_display_name => p_approver_rec.display_name);
1050:
1051: p_approver_rec.orig_system:='PER';
1052: p_approver_rec.orig_system_id:=l_forward_to_person_id;
1053: p_approver_rec.approver_category:=ame_util.approvalApproverCategory;
1054: end if;
1055:
1056:
1057: end if;

Line 1069: p_approverRec in ame_util.approverRecord2)

1065: end getNextCustomApprover;
1066:
1067: procedure populateApproverDetails(p_item_type in varchar2,
1068: p_item_key in varchar2,
1069: p_approverRec in ame_util.approverRecord2)
1070: is
1071: -- local variables
1072: c_proc constant varchar2(60) := 'populateApproverDetails';
1073: begin

Line 1080: -- same structer as ame_util.approverRecord2

1076: if g_debug then
1077: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1078: end if;
1079: -- create and/or populate approver details to item attributes
1080: -- same structer as ame_util.approverRecord2
1081: -- HR_APR_NAME_ATTR
1082:
1083: create_item_attrib_if_notexist(itemtype=>p_item_type,
1084: itemkey=>p_item_key,

Line 1282: p_approverRec in ame_util.approverRecord2)

1278: end populateApproverDetails;
1279:
1280: procedure populatePrllApprDet(p_item_type in varchar2,
1281: p_item_key in varchar2,
1282: p_approverRec in ame_util.approverRecord2)
1283: is
1284: -- local variables
1285: c_proc constant varchar2(60) := 'populateApproverDetails';
1286: begin

Line 1293: -- same structer as ame_util.approverRecord2

1289: if g_debug then
1290: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1291: end if;
1292: -- create and/or populate approver details to item attributes
1293: -- same structer as ame_util.approverRecord2
1294:
1295:
1296:
1297:

Line 1610: ,text_value=>ame_util.fyiApproverCategory

1606:
1607: create_item_attrib_if_notexist(itemtype => p_item_type
1608: ,itemkey => p_item_key
1609: ,aname => 'HR_APR_CATEGORY_ATTR'
1610: ,text_value=>ame_util.fyiApproverCategory
1611: ,number_value=>null,
1612: date_value=>null
1613: );
1614:

Line 1690: ,text_value=>ame_util.fyiApproverCategory

1686:
1687: create_item_attrib_if_notexist(itemtype => p_item_type
1688: ,itemkey => p_item_key
1689: ,aname => 'HR_APR_CATEGORY_ATTR'
1690: ,text_value=>ame_util.fyiApproverCategory
1691: ,number_value=>null,
1692: date_value=>null
1693: );
1694:

Line 1762: -- same structer as ame_util.approverRecord2

1758: end if;
1759:
1760:
1761: -- create and/or populate approver details to item attributes
1762: -- same structer as ame_util.approverRecord2
1763: -- HR_APR_NAME_ATTR
1764:
1765: create_item_attrib_if_notexist(itemtype=>p_item_type,
1766: itemkey=>p_item_key,

Line 1809: c_next_approvers ame_util.approverstable2;

1805: -- Variables required for AME API
1806: c_application_id integer;
1807: c_transaction_id varchar2(25);
1808: c_transaction_type varchar2(25);
1809: c_next_approvers ame_util.approverstable2;
1810: c_approvalprocesscompleteynout varchar2(1) ;
1811: c_approver_to_notify_rec ame_util.approverRecord2;
1812: error_message_text varchar2(2000);
1813:

Line 1811: c_approver_to_notify_rec ame_util.approverRecord2;

1807: c_transaction_id varchar2(25);
1808: c_transaction_type varchar2(25);
1809: c_next_approvers ame_util.approverstable2;
1810: c_approvalprocesscompleteynout varchar2(1) ;
1811: c_approver_to_notify_rec ame_util.approverRecord2;
1812: error_message_text varchar2(2000);
1813:
1814: l_is_parallel varchar2(10) := null;
1815: l_role_name wf_roles.name%TYPE;

Line 1834: c_approvalprocesscompleteynout := ame_util.booleanFalse;

1830: --
1831:
1832: BEGIN
1833: g_debug := hr_utility.debug_enabled;
1834: c_approvalprocesscompleteynout := ame_util.booleanFalse;
1835:
1836: if g_debug then
1837: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1838: end if;

Line 1908: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);

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);
1909: end if;
1910: ame_api2.getNextApprovers4
1911: (applicationIdIn => c_application_id
1912: ,transactionTypeIn => c_transaction_type

Line 1914: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

1910: ame_api2.getNextApprovers4
1911: (applicationIdIn => c_application_id
1912: ,transactionTypeIn => c_transaction_type
1913: ,transactionIdIn => c_transaction_id
1914: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
1915: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
1916: ,nextApproversOut => c_next_approvers);
1917:
1918: if g_debug then

Line 2113: c_next_approvers ame_util.approverstable2;

2109: -- Variables required for AME API
2110: c_application_id integer;
2111: c_transaction_id varchar2(25);
2112: c_transaction_type varchar2(25);
2113: c_next_approvers ame_util.approverstable2;
2114: c_approvalprocesscompleteynout ame_util.charType;
2115: l_current_forward_to_username wf_users.name%type;
2116:
2117: begin

Line 2114: c_approvalprocesscompleteynout ame_util.charType;

2110: c_application_id integer;
2111: c_transaction_id varchar2(25);
2112: c_transaction_type varchar2(25);
2113: c_next_approvers ame_util.approverstable2;
2114: c_approvalprocesscompleteynout ame_util.charType;
2115: l_current_forward_to_username wf_users.name%type;
2116:
2117: begin
2118: g_debug := hr_utility.debug_enabled;

Line 2202: c_next_approvers ame_util.approverstable2;

2198: -- Variables required for AME API
2199: c_application_id integer;
2200: c_transaction_id varchar2(25);
2201: c_transaction_type varchar2(25);
2202: c_next_approvers ame_util.approverstable2;
2203: c_approvalprocesscompleteynout ame_util.charType;
2204: l_current_forward_to_username wf_users.name%type;
2205: notification_rec ame_util2.notificationRecord;
2206: l_is_parallel varchar2(10) := null;

Line 2203: c_approvalprocesscompleteynout ame_util.charType;

2199: c_application_id integer;
2200: c_transaction_id varchar2(25);
2201: c_transaction_type varchar2(25);
2202: c_next_approvers ame_util.approverstable2;
2203: c_approvalprocesscompleteynout ame_util.charType;
2204: l_current_forward_to_username wf_users.name%type;
2205: notification_rec ame_util2.notificationRecord;
2206: l_is_parallel varchar2(10) := null;
2207: original_forward_to_user wf_users.name%type;

Line 2205: notification_rec ame_util2.notificationRecord;

2201: c_transaction_type varchar2(25);
2202: c_next_approvers ame_util.approverstable2;
2203: c_approvalprocesscompleteynout ame_util.charType;
2204: l_current_forward_to_username wf_users.name%type;
2205: notification_rec ame_util2.notificationRecord;
2206: l_is_parallel varchar2(10) := null;
2207: original_forward_to_user wf_users.name%type;
2208: l_role_name wf_users.name%type;
2209:

Line 2285: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

2281: ame_api2.getNextApprovers4
2282: (applicationIdIn => c_application_id
2283: ,transactionTypeIn => c_transaction_type
2284: ,transactionIdIn => c_transaction_id
2285: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
2286: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
2287: ,nextApproversOut => c_next_approvers);
2288:
2289: for l_index in 1 .. c_next_approvers.count

Line 2319: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);

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);
2321: end if;
2322:
2323: hr_utility.set_location('before update AME: ' || l_current_forward_to_username,111);

Line 2331: approvalStatusIn =>ame_util.approvedStatus,

2327: begin
2328: ame_api6.updateApprovalStatus2(applicationIdIn=>c_application_id,
2329: transactionTypeIn =>c_transaction_type,
2330: transactionIdIn=>c_transaction_id,
2331: approvalStatusIn =>ame_util.approvedStatus,
2332: approverNameIn =>l_current_forward_to_username,
2333: itemClassIn => null,
2334: itemIdIn =>null,
2335: actionTypeIdIn=> null,

Line 2339: forwardeeIn =>ame_util.emptyApproverRecord2,

2335: actionTypeIdIn=> null,
2336: groupOrChainIdIn =>null,
2337: occurrenceIn =>null,
2338: notificationIn => notification_rec,
2339: forwardeeIn =>ame_util.emptyApproverRecord2,
2340: updateItemIn =>false);
2341:
2342: wf_engine.SetItemAttrText
2343: (itemtype => p_item_type

Line 2478: c_next_approvers ame_util.approverstable2;

2474: c_transaction_type varchar2(25);
2475: l_current_forward_to_username wf_users.name%type;
2476: l_curr_fwd_to_orig_system_id number;
2477: l_is_parallel varchar2(10) := null;
2478: c_next_approvers ame_util.approverstable2;
2479: c_approvalprocesscompleteynout varchar2(1) ;
2480:
2481: begin
2482: g_debug := hr_utility.debug_enabled;

Line 2514: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

2510: ame_api2.getNextApprovers4
2511: (applicationIdIn => c_application_id
2512: ,transactionTypeIn => c_transaction_type
2513: ,transactionIdIn => c_transaction_id
2514: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
2515: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
2516: ,nextApproversOut => c_next_approvers);
2517:
2518:

Line 2528: approvalStatusIn =>ame_util.notifiedStatus,

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,
2530: itemClassIn => wf_engine.GetItemAttrText(itemtype => p_item_type ,
2531: itemkey => p_item_key,
2532: aname => 'HR_APR_ITEM_CLASS_ATTR'),

Line 2546: forwardeeIn =>ame_util.emptyApproverRecord2,

2542: groupOrChainIdIn =>wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2543: itemkey => p_item_key,
2544: aname => 'HR_APR_GRPORCHN_ID_ATTR'),
2545: occurrenceIn =>null,
2546: forwardeeIn =>ame_util.emptyApproverRecord2,
2547: updateItemIn =>false);
2548: exit when l_index = 1;
2549: end loop;
2550: end if;

Line 2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);

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);
2572: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2573: end if;
2574:
2575: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

Line 2578: approvalStatusIn =>ame_util.notifiedStatus,

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,
2580: itemClassIn => wf_engine.GetItemAttrText(itemtype => p_item_type ,
2581: itemkey => p_item_key,
2582: aname => 'HR_APR_ITEM_CLASS_ATTR'),

Line 2596: forwardeeIn =>ame_util.emptyApproverRecord2,

2592: groupOrChainIdIn =>wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2593: itemkey => p_item_key,
2594: aname => 'HR_APR_GRPORCHN_ID_ATTR'),
2595: occurrenceIn =>null,
2596: forwardeeIn =>ame_util.emptyApproverRecord2,
2597: updateItemIn =>false);
2598: end if;
2599: end if;
2600:

Line 2632: c_next_approvers ame_util.approverstable2;

2628: -- Variables required for AME API
2629: c_application_id integer;
2630: c_transaction_id varchar2(25);
2631: c_transaction_type varchar2(25);
2632: c_next_approvers ame_util.approverstable2;
2633: c_approvalprocesscompleteynout ame_util.charType;
2634: l_current_forward_to_username wf_users.name%type;
2635: l_is_parallel varchar2(10) := null;
2636:

Line 2633: c_approvalprocesscompleteynout ame_util.charType;

2629: c_application_id integer;
2630: c_transaction_id varchar2(25);
2631: c_transaction_type varchar2(25);
2632: c_next_approvers ame_util.approverstable2;
2633: c_approvalprocesscompleteynout ame_util.charType;
2634: l_current_forward_to_username wf_users.name%type;
2635: l_is_parallel varchar2(10) := null;
2636:
2637: CURSOR c_get_users_from_role (p_role_name VARCHAR2) IS

Line 2677: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

2673: ame_api2.getNextApprovers4
2674: (applicationIdIn => c_application_id
2675: ,transactionTypeIn => c_transaction_type
2676: ,transactionIdIn => c_transaction_id
2677: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
2678: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
2679: ,nextApproversOut => c_next_approvers);
2680:
2681: if g_debug then

Line 2699: approvalStatusIn =>ame_util.noResponseStatus,

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,
2701: itemClassIn => null,
2702: itemIdIn =>null,
2703: actionTypeIdIn=> null,

Line 2706: forwardeeIn =>ame_util.emptyApproverRecord2,

2702: itemIdIn =>null,
2703: actionTypeIdIn=> null,
2704: groupOrChainIdIn =>null,
2705: occurrenceIn =>null,
2706: forwardeeIn =>ame_util.emptyApproverRecord2,
2707: updateItemIn =>false);
2708: end loop;
2709: else
2710:

Line 2714: approvalStatusIn =>ame_util.noResponseStatus,

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,
2716: itemClassIn => null,
2717: itemIdIn =>null,
2718: actionTypeIdIn=> null,

Line 2721: forwardeeIn =>ame_util.emptyApproverRecord2,

2717: itemIdIn =>null,
2718: actionTypeIdIn=> null,
2719: groupOrChainIdIn =>null,
2720: occurrenceIn =>null,
2721: forwardeeIn =>ame_util.emptyApproverRecord2,
2722: updateItemIn =>false);
2723: end if;
2724:
2725: end loop;

Line 2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);

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);
2741: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2742: end if;
2743:
2744: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

Line 2747: approvalStatusIn =>ame_util.noResponseStatus,

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,
2749: itemClassIn => null,
2750: itemIdIn =>null,
2751: actionTypeIdIn=> null,

Line 2754: forwardeeIn =>ame_util.emptyApproverRecord2,

2750: itemIdIn =>null,
2751: actionTypeIdIn=> null,
2752: groupOrChainIdIn =>null,
2753: occurrenceIn =>null,
2754: forwardeeIn =>ame_util.emptyApproverRecord2,
2755: updateItemIn =>false);
2756:
2757: end if;
2758:

Line 2887: c_next_approvers ame_util.approverstable2;

2883: -- Variables required for AME API
2884: c_application_id integer;
2885: c_transaction_id varchar2(25);
2886: c_transaction_type varchar2(25);
2887: c_next_approvers ame_util.approverstable2;
2888: c_approvalprocesscompleteynout ame_util.charType;
2889: l_current_forward_to_username wf_users.name%type;
2890: lv_transaction_status varchar2(100);
2891: lv_approval_required varchar2(100);

Line 2888: c_approvalprocesscompleteynout ame_util.charType;

2884: c_application_id integer;
2885: c_transaction_id varchar2(25);
2886: c_transaction_type varchar2(25);
2887: c_next_approvers ame_util.approverstable2;
2888: c_approvalprocesscompleteynout ame_util.charType;
2889: l_current_forward_to_username wf_users.name%type;
2890: lv_transaction_status varchar2(100);
2891: lv_approval_required varchar2(100);
2892: lv_result varchar2(100);

Line 3006: c_next_approvers ame_util.approverstable2;

3002: -- Variables required for AME API
3003: c_application_id integer;
3004: c_transaction_id varchar2(25);
3005: c_transaction_type varchar2(25);
3006: c_next_approvers ame_util.approverstable2;
3007: c_approvalprocesscompleteynout ame_util.charType;
3008: l_current_forward_to_username wf_users.name%type;
3009: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3010: lv_result_display varchar2(250);

Line 3007: c_approvalprocesscompleteynout ame_util.charType;

3003: c_application_id integer;
3004: c_transaction_id varchar2(25);
3005: c_transaction_type varchar2(25);
3006: c_next_approvers ame_util.approverstable2;
3007: c_approvalprocesscompleteynout ame_util.charType;
3008: l_current_forward_to_username wf_users.name%type;
3009: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3010: lv_result_display varchar2(250);
3011:

Line 3055: c_next_approvers ame_util.approverstable2;

3051: -- Variables required for AME API
3052: c_application_id integer;
3053: c_transaction_id varchar2(25);
3054: c_transaction_type varchar2(25);
3055: c_next_approvers ame_util.approverstable2;
3056: c_approvalprocesscompleteynout ame_util.charType;
3057: l_current_forward_to_username wf_users.name%type;
3058: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3059: lv_result_display varchar2(250);

Line 3056: c_approvalprocesscompleteynout ame_util.charType;

3052: c_application_id integer;
3053: c_transaction_id varchar2(25);
3054: c_transaction_type varchar2(25);
3055: c_next_approvers ame_util.approverstable2;
3056: c_approvalprocesscompleteynout ame_util.charType;
3057: l_current_forward_to_username wf_users.name%type;
3058: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3059: lv_result_display varchar2(250);
3060:

Line 3151: c_next_approvers ame_util.approverstable2;

3147: l_forward_to_person_id per_people_f.person_id%type;
3148: c_application_id integer;
3149: c_transaction_id varchar2(25);
3150: c_transaction_type varchar2(25);
3151: c_next_approvers ame_util.approverstable2;
3152: c_approvalprocesscompleteynout ame_util.charType;
3153: l_current_forward_to_username wf_users.name%type;
3154: rec_forwardee ame_util.approverRecord2;
3155:

Line 3152: c_approvalprocesscompleteynout ame_util.charType;

3148: c_application_id integer;
3149: c_transaction_id varchar2(25);
3150: c_transaction_type varchar2(25);
3151: c_next_approvers ame_util.approverstable2;
3152: c_approvalprocesscompleteynout ame_util.charType;
3153: l_current_forward_to_username wf_users.name%type;
3154: rec_forwardee ame_util.approverRecord2;
3155:
3156: l_new_fwd_person_id per_people_f.person_id%type;

Line 3154: rec_forwardee ame_util.approverRecord2;

3150: c_transaction_type varchar2(25);
3151: c_next_approvers ame_util.approverstable2;
3152: c_approvalprocesscompleteynout ame_util.charType;
3153: l_current_forward_to_username wf_users.name%type;
3154: rec_forwardee ame_util.approverRecord2;
3155:
3156: l_new_fwd_person_id per_people_f.person_id%type;
3157: l_new_orig_system varchar2(30);
3158: l_new_fwd_display_name varchar2(360);

Line 3219: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);

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);
3221: hr_utility.set_location('new approver:'|| wf_engine.context_new_role, 7);
3222: end if;
3223:

Line 3243: approvalStatusIn =>ame_util.forwardStatus,

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,
3245: itemClassIn => null,
3246: itemIdIn =>null,
3247: actionTypeIdIn=> null,

Line 3265: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);

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);
3266: end if;
3267:
3268: ame_api2.getNextApprovers4
3269: (applicationIdIn => c_application_id

Line 3272: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

3268: ame_api2.getNextApprovers4
3269: (applicationIdIn => c_application_id
3270: ,transactionTypeIn => c_transaction_type
3271: ,transactionIdIn => c_transaction_id
3272: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
3273: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
3274: ,nextApproversOut => c_next_approvers);
3275:
3276:

Line 3326: c_next_approvers ame_util.approverstable2;

3322: -- Variables required for AME API
3323: c_application_id integer;
3324: c_transaction_id varchar2(25);
3325: c_transaction_type varchar2(25);
3326: c_next_approvers ame_util.approverstable2;
3327: c_approvalprocesscompleteynout ame_util.charType;
3328: l_current_forward_to_username wf_users.name%type;
3329: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3330: lv_result_display varchar2(250);

Line 3327: c_approvalprocesscompleteynout ame_util.charType;

3323: c_application_id integer;
3324: c_transaction_id varchar2(25);
3325: c_transaction_type varchar2(25);
3326: c_next_approvers ame_util.approverstable2;
3327: c_approvalprocesscompleteynout ame_util.charType;
3328: l_current_forward_to_username wf_users.name%type;
3329: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3330: lv_result_display varchar2(250);
3331: lv_test_result_code varchar2(250);

Line 3447: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;

3443: -- Variables required for AME API
3444: c_application_id integer;
3445: c_transaction_id varchar2(25);
3446: c_transaction_type varchar2(25);
3447: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;
3448: c_approvalprocesscompleteynout ame_util.charType;
3449:
3450: c_creator_user wf_users.name%Type;
3451: c_return_user wf_users.name%Type;

Line 3448: c_approvalprocesscompleteynout ame_util.charType;

3444: c_application_id integer;
3445: c_transaction_id varchar2(25);
3446: c_transaction_type varchar2(25);
3447: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;
3448: c_approvalprocesscompleteynout ame_util.charType;
3449:
3450: c_creator_user wf_users.name%Type;
3451: c_return_user wf_users.name%Type;
3452: c_match_found varchar2(1);

Line 3454: notification_rec ame_util2.notificationRecord;

3450: c_creator_user wf_users.name%Type;
3451: c_return_user wf_users.name%Type;
3452: c_match_found varchar2(1);
3453: c_rfc_initiator varchar2(1);
3454: notification_rec ame_util2.notificationRecord;
3455: c_rfc_user wf_users.name%Type;
3456: l_is_parallel varchar2(10) := null;
3457:
3458: l_proc constant varchar2(100) := g_package || ' reset_ame_to_rfc_state';

Line 3578: forwardeeIn =>ame_util.emptyApproverRecord2,

3574: actionTypeIdIn=> c_all_approvers(i).ACTION_TYPE_ID,
3575: groupOrChainIdIn =>c_all_approvers(i).GROUP_OR_CHAIN_ID,
3576: occurrenceIn =>c_all_approvers(i).OCCURRENCE,
3577: notificationIn => notification_rec,
3578: forwardeeIn =>ame_util.emptyApproverRecord2,
3579: updateItemIn =>false);
3580: ELSE
3581:
3582: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

Line 3592: forwardeeIn =>ame_util.emptyApproverRecord2,

3588: itemIdIn =>c_all_approvers(i).ITEM_ID,
3589: actionTypeIdIn=> c_all_approvers(i).ACTION_TYPE_ID,
3590: groupOrChainIdIn =>c_all_approvers(i).GROUP_OR_CHAIN_ID,
3591: occurrenceIn =>c_all_approvers(i).OCCURRENCE,
3592: forwardeeIn =>ame_util.emptyApproverRecord2,
3593: updateItemIn =>false);
3594: END IF;
3595: end if;
3596:

Line 3843: c_next_approvers ame_util.approverstable2;

3839: -- Variables required for AME API
3840: c_application_id integer;
3841: c_transaction_id varchar2(25);
3842: c_transaction_type varchar2(25);
3843: c_next_approvers ame_util.approverstable2;
3844: c_approvalprocesscompleteynout ame_util.charType;
3845: l_current_forward_to_username wf_users.name%type;
3846: lv_creatorUserName wf_roles.name%type;
3847: lv_rfcUserName wf_roles.name%type;

Line 3844: c_approvalprocesscompleteynout ame_util.charType;

3840: c_application_id integer;
3841: c_transaction_id varchar2(25);
3842: c_transaction_type varchar2(25);
3843: c_next_approvers ame_util.approverstable2;
3844: c_approvalprocesscompleteynout ame_util.charType;
3845: l_current_forward_to_username wf_users.name%type;
3846: lv_creatorUserName wf_roles.name%type;
3847: lv_rfcUserName wf_roles.name%type;
3848: lv_customRFC varchar2(5);

Line 5895: c_approver_to_notify_rec ame_util.approverRecord2;

5891: c_transaction_id varchar2(25);
5892: c_transaction_type varchar2(25);
5893: l_forward_from_display_name wf_users.display_name%type;
5894: l_forward_to_display_name wf_users.display_name%type;
5895: c_approver_to_notify_rec ame_util.approverRecord2;
5896: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
5897:
5898:
5899: begin

Line 5984: c_next_approvers ame_util.approverstable2;

5980: -- Variables required for AME API
5981: c_application_id integer;
5982: c_transaction_id varchar2(25);
5983: c_transaction_type varchar2(50);
5984: c_next_approvers ame_util.approverstable2;
5985: c_approvalprocesscompleteynout ame_util.charType;
5986: l_current_forward_to_username wf_users.name%type;
5987: itemClass varchar2(100);
5988: itemId varchar2(100);

Line 5985: c_approvalprocesscompleteynout ame_util.charType;

5981: c_application_id integer;
5982: c_transaction_id varchar2(25);
5983: c_transaction_type varchar2(50);
5984: c_next_approvers ame_util.approverstable2;
5985: c_approvalprocesscompleteynout ame_util.charType;
5986: l_current_forward_to_username wf_users.name%type;
5987: itemClass varchar2(100);
5988: itemId varchar2(100);
5989: actionTypeId number;

Line 5992: notification_rec ame_util2.notificationRecord;

5988: itemId varchar2(100);
5989: actionTypeId number;
5990: groupOrChainId number;
5991: occurrence number;
5992: notification_rec ame_util2.notificationRecord;
5993: l_trans_ref_table hr_api_transactions.transaction_ref_Table%type;
5994: l_current_forward_to_username1 wf_users.name%type;
5995:
5996: l_is_parallel varchar2(10) := null;

Line 6096: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

6092: ame_api2.getNextApprovers4
6093: (applicationIdIn => c_application_id
6094: ,transactionTypeIn => c_transaction_type
6095: ,transactionIdIn => c_transaction_id
6096: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
6097: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
6098: ,nextApproversOut => c_next_approvers);
6099:
6100: for l_index in 1 .. c_next_approvers.count

Line 6131: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);

6127: if g_debug then
6128: hr_utility.set_location('calling ame_api6.updateApproveStatus2 with Reject status', 3);
6129: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
6130: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
6131: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
6132: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
6133: end if;
6134:
6135: begin

Line 6139: approvalStatusIn =>ame_util.rejectStatus,

6135: begin
6136: ame_api6.updateApprovalStatus2(applicationIdIn=>c_application_id,
6137: transactionTypeIn =>c_transaction_type,
6138: transactionIdIn=>c_transaction_id,
6139: approvalStatusIn =>ame_util.rejectStatus,
6140: approverNameIn =>l_current_forward_to_username,
6141: itemClassIn => null,
6142: itemIdIn => null,
6143: actionTypeIdIn=> null,

Line 6147: forwardeeIn =>ame_util.emptyApproverRecord2,

6143: actionTypeIdIn=> null,
6144: groupOrChainIdIn => null,
6145: occurrenceIn => null,
6146: notificationIn => notification_rec,
6147: forwardeeIn =>ame_util.emptyApproverRecord2,
6148: updateItemIn =>false);
6149:
6150: exception
6151: when others then