237: sales_credit_id
238: into
239: v_sales_credit_id
240: from
241: oe_sales_credits
242: where sales_credit_id = msc.sales_credit_id;
243:
244: select
245: oe_sales_credits_s.nextval
241: oe_sales_credits
242: where sales_credit_id = msc.sales_credit_id;
243:
244: select
245: oe_sales_credits_s.nextval
246: into
247: v_sales_credit_id
248: from dual;
249: exception
253: null;
254: /* Should also process ERRORS here */
255: end;
256:
257: -- dbms_output.put_line('Ins oe_sales_credits');
258: insert into oe_sales_credits
259: (
260: sales_credit_id,
261: creation_date,
254: /* Should also process ERRORS here */
255: end;
256:
257: -- dbms_output.put_line('Ins oe_sales_credits');
258: insert into oe_sales_credits
259: (
260: sales_credit_id,
261: creation_date,
262: created_by,