[Home] [Help]
602: null,
603: null,
604: 2);
605:
606: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
607: set sd_qty = sd_qty - p_atp_rec.quantity_ordered
608: where inventory_item_id = p_atp_rec.inventory_item_id
609: and plan_id = p_plan_id
610: and sr_instance_id = p_atp_rec.instance_id
1168: IF PG_DEBUG in ('Y', 'C') THEN
1169: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || 'Couldnt update. Inset the row');
1170: END IF;
1171: BEGIN
1172: INSERT /*+ INDEX(msc_atp_summary_RES MSC_ATP_SUMMARY_SD_RES) *//* INTO MSC_ATP_SUMMARY_RES
1173: (plan_id,
1174: organization_id,
1175: sr_instance_id,
1176: department_id,
2231: -- Supplies are being updated hence plan id would definitely not be -1
2232: /**
2233: IF c1.summary_flag = 'Y' and (c1.identifier3 > 0) and (p_plan_id = -1) THEN
2234: -- Check for Plan_id=-1 added for summary enhancement
2235: --- update the MSC_ATP_SUMMARY_SD table
2236: IF PG_DEBUG in ('Y', 'C') THEN
2237: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'update summary table');
2238: END IF;
2239: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2248: null,
2249: null,
2250: 2);
2251:
2252: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
2253: set sd_qty = (sd_qty - l_sd_qty)
2254: where plan_id = p_plan_id and
2255: sr_instance_id = l_instance_id and
2256: inventory_item_id = l_inventory_item_id and
2364: null,
2365: null,
2366: 2);
2367:
2368: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
2369: SET sd_qty = sd_qty + l_sd_qty
2370: WHERE plan_id = p_plan_id
2371: AND sr_instance_id = l_instance_id
2372: AND organization_id = l_organization_id
2883: --- old and new dates are same
2884: IF PG_DEBUG in ('Y', 'C') THEN
2885: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'old and new dates are same');
2886: END IF;
2887: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* msc_atp_summary_sd
2888: set sd_qty = sd_qty - l_sd_qty + p_quantity
2889: where plan_id = p_plan_id
2890: and inventory_item_id = l_inventory_item_id
2891: and organization_id = l_organization_id
2923: null,
2924: null,
2925: 2);
2926:
2927: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
2928: set sd_qty = (sd_qty - l_sd_qty)
2929: where sr_instance_id = l_instance_id and
2930: inventory_item_id = l_inventory_item_id and
2931: organization_id = l_organization_id and
2964: null,
2965: null,
2966: 2);
2967:
2968: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* msc_atp_summary_sd
2969: set sd_qty = (sd_qty + nvl(p_quantity, l_sd_qty))
2970: where plan_id = p_plan_id and
2971: sr_instance_id = l_instance_id and
2972: inventory_item_id = l_inventory_item_id and
3118: null,
3119: null,
3120: 2);
3121:
3122: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
3123: -- dsting 2754446
3124: SET sd_qty = sd_qty + l_sd_qty - l_prim_uom_dmd_qty
3125: -- SET sd_qty = sd_qty + l_sd_qty - p_quantity
3126: where plan_id = l_plan_id
3557: null,
3558: null,
3559: 2);
3560:
3561: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
3562: set sd_qty = (sd_qty + p_old_demand_qty)
3563: where sr_instance_id = p_instance_id and
3564: inventory_item_id = l_inventory_item_id and
3565: organization_id = l_org_id and
3599: null,
3600: null,
3601: 2);
3602:
3603: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* msc_atp_summary_sd
3604: set sd_qty = sd_qty - NVL(p_supply_demand_qty, p_old_demand_qty)
3605: where plan_id = p_plan_id and
3606: sr_instance_id = p_instance_id and
3607: inventory_item_id = l_inventory_item_id and
4197:
4198: END IF;
4199:
4200: FORALL l_counter IN 1..p_inventory_item_id.COUNT
4201: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ MSC_ATP_SUMMARY_SD
4202: SET SD_QTY = SD_QTY + p_old_demand_quantity(l_counter)
4203: WHERE INVENTORY_ITEM_ID = p_inventory_item_id(l_counter)
4204: AND PLAN_ID = p_plan_id
4205: AND SR_INSTANCE_ID = p_instance_id
4245:
4246: END IF;
4247:
4248: FORALL l_counter IN 1..p_inventory_item_id.COUNT
4249: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ MSC_ATP_SUMMARY_SD
4250: SET SD_QTY = SD_QTY - p_using_requirement_quantity(l_counter)
4251: WHERE INVENTORY_ITEM_ID = p_inventory_item_id(l_counter)
4252: AND PLAN_ID = p_plan_id(l_counter)
4253: AND SR_INSTANCE_ID = p_instance_id
4287: msc_sch_wb.atp_debug('INSERT_SUMMARY_SD_ROW: ' || ' p_quantity := ' || p_quantity);
4288: msc_sch_wb.atp_debug('INSERT_SUMMARY_SD_ROW: ' || 'p_demand_class := ' || p_demand_class);
4289: END IF;
4290: BEGIN
4291: insert /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ into msc_atp_summary_sd
4292: (plan_id,
4293: inventory_item_id,
4294: organization_id,
4295: sr_instance_id,
4330:
4331: IF PG_DEBUG in ('Y', 'C') THEN
4332: msc_sch_wb.atp_debug('INSERT_SUMMARY_SD_ROW: ' || 'Row already exists in table. Update the row');
4333: END IF;
4334: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
4335: set sd_qty = sd_qty + p_quantity
4336: where plan_id = p_plan_id
4337: and inventory_item_id = p_inventory_item_id
4338: and sr_instance_id = p_instance_id
5033: null,
5034: null,
5035: 2);
5036:
5037: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* msc_atp_summary_sd
5038: set sd_qty = sd_qty + p_supply_rec_type.order_quantity
5039: where inventory_item_id = p_supply_rec_type.inventory_item_id
5040: and plan_id = p_supply_rec_type.plan_id
5041: and sr_instance_id = p_supply_rec_type.instance_id