APPS.ICX_MARGIN_WEB_ANA_PKG dependencies on ICX_MARGIN_ANALYSIS

Line 94: DELETE FROM ICX_MARGIN_ANALYSIS;

90: BEGIN
91:
92: --
93: /* delete date from tables */
94: DELETE FROM ICX_MARGIN_ANALYSIS;
95: DELETE FROM ICX_MARGIN_ANALYSIS_ERR;
96:
97: records_processed := 0;
98: FOR wkly_amt_rec IN wkly_amt_cursor LOOP

Line 95: DELETE FROM ICX_MARGIN_ANALYSIS_ERR;

91:
92: --
93: /* delete date from tables */
94: DELETE FROM ICX_MARGIN_ANALYSIS;
95: DELETE FROM ICX_MARGIN_ANALYSIS_ERR;
96:
97: records_processed := 0;
98: FOR wkly_amt_rec IN wkly_amt_cursor LOOP
99: --

Line 124: INSERT INTO icx_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 icx_margin_analysis
125: (
126: build_id,
127: customer_id,
128: primary_salesrep_id,

Line 161: INSERT into icx_margin_analysis_err

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

Line 180: INSERT into icx_margin_analysis_err

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

Line 230: INSERT INTO icx_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 icx_margin_analysis
231: (
232: build_id,
233: customer_id,
234: primary_salesrep_id,

Line 267: INSERT into icx_margin_analysis_err

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

Line 286: INSERT into icx_margin_analysis_err

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

Line 336: INSERT INTO icx_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 icx_margin_analysis
337: (
338: build_id,
339: customer_id,
340: primary_salesrep_id,

Line 373: INSERT into icx_margin_analysis_err

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

Line 392: INSERT into icx_margin_analysis_err

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

Line 426: from icx_margin_analysis

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

Line 440: from icx_margin_analysis

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