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 604: p_approver_rec out nocopy ame_util.approverRecord2)

600:
601: procedure getNextCustomApprover(p_item_type in varchar2,
602: p_item_key in varchar2,
603: p_approvalprocesscompleteynout out nocopy varchar2,
604: p_approver_rec out nocopy ame_util.approverRecord2)
605: is
606: -- local variables
607: c_proc constant varchar2(30) := 'getNextCustomApprover';
608: l_creator_person_id per_people_f.person_id%type;

Line 697: p_approvalprocesscompleteynout := ame_util.booleanTrue;

693: (p_forward_to_person_id => ln_last_def_approver
694: ,p_person_id => l_creator_person_id );
695:
696: IF lv_response <>'N' THEN
697: p_approvalprocesscompleteynout := ame_util.booleanTrue;
698: return;
699: else
700: p_approvalprocesscompleteynout := ame_util.booleanFalse;
701: END IF;

Line 700: p_approvalprocesscompleteynout := ame_util.booleanFalse;

696: IF lv_response <>'N' THEN
697: p_approvalprocesscompleteynout := ame_util.booleanTrue;
698: return;
699: else
700: p_approvalprocesscompleteynout := ame_util.booleanFalse;
701: END IF;
702:
703: -- check if we have reached the max limit on the approvers level
704: -- the level is based on the heirarchy tree.

Line 749: p_approvalprocesscompleteynout := ame_util.booleanFalse;

745: THEN
746: IF( ln_curr_def_appr_index < ln_approval_level)
747: THEN
748:
749: p_approvalprocesscompleteynout := ame_util.booleanFalse;
750: ELSE
751: p_approvalprocesscompleteynout := ame_util.booleanTrue;
752: END IF;
753: ELSE

Line 751: p_approvalprocesscompleteynout := ame_util.booleanTrue;

747: THEN
748:
749: p_approvalprocesscompleteynout := ame_util.booleanFalse;
750: ELSE
751: p_approvalprocesscompleteynout := ame_util.booleanTrue;
752: END IF;
753: ELSE
754: lv_response := hr_approval_custom.Check_Final_approver
755: (p_forward_to_person_id => ln_last_def_approver

Line 758: p_approvalprocesscompleteynout := ame_util.booleanTrue ;

754: lv_response := hr_approval_custom.Check_Final_approver
755: (p_forward_to_person_id => ln_last_def_approver
756: ,p_person_id => l_creator_person_id );
757: if lv_response <>'N' then
758: p_approvalprocesscompleteynout := ame_util.booleanTrue ;
759: else
760: p_approvalprocesscompleteynout := ame_util.booleanFalse;
761: end if;
762: END IF;

Line 760: p_approvalprocesscompleteynout := ame_util.booleanFalse;

756: ,p_person_id => l_creator_person_id );
757: if lv_response <>'N' then
758: p_approvalprocesscompleteynout := ame_util.booleanTrue ;
759: else
760: p_approvalprocesscompleteynout := ame_util.booleanFalse;
761: end if;
762: END IF;
763:
764: -- get the next approver details

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

761: end if;
762: END IF;
763:
764: -- get the next approver details
765: if(p_approvalprocesscompleteynout = ame_util.booleanFalse) then
766:
767: l_current_forward_from_id:=null;
768: l_current_forward_to_id:=null;
769: ln_addntl_approvers:= null;

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

940: ,p_display_name => p_approver_rec.display_name);
941:
942: p_approver_rec.orig_system:='PER';
943: p_approver_rec.orig_system_id:=l_forward_to_person_id;
944: p_approver_rec.approver_category:=ame_util.approvalApproverCategory;
945: end if;
946:
947:
948: end if;

Line 960: p_approverRec in ame_util.approverRecord2)

956: end getNextCustomApprover;
957:
958: procedure populateApproverDetails(p_item_type in varchar2,
959: p_item_key in varchar2,
960: p_approverRec in ame_util.approverRecord2)
961: is
962: -- local variables
963: c_proc constant varchar2(60) := 'populateApproverDetails';
964: begin

Line 971: -- same structer as ame_util.approverRecord2

