[Home] [Help]
PACKAGE: APPS.OE_ADV_ITEM_SEARCH_PVT
Source
1 PACKAGE OE_ADV_ITEM_SEARCH_PVT AS
2 /* $Header: OEXVAISS.pls 120.0 2005/06/01 23:07:12 appldev noship $ */
3
4 TYPE Ais_Item_Rec IS RECORD
5 ( inventory_item_id NUMBER,
6 return_status VARCHAR2(1) );
7
8 TYPE Ais_Item_Tbl IS TABLE OF Ais_Item_Rec
9 INDEX BY BINARY_INTEGER;
10
11 PROCEDURE Create_Items_Selected( p_session_id IN NUMBER,
12 p_header_id IN NUMBER,
13 x_ais_items_tbl OUT NOCOPY /* file.sql.39 change */ ais_item_tbl,
14 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
15 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
16 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
17
18 PROCEDURE delete_selection( p_session_id NUMBER );
19
20 PROCEDURE update_used_flag( p_session_id NUMBER );
21
22 PROCEDURE insert_unused_session( p_session_id NUMBER );
23
24
25 END OE_ADV_ITEM_SEARCH_PVT;