211: IF v_report_id IS NULL
212: THEN
213: SELECT mtl_kanban_card_print_temp_s.NEXTVAL
214: INTO v_report_id
215: FROM DUAL;
216: END IF;
217:
218: INSERT INTO mtl_kanban_card_print_temp
219: (report_id, kanban_card_id
232: FOR i IN 1 .. l_count
233: LOOP
234: SELECT REGEXP_SUBSTR (p_mul_kbn_card_ids, '[^,]+', 1, i)
235: INTO l_value
236: FROM DUAL;
237: IF v_report_id IS NULL
238: THEN
239: SELECT mtl_kanban_card_print_temp_s.NEXTVAL
240: INTO v_report_id
237: IF v_report_id IS NULL
238: THEN
239: SELECT mtl_kanban_card_print_temp_s.NEXTVAL
240: INTO v_report_id
241: FROM DUAL;
242: END IF;
243:
244: INSERT INTO mtl_kanban_card_print_temp
245: (report_id, kanban_card_id