APPS.PAY_ETP_SHD_ND dependencies on PAY_ELEMENT_TYPES_F

Line 87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then

83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;

Line 92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then

88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;

Line 97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then

93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;

Line 102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then

98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;

Line 107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then

103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;

Line 225: from pay_element_types_f

221: ,recalc_event_group_id
222: ,once_each_period_flag
223: ,time_definition_type
224: ,time_definition_id
225: from pay_element_types_f
226: where element_type_id = p_element_type_id
227: and p_effective_date
228: between effective_start_date and effective_end_date;
229: --

Line 301: ,p_base_table_name => 'pay_element_types_f'

297: -- Call the corresponding datetrack api
298: --
299: dt_api.find_dt_upd_modes
300: (p_effective_date => p_effective_date
301: ,p_base_table_name => 'pay_element_types_f'
302: ,p_base_key_column => 'element_type_id'
303: ,p_base_key_value => p_base_key_value
304: ,p_correction => p_correction
305: ,p_update => p_update

Line 335: ,p_base_table_name => 'pay_element_types_f'

331: -- Call the corresponding datetrack api
332: --
333: dt_api.find_dt_del_modes
334: (p_effective_date => p_effective_date
335: ,p_base_table_name => 'pay_element_types_f'
336: ,p_base_key_column => 'element_type_id'
337: ,p_base_key_value => p_base_key_value
338: ,p_zap => p_zap
339: ,p_delete => p_delete

Line 370: (p_base_table_name => 'pay_element_types_f'

366: -- version number.
367: --
368: l_object_version_number :=
369: dt_api.get_object_version_number
370: (p_base_table_name => 'pay_element_types_f'
371: ,p_base_key_column => 'element_type_id'
372: ,p_base_key_value => p_base_key_value
373: );
374: --

Line 381: update pay_element_types_f t

377: --
378: -- Update the specified datetrack row setting the effective
379: -- end date to the specified new effective end date.
380: --
381: update pay_element_types_f t
382: set t.effective_end_date = p_new_effective_end_date
383: , t.object_version_number = l_object_version_number
384: where t.element_type_id = p_base_key_value
385: and p_effective_date

Line 512: from pay_element_types_f

508: ,recalc_event_group_id
509: ,once_each_period_flag
510: ,time_definition_type
511: ,time_definition_id
512: from pay_element_types_f
513: where element_type_id = p_element_type_id
514: and p_effective_date
515: between effective_start_date and effective_end_date
516: for update nowait;

Line 601: ,p_base_table_name => 'pay_element_types_f'

597: --
598: dt_api.validate_dt_mode
599: (p_effective_date => p_effective_date
600: ,p_datetrack_mode => p_datetrack_mode
601: ,p_base_table_name => 'pay_element_types_f'
602: ,p_base_key_column => 'element_type_id'
603: ,p_base_key_value => p_element_type_id
604: ,p_child_table_name1 => 'pay_input_values_f'
605: ,p_child_key_column1 => 'input_value_id'

Line 648: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');

644: -- The object is locked therefore we need to supply a meaningful
645: -- error message.
646: --
647: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
648: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
649: fnd_message.raise_error;
650: End lck;
651: --
652: -- ----------------------------------------------------------------------------