APPS.HR_PSF_BUS dependencies on DT_API

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

5357: p_argument_value => p_datetrack_mode);
5358: --
5359: -- Only perform the validation if the datetrack update mode is valid
5360: --
5361: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
5362: --
5363: --
5364: -- Ensure the arguments are not null
5365: --

Line 5381: NOT (dt_api.check_min_max_dates

5377: if g_debug then
5378: hr_utility.set_location(l_proc,20 );
5379: end if;
5380: If ((nvl(p_relief_position_id, hr_api.g_number) <> hr_api.g_number) and
5381: NOT (dt_api.check_min_max_dates
5382: (p_base_table_name => 'hr_all_positions_f',
5383: p_base_key_column => 'position_id',
5384: p_base_key_value => p_relief_position_id,
5385: p_from_date => p_validation_start_date,

Line 5394: NOT (dt_api.check_min_max_dates

5390: if g_debug then
5391: hr_utility.set_location(l_proc,30 );
5392: end if;
5393: If ((nvl(p_successor_position_id, hr_api.g_number) <> hr_api.g_number) and
5394: NOT (dt_api.check_min_max_dates
5395: (p_base_table_name => 'hr_all_positions_f',
5396: p_base_key_column => 'position_id',
5397: p_base_key_value => p_successor_position_id,
5398: p_from_date => p_validation_start_date,

Line 5407: NOT (dt_api.check_min_max_dates

5403: if g_debug then
5404: hr_utility.set_location(l_proc,40 );
5405: end if;
5406: If ((nvl(p_supervisor_position_id, hr_api.g_number) <> hr_api.g_number) and
5407: NOT (dt_api.check_min_max_dates
5408: (p_base_table_name => 'hr_all_positions_f',
5409: p_base_key_column => 'position_id',
5410: p_base_key_value => p_supervisor_position_id,
5411: p_from_date => p_validation_start_date,

Line 5420: NOT (dt_api.check_min_max_dates

5416: if g_debug then
5417: hr_utility.set_location(l_proc,50 );
5418: end if;
5419: If ((nvl(p_pay_freq_payroll_id, hr_api.g_number) <> hr_api.g_number) and
5420: NOT (dt_api.check_min_max_dates
5421: (p_base_table_name => 'pay_all_payrolls_f',
5422: p_base_key_column => 'payroll_id',
5423: p_base_key_value => p_pay_freq_payroll_id,
5424: p_from_date => p_validation_start_date,

Line 5433: NOT (dt_api.check_min_max_dates

5429: if g_debug then
5430: hr_utility.set_location(l_proc,60 );
5431: end if;
5432: If ((nvl(p_entry_step_id, hr_api.g_number) <> hr_api.g_number) and
5433: NOT (dt_api.check_min_max_dates
5434: (p_base_table_name => 'per_spinal_point_steps_f',
5435: p_base_key_column => 'step_id',
5436: p_base_key_value => p_entry_step_id,
5437: p_from_date => p_validation_start_date,

Line 5446: NOT (dt_api.check_min_max_dates

5442: if g_debug then
5443: hr_utility.set_location(l_proc,70 );
5444: end if;
5445: If ((nvl(p_entry_grade_rule_id, hr_api.g_number) <> hr_api.g_number) and
5446: NOT (dt_api.check_min_max_dates
5447: (p_base_table_name => 'pay_grade_rules_f',
5448: p_base_key_column => 'grade_rule_id',
5449: p_base_key_value => p_entry_grade_rule_id,
5450: p_from_date => p_validation_start_date,

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

5501: -- Processing continues.
5502: --
5503: -- Post Failure:
5504: -- If a row exists by determining the returning Boolean value from the
5505: -- generic dt_api.rows_exist function then we must supply an error via
5506: -- the use of the local exception handler l_rows_exist.
5507: --
5508: -- Developer Implementation Notes:
5509: -- This procedure should not need maintenance unless the HR Schema model

Line 5564: If (dt_api.rows_exist

5560: (p_api_name => l_proc,
5561: p_argument => 'position_id',
5562: p_argument_value => p_position_id);
5563: --
5564: If (dt_api.rows_exist
5565: (p_base_table_name => 'hr_all_positions_f',
5566: p_base_key_column => 'relief_position_id',
5567: p_base_key_value => p_position_id,
5568: p_from_date => p_validation_start_date,

Line 5574: If (dt_api.rows_exist

5570: l_table_name := 'all positions';
5571: Raise l_rows_exist;
5572: End If;
5573:
5574: If (dt_api.rows_exist
5575: (p_base_table_name => 'hr_all_positions_f',
5576: p_base_key_column => 'supervisor_position_id',
5577: p_base_key_value => p_position_id,
5578: p_from_date => p_validation_start_date,

Line 5583: If (dt_api.rows_exist

5579: p_to_date => p_validation_end_date)) Then
5580: l_table_name := 'all positions';
5581: Raise l_rows_exist;
5582: End If;
5583: If (dt_api.rows_exist
5584: (p_base_table_name => 'hr_all_positions_f',
5585: p_base_key_column => 'successor_position_id',
5586: p_base_key_value => p_position_id,
5587: p_from_date => p_validation_start_date,

Line 5593: If (dt_api.rows_exist

5589: l_table_name := 'all positions';
5590: Raise l_rows_exist;
5591: End If;
5592: /*
5593: If (dt_api.rows_exist
5594: (p_base_table_name => 'hr_all_positions_f',
5595: p_base_key_column => 'prior_position_id',
5596: p_base_key_value => p_position_id,
5597: p_from_date => p_validation_start_date,