DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on FND_GLOBAL

Line 549: last_updated_by = fnd_global.user_id,

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,

Line 550: last_update_login = fnd_global.login_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,

Line 551: request_id = fnd_global.conc_request_id,

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

Line 552: program_application_id = fnd_global.prog_appl_id,

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

Line 553: program_id = fnd_global.conc_program_id,

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;

Line 622: l_created_by:= fnd_global.user_id;

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

Line 679: fnd_global.user_id,

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,

Line 682: fnd_global.login_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,

Line 683: fnd_global.conc_request_id,

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,

Line 684: fnd_global.prog_appl_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,
688: mtl_material_transactions_s.nextval,

Line 685: fnd_global.conc_program_id,

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,