DBA Data[Home] [Help]

APPS.OE_UPG_SO dependencies on OE_SALES_CREDITS

Line 241: oe_sales_credits

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

Line 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

Line 257: -- dbms_output.put_line('Ins oe_sales_credits');

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,

Line 258: insert into oe_sales_credits

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,