APPS.PAY_ETP_BUS dependencies on DT_API

Line 580: -- generic dt_api.rows_exist function then we must supply an error via

576: -- Processing continues.
577: --
578: -- Post Failure:
579: -- If a row exists by determining the returning Boolean value from the
580: -- generic dt_api.rows_exist function then we must supply an error via
581: -- the use of the local exception handler l_rows_exist.
582: --
583: -- Developer Implementation Notes:
584: -- This procedure should not need maintenance unless the HR Schema model

Line 638: If (dt_api.rows_exist

634: ,p_argument => 'element_type_id'
635: ,p_argument_value => p_element_type_id
636: );
637: --
638: If (dt_api.rows_exist
639: (p_base_table_name => 'pay_input_values_f'
640: ,p_base_key_column => 'element_type_id'
641: ,p_base_key_value => p_element_type_id
642: ,p_from_date => p_validation_start_date

Line 649: If (dt_api.rows_exist

645: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
646: fnd_message.set_token('TABLE_NAME','input values');
647: hr_multi_message.add;
648: End If;
649: If (dt_api.rows_exist
650: (p_base_table_name => 'ben_acty_base_rt_f'
651: ,p_base_key_column => 'element_type_id'
652: ,p_base_key_value => p_element_type_id
653: ,p_from_date => p_validation_start_date

Line 660: If (dt_api.rows_exist

656: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
657: fnd_message.set_token('TABLE_NAME','acty base rt');
658: hr_multi_message.add;
659: End If;
660: If (dt_api.rows_exist
661: (p_base_table_name => 'pay_element_links_f'
662: ,p_base_key_column => 'element_type_id'
663: ,p_base_key_value => p_element_type_id
664: ,p_from_date => p_validation_start_date

Line 671: If (dt_api.rows_exist

667: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
668: fnd_message.set_token('TABLE_NAME','element links');
669: hr_multi_message.add;
670: End If;
671: If (dt_api.rows_exist
672: (p_base_table_name => 'pay_element_type_usages_f'
673: ,p_base_key_column => 'element_type_id'
674: ,p_base_key_value => p_element_type_id
675: ,p_from_date => p_validation_start_date

Line 888: If not (dt_api.rows_exist

884: Begin
885: hr_utility.set_location('Entering:'||l_proc, 5);
886: --
887: If p_formula_id is not null Then
888: If not (dt_api.rows_exist
889: (p_base_table_name => 'FF_FORMULAS_F'
890: ,p_base_key_column => 'FORMULA_ID'
891: ,p_base_key_value => p_formula_id
892: ,p_from_date => p_validation_start_date

Line 2051: If not (dt_api.rows_exist

2047: Begin
2048: hr_utility.set_location('Entering:'||l_proc, 5);
2049: --
2050: If nvl(p_iterative_formula_id,hr_api.g_number) <> hr_api.g_number Then
2051: If not (dt_api.rows_exist
2052: (p_base_table_name => 'FF_FORMULAS_F'
2053: ,p_base_key_column => 'FORMULA_ID'
2054: ,p_base_key_value => p_iterative_formula_id
2055: ,p_from_date => p_validation_start_date

Line 2172: If not (dt_api.rows_exist

2168: Begin
2169: hr_utility.set_location('Entering:'||l_proc, 5);
2170: --
2171: If nvl(p_retro_summ_ele_id,hr_api.g_number) <> hr_api.g_number Then
2172: If not (dt_api.rows_exist
2173: (p_base_table_name => 'PAY_ELEMENT_TYPES_F'
2174: ,p_base_key_column => 'ELEMENT_TYPE_ID'
2175: ,p_base_key_value => p_retro_summ_ele_id
2176: ,p_from_date => p_validation_start_date

Line 2189: If not (dt_api.rows_exist

2185: End If;
2186: End If;
2187: --
2188: If nvl(p_proration_formula_id,hr_api.g_number) <> hr_api.g_number Then
2189: If not (dt_api.rows_exist
2190: (p_base_table_name => 'FF_FORMULAS_F'
2191: ,p_base_key_column => 'FORMULA_ID'
2192: ,p_base_key_value => p_proration_formula_id
2193: ,p_from_date => p_validation_start_date