eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DDR_EMD_UTIL dependencies on DDR_EMD_UTIL

Line 1: PACKAGE BODY ddr_emd_util AS

1: PACKAGE BODY ddr_emd_util AS
2: /* $Header: ddremdub.pls 120.11.12020000.3 2012/08/04 02:31:58 gglover ship $ */
3:
4: get_avg_sls_id1 ddr_b_rtl_sl_rtn_itm_day.org_bsns_unit_id%TYPE;
5: get_avg_sls_id2 ddr_b_rtl_sl_rtn_itm_day.mfg_sku_item_id%TYPE;

Line 97: x_return_status := ddr_emd_util.success;

93: ,x_return_status OUT NOCOPY VARCHAR2
94: ,x_msg OUT NOCOPY VARCHAR2
95: ) IS
96: BEGIN
97: x_return_status := ddr_emd_util.success;
98:
99: DELETE FROM ddr_b_excptn_item_day
100: WHERE excptn_typ = NVL(p_excptn_type,excptn_typ)
101: AND excptn_src_cd = NVL(p_excptn_src_code,excptn_src_cd)

Line 106: x_return_status := ddr_emd_util.error;

102: AND day_cd <= TO_CHAR(p_end_date, 'YYYYMMDD');
103: COMMIT;
104: EXCEPTION
105: WHEN OTHERS THEN
106: x_return_status := ddr_emd_util.error;
107: x_msg := 'Failed in ddr_emd_util.delete_all_exceptions '||SQLERRM;
108: END delete_all_exceptions;
109:
110:

Line 107: x_msg := 'Failed in ddr_emd_util.delete_all_exceptions '||SQLERRM;

103: COMMIT;
104: EXCEPTION
105: WHEN OTHERS THEN
106: x_return_status := ddr_emd_util.error;
107: x_msg := 'Failed in ddr_emd_util.delete_all_exceptions '||SQLERRM;
108: END delete_all_exceptions;
109:
110:
111: PROCEDURE delete_all_exceptions_wrp(

Line 119: DDR_EMD_UTIL.DELETE_ALL_EXCEPTIONS(P_END_DATE=>P_END_DATE,

115: ) IS
116: X_RETURN_STATUS VARCHAR2(1000);
117: X_MSG VARCHAR2(1000);
118: BEGIN
119: DDR_EMD_UTIL.DELETE_ALL_EXCEPTIONS(P_END_DATE=>P_END_DATE,
120: P_EXCPTN_TYPE => P_EXCPTN_TYPE,
121: P_EXCPTN_SRC_CODE => P_EXCPTN_SRC_CODE,
122: X_RETURN_STATUS => X_RETURN_STATUS,
123: X_MSG => X_MSG

Line 128: x_return_status := ddr_emd_util.error;

124: );
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: x_return_status := ddr_emd_util.error;
129: X_MSG := 'Failed in ddr_emd_util.delete_all_exceptions '||SQLERRM;
130: END delete_all_exceptions_wrp;
131:
132:

Line 129: X_MSG := 'Failed in ddr_emd_util.delete_all_exceptions '||SQLERRM;

125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: x_return_status := ddr_emd_util.error;
129: X_MSG := 'Failed in ddr_emd_util.delete_all_exceptions '||SQLERRM;
130: END delete_all_exceptions_wrp;
131:
132:
133: PROCEDURE populate_new_items(p_date DATE DEFAULT SYSDATE

Line 142: v_org_cd_tbl ddr_emd_util.varchar_tbl;

138: ,x_return_status OUT NOCOPY VARCHAR2
139: ,x_msg OUT NOCOPY VARCHAR2
140: ) IS
141:
142: v_org_cd_tbl ddr_emd_util.varchar_tbl;
143: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
144: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
145: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
146: v_new_item_strt_dt_tbl ddr_emd_util.date_tbl;

Line 143: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;

139: ,x_msg OUT NOCOPY VARCHAR2
140: ) IS
141:
142: v_org_cd_tbl ddr_emd_util.varchar_tbl;
143: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
144: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
145: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
146: v_new_item_strt_dt_tbl ddr_emd_util.date_tbl;
147: v_new_item_end_dt_tbl ddr_emd_util.date_tbl;

Line 144: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;

140: ) IS
141:
142: v_org_cd_tbl ddr_emd_util.varchar_tbl;
143: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
144: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
145: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
146: v_new_item_strt_dt_tbl ddr_emd_util.date_tbl;
147: v_new_item_end_dt_tbl ddr_emd_util.date_tbl;
148: v_first_sl_date_tbl ddr_emd_util.date_tbl;

Line 145: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;

141:
142: v_org_cd_tbl ddr_emd_util.varchar_tbl;
143: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
144: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
145: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
146: v_new_item_strt_dt_tbl ddr_emd_util.date_tbl;
147: v_new_item_end_dt_tbl ddr_emd_util.date_tbl;
148: v_first_sl_date_tbl ddr_emd_util.date_tbl;
149: v_user VARCHAR2(100);

Line 146: v_new_item_strt_dt_tbl ddr_emd_util.date_tbl;

