APPS.OE_RESERVE_CONC dependencies on OE_RESERVATION_SETS

Line 439: UPDATE oe_reservation_sets

435: oe_debug_pub.add( 'ENTERING UPDATE_RESERVATION_SET ' , 1 ) ;
436: END IF;
437:
438: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
439: UPDATE oe_reservation_sets
440: SET process_flag = 'Y',
441: reservation_request_id = l_request_id,
442: program_update_date = sysdate,
443: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

Line 469: into oe_reservation_sets and oe_rsv_set_details table.

465:
466: /*------------------------------------------------------
467: Procedure Name : Create_Reservation_Set
468: Description : Inserts simulated or reserved records
469: into oe_reservation_sets and oe_rsv_set_details table.
470: --------------------------------------------------------------------- */
471: Procedure Create_Reservation_Set(p_rsv_tbl IN OE_RESERVE_CONC.Rsv_Tbl_Type,
472: p_reserve_set_name IN VARCHAR2,
473: p_rsv_request_id IN NUMBER DEFAULT NULL,

Line 496: FROM oe_reservation_sets

492:
493: -- Deleting records from table for the given set name.
494: BEGIN
495: SELECT reservation_set_id into l_set_id
496: FROM oe_reservation_sets
497: WHERE reservation_set_name = P_reserve_set_name;
498: g_set_id := l_set_id;
499: -- Deleting the existing records.
500: DELETE oe_rsv_set_details

Line 503: DELETE oe_reservation_sets

499: -- Deleting the existing records.
500: DELETE oe_rsv_set_details
501: WHERE reservation_set_id = l_set_id;
502:
503: DELETE oe_reservation_sets
504: WHERE reservation_set_id = l_set_id;
505:
506: EXCEPTION
507: WHEN OTHERS THEN

Line 511: SELECT oe_reservation_sets_s.nextval INTO g_set_id FROM dual;

507: WHEN OTHERS THEN
508: NULL;
509: END;
510: IF g_set_id IS NULL THEN
511: SELECT oe_reservation_sets_s.nextval INTO g_set_id FROM dual;
512: END IF;
513:
514: IF p_rsv_request_id IS NOT NULL THEN
515: l_process_flag := 'Y';

Line 521: Insert Into oe_reservation_sets

517: IF l_debug_level > 0 THEN
518: oe_debug_pub.add( 'Reservation_Set_Id: '||g_set_id , 1 ) ;
519: END IF;
520: -- Insert Header information
521: Insert Into oe_reservation_sets
522: (Reservation_Set_Id
523: ,Reservation_Set_Name
524: ,Reservation_request_id
525: ,process_Flag

Line 2177: SELECT reservation_set_id FROM oe_reservation_sets

2173: l_reserved_quantity NUMBER;
2174: l_reserved_quantity2 NUMBER;
2175:
2176: CURSOR get_reservation_set IS
2177: SELECT reservation_set_id FROM oe_reservation_sets
2178: WHERE reservation_set_name = p_reserve_set_name;
2179:
2180: CURSOR rsv_process_flag IS
2181: SELECT process_flag FROM oe_reservation_sets

Line 2181: SELECT process_flag FROM oe_reservation_sets

2177: SELECT reservation_set_id FROM oe_reservation_sets
2178: WHERE reservation_set_name = p_reserve_set_name;
2179:
2180: CURSOR rsv_process_flag IS
2181: SELECT process_flag FROM oe_reservation_sets
2182: WHERE reservation_set_name = p_reserve_set_name;
2183: --
2184: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2185: --

Line 2205: from OE_RESERVATION_SETS

2201: -- MOAC Start
2202: BEGIN
2203: IF p_reserve_set_name IS NOT NULL THEN
2204: SELECT created_by INTO l_created_by
2205: from OE_RESERVATION_SETS
2206: WHERE reservation_set_name = p_reserve_set_name;
2207: --AND CREATED_BY = FND_GLOBAL.USER_ID ;
2208: IF l_created_by <> FND_GLOBAL.USER_ID THEN
2209: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');

Line 2437: l_stmt := 'SELECT Line_id FROM OE_Reservation_Sets_V rset WHERE '||

2433: -- Moac End
2434:
2435: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2436: IF p_reserve_run_type ='CREATE_RESERVATION' THEN --Pack J
2437: l_stmt := 'SELECT Line_id FROM OE_Reservation_Sets_V rset WHERE '||
2438: 'rset.reservation_set_name=:reservation_set_name';
2439:
2440: ELSE
2441: --Moac