967: if g_debug then
968: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
969: end if;
970: -- create and/or populate approver details to item attributes
971: -- same structer as ame_util.approverRecord2
972: -- HR_APR_NAME_ATTR
973:
974: create_item_attrib_if_notexist(itemtype=>p_item_type,
975: itemkey=>p_item_key,

Line 1251: ,text_value=>ame_util.fyiApproverCategory

1247:
1248: create_item_attrib_if_notexist(itemtype => p_item_type
1249: ,itemkey => p_item_key
1250: ,aname => 'HR_APR_CATEGORY_ATTR'
1251: ,text_value=>ame_util.fyiApproverCategory
1252: ,number_value=>null,
1253: date_value=>null
1254: );
1255:

Line 1331: ,text_value=>ame_util.fyiApproverCategory

1327:
1328: create_item_attrib_if_notexist(itemtype => p_item_type
1329: ,itemkey => p_item_key
1330: ,aname => 'HR_APR_CATEGORY_ATTR'
1331: ,text_value=>ame_util.fyiApproverCategory
1332: ,number_value=>null,
1333: date_value=>null
1334: );
1335:

Line 1394: c_next_approvers ame_util.approverstable2;

1390: -- Variables required for AME API
1391: c_application_id integer;
1392: c_transaction_id varchar2(25);
1393: c_transaction_type varchar2(25);
1394: c_next_approvers ame_util.approverstable2;
1395: c_approvalprocesscompleteynout varchar2(1) ;
1396: c_approver_to_notify_rec ame_util.approverRecord2;
1397: error_message_text varchar2(2000);
1398:

Line 1396: c_approver_to_notify_rec ame_util.approverRecord2;

1392: c_transaction_id varchar2(25);
1393: c_transaction_type varchar2(25);
1394: c_next_approvers ame_util.approverstable2;
1395: c_approvalprocesscompleteynout varchar2(1) ;
1396: c_approver_to_notify_rec ame_util.approverRecord2;
1397: error_message_text varchar2(2000);
1398:
1399: --
1400:

Line 1403: c_approvalprocesscompleteynout := ame_util.booleanFalse;

1399: --
1400:
1401: BEGIN
1402: g_debug := hr_utility.debug_enabled;
1403: c_approvalprocesscompleteynout := ame_util.booleanFalse;
1404:
1405: if g_debug then
1406: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1407: end if;

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

1473: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
1474: hr_utility.set_location('c_application_id:'||c_application_id,5);
1475: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
1476: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
1477: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
1478: end if;
1479: ame_api2.getNextApprovers4
1480: (applicationIdIn => c_application_id
1481: ,transactionTypeIn => c_transaction_type

Line 1483: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

1479: ame_api2.getNextApprovers4
1480: (applicationIdIn => c_application_id
1481: ,transactionTypeIn => c_transaction_type
1482: ,transactionIdIn => c_transaction_id
1483: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
1484: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
1485: ,nextApproversOut => c_next_approvers);
1486:
1487: if g_debug then

Line 1579: c_next_approvers ame_util.approverstable2;

1575: -- Variables required for AME API
1576: c_application_id integer;
1577: c_transaction_id varchar2(25);
1578: c_transaction_type varchar2(25);
1579: c_next_approvers ame_util.approverstable2;
1580: c_approvalprocesscompleteynout ame_util.charType;
1581: l_current_forward_to_username wf_users.name%type;
1582:
1583: begin

Line 1580: c_approvalprocesscompleteynout ame_util.charType;

1576: c_application_id integer;
1577: c_transaction_id varchar2(25);
1578: c_transaction_type varchar2(25);
1579: c_next_approvers ame_util.approverstable2;
1580: c_approvalprocesscompleteynout ame_util.charType;
1581: l_current_forward_to_username wf_users.name%type;
1582:
1583: begin
1584: g_debug := hr_utility.debug_enabled;

Line 1668: c_next_approvers ame_util.approverstable2;

1664: -- Variables required for AME API
1665: c_application_id integer;
1666: c_transaction_id varchar2(25);
1667: c_transaction_type varchar2(25);
1668: c_next_approvers ame_util.approverstable2;
1669: c_approvalprocesscompleteynout ame_util.charType;
1670: l_current_forward_to_username wf_users.name%type;
1671:
1672: begin

Line 1669: c_approvalprocesscompleteynout ame_util.charType;

1665: c_application_id integer;
1666: c_transaction_id varchar2(25);
1667: c_transaction_type varchar2(25);
1668: c_next_approvers ame_util.approverstable2;
1669: c_approvalprocesscompleteynout ame_util.charType;
1670: l_current_forward_to_username wf_users.name%type;
1671:
1672: begin
1673:

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

1701: if g_debug then
1702: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
1703: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
1704: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
1705: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
1706: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
1707: end if;
1708:
1709: begin

Line 1713: approvalStatusIn =>ame_util.approvedStatus,

1709: begin
1710: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
1711: transactionTypeIn =>c_transaction_type,
1712: transactionIdIn=>c_transaction_id,
1713: approvalStatusIn =>ame_util.approvedStatus,
1714: approverNameIn =>l_current_forward_to_username,
1715: itemClassIn => null,
1716: itemIdIn =>null,
1717: actionTypeIdIn=> null,

Line 1720: forwardeeIn =>ame_util.emptyApproverRecord2,

1716: itemIdIn =>null,
1717: actionTypeIdIn=> null,
1718: groupOrChainIdIn =>null,
1719: occurrenceIn =>null,
1720: forwardeeIn =>ame_util.emptyApproverRecord2,
1721: updateItemIn =>false);
1722: exception
1723: when others then
1724: if g_debug then

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

1866: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
1867: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
1868: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
1869: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
1870: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);
1871: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
1872: end if;
1873:
1874: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

