APPS.PAY_LOADER_UTILS_PKG dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 336: -- This procedure uploads a single row into pay_report_format_mappings_f

332: -- |------------------------------< load_rfm_row >----------------------------|
333: -- ----------------------------------------------------------------------------
334: --
335: -- Description:
336: -- This procedure uploads a single row into pay_report_format_mappings_f
337: -- table. When the first row of a date tracked record is being uploaded
338: -- it checks if the record already exists in the table. If the record already
339: -- exists then all the rows of this record are deleted first and then the
340: -- first row is inserted. All the subsequent rows are uploaded by updating

Line 368: l_business_group_id PAY_REPORT_FORMAT_MAPPINGS_F.BUSINESS_GROUP_ID%TYPE;

364: ,p_owner in varchar2
365: ,p_eof in number ) IS
366: --
367: l_proc varchar2(72) := g_package||'load_rfm_row';
368: l_business_group_id PAY_REPORT_FORMAT_MAPPINGS_F.BUSINESS_GROUP_ID%TYPE;
369: l_rec PAY_RFM_SHD.G_REC_TYPE;
370: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;
371: l_exists varchar2 (1);
372: --

Line 370: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;

366: --
367: l_proc varchar2(72) := g_package||'load_rfm_row';
368: l_business_group_id PAY_REPORT_FORMAT_MAPPINGS_F.BUSINESS_GROUP_ID%TYPE;
369: l_rec PAY_RFM_SHD.G_REC_TYPE;
370: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;
371: l_exists varchar2 (1);
372: --
373: cursor csr_exists is
374: select null

Line 375: from pay_report_format_mappings_f

371: l_exists varchar2 (1);
372: --
373: cursor csr_exists is
374: select null
375: from pay_report_format_mappings_f
376: where report_type = p_report_type
377: and report_qualifier = p_report_qualifier
378: and report_category = p_report_category;
379: --

Line 527: delete from pay_report_format_mappings_f

523: if csr_exists%found then
524:
525: -- Can't do an api delete as child rows may exist.
526:
527: delete from pay_report_format_mappings_f
528: where report_format_mapping_id = l_report_format_mapping_id;
529:
530: delete from pay_report_format_mappings_tl rfmtl
531: where rfmtl.report_format_mapping_id = l_report_format_mapping_id

Line 624: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;

620: ,p_report_category in varchar2
621: ,p_display_name in varchar2 ) IS
622: --
623: l_proc varchar2(72) := g_package||'translate_rfm_row';
624: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;
625: --
626: BEGIN
627: --
628: hr_utility.set_location('Entering:'||l_proc, 5);

Line 677: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;

673: l_proc varchar2(72) := g_package||'load_rfi_row';
674: l_rec PAY_RFI_SHD.G_REC_TYPE;
675: l_exists varchar2 (1);
676: l_user_entity_id PAY_REPORT_FORMAT_ITEMS_F.USER_ENTITY_ID%TYPE;
677: l_report_format_mapping_id PAY_REPORT_FORMAT_MAPPINGS_F.REPORT_FORMAT_MAPPING_ID%TYPE;
678: l_report_format_item_id PAY_REPORT_FORMAT_ITEMS_F.REPORT_FORMAT_ITEM_ID%TYPE;
679: --
680: cursor csr_exists is
681: select null