APPS.PAY_ETP_BUS_ND dependencies on DT_API

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

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

Line 640: If (dt_api.rows_exist

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

Line 651: If (dt_api.rows_exist

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

Line 662: If (dt_api.rows_exist

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

Line 673: If (dt_api.rows_exist

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

Line 890: If not (dt_api.rows_exist

886: Begin
887: hr_utility.set_location('Entering:'||l_proc, 5);
888: --
889: If p_formula_id is not null Then
890: If not (dt_api.rows_exist
891: (p_base_table_name => 'FF_FORMULAS_F'
892: ,p_base_key_column => 'FORMULA_ID'
893: ,p_base_key_value => p_formula_id
894: ,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