[Home] [Help]
199: related to bug 983094 and 101435
200:
201: 01-sep-1999 achauhan While archiving the employer data
202: add the context of pay_payroll_actions
203: to ff_archive_item_contexts.
204: 11-aug-1999 achauhan Added the call to
205: eoy_archive_gre_data in the
206: eoy_range_cursor procedure. This is
207: being done to handle the situation
1631: l_step := 2;
1632:
1633: for i in p_sequence.first .. p_sequence.last
1634: loop
1635: insert into ff_archive_item_contexts
1636: (ARCHIVE_ITEM_ID,
1637: SEQUENCE_NO,
1638: CONTEXT,
1639: CONTEXT_ID)
1651: || to_char(sqlcode));
1652: raise hr_utility.hr_error;
1653:
1654: elsif l_step = 2 then
1655: hr_utility.trace('Error while inserting into ff_archive_item_contexts'
1656: || to_char(sqlcode));
1657: raise hr_utility.hr_error;
1658:
1659: end if;
2163: -- p_assactid ,
2164: -- l_wage_plan_code );
2165: --
2166: --
2167: -- INSERT INTO ff_archive_item_contexts (archive_item_id,
2168: -- sequence_no ,
2169: -- context ,
2170: -- context_id )
2171: -- VALUES (ff_archive_items_s.currval,
2201: l_user_entity_id ,
2202: p_assactid ,
2203: l_wage_plan_code );
2204:
2205: INSERT INTO ff_archive_item_contexts (archive_item_id,
2206: sequence_no ,
2207: context ,
2208: context_id )
2209: VALUES (ff_archive_items_s.currval,
2236: l_user_entity_id ,
2237: p_assactid ,
2238: l_wage_plan_code );
2239:
2240: INSERT INTO ff_archive_item_contexts (archive_item_id,
2241: sequence_no ,
2242: context ,
2243: context_id )
2244: VALUES (ff_archive_items_s.currval,