DBA Data[Home] [Help]

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on HR_DYNAMIC_APPROVER_LIST_SS

Line 1854: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)

1850:
1851: PROCEDURE get_default_approvers_list(
1852: p_item_type IN wf_items.item_type%TYPE,
1853: p_item_key IN wf_items.item_key%TYPE,
1854: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
1855:
1856: AS
1857:
1858: --local variables

Line 1861: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

1857:
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);

Line 1923: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,

1919:
1920: PROCEDURE get_default_approvers_list(
1921: p_item_type IN wf_items.item_type%TYPE,
1922: p_item_key IN wf_items.item_key%TYPE,
1923: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,
1924: p_error_message OUT NOCOPY varchar)
1925:
1926: AS
1927:

Line 1931: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

1927:
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

Line 5279: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)

5275:
5276: PROCEDURE get_ame_approvers_list(
5277: p_item_type IN wf_items.item_type%TYPE,
5278: p_item_key IN wf_items.item_key%TYPE,
5279: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5280:
5281: AS
5282:
5283: --local variables

Line 5286: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

5282:
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();

Line 5290: l_no_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

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;
5292: l_proc constant varchar2(100) := g_package || ' get_ame_approvers_list';
5293: BEGIN
5294: hr_utility.set_location('Entering: '|| l_proc,5);

Line 5396: p_default_approvers_list IN hr_dynamic_approver_list_ss)

5392:
5393: PROCEDURE set_ame_approvers_list(
5394: p_item_type IN wf_items.item_type%TYPE,
5395: p_item_key IN wf_items.item_key%TYPE,
5396: p_default_approvers_list IN hr_dynamic_approver_list_ss)
5397:
5398: AS
5399:
5400: --local variables

Line 5403: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

5399:
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';

Line 5405: l_approvers_list hr_dynamic_approver_list_ss;

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
5409: c_application_id integer;

Line 5501: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss)

5497:
5498: PROCEDURE get_additional_notifiers_list(
5499: p_item_type IN wf_items.item_type%TYPE,
5500: p_item_key IN wf_items.item_key%TYPE,
5501: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5502:
5503: AS
5504:
5505: --local variables

Line 5508: l_additional_notifiers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

5504:
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) ;