Line 1877: approvalStatusIn =>ame_util.notifiedStatus,

1873:
1874: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
1875: transactionTypeIn =>c_transaction_type,
1876: transactionIdIn=>c_transaction_id,
1877: approvalStatusIn =>ame_util.notifiedStatus,
1878: approverNameIn =>l_current_forward_to_username,
1879: itemClassIn => wf_engine.GetItemAttrText(itemtype => p_item_type ,
1880: itemkey => p_item_key,
1881: aname => 'HR_APR_ITEM_CLASS_ATTR'),

Line 1895: forwardeeIn =>ame_util.emptyApproverRecord2,

1891: groupOrChainIdIn =>wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1892: itemkey => p_item_key,
1893: aname => 'HR_APR_GRPORCHN_ID_ATTR'),
1894: occurrenceIn =>null,
1895: forwardeeIn =>ame_util.emptyApproverRecord2,
1896: updateItemIn =>false);
1897: end if;
1898: result := wf_engine.eng_trans_default;
1899: else

Line 1930: c_next_approvers ame_util.approverstable2;

1926: -- Variables required for AME API
1927: c_application_id integer;
1928: c_transaction_id varchar2(25);
1929: c_transaction_type varchar2(25);
1930: c_next_approvers ame_util.approverstable2;
1931: c_approvalprocesscompleteynout ame_util.charType;
1932: l_current_forward_to_username wf_users.name%type;
1933:
1934: begin

Line 1931: c_approvalprocesscompleteynout ame_util.charType;

1927: c_application_id integer;
1928: c_transaction_id varchar2(25);
1929: c_transaction_type varchar2(25);
1930: c_next_approvers ame_util.approverstable2;
1931: c_approvalprocesscompleteynout ame_util.charType;
1932: l_current_forward_to_username wf_users.name%type;
1933:
1934: begin
1935: g_debug := hr_utility.debug_enabled;

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

1959: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
1960: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
1961: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
1962: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
1963: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);
1964: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
1965: end if;
1966:
1967: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

Line 1970: approvalStatusIn =>ame_util.noResponseStatus,

1966:
1967: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
1968: transactionTypeIn =>c_transaction_type,
1969: transactionIdIn=>c_transaction_id,
1970: approvalStatusIn =>ame_util.noResponseStatus,
1971: approverNameIn =>l_current_forward_to_username,
1972: itemClassIn => null,
1973: itemIdIn =>null,
1974: actionTypeIdIn=> null,

Line 1977: forwardeeIn =>ame_util.emptyApproverRecord2,

1973: itemIdIn =>null,
1974: actionTypeIdIn=> null,
1975: groupOrChainIdIn =>null,
1976: occurrenceIn =>null,
1977: forwardeeIn =>ame_util.emptyApproverRecord2,
1978: updateItemIn =>false);
1979:
1980: result := wf_engine.eng_trans_default;
1981: else

Line 2102: c_next_approvers ame_util.approverstable2;

2098: -- Variables required for AME API
2099: c_application_id integer;
2100: c_transaction_id varchar2(25);
2101: c_transaction_type varchar2(25);
2102: c_next_approvers ame_util.approverstable2;
2103: c_approvalprocesscompleteynout ame_util.charType;
2104: l_current_forward_to_username wf_users.name%type;
2105: lv_transaction_status varchar2(100);
2106: lv_approval_required varchar2(100);

