APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on HR_API

Line 247: effective_start_date and nvl(effective_end_date, hr_api.g_eot))

243: from ff_formulas_f
244: where formula_type_id = p_formula_type_id
245: and upper(formula_name) = p_formula
246: and (p_effective_date between
247: effective_start_date and nvl(effective_end_date, hr_api.g_eot))
248: and
249: (
250: (business_group_id is null and legislation_code is null)
251: or (legislation_code is null and business_group_id = p_business_group_id)

Line 336: effective_start_date and nvl(effective_end_date, hr_api.g_eot)

332: select element_type_id
333: from pay_element_types_f
334: where upper(element_name) = p_element_name
335: and p_effective_date between
336: effective_start_date and nvl(effective_end_date, hr_api.g_eot)
337: and
338: (
339: (business_group_id is null and legislation_code is null)
340: or (legislation_code is null and business_group_id = p_business_group_id)

Line 471: effective_start_date and nvl(effective_end_date, hr_api.g_eot)

467: select run_type_id
468: from pay_run_types_f
469: where upper(run_type_name) = p_run_type
470: and p_effective_date between
471: effective_start_date and nvl(effective_end_date, hr_api.g_eot)
472: and
473: (
474: (business_group_id is null and legislation_code is null)
475: or (legislation_code is null and business_group_id = p_business_group_id)

Line 1069: l_last_update_date := hr_api.g_sys;

1065: --
1066: l_formula_name := p_formulas(i).formula_name;
1067: l_formula_id := null;
1068: l_rowid := null;
1069: l_last_update_date := hr_api.g_sys;
1070:
1071: --
1072: -- Get the formula type. If formula type is null then consider
1073: -- formula to be of type 'Oracle Payroll' and use g_payroll_formula_id.

Line 1088: ,x_effective_end_date => hr_api.g_eot

1084: ff_formulas_f_pkg.insert_row
1085: (x_rowid => l_rowid
1086: ,x_formula_id => l_formula_id
1087: ,x_effective_start_date => p_effective_date
1088: ,x_effective_end_date => hr_api.g_eot
1089: ,x_business_group_id => p_formulas(i).business_group_id
1090: ,x_legislation_code => null
1091: ,x_formula_type_id => l_formula_type_id
1092: ,x_formula_name => l_formula_name

Line 1558: ,p_val_end_date => hr_api.g_eot

1554: hr_elements.chk_element_type
1555: (p_element_name => p_element_types(i).element_name
1556: ,p_element_type_id => null
1557: ,p_val_start_date => p_effective_date
1558: ,p_val_end_date => hr_api.g_eot
1559: ,p_reporting_name => p_element_types(i).reporting_name
1560: ,p_rowid => null
1561: ,p_recurring_flag => p_element_types(i).processing_type
1562: ,p_standard_flag => p_element_types(i).standard_link_flag

Line 1584: ,p_effective_end_date => hr_api.g_eot

1580: pay_element_types_pkg.insert_row
1581: (p_rowid => l_rowid
1582: ,p_element_type_id => l_element_type_id
1583: ,p_effective_start_date => p_effective_date
1584: ,p_effective_end_date => hr_api.g_eot
1585: ,p_business_group_id => p_business_group_id
1586: ,p_legislation_code => null
1587: ,p_formula_id => l_formula_id
1588: ,p_input_currency_code => p_element_types(i).input_currency_code

Line 1721: ,x_effective_end_date => hr_api.g_eot

1717: pay_status_rules_pkg.insert_row
1718: (x_rowid => l_rowid
1719: ,x_status_processing_rule_id => l_status_processing_rule_id
1720: ,x_effective_start_date => p_effective_date
1721: ,x_effective_end_date => hr_api.g_eot
1722: ,x_business_group_id => p_business_group_id
1723: ,x_legislation_code => null
1724: ,x_element_type_id => l_element_type_id
1725: ,x_assignment_status_type_id => null

Line 1730: ,x_last_update_date => hr_api.g_sys

1726: ,x_formula_id => l_formula_id
1727: ,x_processing_rule => 'P'
1728: ,x_comment_id => null
1729: ,x_legislation_subgroup => null
1730: ,x_last_update_date => hr_api.g_sys
1731: ,x_last_updated_by => -1
1732: ,x_last_update_login => -1
1733: ,x_created_by => -1
1734: ,x_creation_date => hr_api.g_sys

Line 1734: ,x_creation_date => hr_api.g_sys

1730: ,x_last_update_date => hr_api.g_sys
1731: ,x_last_updated_by => -1
1732: ,x_last_update_login => -1
1733: ,x_created_by => -1
1734: ,x_creation_date => hr_api.g_sys
1735: );
1736: --
1737: -- Set up the core object table rows.
1738: --

Line 1918: ,p_effective_end_date => hr_api.g_eot

1914: pay_sub_class_rules_pkg.insert_row
1915: (p_rowid => l_rowid
1916: ,p_sub_classification_rule_id => l_sub_classification_rule_id
1917: ,p_effective_start_date => p_effective_date
1918: ,p_effective_end_date => hr_api.g_eot
1919: ,p_element_type_id => l_element_type_id
1920: ,p_classification_id => l_ele_classification_id
1921: ,p_business_group_id => p_business_group_id
1922: ,p_legislation_code => null

Line 1923: ,p_last_update_date => hr_api.g_sys

1919: ,p_element_type_id => l_element_type_id
1920: ,p_classification_id => l_ele_classification_id
1921: ,p_business_group_id => p_business_group_id
1922: ,p_legislation_code => null
1923: ,p_last_update_date => hr_api.g_sys
1924: ,p_last_updated_by => -1
1925: ,p_last_update_login => -1
1926: ,p_created_by => -1
1927: ,p_creation_date => hr_api.g_sys

Line 1927: ,p_creation_date => hr_api.g_sys

1923: ,p_last_update_date => hr_api.g_sys
1924: ,p_last_updated_by => -1
1925: ,p_last_update_login => -1
1926: ,p_created_by => -1
1927: ,p_creation_date => hr_api.g_sys
1928: );
1929: --
1930: -- Set up the core object table rows.
1931: --

Line 2264: ,p_effective_end_date => hr_api.g_eot

2260: pay_input_values_pkg.insert_row
2261: (p_rowid => l_rowid
2262: ,p_input_value_id => l_input_value_id
2263: ,p_effective_start_date => p_effective_date
2264: ,p_effective_end_date => hr_api.g_eot
2265: ,p_element_type_id => l_element_type_id
2266: ,p_lookup_type => p_input_values(i).lookup_type
2267: ,p_business_group_id => p_business_group_id
2268: ,p_legislation_code => null

Line 2387: ,x_effective_end_date => hr_api.g_eot

2383: pay_balance_feeds_f_pkg.insert_row
2384: (x_rowid => l_rowid
2385: ,x_balance_feed_id => l_balance_feed_id
2386: ,x_effective_start_date => p_effective_date
2387: ,x_effective_end_date => hr_api.g_eot
2388: ,x_business_group_id => p_business_group_id
2389: ,x_legislation_code => null
2390: ,x_balance_type_id => l_balance_type_id
2391: ,x_input_value_id => l_input_value_id

Line 2549: ,p_effective_end_date => hr_api.g_eot

2545: pay_formula_result_rules_pkg.insert_row
2546: (p_rowid => l_rowid
2547: ,p_formula_result_rule_id => l_formula_result_rule_id
2548: ,p_effective_start_date => p_effective_date
2549: ,p_effective_end_date => hr_api.g_eot
2550: ,p_business_group_id => p_business_group_id
2551: ,p_legislation_code => null
2552: ,p_element_type_id => l_element_type_id
2553: ,p_status_processing_rule_id => l_status_processing_rule_id

Line 2560: ,p_session_date => hr_api.g_sys

2556: ,p_legislation_subgroup => null
2557: ,p_severity_level => p_formula_rules(i).severity_level
2558: ,p_input_value_id => l_input_value_id
2559: ,p_created_by => -1
2560: ,p_session_date => hr_api.g_sys
2561: );
2562: --
2563: -- Set up the core object table rows.
2564: --

Line 2900: ,p_end_date => hr_api.g_eot

2896: --
2897: hr_utility.set_location(l_proc, 30);
2898: pay_gbe_ins.ins
2899: (p_start_date => p_effective_date
2900: ,p_end_date => hr_api.g_eot
2901: ,p_source_id => l_source_id
2902: ,p_source_type => p_gu_bal_exclusions(i).source_type
2903: ,p_balance_type_id => l_balance_type_id
2904: ,p_grossup_balances_id => l_grossup_balances_id

Line 3119: hr_api.return_legislation_code(l_business_group_id);

3115: hr_utility.set_location(l_proc, 30);
3116: get_formula_types;
3117: l_business_group_id := l_element_template.business_group_id;
3118: l_legislation_code :=
3119: hr_api.return_legislation_code(l_business_group_id);
3120: hr_general.assert_condition(l_legislation_code is not null);
3121: ---------------------------------
3122: -- At last, do the generation! --
3123: ---------------------------------

Line 3391: hr_api.return_legislation_code(l_business_group_id);

3387: );
3388: --
3389: l_business_group_id := l_element_template.business_group_id;
3390: l_legislation_code :=
3391: hr_api.return_legislation_code(l_business_group_id);
3392: --
3393: get_formula_types;
3394: -----------------------------------------------
3395: -- Read in information on generated objects. --

Line 4122: ,p_validation_start_date => hr_api.g_sot

4118: pay_sub_class_rules_pkg.delete_row
4119: (p_rowid => p_rowid_id_recs(i).rowid
4120: ,p_sub_classification_rule_id => p_rowid_id_recs(i).id
4121: ,p_delete_mode => g_zap_deletion_mode
4122: ,p_validation_start_date => hr_api.g_sot
4123: ,p_validation_end_date => hr_api.g_eot
4124: );
4125: --
4126: i := p_rowid_id_recs.next(i);

Line 4123: ,p_validation_end_date => hr_api.g_eot

4119: (p_rowid => p_rowid_id_recs(i).rowid
4120: ,p_sub_classification_rule_id => p_rowid_id_recs(i).id
4121: ,p_delete_mode => g_zap_deletion_mode
4122: ,p_validation_start_date => hr_api.g_sot
4123: ,p_validation_end_date => hr_api.g_eot
4124: );
4125: --
4126: i := p_rowid_id_recs.next(i);
4127: end loop;

Line 4174: ,p_validation_start_date => hr_api.g_sot

4170: (p_rowid => p_rowid_id_recs(i).rowid
4171: ,p_input_value_id => p_rowid_id_recs(i).id
4172: ,p_delete_mode => g_zap_deletion_mode
4173: ,p_session_date => p_rowid_id_recs(i).effective_date
4174: ,p_validation_start_date => hr_api.g_sot
4175: ,p_validation_end_date => hr_api.g_eot
4176: );
4177: l_id := p_rowid_id_recs(i).id;
4178: end if;

Line 4175: ,p_validation_end_date => hr_api.g_eot

4171: ,p_input_value_id => p_rowid_id_recs(i).id
4172: ,p_delete_mode => g_zap_deletion_mode
4173: ,p_session_date => p_rowid_id_recs(i).effective_date
4174: ,p_validation_start_date => hr_api.g_sot
4175: ,p_validation_end_date => hr_api.g_eot
4176: );
4177: l_id := p_rowid_id_recs(i).id;
4178: end if;
4179: --

Line 4391: ,x_validation_start_date => hr_api.g_sot

4387: ff_formulas_f_pkg.delete_row
4388: (x_rowid => p_rowid_id_recs(i).rowid
4389: ,x_formula_id => l_formula_id
4390: ,x_dt_delete_mode => g_zap_deletion_mode
4391: ,x_validation_start_date => hr_api.g_sot
4392: ,x_validation_end_date => hr_api.g_eot
4393: );
4394: --
4395: l_formula_id := p_rowid_id_recs(i).id;

Line 4392: ,x_validation_end_date => hr_api.g_eot

4388: (x_rowid => p_rowid_id_recs(i).rowid
4389: ,x_formula_id => l_formula_id
4390: ,x_dt_delete_mode => g_zap_deletion_mode
4391: ,x_validation_start_date => hr_api.g_sot
4392: ,x_validation_end_date => hr_api.g_eot
4393: );
4394: --
4395: l_formula_id := p_rowid_id_recs(i).id;
4396: end if;