[Home] [Help]
397: if(p_repSchedID is null) then
398: begin
399: select rowid
400: into l_rowid
401: from wip_requirement_operations
402: where inventory_item_id = p_issueRec.itemID
403: and wip_entity_id = p_issueRec.wipEntityID
404: and operation_seq_num = p_issueRec.opSeqNum
405: for update of quantity_issued, quantity_allocated nowait;
412: wip_logger.log('do update is true', l_returnStatus);
413: end if;
414: --below, quantity_allocated must be >= 0. At the same time, it must never increase via a return, negative issue.
415: --only the component picking process should increase the quantity_allocated column
416: update wip_requirement_operations --try to update an existing requirement
417: set quantity_issued = quantity_issued + nvl(p_issueQty, p_issueRec.primaryQty),
418: quantity_allocated = greatest(0, least(quantity_allocated, quantity_allocated - nvl(p_issueQty, p_issueRec.primaryQty))),
419: last_update_date = sysdate,
420: last_updated_by = fnd_global.user_id,
428: else
429: begin --try to find an existing requirement
430: select rowid
431: into l_rowid
432: from wip_requirement_operations
433: where inventory_item_id = p_issueRec.itemID
434: and wip_entity_id = p_issueRec.wipEntityID
435: and repetitive_schedule_id = p_repSchedID
436: and operation_seq_num = p_issueRec.opSeqNum
441: end;
442: if(l_doUpdate) then
443: --below, quantity_allocated must be >= 0. At the same time, it must never increase via a return, negative issue.
444: --only the component picking process should increase the quantity_allocated column
445: update wip_requirement_operations --try to update an existing requirement
446: set quantity_issued = quantity_issued + nvl(p_issueQty, p_issueRec.primaryQty),
447: quantity_allocated = greatest(0, least(quantity_allocated, quantity_allocated - nvl(p_issueQty, p_issueRec.primaryQty))),
448: last_update_date = sysdate,
449: last_updated_by = fnd_global.user_id,
475: end;
476: end if;
477: /* End bugfix 5401362 */
478:
479: insert into wip_requirement_operations
480: (inventory_item_id,
481: organization_id,
482: wip_entity_id,
483: operation_seq_num,
648: if(p_issueRec.txnActionID in (wip_constants.isscomp_action, wip_constants.issnegc_action)) then
649: select wro.repetitive_schedule_id,
650: wro.required_quantity - wro.quantity_issued
651: bulk collect into x_schedTbl, x_qtyTbl
652: from wip_requirement_operations wro,
653: wip_repetitive_schedules wrs
654: where wro.wip_entity_id = p_issueRec.wipEntityID
655: and wro.inventory_item_id = p_issueRec.itemID
656: and wro.operation_seq_num = p_issueRec.opSeqNum
664: else -- a return transaction
665: select wro.repetitive_schedule_id,--same as issue cursor above except for order by
666: wro.quantity_issued
667: bulk collect into x_schedTbl, x_qtyTbl
668: from wip_requirement_operations wro,
669: wip_repetitive_schedules wrs
670: where wro.wip_entity_id = p_issueRec.wipEntityID
671: and wro.inventory_item_id = p_issueRec.itemID
672: and wro.operation_seq_num = p_issueRec.opSeqNum
698: / decode(l_include_yield,2,1,nvl(wro.component_yield_factor,1)),
699: wip_constants.inv_max_precision)
700: bulk collect into x_schedTbl, x_qtyTbl
701: from wip_repetitive_schedules wrs,
702: wip_requirement_operations wro,
703: wip_move_txn_allocations wmta
704: where wmta.transaction_id = p_issueRec.movTxnID
705: and wro.repetitive_schedule_id = wmta.repetitive_schedule_id
706: and wro.repetitive_schedule_id = wrs.repetitive_schedule_id
720: / decode(l_include_yield,2,1,nvl(wro.component_yield_factor,1)),
721: wip_constants.inv_max_precision)
722: bulk collect into x_schedTbl, x_qtyTbl
723: from wip_repetitive_schedules wrs,
724: wip_requirement_operations wro,
725: wip_move_txn_allocations wmta
726: where wmta.transaction_id = p_issueRec.movTxnID
727: and wro.repetitive_schedule_id = wmta.repetitive_schedule_id
728: and wro.repetitive_schedule_id = wrs.repetitive_schedule_id
749: select wro.repetitive_schedule_id,
750: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
751: bulk collect into x_schedTbl, x_qtyTbl
752: from wip_repetitive_schedules wrs,
753: wip_requirement_operations wro,
754: mtl_material_txn_allocations mmta,
755: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
756: where mmta.transaction_id = mmtt.material_allocation_temp_id
757: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
777: select wro.repetitive_schedule_id,
778: wro.quantity_per_assembly * sum(wmat.primary_quantity) schedQty
779: bulk collect into x_schedTbl, x_qtyTbl
780: from wip_repetitive_schedules wrs,
781: wip_requirement_operations wro,
782: wip_mtl_allocations_temp wmat,
783: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
784: where wmat.transaction_temp_id = mmtt.transaction_temp_id
785: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
801: select wro.repetitive_schedule_id,
802: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
803: bulk collect into x_schedTbl, x_qtyTbl
804: from wip_repetitive_schedules wrs,
805: wip_requirement_operations wro,
806: mtl_material_txn_allocations mmta,
807: mtl_material_transactions_temp mmtt
808: where mmta.transaction_id = mmtt.material_allocation_temp_id
809: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
828: select wro.repetitive_schedule_id,
829: wro.quantity_per_assembly * sum(wmat.primary_quantity) schedQty
830: bulk collect into x_schedTbl, x_qtyTbl
831: from wip_repetitive_schedules wrs,
832: wip_requirement_operations wro,
833: wip_mtl_allocations_temp wmat,
834: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
835: where wmat.transaction_temp_id = mmtt.transaction_temp_id
836: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
856: select wro.repetitive_schedule_id,
857: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
858: bulk collect into x_schedTbl, x_qtyTbl
859: from wip_repetitive_schedules wrs,
860: wip_requirement_operations wro,
861: mtl_material_txn_allocations mmta,
862: mtl_material_transactions mmt
863: where mmta.transaction_id = mmt.transaction_id
864: and mmt.completion_transaction_id = p_issueRec.cplTxnID
878: select wro.repetitive_schedule_id,
879: wro.quantity_per_assembly * sum(mmta.primary_quantity) schedQty
880: bulk collect into x_schedTbl, x_qtyTbl
881: from wip_repetitive_schedules wrs,
882: wip_requirement_operations wro,
883: mtl_material_txn_allocations mmta,
884: mtl_material_transactions mmt
885: where mmta.transaction_id = mmt.transaction_id
886: and mmt.completion_transaction_id = p_issueRec.cplTxnID