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_DB_UTILS dependencies on MRP_ATP_DETAILS_TEMP

Line 821: p_pegging_rec IN mrp_atp_details_temp%ROWTYPE,

817: END Add_Mat_Demand;
818:
819:
820: PROCEDURE Add_Pegging(
821: p_pegging_rec IN mrp_atp_details_temp%ROWTYPE,
822: x_pegging_id OUT NoCopy NUMBER
823: )
824: IS
825: temp number;

Line 841: INSERT into mrp_atp_details_temp

837: msc_sch_wb.atp_debug('Add_Pegging: ' || 'component_yield_factor := ' || p_pegging_rec.component_yield_factor);
838:
839: END IF;
840:
841: INSERT into mrp_atp_details_temp
842: (session_id,
843: order_line_id,
844: pegging_id,
845: parent_pegging_id,

Line 1401: DELETE FROM mrp_atp_details_temp

1397: IF PG_DEBUG in ('Y', 'C') THEN
1398: msc_sch_wb.atp_debug('Begin delete_pegging,p_pegging_id='||p_pegging_id);
1399: END IF;
1400:
1401: DELETE FROM mrp_atp_details_temp
1402: WHERE pegging_id = p_pegging_id
1403: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
1404:
1405: IF PG_DEBUG in ('Y', 'C') THEN

Line 2239: from mrp_atp_details_temp

2235: supply_demand_quantity, department_id, resource_id, order_line_id, supplier_id, supplier_site_id,
2236: supplier_atp_date, dest_inv_item_id, summary_flag
2237: -- time_phased_atp
2238: , aggregate_time_fence_date
2239: from mrp_atp_details_temp
2240: where ((pegging_id <> p_identifier and (p_mode = 2 or p_mode = 3)) or
2241: (p_mode = 1))
2242: and record_type in (3,4)
2243: and session_id = MSC_ATP_PVT.G_SESSION_ID

Line 2784: UPDATE mrp_atp_details_temp

2780: IF PG_DEBUG in ('Y', 'C') THEN
2781: msc_sch_wb.atp_debug('Begin Update_Pegging,p_pegging_id='||p_pegging_id);
2782: END IF;
2783:
2784: UPDATE mrp_atp_details_temp
2785: SET supply_demand_quantity = NVL(p_quantity, supply_demand_quantity),
2786: supply_demand_date = NVL(p_date, supply_demand_date),
2787: --bug 3328421
2788: --required_date = NVL(p_date, supply_demand_date)

Line 2874: FROM mrp_atp_details_temp

2870: , receiving_organization_id, organization_id, identifier1 -- ATP4drp
2871: INTO l_transaction_id, l_sd_date, l_po_qty, l_summary_flag
2872: ,l_atf_date -- for time_phased_atp
2873: , l_receive_org_id, l_organization_id, l_instance_id -- ATP4drp
2874: FROM mrp_atp_details_temp
2875: WHERE pegging_id = p_pegging_id
2876: AND record_type = 3
2877: AND session_id = MSC_ATP_PVT.G_SESSION_ID ;
2878:

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

2901: 0,
2902: l_return_status);
2903:
2904: IF PG_DEBUG in ('Y', 'C') THEN
2905: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'after delete mrp_atp_details_temp by calling remove');
2906: END IF;
2907:
2908: --s_cto_rearch
2909: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN

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

2923: MSC_ATP_DB_UTILS.Update_Pegging(p_pegging_id, p_date, p_quantity);
2924: END IF;
2925:
2926: IF PG_DEBUG in ('Y', 'C') THEN
2927: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'after first update to mrp_atp_details_temp');
2928: END IF;
2929:
2930: -- For bug 2259824, move the supply to the end of day
2931: --s_cto_rearch:

Line 3168: FROM mrp_atp_details_temp

3164: SELECT identifier3, pegging_id, NVL(identifier2, p_plan_id), supply_demand_date,
3165: supply_demand_quantity, organization_id, supplier_atp_date, summary_flag
3166: INTO l_demand_id, l_child_pegging_id, l_plan_id, l_sd_date, l_sd_qty, l_organization_id,
3167: l_supplier_atp_date, l_summary_flag
3168: FROM mrp_atp_details_temp
3169: WHERE parent_pegging_id = p_pegging_id
3170: AND record_type = 3
3171: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
3172:

