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_UTILS dependencies on MSC_ATP_UTILS

Line 1: PACKAGE BODY MSC_ATP_UTILS AS

1: PACKAGE BODY MSC_ATP_UTILS AS
2: /* $Header: MSCUATPB.pls 120.10 2011/08/10 07:40:02 sbnaik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_UTILS';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_UTILS';

1: PACKAGE BODY MSC_ATP_UTILS AS
2: /* $Header: MSCUATPB.pls 120.10 2011/08/10 07:40:02 sbnaik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_UTILS';
5:
6: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
7:
8: procedure Update_Line_Item_Properties_WS(p_session_id IN NUMBER);

Line 72: MSC_ATP_UTILS.PUT_SD_DATA(x_atp_supply_demand, x_dblink, x_session_id);

68:
69: -- moved deleting old records from mrp_atp_details_temp to call_schedule_remote
70:
71: /*
72: MSC_ATP_UTILS.PUT_SD_DATA(x_atp_supply_demand, x_dblink, x_session_id);
73: IF PG_DEBUG in ('Y', 'C') THEN
74: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted supply demand records ');
75: END IF;
76:

Line 77: -- MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, x_dblink, x_session_id);

73: IF PG_DEBUG in ('Y', 'C') THEN
74: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted supply demand records ');
75: END IF;
76:
77: -- MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, x_dblink, x_session_id);
78: -- dsting call it with null because we'll transfer it later
79: -- I'm not really expecting anything here
80: IF PG_DEBUG in ('Y', 'C') THEN
81: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' dsting expect 0 period recs: ' || x_atp_period.level.count);

Line 83: MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, NULL, x_session_id);

79: -- I'm not really expecting anything here
80: IF PG_DEBUG in ('Y', 'C') THEN
81: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' dsting expect 0 period recs: ' || x_atp_period.level.count);
82: END IF;
83: MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, NULL, x_session_id);
84:
85: IF PG_DEBUG in ('Y', 'C') THEN
86: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted period records ');
87: msc_sch_wb.atp_debug('enter put_into_temp_table :30');

Line 91: -- MSC_ATP_UTILS.PUT_Pegging_Data(x_session_id, x_dblink);

87: msc_sch_wb.atp_debug('enter put_into_temp_table :30');
88: END IF;
89:
90: -- dsting transfer it later
91: -- MSC_ATP_UTILS.PUT_Pegging_Data(x_session_id, x_dblink);
92:
93: IF PG_DEBUG in ('Y', 'C') THEN
94: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'Inserted Pegging Records');
95: END IF;

Line 98: MSC_ATP_UTILS.Put_Scheduling_data(x_atp_rec, x_mode, x_dblink, x_session_id);

94: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'Inserted Pegging Records');
95: END IF;
96: */
97:
98: MSC_ATP_UTILS.Put_Scheduling_data(x_atp_rec, x_mode, x_dblink, x_session_id);
99:
100: IF PG_DEBUG in ('Y', 'C') THEN
101: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted main records ');
102: END IF;

Line 196: MSC_ATP_UTILS.Transfer_scheduling_data(x_session_id, x_dblink, REQUEST_MODE);

192: delete mrp_atp_details_temp
193: where session_id = x_session_id;
194:
195: --transfer the date from source to dest mrp_atp_schedule_temp
196: MSC_ATP_UTILS.Transfer_scheduling_data(x_session_id, x_dblink, REQUEST_MODE);
197: END IF;
198: ---e_cto_rearch
199:
200: IF PG_DEBUG in ('Y', 'C') THEN

Line 552: AND ORDER_LINE_ID = DECODE( x_mode, MSC_ATP_UTILS.RESULTS_MODE, ORDER_LINE_ID,

548: FROM mrp_atp_schedule_temp
549: WHERE session_id = x_session_id
550: AND status_flag = l_status_flag
551: AND NVL(mandatory_item_flag, 2) = 2
552: AND ORDER_LINE_ID = DECODE( x_mode, MSC_ATP_UTILS.RESULTS_MODE, ORDER_LINE_ID,
553: NVL(ATO_Model_Line_Id, ORDER_LINE_ID))
554: ORDER BY sequence_number;
555:
556: IF PG_DEBUG in ('Y', 'C') THEN

Line 825: MSC_ATP_UTILS.Retrieve_Period_And_SD_Data(x_session_id,

821:
822: */
823: --e_cto_reach
824: IF x_mode = RESULTS_MODE and NVL(p_details_flag, 2) = 1 THEN
825: MSC_ATP_UTILS.Retrieve_Period_And_SD_Data(x_session_id,
826: x_atp_period,
827: x_atp_supply_demand);
828:
829: IF PG_DEBUG in ('Y', 'C') THEN

Line 1901: MSC_ATP_UTILS.Put_sch_data_result_mode(p_atp_rec, p_dblink, p_session_id);

1897: IF p_mode = RESULTS_MODE THEN
1898: IF PG_DEBUG in ('Y', 'C') THEN
1899: msc_sch_wb.atp_debug('Put_Scheduling_data in results mode: ' || ' output records '|| l_count );
1900: END IF;
1901: MSC_ATP_UTILS.Put_sch_data_result_mode(p_atp_rec, p_dblink, p_session_id);
1902: ELSE
1903: MSC_ATP_UTILS.Put_sch_Data_Request_mode(p_atp_rec, p_session_id);
1904: END IF;
1905: END IF;

Line 1903: MSC_ATP_UTILS.Put_sch_Data_Request_mode(p_atp_rec, p_session_id);

1899: msc_sch_wb.atp_debug('Put_Scheduling_data in results mode: ' || ' output records '|| l_count );
1900: END IF;
1901: MSC_ATP_UTILS.Put_sch_data_result_mode(p_atp_rec, p_dblink, p_session_id);
1902: ELSE
1903: MSC_ATP_UTILS.Put_sch_Data_Request_mode(p_atp_rec, p_session_id);
1904: END IF;
1905: END IF;
1906: ---e_cto_rearch
1907:

Line 3164: MSC_ATP_UTILS.Update_Line_item_properties_WS(p_session_id);

3160: END IF;
3161: */
3162: -- Web service, no need to change item_properties if call is from Web service
3163: IF (p_atp_rec.attribute_02(1) = 3) THEN
3164: MSC_ATP_UTILS.Update_Line_item_properties_WS(p_session_id);
3165: ELSE
3166: MSC_ATP_UTILS.Update_Line_item_properties(p_session_id, p_atp_rec.action(1)); --3720018
3167: END IF;
3168: /*

Line 3166: MSC_ATP_UTILS.Update_Line_item_properties(p_session_id, p_atp_rec.action(1)); --3720018

3162: -- Web service, no need to change item_properties if call is from Web service
3163: IF (p_atp_rec.attribute_02(1) = 3) THEN
3164: MSC_ATP_UTILS.Update_Line_item_properties_WS(p_session_id);
3165: ELSE
3166: MSC_ATP_UTILS.Update_Line_item_properties(p_session_id, p_atp_rec.action(1)); --3720018
3167: END IF;
3168: /*
3169: -- Bug 3449812 - Removed IF to populate internal_org in all cases
3170: -- IF MSC_ATP_PVT.G_INV_CTP = 4 THEN

Line 4026: END MSC_ATP_UTILS;

4022: END IF;
4023: END Truncate_Demand;
4024:
4025:
4026: END MSC_ATP_UTILS;
4027: