APPS.PAY_LIV_SHD dependencies on PAY_LINK_INPUT_VALUES_F

Line 37: ElsIf (p_constraint_name = 'PAY_LINK_INPUT_VALUES_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_LINK_INPUT_VALUES_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_LINK_INPUT_VALUES_F_U50') 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_LINK_INPUT_VALUES_F_U50') 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 85: from pay_link_input_values_f

81: ,max_value
82: ,min_value
83: ,warning_or_error
84: ,object_version_number
85: from pay_link_input_values_f
86: where link_input_value_id = p_link_input_value_id
87: and p_effective_date
88: between effective_start_date and effective_end_date;
89: --

Line 161: ,p_base_table_name => 'pay_link_input_values_f'

157: -- Call the corresponding datetrack api
158: --
159: dt_api.find_dt_upd_modes
160: (p_effective_date => p_effective_date
161: ,p_base_table_name => 'pay_link_input_values_f'
162: ,p_base_key_column => 'link_input_value_id'
163: ,p_base_key_value => p_base_key_value
164: ,p_correction => p_correction
165: ,p_update => p_update

Line 194: from pay_link_input_values_f t

190: Cursor C_Sel1 Is
191: select
192: t.input_value_id
193: ,t.element_link_id
194: from pay_link_input_values_f t
195: where t.link_input_value_id = p_base_key_value
196: and p_effective_date
197: between t.effective_start_date and t.effective_end_date;
198: --

Line 218: ,p_base_table_name => 'pay_link_input_values_f'

214: -- Call the corresponding datetrack api
215: --
216: dt_api.find_dt_del_modes
217: (p_effective_date => p_effective_date
218: ,p_base_table_name => 'pay_link_input_values_f'
219: ,p_base_key_column => 'link_input_value_id'
220: ,p_base_key_value => p_base_key_value
221: ,p_parent_table_name1 => 'pay_input_values_f'
222: ,p_parent_key_column1 => 'input_value_id'

Line 259: (p_base_table_name => 'pay_link_input_values_f'

255: -- version number.
256: --
257: l_object_version_number :=
258: dt_api.get_object_version_number
259: (p_base_table_name => 'pay_link_input_values_f'
260: ,p_base_key_column => 'link_input_value_id'
261: ,p_base_key_value => p_base_key_value
262: );
263: --

Line 270: update pay_link_input_values_f t

266: --
267: -- Update the specified datetrack row setting the effective
268: -- end date to the specified new effective end date.
269: --
270: update pay_link_input_values_f t
271: set t.effective_end_date = p_new_effective_end_date
272: , t.object_version_number = l_object_version_number
273: where t.link_input_value_id = p_base_key_value
274: and p_effective_date

Line 321: from pay_link_input_values_f

317: ,max_value
318: ,min_value
319: ,warning_or_error
320: ,object_version_number
321: from pay_link_input_values_f
322: where link_input_value_id = p_link_input_value_id
323: and p_effective_date
324: between effective_start_date and effective_end_date
325: for update nowait;

Line 384: ,p_base_table_name => 'pay_link_input_values_f'

380: --
381: dt_api.validate_dt_mode
382: (p_effective_date => p_effective_date
383: ,p_datetrack_mode => p_datetrack_mode
384: ,p_base_table_name => 'pay_link_input_values_f'
385: ,p_base_key_column => 'link_input_value_id'
386: ,p_base_key_value => p_link_input_value_id
387: ,p_parent_table_name1 => 'pay_input_values_f'
388: ,p_parent_key_column1 => 'input_value_id'

Line 425: fnd_message.set_token('TABLE_NAME', 'pay_link_input_values_f');

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