Line 3381: UPDATE mrp_atp_details_temp

3377: END IF;
3378: -- dsting ATO 2465370
3379:
3380: BEGIN
3381: UPDATE mrp_atp_details_temp
3382: --bug 3328421
3383: --SET required_date = TRUNC(NVL(p_supply_demand_date, required_date)) + MSC_ATP_PVT.G_END_OF_DAY
3384: SET actual_supply_demand_date = TRUNC(NVL(p_supply_demand_date, actual_supply_demand_date)) + MSC_ATP_PVT.G_END_OF_DAY
3385: WHERE pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID

Line 3432: from mrp_atp_details_temp

3428: BEGIN
3429: --- G_DEMAND_PEGGING_ID wil be null for non atpbale items
3430: select supply_demand_quantity, supply_demand_date, organization_id
3431: into l_sd_qty, l_sd_date, l_org_id
3432: from mrp_atp_details_temp
3433: where pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
3434: and session_id = MSC_ATP_PVT.G_SESSION_ID
3435: and record_type = 3;
3436: EXCEPTION

Line 4633: FROM mrp_atp_details_temp

4629:
4630: CURSOR pegging(p_pegging_id IN NUMBER)
4631: IS
4632: SELECT pegging_id, identifier1, identifier2, identifier3
4633: FROM mrp_atp_details_temp
4634: WHERE pegging_id = p_pegging_id
4635: AND record_type in (3,4)
4636: AND session_id = MSC_ATP_PVT.G_SESSION_ID
4637: START WITH pegging_id = p_pegging_id

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

4688: /*
4689: * dsting: 9/17/2002
4690: *
4691: * Copy the data from the msc_atp_sd_details_temp table
4692: * into mrp_atp_details_temp. Plus, slap on a pegging id and
4693: * end_pegging_id
4694: *
4695: * Delete the entries in msc_atp_sd_details_temp
4696: * since we don't need them anymore too.

Line 4712: INSERT INTO mrp_atp_details_temp (

4708: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' p_end_pegging_id: ' || p_end_pegging_id);
4709: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' session_id: ' || MSC_ATP_PVT.G_SESSION_ID);
4710: END IF;
4711:
4712: INSERT INTO mrp_atp_details_temp (
4713: session_id,
4714: scenario_id,
4715: order_line_id,
4716: ATP_Level,

Line 5945: from mrp_atp_details_temp

5941: supply_demand_type, inventory_item_id, char1, organization_id, supply_demand_date,
5942: supply_demand_quantity, department_id, resource_id, order_line_id, supplier_id, supplier_site_id,
5943: supplier_atp_date, dest_inv_item_id, summary_flag
5944: , aggregate_time_fence_date
5945: from mrp_atp_details_temp
5946: where record_type in (3,4)
5947: and session_id = MSC_ATP_PVT.G_SESSION_ID
5948: start with pegging_id = p_identifier
5949: and session_id = MSC_ATP_PVT.G_SESSION_ID

Line 6126: from mrp_atp_details_temp

6122: supply_demand_type, inventory_item_id, char1, organization_id, supply_demand_date,
6123: supply_demand_quantity, department_id, resource_id, order_line_id, supplier_id, supplier_site_id,
6124: supplier_atp_date, dest_inv_item_id, summary_flag
6125: , aggregate_time_fence_date,from_organization_id
6126: from mrp_atp_details_temp
6127: where record_type in (3,4)
6128: and session_id = MSC_ATP_PVT.G_SESSION_ID
6129: start with pegging_id = p_pegging_id
6130: and session_id = MSC_ATP_PVT.G_SESSION_ID

Line 6291: from mrp_atp_details_temp

6287: supply_demand_type, inventory_item_id, char1, organization_id, supply_demand_date,
6288: supply_demand_quantity, department_id, resource_id, order_line_id, supplier_id, supplier_site_id,
6289: supplier_atp_date, dest_inv_item_id, summary_flag
6290: , aggregate_time_fence_date,from_organization_id
6291: from mrp_atp_details_temp
6292: where record_type in (3,4)
6293: and session_id = MSC_ATP_PVT.G_SESSION_ID
6294: start with pegging_id = p_pegging_id
6295: and session_id = MSC_ATP_PVT.G_SESSION_ID