[Home] [Help]
3102:
3103:
3104: --4686870 , remove the records with origination_type as -200, when the supplies have been added.
3105: FOR j in 1..org_availability_info.organization_id.count LOOP
3106: DELETE MSC_DEMANDS
3107: where origination_type = -200
3108: and sr_instance_id = p_atp_record.instance_id
3109: and plan_id = org_availability_info.plan_id(j)
3110: and demand_id = org_availability_info.demand_id(j)
5203: msc_sch_wb.atp_debug('Update_demand: ' || 'p_plan_id := ' || p_plan_id);
5204: msc_sch_wb.atp_debug('Update_demand: ' || 'p_quantity := ' || p_quantity);
5205: END IF;
5206:
5207: update msc_demands
5208: set using_requirement_quantity = p_quantity
5209: where demand_id = p_demand_id
5210: and plan_id = p_plan_id;
5211: IF PG_DEBUG in ('Y', 'C') THEN
5243: END IF;
5244:
5245:
5246: --- DELETE DEMAND
5247: delete msc_demands
5248: where demand_id = p_demand_id
5249: and plan_id = p_plan_id;
5250:
5251: IF PG_DEBUG in ('Y', 'C') THEN
5875: END IF;
5876: --IF (p_atp_rec.origination_type NOT IN (6, 30)) THEN
5877:
5878: IF PG_DEBUG in ('Y', 'C') THEN
5879: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'before insert into msc_demands');
5880: END IF;
5881:
5882: INSERT INTO MSC_DEMANDS(
5883: DEMAND_ID,
5878: IF PG_DEBUG in ('Y', 'C') THEN
5879: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'before insert into msc_demands');
5880: END IF;
5881:
5882: INSERT INTO MSC_DEMANDS(
5883: DEMAND_ID,
5884: USING_REQUIREMENT_QUANTITY,
5885: USING_ASSEMBLY_DEMAND_DATE,
5886: DEMAND_TYPE,
5905: original_item_id,
5906: record_source) -- For plan order pegging
5907: ---STOLEN_FLAG) -- 02/16: Stealing
5908: VALUES(
5909: msc_demands_s.nextval,
5910: p_atp_rec.quantity_ordered,
5911: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
5912: 1, -- discrete demand
5913: p_atp_rec.origination_type,