APPS.OE_ADV_ITEM_SEARCH_PVT dependencies on OE_SELECTED_ITEMS

Line 16: FROM oe_selected_items

12: IS
13:
14: CURSOR selected_items IS
15: SELECT inventory_item_id
16: FROM oe_selected_items
17: WHERE session_id = p_session_id;
18:
19: l_line_tbl oe_order_pub.line_tbl_type;
20: l_old_line_tbl oe_order_pub.line_tbl_type;

Line 115: -- insert a row into OE_SELECTED_ITEMS with inventory_item_id as -1 for the passed session_id

111: x_return_status := l_return_status;
112:
113: ELSE -- No items have been selected.
114:
115: -- insert a row into OE_SELECTED_ITEMS with inventory_item_id as -1 for the passed session_id
116: insert_unused_session( p_session_id );
117:
118: END IF;
119:

Line 153: DELETE FROM oe_selected_items

149: PROCEDURE delete_selection ( p_session_id NUMBER ) IS
150:
151: BEGIN
152:
153: DELETE FROM oe_selected_items
154: WHERE session_id = p_session_id;
155:
156: END delete_selection;
157:

Line 162: UPDATE oe_selected_items

158: PROCEDURE Update_Used_Flag ( p_session_id NUMBER ) IS
159:
160: BEGIN
161:
162: UPDATE oe_selected_items
163: SET used_flag = 'Y'
164: WHERE session_id = p_session_id;
165:
166: END Update_Used_Flag;

Line 172: INSERT INTO oe_selected_items

168: PROCEDURE Insert_unused_session ( p_session_id NUMBER ) IS
169:
170: BEGIN
171:
172: INSERT INTO oe_selected_items
173: (session_id, inventory_item_id, used_flag)
174: VALUES ( p_session_id, -1, 'Y' );
175:
176: END insert_unused_session;