1 package IEM_AMV_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvamvs.pls 120.0 2005/06/02 14:01:09 appldev noship $*/
3 TYPE category_type IS RECORD (
4 category_id amv_c_categories_vl.channel_category_id%type,
5 category_name amv_c_categories_vl.channel_category_name%type);
6
7 TYPE category_tbl IS TABLE OF category_type
8 INDEX BY BINARY_INTEGER;
9
10 PROCEDURE get_categories (p_api_version_number IN NUMBER,
11 p_init_msg_list IN VARCHAR2:=NULL,
12 p_commit IN VARCHAR2:=NULL,
13 x_category_tbl out nocopy category_tbl,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2);
17
18 PROCEDURE get_sub_categories (p_api_version_number IN NUMBER,
19 p_init_msg_list IN VARCHAR2 := NULL,
20 p_commit IN VARCHAR2 := NULL,
21 p_category_id IN NUMBER,
22 p_index IN NUMBER,
23 p_string IN VARCHAR2,
24 x_index OUT NOCOPY NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2);
28
29
30
31 end IEM_AMV_PVT;