APPS.ONT_PRT_MARGIN_ANA_PKG dependencies on ONT_PRT_MARGIN_ANA_ERR

Line 95: DELETE FROM ONT_PRT_MARGIN_ANA_ERR;

91:
92: --
93: /* delete old data from tables */
94: DELETE FROM ONT_PRT_MARGIN_ANALYSIS;
95: DELETE FROM ONT_PRT_MARGIN_ANA_ERR;
96:
97: records_processed := 0;
98: FOR wkly_amt_rec IN wkly_amt_cursor LOOP
99: --

Line 161: INSERT into ONT_PRT_MARGIN_ANA_ERR

157: end if;
158:
159: EXCEPTION
160: WHEN DUP_VAL_ON_INDEX THEN
161: INSERT into ONT_PRT_MARGIN_ANA_ERR
162: (
163: build_id,
164: customer_id,
165: primary_salesrep_id,

Line 180: INSERT into ONT_PRT_MARGIN_ANA_ERR

176: tmp_inv_item_id,
177: '7D'
178: );
179: WHEN OTHERS THEN
180: INSERT into ONT_PRT_MARGIN_ANA_ERR
181: (
182: build_id,
183: customer_id,
184: primary_salesrep_id,

Line 267: INSERT into ONT_PRT_MARGIN_ANA_ERR

263: end if;
264:
265: EXCEPTION
266: WHEN DUP_VAL_ON_INDEX THEN
267: INSERT into ONT_PRT_MARGIN_ANA_ERR
268: (
269: build_id,
270: customer_id,
271: primary_salesrep_id,

Line 286: INSERT into ONT_PRT_MARGIN_ANA_ERR

282: tmp_inv_item_id,
283: '30D'
284: );
285: WHEN OTHERS THEN
286: INSERT into ONT_PRT_MARGIN_ANA_ERR
287: (
288: build_id,
289: customer_id,
290: primary_salesrep_id,

Line 373: INSERT into ONT_PRT_MARGIN_ANA_ERR

369: end if;
370:
371: EXCEPTION
372: WHEN DUP_VAL_ON_INDEX THEN
373: INSERT into ONT_PRT_MARGIN_ANA_ERR
374: (
375: build_id,
376: customer_id,
377: primary_salesrep_id,

Line 392: INSERT into ONT_PRT_MARGIN_ANA_ERR

388: tmp_inv_item_id,
389: '90D'
390: );
391: WHEN OTHERS THEN
392: INSERT into ONT_PRT_MARGIN_ANA_ERR
393: (
394: build_id,
395: customer_id,
396: primary_salesrep_id,