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.9 2007/12/12 10:42:48 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.9 2007/12/12 10:42:48 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 put_into_temp_table

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 823: MSC_ATP_UTILS.Retrieve_Period_And_SD_Data(x_session_id,

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

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

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

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

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

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

3109: msc_sch_wb.atp_debug('After updating item properties');
3110: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
3111: END IF;
3112: */
3113: MSC_ATP_UTILS.Update_Line_item_properties(p_session_id, p_atp_rec.action(1)); --3720018
3114: /*
3115: -- Bug 3449812 - Removed IF to populate internal_org in all cases
3116: -- IF MSC_ATP_PVT.G_INV_CTP = 4 THEN
3117: --add condition to fiter based on atp query

Line 3972: END MSC_ATP_UTILS;

3968: END IF;
3969: END Truncate_Demand;
3970:
3971:
3972: END MSC_ATP_UTILS;
3973: