APPS.MSC_ATP_PVT dependencies on MSC_ATP_UTILS

Line 8541: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-

8537: END IF;
8538:
8539: update msc_demands
8540: set USING_REQUIREMENT_QUANTITY =
8541: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-
8542: greatest(l_sub_requested_date_quantity, 0))) -- 5598066
8543: where demand_id = l_demand_id
8544: and plan_id = p_plan_id
8545: returning inventory_item_id into l_inventory_item_id;

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

8976: msc_sch_wb.atp_debug('ATP_Check: ' || 'l_demand_id: ' || l_demand_id);
8977: END IF;
8978:
8979: update msc_demands
8980: set using_requirement_quantity = MSC_ATP_UTILS.Truncate_Demand(p_atp_record.requested_date_quantity + l_stealing_requested_date_qty)
8981: where demand_id = l_demand_id
8982: and plan_id = p_plan_id;
8983:
8984: -- time_phased_atp changes begin

Line 9543: MSC_ATP_UTILS.copy_mrp_sd_recs(

9539: -- Link the Supply Demand Details for
9540: --first Demand class to the pegging details
9541:
9542: IF l_atp_period_first.pegging_id.COUNT > 0 THEN
9543: MSC_ATP_UTILS.copy_mrp_sd_recs(
9544: l_atp_period_first.pegging_id(1),
9545: l_atp_pegging_id);
9546: END IF;
9547:

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

14754: null,
14755: l_atp_ctp_qty );
14756: END IF;
14757: update msc_demands
14758: set USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(l_atp_ctp_qty) -- 5598066
14759: where demand_id = l_substitutes_rec.demand_id(l_index)
14760: and plan_id = p_plan_id
14761: returning inventory_item_id
14762: into l_inventory_item_id;

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

14895:
14896: IF MSC_ATP_PVT.G_DIAGNOSTIC_ATP <> 1 THEN
14897: update msc_demands
14898: set USING_REQUIREMENT_QUANTITY =
14899: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-l_net_demand)) -- 5598066
14900: where demand_id = l_demand_id
14901: and plan_id = p_plan_id
14902: returning inventory_item_id into l_inventory_item_id;
14903:

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

15108: IF MSC_ATP_PVT.G_DIAGNOSTIC_ATP <> 1 THEN
15109:
15110: update msc_demands
15111: set USING_REQUIREMENT_QUANTITY =
15112: MSC_ATP_UTILS.Truncate_Demand((USING_REQUIREMENT_QUANTITY-l_net_demand)) -- 5598066
15113: where demand_id = l_demand_id
15114: and plan_id = p_plan_id
15115: returning inventory_item_id into l_inventory_item_id;
15116:

Line 18359: MSC_ATP_UTILS.Get_From_Temp_Table(

18355: --s_cto_rearch: 24x7
18356: MSC_ATP_PVT.G_REFRESH_NUMBER := p_refresh_number;
18357: --e_cto_rearch: 24x7
18358:
18359: MSC_ATP_UTILS.Get_From_Temp_Table(
18360: l_dblink,
18361: p_session_id,
18362: p_atp_table,
18363: x_atp_supply_demand,

Line 18366: MSC_ATP_UTILS.REQUEST_MODE,

18362: p_atp_table,
18363: x_atp_supply_demand,
18364: x_atp_period,
18365: x_atp_details ,
18366: MSC_ATP_UTILS.REQUEST_MODE,
18367: x_return_status,
18368: x_msg_data,
18369: x_msg_count,
18370: 2);

Line 18473: MSC_ATP_UTILS.Put_Into_Temp_Table(

18469: END IF;
18470:
18471: END IF;
18472:
18473: MSC_ATP_UTILS.Put_Into_Temp_Table(
18474: l_dblink,
18475: p_session_id,
18476: x_atp_table,
18477: x_atp_supply_demand,

Line 18480: MSC_ATP_UTILS.RESULTS_MODE,

18476: x_atp_table,
18477: x_atp_supply_demand,
18478: x_atp_period,
18479: x_atp_details,
18480: MSC_ATP_UTILS.RESULTS_MODE,
18481: x_return_status,
18482: x_msg_data,
18483: x_msg_count);
18484:

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

18485: IF PG_DEBUG in ('Y', 'C') THEN
18486: msc_sch_wb.atp_debug('Call_Schedule_Remote: ' || 'here');
18487: END IF;
18488: IF l_dblink IS NOT NULL THEN
18489: MSC_ATP_UTILS.Transfer_mrp_atp_details_temp(l_dblink, p_session_id);
18490: END IF;
18491:
18492: -- Bug 2387242 : krajan
18493: -- Set Sql Trace.