384: sales_credit_id
385: into
386: v_sales_credit_id
387: from
388: oe_sales_credits
389: where sales_credit_id = mscx.sales_credit_id;
390:
391: select
392: oe_sales_credits_s.nextval
388: oe_sales_credits
389: where sales_credit_id = mscx.sales_credit_id;
390:
391: select
392: oe_sales_credits_s.nextval
393: into
394: v_sales_credit_id
395: from dual;
396: exception
400: null;
401: /* Should also process ERRORS here */
402: end;
403:
404: -- dbms_output.put_line('Ins oe_sales_credits');
405: insert into oe_sales_credits
406: (
407: sales_credit_id,
408: creation_date,
401: /* Should also process ERRORS here */
402: end;
403:
404: -- dbms_output.put_line('Ins oe_sales_credits');
405: insert into oe_sales_credits
406: (
407: sales_credit_id,
408: creation_date,
409: created_by,