142: v_org_cd_tbl ddr_emd_util.varchar_tbl;
143: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
144: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
145: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
146: v_new_item_strt_dt_tbl ddr_emd_util.date_tbl;
147: v_new_item_end_dt_tbl ddr_emd_util.date_tbl;
148: v_first_sl_date_tbl ddr_emd_util.date_tbl;
149: v_user VARCHAR2(100);
150:

Line 147: v_new_item_end_dt_tbl ddr_emd_util.date_tbl;

143: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
144: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
145: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
146: v_new_item_strt_dt_tbl ddr_emd_util.date_tbl;
147: v_new_item_end_dt_tbl ddr_emd_util.date_tbl;
148: v_first_sl_date_tbl ddr_emd_util.date_tbl;
149: v_user VARCHAR2(100);
150:
151: v_rec_count NUMBER:= 0;

Line 148: v_first_sl_date_tbl ddr_emd_util.date_tbl;

144: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
145: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
146: v_new_item_strt_dt_tbl ddr_emd_util.date_tbl;
147: v_new_item_end_dt_tbl ddr_emd_util.date_tbl;
148: v_first_sl_date_tbl ddr_emd_util.date_tbl;
149: v_user VARCHAR2(100);
150:
151: v_rec_count NUMBER:= 0;
152:

Line 156: WHERE eff_from_dt > TRUNC(p_date) - ddr_emd_util.new_item_period

152:
153: CURSOR new_items IS
154: SELECT *
155: FROM ddr_r_item_bsns_unt_assc
156: WHERE eff_from_dt > TRUNC(p_date) - ddr_emd_util.new_item_period
157: AND rtl_org_cd = NVL(p_rtl_org_cd,rtl_org_cd)
158: AND rtl_bsns_unit_id = NVL(p_bsns_unit_id,rtl_bsns_unit_id)
159: AND mfg_sku_item_id = NVL(p_mfg_sku_item_id,mfg_sku_item_id)
160: --AND eff_to_dt IS NULL;

Line 209: v_new_item_end_dt_tbl(v_rec_count) := v_new_item_strt_dt_tbl(v_rec_count)+ddr_emd_util.new_item_period;

