APPS.OE_SCH_ORGANIZER_UTIL dependencies on OE_RSV_SET_DETAILS

Line 413: -- selected rows are inserted into oe_rsv_set_details table without parent, and then the

409: IF p_selected_line_tbl.COUNT > 0 THEN
410: SELECT oe_reservation_sets_s.nextval
411: INTO l_set_id
412: FROM dual;
413: -- selected rows are inserted into oe_rsv_set_details table without parent, and then the
414: -- concurrent program will delete these rows after processing.
415: FOR I IN 1..p_selected_line_tbl.COUNT LOOP
416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add( ' Line Id '||p_selected_line_tbl(I).id1,1);

Line 419: INSERT INTO oe_rsv_set_details

415: FOR I IN 1..p_selected_line_tbl.COUNT LOOP
416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add( ' Line Id '||p_selected_line_tbl(I).id1,1);
418: END IF;
419: INSERT INTO oe_rsv_set_details
420: (reservation_set_id
421: ,line_id
422: ,header_id
423: ,creation_date

Line 519: Update Oe_Rsv_Set_Details

515:
516:
517: FOR I IN 1..p_sch_line_tbl.COUNT
518: LOOP
519: Update Oe_Rsv_Set_Details
520: SET Corrected_Qty = p_sch_line_tbl(I).corrected_qty,
521: Corrected_Qty2 = p_sch_line_tbl(I).corrected_qty2, -- INVCONV
522: last_update_login = FND_GLOBAL.LOGIN_ID,
523: last_updated_by = FND_GLOBAL.USER_ID,