APPS.MSC_ATP_PVT dependencies on MSC_ATP_UTILS

Line 9233: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-

9229: END IF;
9230:
9231: update msc_demands
9232: set USING_REQUIREMENT_QUANTITY =
9233: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-
9234: greatest(l_sub_requested_date_quantity, 0))) -- 5598066
9235: where demand_id = l_demand_id
9236: and plan_id = p_plan_id
9237: returning inventory_item_id into l_inventory_item_id;

Line 9685: set using_requirement_quantity = MSC_ATP_UTILS.Truncate_Demand(p_atp_record.requested_date_quantity + l_stealing_requested_date_qty)

9681: msc_sch_wb.atp_debug('ATP_Check: ' || 'l_demand_id: ' || l_demand_id);
9682: END IF;
9683:
9684: update msc_demands
9685: set using_requirement_quantity = MSC_ATP_UTILS.Truncate_Demand(p_atp_record.requested_date_quantity + l_stealing_requested_date_qty)
9686: where demand_id = l_demand_id
9687: and plan_id = p_plan_id;
9688:
9689: -- time_phased_atp changes begin

Line 10250: MSC_ATP_UTILS.copy_mrp_sd_recs(

10246: -- Link the Supply Demand Details for
10247: --first Demand class to the pegging details
10248:
10249: IF l_atp_period_first.pegging_id.COUNT > 0 THEN
10250: MSC_ATP_UTILS.copy_mrp_sd_recs(
10251: l_atp_period_first.pegging_id(1),
10252: l_atp_pegging_id);
10253: END IF;
10254:

Line 15599: set USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(l_atp_ctp_qty) -- 5598066

15595: null,
15596: l_atp_ctp_qty );
15597: END IF;
15598: update msc_demands
15599: set USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(l_atp_ctp_qty) -- 5598066
15600: where demand_id = l_substitutes_rec.demand_id(l_index)
15601: and plan_id = p_plan_id
15602: returning inventory_item_id
15603: into l_inventory_item_id;

Line 15742: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-l_net_demand)) -- 5598066

15738:
15739: IF MSC_ATP_PVT.G_DIAGNOSTIC_ATP <> 1 THEN
15740: update msc_demands
15741: set USING_REQUIREMENT_QUANTITY =
15742: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-l_net_demand)) -- 5598066
15743: where demand_id = l_demand_id
15744: and plan_id = p_plan_id
15745: returning inventory_item_id into l_inventory_item_id;
15746:

Line 15961: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-l_net_demand)) -- 5598066

15957: IF MSC_ATP_PVT.G_DIAGNOSTIC_ATP <> 1 THEN
15958:
15959: update msc_demands
15960: set USING_REQUIREMENT_QUANTITY =
15961: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-l_net_demand)) -- 5598066
15962: where demand_id = l_demand_id
15963: and plan_id = p_plan_id
15964: returning inventory_item_id into l_inventory_item_id;
15965:

Line 19239: MSC_ATP_UTILS.Get_From_Temp_Table(

19235: --s_cto_rearch: 24x7
19236: MSC_ATP_PVT.G_REFRESH_NUMBER := p_refresh_number;
19237: --e_cto_rearch: 24x7
19238:
19239: MSC_ATP_UTILS.Get_From_Temp_Table(
19240: l_dblink,
19241: p_session_id,
19242: p_atp_table,
19243: x_atp_supply_demand,

Line 19246: MSC_ATP_UTILS.REQUEST_MODE,

19242: p_atp_table,
19243: x_atp_supply_demand,
19244: x_atp_period,
19245: x_atp_details ,
19246: MSC_ATP_UTILS.REQUEST_MODE,
19247: x_return_status,
19248: x_msg_data,
19249: x_msg_count,
19250: 2);

Line 19353: MSC_ATP_UTILS.Put_Into_Temp_Table(

19349: END IF;
19350:
19351: END IF;
19352:
19353: MSC_ATP_UTILS.Put_Into_Temp_Table(
19354: l_dblink,
19355: p_session_id,
19356: x_atp_table,
19357: x_atp_supply_demand,

Line 19360: MSC_ATP_UTILS.RESULTS_MODE,

19356: x_atp_table,
19357: x_atp_supply_demand,
19358: x_atp_period,
19359: x_atp_details,
19360: MSC_ATP_UTILS.RESULTS_MODE,
19361: x_return_status,
19362: x_msg_data,
19363: x_msg_count);
19364:

Line 19369: MSC_ATP_UTILS.Transfer_mrp_atp_details_temp(l_dblink, p_session_id);

19365: IF PG_DEBUG in ('Y', 'C') THEN
19366: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'here');
19367: END IF;
19368: IF l_dblink IS NOT NULL THEN
19369: MSC_ATP_UTILS.Transfer_mrp_atp_details_temp(l_dblink, p_session_id);
19370: END IF;
19371:
19372: -- Bug 2387242 : krajan
19373: -- Set Sql Trace.