DBA Data[Home] [Help]

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on HR_DYNAMIC_APPROVER_SS

Line 1862: l_default_approver hr_dynamic_approver_ss;

1858: --local variables
1859: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1860: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1861: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1862: l_default_approver hr_dynamic_approver_ss;
1863: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list';
1864: BEGIN
1865: hr_utility.set_location('Entering: '|| l_proc,5);
1866: -- remove all rows from person details table

Line 1891: l_default_approver := hr_dynamic_approver_ss(

1887: hr_utility.trace('Going into (FOR I IN 1..grt_person_details_rec_table.count): '|| l_proc);
1888: FOR I IN 1..grt_person_details_rec_table.count
1889: LOOP
1890:
1891: l_default_approver := hr_dynamic_approver_ss(
1892: grt_person_details_rec_table(I).full_name,
1893: grt_person_details_rec_table(I).person_id,
1894: grt_person_details_rec_table(I).job_title,
1895: grt_person_details_rec_table(I).default_approver,

Line 1932: l_default_approver hr_dynamic_approver_ss;

1928: --local variables
1929: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1930: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1931: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1932: l_default_approver hr_dynamic_approver_ss;
1933: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list_extra';
1934: l_error_message long default null;
1935: BEGIN
1936: hr_utility.set_location('Entering: '|| l_proc,5);

Line 1962: l_default_approver := hr_dynamic_approver_ss(

1958: hr_utility.trace('Going into (FOR I IN 1..grt_person_details_rec_table.count): '|| l_proc);
1959: FOR I IN 1..grt_person_details_rec_table.count
1960: LOOP
1961:
1962: l_default_approver := hr_dynamic_approver_ss(
1963: grt_person_details_rec_table(I).full_name,
1964: grt_person_details_rec_table(I).person_id,
1965: grt_person_details_rec_table(I).job_title,
1966: grt_person_details_rec_table(I).default_approver,

Line 5287: l_default_approver hr_dynamic_approver_ss;

5283: --local variables
5284: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5285: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5286: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5287: l_default_approver hr_dynamic_approver_ss;
5288: lv_number varchar2(10);
5289: ln_creator_person_id number;
5290: l_no_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5291: ln_transaction_id hr_api_transactions.transaction_id%type;

Line 5320: hr_utility.trace('building approvers out nocopy list using hr_dynamic_approver_ss');

5316: hr_utility.trace('approver count retuned from get_all_ame_approvers :'||nvl(lv_number,0));
5317: hr_utility.trace('Going into ( FOR I IN 1..grt_approver_details_table.count ): '|| l_proc);
5318: FOR I IN 1..grt_approver_details_table.count
5319: LOOP
5320: hr_utility.trace('building approvers out nocopy list using hr_dynamic_approver_ss');
5321: hr_utility.trace(' Adding approver :'||grt_approver_details_table(I).person_id||' to the list');
5322: l_default_approver := hr_dynamic_approver_ss(
5323: grt_approver_details_table(I).full_name,
5324: grt_approver_details_table(I).person_id,

Line 5322: l_default_approver := hr_dynamic_approver_ss(

5318: FOR I IN 1..grt_approver_details_table.count
5319: LOOP
5320: hr_utility.trace('building approvers out nocopy list using hr_dynamic_approver_ss');
5321: hr_utility.trace(' Adding approver :'||grt_approver_details_table(I).person_id||' to the list');
5322: l_default_approver := hr_dynamic_approver_ss(
5323: grt_approver_details_table(I).full_name,
5324: grt_approver_details_table(I).person_id,
5325: grt_approver_details_table(I).job_title,
5326: grt_approver_details_table(I).default_approver,

Line 5404: l_default_approver hr_dynamic_approver_ss;

5400: --local variables
5401: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5402: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5403: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5404: l_default_approver hr_dynamic_approver_ss;
5405: l_approvers_list hr_dynamic_approver_list_ss;
5406: lv_number varchar2(10);
5407: l_proc constant varchar2(100) := g_package || ' set_ame_approvers_list';
5408: -- Variables required for AME API

Line 5509: l_notifier_rec hr_dynamic_approver_ss;

5505: --local variables
5506: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5507: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5508: l_additional_notifiers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5509: l_notifier_rec hr_dynamic_approver_ss;
5510: lv_number varchar2(10);
5511: lv_exist VARCHAR2(10) DEFAULT 'N';
5512: l_dummy VARCHAR2(100) ;
5513: lv_item_name VARCHAR2(100);

Line 5603: l_notifier_rec := hr_dynamic_approver_ss(

5599: -- parse the lv_notify for these values
5600: lrt_notifier_details_table(I).on_submit := SUBSTR(lv_notify,1,1);
5601: lrt_notifier_details_table(I).on_approval := SUBSTR(lv_notify,3,3);
5602:
5603: l_notifier_rec := hr_dynamic_approver_ss(
5604: lrt_notifier_details_table(I).full_name,
5605: lrt_notifier_details_table(I).person_id,
5606: lrt_notifier_details_table(I).job_title ,
5607: lv_notify,