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.MSC_ATP_DRP dependencies on MSC_SCH_WB

Line 20: msc_sch_wb.atp_debug(' Begin Get_Mat_Avail_Drp ');

16: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
17: ) IS
18: BEGIN
19: IF PG_DEBUG in ('Y', 'C') THEN
20: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp **********');
21: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_item_id ' || p_item_id);
22: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_org_id ' || p_org_id);
23: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_instance_id ' || p_instance_id);
24: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_plan_id ' || p_plan_id);

Line 21: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_item_id ' || p_item_id);

17: ) IS
18: BEGIN
19: IF PG_DEBUG in ('Y', 'C') THEN
20: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp **********');
21: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_item_id ' || p_item_id);
22: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_org_id ' || p_org_id);
23: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_instance_id ' || p_instance_id);
24: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_plan_id ' || p_plan_id);
25: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_itf ' || p_itf);

Line 22: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_org_id ' || p_org_id);

18: BEGIN
19: IF PG_DEBUG in ('Y', 'C') THEN
20: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp **********');
21: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_item_id ' || p_item_id);
22: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_org_id ' || p_org_id);
23: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_instance_id ' || p_instance_id);
24: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_plan_id ' || p_plan_id);
25: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_itf ' || p_itf);
26: END IF;

Line 23: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_instance_id ' || p_instance_id);

19: IF PG_DEBUG in ('Y', 'C') THEN
20: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp **********');
21: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_item_id ' || p_item_id);
22: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_org_id ' || p_org_id);
23: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_instance_id ' || p_instance_id);
24: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_plan_id ' || p_plan_id);
25: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_itf ' || p_itf);
26: END IF;
27:

Line 24: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_plan_id ' || p_plan_id);

20: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp **********');
21: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_item_id ' || p_item_id);
22: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_org_id ' || p_org_id);
23: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_instance_id ' || p_instance_id);
24: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_plan_id ' || p_plan_id);
25: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_itf ' || p_itf);
26: END IF;
27:
28: SELECT SD_DATE, SUM(SD_QTY)

Line 25: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_itf ' || p_itf);

21: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_item_id ' || p_item_id);
22: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_org_id ' || p_org_id);
23: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_instance_id ' || p_instance_id);
24: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_plan_id ' || p_plan_id);
25: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp: p_itf ' || p_itf);
26: END IF;
27:
28: SELECT SD_DATE, SUM(SD_QTY)
29: BULK COLLECT INTO x_atp_dates, x_atp_qtys

Line 95: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp : Total Row Count ' || x_atp_qtys.COUNT );

91: )
92: GROUP BY SD_DATE;
93:
94: IF PG_DEBUG in ('Y', 'C') THEN
95: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp : Total Row Count ' || x_atp_qtys.COUNT );
96: msc_sch_wb.atp_debug('******** Get_Mat_Avail_Drp End ********');
97: END IF;
98:
99:

Line 96: msc_sch_wb.atp_debug(' Get_Mat_Avail_Drp End ');

92: GROUP BY SD_DATE;
93:
94: IF PG_DEBUG in ('Y', 'C') THEN
95: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp : Total Row Count ' || x_atp_qtys.COUNT );
96: msc_sch_wb.atp_debug('******** Get_Mat_Avail_Drp End ********');
97: END IF;
98:
99:
100: END Get_Mat_Avail_Drp;

Line 122: msc_sch_wb.atp_debug(' Begin Get_Mat_Avail_Drp_Dtls ');

118: l_sysdate DATE := sysdate;
119: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
120: BEGIN
121: IF PG_DEBUG in ('Y', 'C') THEN
122: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Dtls **********');
123: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_item_id ' || p_item_id);
124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_request_item_id ' || p_request_item_id);
125: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_org_id ' || p_org_id);
126: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_instance_id ' || p_instance_id);

Line 123: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_item_id ' || p_item_id);

119: l_user_id NUMBER := FND_GLOBAL.USER_ID; -- Declare and Define value.
120: BEGIN
121: IF PG_DEBUG in ('Y', 'C') THEN
122: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Dtls **********');
123: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_item_id ' || p_item_id);
124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_request_item_id ' || p_request_item_id);
125: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_org_id ' || p_org_id);
126: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_instance_id ' || p_instance_id);
127: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_plan_id ' || p_plan_id);

Line 124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_request_item_id ' || p_request_item_id);

120: BEGIN
121: IF PG_DEBUG in ('Y', 'C') THEN
122: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Dtls **********');
123: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_item_id ' || p_item_id);
124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_request_item_id ' || p_request_item_id);
125: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_org_id ' || p_org_id);
126: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_instance_id ' || p_instance_id);
127: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_plan_id ' || p_plan_id);
128: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_itf ' || p_itf);

Line 125: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_org_id ' || p_org_id);

121: IF PG_DEBUG in ('Y', 'C') THEN
122: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Dtls **********');
123: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_item_id ' || p_item_id);
124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_request_item_id ' || p_request_item_id);
125: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_org_id ' || p_org_id);
126: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_instance_id ' || p_instance_id);
127: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_plan_id ' || p_plan_id);
128: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_itf ' || p_itf);
129: END IF;

Line 126: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_instance_id ' || p_instance_id);

122: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Dtls **********');
123: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_item_id ' || p_item_id);
124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_request_item_id ' || p_request_item_id);
125: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_org_id ' || p_org_id);
126: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_instance_id ' || p_instance_id);
127: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_plan_id ' || p_plan_id);
128: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_itf ' || p_itf);
129: END IF;
130:

Line 127: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_plan_id ' || p_plan_id);

