APPS.HR_TASKFLOW_WORKFLOW dependencies on HR_API

Line 1447: and nvl(hnu.block_name, hr_api.g_varchar2) = nvl(c_block_name, hr_api.g_varchar2)

1443: ,hnul.default_label
1444: from hr_navigation_units hnu,
1445: hr_navigation_units_tl hnul
1446: where hnu.form_name = c_form_name
1447: and nvl(hnu.block_name, hr_api.g_varchar2) = nvl(c_block_name, hr_api.g_varchar2)
1448: and hnu.nav_unit_id = hnul.nav_unit_id
1449: and hnul.language=userenv('LANG');
1450: --
1451: cursor l_csr_cust_restrict_id(c_form_name varchar2, c_customization_name varchar2) is

Line 1456: and nvl(pcr.business_group_id, nvl(g_business_group_id, hr_api.g_number)) =

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)
1458: and nvl(pcr.legislation_code, nvl(g_legislation_code, hr_api.g_varchar2)) =
1459: nvl(g_legislation_code, hr_api.g_varchar2)
1460: and nvl(pcr.legislation_subgroup, nvl(g_legislation_subgroup, hr_api.g_varchar2)) =

Line 1457: nvl(g_business_group_id, hr_api.g_number)

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)
1458: and nvl(pcr.legislation_code, nvl(g_legislation_code, hr_api.g_varchar2)) =
1459: nvl(g_legislation_code, hr_api.g_varchar2)
1460: and nvl(pcr.legislation_subgroup, nvl(g_legislation_subgroup, hr_api.g_varchar2)) =
1461: nvl(g_legislation_subgroup, hr_api.g_varchar2)

Line 1458: and nvl(pcr.legislation_code, nvl(g_legislation_code, hr_api.g_varchar2)) =

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)
1458: and nvl(pcr.legislation_code, nvl(g_legislation_code, hr_api.g_varchar2)) =
1459: nvl(g_legislation_code, hr_api.g_varchar2)
1460: and nvl(pcr.legislation_subgroup, nvl(g_legislation_subgroup, hr_api.g_varchar2)) =
1461: nvl(g_legislation_subgroup, hr_api.g_varchar2)
1462: and pcr.application_id between 800 and 899

Line 1459: nvl(g_legislation_code, hr_api.g_varchar2)

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)
1458: and nvl(pcr.legislation_code, nvl(g_legislation_code, hr_api.g_varchar2)) =
1459: nvl(g_legislation_code, hr_api.g_varchar2)
1460: and nvl(pcr.legislation_subgroup, nvl(g_legislation_subgroup, hr_api.g_varchar2)) =
1461: nvl(g_legislation_subgroup, hr_api.g_varchar2)
1462: and pcr.application_id between 800 and 899
1463: and pcr.name = c_customization_name;

Line 1460: and nvl(pcr.legislation_subgroup, nvl(g_legislation_subgroup, hr_api.g_varchar2)) =

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)
1458: and nvl(pcr.legislation_code, nvl(g_legislation_code, hr_api.g_varchar2)) =
1459: nvl(g_legislation_code, hr_api.g_varchar2)
1460: and nvl(pcr.legislation_subgroup, nvl(g_legislation_subgroup, hr_api.g_varchar2)) =
1461: nvl(g_legislation_subgroup, hr_api.g_varchar2)
1462: and pcr.application_id between 800 and 899
1463: and pcr.name = c_customization_name;
1464: --

Line 1461: nvl(g_legislation_subgroup, hr_api.g_varchar2)

1457: nvl(g_business_group_id, hr_api.g_number)
1458: and nvl(pcr.legislation_code, nvl(g_legislation_code, hr_api.g_varchar2)) =
1459: nvl(g_legislation_code, hr_api.g_varchar2)
1460: and nvl(pcr.legislation_subgroup, nvl(g_legislation_subgroup, hr_api.g_varchar2)) =
1461: nvl(g_legislation_subgroup, hr_api.g_varchar2)
1462: and pcr.application_id between 800 and 899
1463: and pcr.name = c_customization_name;
1464: --
1465: cursor l_csr_nav_node_id(c_nav_unit_id number, c_customized_restriction_id number) is

Line 1470: and nvl(hnn.customized_restriction_id, hr_api.g_number) =

1466: select hnn.nav_node_id
1467: ,hnn.name
1468: from hr_navigation_nodes hnn
1469: where hnn.nav_unit_id = c_nav_unit_id
1470: and nvl(hnn.customized_restriction_id, hr_api.g_number) =
1471: nvl(c_customized_restriction_id, hr_api.g_number);
1472: --
1473: l_taskflow_actvity_name wf_activity_attr_values.text_value%type;
1474: l_customization_name wf_activity_attr_values.text_value%type;

Line 1471: nvl(c_customized_restriction_id, hr_api.g_number);

1467: ,hnn.name
1468: from hr_navigation_nodes hnn
1469: where hnn.nav_unit_id = c_nav_unit_id
1470: and nvl(hnn.customized_restriction_id, hr_api.g_number) =
1471: nvl(c_customized_restriction_id, hr_api.g_number);
1472: --
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;

Line 1694: hr_api.mandatory_arg_error

1690: --
1691: begin
1692: hr_utility.set_location('Entering:'||l_proc, 10);
1693: -- ensure that the item type has been set
1694: hr_api.mandatory_arg_error
1695: (p_api_name => l_proc
1696: ,p_argument => 'process_item_type'
1697: ,p_argument_value => p_process_item_type);
1698: -- set the language code

Line 1828: hr_api.mandatory_arg_error

1824: --
1825: begin
1826: hr_utility.set_location('Entering:'||l_proc, 10);
1827: -- ensure that the item type and process names are specified
1828: hr_api.mandatory_arg_error
1829: (p_api_name => l_proc
1830: ,p_argument => 'item_type'
1831: ,p_argument_value => p_item_type);
1832: hr_api.mandatory_arg_error

Line 1832: hr_api.mandatory_arg_error

1828: hr_api.mandatory_arg_error
1829: (p_api_name => l_proc
1830: ,p_argument => 'item_type'
1831: ,p_argument_value => p_item_type);
1832: hr_api.mandatory_arg_error
1833: (p_api_name => l_proc
1834: ,p_argument => 'process_name'
1835: ,p_argument_value => p_process_name);
1836: -- open the cursor