APPS.PAY_PPR_SHD dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 86: from pay_status_processing_rules_f

82: ,comment_id
83: ,null
84: ,legislation_subgroup
85: ,object_version_number
86: from pay_status_processing_rules_f
87: where status_processing_rule_id = p_status_processing_rule_id
88: and p_effective_date
89: between effective_start_date and effective_end_date;
90: --

Line 162: ,p_base_table_name => 'pay_status_processing_rules_f'

158: -- Call the corresponding datetrack api
159: --
160: dt_api.find_dt_upd_modes
161: (p_effective_date => p_effective_date
162: ,p_base_table_name => 'pay_status_processing_rules_f'
163: ,p_base_key_column => 'status_processing_rule_id'
164: ,p_base_key_value => p_base_key_value
165: ,p_correction => p_correction
166: ,p_update => p_update

Line 196: ,p_base_table_name => 'pay_status_processing_rules_f'

192: -- Call the corresponding datetrack api
193: --
194: dt_api.find_dt_del_modes
195: (p_effective_date => p_effective_date
196: ,p_base_table_name => 'pay_status_processing_rules_f'
197: ,p_base_key_column => 'status_processing_rule_id'
198: ,p_base_key_value => p_base_key_value
199: ,p_zap => p_zap
200: ,p_delete => p_delete

Line 231: (p_base_table_name => 'pay_status_processing_rules_f'

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

Line 242: update pay_status_processing_rules_f t

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

Line 295: from pay_status_processing_rules_f

291: ,comment_id
292: ,null
293: ,legislation_subgroup
294: ,object_version_number
295: from pay_status_processing_rules_f
296: where status_processing_rule_id = p_status_processing_rule_id
297: and p_effective_date
298: between effective_start_date and effective_end_date
299: for update nowait;

Line 384: ,p_base_table_name => 'pay_status_processing_rules_f'

380: --
381: dt_api.validate_dt_mode
382: (p_effective_date => p_effective_date
383: ,p_datetrack_mode => p_datetrack_mode
384: ,p_base_table_name => 'pay_status_processing_rules_f'
385: ,p_base_key_column => 'status_processing_rule_id'
386: ,p_base_key_value => p_status_processing_rule_id
387: ,p_enforce_foreign_locking => true
388: ,p_validation_start_date => l_validation_start_date

Line 420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');

416: -- The object is locked therefore we need to supply a meaningful
417: -- error message.
418: --
419: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');
421: fnd_message.raise_error;
422: End lck;
423: --
424: -- ----------------------------------------------------------------------------