APPS.WIP_MTLINTERFACEPROC_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 80: from mtl_transactions_interface

76: l_errMessage := substr(l_errMessage,1,240);
77:
78: select transaction_interface_id, error_code, error_explanation
79: bulk collect into l_intTbl, l_errCodeTbl, l_errExpTbl
80: from mtl_transactions_interface
81: where transaction_header_id = p_txnHdrID
82: and process_flag = 3;
83:
84: rollback to wipintpb0;

Line 87: update mtl_transactions_interface

83:
84: rollback to wipintpb0;
85:
86: for i in 1..l_intTbl.count loop
87: update mtl_transactions_interface
88: set error_code = l_errCodeTbl(i),
89: error_explanation = l_errExpTbl(i),
90: process_flag = wip_constants.mti_error
91: where transaction_header_id = p_txnHdrID

Line 112: update mtl_transactions_interface

108: wip_utilities.get_message_stack(p_msg => l_errMessage,
109: p_separator => ' ',
110: p_delete_stack => fnd_api.g_false);
111: l_errMessage := substr(l_errMessage,1,240);
112: update mtl_transactions_interface
113: set error_code = 'wip_mtlInterfaceProc_pub.processInterface()',
114: error_explanation = l_errMessage,
115: process_flag = wip_constants.mti_error
116: where transaction_header_id = p_txnHdrID;

Line 128: from mtl_transactions_interface

124: l_txnHdrID NUMBER;
125:
126: cursor c_mtiRow is
127: select error_explanation
128: from mtl_transactions_interface
129: where transaction_interface_id = p_txnIntID;
130: l_params wip_logger.param_tbl_t;
131: l_msg VARCHAR2(100);
132: l_returnStatus VARCHAR2(1);

Line 153: from mtl_transactions_interface

149:
150: --must be a single wip transaction that has not yet errored
151: select rowid, transaction_header_id
152: into l_rowID, l_txnHdrID
153: from mtl_transactions_interface
154: where transaction_interface_id = p_txnIntID
155: and transaction_source_type_id = 5
156: and process_flag = wip_constants.mti_inventory;
157:

Line 262: from mtl_transactions_interface

258: l_returnStatus VARCHAR2(1);
259: cursor c_mtiRows is
260: select rowid,
261: transaction_interface_id txnIntID
262: from mtl_transactions_interface
263: where transaction_header_id = p_txnHdrID
264: and process_flag = 1;
265:
266: cursor c_mmttRows is