APPS.PAY_PBF_SHD dependencies on PAY_BALANCE_FEEDS_F

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

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_BALANCE_FEEDS_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_BALANCE_FEEDS_F_PK') 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_BALANCE_FEEDS_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;

Line 42: ElsIf (p_constraint_name = 'PAY_BALANCE_FEEDS_F_UK2') 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_BALANCE_FEEDS_F_UK2') 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 79: from pay_balance_feeds_f

75: ,input_value_id
76: ,scale
77: ,legislation_subgroup
78: ,object_version_number
79: from pay_balance_feeds_f
80: where balance_feed_id = p_balance_feed_id
81: and p_effective_date
82: between effective_start_date and effective_end_date;
83: --

Line 159: ,p_base_table_name => 'pay_balance_feeds_f'

155: -- Call the corresponding datetrack api
156: --
157: dt_api.find_dt_upd_modes
158: (p_effective_date => p_effective_date
159: ,p_base_table_name => 'pay_balance_feeds_f'
160: ,p_base_key_column => 'balance_feed_id'
161: ,p_base_key_value => p_base_key_value
162: ,p_correction => p_correction
163: ,p_update => p_update

Line 193: ,p_base_table_name => 'pay_balance_feeds_f'

189: -- Call the corresponding datetrack api
190: --
191: dt_api.find_dt_del_modes
192: (p_effective_date => p_effective_date
193: ,p_base_table_name => 'pay_balance_feeds_f'
194: ,p_base_key_column => 'balance_feed_id'
195: ,p_base_key_value => p_base_key_value
196: ,p_zap => p_zap
197: ,p_delete => p_delete

Line 228: (p_base_table_name => 'pay_balance_feeds_f'

224: -- version number.
225: --
226: l_object_version_number :=
227: dt_api.get_object_version_number
228: (p_base_table_name => 'pay_balance_feeds_f'
229: ,p_base_key_column => 'balance_feed_id'
230: ,p_base_key_value => p_base_key_value
231: );
232: --

Line 239: update pay_balance_feeds_f t

235: --
236: -- Update the specified datetrack row setting the effective
237: -- end date to the specified new effective end date.
238: --
239: update pay_balance_feeds_f t
240: set t.effective_end_date = p_new_effective_end_date
241: , t.object_version_number = l_object_version_number
242: where t.balance_feed_id = p_base_key_value
243: and p_effective_date

Line 289: from pay_balance_feeds_f

285: ,input_value_id
286: ,scale
287: ,legislation_subgroup
288: ,object_version_number
289: from pay_balance_feeds_f
290: where balance_feed_id = p_balance_feed_id
291: and p_effective_date
292: between effective_start_date and effective_end_date
293: for update nowait;

Line 352: ,p_base_table_name => 'pay_balance_feeds_f'

348: --
349: dt_api.validate_dt_mode
350: (p_effective_date => p_effective_date
351: ,p_datetrack_mode => p_datetrack_mode
352: ,p_base_table_name => 'pay_balance_feeds_f'
353: ,p_base_key_column => 'balance_feed_id'
354: ,p_base_key_value => p_balance_feed_id
355: ,p_parent_table_name1 => 'pay_input_values_f'
356: ,p_parent_key_column1 => 'input_value_id'

Line 390: fnd_message.set_token('TABLE_NAME', 'pay_balance_feeds_f');

386: -- The object is locked therefore we need to supply a meaningful
387: -- error message.
388: --
389: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
390: fnd_message.set_token('TABLE_NAME', 'pay_balance_feeds_f');
391: fnd_message.raise_error;
392: End lck;
393: --
394: -- ----------------------------------------------------------------------------