APPS.OE_RESERVE_CONC dependencies on OE_RESERVATION_SETS

Line 363: UPDATE oe_reservation_sets

359: oe_debug_pub.add( 'ENTERING UPDATE_RESERVATION_SET ' , 1 ) ;
360: END IF;
361:
362: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
363: UPDATE oe_reservation_sets
364: SET process_flag = 'Y',
365: reservation_request_id = l_request_id,
366: program_update_date = sysdate,
367: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

Line 393: into oe_reservation_sets and oe_rsv_set_details table.

389:
390: /*------------------------------------------------------
391: Procedure Name : Create_Reservation_Set
392: Description : Inserts simulated or reserved records
393: into oe_reservation_sets and oe_rsv_set_details table.
394: --------------------------------------------------------------------- */
395: Procedure Create_Reservation_Set(p_rsv_tbl IN OE_RESERVE_CONC.Rsv_Tbl_Type,
396: p_reserve_set_name IN VARCHAR2,
397: p_rsv_request_id IN NUMBER DEFAULT NULL,

Line 420: FROM oe_reservation_sets

416:
417: -- Deleting records from table for the given set name.
418: BEGIN
419: SELECT reservation_set_id into l_set_id
420: FROM oe_reservation_sets
421: WHERE reservation_set_name = P_reserve_set_name;
422: g_set_id := l_set_id;
423: -- Deleting the existing records.
424: DELETE oe_rsv_set_details

Line 427: DELETE oe_reservation_sets

423: -- Deleting the existing records.
424: DELETE oe_rsv_set_details
425: WHERE reservation_set_id = l_set_id;
426:
427: DELETE oe_reservation_sets
428: WHERE reservation_set_id = l_set_id;
429:
430: EXCEPTION
431: WHEN OTHERS THEN

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

431: WHEN OTHERS THEN
432: NULL;
433: END;
434: IF g_set_id IS NULL THEN
435: SELECT oe_reservation_sets_s.nextval INTO g_set_id FROM dual;
436: END IF;
437:
438: IF p_rsv_request_id IS NOT NULL THEN
439: l_process_flag := 'Y';

Line 445: Insert Into oe_reservation_sets

441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'Reservation_Set_Id: '||g_set_id , 1 ) ;
443: END IF;
444: -- Insert Header information
445: Insert Into oe_reservation_sets
446: (Reservation_Set_Id
447: ,Reservation_Set_Name
448: ,Reservation_request_id
449: ,process_Flag

Line 2125: SELECT reservation_set_id FROM oe_reservation_sets

2121: l_reserved_quantity NUMBER;
2122: l_reserved_quantity2 NUMBER;
2123:
2124: CURSOR get_reservation_set IS
2125: SELECT reservation_set_id FROM oe_reservation_sets
2126: WHERE reservation_set_name = p_reserve_set_name;
2127:
2128: CURSOR rsv_process_flag IS
2129: SELECT process_flag FROM oe_reservation_sets

Line 2129: SELECT process_flag FROM oe_reservation_sets

2125: SELECT reservation_set_id FROM oe_reservation_sets
2126: WHERE reservation_set_name = p_reserve_set_name;
2127:
2128: CURSOR rsv_process_flag IS
2129: SELECT process_flag FROM oe_reservation_sets
2130: WHERE reservation_set_name = p_reserve_set_name;
2131: --
2132: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2133: --

Line 2152: from OE_RESERVATION_SETS

2148: -- MOAC Start
2149: BEGIN
2150: IF p_reserve_set_name IS NOT NULL THEN
2151: SELECT created_by INTO l_created_by
2152: from OE_RESERVATION_SETS
2153: WHERE reservation_set_name = p_reserve_set_name;
2154: --AND CREATED_BY = FND_GLOBAL.USER_ID ;
2155: IF l_created_by <> FND_GLOBAL.USER_ID THEN
2156: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');

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

2380: -- Moac End
2381:
2382: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2383: IF p_reserve_run_type ='CREATE_RESERVATION' THEN --Pack J
2384: l_stmt := 'SELECT Line_id FROM OE_Reservation_Sets_V rset WHERE '||
2385: 'rset.reservation_set_name=:reservation_set_name';
2386:
2387: ELSE
2388: --Moac