1621: CONTEXT1,
1622: VALUE,
1623: ARCHIVE_TYPE)
1624: values
1625: (ff_archive_items_s.nextval,
1626: p_user_entity_id,
1627: p_context1,
1628: p_value,
1629: 'PPA'); /* Bug:2965887 */
1637: SEQUENCE_NO,
1638: CONTEXT,
1639: CONTEXT_ID)
1640: values
1641: (ff_archive_items_s.currval,
1642: p_sequence(i),
1643: p_context(i),
1644: p_context_id(i));
1645: end loop;
2157: -- INSERT INTO ff_archive_items (archive_item_id,
2158: -- user_entity_id,
2159: -- context1,
2160: -- value)
2161: -- VALUES( ff_archive_items_s.NEXTVAL ,
2162: -- l_user_entity_id ,
2163: -- p_assactid ,
2164: -- l_wage_plan_code );
2165: --
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,
2172: -- 1 ,
2173: -- l_assignment_id ,
2174: -- l_context_id_assignment_id);
2175: -- END LOOP;
2196: INSERT INTO ff_archive_items (archive_item_id,
2197: user_entity_id,
2198: context1,
2199: value)
2200: VALUES( ff_archive_items_s.NEXTVAL ,
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,
2210: 1 ,
2211: asgid ,
2212: l_context_id_assignment_id);
2213:
2231: INSERT INTO ff_archive_items (archive_item_id,
2232: user_entity_id,
2233: context1,
2234: value)
2235: VALUES( ff_archive_items_s.NEXTVAL ,
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,
2245: 1 ,
2246: asgid ,
2247: l_context_id_assignment_id);
2248: