APPS.PAY_PBC_SHD dependencies on PAY_BALANCE_CATEGORIES_F

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_BALANCE_CATEGORIES_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 27: (p_constraint_name = 'PAY_BALANCE_CATEGORIES_F_UK') Then

23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Elsif
27: (p_constraint_name = 'PAY_BALANCE_CATEGORIES_F_UK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;

Line 94: from pay_balance_categories_f

90: ,pbc_information28
91: ,pbc_information29
92: ,pbc_information30
93: ,object_version_number
94: from pay_balance_categories_f
95: where balance_category_id = p_balance_category_id
96: and p_effective_date
97: between effective_start_date and effective_end_date;
98: --

Line 170: ,p_base_table_name => 'pay_balance_categories_f'

166: -- Call the corresponding datetrack api
167: --
168: dt_api.find_dt_upd_modes
169: (p_effective_date => p_effective_date
170: ,p_base_table_name => 'pay_balance_categories_f'
171: ,p_base_key_column => 'balance_category_id'
172: ,p_base_key_value => p_base_key_value
173: ,p_correction => p_correction
174: ,p_update => p_update

Line 204: ,p_base_table_name => 'pay_balance_categories_f'

200: -- Call the corresponding datetrack api
201: --
202: dt_api.find_dt_del_modes
203: (p_effective_date => p_effective_date
204: ,p_base_table_name => 'pay_balance_categories_f'
205: ,p_base_key_column => 'balance_category_id'
206: ,p_base_key_value => p_base_key_value
207: ,p_zap => p_zap
208: ,p_delete => p_delete

Line 239: (p_base_table_name => 'pay_balance_categories_f'

235: -- version number.
236: --
237: l_object_version_number :=
238: dt_api.get_object_version_number
239: (p_base_table_name => 'pay_balance_categories_f'
240: ,p_base_key_column => 'balance_category_id'
241: ,p_base_key_value => p_base_key_value
242: );
243: --

Line 250: update pay_balance_categories_f t

246: --
247: -- Update the specified datetrack row setting the effective
248: -- end date to the specified new effective end date.
249: --
250: update pay_balance_categories_f t
251: set t.effective_end_date = p_new_effective_end_date
252: , t.object_version_number = l_object_version_number
253: where t.balance_category_id = p_base_key_value
254: and p_effective_date

Line 325: from pay_balance_categories_f

321: ,pbc_information28
322: ,pbc_information29
323: ,pbc_information30
324: ,object_version_number
325: from pay_balance_categories_f
326: where balance_category_id = p_balance_category_id
327: and p_effective_date
328: between effective_start_date and effective_end_date
329: for update nowait;

Line 388: ,p_base_table_name => 'pay_balance_categories_f'

384: --
385: dt_api.validate_dt_mode
386: (p_effective_date => p_effective_date
387: ,p_datetrack_mode => p_datetrack_mode
388: ,p_base_table_name => 'pay_balance_categories_f'
389: ,p_base_key_column => 'balance_category_id'
390: ,p_base_key_value => p_balance_category_id
391: ,p_enforce_foreign_locking => true
392: ,p_validation_start_date => l_validation_start_date

Line 423: fnd_message.set_token('TABLE_NAME', 'pay_balance_categories_f');

419: -- The object is locked therefore we need to supply a meaningful
420: -- error message.
421: --
422: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
423: fnd_message.set_token('TABLE_NAME', 'pay_balance_categories_f');
424: fnd_message.raise_error;
425: End lck;
426: --
427: -- ----------------------------------------------------------------------------