[Home] [Help]
3170: WHERE osp_order_id = p_osp_order_id
3171: AND oe_return_line_id = p_oe_return_line_id
3172: AND status_code IS NULL;
3173: CURSOR line_already_shipped_csr(p_oe_line_id IN NUMBER) IS
3174: SELECT 'x' from oe_order_lines_all
3175: where line_id = p_oe_line_id AND
3176: shipped_quantity > 0;
3177: l_exist VARCHAR2(1);
3178: l_index NUMBER := 1;
3313: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
3314: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
3315: ) RETURN BOOLEAN IS
3316: CURSOR order_has_ship_return_csr(p_osp_order_id IN NUMBER) IS
3317: SELECT 'x' FROM ahl_osp_order_lines ol --, oe_order_lines_all oel
3318: WHERE ol.osp_order_id = p_osp_order_id
3319: AND ol.oe_return_line_id IS NOT NULL; --= oel.line_id;
3320: CURSOR order_header_status_csr(p_osp_order_id IN NUMBER) IS
3321: SELECT status_code FROM ahl_osp_orders_b
5404: -- Added by jaramana on January 10, 2008 for the Bug 5547870/5673279
5405: CURSOR check_osp_order_unique(c_osp_order_id NUMBER, c_inventory_item_id NUMBER,
5406: c_inventory_org_id NUMBER, c_serial_number VARCHAR2) IS
5407: SELECT 'X'
5408: FROM ahl_osp_order_lines ospl, ahl_osp_orders_b osp, oe_order_lines_all oelship
5409: WHERE ospl.osp_order_id = osp.osp_order_id
5410: AND osp.status_code <> 'CLOSED'
5411: AND oelship.LINE_ID = ospl.OE_SHIP_LINE_ID
5412: --The order line should not be closed and should not be cancelled to be considered in the uniqueness check