DBA Data[Home] [Help]

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on HR_DYNAMIC_APPROVER_LIST_SS

Line 1915: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)

1911:
1912: PROCEDURE get_default_approvers_list(
1913: p_item_type IN wf_items.item_type%TYPE,
1914: p_item_key IN wf_items.item_key%TYPE,
1915: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
1916:
1917: AS
1918:
1919: --local variables

Line 1922: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

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

Line 1984: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,

1980:
1981: PROCEDURE get_default_approvers_list(
1982: p_item_type IN wf_items.item_type%TYPE,
1983: p_item_key IN wf_items.item_key%TYPE,
1984: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,
1985: p_error_message OUT NOCOPY varchar)
1986:
1987: AS
1988:

Line 1992: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

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

Line 5395: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)

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

Line 5402: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

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

Line 5406: l_no_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

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

Line 5512: p_default_approvers_list IN hr_dynamic_approver_list_ss)

5508:
5509: PROCEDURE set_ame_approvers_list(
5510: p_item_type IN wf_items.item_type%TYPE,
5511: p_item_key IN wf_items.item_key%TYPE,
5512: p_default_approvers_list IN hr_dynamic_approver_list_ss)
5513:
5514: AS
5515:
5516: --local variables

Line 5519: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

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

Line 5521: l_approvers_list hr_dynamic_approver_list_ss;

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

Line 5645: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss)

5641:
5642: PROCEDURE get_additional_notifiers_list(
5643: p_item_type IN wf_items.item_type%TYPE,
5644: p_item_key IN wf_items.item_key%TYPE,
5645: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5646:
5647: AS
5648:
5649: --local variables

Line 5652: l_additional_notifiers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();

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