205: v_bsns_unit_id_tbl(v_rec_count) := rec.rtl_bsns_unit_id;
206: v_mfg_sku_item_id_tbl(v_rec_count) := rec.mfg_sku_item_id;
207: v_rtl_sku_item_id_tbl(v_rec_count) := rec1.rtl_sku_item_id;
208: v_new_item_strt_dt_tbl(v_rec_count) := TRUNC(rec.eff_from_dt);
209: v_new_item_end_dt_tbl(v_rec_count) := v_new_item_strt_dt_tbl(v_rec_count)+ddr_emd_util.new_item_period;
210: v_first_sl_date_tbl(v_rec_count) := NULL;
211:
212: FOR rec2 IN sls_rec(rec.rtl_bsns_unit_id
213: ,rec.mfg_sku_item_id

Line 218: IF MOD(v_rec_count,ddr_emd_util.c_batch_size) = 0 THEN --{

214: ,rec1.rtl_sku_item_id
215: ,TO_CHAR(rec.eff_from_dt,'YYYYMMDD')) LOOP --{
216: v_first_sl_date_tbl(v_rec_count) := TO_DATE(rec2.first_sl_date,'YYYYMMDD');
217: END LOOP; --}
218: IF MOD(v_rec_count,ddr_emd_util.c_batch_size) = 0 THEN --{
219: FORALL i IN 1..v_rec_count
220: INSERT INTO ddr_b_new_item_no_sls(rtl_org_cd
221: ,rtl_bsns_unit_id
222: ,mfg_sku_item_id

Line 270: x_return_status := ddr_emd_util.error;

266: );
267: COMMIT;
268: EXCEPTION
269: WHEN OTHERS THEN
270: x_return_status := ddr_emd_util.error;
271: x_msg := 'Failed in populate_new_items'||' :'||SQLERRM;
272: END populate_new_items;
273:
274:

Line 318: x_return_status := ddr_emd_util.success;

314: AND rtl_sku_item_id = p_sls_rec.rtl_sku_item_id
315: AND prmtn_flag = 'Y';
316: BEGIN
317:
318: x_return_status := ddr_emd_util.success;
319: p_exp_sls := NULL;
320:
321: v_day := TO_DATE(p_sls_rec.day_cd,'YYYYMMDD');
322:

Line 342: x_return_status := ddr_emd_util.error;

338: END LOOP; --}
339: END IF; --}
340: EXCEPTION
341: WHEN OTHERS THEN
342: x_return_status := ddr_emd_util.error;
343: x_msg := 'Failed in get_exp_sls'||' :'||SQLERRM;
344: END get_exp_sls;
345:
346: PROCEDURE get_avg_sls(p_sls_rec ddr_b_rtl_sl_rtn_itm_day%ROWTYPE

Line 355: x_return_status := ddr_emd_util.success;

351:
352: v_wk_strt_dt DATE:= NULL;
353:
354: BEGIN
355: x_return_status := ddr_emd_util.success;
356: p_avg_sls := NULL;
357:
358: IF p_sls_rec.prmtn_flag = 'N' THEN --{
359: p_avg_sls := NULL;

Line 396: x_return_status := ddr_emd_util.error;

392: get_avg_sls_avg_sls := p_avg_sls;
393:
394: EXCEPTION
395: WHEN OTHERS THEN
396: x_return_status := ddr_emd_util.error;
397: x_msg := 'Failed in get_avg_sls'||' :'||SQLERRM;
398: END get_avg_sls;
399:
400: PROCEDURE get_prmtn_price(p_sls_rec ddr_b_rtl_sl_rtn_itm_day%ROWTYPE

Line 415: x_return_status := ddr_emd_util.success;

411: AND TO_DATE(p_sls_rec.day_cd,'YYYYMMDD') BETWEEN prmtn_from_dt AND prmtn_to_dt;
412:
413: BEGIN
414:
415: x_return_status := ddr_emd_util.success;
416: p_prmtn_price := NULL;
417:
418: IF p_sls_rec.prmtn_flag = 'N' THEN --{
419: RETURN;

Line 427: x_return_status := ddr_emd_util.error;

423: p_prmtn_price := rec.min_prmtn_price;
424: END LOOP; --}
425: EXCEPTION
426: WHEN OTHERS THEN
427: x_return_status := ddr_emd_util.error;
428: x_msg := 'Failed in get_prmtn_price'||' :'||SQLERRM;
429: END get_prmtn_price;
430:
431: PROCEDURE get_sls_threshold(p_exp_sls NUMBER

Line 438: x_return_status := ddr_emd_util.success;

434: ,x_msg OUT NOCOPY VARCHAR2
435: ) IS
436: v_exp_sls NUMBER;
437: BEGIN
438: x_return_status := ddr_emd_util.success;
439: p_sls_threshold := NULL;
440: v_exp_sls := p_exp_sls;
441:
442: IF get_sls_threshold_max_exp_sls IS NULL THEN --{

Line 466: x_return_status := ddr_emd_util.error;

462: FROM ddr_r_excptn_sls_thrshld
463: WHERE expctd_sls = ROUND(v_exp_sls);
464: EXCEPTION
465: WHEN OTHERS THEN
466: x_return_status := ddr_emd_util.error;
467: x_msg := 'Failed in get_sls_threshold'||' :'||SQLERRM;
468: END get_sls_threshold;
469:
470: -- This procedure populates ddr_b_sl_rtl_addtnl_msrs table

Line 497: v_org_cd_tbl ddr_emd_util.varchar_tbl;

493: ,x_return_status OUT NOCOPY VARCHAR2
494: ,x_msg OUT NOCOPY VARCHAR2
495: ) IS
496:
497: v_org_cd_tbl ddr_emd_util.varchar_tbl;
498: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
499: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
500: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
501: v_day_cd_tbl ddr_emd_util.varchar_tbl;

Line 498: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;

494: ,x_msg OUT NOCOPY VARCHAR2
495: ) IS
496:
497: v_org_cd_tbl ddr_emd_util.varchar_tbl;
498: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
499: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
500: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
501: v_day_cd_tbl ddr_emd_util.varchar_tbl;
502:

Line 499: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;

495: ) IS
496:
497: v_org_cd_tbl ddr_emd_util.varchar_tbl;
498: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
499: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
500: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
501: v_day_cd_tbl ddr_emd_util.varchar_tbl;
502:
503: v_m1_tbl ddr_emd_util.date_tbl;

Line 500: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;

496:
497: v_org_cd_tbl ddr_emd_util.varchar_tbl;
498: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
499: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
500: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
501: v_day_cd_tbl ddr_emd_util.varchar_tbl;
502:
503: v_m1_tbl ddr_emd_util.date_tbl;
504: v_m2_tbl ddr_emd_util.date_tbl;

Line 501: v_day_cd_tbl ddr_emd_util.varchar_tbl;

497: v_org_cd_tbl ddr_emd_util.varchar_tbl;
498: v_bsns_unit_id_tbl ddr_emd_util.number_tbl;
499: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
500: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
501: v_day_cd_tbl ddr_emd_util.varchar_tbl;
502:
503: v_m1_tbl ddr_emd_util.date_tbl;
504: v_m2_tbl ddr_emd_util.date_tbl;
505: v_m3_tbl ddr_emd_util.number_tbl;

Line 503: v_m1_tbl ddr_emd_util.date_tbl;

499: v_mfg_sku_item_id_tbl ddr_emd_util.number_tbl;
500: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
501: v_day_cd_tbl ddr_emd_util.varchar_tbl;
502:
503: v_m1_tbl ddr_emd_util.date_tbl;
504: v_m2_tbl ddr_emd_util.date_tbl;
505: v_m3_tbl ddr_emd_util.number_tbl;
506: v_m4_tbl ddr_emd_util.number_tbl;
507: v_m5_tbl ddr_emd_util.number_tbl;

Line 504: v_m2_tbl ddr_emd_util.date_tbl;

500: v_rtl_sku_item_id_tbl ddr_emd_util.number_tbl;
501: v_day_cd_tbl ddr_emd_util.varchar_tbl;
502:
503: v_m1_tbl ddr_emd_util.date_tbl;
504: v_m2_tbl ddr_emd_util.date_tbl;
505: v_m3_tbl ddr_emd_util.number_tbl;
506: v_m4_tbl ddr_emd_util.number_tbl;
507: v_m5_tbl ddr_emd_util.number_tbl;
508: v_m6_tbl ddr_emd_util.number_tbl;

Line 505: v_m3_tbl ddr_emd_util.number_tbl;

501: v_day_cd_tbl ddr_emd_util.varchar_tbl;
502:
503: v_m1_tbl ddr_emd_util.date_tbl;
504: v_m2_tbl ddr_emd_util.date_tbl;
505: v_m3_tbl ddr_emd_util.number_tbl;
506: v_m4_tbl ddr_emd_util.number_tbl;
507: v_m5_tbl ddr_emd_util.number_tbl;
508: v_m6_tbl ddr_emd_util.number_tbl;
509: v_m7_tbl ddr_emd_util.number_tbl;

Line 506: v_m4_tbl ddr_emd_util.number_tbl;

502:
503: v_m1_tbl ddr_emd_util.date_tbl;
504: v_m2_tbl ddr_emd_util.date_tbl;
505: v_m3_tbl ddr_emd_util.number_tbl;
506: v_m4_tbl ddr_emd_util.number_tbl;
507: v_m5_tbl ddr_emd_util.number_tbl;
508: v_m6_tbl ddr_emd_util.number_tbl;
509: v_m7_tbl ddr_emd_util.number_tbl;
510: v_m8_tbl ddr_emd_util.number_tbl;

Line 507: v_m5_tbl ddr_emd_util.number_tbl;

503: v_m1_tbl ddr_emd_util.date_tbl;
504: v_m2_tbl ddr_emd_util.date_tbl;
505: v_m3_tbl ddr_emd_util.number_tbl;
506: v_m4_tbl ddr_emd_util.number_tbl;
507: v_m5_tbl ddr_emd_util.number_tbl;
508: v_m6_tbl ddr_emd_util.number_tbl;
509: v_m7_tbl ddr_emd_util.number_tbl;
510: v_m8_tbl ddr_emd_util.number_tbl;
511: v_m9_tbl ddr_emd_util.number_tbl;

Line 508: v_m6_tbl ddr_emd_util.number_tbl;

504: v_m2_tbl ddr_emd_util.date_tbl;
505: v_m3_tbl ddr_emd_util.number_tbl;
506: v_m4_tbl ddr_emd_util.number_tbl;
507: v_m5_tbl ddr_emd_util.number_tbl;
508: v_m6_tbl ddr_emd_util.number_tbl;
509: v_m7_tbl ddr_emd_util.number_tbl;
510: v_m8_tbl ddr_emd_util.number_tbl;
511: v_m9_tbl ddr_emd_util.number_tbl;
512: v_m10_tbl ddr_emd_util.number_tbl;

Line 509: v_m7_tbl ddr_emd_util.number_tbl;

505: v_m3_tbl ddr_emd_util.number_tbl;
506: v_m4_tbl ddr_emd_util.number_tbl;
507: v_m5_tbl ddr_emd_util.number_tbl;
508: v_m6_tbl ddr_emd_util.number_tbl;
509: v_m7_tbl ddr_emd_util.number_tbl;
510: v_m8_tbl ddr_emd_util.number_tbl;
511: v_m9_tbl ddr_emd_util.number_tbl;
512: v_m10_tbl ddr_emd_util.number_tbl;
513:

Line 510: v_m8_tbl ddr_emd_util.number_tbl;

506: v_m4_tbl ddr_emd_util.number_tbl;
507: v_m5_tbl ddr_emd_util.number_tbl;
508: v_m6_tbl ddr_emd_util.number_tbl;
509: v_m7_tbl ddr_emd_util.number_tbl;
510: v_m8_tbl ddr_emd_util.number_tbl;
511: v_m9_tbl ddr_emd_util.number_tbl;
512: v_m10_tbl ddr_emd_util.number_tbl;
513:
514: v_rec_count NUMBER:= 0;

Line 511: v_m9_tbl ddr_emd_util.number_tbl;

507: v_m5_tbl ddr_emd_util.number_tbl;
508: v_m6_tbl ddr_emd_util.number_tbl;
509: v_m7_tbl ddr_emd_util.number_tbl;
510: v_m8_tbl ddr_emd_util.number_tbl;
511: v_m9_tbl ddr_emd_util.number_tbl;
512: v_m10_tbl ddr_emd_util.number_tbl;
513:
514: v_rec_count NUMBER:= 0;
515: v_user VARCHAR2(100);

Line 512: v_m10_tbl ddr_emd_util.number_tbl;

508: v_m6_tbl ddr_emd_util.number_tbl;
509: v_m7_tbl ddr_emd_util.number_tbl;
510: v_m8_tbl ddr_emd_util.number_tbl;
511: v_m9_tbl ddr_emd_util.number_tbl;
512: v_m10_tbl ddr_emd_util.number_tbl;
513:
514: v_rec_count NUMBER:= 0;
515: v_user VARCHAR2(100);
516:

Line 561: IF p_populate_m1 = ddr_emd_util.c_populate_custom THEN --{

557: v_rtl_sku_item_id_tbl(v_rec_count) := sls_rec.rtl_sku_item_id;
558: v_day_cd_tbl(v_rec_count) := sls_rec.day_cd;
559:
560: -- Populate measure1 --{
561: IF p_populate_m1 = ddr_emd_util.c_populate_custom THEN --{
562: /*
563: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
564: ,ddr_emd_util.m1
565: ,v_m1_tbl(v_rec_count)

Line 564: ,ddr_emd_util.m1

560: -- Populate measure1 --{
561: IF p_populate_m1 = ddr_emd_util.c_populate_custom THEN --{
562: /*
563: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
564: ,ddr_emd_util.m1
565: ,v_m1_tbl(v_rec_count)
566: ,x_return_status
567: ,x_msg
568: );

Line 571: ELSIF p_populate_m1 = ddr_emd_util.c_populate_standard THEN --}{

567: ,x_msg
568: );
569: */
570: NULL;
571: ELSIF p_populate_m1 = ddr_emd_util.c_populate_standard THEN --}{
572: NULL;
573: ELSE --}{
574: v_m1_tbl(v_rec_count):= NULL;
575: END IF; --}

Line 576: IF x_return_status = ddr_emd_util.error THEN --{

572: NULL;
573: ELSE --}{
574: v_m1_tbl(v_rec_count):= NULL;
575: END IF; --}
576: IF x_return_status = ddr_emd_util.error THEN --{
577: RETURN;
578: END IF; --}
579: -- Populate measure1 --}
580:

Line 582: IF p_populate_m2 = ddr_emd_util.c_populate_custom THEN --{

578: END IF; --}
579: -- Populate measure1 --}
580:
581: -- Populate measure2 --{
582: IF p_populate_m2 = ddr_emd_util.c_populate_custom THEN --{
583: /*
584: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
585: ,ddr_emd_util.m2
586: ,v_m2_tbl(v_rec_count)

Line 585: ,ddr_emd_util.m2

581: -- Populate measure2 --{
582: IF p_populate_m2 = ddr_emd_util.c_populate_custom THEN --{
583: /*
584: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
585: ,ddr_emd_util.m2
586: ,v_m2_tbl(v_rec_count)
587: ,x_return_status
588: ,x_msg
589: );

Line 592: ELSIF p_populate_m2 = ddr_emd_util.c_populate_standard THEN --}{

588: ,x_msg
589: );
590: */
591: NULL;
592: ELSIF p_populate_m2 = ddr_emd_util.c_populate_standard THEN --}{
593: NULL;
594: ELSE --}{
595: v_m2_tbl(v_rec_count):= NULL;
596: END IF; --}

Line 597: IF x_return_status = ddr_emd_util.error THEN --{

593: NULL;
594: ELSE --}{
595: v_m2_tbl(v_rec_count):= NULL;
596: END IF; --}
597: IF x_return_status = ddr_emd_util.error THEN --{
598: RETURN;
599: END IF; --}
600: -- Populate measure2 --}
601:

Line 603: IF p_populate_m3 = ddr_emd_util.c_populate_custom THEN --{

599: END IF; --}
600: -- Populate measure2 --}
601:
602: -- Populate measure3 --{
603: IF p_populate_m3 = ddr_emd_util.c_populate_custom THEN --{
604: /*
605: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
606: ,ddr_emd_util.m3
607: ,v_m3_tbl(v_rec_count)

Line 606: ,ddr_emd_util.m3

602: -- Populate measure3 --{
603: IF p_populate_m3 = ddr_emd_util.c_populate_custom THEN --{
604: /*
605: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
606: ,ddr_emd_util.m3
607: ,v_m3_tbl(v_rec_count)
608: ,x_return_status
609: ,x_msg
610: );

Line 613: ELSIF p_populate_m3 = ddr_emd_util.c_populate_standard THEN --}{

609: ,x_msg
610: );
611: */
612: NULL;
613: ELSIF p_populate_m3 = ddr_emd_util.c_populate_standard THEN --}{
614: get_exp_sls(sls_rec
615: ,v_m3_tbl(v_rec_count)
616: ,x_return_status
617: ,x_msg

Line 622: IF x_return_status = ddr_emd_util.error THEN --{

618: );
619: ELSE --}{
620: v_m3_tbl(v_rec_count):= NULL;
621: END IF; --}
622: IF x_return_status = ddr_emd_util.error THEN --{
623: RETURN;
624: END IF; --}
625: -- Populate measure3 --}
626:

Line 628: IF p_populate_m4 = ddr_emd_util.c_populate_custom THEN --{

624: END IF; --}
625: -- Populate measure3 --}
626:
627: -- Populate measure4 --{
628: IF p_populate_m4 = ddr_emd_util.c_populate_custom THEN --{
629: /*
630: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
631: ,ddr_emd_util.m4
632: ,v_m4_tbl(v_rec_count)

Line 631: ,ddr_emd_util.m4

627: -- Populate measure4 --{
628: IF p_populate_m4 = ddr_emd_util.c_populate_custom THEN --{
629: /*
630: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
631: ,ddr_emd_util.m4
632: ,v_m4_tbl(v_rec_count)
633: ,x_return_status
634: ,x_msg
635: );

Line 638: ELSIF p_populate_m4 = ddr_emd_util.c_populate_standard THEN --}{

634: ,x_msg
635: );
636: */
637: NULL;
638: ELSIF p_populate_m4 = ddr_emd_util.c_populate_standard THEN --}{
639: get_avg_sls(sls_rec
640: ,v_m4_tbl(v_rec_count)
641: ,x_return_status
642: ,x_msg

Line 647: IF x_return_status = ddr_emd_util.error THEN --{

643: );
644: ELSE --}{
645: v_m4_tbl(v_rec_count):= NULL;
646: END IF; --}
647: IF x_return_status = ddr_emd_util.error THEN --{
648: RETURN;
649: END IF; --}
650: -- Populate measure4 --}
651:

Line 653: IF p_populate_m5 = ddr_emd_util.c_populate_custom THEN --{

649: END IF; --}
650: -- Populate measure4 --}
651:
652: -- Populate measure5 --{
653: IF p_populate_m5 = ddr_emd_util.c_populate_custom THEN --{
654: /*
655: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
656: ,ddr_emd_util.m5
657: ,v_m5_tbl(v_rec_count)

Line 656: ,ddr_emd_util.m5

652: -- Populate measure5 --{
653: IF p_populate_m5 = ddr_emd_util.c_populate_custom THEN --{
654: /*
655: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
656: ,ddr_emd_util.m5
657: ,v_m5_tbl(v_rec_count)
658: ,x_return_status
659: ,x_msg
660: );

Line 663: ELSIF p_populate_m5 = ddr_emd_util.c_populate_standard THEN --}{

659: ,x_msg
660: );
661: */
662: NULL;
663: ELSIF p_populate_m5 = ddr_emd_util.c_populate_standard THEN --}{
664: get_prmtn_price(sls_rec
665: ,v_m5_tbl(v_rec_count)
666: ,x_return_status
667: ,x_msg

Line 669: IF x_return_status = ddr_emd_util.error THEN --{

665: ,v_m5_tbl(v_rec_count)
666: ,x_return_status
667: ,x_msg
668: );
669: IF x_return_status = ddr_emd_util.error THEN --{
670: NULL;
671: END IF; --}
672: ELSE --}{
673: v_m5_tbl(v_rec_count):= NULL;

Line 675: IF x_return_status = ddr_emd_util.error THEN --{

671: END IF; --}
672: ELSE --}{
673: v_m5_tbl(v_rec_count):= NULL;
674: END IF; --}
675: IF x_return_status = ddr_emd_util.error THEN --{
676: RETURN;
677: END IF; --}
678: -- Populate measure5 --}
679:

Line 681: IF p_populate_m6 = ddr_emd_util.c_populate_custom THEN --{

677: END IF; --}
678: -- Populate measure5 --}
679:
680: -- Populate measure6 --{
681: IF p_populate_m6 = ddr_emd_util.c_populate_custom THEN --{
682: /*
683: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
684: ,ddr_emd_util.m6
685: ,v_m6_tbl(v_rec_count)

Line 684: ,ddr_emd_util.m6

680: -- Populate measure6 --{
681: IF p_populate_m6 = ddr_emd_util.c_populate_custom THEN --{
682: /*
683: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
684: ,ddr_emd_util.m6
685: ,v_m6_tbl(v_rec_count)
686: ,x_return_status
687: ,x_msg
688: );

Line 691: ELSIF p_populate_m6 = ddr_emd_util.c_populate_standard THEN --}{

687: ,x_msg
688: );
689: */
690: NULL;
691: ELSIF p_populate_m6 = ddr_emd_util.c_populate_standard THEN --}{
692: get_sls_threshold(v_m3_tbl(v_rec_count)
693: ,v_m6_tbl(v_rec_count)
694: ,x_return_status
695: ,x_msg

Line 700: IF x_return_status = ddr_emd_util.error THEN --{

696: );
697: ELSE --}{
698: v_m6_tbl(v_rec_count):= NULL;
699: END IF; --}
700: IF x_return_status = ddr_emd_util.error THEN --{
701: RETURN;
702: END IF; --}
703: -- Populate measure6 --}
704:

Line 706: IF p_populate_m7 = ddr_emd_util.c_populate_custom THEN --{

702: END IF; --}
703: -- Populate measure6 --}
704:
705: -- Populate measure7 --{
706: IF p_populate_m7 = ddr_emd_util.c_populate_custom THEN --{
707: /*
708: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
709: ,ddr_emd_util.m7
710: ,v_m7_tbl(v_rec_count)

Line 709: ,ddr_emd_util.m7

705: -- Populate measure7 --{
706: IF p_populate_m7 = ddr_emd_util.c_populate_custom THEN --{
707: /*
708: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
709: ,ddr_emd_util.m7
710: ,v_m7_tbl(v_rec_count)
711: ,x_return_status
712: ,x_msg
713: );

Line 716: ELSIF p_populate_m7 = ddr_emd_util.c_populate_standard THEN --}{

712: ,x_msg
713: );
714: */
715: NULL;
716: ELSIF p_populate_m7 = ddr_emd_util.c_populate_standard THEN --}{
717: NULL;
718: ELSE --}{
719: v_m7_tbl(v_rec_count):= NULL;
720: END IF; --}

Line 721: IF x_return_status = ddr_emd_util.error THEN --{

717: NULL;
718: ELSE --}{
719: v_m7_tbl(v_rec_count):= NULL;
720: END IF; --}
721: IF x_return_status = ddr_emd_util.error THEN --{
722: RETURN;
723: END IF; --}
724: -- Populate measure7 --}
725:

