[Home] [Help]
2277: l_init_line_id NUMBER;
2278: l_org_id Number;
2279:
2280: CURSOR c_split_details IS
2281: SELECT * FROM oe_line_split_details
2282: WHERE line_id = l_init_line_id
2283: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
2284: FOR UPDATE NOWAIT;
2285:
2315: raise;
2316: END;
2317:
2318: select count(*) into l_count
2319: from oe_line_split_details where line_id = l_init_line_id
2320: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2321:
2322: IF l_count = 0 THEN
2323: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2331: IF l_count > 1 THEN
2332:
2333: SELECT sum(ORDERED_QUANTITY), sum(ORDERED_QUANTITY2)
2334: INTO l_ord_qty_sum, l_ord_qty2_sum
2335: FROM oe_line_split_details
2336: WHERE line_id = l_init_line_id
2337: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2338:
2339: SELECT ordered_quantity, ordered_quantity2
2623: END IF;
2624: END IF;
2625:
2626: -- Irrespective of program result, deleting the data from table
2627: DELETE FROM oe_line_split_details
2628: WHERE line_id = l_init_line_id
2629: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2630:
2631: ELSE -- l_count < 2
2686: errbuf := 'Concurrent program did not finish successfully. See error messages and log file for more details';
2687: END IF;
2688: ROLLBACK;
2689: -- Irrespective of program result, deleting the data from table
2690: DELETE FROM oe_line_split_details
2691: WHERE line_id = l_init_line_id
2692: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2693: COMMIT;
2694: END Defer_Split;
2698: begin
2699: oe_debug_pub.add('entering oe_split_util.bulk_insert');
2700:
2701: FORALL j IN p_line_conc_tbl.FIRST .. p_line_conc_tbl.LAST
2702: INSERT INTO OE_LINE_SPLIT_DETAILS
2703: VALUES p_line_conc_tbl(j);
2704:
2705: exception
2706: WHEN OTHERS THEN