226: l_code VARCHAR2(30);
227: l_dummy NUMBER;
228:
229: CURSOR c_seq IS
230: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)
231: FROM DUAL;
232:
233: CURSOR c_prefix IS
234: SELECT tag
366:
367: l_code VARCHAR2(30);
368:
369: CURSOR c_seq IS
370: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)
371: FROM DUAL;
372:
373: BEGIN
374:
907: scode_char_element,
908: scode_number_element,
909: arc_source_code_for
910: ) VALUES (
911: ams_source_codes_gen_s.NEXTVAL,
912: SYSDATE,
913: FND_GLOBAL.user_id,
914: SYSDATE,
915: FND_GLObAL.user_id,