APPS.PQH_ACC_SHD dependencies on PQH_ACCOMMODATIONS_F

Line 21: If (p_constraint_name = 'PQH_ACCOMMODATIONS_F_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_ACCOMMODATIONS_F_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 142: from pqh_accommodations_f

138: ,attribute28
139: ,attribute29
140: ,attribute30
141: ,object_version_number
142: from pqh_accommodations_f
143: where accommodation_id = p_accommodation_id
144: and p_effective_date
145: between effective_start_date and effective_end_date;
146: --

Line 218: ,p_base_table_name => 'pqh_accommodations_f'

214: -- Call the corresponding datetrack api
215: --
216: dt_api.find_dt_upd_modes
217: (p_effective_date => p_effective_date
218: ,p_base_table_name => 'pqh_accommodations_f'
219: ,p_base_key_column => 'accommodation_id'
220: ,p_base_key_value => p_base_key_value
221: ,p_correction => p_correction
222: ,p_update => p_update

Line 252: ,p_base_table_name => 'pqh_accommodations_f'

248: -- Call the corresponding datetrack api
249: --
250: dt_api.find_dt_del_modes
251: (p_effective_date => p_effective_date
252: ,p_base_table_name => 'pqh_accommodations_f'
253: ,p_base_key_column => 'accommodation_id'
254: ,p_base_key_value => p_base_key_value
255: ,p_zap => p_zap
256: ,p_delete => p_delete

Line 287: (p_base_table_name => 'pqh_accommodations_f'

283: -- version number.
284: --
285: l_object_version_number :=
286: dt_api.get_object_version_number
287: (p_base_table_name => 'pqh_accommodations_f'
288: ,p_base_key_column => 'accommodation_id'
289: ,p_base_key_value => p_base_key_value
290: );
291: --

Line 298: update pqh_accommodations_f t

294: --
295: -- Update the specified datetrack row setting the effective
296: -- end date to the specified new effective end date.
297: --
298: update pqh_accommodations_f t
299: set t.effective_end_date = p_new_effective_end_date
300: , t.object_version_number = l_object_version_number
301: where t.accommodation_id = p_base_key_value
302: and p_effective_date

Line 427: from pqh_accommodations_f

423: ,attribute28
424: ,attribute29
425: ,attribute30
426: ,object_version_number
427: from pqh_accommodations_f
428: where accommodation_id = p_accommodation_id
429: and p_effective_date
430: between effective_start_date and effective_end_date
431: for update nowait;

Line 490: ,p_base_table_name => 'pqh_accommodations_f'

486: --
487: dt_api.validate_dt_mode
488: (p_effective_date => p_effective_date
489: ,p_datetrack_mode => p_datetrack_mode
490: ,p_base_table_name => 'pqh_accommodations_f'
491: ,p_base_key_column => 'accommodation_id'
492: ,p_base_key_value => p_accommodation_id
493: ,p_child_table_name1 => 'pqh_assign_accommodations_f'
494: ,p_child_key_column1 => 'assignment_acco_id'

Line 528: fnd_message.set_token('TABLE_NAME', 'pqh_accommodations_f');

524: -- The object is locked therefore we need to supply a meaningful
525: -- error message.
526: --
527: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
528: fnd_message.set_token('TABLE_NAME', 'pqh_accommodations_f');
529: fnd_message.raise_error;
530: End lck;
531: --
532: -- ----------------------------------------------------------------------------