DBA Data[Home] [Help]

APPS.PAY_PEL_BUS dependencies on DT_API

Line 407: NOT (dt_api.check_min_max_dates

403: ,p_argument_value => p_validation_end_date
404: );
405: --
406: If ((nvl(p_payroll_id, hr_api.g_number) <> hr_api.g_number) and
407: NOT (dt_api.check_min_max_dates
408: (p_base_table_name => 'pay_all_payrolls_f'
409: ,p_base_key_column => 'PAYROLL_ID'
410: ,p_base_key_value => p_payroll_id
411: ,p_from_date => p_validation_start_date

Line 419: NOT (dt_api.check_min_max_dates

415: hr_multi_message.add
416: (p_associated_column1 => pay_pel_shd.g_tab_nam || '.PAYROLL_ID');
417: End If;
418: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
419: NOT (dt_api.check_min_max_dates
420: (p_base_table_name => 'pay_element_types_f'
421: ,p_base_key_column => 'ELEMENT_TYPE_ID'
422: ,p_base_key_value => p_element_type_id
423: ,p_from_date => p_validation_start_date

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

462: -- Processing continues.
463: --
464: -- Post Failure:
465: -- If a row exists by determining the returning Boolean value from the
466: -- generic dt_api.rows_exist function then we must supply an error via
467: -- the use of the local exception handler l_rows_exist.
468: --
469: -- Developer Implementation Notes:
470: -- This procedure should not need maintenance unless the HR Schema model

Line 524: If (dt_api.rows_exist

520: ,p_argument => 'element_link_id'
521: ,p_argument_value => p_element_link_id
522: );
523: --
524: If (dt_api.rows_exist
525: (p_base_table_name => 'pay_link_input_values_f'
526: ,p_base_key_column => 'element_link_id'
527: ,p_base_key_value => p_element_link_id
528: ,p_from_date => p_validation_start_date

Line 535: If (dt_api.rows_exist

531: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
532: fnd_message.set_token('TABLE_NAME','link input values');
533: hr_multi_message.add;
534: End If;
535: If (dt_api.rows_exist
536: (p_base_table_name => 'pay_element_entries_f'
537: ,p_base_key_column => 'element_link_id'
538: ,p_base_key_value => p_element_link_id
539: ,p_from_date => p_validation_start_date