APPS.WIP_MTLTEMPPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 435: from mtl_transactions_interface

431:
432: if(l_numIntRows is null) then
433: select count(*)
434: into l_numIntRows
435: from mtl_transactions_interface
436: where transaction_header_id = p_txnHdrID
437: and process_flag = wip_constants.mti_inventory;
438: end if;
439:

Line 465: from mtl_transactions_interface

461:
462: --x_trans_count out param is not supported yet
463: select count(*)
464: into l_numErrRows
465: from mtl_transactions_interface
466: where transaction_header_id = p_txnHdrID;
467:
468: select count(*)
469: into l_numTempRows

Line 504: from mtl_transactions_interface mti,

500: select msik.concatenated_segments,
501: mti.error_explanation
502: bulk collect into l_itemNameTbl,
503: l_errExplTbl
504: from mtl_transactions_interface mti,
505: mtl_system_items_kfv msik
506: where mti.transaction_header_id = p_txnHdrID
507: and mti.error_explanation is not null
508: and mti.inventory_item_id = msik.inventory_item_id

Line 545: update mtl_transactions_interface

541: else --caller wants error in MTI
542: wip_utilities.get_message_stack(p_msg => l_msgData,
543: p_delete_stack => fnd_api.g_false);
544:
545: update mtl_transactions_interface
546: set last_update_date = sysdate,
547: last_update_login = fnd_global.login_id,
548: program_application_id = fnd_global.prog_appl_id,
549: program_id = fnd_global.conc_program_id,

Line 584: update mtl_transactions_interface

580: else
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,