[Home] [Help]
685:
686: -- This cursor is used to get the warehouse for the Order and Line Transaction types
687: CURSOR l_oetranstypesall_csr(p_trans_id NUMBER) IS
688: SELECT warehouse_id, default_outbound_line_type_id, name
689: FROM oe_transaction_types_all a, oe_transaction_types_tl b
690: WHERE a.transaction_type_id = b.transaction_type_id
691: AND a.transaction_type_id = p_trans_id;
692:
693: --SECHAWLA 05-DEC-02 - Bug# 2679812 : Added a new cursor
1108:
1109: -- get the warehouse and the Line Type for the Default Order Type
1110: OPEN l_oetranstypesall_csr(l_default_order_type_id);
1111: FETCH l_oetranstypesall_csr INTO l_order_warehouse_id, l_def_outbound_line_type_id, l_order_name;
1112: -- This fetch will definitely find the record in oe_transaction_types_all
1113: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1114: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_REMARKET_ASSET_PVT.create_rmk_item.',
1115: 'fetched l_oetranstypesall_csr..');
1116: END IF;
1153:
1154: -- get the warehouse for the Line type corresponding to the Default Order Type
1155: OPEN l_oetranstypesall_csr(l_def_outbound_line_type_id);
1156: FETCH l_oetranstypesall_csr INTO l_line_warehouse_id, l_def_outbound_line_type_id, l_line_name;
1157: -- This fetch will definitely find the record in oe_transaction_types_all
1158: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1159: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_REMARKET_ASSET_PVT.create_rmk_item.',
1160: 'fetched l_oetranstypesall_csr again');
1161: END IF;