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: --
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,
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,
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,
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,
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,
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,