Line 2103: c_approvalprocesscompleteynout ame_util.charType;

2099: c_application_id integer;
2100: c_transaction_id varchar2(25);
2101: c_transaction_type varchar2(25);
2102: c_next_approvers ame_util.approverstable2;
2103: c_approvalprocesscompleteynout ame_util.charType;
2104: l_current_forward_to_username wf_users.name%type;
2105: lv_transaction_status varchar2(100);
2106: lv_approval_required varchar2(100);
2107: lv_result varchar2(100);

Line 2213: c_next_approvers ame_util.approverstable2;

2209: -- Variables required for AME API
2210: c_application_id integer;
2211: c_transaction_id varchar2(25);
2212: c_transaction_type varchar2(25);
2213: c_next_approvers ame_util.approverstable2;
2214: c_approvalprocesscompleteynout ame_util.charType;
2215: l_current_forward_to_username wf_users.name%type;
2216: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2217: lv_result_display varchar2(250);

Line 2214: c_approvalprocesscompleteynout ame_util.charType;

2210: c_application_id integer;
2211: c_transaction_id varchar2(25);
2212: c_transaction_type varchar2(25);
2213: c_next_approvers ame_util.approverstable2;
2214: c_approvalprocesscompleteynout ame_util.charType;
2215: l_current_forward_to_username wf_users.name%type;
2216: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2217: lv_result_display varchar2(250);
2218:

Line 2262: c_next_approvers ame_util.approverstable2;

2258: -- Variables required for AME API
2259: c_application_id integer;
2260: c_transaction_id varchar2(25);
2261: c_transaction_type varchar2(25);
2262: c_next_approvers ame_util.approverstable2;
2263: c_approvalprocesscompleteynout ame_util.charType;
2264: l_current_forward_to_username wf_users.name%type;
2265: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2266: lv_result_display varchar2(250);

Line 2263: c_approvalprocesscompleteynout ame_util.charType;

2259: c_application_id integer;
2260: c_transaction_id varchar2(25);
2261: c_transaction_type varchar2(25);
2262: c_next_approvers ame_util.approverstable2;
2263: c_approvalprocesscompleteynout ame_util.charType;
2264: l_current_forward_to_username wf_users.name%type;
2265: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2266: lv_result_display varchar2(250);
2267:

Line 2337: c_next_approvers ame_util.approverstable2;

2333: l_forward_to_person_id per_people_f.person_id%type;
2334: c_application_id integer;
2335: c_transaction_id varchar2(25);
2336: c_transaction_type varchar2(25);
2337: c_next_approvers ame_util.approverstable2;
2338: c_approvalprocesscompleteynout ame_util.charType;
2339: l_current_forward_to_username wf_users.name%type;
2340: rec_forwardee ame_util.approverRecord2;
2341:

Line 2338: c_approvalprocesscompleteynout ame_util.charType;

2334: c_application_id integer;
2335: c_transaction_id varchar2(25);
2336: c_transaction_type varchar2(25);
2337: c_next_approvers ame_util.approverstable2;
2338: c_approvalprocesscompleteynout ame_util.charType;
2339: l_current_forward_to_username wf_users.name%type;
2340: rec_forwardee ame_util.approverRecord2;
2341:
2342: l_new_fwd_person_id per_people_f.person_id%type;

Line 2340: rec_forwardee ame_util.approverRecord2;

2336: c_transaction_type varchar2(25);
2337: c_next_approvers ame_util.approverstable2;
2338: c_approvalprocesscompleteynout ame_util.charType;
2339: l_current_forward_to_username wf_users.name%type;
2340: rec_forwardee ame_util.approverRecord2;
2341:
2342: l_new_fwd_person_id per_people_f.person_id%type;
2343: l_new_orig_system varchar2(30);
2344: l_new_fwd_display_name varchar2(360);

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

2380: if g_debug then
2381: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
2382: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
2383: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
2384: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2385: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2386: hr_utility.set_location('new approver:'|| wf_engine.context_new_role, 7);
2387: end if;
2388:

Line 2408: approvalStatusIn =>ame_util.forwardStatus,

2404:
2405: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2406: transactionTypeIn =>c_transaction_type,
2407: transactionIdIn=>c_transaction_id,
2408: approvalStatusIn =>ame_util.forwardStatus,
2409: approverNameIn =>l_current_forward_to_username,
2410: itemClassIn => null,
2411: itemIdIn =>null,
2412: actionTypeIdIn=> null,

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

