APPS.PQP_VAL_SHD dependencies on PQP_VEHICLE_ALLOCATIONS_F

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQP_VEHICLE_ALLOCATIONS_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 112: from pqp_vehicle_allocations_f

108: ,val_information20
109: ,object_version_number
110: ,fuel_benefit
111: ,sliding_rates_info
112: from pqp_vehicle_allocations_f
113: where vehicle_allocation_id = p_vehicle_allocation_id
114: and p_effective_date
115: between effective_start_date and effective_end_date;
116: --

Line 197: ,p_base_table_name => 'pqp_vehicle_allocations_f'

193: -- Call the corresponding datetrack api
194: --
195: dt_api.find_dt_upd_modes
196: (p_effective_date => p_effective_date
197: ,p_base_table_name => 'pqp_vehicle_allocations_f'
198: ,p_base_key_column => 'vehicle_allocation_id'
199: ,p_base_key_value => p_base_key_value
200: ,p_correction => p_correction
201: ,p_update => p_update

Line 231: ,p_base_table_name => 'pqp_vehicle_allocations_f'

227: -- Call the corresponding datetrack api
228: --
229: dt_api.find_dt_del_modes
230: (p_effective_date => p_effective_date
231: ,p_base_table_name => 'pqp_vehicle_allocations_f'
232: ,p_base_key_column => 'vehicle_allocation_id'
233: ,p_base_key_value => p_base_key_value
234: ,p_zap => p_zap
235: ,p_delete => p_delete

Line 266: (p_base_table_name => 'pqp_vehicle_allocations_f'

262: -- version number.
263: --
264: l_object_version_number :=
265: dt_api.get_object_version_number
266: (p_base_table_name => 'pqp_vehicle_allocations_f'
267: ,p_base_key_column => 'vehicle_allocation_id'
268: ,p_base_key_value => p_base_key_value
269: );
270: --

Line 277: update pqp_vehicle_allocations_f t

273: --
274: -- Update the specified datetrack row setting the effective
275: -- end date to the specified new effective end date.
276: --
277: update pqp_vehicle_allocations_f t
278: set t.effective_end_date = p_new_effective_end_date
279: , t.object_version_number = l_object_version_number
280: where t.vehicle_allocation_id = p_base_key_value
281: and p_effective_date

Line 376: from pqp_vehicle_allocations_f

372: ,val_information20
373: ,object_version_number
374: ,fuel_benefit
375: ,sliding_rates_info
376: from pqp_vehicle_allocations_f
377: where vehicle_allocation_id = p_vehicle_allocation_id
378: and p_effective_date
379: between effective_start_date and effective_end_date
380: for update nowait;

Line 439: ,p_base_table_name => 'pqp_vehicle_allocations_f'

435: --
436: dt_api.validate_dt_mode
437: (p_effective_date => p_effective_date
438: ,p_datetrack_mode => p_datetrack_mode
439: ,p_base_table_name => 'pqp_vehicle_allocations_f'
440: ,p_base_key_column => 'vehicle_allocation_id'
441: ,p_base_key_value => p_vehicle_allocation_id
442: ,p_enforce_foreign_locking => true
443: ,p_validation_start_date => l_validation_start_date

Line 474: fnd_message.set_token('TABLE_NAME', 'pqp_vehicle_allocations_f');

470: -- The object is locked therefore we need to supply a meaningful
471: -- error message.
472: --
473: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
474: fnd_message.set_token('TABLE_NAME', 'pqp_vehicle_allocations_f');
475: fnd_message.raise_error;
476: End lck;
477: --
478: -- ----------------------------------------------------------------------------