APPS.PAY_RFM_SHD dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 79: from pay_report_format_mappings_f

75: ,business_group_id
76: ,legislation_code
77: ,temporary_action_flag
78: ,object_version_number
79: from pay_report_format_mappings_f
80: where report_format_mapping_id = p_report_format_mapping_id
81: and p_effective_date
82: between effective_start_date and effective_end_date;
83: --

Line 155: ,p_base_table_name => 'pay_report_format_mappings_f'

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

Line 189: ,p_base_table_name => 'pay_report_format_mappings_f'

185: -- Call the corresponding datetrack api
186: --
187: dt_api.find_dt_del_modes
188: (p_effective_date => p_effective_date
189: ,p_base_table_name => 'pay_report_format_mappings_f'
190: ,p_base_key_column => 'report_format_mapping_id'
191: ,p_base_key_value => p_base_key_value
192: ,p_zap => p_zap
193: ,p_delete => p_delete

Line 224: (p_base_table_name => 'pay_report_format_mappings_f'

220: -- version number.
221: --
222: l_object_version_number :=
223: dt_api.get_object_version_number
224: (p_base_table_name => 'pay_report_format_mappings_f'
225: ,p_base_key_column => 'report_format_mapping_id'
226: ,p_base_key_value => p_base_key_value
227: );
228: --

Line 235: update pay_report_format_mappings_f t

231: --
232: -- Update the specified datetrack row setting the effective
233: -- end date to the specified new effective end date.
234: --
235: update pay_report_format_mappings_f t
236: set t.effective_end_date = p_new_effective_end_date
237: , t.object_version_number = l_object_version_number
238: where t.report_format_mapping_id = p_base_key_value
239: and p_effective_date

Line 295: from pay_report_format_mappings_f

291: ,business_group_id
292: ,legislation_code
293: ,temporary_action_flag
294: ,object_version_number
295: from pay_report_format_mappings_f
296: where report_format_mapping_id = p_report_format_mapping_id
297: and p_effective_date
298: between effective_start_date and effective_end_date
299: for update nowait;

Line 358: ,p_base_table_name => 'pay_report_format_mappings_f'

354: --
355: dt_api.validate_dt_mode
356: (p_effective_date => p_effective_date
357: ,p_datetrack_mode => p_datetrack_mode
358: ,p_base_table_name => 'pay_report_format_mappings_f'
359: ,p_base_key_column => 'report_format_mapping_id'
360: ,p_base_key_value => p_report_format_mapping_id
361: ,p_enforce_foreign_locking => true
362: ,p_validation_start_date => l_validation_start_date

Line 393: fnd_message.set_token('TABLE_NAME', 'pay_report_format_mappings_f');

389: -- The object is locked therefore we need to supply a meaningful
390: -- error message.
391: --
392: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
393: fnd_message.set_token('TABLE_NAME', 'pay_report_format_mappings_f');
394: fnd_message.raise_error;
395: End lck;
396: --
397: -- ----------------------------------------------------------------------------

Line 469: from pay_report_format_mappings_f

465: Return number is
466: --
467: cursor csr_format_mapping_id is
468: select distinct report_format_mapping_id
469: from pay_report_format_mappings_f
470: where report_type = p_report_type
471: and report_qualifier = p_report_qualifier
472: and report_category = p_report_category;
473: --

Line 475: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;

471: and report_qualifier = p_report_qualifier
472: and report_category = p_report_category;
473: --
474: l_proc varchar2(72) := g_package||'get_report_format_mapping_id';
475: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;
476: --
477: Begin
478: --
479: hr_utility.set_location('Entering:'||l_proc, 5);