APPS.PQH_ASA_SHD dependencies on PQH_ASSIGN_ACCOMMODATIONS_F

Line 128: from pqh_assign_accommodations_f

124: ,attribute30
125: ,object_version_number
126: ,reason_for_no_acco
127: ,indemnity_currency
128: from pqh_assign_accommodations_f
129: where assignment_acco_id = p_assignment_acco_id
130: and p_effective_date
131: between effective_start_date and effective_end_date;
132: --

Line 204: ,p_base_table_name => 'pqh_assign_accommodations_f'

200: -- Call the corresponding datetrack api
201: --
202: dt_api.find_dt_upd_modes
203: (p_effective_date => p_effective_date
204: ,p_base_table_name => 'pqh_assign_accommodations_f'
205: ,p_base_key_column => 'assignment_acco_id'
206: ,p_base_key_value => p_base_key_value
207: ,p_correction => p_correction
208: ,p_update => p_update

Line 235: from pqh_assign_accommodations_f t

231: --
232: Cursor C_Sel1 Is
233: select
234: t.accommodation_id
235: from pqh_assign_accommodations_f t
236: where t.assignment_acco_id = p_base_key_value
237: and p_effective_date
238: between t.effective_start_date and t.effective_end_date;
239: --

Line 258: ,p_base_table_name => 'pqh_assign_accommodations_f'

254: -- Call the corresponding datetrack api
255: --
256: dt_api.find_dt_del_modes
257: (p_effective_date => p_effective_date
258: ,p_base_table_name => 'pqh_assign_accommodations_f'
259: ,p_base_key_column => 'assignment_acco_id'
260: ,p_base_key_value => p_base_key_value
261: ,p_parent_table_name1 => 'pqh_accommodations_f'
262: ,p_parent_key_column1 => 'accommodation_id'

Line 296: (p_base_table_name => 'pqh_assign_accommodations_f'

292: -- version number.
293: --
294: l_object_version_number :=
295: dt_api.get_object_version_number
296: (p_base_table_name => 'pqh_assign_accommodations_f'
297: ,p_base_key_column => 'assignment_acco_id'
298: ,p_base_key_value => p_base_key_value
299: );
300: --

Line 307: update pqh_assign_accommodations_f t

303: --
304: -- Update the specified datetrack row setting the effective
305: -- end date to the specified new effective end date.
306: --
307: update pqh_assign_accommodations_f t
308: set t.effective_end_date = p_new_effective_end_date
309: , t.object_version_number = l_object_version_number
310: where t.assignment_acco_id = p_base_key_value
311: and p_effective_date

Line 422: from pqh_assign_accommodations_f

418: ,attribute30
419: ,object_version_number
420: ,reason_for_no_acco
421: ,indemnity_currency
422: from pqh_assign_accommodations_f
423: where assignment_acco_id = p_assignment_acco_id
424: and p_effective_date
425: between effective_start_date and effective_end_date
426: for update nowait;

Line 485: ,p_base_table_name => 'pqh_assign_accommodations_f'

481: --
482: dt_api.validate_dt_mode
483: (p_effective_date => p_effective_date
484: ,p_datetrack_mode => p_datetrack_mode
485: ,p_base_table_name => 'pqh_assign_accommodations_f'
486: ,p_base_key_column => 'assignment_acco_id'
487: ,p_base_key_value => p_assignment_acco_id
488: ,p_parent_table_name1 => 'pqh_accommodations_f'
489: ,p_parent_key_column1 => 'accommodation_id'

Line 523: fnd_message.set_token('TABLE_NAME', 'pqh_assign_accommodations_f');

519: -- The object is locked therefore we need to supply a meaningful
520: -- error message.
521: --
522: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
523: fnd_message.set_token('TABLE_NAME', 'pqh_assign_accommodations_f');
524: fnd_message.raise_error;
525: End lck;
526: --
527: -- ----------------------------------------------------------------------------