2122: a.value
2123: from pay_report_format_items_f i,
2124: ff_database_items d,
2125: ff_user_entities u,
2126: ff_archive_items a,
2127: pay_payroll_actions ppa,
2128: pay_assignment_actions paa
2129: where paa.assignment_action_id = p_assignment_action_id
2130: and ppa.payroll_action_id = paa.payroll_action_id
2583: -- Bug 5036734 : Need to delete archive records while retrying
2584: -- an archive process that used AAC archive type
2585: if p_archive_type_used <> 'AAP' then -- old archive, delete manually.
2586:
2587: delete from ff_archive_items
2588: where CONTEXT1 = p_assignment_action_id
2589: and ARCHIVE_TYPE = 'AAC';
2590:
2591: end if;
2590:
2591: end if;
2592:
2593: ------------------------------------------------------------------------
2594: -- Insert into FF_ARCHIVE_ITEMS
2595: ------------------------------------------------------------------------
2596: forall i in 1..l_user_entity_id_tbl.count
2597: insert into ff_archive_items(
2598: ARCHIVE_ITEM_ID,
2593: ------------------------------------------------------------------------
2594: -- Insert into FF_ARCHIVE_ITEMS
2595: ------------------------------------------------------------------------
2596: forall i in 1..l_user_entity_id_tbl.count
2597: insert into ff_archive_items(
2598: ARCHIVE_ITEM_ID,
2599: USER_ENTITY_ID,
2600: CONTEXT1,
2601: VALUE,
2599: USER_ENTITY_ID,
2600: CONTEXT1,
2601: VALUE,
2602: ARCHIVE_TYPE)
2603: values( ff_archive_items_s.nextval,
2604: l_user_entity_id_tbl(i),
2605: p_assignment_action_id,
2606: l_archive_item_value_tbl(i),
2607: p_archive_type_used); -- Bug 5036734