APPS.PAY_IVL_SHD dependencies on PAY_INPUT_VALUES_F

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

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

Line 37: ElsIf (p_constraint_name = 'PAY_INPUT_VALUES_F_UK2') 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_INPUT_VALUES_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;

Line 110: from pay_input_values_f

106: ,max_value
107: ,min_value
108: ,warning_or_error
109: ,object_version_number
110: from pay_input_values_f
111: where input_value_id = p_input_value_id
112: and p_effective_date
113: between effective_start_date and effective_end_date;
114: --

Line 186: ,p_base_table_name => 'pay_input_values_f'

182: -- Call the corresponding datetrack api
183: --
184: dt_api.find_dt_upd_modes
185: (p_effective_date => p_effective_date
186: ,p_base_table_name => 'pay_input_values_f'
187: ,p_base_key_column => 'input_value_id'
188: ,p_base_key_value => p_base_key_value
189: ,p_correction => p_correction
190: ,p_update => p_update

Line 217: from pay_input_values_f t

213: --
214: Cursor C_Sel1 Is
215: select
216: t.element_type_id
217: from pay_input_values_f t
218: where t.input_value_id = p_base_key_value
219: and p_effective_date
220: between t.effective_start_date and t.effective_end_date;
221: --

Line 240: ,p_base_table_name => 'pay_input_values_f'

236: -- Call the corresponding datetrack api
237: --
238: dt_api.find_dt_del_modes
239: (p_effective_date => p_effective_date
240: ,p_base_table_name => 'pay_input_values_f'
241: ,p_base_key_column => 'input_value_id'
242: ,p_base_key_value => p_base_key_value
243: ,p_parent_table_name1 => 'pay_element_types_f'
244: ,p_parent_key_column1 => 'element_type_id'

Line 278: (p_base_table_name => 'pay_input_values_f'

274: -- version number.
275: --
276: l_object_version_number :=
277: dt_api.get_object_version_number
278: (p_base_table_name => 'pay_input_values_f'
279: ,p_base_key_column => 'input_value_id'
280: ,p_base_key_value => p_base_key_value
281: );
282: --

Line 289: update pay_input_values_f t

285: --
286: -- Update the specified datetrack row setting the effective
287: -- end date to the specified new effective end date.
288: --
289: update pay_input_values_f t
290: set t.effective_end_date = p_new_effective_end_date
291: , t.object_version_number = l_object_version_number
292: where t.input_value_id = p_base_key_value
293: and p_effective_date

Line 350: from pay_input_values_f

346: ,max_value
347: ,min_value
348: ,warning_or_error
349: ,object_version_number
350: from pay_input_values_f
351: where input_value_id = p_input_value_id
352: and p_effective_date
353: between effective_start_date and effective_end_date
354: for update nowait;

Line 413: ,p_base_table_name => 'pay_input_values_f'

409: --
410: dt_api.validate_dt_mode
411: (p_effective_date => p_effective_date
412: ,p_datetrack_mode => p_datetrack_mode
413: ,p_base_table_name => 'pay_input_values_f'
414: ,p_base_key_column => 'input_value_id'
415: ,p_base_key_value => p_input_value_id
416: ,p_parent_table_name1 => 'pay_element_types_f'
417: ,p_parent_key_column1 => 'element_type_id'

Line 457: fnd_message.set_token('TABLE_NAME', 'pay_input_values_f');

453: -- The object is locked therefore we need to supply a meaningful
454: -- error message.
455: --
456: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
457: fnd_message.set_token('TABLE_NAME', 'pay_input_values_f');
458: fnd_message.raise_error;
459: End lck;
460: --
461: -- ----------------------------------------------------------------------------