1 PACKAGE amv_mychannel_grp AS
2 /* $Header: amvgmycs.pls 120.1 2005/06/22 16:28:30 appldev ship $ */
3 --
4 --
5 -- NAME
6 -- AMV_MYCHANNEL_GRP
7 -- PURPOSE
8 --
9 -- HISTORY
10 -- 01/29/2000 SLKRISHN CREATED
11 --
12 --
13 --
14 -- This package contains the following procedures
15 --
16 --------------------------------------------------------------------------------
17 --------------------------------------------------------------------------------
18 -- Start of comments
19 -- API name : Get_MyChannels
20 -- Type : Private
21 -- Pre-reqs : None
22 -- Function : Get all the channels for a given user (p_user_id)
23 -- Parameters :
24 -- IN p_api_version IN NUMBER Required
25 -- p_init_msg_list IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 -- p_validation_level IN NUMBER Optional
28 -- Default = FND_API.G_VALID_LEVEL_FULL
29 -- p_check_login_user IN VARCHAR2 Optional
30 -- Default = FND_API.G_TRUE
31 -- p_user_id IN NUMBER Required
32 -- the given user
33 -- OUT : x_return_status OUT VARCHAR2
34 -- x_msg_count OUT NUMBER
35 -- x_msg_data OUT VARCHAR2
36 -- x_mychannel_array OUT AMV_MY_CHANNEL_VARRAY_TYPE
37 -- Version : Current version 1.0
38 -- Previous version 1.0
39 -- Initial version 1.0
40 -- Notes :
41 --
42 -- End of comments
43 --
44 PROCEDURE Get_MyChannels
45 ( p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
52 p_user_id IN NUMBER,
53 x_mychannel_array OUT NOCOPY AMV_MYCHANNEL_PVT.AMV_MY_CHANNEL_VARRAY_TYPE
54 );
55 --
56 -- Algorithm:
57 -- BEGIN
58 -- ...
59 -- END
60 --
61 --------------------------------------------------------------------------------
62 --------------------------------------------------------------------------------
63 -- Start of comments
64 -- API name : Get_ItemsPerUser
65 -- Type : Private
66 -- Pre-reqs : None
67 -- Function : Return all items a user can access based channel/cat access
68 -- Parameters :
69 -- IN p_api_version IN NUMBER Required
70 -- p_init_msg_list IN VARCHAR2 Optional
71 -- Default = FND_API.G_FALSE
72 -- p_validation_level IN NUMBER Optional
73 -- Default = FND_API.G_VALID_LEVEL_FULL
74 -- p_category_id IN NUMBER Required
75 -- p_include_subcats IN VARCHAR2 Optional
76 -- Default = FND_API.G_FALSE
77 -- OUT : x_return_status OUT VARCHAR2
78 -- x_msg_count OUT NUMBER
79 -- x_msg_data OUT VARCHAR2
80 -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE
81 -- Version : Current version 1.0
82 -- Previous version 1.0
83 -- Initial version 1.0
84 -- Notes :
85 --
86 -- End of comments
87 --
88 PROCEDURE Get_ItemsPerUser
89 ( p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
96 p_user_id IN NUMBER,
97 p_request_obj IN AMV_MYCHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
98 x_return_obj OUT NOCOPY AMV_MYCHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
99 x_items_array OUT NOCOPY AMV_MYCHANNEL_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
100 );
101 --
102 -- Algorithm:
103 -- BEGIN
104 -- ...
105 -- END
106 --
107 --------------------------------------------------------------------------------
108 --------------------------------------------------------------------------------
109 --
110 END amv_mychannel_grp;