1 PACKAGE CN_SFP_SRP_UTIL_PVT AUTHID CURRENT_USER AS
2 -- $Header: cnvsfsrs.pls 115.3 2004/01/27 02:24:01 fmburu noship $
3
4 -- Used meaning because it has bigger size varchar2(80)
5
6 TYPE string_tabletype IS TABLE OF CN_LOOKUPS.MEANING%TYPE INDEX BY BINARY_INTEGER;
7
8 -- Start of comments
9 -- API name : Get_Valid_Plan_Statuses
10 -- Type : Private.
11 -- Function :
12 -- Pre-reqs : None.
13 -- Parameters :
14 -- IN : p_api_version IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_commit IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_validation_level IN NUMBER Optional
20 -- Default = FND_API.G_VALID_LEVEL_FULL
21 -- p_default_all
22 -- p_type
23 -- OUT : x_return_status OUT VARCHAR2(1)
24 -- x_msg_count OUT NUMBER
25 -- x_msg_data OUT VARCHAR2(2000)
26 -- x_values_tab OUT string_tabletype
27 -- x_meanings_tab OUT string_tabletype
28 -- Version : Current version 1.0
29 --
30 --
31 --
32 -- Notes : This procedure gets valid statuses of the salesrep/fm/pa/sm.
33 --
34 -- End of comments
35
36 PROCEDURE Get_Valid_Plan_Statuses
37 ( p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39 p_commit IN VARCHAR2 := FND_API.G_FALSE,
40 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41 p_default_all IN VARCHAR2 := FND_API.G_FALSE,
42 p_type IN VARCHAR2 := 'COMPPLANPROCESS',
43 x_values_tab OUT NOCOPY string_tabletype,
44 x_meanings_tab OUT NOCOPY string_tabletype,
45 x_return_status OUT NOCOPY VARCHAR2 ,
46 x_msg_count OUT NOCOPY NUMBER ,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50
51 -- Start of comments
52 -- API name : Get_Groups_In_Hierarchy
53 -- Type : Private.
54 -- Function :
55 -- Pre-reqs : None.
56 -- Parameters :
57 -- IN :
58 -- p_include_array IN DBMS_SQL.NUMBER_TABLE ,
59 -- p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
60 -- p_date IN DATE := SYSDATE,
61 -- p_type
62 -- OUT : x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
63 -- Version : Current version 1.0
64
65 --
66 -- Notes : Given certain root groups, this procedure gets all groups under their heirarchies but
67 -- excludes those in the p_exclude_array parameters..
68 --
69 -- End of comments
70 PROCEDURE Get_Groups_In_Hierarchy
71 (
72 p_include_array IN DBMS_SQL.NUMBER_TABLE ,
73 p_exclude_array IN DBMS_SQL.NUMBER_TABLE ,
74 p_date IN DATE := SYSDATE,
75 x_hierarchy_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE
76 ) ;
77
78
79 -- Start of comments
80 -- API name : Get_All_Groups_Access
81 -- Type : Private.
82 -- Function :
83 -- Pre-reqs : None.
84 -- Parameters :
85 -- IN : p_api_version IN NUMBER Required
86 -- p_init_msg_list IN VARCHAR2 Optional
87 -- Default = FND_API.G_FALSE
88 -- p_commit IN VARCHAR2 Optional
89 -- Default = FND_API.G_FALSE
90 -- p_validation_level IN NUMBER Optional
91 -- Default = FND_API.G_VALID_LEVEL_FULL
92 -- p_org_code IN VARCHAR2 := NULL,
93 -- p_date IN VARCHAR2,
94 -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,
95 -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,
96 -- OUT : x_return_status OUT VARCHAR2(1)
97 -- x_msg_count OUT NUMBER
98 -- x_msg_data OUT VARCHAR2(2000)
99 -- Version : Current version 1.0
100 --
101 --
102 --
103 -- Notes : This procedure gets the user_access for all groups
104 -- in cn_user_access
105 --
106 -- End of comments
107
108 PROCEDURE Get_All_Groups_Access
109 ( p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113 p_org_code IN VARCHAR2 := NULL,
114 p_date IN VARCHAR2,
115 x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
116 x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2
120 ) ;
121
122 -- Start of comments
123 -- API name : Get_Group_Access
124 -- Type : Private.
125 -- Function :
126 -- Pre-reqs : None.
127 -- Parameters :
128 -- IN : p_api_version IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional
130 -- Default = FND_API.G_FALSE
131 -- p_commit IN VARCHAR2 Optional
132 -- Default = FND_API.G_FALSE
133 -- p_validation_level IN NUMBER Optional
134 -- Default = FND_API.G_VALID_LEVEL_FULL
135 -- p_default_all
136 -- p_group_id
137 -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,
138 -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,
139 -- OUT : x_return_status OUT VARCHAR2(1)
140 -- x_msg_count OUT NUMBER
141 -- x_msg_data OUT VARCHAR2(2000)
142 -- x_privilege OUT VARCHAR2,
143 -- Version : Current version 1.0
144 --
145 --
146 --
147 -- Notes : This procedure get the user access for a particular group.
148 --
149 -- End of comments
150
151
152 PROCEDURE Get_Group_Access
153 ( p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157 p_group_id IN NUMBER,
158 p_update_groups IN DBMS_SQL.NUMBER_TABLE,
159 p_view_groups IN DBMS_SQL.NUMBER_TABLE,
160 x_privilege OUT NOCOPY VARCHAR2,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 ) ;
165
166
167
168 END CN_SFP_SRP_UTIL_PVT;