[Home] [Help]
791: --Query to get the error message
792: CURSOR Txn_Error_Cur(p_txn_Id NUMBER) IS
793: SELECT intf.ERROR_EXPLANATION ,intf.ERROR_CODE, kfv.concatenated_segments,
794: WO.workorder_name
795: --FROM MTL_MATERIAL_TRANSACTIONS_TEMP
796: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,
797: ahl_workorders WO
798: --WHERE TRANSACTION_TEMP_ID = p_txn_Id;
799: WHERE TRANSACTION_INTERFACE_ID = p_txn_Id
2243: p_item_revision IN VARCHAR2,
2244: p_lot_number IN VARCHAR2)
2245: IS
2246: SELECT sum(abs(mmt.primary_quantity))
2247: FROM mtl_material_transactions mmt, MTL_TRANSACTION_LOT_NUMBERS mtln
2248: WHERE mmt.TRANSACTION_ID = mtln.TRANSACTION_ID
2249: AND mmt.TRANSACTION_SOURCE_ID = p_wip_entity_id
2250: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
2251: AND mmt.Transaction_Type_Id = p_type_id
2259: p_type_id IN NUMBER,
2260: p_item_revision IN VARCHAR2)
2261: IS
2262: SELECT sum(abs(mmt.primary_quantity))
2263: FROM mtl_material_transactions mmt
2264: WHERE mmt.TRANSACTION_SOURCE_ID = p_wip_entity_id
2265: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
2266: AND mmt.Transaction_Type_Id = p_type_id
2267: AND nvl(mmt.revision, '1') = nvl(p_item_revision, '1')
3471: l_txn_action NUMBER;
3472: l_txn_source_type NUMBER;
3473: l_transaction_Mode NUMBER;
3474: l_Srl_Txn_Tmp_Id NUMBER;
3475: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
3476: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
3477: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
3478:
3479: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;
3475: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
3476: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
3477: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
3478:
3479: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;
3480:
3481: CURSOR ACCT_PERIOD_CUR(P_org_Id NUMBER) IS
3482: SELECT ACCT_PERIOD_ID from org_acct_periods
3483: where organization_id = p_org_id and open_flag = 'Y'
3671: p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) THEN
3672:
3673: --Item is under Lot and Serial Control
3674: --Generate serial transaction Temp id.
3675: SELECT Mtl_Material_Transactions_S.nextval
3676: INTO l_Srl_Txn_Tmp_Id
3677: FROM DUAL;
3678:
3679:
4185: CLOSE TRX_ACTION_CUR;
4186:
4187:
4188: IF(p_x_txn_hdr_id IS NULL) THEN
4189: SELECT Mtl_Material_Transactions_S.nextval
4190: INTO p_x_txn_hdr_id
4191: FROM DUAL;
4192: IF G_DEBUG='Y' THEN
4193: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');
4197: l_loop_count := 0;
4198:
4199: WHILE (l_loop_count < p_x_ahl_mtl_txn_rec.Quantity) LOOP
4200:
4201: SELECT Mtl_Material_Transactions_S.nextval
4202: INTO p_x_txn_intf_id
4203: FROM DUAL;
4204:
4205: IF G_DEBUG='Y' THEN
4336: CLOSE get_lot_dff_attrib;
4337: -- Fix for bug# 8607839(FP for Bug # 8575782) -- end
4338:
4339: IF(p_x_ahl_mtl_txn_rec.Serial_Number IS NOT NULL) THEN
4340: SELECT Mtl_Material_Transactions_S.nextval
4341: INTO l_txn_tmp_id
4342: FROM DUAL;
4343: ELSE
4344: l_txn_tmp_id := p_x_txn_intf_id;
5169: l_ii_quantity NUMBER;
5170: l_reln_exists VARCHAR2(1);
5171: l_dup_disposition VARCHAR2(1);
5172: l_inv_item_id NUMBER;
5173: l_inv_rev mtl_material_transactions.revision%TYPE;
5174: l_inv_serial mtl_serial_numbers.serial_number%TYPE;
5175: l_inv_lot_no mtl_lot_numbers.lot_number%TYPE;
5176: l_wo_id NUMBER;
5177: l_track_flag BOOLEAN;
5199: p_lot_number IN VARCHAR2)
5200: IS
5201:
5202: SELECT sum(abs(mmt.primary_quantity))
5203: FROM mtl_material_transactions mmt, MTL_TRANSACTION_LOT_NUMBERS mtln
5204: WHERE mmt.TRANSACTION_ID = mtln.TRANSACTION_ID
5205: AND mmt.TRANSACTION_SOURCE_ID = p_wip_entity_id
5206: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
5207: AND mmt.Transaction_Type_Id = p_type_id
5216: p_item_revision IN VARCHAR2)
5217: IS
5218:
5219: SELECT sum(abs(mmt.primary_quantity))
5220: FROM mtl_material_transactions mmt
5221: WHERE mmt.TRANSACTION_SOURCE_ID = p_wip_entity_id
5222: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
5223: AND mmt.Transaction_Type_Id = p_type_id
5224: AND nvl(mmt.revision, '1') = nvl(p_item_revision, '1')