2425: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
2426: hr_utility.set_location('c_application_id:'||c_application_id,5);
2427: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
2428: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
2429: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
2430: end if;
2431:
2432: ame_api2.getNextApprovers4
2433: (applicationIdIn => c_application_id

Line 2436: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse

2432: ame_api2.getNextApprovers4
2433: (applicationIdIn => c_application_id
2434: ,transactionTypeIn => c_transaction_type
2435: ,transactionIdIn => c_transaction_id
2436: ,flagApproversAsNotifiedIn=>ame_util.booleanFalse
2437: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
2438: ,nextApproversOut => c_next_approvers);
2439:
2440:

Line 2490: c_next_approvers ame_util.approverstable2;

2486: -- Variables required for AME API
2487: c_application_id integer;
2488: c_transaction_id varchar2(25);
2489: c_transaction_type varchar2(25);
2490: c_next_approvers ame_util.approverstable2;
2491: c_approvalprocesscompleteynout ame_util.charType;
2492: l_current_forward_to_username wf_users.name%type;
2493: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2494: lv_result_display varchar2(250);

Line 2491: c_approvalprocesscompleteynout ame_util.charType;

2487: c_application_id integer;
2488: c_transaction_id varchar2(25);
2489: c_transaction_type varchar2(25);
2490: c_next_approvers ame_util.approverstable2;
2491: c_approvalprocesscompleteynout ame_util.charType;
2492: l_current_forward_to_username wf_users.name%type;
2493: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2494: lv_result_display varchar2(250);
2495: lv_test_result_code varchar2(250);

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

2546: -- Variables required for AME API
2547: c_application_id integer;
2548: c_transaction_id varchar2(25);
2549: c_transaction_type varchar2(25);
2550: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;
2551: c_approvalprocesscompleteynout ame_util.charType;
2552:
2553: c_creator_user wf_users.name%Type;
2554: c_return_user wf_users.name%Type;

Line 2551: c_approvalprocesscompleteynout ame_util.charType;

2547: c_application_id integer;
2548: c_transaction_id varchar2(25);
2549: c_transaction_type varchar2(25);
2550: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;
2551: c_approvalprocesscompleteynout ame_util.charType;
2552:
2553: c_creator_user wf_users.name%Type;
2554: c_return_user wf_users.name%Type;
2555: c_match_found varchar2(1);

Line 2631: forwardeeIn =>ame_util.emptyApproverRecord2,

2627: itemIdIn =>c_all_approvers(i).ITEM_ID,
2628: actionTypeIdIn=> c_all_approvers(i).ACTION_TYPE_ID,
2629: groupOrChainIdIn =>c_all_approvers(i).GROUP_OR_CHAIN_ID,
2630: occurrenceIn =>c_all_approvers(i).OCCURRENCE,
2631: forwardeeIn =>ame_util.emptyApproverRecord2,
2632: updateItemIn =>false);
2633: end if;
2634:
2635: end loop;

Line 2843: c_next_approvers ame_util.approverstable2;

2839: -- Variables required for AME API
2840: c_application_id integer;
2841: c_transaction_id varchar2(25);
2842: c_transaction_type varchar2(25);
2843: c_next_approvers ame_util.approverstable2;
2844: c_approvalprocesscompleteynout ame_util.charType;
2845: l_current_forward_to_username wf_users.name%type;
2846: lv_creatorUserName wf_roles.name%type;
2847: lv_rfcUserName wf_roles.name%type;

Line 2844: c_approvalprocesscompleteynout ame_util.charType;

2840: c_application_id integer;
2841: c_transaction_id varchar2(25);
2842: c_transaction_type varchar2(25);
2843: c_next_approvers ame_util.approverstable2;
2844: c_approvalprocesscompleteynout ame_util.charType;
2845: l_current_forward_to_username wf_users.name%type;
2846: lv_creatorUserName wf_roles.name%type;
2847: lv_rfcUserName wf_roles.name%type;
2848: lv_customRFC varchar2(5);

Line 4847: c_approver_to_notify_rec ame_util.approverRecord2;

4843: c_transaction_id varchar2(25);
4844: c_transaction_type varchar2(25);
4845: l_forward_from_display_name wf_users.display_name%type;
4846: l_forward_to_display_name wf_users.display_name%type;
4847: c_approver_to_notify_rec ame_util.approverRecord2;
4848: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
4849:
4850:
4851: begin