123: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_item_id ' || p_item_id);
124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_request_item_id ' || p_request_item_id);
125: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_org_id ' || p_org_id);
126: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_instance_id ' || p_instance_id);
127: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_plan_id ' || p_plan_id);
128: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_itf ' || p_itf);
129: END IF;
130:
131: INSERT INTO msc_atp_sd_details_temp (

Line 128: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_itf ' || p_itf);

124: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_request_item_id ' || p_request_item_id);
125: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_org_id ' || p_org_id);
126: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_instance_id ' || p_instance_id);
127: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_plan_id ' || p_plan_id);
128: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: p_itf ' || p_itf);
129: END IF;
130:
131: INSERT INTO msc_atp_sd_details_temp (
132: ATP_Level,

Line 363: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);

359: < NVL(p_itf, TRUNC(NVL(S.FIRM_DATE,S.NEW_SHIP_DATE)) + 1)
360: )
361: ;
362: IF PG_DEBUG in ('Y', 'C') THEN
363: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);
364: msc_sch_wb.atp_debug('******** Get_Mat_Avail_Drp_Dtls End ********');
365: END IF;
366:
367: END Get_Mat_Avail_Drp_Dtls;

Line 364: msc_sch_wb.atp_debug(' Get_Mat_Avail_Drp_Dtls End ');

360: )
361: ;
362: IF PG_DEBUG in ('Y', 'C') THEN
363: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Dtls: ' || 'Total Records inserted : ' || SQL%ROWCOUNT);
364: msc_sch_wb.atp_debug('******** Get_Mat_Avail_Drp_Dtls End ********');
365: END IF;
366:
367: END Get_Mat_Avail_Drp_Dtls;
368:

Line 717: msc_sch_wb.atp_debug(' Begin Get_Mat_Avail_Drp_Summ ');

713: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
714: ) IS
715: BEGIN
716: IF PG_DEBUG in ('Y', 'C') THEN
717: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Summ **********');
718: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_item_id ' || p_item_id);
719: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_org_id ' || p_org_id);
720: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_instance_id ' || p_instance_id);
721: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_plan_id ' || p_plan_id);

Line 718: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_item_id ' || p_item_id);

714: ) IS
715: BEGIN
716: IF PG_DEBUG in ('Y', 'C') THEN
717: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Summ **********');
718: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_item_id ' || p_item_id);
719: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_org_id ' || p_org_id);
720: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_instance_id ' || p_instance_id);
721: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_plan_id ' || p_plan_id);
722: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_itf ' || p_itf);

Line 719: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_org_id ' || p_org_id);

715: BEGIN
716: IF PG_DEBUG in ('Y', 'C') THEN
717: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Summ **********');
718: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_item_id ' || p_item_id);
719: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_org_id ' || p_org_id);
720: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_instance_id ' || p_instance_id);
721: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_plan_id ' || p_plan_id);
722: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_itf ' || p_itf);
723: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_refresh_number ' || p_refresh_number);

Line 720: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_instance_id ' || p_instance_id);

716: IF PG_DEBUG in ('Y', 'C') THEN
717: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Summ **********');
718: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_item_id ' || p_item_id);
719: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_org_id ' || p_org_id);
720: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_instance_id ' || p_instance_id);
721: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_plan_id ' || p_plan_id);
722: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_itf ' || p_itf);
723: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_refresh_number ' || p_refresh_number);
724: END IF;

Line 721: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_plan_id ' || p_plan_id);

717: msc_sch_wb.atp_debug('********** Begin Get_Mat_Avail_Drp_Summ **********');
718: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_item_id ' || p_item_id);
719: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_org_id ' || p_org_id);
720: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_instance_id ' || p_instance_id);
721: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_plan_id ' || p_plan_id);
722: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_itf ' || p_itf);
723: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_refresh_number ' || p_refresh_number);
724: END IF;
725:

Line 722: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_itf ' || p_itf);

718: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_item_id ' || p_item_id);
719: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_org_id ' || p_org_id);
720: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_instance_id ' || p_instance_id);
721: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_plan_id ' || p_plan_id);
722: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_itf ' || p_itf);
723: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_refresh_number ' || p_refresh_number);
724: END IF;
725:
726: -- SQL changed for summary enhancement

Line 723: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_refresh_number ' || p_refresh_number);

719: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_org_id ' || p_org_id);
720: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_instance_id ' || p_instance_id);
721: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_plan_id ' || p_plan_id);
722: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_itf ' || p_itf);
723: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ: p_refresh_number ' || p_refresh_number);
724: END IF;
725:
726: -- SQL changed for summary enhancement
727: SELECT SD_DATE, SUM(SD_QTY)

Line 804: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ : Total Row Count ' || x_atp_qtys.COUNT );

800: GROUP BY SD_DATE
801: ORDER BY SD_DATE;
802:
803: IF PG_DEBUG in ('Y', 'C') THEN
804: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ : Total Row Count ' || x_atp_qtys.COUNT );
805: msc_sch_wb.atp_debug('******** Get_Mat_Avail_Drp_Summ End ********');
806: END IF;
807:
808: END get_mat_avail_drp_summ;

Line 805: msc_sch_wb.atp_debug(' Get_Mat_Avail_Drp_Summ End ');

801: ORDER BY SD_DATE;
802:
803: IF PG_DEBUG in ('Y', 'C') THEN
804: msc_sch_wb.atp_debug('Get_Mat_Avail_Drp_Summ : Total Row Count ' || x_atp_qtys.COUNT );
805: msc_sch_wb.atp_debug('******** Get_Mat_Avail_Drp_Summ End ********');
806: END IF;
807:
808: END get_mat_avail_drp_summ;
809: