APPS.WIP_MTLTEMPPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 474: from mtl_transactions_interface

470:
471: if(l_numIntRows is null) then
472: select count(*)
473: into l_numIntRows
474: from mtl_transactions_interface
475: where transaction_header_id = p_txnHdrID
476: and process_flag = wip_constants.mti_inventory;
477: end if;
478:

Line 504: from mtl_transactions_interface

500:
501: --x_trans_count out param is not supported yet
502: select count(*)
503: into l_numErrRows
504: from mtl_transactions_interface
505: where transaction_header_id = p_txnHdrID;
506:
507: select count(*)
508: into l_numTempRows

Line 543: from mtl_transactions_interface mti,

539: select msik.concatenated_segments,
540: mti.error_explanation
541: bulk collect into l_itemNameTbl,
542: l_errExplTbl
543: from mtl_transactions_interface mti,
544: mtl_system_items_kfv msik
545: where mti.transaction_header_id = p_txnHdrID
546: and mti.error_explanation is not null
547: and mti.inventory_item_id = msik.inventory_item_id

Line 584: update mtl_transactions_interface

580: else --caller wants error in MTI
581: wip_utilities.get_message_stack(p_msg => l_msgData,
582: p_delete_stack => fnd_api.g_false);
583:
584: update mtl_transactions_interface
585: set last_update_date = sysdate,
586: last_update_login = fnd_global.login_id,
587: program_application_id = fnd_global.prog_appl_id,
588: program_id = fnd_global.conc_program_id,

Line 623: update mtl_transactions_interface

619: else
620: wip_utilities.get_message_stack(p_msg => l_msgData,
621: p_delete_stack => fnd_api.g_false);
622:
623: update mtl_transactions_interface
624: set last_update_date = sysdate,
625: last_update_login = fnd_global.login_id,
626: program_application_id = fnd_global.prog_appl_id,
627: program_id = fnd_global.conc_program_id,