Line 727: IF p_populate_m8 = ddr_emd_util.c_populate_custom THEN --{

723: END IF; --}
724: -- Populate measure7 --}
725:
726: -- Populate measure8 --{
727: IF p_populate_m8 = ddr_emd_util.c_populate_custom THEN --{
728: /*
729: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
730: ,ddr_emd_util.m8
731: ,v_m8_tbl(v_rec_count)

Line 730: ,ddr_emd_util.m8

726: -- Populate measure8 --{
727: IF p_populate_m8 = ddr_emd_util.c_populate_custom THEN --{
728: /*
729: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
730: ,ddr_emd_util.m8
731: ,v_m8_tbl(v_rec_count)
732: ,x_return_status
733: ,x_msg
734: );

Line 737: ELSIF p_populate_m8 = ddr_emd_util.c_populate_standard THEN --}{

733: ,x_msg
734: );
735: */
736: NULL;
737: ELSIF p_populate_m8 = ddr_emd_util.c_populate_standard THEN --}{
738: NULL;
739: ELSE --}{
740: v_m8_tbl(v_rec_count):= NULL;
741: END IF; --}

Line 742: IF x_return_status = ddr_emd_util.error THEN --{

738: NULL;
739: ELSE --}{
740: v_m8_tbl(v_rec_count):= NULL;
741: END IF; --}
742: IF x_return_status = ddr_emd_util.error THEN --{
743: RETURN;
744: END IF; --}
745: -- Populate measure8 --}
746:

Line 748: IF p_populate_m9 = ddr_emd_util.c_populate_custom THEN --{

744: END IF; --}
745: -- Populate measure8 --}
746:
747: -- Populate measure9 --{
748: IF p_populate_m9 = ddr_emd_util.c_populate_custom THEN --{
749: /*
750: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
751: ,ddr_emd_util.m9
752: ,v_m9_tbl(v_rec_count)

Line 751: ,ddr_emd_util.m9

747: -- Populate measure9 --{
748: IF p_populate_m9 = ddr_emd_util.c_populate_custom THEN --{
749: /*
750: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
751: ,ddr_emd_util.m9
752: ,v_m9_tbl(v_rec_count)
753: ,x_return_status
754: ,x_msg
755: );

Line 758: ELSIF p_populate_m9 = ddr_emd_util.c_populate_standard THEN --}{

754: ,x_msg
755: );
756: */
757: NULL;
758: ELSIF p_populate_m9 = ddr_emd_util.c_populate_standard THEN --}{
759: NULL;
760: ELSE --}{
761: v_m9_tbl(v_rec_count):= NULL;
762: END IF; --}

Line 763: IF x_return_status = ddr_emd_util.error THEN --{

759: NULL;
760: ELSE --}{
761: v_m9_tbl(v_rec_count):= NULL;
762: END IF; --}
763: IF x_return_status = ddr_emd_util.error THEN --{
764: RETURN;
765: END IF; --}
766: -- Populate measure9 --}
767:

