APPS.PAY_EVC_SHD dependencies on PAY_EVENT_VALUE_CHANGES_F

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_EVENT_VALUE_CHANGES_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 62: from pay_event_value_changes_f

58: ,to_value
59: ,proration_style
60: ,qualifier_value
61: ,object_version_number
62: from pay_event_value_changes_f
63: where event_value_change_id = p_event_value_change_id
64: and p_effective_date
65: between effective_start_date and effective_end_date;
66: --

Line 138: ,p_base_table_name => 'pay_event_value_changes_f'

134: -- Call the corresponding datetrack api
135: --
136: dt_api.find_dt_upd_modes
137: (p_effective_date => p_effective_date
138: ,p_base_table_name => 'pay_event_value_changes_f'
139: ,p_base_key_column => 'event_value_change_id'
140: ,p_base_key_value => p_base_key_value
141: ,p_correction => p_correction
142: ,p_update => p_update

Line 169: from pay_event_value_changes_f t

165: --
166: Cursor C_Sel1 Is
167: select
168: t.event_qualifier_id
169: from pay_event_value_changes_f t
170: where t.event_value_change_id = p_base_key_value
171: and p_effective_date
172: between t.effective_start_date and t.effective_end_date;
173: --

Line 192: ,p_base_table_name => 'pay_event_value_changes_f'

188: -- Call the corresponding datetrack api
189: --
190: dt_api.find_dt_del_modes
191: (p_effective_date => p_effective_date
192: ,p_base_table_name => 'pay_event_value_changes_f'
193: ,p_base_key_column => 'event_value_change_id'
194: ,p_base_key_value => p_base_key_value
195: ,p_parent_table_name1 => 'pay_event_qualifiers_f'
196: ,p_parent_key_column1 => 'event_qualifier_id'

Line 230: (p_base_table_name => 'pay_event_value_changes_f'

226: -- version number.
227: --
228: l_object_version_number :=
229: dt_api.get_object_version_number
230: (p_base_table_name => 'pay_event_value_changes_f'
231: ,p_base_key_column => 'event_value_change_id'
232: ,p_base_key_value => p_base_key_value
233: );
234: --

Line 241: update pay_event_value_changes_f t

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

Line 290: from pay_event_value_changes_f

286: ,to_value
287: ,proration_style
288: ,qualifier_value
289: ,object_version_number
290: from pay_event_value_changes_f
291: where event_value_change_id = p_event_value_change_id
292: and p_effective_date
293: between effective_start_date and effective_end_date
294: for update nowait;

Line 353: ,p_base_table_name => 'pay_event_value_changes_f'

349: --
350: dt_api.validate_dt_mode
351: (p_effective_date => p_effective_date
352: ,p_datetrack_mode => p_datetrack_mode
353: ,p_base_table_name => 'pay_event_value_changes_f'
354: ,p_base_key_column => 'event_value_change_id'
355: ,p_base_key_value => p_event_value_change_id
356: ,p_parent_table_name1 => 'pay_event_qualifiers_f'
357: ,p_parent_key_column1 => 'event_qualifier_id'

Line 391: fnd_message.set_token('TABLE_NAME', 'pay_event_value_changes_f');

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