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 2240: MSC_ATP_UTILS.put_into_temp_table(

2236: -- Bug 2280196 Base Bug 2262291 Added by : krajan
2237: IF PG_DEBUG in ('Y', 'C') THEN
2238: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Put into temp table for MSCBALWB');
2239: END IF;
2240: MSC_ATP_UTILS.put_into_temp_table(
2241: NULL,
2242: p_session_id,
2243: x_atp_rec,
2244: x_atp_supply_demand,

Line 2247: MSC_ATP_UTILS.RESULTS_MODE,

2243: x_atp_rec,
2244: x_atp_supply_demand,
2245: x_atp_period,
2246: x_atp_details,
2247: MSC_ATP_UTILS.RESULTS_MODE,
2248: x_return_status,
2249: x_msg_data,
2250: x_msg_count);
2251: -- End of change - Bug 2280196

Line 2256: MSC_ATP_UTILS.Get_From_Temp_Table(

2252:
2253: ---since we update instead of insert, we need to get the updated data as well.
2254: --but we do it only for PDS case where model is present in the request
2255: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT = 1 THEN
2256: MSC_ATP_UTILS.Get_From_Temp_Table(
2257: null,
2258: p_session_id,
2259: x_atp_rec,
2260: x_atp_supply_demand,

Line 2263: MSC_ATP_UTILS.RESULTS_MODE,

2259: x_atp_rec,
2260: x_atp_supply_demand,
2261: x_atp_period,
2262: x_atp_details,
2263: MSC_ATP_UTILS.RESULTS_MODE,
2264: x_return_status,
2265: x_msg_data,
2266: x_msg_count,
2267: l_details_flag);

Line 2355: MSC_ATP_UTILS.put_into_temp_table(

2351: l_atp_rec_temp := l_custom_atp_rec;
2352:
2353: END IF;
2354:
2355: MSC_ATP_UTILS.put_into_temp_table(
2356: l_a2m_dblink, --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
2357: --l_db_profile,
2358: p_session_id,
2359: --x_atp_rec,

Line 2364: MSC_ATP_UTILS.RESULTS_MODE,

2360: l_atp_rec_temp,
2361: x_atp_supply_demand,
2362: x_atp_period,
2363: x_atp_details,
2364: MSC_ATP_UTILS.RESULTS_MODE,
2365: x_return_status,
2366: x_msg_data,
2367: x_msg_count);
2368:

Line 2372: MSC_ATP_UTILS.Get_From_Temp_Table(

2368:
2369: ---since we update instead of insert, we need to get the updated data as well.
2370: --but we do it only for PDS case where model is present in the request
2371: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT = 1 THEN
2372: MSC_ATP_UTILS.Get_From_Temp_Table(
2373: null,
2374: p_session_id,
2375: --x_atp_rec,
2376: l_atp_rec_temp,

Line 2380: MSC_ATP_UTILS.RESULTS_MODE,

2376: l_atp_rec_temp,
2377: x_atp_supply_demand,
2378: x_atp_period,
2379: x_atp_details,
2380: MSC_ATP_UTILS.RESULTS_MODE,
2381: x_return_status,
2382: x_msg_data,
2383: x_msg_count,
2384: l_details_flag);

Line 2391: MSC_ATP_UTILS.Retrieve_Period_And_SD_Data(p_session_id,

2387:
2388: IF p_atp_rec.attribute_04.count > 0 AND
2389: NVL(p_atp_rec.attribute_04(1),0) = 1
2390: THEN
2391: MSC_ATP_UTILS.Retrieve_Period_And_SD_Data(p_session_id,
2392: x_atp_period,
2393: x_atp_supply_demand);
2394: END IF;
2395:

Line 2398: MSC_ATP_UTILS.put_into_temp_table(

2394: END IF;
2395:
2396: ELSE
2397: /* s_cto_rearch- ATP is called from the source.
2398: MSC_ATP_UTILS.put_into_temp_table(
2399: NULL,
2400: p_session_id,
2401: l_atp_rec,
2402: x_atp_supply_demand,

Line 2405: MSC_ATP_UTILS.REQUEST_MODE,

2401: l_atp_rec,
2402: x_atp_supply_demand,
2403: x_atp_period,
2404: x_atp_details,
2405: MSC_ATP_UTILS.REQUEST_MODE,
2406: x_return_status,
2407: x_msg_data,
2408: x_msg_count);
2409:

Line 2489: MSC_ATP_UTILS.Get_From_Temp_Table(

2485: ELSE
2486: l_details_flag := 2;
2487: END IF;
2488:
2489: MSC_ATP_UTILS.Get_From_Temp_Table(
2490: null,
2491: p_session_id,
2492: --x_atp_rec,
2493: l_atp_rec_temp,

Line 2497: MSC_ATP_UTILS.RESULTS_MODE,

2493: l_atp_rec_temp,
2494: x_atp_supply_demand,
2495: x_atp_period,
2496: x_atp_details,
2497: MSC_ATP_UTILS.RESULTS_MODE,
2498: x_return_status,
2499: x_msg_data,
2500: x_msg_count,
2501: l_details_flag);

Line 2755: MSC_ATP_UTILS.put_into_temp_table(

2751: --- ATP inquiry gets data from mrp_atp_schedule_temp table.
2752: --- If something goes wrong in ATP inquiry then we never get to the point to
2753: --- put the data back in the above table
2754: --AS a result we dont get a clue from ATP inquiry form as to what went wrong
2755: MSC_ATP_UTILS.put_into_temp_table(
2756: NULL, -- G_DB_PROFILE, dsting insert into source not dest
2757: p_session_id,
2758: x_atp_rec,
2759: x_atp_supply_demand,

Line 2762: MSC_ATP_UTILS.REQUEST_MODE,

2758: x_atp_rec,
2759: x_atp_supply_demand,
2760: x_atp_period,
2761: x_atp_details,
2762: MSC_ATP_UTILS.REQUEST_MODE,
2763: x_return_status,
2764: x_msg_data,
2765: x_msg_count);
2766:

Line 2844: MSC_ATP_UTILS.put_into_temp_table(

2840: --- ATP inquiry gets data from mrp_atp_schedule_temp table.
2841: --- If something goes wrong in ATP inquiry then we never get to the point to
2842: --- put the data back in the above table
2843: --AS a result we dont get a clue from ATP inquiry form as to what went wrong
2844: MSC_ATP_UTILS.put_into_temp_table(
2845: NULL, -- G_DB_PROFILE, dsting insert into src not dest
2846: p_session_id,
2847: x_atp_rec,
2848: x_atp_supply_demand,

Line 2851: MSC_ATP_UTILS.REQUEST_MODE,

2847: x_atp_rec,
2848: x_atp_supply_demand,
2849: x_atp_period,
2850: x_atp_details,
2851: MSC_ATP_UTILS.REQUEST_MODE,
2852: x_return_status,
2853: x_msg_data,
2854: x_msg_count);
2855: