APPS.HR_TASKFLOW_WORKFLOW dependencies on PAY_CUSTOMIZED_RESTRICTIONS

Line 38: g_business_group_id pay_customized_restrictions.business_group_id%type;

34: g_max_number_of_buttons number := 5;
35: g_max_button_sequence_value number := 99999;
36: g_root_form_activity_id number;
37: g_root_process_id wf_process_activities.instance_id%type;
38: g_business_group_id pay_customized_restrictions.business_group_id%type;
39: g_legislation_code pay_customized_restrictions.legislation_code%type;
40: g_legislation_subgroup pay_customized_restrictions.legislation_subgroup%type;
41: g_activity_display_name wf_activities_tl.display_name%type;
42: g_process_display_name wf_activities_tl.display_name%type;

Line 39: g_legislation_code pay_customized_restrictions.legislation_code%type;

35: g_max_button_sequence_value number := 99999;
36: g_root_form_activity_id number;
37: g_root_process_id wf_process_activities.instance_id%type;
38: g_business_group_id pay_customized_restrictions.business_group_id%type;
39: g_legislation_code pay_customized_restrictions.legislation_code%type;
40: g_legislation_subgroup pay_customized_restrictions.legislation_subgroup%type;
41: g_activity_display_name wf_activities_tl.display_name%type;
42: g_process_display_name wf_activities_tl.display_name%type;
43: g_item_type_display_name wf_item_types_tl.display_name%type;

Line 40: g_legislation_subgroup pay_customized_restrictions.legislation_subgroup%type;

36: g_root_form_activity_id number;
37: g_root_process_id wf_process_activities.instance_id%type;
38: g_business_group_id pay_customized_restrictions.business_group_id%type;
39: g_legislation_code pay_customized_restrictions.legislation_code%type;
40: g_legislation_subgroup pay_customized_restrictions.legislation_subgroup%type;
41: g_activity_display_name wf_activities_tl.display_name%type;
42: g_process_display_name wf_activities_tl.display_name%type;
43: g_item_type_display_name wf_item_types_tl.display_name%type;
44: g_language varchar2(30);

Line 378: (p_business_group_id in pay_customized_restrictions.business_group_id%type

374: -- ----------------------------------------------------------------------------
375: -- |---------------------< set_business_legislation >-------------------------|
376: -- ----------------------------------------------------------------------------
377: procedure set_business_legislation
378: (p_business_group_id in pay_customized_restrictions.business_group_id%type
379: ,p_legislation_code in pay_customized_restrictions.legislation_code%type
380: ,p_legislation_subgroup in pay_customized_restrictions.legislation_subgroup%type) is
381: --
382: l_proc varchar2(72) := g_package||'set_business_legislation';

Line 379: ,p_legislation_code in pay_customized_restrictions.legislation_code%type

375: -- |---------------------< set_business_legislation >-------------------------|
376: -- ----------------------------------------------------------------------------
377: procedure set_business_legislation
378: (p_business_group_id in pay_customized_restrictions.business_group_id%type
379: ,p_legislation_code in pay_customized_restrictions.legislation_code%type
380: ,p_legislation_subgroup in pay_customized_restrictions.legislation_subgroup%type) is
381: --
382: l_proc varchar2(72) := g_package||'set_business_legislation';
383: --

Line 380: ,p_legislation_subgroup in pay_customized_restrictions.legislation_subgroup%type) is

376: -- ----------------------------------------------------------------------------
377: procedure set_business_legislation
378: (p_business_group_id in pay_customized_restrictions.business_group_id%type
379: ,p_legislation_code in pay_customized_restrictions.legislation_code%type
380: ,p_legislation_subgroup in pay_customized_restrictions.legislation_subgroup%type) is
381: --
382: l_proc varchar2(72) := g_package||'set_business_legislation';
383: --
384: begin

Line 1453: from pay_customized_restrictions pcr

1449: and hnul.language=userenv('LANG');
1450: --
1451: cursor l_csr_cust_restrict_id(c_form_name varchar2, c_customization_name varchar2) is
1452: select pcr.customized_restriction_id
1453: from pay_customized_restrictions pcr
1454: where pcr.form_name = c_form_name
1455: and pcr.enabled_flag = 'Y'
1456: and nvl(pcr.business_group_id, nvl(g_business_group_id, hr_api.g_number)) =
1457: nvl(g_business_group_id, hr_api.g_number)

Line 1477: l_customized_restriction_id pay_customized_restrictions.customized_restriction_id%type;

1473: l_taskflow_actvity_name wf_activity_attr_values.text_value%type;
1474: l_customization_name wf_activity_attr_values.text_value%type;
1475: l_taskflow_block_name wf_activity_attr_values.text_value%type;
1476: l_nav_unit_id hr_navigation_units.nav_unit_id%type;
1477: l_customized_restriction_id pay_customized_restrictions.customized_restriction_id%type;
1478: l_navigation_node_name hr_navigation_nodes.name%type;
1479: l_nextval number;
1480: l_nav_node_id hr_navigation_nodes.nav_node_id%type;
1481: l_root_nav_node_id hr_navigation_nodes.nav_node_id%type;