545: if(fnd_api.to_boolean(p_mergeMode)) then
546: --user wants to merge requirements. Update the txn qty
547: update mtl_transactions_interface
548: set last_update_date = sysdate,
549: last_updated_by = fnd_global.user_id,
550: last_update_login = fnd_global.login_id,
551: request_id = fnd_global.conc_request_id,
552: program_application_id = fnd_global.prog_appl_id,
553: program_id = fnd_global.conc_program_id,
546: --user wants to merge requirements. Update the txn qty
547: update mtl_transactions_interface
548: set last_update_date = sysdate,
549: last_updated_by = fnd_global.user_id,
550: last_update_login = fnd_global.login_id,
551: request_id = fnd_global.conc_request_id,
552: program_application_id = fnd_global.prog_appl_id,
553: program_id = fnd_global.conc_program_id,
554: program_update_date = sysdate,
547: update mtl_transactions_interface
548: set last_update_date = sysdate,
549: last_updated_by = fnd_global.user_id,
550: last_update_login = fnd_global.login_id,
551: request_id = fnd_global.conc_request_id,
552: program_application_id = fnd_global.prog_appl_id,
553: program_id = fnd_global.conc_program_id,
554: program_update_date = sysdate,
555: transaction_quantity = transaction_quantity - l_compQty, --subtract b/c l_compQty is relative to WIP
548: set last_update_date = sysdate,
549: last_updated_by = fnd_global.user_id,
550: last_update_login = fnd_global.login_id,
551: request_id = fnd_global.conc_request_id,
552: program_application_id = fnd_global.prog_appl_id,
553: program_id = fnd_global.conc_program_id,
554: program_update_date = sysdate,
555: transaction_quantity = transaction_quantity - l_compQty, --subtract b/c l_compQty is relative to WIP
556: primary_quantity = primary_quantity - l_compQty --subtract b/c l_compQty is relative to WIP
549: last_updated_by = fnd_global.user_id,
550: last_update_login = fnd_global.login_id,
551: request_id = fnd_global.conc_request_id,
552: program_application_id = fnd_global.prog_appl_id,
553: program_id = fnd_global.conc_program_id,
554: program_update_date = sysdate,
555: transaction_quantity = transaction_quantity - l_compQty, --subtract b/c l_compQty is relative to WIP
556: primary_quantity = primary_quantity - l_compQty --subtract b/c l_compQty is relative to WIP
557: where transaction_interface_id = l_popRec.txnIntID;
618: INTO l_created_by
619: FROM wip_move_transactions
620: WHERE TRANSACTION_ID = p_movTxnID;
621: exception when others then
622: l_created_by:= fnd_global.user_id;
623: end;
624: /* End of fix for Bug 5444243 */
625:
626: insert into mtl_transactions_interface
675: reason_id,
676: transaction_reference)
677: values
678: (sysdate,
679: fnd_global.user_id,
680: sysdate,
681: l_created_by,/* Fix for Bug 5444243 */
682: fnd_global.login_id,
683: fnd_global.conc_request_id,
678: (sysdate,
679: fnd_global.user_id,
680: sysdate,
681: l_created_by,/* Fix for Bug 5444243 */
682: fnd_global.login_id,
683: fnd_global.conc_request_id,
684: fnd_global.prog_appl_id,
685: fnd_global.conc_program_id,
686: sysdate,
679: fnd_global.user_id,
680: sysdate,
681: l_created_by,/* Fix for Bug 5444243 */
682: fnd_global.login_id,
683: fnd_global.conc_request_id,
684: fnd_global.prog_appl_id,
685: fnd_global.conc_program_id,
686: sysdate,
687: p_txnHdrID,
680: sysdate,
681: l_created_by,/* Fix for Bug 5444243 */
682: fnd_global.login_id,
683: fnd_global.conc_request_id,
684: fnd_global.prog_appl_id,
685: fnd_global.conc_program_id,
686: sysdate,
687: p_txnHdrID,
688: mtl_material_transactions_s.nextval,
681: l_created_by,/* Fix for Bug 5444243 */
682: fnd_global.login_id,
683: fnd_global.conc_request_id,
684: fnd_global.prog_appl_id,
685: fnd_global.conc_program_id,
686: sysdate,
687: p_txnHdrID,
688: mtl_material_transactions_s.nextval,
689: p_wipEntityID,