APPS.OE_ADV_ITEM_SEARCH_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

PROCEDURE Create_Items_Selected(p_session_id IN NUMBER,
				p_header_id  IN NUMBER,
				x_ais_items_tbl OUT NOCOPY /* file.sql.39 change */ ais_item_tbl,
				x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
				x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
				x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
  IS

      CURSOR selected_items IS
 	SELECT inventory_item_id
 	  FROM oe_selected_items
	  WHERE session_id = p_session_id;

Line: 40

/*   SELECT booked_flag
     INTO l_booked_flag
     FROM oe_order_headers
     WHERE header_id = p_header_id;

Line: 51

   FOR l_item IN selected_items LOOP

      l_line_rec.inventory_item_id := l_item.inventory_item_id;

Line: 62

   oe_debug_pub.add('No of Items Selected in Advanced Search : ' || To_char(l_index - 1), 1);

Line: 113

    ELSE -- No items have been selected.

      -- insert a row into  OE_SELECTED_ITEMS with inventory_item_id as -1 for the passed session_id
      insert_unused_session( p_session_id );

Line: 120

   oe_debug_pub.add('Leaving Create_Items_Selected  : ' || l_return_status, 1 );

Line: 141

	   , 'Create_Items_Selected' );

Line: 147

END  create_items_selected;

Line: 149

PROCEDURE delete_selection ( p_session_id NUMBER ) IS

BEGIN

   DELETE FROM oe_selected_items
     WHERE session_id = p_session_id;

Line: 156

END delete_selection;

Line: 158

PROCEDURE Update_Used_Flag ( p_session_id NUMBER ) IS

BEGIN

   UPDATE oe_selected_items
     SET used_flag = 'Y'
     WHERE session_id = p_session_id;

Line: 166

END Update_Used_Flag;

Line: 168

PROCEDURE Insert_unused_session ( p_session_id NUMBER ) IS

BEGIN

   INSERT INTO  oe_selected_items
     (session_id, inventory_item_id, used_flag)
     VALUES ( p_session_id, -1, 'Y' );

Line: 176

END insert_unused_session;