APPS.OE_SCH_ORGANIZER_UTIL dependencies on OE_RESERVATION_SETS

Line 410: SELECT oe_reservation_sets_s.nextval

406: l_org_id := NULL;
407: END IF;
408:
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.

Line 501: FROM oe_reservation_sets

497: p_sch_line_tbl IN OE_SCH_ORGANIZER_UTIL.sch_line_tbl_type)
498: IS
499: CURSOR rsv_set_id IS
500: SELECT reservation_set_id
501: FROM oe_reservation_sets
502: WHERE Reservation_set_name =p_reservation_set;
503:
504: l_set_id NUMBER;
505: --

Line 545: FROM oe_reservation_sets

541: RETURN BOOLEAN
542: IS
543: CURSOR set_processed IS
544: SELECT process_flag
545: FROM oe_reservation_sets
546: WHERE reservation_set_name = p_reservation_set_name;
547:
548: l_process_flag VARCHAR2(1);
549: --