[Home] [Help]
5379: a.value
5380: from pay_report_format_items_f i,
5381: ff_database_items d,
5382: ff_user_entities u,
5383: ff_archive_items a,
5384: pay_payroll_actions ppa,
5385: pay_assignment_actions paa
5386: where paa.assignment_action_id = p_assignment_action_id
5387: and ppa.payroll_action_id = paa.payroll_action_id
5935: -- Bug 5036734 : Need to delete archive records while retrying
5936: -- an archive process that used AAC archive type
5937: if p_archive_type_used <> 'AAP' then -- old archive, delete manually.
5938:
5939: delete from ff_archive_items
5940: where CONTEXT1 = p_assignment_action_id
5941: and ARCHIVE_TYPE = 'AAC';
5942:
5943: end if;
5942:
5943: end if;
5944:
5945: ------------------------------------------------------------------------
5946: -- Insert into FF_ARCHIVE_ITEMS
5947: ------------------------------------------------------------------------
5948: forall i in 1..l_user_entity_id_tbl.count
5949: insert into ff_archive_items(
5950: ARCHIVE_ITEM_ID,
5945: ------------------------------------------------------------------------
5946: -- Insert into FF_ARCHIVE_ITEMS
5947: ------------------------------------------------------------------------
5948: forall i in 1..l_user_entity_id_tbl.count
5949: insert into ff_archive_items(
5950: ARCHIVE_ITEM_ID,
5951: USER_ENTITY_ID,
5952: CONTEXT1,
5953: VALUE,
5951: USER_ENTITY_ID,
5952: CONTEXT1,
5953: VALUE,
5954: ARCHIVE_TYPE)
5955: values( ff_archive_items_s.nextval,
5956: l_user_entity_id_tbl(i),
5957: p_assignment_action_id,
5958: l_archive_item_value_tbl(i),
5959: p_archive_type_used); -- Bug 5036734