Line 769: IF p_populate_m10 = ddr_emd_util.c_populate_custom THEN --{

765: END IF; --}
766: -- Populate measure9 --}
767:
768: -- Populate measure10 --{
769: IF p_populate_m10 = ddr_emd_util.c_populate_custom THEN --{
770: /*
771: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
772: ,ddr_emd_util.m10
773: ,v_m10_tbl(v_rec_count)

Line 772: ,ddr_emd_util.m10

768: -- Populate measure10 --{
769: IF p_populate_m10 = ddr_emd_util.c_populate_custom THEN --{
770: /*
771: ddr_custom_pkg.populate_addtnl_sl_msrs(sls_rec
772: ,ddr_emd_util.m10
773: ,v_m10_tbl(v_rec_count)
774: ,x_return_status
775: ,x_msg
776: );

Line 779: ELSIF p_populate_m10 = ddr_emd_util.c_populate_standard THEN --}{

775: ,x_msg
776: );
777: */
778: NULL;
779: ELSIF p_populate_m10 = ddr_emd_util.c_populate_standard THEN --}{
780: NULL;
781: ELSE --}{
782: v_m10_tbl(v_rec_count):= NULL;
783: END IF; --}

Line 784: IF x_return_status = ddr_emd_util.error THEN --{

780: NULL;
781: ELSE --}{
782: v_m10_tbl(v_rec_count):= NULL;
783: END IF; --}
784: IF x_return_status = ddr_emd_util.error THEN --{
785: RETURN;
786: END IF; --}
787: -- Populate measure10 --}
788:

