DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on FND_GLOBAL

Line 557: last_updated_by = fnd_global.user_id,

553: if(fnd_api.to_boolean(p_mergeMode)) then
554: --user wants to merge requirements. Update the txn qty
555: update mtl_transactions_interface
556: set last_update_date = sysdate,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id,
559: request_id = fnd_global.conc_request_id,
560: program_application_id = fnd_global.prog_appl_id,
561: program_id = fnd_global.conc_program_id,

Line 558: last_update_login = fnd_global.login_id,

554: --user wants to merge requirements. Update the txn qty
555: update mtl_transactions_interface
556: set last_update_date = sysdate,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id,
559: request_id = fnd_global.conc_request_id,
560: program_application_id = fnd_global.prog_appl_id,
561: program_id = fnd_global.conc_program_id,
562: program_update_date = sysdate,

Line 559: request_id = fnd_global.conc_request_id,

555: update mtl_transactions_interface
556: set last_update_date = sysdate,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id,
559: request_id = fnd_global.conc_request_id,
560: program_application_id = fnd_global.prog_appl_id,
561: program_id = fnd_global.conc_program_id,
562: program_update_date = sysdate,
563: transaction_quantity = transaction_quantity - l_compQty, --subtract b/c l_compQty is relative to WIP

Line 560: program_application_id = fnd_global.prog_appl_id,

556: set last_update_date = sysdate,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id,
559: request_id = fnd_global.conc_request_id,
560: program_application_id = fnd_global.prog_appl_id,
561: program_id = fnd_global.conc_program_id,
562: program_update_date = sysdate,
563: transaction_quantity = transaction_quantity - l_compQty, --subtract b/c l_compQty is relative to WIP
564: primary_quantity = primary_quantity - l_compQty --subtract b/c l_compQty is relative to WIP

Line 561: program_id = fnd_global.conc_program_id,

557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id,
559: request_id = fnd_global.conc_request_id,
560: program_application_id = fnd_global.prog_appl_id,
561: program_id = fnd_global.conc_program_id,
562: program_update_date = sysdate,
563: transaction_quantity = transaction_quantity - l_compQty, --subtract b/c l_compQty is relative to WIP
564: primary_quantity = primary_quantity - l_compQty --subtract b/c l_compQty is relative to WIP
565: where transaction_interface_id = l_popRec.txnIntID;

Line 630: l_created_by:= fnd_global.user_id;

626: INTO l_created_by
627: FROM wip_move_transactions
628: WHERE TRANSACTION_ID = p_movTxnID;
629: exception when others then
630: l_created_by:= fnd_global.user_id;
631: end;
632: /* End of fix for Bug 5444243 */
633:
634: insert into mtl_transactions_interface

Line 687: fnd_global.user_id,

683: reason_id,
684: transaction_reference)
685: values
686: (sysdate,
687: fnd_global.user_id,
688: sysdate,
689: l_created_by,/* Fix for Bug 5444243 */
690: fnd_global.login_id,
691: fnd_global.conc_request_id,

Line 690: fnd_global.login_id,

686: (sysdate,
687: fnd_global.user_id,
688: sysdate,
689: l_created_by,/* Fix for Bug 5444243 */
690: fnd_global.login_id,
691: fnd_global.conc_request_id,
692: fnd_global.prog_appl_id,
693: fnd_global.conc_program_id,
694: sysdate,

Line 691: fnd_global.conc_request_id,

687: fnd_global.user_id,
688: sysdate,
689: l_created_by,/* Fix for Bug 5444243 */
690: fnd_global.login_id,
691: fnd_global.conc_request_id,
692: fnd_global.prog_appl_id,
693: fnd_global.conc_program_id,
694: sysdate,
695: p_txnHdrID,

Line 692: fnd_global.prog_appl_id,

688: sysdate,
689: l_created_by,/* Fix for Bug 5444243 */
690: fnd_global.login_id,
691: fnd_global.conc_request_id,
692: fnd_global.prog_appl_id,
693: fnd_global.conc_program_id,
694: sysdate,
695: p_txnHdrID,
696: mtl_material_transactions_s.nextval,

Line 693: fnd_global.conc_program_id,

689: l_created_by,/* Fix for Bug 5444243 */
690: fnd_global.login_id,
691: fnd_global.conc_request_id,
692: fnd_global.prog_appl_id,
693: fnd_global.conc_program_id,
694: sysdate,
695: p_txnHdrID,
696: mtl_material_transactions_s.nextval,
697: p_wipEntityID,