APPS.HR_PSF_BUS dependencies on DT_API

Line 5478: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then

5474: p_argument_value => p_datetrack_mode);
5475: --
5476: -- Only perform the validation if the datetrack update mode is valid
5477: --
5478: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
5479: --
5480: --
5481: -- Ensure the arguments are not null
5482: --

Line 5498: NOT (dt_api.check_min_max_dates

5494: if g_debug then
5495: hr_utility.set_location(l_proc,20 );
5496: end if;
5497: If ((nvl(p_relief_position_id, hr_api.g_number) <> hr_api.g_number) and
5498: NOT (dt_api.check_min_max_dates
5499: (p_base_table_name => 'hr_all_positions_f',
5500: p_base_key_column => 'position_id',
5501: p_base_key_value => p_relief_position_id,
5502: p_from_date => p_validation_start_date,

Line 5511: NOT (dt_api.check_min_max_dates

5507: if g_debug then
5508: hr_utility.set_location(l_proc,30 );
5509: end if;
5510: If ((nvl(p_successor_position_id, hr_api.g_number) <> hr_api.g_number) and
5511: NOT (dt_api.check_min_max_dates
5512: (p_base_table_name => 'hr_all_positions_f',
5513: p_base_key_column => 'position_id',
5514: p_base_key_value => p_successor_position_id,
5515: p_from_date => p_validation_start_date,

Line 5524: NOT (dt_api.check_min_max_dates

5520: if g_debug then
5521: hr_utility.set_location(l_proc,40 );
5522: end if;
5523: If ((nvl(p_supervisor_position_id, hr_api.g_number) <> hr_api.g_number) and
5524: NOT (dt_api.check_min_max_dates
5525: (p_base_table_name => 'hr_all_positions_f',
5526: p_base_key_column => 'position_id',
5527: p_base_key_value => p_supervisor_position_id,
5528: p_from_date => p_validation_start_date,

Line 5537: NOT (dt_api.check_min_max_dates

5533: if g_debug then
5534: hr_utility.set_location(l_proc,50 );
5535: end if;
5536: If ((nvl(p_pay_freq_payroll_id, hr_api.g_number) <> hr_api.g_number) and
5537: NOT (dt_api.check_min_max_dates
5538: (p_base_table_name => 'pay_all_payrolls_f',
5539: p_base_key_column => 'payroll_id',
5540: p_base_key_value => p_pay_freq_payroll_id,
5541: p_from_date => p_validation_start_date,

Line 5550: NOT (dt_api.check_min_max_dates

5546: if g_debug then
5547: hr_utility.set_location(l_proc,60 );
5548: end if;
5549: If ((nvl(p_entry_step_id, hr_api.g_number) <> hr_api.g_number) and
5550: NOT (dt_api.check_min_max_dates
5551: (p_base_table_name => 'per_spinal_point_steps_f',
5552: p_base_key_column => 'step_id',
5553: p_base_key_value => p_entry_step_id,
5554: p_from_date => p_validation_start_date,

Line 5563: NOT (dt_api.check_min_max_dates

5559: if g_debug then
5560: hr_utility.set_location(l_proc,70 );
5561: end if;
5562: If ((nvl(p_entry_grade_rule_id, hr_api.g_number) <> hr_api.g_number) and
5563: NOT (dt_api.check_min_max_dates
5564: (p_base_table_name => 'pay_grade_rules_f',
5565: p_base_key_column => 'grade_rule_id',
5566: p_base_key_value => p_entry_grade_rule_id,
5567: p_from_date => p_validation_start_date,

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

5618: -- Processing continues.
5619: --
5620: -- Post Failure:
5621: -- If a row exists by determining the returning Boolean value from the
5622: -- generic dt_api.rows_exist function then we must supply an error via
5623: -- the use of the local exception handler l_rows_exist.
5624: --
5625: -- Developer Implementation Notes:
5626: -- This procedure should not need maintenance unless the HR Schema model

Line 5681: If (dt_api.rows_exist

5677: (p_api_name => l_proc,
5678: p_argument => 'position_id',
5679: p_argument_value => p_position_id);
5680: --
5681: If (dt_api.rows_exist
5682: (p_base_table_name => 'hr_all_positions_f',
5683: p_base_key_column => 'relief_position_id',
5684: p_base_key_value => p_position_id,
5685: p_from_date => p_validation_start_date,

Line 5691: If (dt_api.rows_exist

5687: l_table_name := 'all positions';
5688: Raise l_rows_exist;
5689: End If;
5690:
5691: If (dt_api.rows_exist
5692: (p_base_table_name => 'hr_all_positions_f',
5693: p_base_key_column => 'supervisor_position_id',
5694: p_base_key_value => p_position_id,
5695: p_from_date => p_validation_start_date,

Line 5700: If (dt_api.rows_exist

5696: p_to_date => p_validation_end_date)) Then
5697: l_table_name := 'all positions';
5698: Raise l_rows_exist;
5699: End If;
5700: If (dt_api.rows_exist
5701: (p_base_table_name => 'hr_all_positions_f',
5702: p_base_key_column => 'successor_position_id',
5703: p_base_key_value => p_position_id,
5704: p_from_date => p_validation_start_date,

Line 5710: If (dt_api.rows_exist

5706: l_table_name := 'all positions';
5707: Raise l_rows_exist;
5708: End If;
5709: /*
5710: If (dt_api.rows_exist
5711: (p_base_table_name => 'hr_all_positions_f',
5712: p_base_key_column => 'prior_position_id',
5713: p_base_key_value => p_position_id,
5714: p_from_date => p_validation_start_date,