DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on WIP_TRANSACTIONS_S

Line 745: select wip_transactions_s.nextval

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

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

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