[Home] [Help]
PACKAGE: APPS.PA_BILLING_SCHEDULE_UTILS
Source
1 PACKAGE PA_BILLING_SCHEDULE_UTILS AS
2 /* $Header: PABLINUS.pls 120.1 2005/08/19 16:16:31 mwasowic noship $ */
3
4 -- API name : Emp_bill_rate_sch_name_To_Id
5 -- Type : Public procedure
6 -- Pre-reqs : None
7 -- Return Value : N/A
8 -- Prameters
9 -- p_emp_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
10 -- p_emp_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
11 -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
12 -- x_ emp_bill_rate_id OUT NUMBER REQUIRED
13 -- x_return_status OUT VARCHAR2 REQUIRED
14 -- x_error_msg_code OUT VARCHAR2 REQUIRED
15 --
16 -- History
17 --
18 -- 21-MAY-01 Majid Ansari -Created
19 --
20 --
21
22 PROCEDURE Emp_bill_rate_sch_name_To_Id(
23 p_emp_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
24 p_emp_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
25 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
26 x_emp_bill_rate_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
27 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29 );
30
31 -- API name : Job_bill_rate_sch_name_To_Id
32 -- Type : Public procedure
33 -- Pre-reqs : None
34 -- Return Value : N/A
35 -- Prameters
36 -- p_job_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
37 -- p_job_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
38 -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
39 -- p_job_group_id IN NUMBER REQUIRED
40 -- x_job_bill_rate_id OUT NUMBER REQUIRED
41 -- x_return_status OUT VARCHAR2 REQUIRED
42 -- x_error_msg_code OUT VARCHAR2 REQUIRED
43 --
44 -- History
45 --
46 -- 21-MAY-01 Majid Ansari -Created
47 --
48 --
49
50 PROCEDURE job_bill_rate_sch_name_To_Id(
51 p_job_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52 p_job_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
54 p_job_group_id IN NUMBER ,
55 x_job_bill_rate_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
57 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58 );
59
60 -- API name : Rev_Sch_Name_To_Id
61 -- Type : Public procedure
62 -- Pre-reqs : None
63 -- Return Value : N/A
64 -- Prameters
65 -- p_rev_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
66 -- p_rev_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
67 -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
68 -- x_rev_sch_id OUT NUMBER REQUIRED
69 -- x_return_status OUT VARCHAR2 REQUIRED
70 -- x_error_msg_code OUT VARCHAR2 REQUIRED
71 --
72 -- History
73 --
74 -- 21-MAY-01 Majid Ansari -Created
75 --
76 --
77
78 PROCEDURE Rev_Sch_Name_To_Id(
79 p_rev_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80 p_rev_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
81 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
82 x_rev_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
83 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
84 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
85 );
86
87 -- API name : Inv_Sch_Name_To_Id
88 -- Type : Public procedure
89 -- Pre-reqs : None
90 -- Return Value : N/A
91 -- Prameters
92 -- p_inv_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
93 -- p_inv_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
94 -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
95 -- x_inv_sch_id OUT NUMBER REQUIRED
96 -- x_return_status OUT VARCHAR2 REQUIRED
97 -- x_error_msg_code OUT VARCHAR2 REQUIRED
98 --
99 -- History
100 --
101 -- 21-MAY-01 Majid Ansari -Created
102 --
103 --
104
105 PROCEDURE Inv_Sch_Name_To_Id(
106 p_Inv_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
107 p_Inv_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
108 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
109 x_Inv_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
110 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
111 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112 );
113
114 -- API name : Nlbr_schedule_name_To_Id
115 -- Type : Public procedure
116 -- Pre-reqs : None
117 -- Return Value : N/A
118 -- Prameters
119 -- p_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
120 -- p_nlbr_org_id IN NUMBER REQUIRED
121 -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
122 -- x_sch_name OUT NUMBER REQUIRED
123 -- x_return_status OUT VARCHAR2 REQUIRED
124 -- x_error_msg_code OUT VARCHAR2 REQUIRED
125 --
126 -- History
127 --
128 -- 21-MAY-01 Majid Ansari -Created
129 --
130 --
131
132 PROCEDURE Nlbr_schedule_name_To_Id(
133 p_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
134 p_nlbr_org_id IN NUMBER,
135 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
136 x_sch_name OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
137 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
138 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
139 );
140
141 -- API name : NL_org_sch_Name_To_Id
142 -- Type : Public procedure
143 -- Pre-reqs : None
144 -- Return Value : N/A
145 -- Prameters
146 -- p_org_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
147 -- p_org_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
148 -- p_nlbr_org_id IN NUMBER REQUIRED
149 -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
150 -- x_org_id OUT NUMBER REQUIRED
151 -- x_return_status OUT VARCHAR2 REQUIRED
152 -- x_error_msg_code OUT VARCHAR2 REQUIRED
153 --
154 -- History
155 --
156 -- 21-MAY-01 Majid Ansari -Created
157 --
158 --
159
160 PROCEDURE NL_org_sch_Name_To_Id(
161 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
162 p_org_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
163 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
164 x_org_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
165 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
166 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
167 );
168
169 -- API name : Duplicate_labor_Multiplier
170 -- Type : Public Function
171 -- Pre-reqs : None
172 -- Return Value : BOLLEAN
173 -- Prameters
174 -- p_project_id IN NUMBER REQUIRED
175 -- p_task_id IN NUMBER OPTIONAL DEFAULT FND_API.MISS_NUM
176 -- p_effective_from_date IN DATE REQUIRED
177 -- p_effective_to_date IN DATE
178 -- p_labor_multiplier_id IN NUMBER
179 -- x_return_status OUT VARCHAR2 REQUIRED
180 --
181 -- History
182 --
183 -- 21-MAY-01 Majid Ansari -Created
184 --
185 --
186
187 FUNCTION Duplicate_labor_Multiplier(
188 p_project_id IN NUMBER,
189 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
190 p_effective_from_date IN DATE ,
191 p_effective_to_date IN DATE ,
192 p_labor_multiplier_id IN NUMBER ,
193 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
194 ) RETURN BOOLEAN;
195
196 -- API name : Emp_job_mandatory_validation
197 -- Type : Public procedure
198 -- Pre-reqs : None
199 -- Return Value : N/A
200 -- Prameters
201 -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
202 -- p_job_bill_rate_sch_id IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_NUM
203 -- x_return_status OUT VARCHAR2 REQUIRED
204 -- x_error_msg_code OUT VARCHAR2 REQUIRED
205 --
206 -- History
207 --
208 -- 21-MAY-01 Majid Ansari -Created
209 --
210 --
211
212 PROCEDURE Emp_job_mandatory_validation(
213 p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
214 p_job_bill_rate_sch_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM,
215 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
216 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
217 );
218
219 -- API name : Get_Job_Group_Id
220 -- Type : Public procedure
221 -- Pre-reqs : None
222 -- Return Value : NUMBER
223 -- Prameters
224 -- p_project_id IN NUMBER REQUIRED
225 -- x_return_status OUT VARCHAR2 REQUIRED
226 --
227 -- History
228 --
229 -- 21-MAY-01 Majid Ansari -Created
230 --
231 --
232
233 FUNCTION Get_Job_Group_Id(
234 p_project_id NUMBER ,
235 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
236 ) RETURN NUMBER;
237
238
239 -- API name : Get_Project_Type_Class
240 -- Type : Public procedure
241 -- Pre-reqs : None
242 -- Return Value : VARCHAR2
243 -- Prameters
244 -- p_project_id IN NUMBER REQUIRED
245 -- x_return_status OUT VARCHAR2 REQUIRED
246 --
247 -- History
248 --
249 -- 21-MAY-01 Majid Ansari -Created
250 --
251 --
252
253 FUNCTION Get_Project_Type_Class(
254 p_project_id NUMBER ,
255 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
256 ) RETURN VARCHAR2;
257
258 -- API name : CHECK_BILL_INFO_REQ
259 -- Type : Public procedure
260 -- Pre-reqs : None
261 -- Return Value : N/A
262 -- Prameters
263 -- p_project_type_class_code IN VARCHAR2 REQUIRED
264 -- p_lbr_schedule_type IN VARCHAR2 REQUIRED
265 -- p_non_lbr_schedule_type IN VARCHAR2 REQUIRED
266 -- p_emp_bill_rate_sch_id IN NUMBER REQUIRED
267 -- p_job_bill_rate_sch_id IN NUMBER REQUIRED
268 -- p_rev_schedule_id IN NUMBER REQUIRED
269 -- p_inv_schedule_id IN NUMBER REQUIRED
270 -- p_nlbr_bill_rate_org_id IN NUMBER REQUIRED
271 -- p_nlbr_std_bill_rate_sch IN VARCHAR2 REQUIRED
272 -- x_error_msg_code OUT VARCHAR2 REQUIRED
273 -- x_return_status OUT VARCHAR2 REQUIRED
274 --
275 -- History
276 --
277 -- 06-JUN-01 Majid Ansari -Created
278 --
279 --
280
281 PROCEDURE CHECK_BILL_INFO_REQ(
282 p_project_type_class_code IN VARCHAR2,
283 p_lbr_schedule_type IN VARCHAR2,
284 p_non_lbr_schedule_type IN VARCHAR2,
285 p_emp_bill_rate_sch_id IN NUMBER,
286 p_job_bill_rate_sch_id IN NUMBER,
287 p_rev_schedule_id IN NUMBER,
288 p_inv_schedule_id IN NUMBER,
289 p_nlbr_bill_rate_org_id IN NUMBER,
290 p_nlbr_std_bill_rate_sch IN VARCHAR2,
291 x_error_msg_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
292 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
293 );
294
295
296
297 -- API name : CHECK_LABOR_MULTIPLIER_REQ
298 -- Type : Public procedure
299 -- Pre-reqs : None
300 -- Return Value : N/A
301 -- Prameters
302 -- p_labor_multiplier IN NUMBER,
303 -- p_effective_from_date IN VARCHAR2,
304 -- x_error_msg_code OUT VARCHAR2 REQUIRED
305 -- x_return_status OUT VARCHAR2 REQUIRED
306 --
307 -- History
308 --
309 -- 06-JUN-01 Majid Ansari -Created
310 --
311 --
312
313 PROCEDURE CHECK_LABOR_MULTIPLIER_REQ(
314 p_labor_multiplier IN NUMBER,
315 p_effective_from_date IN DATE,
316 x_error_msg_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
317 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
318 );
319
320
321 -- API name : CHECK_START_END_DATE
322 -- Type : Public procedure
323 -- Pre-reqs : None
324 -- Return Value : N/A
325 -- Prameters
326 -- p_effective_from_date IN DATE REQUIRED
327 -- p_effective_to_date IN DATE REQUIRED
328 -- x_msg_count OUT NUMBER REQUIRED
329 -- x_msg_data OUT VARCHAR2 REQUIRED
330 -- x_return_status OUT VARCHAR2 REQUIRED
331 --
332 -- History
333 --
334 -- 06-JUN-01 Majid Ansari -Created
335 --
336 --
337
338 PROCEDURE CHECK_START_END_DATE(
339 p_effective_from_date IN DATE,
340 p_effective_to_date IN DATE,
341 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
342 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
343 ) ;
344
345 END PA_BILLING_SCHEDULE_UTILS;