APPS.PAY_LOADER_UTILS_PKG dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 384: from pay_report_format_items_f rfi

380: PROCEDURE set_end_date IS
381: --
382: cursor csr_rfi_exists is
383: select min(rfi.effective_start_date), max(rfi.effective_end_date)
384: from pay_report_format_items_f rfi
385: where rfi.report_type = g_rfm_old_rec.report_type
386: and rfi.report_qualifier = g_rfm_old_rec.report_qualifier
387: and rfi.report_category = g_rfm_old_rec.report_category;
388: --

Line 391: from pay_report_format_items_f rfi

387: and rfi.report_category = g_rfm_old_rec.report_category;
388: --
389: cursor csr_rfi_ids (p_effective_date date) is
390: select rfi.report_format_item_id, rfi.object_version_number
391: from pay_report_format_items_f rfi
392: where rfi.report_type = g_rfm_old_rec.report_type
393: and rfi.report_qualifier = g_rfm_old_rec.report_qualifier
394: and rfi.report_category = g_rfm_old_rec.report_category
395: and p_effective_date between

Line 651: -- This procedure uploads a single row into pay_report_format_items_f

647: -- |------------------------------< load_rfi_row >----------------------------|
648: -- ----------------------------------------------------------------------------
649: --
650: -- Description:
651: -- This procedure uploads a single row into pay_report_format_items_f
652: -- table. When the first row of a date tracked record is being uploaded
653: -- it checks if the record already exists in the table. If the record already
654: -- exists then all the rows of this record are deleted first and then the
655: -- first row is inserted. All the subsequent rows are uploaded by updating

Line 676: l_user_entity_id PAY_REPORT_FORMAT_ITEMS_F.USER_ENTITY_ID%TYPE;

672: --
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

Line 678: l_report_format_item_id PAY_REPORT_FORMAT_ITEMS_F.REPORT_FORMAT_ITEM_ID%TYPE;

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
682: from pay_report_format_items_f

Line 682: from pay_report_format_items_f

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
682: from pay_report_format_items_f
683: where report_type = p_report_type
684: and report_qualifier = p_report_qualifier
685: and report_category = p_report_category
686: and user_entity_id = l_user_entity_id;

Line 778: delete from pay_report_format_items_f

774: if csr_exists%found then
775:
776: -- Can't do an api delete as child rows may exist.
777:
778: delete from pay_report_format_items_f
779: where report_format_item_id = l_report_format_item_id;
780:
781: pay_rfi_ins.set_base_key_value
782: ( p_report_format_item_id => l_report_format_item_id );