APPS.PAY_ETP_SHD 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 227: from pay_element_types_f

223: ,time_definition_type
224: ,time_definition_id
225: ,advance_element_type_id
226: ,deduction_element_type_id
227: from pay_element_types_f
228: where element_type_id = p_element_type_id
229: and p_effective_date
230: between effective_start_date and effective_end_date;
231: --

Line 303: ,p_base_table_name => 'pay_element_types_f'

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

Line 337: ,p_base_table_name => 'pay_element_types_f'

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

Line 372: (p_base_table_name => 'pay_element_types_f'

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

Line 383: update pay_element_types_f t

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

Line 516: from pay_element_types_f

512: ,time_definition_type
513: ,time_definition_id
514: ,advance_element_type_id
515: ,deduction_element_type_id
516: from pay_element_types_f
517: where element_type_id = p_element_type_id
518: and p_effective_date
519: between effective_start_date and effective_end_date
520: for update nowait;

Line 605: ,p_base_table_name => 'pay_element_types_f'

601: --
602: dt_api.validate_dt_mode
603: (p_effective_date => p_effective_date
604: ,p_datetrack_mode => p_datetrack_mode
605: ,p_base_table_name => 'pay_element_types_f'
606: ,p_base_key_column => 'element_type_id'
607: ,p_base_key_value => p_element_type_id
608: ,p_child_table_name1 => 'pay_input_values_f'
609: ,p_child_key_column1 => 'input_value_id'

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

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