APPS.OE_SCH_ORGANIZER_UTIL dependencies on OE_RESERVATION_SETS

Line 400: SELECT oe_reservation_sets_s.nextval

396: l_org_id := NULL;
397: END IF;
398:
399: IF p_selected_line_tbl.COUNT > 0 THEN
400: SELECT oe_reservation_sets_s.nextval
401: INTO l_set_id
402: FROM dual;
403: -- selected rows are inserted into oe_rsv_set_details table without parent, and then the
404: -- concurrent program will delete these rows after processing.

Line 486: FROM oe_reservation_sets

482: p_sch_line_tbl IN OE_SCH_ORGANIZER_UTIL.sch_line_tbl_type)
483: IS
484: CURSOR rsv_set_id IS
485: SELECT reservation_set_id
486: FROM oe_reservation_sets
487: WHERE Reservation_set_name =p_reservation_set;
488:
489: l_set_id NUMBER;
490: --

Line 530: FROM oe_reservation_sets

526: RETURN BOOLEAN
527: IS
528: CURSOR set_processed IS
529: SELECT process_flag
530: FROM oe_reservation_sets
531: WHERE reservation_set_name = p_reservation_set_name;
532:
533: l_process_flag VARCHAR2(1);
534: --