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

Line 2211: MSC_ATP_UTILS.put_into_temp_table(

2207: -- Bug 2280196 Base Bug 2262291 Added by : krajan
2208: IF PG_DEBUG in ('Y', 'C') THEN
2209: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Put into temp table for MSCBALWB');
2210: END IF;
2211: MSC_ATP_UTILS.put_into_temp_table(
2212: NULL,
2213: p_session_id,
2214: x_atp_rec,
2215: x_atp_supply_demand,

Line 2218: MSC_ATP_UTILS.RESULTS_MODE,

2214: x_atp_rec,
2215: x_atp_supply_demand,
2216: x_atp_period,
2217: x_atp_details,
2218: MSC_ATP_UTILS.RESULTS_MODE,
2219: x_return_status,
2220: x_msg_data,
2221: x_msg_count);
2222: -- End of change - Bug 2280196

Line 2227: MSC_ATP_UTILS.Get_From_Temp_Table(

2223:
2224: ---since we update instead of insert, we need to get the updated data as well.
2225: --but we do it only for PDS case where model is present in the request
2226: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT = 1 THEN
2227: MSC_ATP_UTILS.Get_From_Temp_Table(
2228: null,
2229: p_session_id,
2230: x_atp_rec,
2231: x_atp_supply_demand,

Line 2234: MSC_ATP_UTILS.RESULTS_MODE,

2230: x_atp_rec,
2231: x_atp_supply_demand,
2232: x_atp_period,
2233: x_atp_details,
2234: MSC_ATP_UTILS.RESULTS_MODE,
2235: x_return_status,
2236: x_msg_data,
2237: x_msg_count,
2238: l_details_flag);

Line 2326: MSC_ATP_UTILS.put_into_temp_table(

2322: l_atp_rec_temp := l_custom_atp_rec;
2323:
2324: END IF;
2325:
2326: MSC_ATP_UTILS.put_into_temp_table(
2327: l_a2m_dblink, --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
2328: --l_db_profile,
2329: p_session_id,
2330: --x_atp_rec,

Line 2335: MSC_ATP_UTILS.RESULTS_MODE,

2331: l_atp_rec_temp,
2332: x_atp_supply_demand,
2333: x_atp_period,
2334: x_atp_details,
2335: MSC_ATP_UTILS.RESULTS_MODE,
2336: x_return_status,
2337: x_msg_data,
2338: x_msg_count);
2339:

Line 2343: MSC_ATP_UTILS.Get_From_Temp_Table(

2339:
2340: ---since we update instead of insert, we need to get the updated data as well.
2341: --but we do it only for PDS case where model is present in the request
2342: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT = 1 THEN
2343: MSC_ATP_UTILS.Get_From_Temp_Table(
2344: null,
2345: p_session_id,
2346: --x_atp_rec,
2347: l_atp_rec_temp,

Line 2351: MSC_ATP_UTILS.RESULTS_MODE,

2347: l_atp_rec_temp,
2348: x_atp_supply_demand,
2349: x_atp_period,
2350: x_atp_details,
2351: MSC_ATP_UTILS.RESULTS_MODE,
2352: x_return_status,
2353: x_msg_data,
2354: x_msg_count,
2355: l_details_flag);

Line 2362: MSC_ATP_UTILS.Retrieve_Period_And_SD_Data(p_session_id,

2358:
2359: IF p_atp_rec.attribute_04.count > 0 AND
2360: NVL(p_atp_rec.attribute_04(1),0) = 1
2361: THEN
2362: MSC_ATP_UTILS.Retrieve_Period_And_SD_Data(p_session_id,
2363: x_atp_period,
2364: x_atp_supply_demand);
2365: END IF;
2366:

Line 2369: MSC_ATP_UTILS.put_into_temp_table(

2365: END IF;
2366:
2367: ELSE
2368: /* s_cto_rearch- ATP is called from the source.
2369: MSC_ATP_UTILS.put_into_temp_table(
2370: NULL,
2371: p_session_id,
2372: l_atp_rec,
2373: x_atp_supply_demand,

Line 2376: MSC_ATP_UTILS.REQUEST_MODE,

2372: l_atp_rec,
2373: x_atp_supply_demand,
2374: x_atp_period,
2375: x_atp_details,
2376: MSC_ATP_UTILS.REQUEST_MODE,
2377: x_return_status,
2378: x_msg_data,
2379: x_msg_count);
2380:

Line 2460: MSC_ATP_UTILS.Get_From_Temp_Table(

2456: ELSE
2457: l_details_flag := 2;
2458: END IF;
2459:
2460: MSC_ATP_UTILS.Get_From_Temp_Table(
2461: null,
2462: p_session_id,
2463: --x_atp_rec,
2464: l_atp_rec_temp,

Line 2468: MSC_ATP_UTILS.RESULTS_MODE,

2464: l_atp_rec_temp,
2465: x_atp_supply_demand,
2466: x_atp_period,
2467: x_atp_details,
2468: MSC_ATP_UTILS.RESULTS_MODE,
2469: x_return_status,
2470: x_msg_data,
2471: x_msg_count,
2472: l_details_flag);

Line 2721: MSC_ATP_UTILS.put_into_temp_table(

2717: --- ATP inquiry gets data from mrp_atp_schedule_temp table.
2718: --- If something goes wrong in ATP inquiry then we never get to the point to
2719: --- put the data back in the above table
2720: --AS a result we dont get a clue from ATP inquiry form as to what went wrong
2721: MSC_ATP_UTILS.put_into_temp_table(
2722: NULL, -- G_DB_PROFILE, dsting insert into source not dest
2723: p_session_id,
2724: x_atp_rec,
2725: x_atp_supply_demand,

Line 2728: MSC_ATP_UTILS.REQUEST_MODE,

2724: x_atp_rec,
2725: x_atp_supply_demand,
2726: x_atp_period,
2727: x_atp_details,
2728: MSC_ATP_UTILS.REQUEST_MODE,
2729: x_return_status,
2730: x_msg_data,
2731: x_msg_count);
2732:

Line 2810: MSC_ATP_UTILS.put_into_temp_table(

2806: --- ATP inquiry gets data from mrp_atp_schedule_temp table.
2807: --- If something goes wrong in ATP inquiry then we never get to the point to
2808: --- put the data back in the above table
2809: --AS a result we dont get a clue from ATP inquiry form as to what went wrong
2810: MSC_ATP_UTILS.put_into_temp_table(
2811: NULL, -- G_DB_PROFILE, dsting insert into src not dest
2812: p_session_id,
2813: x_atp_rec,
2814: x_atp_supply_demand,

Line 2817: MSC_ATP_UTILS.REQUEST_MODE,

2813: x_atp_rec,
2814: x_atp_supply_demand,
2815: x_atp_period,
2816: x_atp_details,
2817: MSC_ATP_UTILS.REQUEST_MODE,
2818: x_return_status,
2819: x_msg_data,
2820: x_msg_count);
2821: