1 PACKAGE CN_Srp_PayGroup_PUB_CUHK AUTHID CURRENT_USER as
2 -- $Header: cncspgps.pls 120.1 2005/10/12 13:50:42 mblum noship $ --+
3
4 -------------------------------------------------------------------------------------+
5 -- Start of comments
6 -- API name : Assign_Salesreps_pre
7 -- Type : Public.
8 -- Pre-reqs : None.
9 -- Usage : Customization before assigning salesperson to a paygroup
10 --
11 -- Desc :
12 --
13 --
14 -- Parameters :
15 -- IN : p_api_version IN NUMBER Required
16 -- p_init_msg_list IN VARCHAR2 Optional
17 -- Default = FND_API.G_FALSE
18 -- p_commit IN VARCHAR2 Optional
19 -- Default = FND_API.G_FALSE
20 -- p_validation_level IN NUMBER Optional
21 -- Default = FND_API.G_VALID_LEVEL_FULL
22 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
23 -- x_msg_count OUT NOCOPY NUMBER
24 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
25 -- IN : p_pay_group_name IN cn_pay_groups.name%TYPE
26 -- p_pay_group_start_date IN cn_pay_groups.start_date%TYPE
27 -- p_pay_group_end_date IN cn_pay_groups.end_date%TYPE
28 -- p_PayGroup_assign_rec IN PayGroup_assign_rec%TYPE
29 --
30 -- OUT : x_loading_status OUT NOCOPY VARCHAR2(50)
31 -- Detailed error code returned from procedure.
32 --
33 -- OUT : x_status OUT NOCOPY VARCHAR2(50)
34 -- Return Sql Statement Status ( VALID/INVALID)
35 --
36 -- Version : Current version 1.0
37 -- Initial version 1.0
38 --
39 -- Notes :
40 --
41 -- End of comments
42 --------------------------------------------------------------------------------------+
43 PROCEDURE Assign_salesreps_pre
44 ( p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46 p_commit 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_paygroup_assign_rec IN OUT NOCOPY cn_srp_paygroup_pub.PayGroup_assign_rec,
52 x_loading_status OUT NOCOPY VARCHAR2,
53 x_status OUT NOCOPY VARCHAR2
54 );
55
56 -------------------------------------------------------------------------------------+
57 -- Start of comments
58 -- API name : Assign_Salesreps_post
59 -- Type : Public.
60 -- Pre-reqs : None.
61 -- Usage : Customization after assigning salesperson to a paygroup
62 --
63 -- Desc :
64 --
65 --
66 -- Parameters :
67 -- IN : p_api_version IN NUMBER Required
68 -- p_init_msg_list IN VARCHAR2 Optional
69 -- Default = FND_API.G_FALSE
70 -- p_commit 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 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
75 -- x_msg_count OUT NOCOPY NUMBER
76 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
77 -- IN : p_pay_group_name IN cn_pay_groups.name%TYPE
78 -- p_pay_group_start_date IN cn_pay_groups.start_date%TYPE
79 -- p_pay_group_end_date IN cn_pay_groups.end_date%TYPE
80 -- p_PayGroup_assign_rec IN PayGroup_assign_rec%TYPE
81 --
82 -- OUT : x_loading_status OUT NOCOPY VARCHAR2(50)
83 -- Detailed error code returned from procedure.
84 --
85 -- OUT : x_status OUT NOCOPY VARCHAR2(50)
86 -- Return Sql Statement Status ( VALID/INVALID)
87 --
88 -- Version : Current version 1.0
89 -- Initial version 1.0
90 --
91 -- Notes :
92 --
93 -- End of comments
94 --------------------------------------------------------------------------------------+
95 PROCEDURE Assign_salesreps_post
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 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_paygroup_assign_rec IN cn_srp_paygroup_pub.PayGroup_assign_rec,
104 x_loading_status OUT NOCOPY VARCHAR2,
105 x_status OUT NOCOPY VARCHAR2
106 );
107
108 --------------------------------------------------------------------------------------+
109 -- Start of comments
110 -- API name : Update_srp_assignment_pre
111 -- Type : Public.
112 -- Pre-reqs : None.
113 -- Usage : Customization before updating the salesrep assignment to paygroup
114 --
115 -- Desc :
116 --
117 -- Parameters :
118 -- IN : p_api_version IN NUMBER Required
119 -- p_init_msg_list IN VARCHAR2 Optional
120 -- Default = FND_API.G_FALSE
121 -- p_commit IN VARCHAR2 Optional
122 -- Default = FND_API.G_FALSE
123 -- p_validation_level IN NUMBER Optional
124 -- Default = FND_API.G_VALID_LEVEL_FULL
125 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
126 -- x_msg_count OUT NOCOPY NUMBER
127 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
128 -- IN : p_old_pay_group_name IN cn_pay_groups.name%TYPE,
129 -- p_old_pay_group_start_date IN cn_pay_groups.start_date%TYPE,
130 -- p_old_pay_group_end_date IN cn_pay_groups.end_date%TYPE,
131 -- p_pay_group_name IN cn_pay_groups.name%TYPE,
132 -- p_pay_group_start_date IN cn_pay_groups.start_date%TYPE,
133 -- p_pay_group_end_date IN cn_pay_groups.end_date%TYPE,
134 -- p_old_paygroup_assign_rec IN PayGroup_assign_rec,
135 -- p_paygroup_assign_rec IN PayGroup_assign_rec,
136 --
137 -- OUT : x_loading_status OUT NOCOPY VARCHAR2(50)
138 -- Detailed error code returned from procedure.
139 --
140 -- OUT : x_status OUT NOCOPY VARCHAR2(50)
141 -- Return Sql Statement Status ( VALID/INVALID)
142 --
143 -- Version : Current version 1.0
144 -- Initial version 1.0
145 --
146 -- Notes : The following are the validations performed by this API
147 -- - Checks if the old and the new pay group parameters are valid
148 -- - Checks if the assignement dates are valid.
149 -- - Checks that the assignment do not overlap.
150 --
151 -- End of comments
152 --------------------------------------------------------------------------------------+
153 PROCEDURE Update_srp_assignment_pre
154 ( p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2,
156 p_commit IN VARCHAR2,
157 p_validation_level IN NUMBER,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_old_paygroup_assign_rec IN OUT NOCOPY cn_srp_paygroup_pub.PayGroup_assign_rec,
162 p_paygroup_assign_rec IN OUT NOCOPY cn_srp_paygroup_pub.PayGroup_assign_rec,
163 x_loading_status OUT NOCOPY VARCHAR2,
164 x_status OUT NOCOPY VARCHAR2
165 );
166
167 --------------------------------------------------------------------------------------+
168 -- Start of comments
169 -- API name : Update_srp_assignment_post
170 -- Type : Public.
171 -- Pre-reqs : None.
172 -- Usage : Customization after updating the salesrep assignment to paygroup
173 --
174 -- Desc :
175 --
176 -- Parameters :
177 -- IN : p_api_version IN NUMBER Required
178 -- p_init_msg_list IN VARCHAR2 Optional
179 -- Default = FND_API.G_FALSE
180 -- p_commit IN VARCHAR2 Optional
181 -- Default = FND_API.G_FALSE
182 -- p_validation_level IN NUMBER Optional
183 -- Default = FND_API.G_VALID_LEVEL_FULL
184 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
185 -- x_msg_count OUT NOCOPY NUMBER
186 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
187 -- IN : p_old_pay_group_name IN cn_pay_groups.name%TYPE,
188 -- p_old_pay_group_start_date IN cn_pay_groups.start_date%TYPE,
189 -- p_old_pay_group_end_date IN cn_pay_groups.end_date%TYPE,
190 -- p_pay_group_name IN cn_pay_groups.name%TYPE,
191 -- p_pay_group_start_date IN cn_pay_groups.start_date%TYPE,
192 -- p_pay_group_end_date IN cn_pay_groups.end_date%TYPE,
193 -- p_old_paygroup_assign_rec IN PayGroup_assign_rec,
194 -- p_paygroup_assign_rec IN PayGroup_assign_rec,
195 --
196 -- OUT : x_loading_status OUT NOCOPY VARCHAR2(50)
197 -- Detailed error code returned from procedure.
198 --
199 -- OUT : x_status OUT NOCOPY VARCHAR2(50)
200 -- Return Sql Statement Status ( VALID/INVALID)
201 --
202 -- Version : Current version 1.0
203 -- Initial version 1.0
204 --
205 -- Notes : The following are the validations performed by this API
206 -- - Checks if the old and the new pay group parameters are valid
207 -- - Checks if the assignement dates are valid.
208 -- - Checks that the assignment do not overlap.
209 --
210 -- End of comments
211 --------------------------------------------------------------------------------------+
212 PROCEDURE Update_srp_assignment_post
213 ( p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2,
215 p_commit IN VARCHAR2,
216 p_validation_level IN NUMBER,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_old_paygroup_assign_rec IN cn_srp_paygroup_pub.PayGroup_assign_rec,
221 p_paygroup_assign_rec IN cn_srp_paygroup_pub.PayGroup_assign_rec,
222 x_loading_status OUT NOCOPY VARCHAR2,
223 x_status OUT NOCOPY VARCHAR2
224 );
225
226
227 --------------------------------------------------------------------------------------+
228 -- Start of comments
229 -- API name : ok_to_generate_msg
230 -- Type : Public.
231 -- Pre-reqs : None.
232 -- Usage : Function to decide whether message needs to be generated
233 --
234 -- Desc :
235 --
236 -- Parameters :
237 -- IN :
238 -- OUT :
239 -- Version : Current version 1.0
240 -- Initial version 1.0
241 --
242 -- End of comments
243 --------------------------------------------------------------------------------------+
244 FUNCTION ok_to_generate_msg
245 (p_paygroup_assign_rec IN cn_srp_paygroup_pub.paygroup_assign_rec)
246 RETURN BOOLEAN;
247
248
249 END CN_Srp_PayGroup_PUB_CUHK;