APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on HR_API

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

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

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

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

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

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

Line 1072: l_last_update_date := hr_api.g_sys;

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

Line 1091: ,x_effective_end_date => hr_api.g_eot

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

Line 1576: ,p_val_end_date => hr_api.g_eot

1572: hr_elements.chk_element_type
1573: (p_element_name => p_element_types(i).element_name
1574: ,p_element_type_id => null
1575: ,p_val_start_date => p_effective_date
1576: ,p_val_end_date => hr_api.g_eot
1577: ,p_reporting_name => p_element_types(i).reporting_name
1578: ,p_rowid => null
1579: ,p_recurring_flag => p_element_types(i).processing_type
1580: ,p_standard_flag => p_element_types(i).standard_link_flag

Line 1602: ,p_effective_end_date => hr_api.g_eot

1598: pay_element_types_pkg.insert_row
1599: (p_rowid => l_rowid
1600: ,p_element_type_id => l_element_type_id
1601: ,p_effective_start_date => p_effective_date
1602: ,p_effective_end_date => hr_api.g_eot
1603: ,p_business_group_id => p_business_group_id
1604: ,p_legislation_code => null
1605: ,p_formula_id => l_formula_id
1606: ,p_input_currency_code => p_element_types(i).input_currency_code

Line 1739: ,x_effective_end_date => hr_api.g_eot

1735: pay_status_rules_pkg.insert_row
1736: (x_rowid => l_rowid
1737: ,x_status_processing_rule_id => l_status_processing_rule_id
1738: ,x_effective_start_date => p_effective_date
1739: ,x_effective_end_date => hr_api.g_eot
1740: ,x_business_group_id => p_business_group_id
1741: ,x_legislation_code => null
1742: ,x_element_type_id => l_element_type_id
1743: ,x_assignment_status_type_id => null

Line 1748: ,x_last_update_date => hr_api.g_sys

1744: ,x_formula_id => l_formula_id
1745: ,x_processing_rule => 'P'
1746: ,x_comment_id => null
1747: ,x_legislation_subgroup => null
1748: ,x_last_update_date => hr_api.g_sys
1749: ,x_last_updated_by => -1
1750: ,x_last_update_login => -1
1751: ,x_created_by => -1
1752: ,x_creation_date => hr_api.g_sys

Line 1752: ,x_creation_date => hr_api.g_sys

1748: ,x_last_update_date => hr_api.g_sys
1749: ,x_last_updated_by => -1
1750: ,x_last_update_login => -1
1751: ,x_created_by => -1
1752: ,x_creation_date => hr_api.g_sys
1753: );
1754: --
1755: -- Set up the core object table rows.
1756: --

Line 1936: ,p_effective_end_date => hr_api.g_eot

1932: pay_sub_class_rules_pkg.insert_row
1933: (p_rowid => l_rowid
1934: ,p_sub_classification_rule_id => l_sub_classification_rule_id
1935: ,p_effective_start_date => p_effective_date
1936: ,p_effective_end_date => hr_api.g_eot
1937: ,p_element_type_id => l_element_type_id
1938: ,p_classification_id => l_ele_classification_id
1939: ,p_business_group_id => p_business_group_id
1940: ,p_legislation_code => null

Line 1941: ,p_last_update_date => hr_api.g_sys

1937: ,p_element_type_id => l_element_type_id
1938: ,p_classification_id => l_ele_classification_id
1939: ,p_business_group_id => p_business_group_id
1940: ,p_legislation_code => null
1941: ,p_last_update_date => hr_api.g_sys
1942: ,p_last_updated_by => -1
1943: ,p_last_update_login => -1
1944: ,p_created_by => -1
1945: ,p_creation_date => hr_api.g_sys

Line 1945: ,p_creation_date => hr_api.g_sys

1941: ,p_last_update_date => hr_api.g_sys
1942: ,p_last_updated_by => -1
1943: ,p_last_update_login => -1
1944: ,p_created_by => -1
1945: ,p_creation_date => hr_api.g_sys
1946: );
1947: --
1948: -- Set up the core object table rows.
1949: --

Line 2282: ,p_effective_end_date => hr_api.g_eot

2278: pay_input_values_pkg.insert_row
2279: (p_rowid => l_rowid
2280: ,p_input_value_id => l_input_value_id
2281: ,p_effective_start_date => p_effective_date
2282: ,p_effective_end_date => hr_api.g_eot
2283: ,p_element_type_id => l_element_type_id
2284: ,p_lookup_type => p_input_values(i).lookup_type
2285: ,p_business_group_id => p_business_group_id
2286: ,p_legislation_code => null

Line 2405: ,x_effective_end_date => hr_api.g_eot

2401: pay_balance_feeds_f_pkg.insert_row
2402: (x_rowid => l_rowid
2403: ,x_balance_feed_id => l_balance_feed_id
2404: ,x_effective_start_date => p_effective_date
2405: ,x_effective_end_date => hr_api.g_eot
2406: ,x_business_group_id => p_business_group_id
2407: ,x_legislation_code => null
2408: ,x_balance_type_id => l_balance_type_id
2409: ,x_input_value_id => l_input_value_id

Line 2567: ,p_effective_end_date => hr_api.g_eot

2563: pay_formula_result_rules_pkg.insert_row
2564: (p_rowid => l_rowid
2565: ,p_formula_result_rule_id => l_formula_result_rule_id
2566: ,p_effective_start_date => p_effective_date
2567: ,p_effective_end_date => hr_api.g_eot
2568: ,p_business_group_id => p_business_group_id
2569: ,p_legislation_code => null
2570: ,p_element_type_id => l_element_type_id
2571: ,p_status_processing_rule_id => l_status_processing_rule_id

Line 2578: ,p_session_date => hr_api.g_sys

2574: ,p_legislation_subgroup => null
2575: ,p_severity_level => p_formula_rules(i).severity_level
2576: ,p_input_value_id => l_input_value_id
2577: ,p_created_by => -1
2578: ,p_session_date => hr_api.g_sys
2579: );
2580: --
2581: -- Set up the core object table rows.
2582: --

Line 2918: ,p_end_date => hr_api.g_eot

2914: --
2915: hr_utility.set_location(l_proc, 30);
2916: pay_gbe_ins.ins
2917: (p_start_date => p_effective_date
2918: ,p_end_date => hr_api.g_eot
2919: ,p_source_id => l_source_id
2920: ,p_source_type => p_gu_bal_exclusions(i).source_type
2921: ,p_balance_type_id => l_balance_type_id
2922: ,p_grossup_balances_id => l_grossup_balances_id

Line 3137: hr_api.return_legislation_code(l_business_group_id);

3133: hr_utility.set_location(l_proc, 30);
3134: get_formula_types;
3135: l_business_group_id := l_element_template.business_group_id;
3136: l_legislation_code :=
3137: hr_api.return_legislation_code(l_business_group_id);
3138: hr_general.assert_condition(l_legislation_code is not null);
3139: ---------------------------------
3140: -- At last, do the generation! --
3141: ---------------------------------

Line 3409: hr_api.return_legislation_code(l_business_group_id);

3405: );
3406: --
3407: l_business_group_id := l_element_template.business_group_id;
3408: l_legislation_code :=
3409: hr_api.return_legislation_code(l_business_group_id);
3410: --
3411: get_formula_types;
3412: -----------------------------------------------
3413: -- Read in information on generated objects. --

Line 4140: ,p_validation_start_date => hr_api.g_sot

4136: pay_sub_class_rules_pkg.delete_row
4137: (p_rowid => p_rowid_id_recs(i).rowid
4138: ,p_sub_classification_rule_id => p_rowid_id_recs(i).id
4139: ,p_delete_mode => g_zap_deletion_mode
4140: ,p_validation_start_date => hr_api.g_sot
4141: ,p_validation_end_date => hr_api.g_eot
4142: );
4143: --
4144: i := p_rowid_id_recs.next(i);

Line 4141: ,p_validation_end_date => hr_api.g_eot

4137: (p_rowid => p_rowid_id_recs(i).rowid
4138: ,p_sub_classification_rule_id => p_rowid_id_recs(i).id
4139: ,p_delete_mode => g_zap_deletion_mode
4140: ,p_validation_start_date => hr_api.g_sot
4141: ,p_validation_end_date => hr_api.g_eot
4142: );
4143: --
4144: i := p_rowid_id_recs.next(i);
4145: end loop;

Line 4192: ,p_validation_start_date => hr_api.g_sot

4188: (p_rowid => p_rowid_id_recs(i).rowid
4189: ,p_input_value_id => p_rowid_id_recs(i).id
4190: ,p_delete_mode => g_zap_deletion_mode
4191: ,p_session_date => p_rowid_id_recs(i).effective_date
4192: ,p_validation_start_date => hr_api.g_sot
4193: ,p_validation_end_date => hr_api.g_eot
4194: );
4195: l_id := p_rowid_id_recs(i).id;
4196: end if;

Line 4193: ,p_validation_end_date => hr_api.g_eot

4189: ,p_input_value_id => p_rowid_id_recs(i).id
4190: ,p_delete_mode => g_zap_deletion_mode
4191: ,p_session_date => p_rowid_id_recs(i).effective_date
4192: ,p_validation_start_date => hr_api.g_sot
4193: ,p_validation_end_date => hr_api.g_eot
4194: );
4195: l_id := p_rowid_id_recs(i).id;
4196: end if;
4197: --

Line 4409: ,x_validation_start_date => hr_api.g_sot

4405: ff_formulas_f_pkg.delete_row
4406: (x_rowid => p_rowid_id_recs(i).rowid
4407: ,x_formula_id => l_formula_id
4408: ,x_dt_delete_mode => g_zap_deletion_mode
4409: ,x_validation_start_date => hr_api.g_sot
4410: ,x_validation_end_date => hr_api.g_eot
4411: );
4412: --
4413: l_formula_id := p_rowid_id_recs(i).id;

Line 4410: ,x_validation_end_date => hr_api.g_eot

4406: (x_rowid => p_rowid_id_recs(i).rowid
4407: ,x_formula_id => l_formula_id
4408: ,x_dt_delete_mode => g_zap_deletion_mode
4409: ,x_validation_start_date => hr_api.g_sot
4410: ,x_validation_end_date => hr_api.g_eot
4411: );
4412: --
4413: l_formula_id := p_rowid_id_recs(i).id;
4414: end if;