[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
1104:
1105: -- get the warehouse and the Line Type for the Default Order Type
1106: OPEN l_oetranstypesall_csr(l_default_order_type_id);
1107: FETCH l_oetranstypesall_csr INTO l_order_warehouse_id, l_def_outbound_line_type_id, l_order_name;
1108: -- This fetch will definitely find the record in oe_transaction_types_all
1109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_REMARKET_ASSET_PVT.create_rmk_item.',
1111: 'fetched l_oetranstypesall_csr..');
1112: END IF;
1149:
1150: -- get the warehouse for the Line type corresponding to the Default Order Type
1151: OPEN l_oetranstypesall_csr(l_def_outbound_line_type_id);
1152: FETCH l_oetranstypesall_csr INTO l_line_warehouse_id, l_def_outbound_line_type_id, l_line_name;
1153: -- This fetch will definitely find the record in oe_transaction_types_all
1154: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_REMARKET_ASSET_PVT.create_rmk_item.',
1156: 'fetched l_oetranstypesall_csr again');
1157: END IF;