APPS.ONT_PRT_MARGIN_ANA_PKG dependencies on ONT_PRT_MARGIN_ANALYSIS

Line 94: DELETE FROM ONT_PRT_MARGIN_ANALYSIS;

90: BEGIN
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

Line 124: INSERT INTO ONT_PRT_MARGIN_ANALYSIS

120: end if;
121:
122: sum_margin := wkly_amt_rec.sum_inv_amt - wkly_amt_rec.sum_cogs_amt;
123:
124: INSERT INTO ONT_PRT_MARGIN_ANALYSIS
125: (
126: build_id,
127: customer_id,
128: primary_salesrep_id,

Line 230: INSERT INTO ONT_PRT_MARGIN_ANALYSIS

226: end if;
227:
228: sum_margin := mnthly_amt_rec.sum_inv_amt - mnthly_amt_rec.sum_cogs_amt;
229:
230: INSERT INTO ONT_PRT_MARGIN_ANALYSIS
231: (
232: build_id,
233: customer_id,
234: primary_salesrep_id,

Line 336: INSERT INTO ONT_PRT_MARGIN_ANALYSIS

332: end if;
333:
334: sum_margin := qrtrly_amt_rec.sum_inv_amt - qrtrly_amt_rec.sum_cogs_amt;
335:
336: INSERT INTO ONT_PRT_MARGIN_ANALYSIS
337: (
338: build_id,
339: customer_id,
340: primary_salesrep_id,

Line 426: from ONT_PRT_MARGIN_ANALYSIS

422: tot_inv_amount number;
423: begin
424: select sum(invoiced_amount)
425: into tot_inv_amount
426: from ONT_PRT_MARGIN_ANALYSIS
427: where period=in_period;
428: return (tot_inv_amount);
429: end get_total_sales;
430: --

Line 440: from ONT_PRT_MARGIN_ANALYSIS

436: tot_margin_amount number;
437: begin
438: select sum(margin)
439: into tot_margin_amount
440: from ONT_PRT_MARGIN_ANALYSIS
441: where period=in_period;
442: return tot_margin_amount;
443: end get_total_margin;
444: --