APPS.MSC_ATP_PROC dependencies on MSC_ATP_DB_UTILS

Line 2938: l_supply_rec_type MSC_ATP_DB_UTILS.Supply_Rec_typ;

2934: -- 2869830
2935: l_coprod_qty number;
2936:
2937: --3766179
2938: l_supply_rec_type MSC_ATP_DB_UTILS.Supply_Rec_typ;
2939: BEGIN
2940: IF PG_DEBUG in ('Y', 'C') THEN
2941: msc_sch_wb.atp_debug('Add_Coproducts: ' || '******* Start ADD_COPRODUCT ********');
2942: msc_sch_wb.atp_debug('Add_Coproducts: ' || ' p_plan_id := ' || p_plan_id);

Line 3029: MSC_ATP_DB_UTILS.Add_Planned_Order(

3025: END IF;
3026:
3027: --bug 3766179: call new procedure add_supplies instead
3028: /*
3029: MSC_ATP_DB_UTILS.Add_Planned_Order(
3030: p_instance_id,
3031: p_plan_id,
3032: l_coproducts_rec.inventory_item_id(rec_count),
3033: p_org_id,

Line 3092: MSC_ATP_DB_UTILS.ADD_SUPPLIES(l_supply_rec_type);

3088: l_supply_rec_type.record_source := 2;
3089: l_supply_rec_type.supply_type := 17; --planned order coproduct
3090: l_supply_rec_type.disposition_id := p_disposition_id;
3091:
3092: MSC_ATP_DB_UTILS.ADD_SUPPLIES(l_supply_rec_type);
3093:
3094: l_transaction_id := l_supply_rec_type.transaction_id;
3095: l_return_status := l_supply_rec_type.return_status;
3096:

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

8384: msc_sch_wb.atp_debug('Update_Set_SD_Dates : ' || 'order_date_type : ' || l_order_date_type);
8385: msc_sch_wb.atp_debug(' update_sd_date line: ' || m || ' date: ' || l_sd_date);
8386: END IF;
8387:
8388: MSC_ATP_DB_UTILS.Update_SD_Date(p_set.Identifier(m),
8389: p_set.instance_id(m), l_sd_date, l_plan_id,null, -- dsting setproc
8390: MSC_ATP_PVT.G_DEMAND_CLASS_ATP_FLAG(m),
8391: MSC_ATP_PVT.G_REQ_ATP_DATE(m),
8392: MSC_ATP_PVT.G_REQ_DATE_QTY(m), -- Bug 1501787

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

8443: IF l_ship_arrival_date_rec.demand_id is not null THEN
8444: --bug4281663 used plan id to determine ods or pds
8445: /*
8446: IF (MSC_ATP_PVT.G_INV_CTP = 4) THEN
8447: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);
8448: ELSE
8449: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8450: END IF;
8451: */

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

8445: /*
8446: IF (MSC_ATP_PVT.G_INV_CTP = 4) THEN
8447: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);
8448: ELSE
8449: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8450: END IF;
8451: */
8452: IF NVL(p_set.plan_id(m),-1) = -1 THEN
8453: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);

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

8449: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8450: END IF;
8451: */
8452: IF NVL(p_set.plan_id(m),-1) = -1 THEN
8453: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8454: ELSE
8455: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);
8456: END IF;
8457: END IF;

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

8451: */
8452: IF NVL(p_set.plan_id(m),-1) = -1 THEN
8453: MSC_ATP_DB_UTILS.Flush_Data_In_Ods(l_ship_arrival_date_rec, l_return_status);
8454: ELSE
8455: MSC_ATP_DB_UTILS.Flush_Data_In_Pds(l_ship_arrival_date_rec, l_return_status);
8456: END IF;
8457: END IF;
8458:
8459: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 8909: MSC_ATP_DB_UTILS.Remove_Invalid_SD_Rec(

8905: ) IS
8906: l_return_sts varchar2(1);
8907: BEGIN
8908: FOR i in 1..peg_ids.count LOOP
8909: MSC_ATP_DB_UTILS.Remove_Invalid_SD_Rec(
8910: peg_ids(i),
8911: p_instance_id,
8912: p_plan_id,
8913: MSC_ATP_PVT.UNDO,