APPS.PAY_CAL_SHD dependencies on PAY_COST_ALLOCATIONS_F

Line 32: If (p_constraint_name = 'PAY_COST_ALLOCATIONS_F_FK1') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_COST_ALLOCATIONS_F_FK1') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 37: ElsIf (p_constraint_name = 'PAY_COST_ALLOCATIONS_F_FK2') Then

33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_COST_ALLOCATIONS_F_FK2') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;

Line 42: ElsIf (p_constraint_name = 'PAY_COST_ALLOCATIONS_F_PK') Then

38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_COST_ALLOCATIONS_F_PK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;

Line 81: from pay_cost_allocations_f

77: ,program_application_id
78: ,program_id
79: ,program_update_date
80: ,object_version_number
81: from pay_cost_allocations_f
82: where cost_allocation_id = p_cost_allocation_id
83: and p_effective_date
84: between effective_start_date and effective_end_date;
85: --

Line 157: ,p_base_table_name => 'pay_cost_allocations_f'

153: -- Call the corresponding datetrack api
154: --
155: dt_api.find_dt_upd_modes
156: (p_effective_date => p_effective_date
157: ,p_base_table_name => 'pay_cost_allocations_f'
158: ,p_base_key_column => 'cost_allocation_id'
159: ,p_base_key_value => p_base_key_value
160: ,p_correction => p_correction
161: ,p_update => p_update

Line 191: ,p_base_table_name => 'pay_cost_allocations_f'

187: -- Call the corresponding datetrack api
188: --
189: dt_api.find_dt_del_modes
190: (p_effective_date => p_effective_date
191: ,p_base_table_name => 'pay_cost_allocations_f'
192: ,p_base_key_column => 'cost_allocation_id'
193: ,p_base_key_value => p_base_key_value
194: ,p_zap => p_zap
195: ,p_delete => p_delete

Line 226: (p_base_table_name => 'pay_cost_allocations_f'

222: -- version number.
223: --
224: l_object_version_number :=
225: dt_api.get_object_version_number
226: (p_base_table_name => 'pay_cost_allocations_f'
227: ,p_base_key_column => 'cost_allocation_id'
228: ,p_base_key_value => p_base_key_value
229: );
230: --

Line 247: update pay_cost_allocations_f t

243: -- Update the specified datetrack row setting the effective
244: -- end date to the specified new effective end date.
245: --
246:
247: update pay_cost_allocations_f t
248: set t.effective_end_date = p_new_effective_end_date
249: , t.object_version_number = l_object_version_number
250: where t.cost_allocation_id = p_base_key_value
251: and p_effective_date

Line 301: from pay_cost_allocations_f

297: ,program_application_id
298: ,program_id
299: ,program_update_date
300: ,object_version_number
301: from pay_cost_allocations_f
302: where cost_allocation_id = p_cost_allocation_id
303: and p_effective_date
304: between effective_start_date and effective_end_date
305: for update nowait;

Line 364: ,p_base_table_name => 'pay_cost_allocations_f'

360: --
361: dt_api.validate_dt_mode
362: (p_effective_date => p_effective_date
363: ,p_datetrack_mode => p_datetrack_mode
364: ,p_base_table_name => 'pay_cost_allocations_f'
365: ,p_base_key_column => 'cost_allocation_id'
366: ,p_base_key_value => p_cost_allocation_id
367: ,p_enforce_foreign_locking => true
368: ,p_validation_start_date => l_validation_start_date

Line 399: fnd_message.set_token('TABLE_NAME', 'pay_cost_allocations_f');

395: -- The object is locked therefore we need to supply a meaningful
396: -- error message.
397: --
398: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
399: fnd_message.set_token('TABLE_NAME', 'pay_cost_allocations_f');
400: fnd_message.raise_error;
401: End lck;
402: --
403: -- ----------------------------------------------------------------------------