APPS.MSC_ATP_PROC dependencies on MSC_ATP_DB_UTILS

Line 2946: l_supply_rec_type MSC_ATP_DB_UTILS.Supply_Rec_typ;

2942: -- 2869830
2943: l_coprod_qty number;
2944:
2945: --3766179
2946: l_supply_rec_type MSC_ATP_DB_UTILS.Supply_Rec_typ;
2947: BEGIN
2948: IF PG_DEBUG in ('Y', 'C') THEN
2949: msc_sch_wb.atp_debug('Add_Coproducts: ' || '******* Start ADD_COPRODUCT ********');
2950: msc_sch_wb.atp_debug('Add_Coproducts: ' || ' p_plan_id := ' || p_plan_id);

Line 3037: MSC_ATP_DB_UTILS.Add_Planned_Order(

3033: END IF;
3034:
3035: --bug 3766179: call new procedure add_supplies instead
3036: /*
3037: MSC_ATP_DB_UTILS.Add_Planned_Order(
3038: p_instance_id,
3039: p_plan_id,
3040: l_coproducts_rec.inventory_item_id(rec_count),
3041: p_org_id,

Line 3100: MSC_ATP_DB_UTILS.ADD_SUPPLIES(l_supply_rec_type);

3096: l_supply_rec_type.record_source := 2;
3097: l_supply_rec_type.supply_type := 17; --planned order coproduct
3098: l_supply_rec_type.disposition_id := p_disposition_id;
3099:
3100: MSC_ATP_DB_UTILS.ADD_SUPPLIES(l_supply_rec_type);
3101:
3102: l_transaction_id := l_supply_rec_type.transaction_id;
3103: l_return_status := l_supply_rec_type.return_status;
3104:

Line 8399: MSC_ATP_DB_UTILS.Update_SD_Date(p_set.Identifier(m),

8395: msc_sch_wb.atp_debug('Update_Set_SD_Dates : ' || 'order_date_type : ' || l_order_date_type);
8396: msc_sch_wb.atp_debug(' update_sd_date line: ' || m || ' date: ' || l_sd_date);
8397: END IF;
8398:
8399: MSC_ATP_DB_UTILS.Update_SD_Date(p_set.Identifier(m),
8400: p_set.instance_id(m), l_sd_date, l_plan_id,null, -- dsting setproc
8401: MSC_ATP_PVT.G_DEMAND_CLASS_ATP_FLAG(m),
8402: MSC_ATP_PVT.G_REQ_ATP_DATE(m),
8403: MSC_ATP_PVT.G_REQ_DATE_QTY(m), -- Bug 1501787

Line 8458: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);

8454: IF l_ship_arrival_date_rec.demand_id is not null THEN
8455: --bug4281663 used plan id to determine ods or pds
8456: /*
8457: IF (MSC_ATP_PVT.G_INV_CTP = 4) THEN
8458: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);
8459: ELSE
8460: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8461: END IF;
8462: */

Line 8460: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);

8456: /*
8457: IF (MSC_ATP_PVT.G_INV_CTP = 4) THEN
8458: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);
8459: ELSE
8460: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8461: END IF;
8462: */
8463: IF NVL(p_set.plan_id(m),-1) = -1 THEN
8464: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);

Line 8464: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);

8460: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8461: END IF;
8462: */
8463: IF NVL(p_set.plan_id(m),-1) = -1 THEN
8464: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8465: ELSE
8466: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);
8467: END IF;
8468: END IF;

Line 8466: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);

8462: */
8463: IF NVL(p_set.plan_id(m),-1) = -1 THEN
8464: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8465: ELSE
8466: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);
8467: END IF;
8468: END IF;
8469:
8470: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 8920: MSC_ATP_DB_UTILS.Remove_Invalid_SD_Rec(

8916: ) IS
8917: l_return_sts varchar2(1);
8918: BEGIN
8919: FOR i in 1..peg_ids.count LOOP
8920: MSC_ATP_DB_UTILS.Remove_Invalid_SD_Rec(
8921: peg_ids(i),
8922: p_instance_id,
8923: p_plan_id,
8924: MSC_ATP_PVT.UNDO,