Line 789: IF MOD(v_rec_count,ddr_emd_util.c_batch_size) = 0 THEN --{

785: RETURN;
786: END IF; --}
787: -- Populate measure10 --}
788:
789: IF MOD(v_rec_count,ddr_emd_util.c_batch_size) = 0 THEN --{
790: FORALL i IN 1..v_rec_count
791: INSERT INTO ddr_b_rtl_sl_addtnl_msrs(rtl_org_cd
792: ,org_bsns_unit_id
793: ,mfg_sku_item_id

Line 909: x_return_status := ddr_emd_util.error;

905: --AND eff_to_dt IS NULL;
906: AND eff_to_dt = to_date('01012400','MMDDYYYY');
907: EXCEPTION
908: WHEN TOO_MANY_ROWS THEN
909: x_return_status := ddr_emd_util.error;
910: x_msg := 'org_cd and bsns_unit_cd combination not unique';
911: RETURN;
912: END;
913: END IF; --}

Line 923: IF x_return_status = ddr_emd_util.error THEN --{

919: ,p_complete_refresh=>TRUE
920: ,x_return_status=>x_return_status
921: ,x_msg=>x_msg
922: );
923: IF x_return_status = ddr_emd_util.error THEN --{
924: RETURN;
925: END IF;
926: END IF; --}
927:

Line 930: v_calc_ifpl_excptn := ddr_emd_util.c_populate_standard;

926: END IF; --}
927:
928:
929: IF p_calc_ifpl_excptn THEN --{
930: v_calc_ifpl_excptn := ddr_emd_util.c_populate_standard;
931: END IF;
932: IF p_calc_oosim_excptn THEN --{
933: v_calc_oosim_excptn := ddr_emd_util.c_populate_standard;
934: END IF;

Line 933: v_calc_oosim_excptn := ddr_emd_util.c_populate_standard;

929: IF p_calc_ifpl_excptn THEN --{
930: v_calc_ifpl_excptn := ddr_emd_util.c_populate_standard;
931: END IF;
932: IF p_calc_oosim_excptn THEN --{
933: v_calc_oosim_excptn := ddr_emd_util.c_populate_standard;
934: END IF;
935:
936: populate_addtnl_sl_msrs_pvt(p_start_date=>TRUNC(SYSDATE - p_date_offset)
937: ,p_end_date=>SYSDATE

Line 956: x_return_status := NVL(x_return_status,ddr_emd_util.success);

952: ,p_complete_refresh=>TRUE
953: ,x_return_status=>x_return_status
954: ,x_msg=>x_msg
955: );
956: x_return_status := NVL(x_return_status,ddr_emd_util.success);
957: EXCEPTION
958: WHEN OTHERS THEN
959: x_return_status := NVL(x_return_status,ddr_emd_util.error);
960: x_msg := NVL(x_msg,SQLERRM); --'Exception raised while processing the request');

Line 959: x_return_status := NVL(x_return_status,ddr_emd_util.error);

955: );
956: x_return_status := NVL(x_return_status,ddr_emd_util.success);
957: EXCEPTION
958: WHEN OTHERS THEN
959: x_return_status := NVL(x_return_status,ddr_emd_util.error);
960: x_msg := NVL(x_msg,SQLERRM); --'Exception raised while processing the request');
961: END calc_exception_measures;
962:
963:

Line 1002: ddr_emd_util.calc_exception_measures(p_date_offset => p_date_offset ,

998: ELSE
999: B_CALC_NPISALES_EXCPTN:=FALSE;
1000: V_CALC_NPISALES_EXCPTN:='FALSE';
1001: END IF;
1002: ddr_emd_util.calc_exception_measures(p_date_offset => p_date_offset ,
1003: P_BSNS_UNIT_CD => P_BSNS_UNIT_CD ,
1004: P_RTL_ORG_CD => P_RTL_ORG_CD ,
1005: P_CALC_IFPL_EXCPTN =>B_CALC_IFPL_EXCPTN ,
1006: P_CALC_OOSIM_EXCPTN =>B_CALC_OOSIM_EXCPTN ,

Line 1012: x_return_status := NVL(x_return_status,ddr_emd_util.error);

1008: X_RETURN_STATUS =>X_RETURN_STATUS ,
1009: X_MSG => X_MSG ) ;
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: x_return_status := NVL(x_return_status,ddr_emd_util.error);
1013: X_MSG := NVL(X_MSG,SQLERRM); --'Exception raised while processing the request');
1014: END calc_exception_measures_wrp;
1015:
1016: END ddr_emd_util;

Line 1016: END ddr_emd_util;

1012: x_return_status := NVL(x_return_status,ddr_emd_util.error);
1013: X_MSG := NVL(X_MSG,SQLERRM); --'Exception raised while processing the request');
1014: END calc_exception_measures_wrp;
1015:
1016: END ddr_emd_util;