[Home] [Help]
3125:
3126:
3127: --4686870 , remove the records with origination_type as -200, when the supplies have been added.
3128: FOR j in 1..org_availability_info.organization_id.count LOOP
3129: DELETE MSC_DEMANDS
3130: where origination_type = -200
3131: and sr_instance_id = p_atp_record.instance_id
3132: and plan_id = org_availability_info.plan_id(j)
3133: and demand_id = org_availability_info.demand_id(j)
5429: msc_sch_wb.atp_debug('Update_demand: ' || 'p_plan_id := ' || p_plan_id);
5430: msc_sch_wb.atp_debug('Update_demand: ' || 'p_quantity := ' || p_quantity);
5431: END IF;
5432:
5433: update msc_demands
5434: set using_requirement_quantity = p_quantity
5435: where demand_id = p_demand_id
5436: and plan_id = p_plan_id;
5437: IF PG_DEBUG in ('Y', 'C') THEN
5469: END IF;
5470:
5471:
5472: --- DELETE DEMAND
5473: delete msc_demands
5474: where demand_id = p_demand_id
5475: and plan_id = p_plan_id;
5476:
5477: IF PG_DEBUG in ('Y', 'C') THEN
6101: END IF;
6102: --IF (p_atp_rec.origination_type NOT IN (6, 30)) THEN
6103:
6104: IF PG_DEBUG in ('Y', 'C') THEN
6105: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'before insert into msc_demands');
6106: END IF;
6107:
6108: INSERT INTO MSC_DEMANDS(
6109: DEMAND_ID,
6104: IF PG_DEBUG in ('Y', 'C') THEN
6105: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'before insert into msc_demands');
6106: END IF;
6107:
6108: INSERT INTO MSC_DEMANDS(
6109: DEMAND_ID,
6110: USING_REQUIREMENT_QUANTITY,
6111: USING_ASSEMBLY_DEMAND_DATE,
6112: DEMAND_TYPE,
6131: original_item_id,
6132: record_source) -- For plan order pegging
6133: ---STOLEN_FLAG) -- 02/16: Stealing
6134: VALUES(
6135: msc_demands_s.nextval,
6136: p_atp_rec.quantity_ordered,
6137: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
6138: 1, -- discrete demand
6139: p_atp_rec.origination_type,