[Home] [Help]
755: null,
756: null,
757: 2);
758:
759: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
760: set sd_qty = sd_qty - p_atp_rec.quantity_ordered
761: where inventory_item_id = p_atp_rec.inventory_item_id
762: and plan_id = p_plan_id
763: and sr_instance_id = p_atp_rec.instance_id
1321: IF PG_DEBUG in ('Y', 'C') THEN
1322: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || 'Couldnt update. Inset the row');
1323: END IF;
1324: BEGIN
1325: INSERT /*+ INDEX(msc_atp_summary_RES MSC_ATP_SUMMARY_SD_RES) *//* INTO MSC_ATP_SUMMARY_RES
1326: (plan_id,
1327: organization_id,
1328: sr_instance_id,
1329: department_id,
2388: -- Supplies are being updated hence plan id would definitely not be -1
2389: /**
2390: IF c1.summary_flag = 'Y' and (c1.identifier3 > 0) and (p_plan_id = -1) THEN
2391: -- Check for Plan_id=-1 added for summary enhancement
2392: --- update the MSC_ATP_SUMMARY_SD table
2393: IF PG_DEBUG in ('Y', 'C') THEN
2394: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'update summary table');
2395: END IF;
2396: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2405: null,
2406: null,
2407: 2);
2408:
2409: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
2410: set sd_qty = (sd_qty - l_sd_qty)
2411: where plan_id = p_plan_id and
2412: sr_instance_id = l_instance_id and
2413: inventory_item_id = l_inventory_item_id and
2521: null,
2522: null,
2523: 2);
2524:
2525: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
2526: SET sd_qty = sd_qty + l_sd_qty
2527: WHERE plan_id = p_plan_id
2528: AND sr_instance_id = l_instance_id
2529: AND organization_id = l_organization_id
3045: --- old and new dates are same
3046: IF PG_DEBUG in ('Y', 'C') THEN
3047: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'old and new dates are same');
3048: END IF;
3049: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* msc_atp_summary_sd
3050: set sd_qty = sd_qty - l_sd_qty + p_quantity
3051: where plan_id = p_plan_id
3052: and inventory_item_id = l_inventory_item_id
3053: and organization_id = l_organization_id
3085: null,
3086: null,
3087: 2);
3088:
3089: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
3090: set sd_qty = (sd_qty - l_sd_qty)
3091: where sr_instance_id = l_instance_id and
3092: inventory_item_id = l_inventory_item_id and
3093: organization_id = l_organization_id and
3126: null,
3127: null,
3128: 2);
3129:
3130: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* msc_atp_summary_sd
3131: set sd_qty = (sd_qty + nvl(p_quantity, l_sd_qty))
3132: where plan_id = p_plan_id and
3133: sr_instance_id = l_instance_id and
3134: inventory_item_id = l_inventory_item_id and
3280: null,
3281: null,
3282: 2);
3283:
3284: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
3285: -- dsting 2754446
3286: SET sd_qty = sd_qty + l_sd_qty - l_prim_uom_dmd_qty
3287: -- SET sd_qty = sd_qty + l_sd_qty - p_quantity
3288: where plan_id = l_plan_id
3724: null,
3725: null,
3726: 2);
3727:
3728: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* MSC_ATP_SUMMARY_SD
3729: set sd_qty = (sd_qty + p_old_demand_qty)
3730: where sr_instance_id = p_instance_id and
3731: inventory_item_id = l_inventory_item_id and
3732: organization_id = l_org_id and
3766: null,
3767: null,
3768: 2);
3769:
3770: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* msc_atp_summary_sd
3771: set sd_qty = sd_qty - NVL(p_supply_demand_qty, p_old_demand_qty)
3772: where plan_id = p_plan_id and
3773: sr_instance_id = p_instance_id and
3774: inventory_item_id = l_inventory_item_id and
4379:
4380: END IF;
4381:
4382: FORALL l_counter IN 1..p_inventory_item_id.COUNT
4383: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ MSC_ATP_SUMMARY_SD
4384: SET SD_QTY = SD_QTY + p_old_demand_quantity(l_counter)
4385: WHERE INVENTORY_ITEM_ID = p_inventory_item_id(l_counter)
4386: AND PLAN_ID = p_plan_id
4387: AND SR_INSTANCE_ID = p_instance_id
4427:
4428: END IF;
4429:
4430: FORALL l_counter IN 1..p_inventory_item_id.COUNT
4431: UPDATE /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ MSC_ATP_SUMMARY_SD
4432: SET SD_QTY = SD_QTY - p_using_requirement_quantity(l_counter)
4433: WHERE INVENTORY_ITEM_ID = p_inventory_item_id(l_counter)
4434: AND PLAN_ID = p_plan_id(l_counter)
4435: AND SR_INSTANCE_ID = p_instance_id
4469: msc_sch_wb.atp_debug('INSERT_SUMMARY_SD_ROW: ' || ' p_quantity := ' || p_quantity);
4470: msc_sch_wb.atp_debug('INSERT_SUMMARY_SD_ROW: ' || 'p_demand_class := ' || p_demand_class);
4471: END IF;
4472: BEGIN
4473: insert /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ into msc_atp_summary_sd
4474: (plan_id,
4475: inventory_item_id,
4476: organization_id,
4477: sr_instance_id,
4512:
4513: IF PG_DEBUG in ('Y', 'C') THEN
4514: msc_sch_wb.atp_debug('INSERT_SUMMARY_SD_ROW: ' || 'Row already exists in table. Update the row');
4515: END IF;
4516: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ msc_atp_summary_sd
4517: set sd_qty = sd_qty + p_quantity
4518: where plan_id = p_plan_id
4519: and inventory_item_id = p_inventory_item_id
4520: and sr_instance_id = p_instance_id
5215: null,
5216: null,
5217: 2);
5218:
5219: update /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) *//* msc_atp_summary_sd
5220: set sd_qty = sd_qty + p_supply_rec_type.order_quantity
5221: where inventory_item_id = p_supply_rec_type.inventory_item_id
5222: and plan_id = p_supply_rec_type.plan_id
5223: and sr_instance_id = p_supply_rec_type.instance_id