1 PACKAGE CN_SFP_GROUP_UTIL_PVT AUTHID CURRENT_USER AS
2 -- $Header: cnvsfgrs.pls 115.2 2003/08/19 22:29:34 sbadami noship $
3
4 TYPE srprole_rec_type IS RECORD
5 ( srp_role_id NUMBER := 0,
6 comp_group_id NUMBER := 0,
7 org_code cn_srp_role_dtls_v.org_code%type := null
8 );
9
10 TYPE srprole_tbl_type IS TABLE OF srprole_rec_type INDEX BY BINARY_INTEGER;
11
12
13 TYPE grporg_rec_type IS RECORD
14 (
15 org_code cn_lookups.lookup_code%type := null,
16 org_meaning cn_lookups.meaning%type := null
17 );
18
19 TYPE grporg_tbl_type IS TABLE OF grporg_rec_type INDEX BY BINARY_INTEGER;
20
21 TYPE grpnum_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
22
23 -- Start of comments
24 -- API name : Get_Descendant_Groups
25 -- Type : Private.
26 -- Function :
27 -- Pre-reqs : None.
28 -- Parameters :
29 -- IN : p_api_version IN NUMBER Required
30 -- p_init_msg_list IN VARCHAR2 Optional
31 -- Default = FND_API.G_FALSE
32 -- p_commit IN VARCHAR2 Optional
33 -- Default = FND_API.G_FALSE
34 -- p_validation_level IN NUMBER Optional
35 -- Default = FND_API.G_VALID_LEVEL_FULL
36 -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,
37 -- p_effective_date
38 -- OUT : x_return_status OUT VARCHAR2(1)
39 -- x_msg_count OUT NUMBER
40 -- x_msg_data OUT VARCHAR2(2000)
41 -- x_descendant_groups OUT DBMS_SQL.NUMBER_TABLE
42 -- Version : Current version 1.0
43 --
44 --
45 --
46 -- Notes : This procedures takes many comp group ids as parameters
47 -- and tries to generate the distinct comp group id list.
48 --
49 -- End of comments
50
51 PROCEDURE Get_Descendant_Groups
52 ( p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_commit IN VARCHAR2 := FND_API.G_FALSE,
55 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56 p_selected_groups IN grpnum_tbl_type,
57 p_effective_date IN DATE := SYSDATE,
58 x_descendant_groups OUT NOCOPY grpnum_tbl_type,
59 x_return_status OUT NOCOPY VARCHAR2 ,
60 x_msg_count OUT NOCOPY NUMBER ,
61 x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64 -- Start of comments
65 -- API name : Get_Salesrep_Roles
66 -- Type : Private.
67 -- Function :
68 -- Pre-reqs : None.
69 -- Parameters :
70 -- IN : p_api_version IN NUMBER Required
71 -- p_init_msg_list IN VARCHAR2 Optional
72 -- Default = FND_API.G_FALSE
73 -- p_commit IN VARCHAR2 Optional
74 -- Default = FND_API.G_FALSE
75 -- p_validation_level IN NUMBER Optional
76 -- Default = FND_API.G_VALID_LEVEL_FULL
77 -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,
78 -- p_status IN VARCHAR2
79 -- p_effective_date IN DATE
80 -- OUT : x_return_status OUT VARCHAR2(1)
81 -- x_msg_count OUT NUMBER
82 -- x_msg_data OUT VARCHAR2(2000)
83 -- x_salesrep_roles OUT srprole_tbl_type
84 -- Version : Current version 1.0
85 --
86 --
87 --
88 -- Notes : This procedure gets the srp role ids for all the
89 -- groups that have been selected based on the status
90 -- Status could be PENDING, LOCKED,GENERATED, SUBMITTED
91 -- APPROVED, ISSUED and ACCEPTED or ALL
92 --
93 -- End of comments
94
95 PROCEDURE Get_Salesrep_Roles
96 ( p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98 p_commit IN VARCHAR2 := FND_API.G_FALSE,
99 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100 p_selected_groups IN grpnum_tbl_type,
101 p_status IN VARCHAR2 := 'ALL',
102 p_effective_date IN DATE := SYSDATE,
103 x_salesrep_roles OUT NOCOPY srprole_tbl_type,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2
107 ) ;
108
109
110 -- Start of comments
111 -- API name : Get_Grp_Organization_Access
112 -- Type : Private.
113 -- Function :
114 -- Pre-reqs : None.
115 -- Parameters :
116 -- IN : p_api_version IN NUMBER Required
117 -- p_init_msg_list IN VARCHAR2 Optional
118 -- Default = FND_API.G_FALSE
119 -- p_commit IN VARCHAR2 Optional
120 -- Default = FND_API.G_FALSE
121 -- p_validation_level IN NUMBER Optional
122 -- Default = FND_API.G_VALID_LEVEL_FULL
123 -- p_comp_group_id IN NUMBER,
124 -- p_effective_date IN DATE
125 -- OUT : x_return_status OUT VARCHAR2(1)
126 -- x_msg_count OUT NUMBER
127 -- x_msg_data OUT VARCHAR2(2000)
128 -- x_updview_organization OUT grporg_tbl_type
129 -- x_upd_organization OUT grporg_tbl_type
130 -- x_view_organization OUT grporg_tbl_type
131 -- x_noview_organization OUT grporg_tbl_type
132 -- Version : Current version 1.0
133 --
134 --
135 --
136 -- Notes : This procedure given a comp group id and an effective
137 -- date lists the Organization user has UPDATE/VIEW or
138 -- NO_READ accesses for that group.
139 --
140 -- End of comments
141 PROCEDURE Get_Grp_Organization_Access
142 ( p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144 p_commit IN VARCHAR2 := FND_API.G_FALSE,
145 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146 p_comp_group_id IN NUMBER,
147 p_effective_date IN DATE := SYSDATE,
148 x_updview_organization OUT NOCOPY grporg_tbl_type,
149 x_upd_organization OUT NOCOPY grporg_tbl_type,
150 x_view_organization OUT NOCOPY grporg_tbl_type,
151 x_noview_organization OUT NOCOPY grporg_tbl_type,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2
155 );
156
157
158 END CN_SFP_GROUP_UTIL_PVT;