APPS.PAY_RFI_SHD dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 71: from pay_report_format_items_f

67: ,display_sequence
68: ,object_version_number
69: ,report_format_item_id
70: ,null
71: from pay_report_format_items_f
72: where report_format_item_id = p_report_format_item_id
73: and p_effective_date
74: between effective_start_date and effective_end_date;
75: --

Line 154: ,p_base_table_name => 'pay_report_format_items_f'

150: -- Call the corresponding datetrack api
151: --
152: dt_api.find_dt_upd_modes
153: (p_effective_date => p_effective_date
154: ,p_base_table_name => 'pay_report_format_items_f'
155: ,p_base_key_column => 'report_format_item_id'
156: ,p_base_key_value => p_base_key_value
157: ,p_correction => p_correction
158: ,p_update => p_update

Line 185: from pay_report_format_items_f t

181: --
182: Cursor C_Sel1 Is
183: select
184: m.report_format_mapping_id
185: from pay_report_format_items_f t
186: ,pay_report_format_mappings_f m
187: where t.report_format_item_id = p_base_key_value
188: and p_effective_date
189: between t.effective_start_date and t.effective_end_date

Line 214: ,p_base_table_name => 'pay_report_format_items_f'

210: -- Call the corresponding datetrack api
211: --
212: dt_api.find_dt_del_modes
213: (p_effective_date => p_effective_date
214: ,p_base_table_name => 'pay_report_format_items_f'
215: ,p_base_key_column => 'report_format_item_id'
216: ,p_base_key_value => p_base_key_value
217: ,p_parent_table_name1 => 'pay_report_format_mappings_f'
218: ,p_parent_key_column1 => 'report_format_mapping_id'

Line 252: (p_base_table_name => 'pay_report_format_items_f'

248: -- version number.
249: --
250: l_object_version_number :=
251: dt_api.get_object_version_number
252: (p_base_table_name => 'pay_report_format_items_f'
253: ,p_base_key_column => 'report_format_item_id'
254: ,p_base_key_value => p_base_key_value
255: );
256: --

Line 263: update pay_report_format_items_f t

259: --
260: -- Update the specified datetrack row setting the effective
261: -- end date to the specified new effective end date.
262: --
263: update pay_report_format_items_f t
264: set t.effective_end_date = p_new_effective_end_date
265: , t.object_version_number = l_object_version_number
266: where t.report_format_item_id = p_base_key_value
267: and p_effective_date

Line 315: from pay_report_format_items_f

311: ,display_sequence
312: ,object_version_number
313: ,report_format_item_id
314: ,null
315: from pay_report_format_items_f
316: where report_format_item_id = p_report_format_item_id
317: and p_effective_date
318: between effective_start_date and effective_end_date
319: for update nowait;

Line 386: ,p_base_table_name => 'pay_report_format_items_f'

382: --
383: dt_api.validate_dt_mode
384: (p_effective_date => p_effective_date
385: ,p_datetrack_mode => p_datetrack_mode
386: ,p_base_table_name => 'pay_report_format_items_f'
387: ,p_base_key_column => 'report_format_item_id'
388: ,p_base_key_value => p_report_format_item_id
389: ,p_parent_table_name1 => 'pay_report_format_mappings_f'
390: ,p_parent_key_column1 => 'report_format_mapping_id'

Line 424: fnd_message.set_token('TABLE_NAME', 'pay_report_format_items_f');

420: -- The object is locked therefore we need to supply a meaningful
421: -- error message.
422: --
423: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
424: fnd_message.set_token('TABLE_NAME', 'pay_report_format_items_f');
425: fnd_message.raise_error;
426: End lck;
427: --
428: -- ----------------------------------------------------------------------------

Line 485: from pay_report_format_items_f

481: Return number is
482: --
483: cursor csr_format_item_id is
484: select distinct report_format_item_id
485: from pay_report_format_items_f
486: where report_type = p_report_type
487: and report_qualifier = p_report_qualifier
488: and report_category = p_report_category
489: and user_entity_id = p_user_entity_id ;

Line 492: l_report_format_item_id PAY_REPORT_FORMAT_ITEMS_F.REPORT_FORMAT_ITEM_ID%TYPE;

488: and report_category = p_report_category
489: and user_entity_id = p_user_entity_id ;
490: --
491: l_proc varchar2(72) := g_package||'get_report_format_item_id';
492: l_report_format_item_id PAY_REPORT_FORMAT_ITEMS_F.REPORT_FORMAT_ITEM_ID%TYPE;
493: --
494: Begin
495: --
496: hr_utility.set_location('Entering:'||l_proc, 5);