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.

[Home] [Help]

APPS.MSC_ATP_DB_UTILS dependencies on MRP_ATP_DETAILS_TEMP

Line 668: p_pegging_rec IN mrp_atp_details_temp%ROWTYPE,

664: END Add_Mat_Demand;
665:
666:
667: PROCEDURE Add_Pegging(
668: p_pegging_rec IN mrp_atp_details_temp%ROWTYPE,
669: x_pegging_id OUT NoCopy NUMBER
670: )
671: IS
672: temp number;

Line 688: INSERT into mrp_atp_details_temp

684: msc_sch_wb.atp_debug('Add_Pegging: ' || 'component_yield_factor := ' || p_pegging_rec.component_yield_factor);
685:
686: END IF;
687:
688: INSERT into mrp_atp_details_temp
689: (session_id,
690: order_line_id,
691: pegging_id,
692: parent_pegging_id,

Line 1248: DELETE FROM mrp_atp_details_temp

1244: IF PG_DEBUG in ('Y', 'C') THEN
1245: msc_sch_wb.atp_debug('Begin delete_pegging,p_pegging_id='||p_pegging_id);
1246: END IF;
1247:
1248: DELETE FROM mrp_atp_details_temp
1249: WHERE pegging_id = p_pegging_id
1250: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
1251:
1252: IF PG_DEBUG in ('Y', 'C') THEN

Line 2086: from mrp_atp_details_temp

2082: supply_demand_quantity, department_id, resource_id, order_line_id, supplier_id, supplier_site_id,
2083: supplier_atp_date, dest_inv_item_id, summary_flag
2084: -- time_phased_atp
2085: , aggregate_time_fence_date
2086: from mrp_atp_details_temp
2087: where ((pegging_id <> p_identifier and (p_mode = 2 or p_mode = 3)) or
2088: (p_mode = 1))
2089: and record_type in (3,4)
2090: and session_id = MSC_ATP_PVT.G_SESSION_ID

Line 2622: UPDATE mrp_atp_details_temp

2618: IF PG_DEBUG in ('Y', 'C') THEN
2619: msc_sch_wb.atp_debug('Begin Update_Pegging,p_pegging_id='||p_pegging_id);
2620: END IF;
2621:
2622: UPDATE mrp_atp_details_temp
2623: SET supply_demand_quantity = NVL(p_quantity, supply_demand_quantity),
2624: supply_demand_date = NVL(p_date, supply_demand_date),
2625: --bug 3328421
2626: --required_date = NVL(p_date, supply_demand_date)

Line 2712: FROM mrp_atp_details_temp

2708: , receiving_organization_id, organization_id, identifier1 -- ATP4drp
2709: INTO l_transaction_id, l_sd_date, l_po_qty, l_summary_flag
2710: ,l_atf_date -- for time_phased_atp
2711: , l_receive_org_id, l_organization_id, l_instance_id -- ATP4drp
2712: FROM mrp_atp_details_temp
2713: WHERE pegging_id = p_pegging_id
2714: AND record_type = 3
2715: AND session_id = MSC_ATP_PVT.G_SESSION_ID ;
2716:

Line 2743: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'after delete mrp_atp_details_temp by calling remove');

2739: 0,
2740: l_return_status);
2741:
2742: IF PG_DEBUG in ('Y', 'C') THEN
2743: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'after delete mrp_atp_details_temp by calling remove');
2744: END IF;
2745:
2746: --s_cto_rearch
2747: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN

Line 2765: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'after first update to mrp_atp_details_temp');

2761: MSC_ATP_DB_UTILS.Update_Pegging(p_pegging_id, p_date, p_quantity);
2762: END IF;
2763:
2764: IF PG_DEBUG in ('Y', 'C') THEN
2765: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'after first update to mrp_atp_details_temp');
2766: END IF;
2767:
2768: -- For bug 2259824, move the supply to the end of day
2769: --s_cto_rearch:

Line 3006: FROM mrp_atp_details_temp

3002: SELECT identifier3, pegging_id, NVL(identifier2, p_plan_id), supply_demand_date,
3003: supply_demand_quantity, organization_id, supplier_atp_date, summary_flag
3004: INTO l_demand_id, l_child_pegging_id, l_plan_id, l_sd_date, l_sd_qty, l_organization_id,
3005: l_supplier_atp_date, l_summary_flag
3006: FROM mrp_atp_details_temp
3007: WHERE parent_pegging_id = p_pegging_id
3008: AND record_type = 3
3009: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
3010:

Line 3214: UPDATE mrp_atp_details_temp

3210: END IF;
3211:
3212: -- dsting ATO 2465370
3213: BEGIN
3214: UPDATE mrp_atp_details_temp
3215: --bug 3328421
3216: --SET required_date = TRUNC(NVL(p_supply_demand_date, required_date)) + MSC_ATP_PVT.G_END_OF_DAY
3217: SET actual_supply_demand_date = TRUNC(NVL(p_supply_demand_date, actual_supply_demand_date)) + MSC_ATP_PVT.G_END_OF_DAY
3218: WHERE pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID

Line 3265: from mrp_atp_details_temp

3261: BEGIN
3262: --- G_DEMAND_PEGGING_ID wil be null for non atpbale items
3263: select supply_demand_quantity, supply_demand_date, organization_id
3264: into l_sd_qty, l_sd_date, l_org_id
3265: from mrp_atp_details_temp
3266: where pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
3267: and session_id = MSC_ATP_PVT.G_SESSION_ID
3268: and record_type = 3;
3269: EXCEPTION

Line 4451: FROM mrp_atp_details_temp

4447:
4448: CURSOR pegging(p_pegging_id IN NUMBER)
4449: IS
4450: SELECT pegging_id, identifier1, identifier2, identifier3
4451: FROM mrp_atp_details_temp
4452: WHERE pegging_id = p_pegging_id
4453: AND record_type in (3,4)
4454: AND session_id = MSC_ATP_PVT.G_SESSION_ID
4455: START WITH pegging_id = p_pegging_id

Line 4510: * into mrp_atp_details_temp. Plus, slap on a pegging id and

4506: /*
4507: * dsting: 9/17/2002
4508: *
4509: * Copy the data from the msc_atp_sd_details_temp table
4510: * into mrp_atp_details_temp. Plus, slap on a pegging id and
4511: * end_pegging_id
4512: *
4513: * Delete the entries in msc_atp_sd_details_temp
4514: * since we don't need them anymore too.

Line 4530: INSERT INTO mrp_atp_details_temp (

4526: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' p_end_pegging_id: ' || p_end_pegging_id);
4527: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' session_id: ' || MSC_ATP_PVT.G_SESSION_ID);
4528: END IF;
4529:
4530: INSERT INTO mrp_atp_details_temp (
4531: session_id,
4532: scenario_id,
4533: order_line_id,
4534: ATP_Level,