APPS.GME_MATERIAL_DETAIL_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 957: FROM mtl_material_transactions

953: IS
954: CURSOR cur_get_trans (v_material_detail_id NUMBER, v_batch_id NUMBER)
955: IS
956: SELECT transaction_id
957: FROM mtl_material_transactions
958: WHERE transaction_source_id = v_batch_id
959: AND trx_source_line_id = v_material_detail_id
960: AND transaction_id NOT IN (
961: SELECT transaction_id1

Line 1159: || ': return -1: more than 1 trxn in mtl_material_transactions');

1155: || '.'
1156: || l_api_name
1157: || 'matl_dtl_id= '
1158: || TO_CHAR (l_mtl_dtl_rec.material_detail_id)
1159: || ': return -1: more than 1 trxn in mtl_material_transactions');
1160: END IF;
1161:
1162: RETURN -1;
1163: END IF;

Line 1186: || ': return -1: lot ctrl with 0 trxn in mtl_material_transactions');

1182: || '.'
1183: || l_api_name
1184: || 'matl_dtl_id= '
1185: || TO_CHAR (l_mtl_dtl_rec.material_detail_id)
1186: || ': return -1: lot ctrl with 0 trxn in mtl_material_transactions');
1187: END IF;
1188:
1189: RETURN -1;
1190: ELSE

Line 1209: || ': return -1: 1 trxn in mtl_material_transactions with more than 1 lot entry in mtl_transaction_lot_numbers'

1205: || '.'
1206: || l_api_name
1207: || 'matl_dtl_id= '
1208: || TO_CHAR (l_mtl_dtl_rec.material_detail_id)
1209: || ': return -1: 1 trxn in mtl_material_transactions with more than 1 lot entry in mtl_transaction_lot_numbers'
1210: || ' trans_id= '
1211: || TO_CHAR (l_trans_id) );
1212: END IF;
1213:

Line 1392: l_mmt_rec mtl_material_transactions%ROWTYPE;

1388: IS
1389:
1390: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_ACTUAL_QTY';
1391:
1392: l_mmt_rec mtl_material_transactions%ROWTYPE;
1393: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1394:
1395: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1396: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;