DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on WIP_TRANSACTIONS_S

Line 750: select wip_transactions_s.nextval

746: overCplRec.txnMode := cmpRecord.transaction_mode;
747: -- generate overcompletion_transaction_id because move processor need it
748: -- to determine whether we should update quantity at Queue of the first
749: -- operation or not.
750: select wip_transactions_s.nextval
751: into overCplRec.overCplTxnID
752: from dual;
753: end if; -- overcompletion
754:

Line 862: lpnCmpRecord.row.overcompletion_transaction_id := wma_derive.getNextVal('wip_transactions_s');

858: lpnCmpRecord.row.transaction_quantity := parameters.transactionQty;
859: /* if (parameters.overcomplete = true) then --never happens?
860: -- generate an overcompletion txn id only if the assembly has a routing
861: if (lastOpSeq <> -1) then
862: lpnCmpRecord.row.overcompletion_transaction_id := wma_derive.getNextVal('wip_transactions_s');
863: end if;
864: availableQty := getAvailableQty (job);
865: lpnCmpRecord.row.overcompletion_transaction_qty := parameters.transactionQty - availableQty;
866: lpnCmpRecord.row.overcompletion_primary_qty := parameters.transactionQty - availableQty;