APPS.PAY_EVQ_SHD dependencies on PAY_EVENT_QUALIFIERS_F

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

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

64: ,entry_qualification
65: ,assignment_qualification
66: ,multi_event_sql
67: ,object_version_number
68: from pay_event_qualifiers_f
69: where event_qualifier_id = p_event_qualifier_id
70: and p_effective_date
71: between effective_start_date and effective_end_date;
72: --

Line 144: ,p_base_table_name => 'pay_event_qualifiers_f'

140: -- Call the corresponding datetrack api
141: --
142: dt_api.find_dt_upd_modes
143: (p_effective_date => p_effective_date
144: ,p_base_table_name => 'pay_event_qualifiers_f'
145: ,p_base_key_column => 'event_qualifier_id'
146: ,p_base_key_value => p_base_key_value
147: ,p_correction => p_correction
148: ,p_update => p_update

Line 178: ,p_base_table_name => 'pay_event_qualifiers_f'

174: -- Call the corresponding datetrack api
175: --
176: dt_api.find_dt_del_modes
177: (p_effective_date => p_effective_date
178: ,p_base_table_name => 'pay_event_qualifiers_f'
179: ,p_base_key_column => 'event_qualifier_id'
180: ,p_base_key_value => p_base_key_value
181: ,p_zap => p_zap
182: ,p_delete => p_delete

Line 213: (p_base_table_name => 'pay_event_qualifiers_f'

209: -- version number.
210: --
211: l_object_version_number :=
212: dt_api.get_object_version_number
213: (p_base_table_name => 'pay_event_qualifiers_f'
214: ,p_base_key_column => 'event_qualifier_id'
215: ,p_base_key_value => p_base_key_value
216: );
217: --

Line 224: update pay_event_qualifiers_f t

220: --
221: -- Update the specified datetrack row setting the effective
222: -- end date to the specified new effective end date.
223: --
224: update pay_event_qualifiers_f t
225: set t.effective_end_date = p_new_effective_end_date
226: , t.object_version_number = l_object_version_number
227: where t.event_qualifier_id = p_base_key_value
228: and p_effective_date

Line 274: from pay_event_qualifiers_f

270: ,entry_qualification
271: ,assignment_qualification
272: ,multi_event_sql
273: ,object_version_number
274: from pay_event_qualifiers_f
275: where event_qualifier_id = p_event_qualifier_id
276: and p_effective_date
277: between effective_start_date and effective_end_date
278: for update nowait;

Line 337: ,p_base_table_name => 'pay_event_qualifiers_f'

333: --
334: dt_api.validate_dt_mode
335: (p_effective_date => p_effective_date
336: ,p_datetrack_mode => p_datetrack_mode
337: ,p_base_table_name => 'pay_event_qualifiers_f'
338: ,p_base_key_column => 'event_qualifier_id'
339: ,p_base_key_value => p_event_qualifier_id
340: ,p_child_table_name1 => 'pay_event_value_changes_f'
341: ,p_child_key_column1 => 'event_value_change_id'

Line 375: fnd_message.set_token('TABLE_NAME', 'pay_event_qualifiers_f');

371: -- The object is locked therefore we need to supply a meaningful
372: -- error message.
373: --
374: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
375: fnd_message.set_token('TABLE_NAME', 'pay_event_qualifiers_f');
376: fnd_message.raise_error;
377: End lck;
378: --
379: -- ----------------------------------------------------------------------------