APPS.PQP_VRE_SHD dependencies on PQP_VEHICLE_REPOSITORY_F

Line 22: IF (p_constraint_name = 'PQP_VEHICLE_REPOSITORY_F_PK') THEN

18: l_proc VARCHAR2(72) := g_package||'constraint_error';
19: --
20: BEGIN
21: --
22: IF (p_constraint_name = 'PQP_VEHICLE_REPOSITORY_F_PK') THEN
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 131: FROM pqp_vehicle_repository_f

127: ,vre_information17
128: ,vre_information18
129: ,vre_information19
130: ,vre_information20
131: FROM pqp_vehicle_repository_f
132: WHERE vehicle_repository_id = p_vehicle_repository_id
133: AND p_effective_date
134: BETWEEN effective_start_date and effective_end_date;
135: --

Line 205: ,p_base_table_name =>'pqp_vehicle_repository_f'

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

Line 239: ,p_base_table_name =>'pqp_vehicle_repository_f'

235: -- Call the corresponding datetrack api
236: --
237: dt_api.find_dt_del_modes
238: (p_effective_date => p_effective_date
239: ,p_base_table_name =>'pqp_vehicle_repository_f'
240: ,p_base_key_column =>'vehicle_repository_id'
241: ,p_base_key_value => p_base_key_value
242: ,p_zap => p_zap
243: ,p_delete => p_delete

Line 274: (p_base_table_name =>'pqp_vehicle_repository_f'

270: -- version number.
271: --
272: l_object_version_number :=
273: dt_api.get_object_version_number
274: (p_base_table_name =>'pqp_vehicle_repository_f'
275: ,p_base_key_column =>'vehicle_repository_id'
276: ,p_base_key_value => p_base_key_value
277: );
278: --

Line 285: UPDATE pqp_vehicle_repository_f t

281: --
282: -- Update the specified datetrack row setting the effective
283: -- end date to the specified new effective end date.
284: --
285: UPDATE pqp_vehicle_repository_f t
286: SET t.effective_end_date = p_new_effective_end_date,
287: t.object_version_number = l_object_version_number
288: WHERE t.vehicle_repository_id = p_base_key_value
289: AND p_effective_date

Line 402: FROM pqp_vehicle_repository_f

398: ,vre_information17
399: ,vre_information18
400: ,vre_information19
401: ,vre_information20
402: FROM pqp_vehicle_repository_f
403: WHERE vehicle_repository_id = p_vehicle_repository_id
404: AND p_effective_date
405: BETWEEN effective_start_date and effective_end_date
406: FOR UPDATE NOWAIT;

Line 465: ,p_base_table_name => 'pqp_vehicle_repository_f'

461: --
462: dt_api.validate_dt_mode
463: (p_effective_date => p_effective_date
464: ,p_datetrack_mode => p_datetrack_mode
465: ,p_base_table_name => 'pqp_vehicle_repository_f'
466: ,p_base_key_column => 'vehicle_repository_id'
467: ,p_base_key_value => p_vehicle_repository_id
468: ,p_enforce_foreign_locking => true
469: ,p_validation_start_date => l_validation_start_date

Line 500: fnd_message.set_token('TABLE_NAME', 'pqp_vehicle_repository_f');

496: -- The object is locked therefore we need to supply a meaningful
497: -- error message.
498: --
499: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
500: fnd_message.set_token('TABLE_NAME', 'pqp_vehicle_repository_f');
501: fnd_message.raise_error;
502: END lck;
503: --
504: -- ----------------------------------------------------------------------------