APPS.PAY_UCI_SHD dependencies on PAY_USER_COLUMN_INSTANCES_F

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

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

Line 73: from pay_user_column_instances_f

69: ,business_group_id
70: ,legislation_code
71: ,value
72: ,object_version_number
73: from pay_user_column_instances_f
74: where user_column_instance_id = p_user_column_instance_id
75: and p_effective_date
76: between effective_start_date and effective_end_date;
77: --

Line 149: ,p_base_table_name => 'pay_user_column_instances_f'

145: -- Call the corresponding datetrack api
146: --
147: dt_api.find_dt_upd_modes
148: (p_effective_date => p_effective_date
149: ,p_base_table_name => 'pay_user_column_instances_f'
150: ,p_base_key_column => 'user_column_instance_id'
151: ,p_base_key_value => p_base_key_value
152: ,p_correction => p_correction
153: ,p_update => p_update

Line 180: from pay_user_column_instances_f t

176: --
177: Cursor C_Sel1 Is
178: select
179: t.user_row_id
180: from pay_user_column_instances_f t
181: where t.user_column_instance_id = p_base_key_value
182: and p_effective_date
183: between t.effective_start_date and t.effective_end_date;
184: --

Line 203: ,p_base_table_name => 'pay_user_column_instances_f'

199: -- Call the corresponding datetrack api
200: --
201: dt_api.find_dt_del_modes
202: (p_effective_date => p_effective_date
203: ,p_base_table_name => 'pay_user_column_instances_f'
204: ,p_base_key_column => 'user_column_instance_id'
205: ,p_base_key_value => p_base_key_value
206: ,p_parent_table_name1 => 'pay_user_rows_f'
207: ,p_parent_key_column1 => 'user_row_id'

Line 241: (p_base_table_name => 'pay_user_column_instances_f'

237: -- version number.
238: --
239: l_object_version_number :=
240: dt_api.get_object_version_number
241: (p_base_table_name => 'pay_user_column_instances_f'
242: ,p_base_key_column => 'user_column_instance_id'
243: ,p_base_key_value => p_base_key_value
244: );
245: --

Line 252: update pay_user_column_instances_f t

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

Line 301: from pay_user_column_instances_f

297: ,business_group_id
298: ,legislation_code
299: ,value
300: ,object_version_number
301: from pay_user_column_instances_f
302: where user_column_instance_id = p_user_column_instance_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_user_column_instances_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_user_column_instances_f'
365: ,p_base_key_column => 'user_column_instance_id'
366: ,p_base_key_value => p_user_column_instance_id
367: ,p_parent_table_name1 => 'pay_user_rows_f'
368: ,p_parent_key_column1 => 'user_row_id'

Line 402: fnd_message.set_token('TABLE_NAME', 'pay_user_column_instances_f');

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