DBA Data[Home] [Help]

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on HR_DYNAMIC_APPROVER_SS

Line 1923: l_default_approver hr_dynamic_approver_ss;

1919: --local variables
1920: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1921: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1922: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1923: l_default_approver hr_dynamic_approver_ss;
1924: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list';
1925: BEGIN
1926: hr_utility.set_location('Entering: '|| l_proc,5);
1927: -- remove all rows from person details table

Line 1952: l_default_approver := hr_dynamic_approver_ss(

1948: hr_utility.trace('Going into (FOR I IN 1..grt_person_details_rec_table.count): '|| l_proc);
1949: FOR I IN 1..grt_person_details_rec_table.count
1950: LOOP
1951:
1952: l_default_approver := hr_dynamic_approver_ss(
1953: grt_person_details_rec_table(I).full_name,
1954: grt_person_details_rec_table(I).person_id,
1955: grt_person_details_rec_table(I).job_title,
1956: grt_person_details_rec_table(I).default_approver,

Line 1993: l_default_approver hr_dynamic_approver_ss;

1989: --local variables
1990: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1991: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1992: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1993: l_default_approver hr_dynamic_approver_ss;
1994: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list_extra';
1995: l_error_message long default null;
1996: BEGIN
1997: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2023: l_default_approver := hr_dynamic_approver_ss(

2019: hr_utility.trace('Going into (FOR I IN 1..grt_person_details_rec_table.count): '|| l_proc);
2020: FOR I IN 1..grt_person_details_rec_table.count
2021: LOOP
2022:
2023: l_default_approver := hr_dynamic_approver_ss(
2024: grt_person_details_rec_table(I).full_name,
2025: grt_person_details_rec_table(I).person_id,
2026: grt_person_details_rec_table(I).job_title,
2027: grt_person_details_rec_table(I).default_approver,

Line 5403: l_default_approver hr_dynamic_approver_ss;

5399: --local variables
5400: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5401: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5402: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5403: l_default_approver hr_dynamic_approver_ss;
5404: lv_number varchar2(10);
5405: ln_creator_person_id number;
5406: l_no_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5407: ln_transaction_id hr_api_transactions.transaction_id%type;

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

5432: hr_utility.trace('approver count retuned from get_all_ame_approvers :'||nvl(lv_number,0));
5433: hr_utility.trace('Going into ( FOR I IN 1..grt_approver_details_table.count ): '|| l_proc);
5434: FOR I IN 1..grt_approver_details_table.count
5435: LOOP
5436: hr_utility.trace('building approvers out nocopy list using hr_dynamic_approver_ss');
5437: hr_utility.trace(' Adding approver :'||grt_approver_details_table(I).person_id||' to the list');
5438: l_default_approver := hr_dynamic_approver_ss(
5439: grt_approver_details_table(I).full_name,
5440: grt_approver_details_table(I).person_id,

Line 5438: l_default_approver := hr_dynamic_approver_ss(

5434: FOR I IN 1..grt_approver_details_table.count
5435: LOOP
5436: hr_utility.trace('building approvers out nocopy list using hr_dynamic_approver_ss');
5437: hr_utility.trace(' Adding approver :'||grt_approver_details_table(I).person_id||' to the list');
5438: l_default_approver := hr_dynamic_approver_ss(
5439: grt_approver_details_table(I).full_name,
5440: grt_approver_details_table(I).person_id,
5441: grt_approver_details_table(I).job_title,
5442: grt_approver_details_table(I).default_approver,

Line 5520: l_default_approver hr_dynamic_approver_ss;

5516: --local variables
5517: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5518: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5519: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5520: l_default_approver hr_dynamic_approver_ss;
5521: l_approvers_list hr_dynamic_approver_list_ss;
5522: lv_number varchar2(10);
5523: l_proc constant varchar2(100) := g_package || ' set_ame_approvers_list';
5524: -- Variables required for AME API

Line 5653: l_notifier_rec hr_dynamic_approver_ss;

5649: --local variables
5650: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5651: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5652: l_additional_notifiers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5653: l_notifier_rec hr_dynamic_approver_ss;
5654: lv_number varchar2(10);
5655: lv_exist VARCHAR2(10) DEFAULT 'N';
5656: l_dummy VARCHAR2(100) ;
5657: lv_item_name VARCHAR2(100);

Line 5747: l_notifier_rec := hr_dynamic_approver_ss(

5743: -- parse the lv_notify for these values
5744: lrt_notifier_details_table(I).on_submit := SUBSTR(lv_notify,1,1);
5745: lrt_notifier_details_table(I).on_approval := SUBSTR(lv_notify,3,3);
5746:
5747: l_notifier_rec := hr_dynamic_approver_ss(
5748: lrt_notifier_details_table(I).full_name,
5749: lrt_notifier_details_table(I).person_id,
5750: lrt_notifier_details_table(I).job_title ,
5751: lv_notify,