[Home] [Help]
PACKAGE: APPS.PA_BILLING_SETUP_UTILS
Source
1 PACKAGE PA_BILLING_SETUP_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PABLSTUS.pls 120.1 2005/08/19 16:16:57 mwasowic noship $ */
3
4
5 -- API name : Validate_Retn_Inv_Format
6 -- Type : Utility procedure
7 -- Pre-reqs : None
8 -- Return Value : N/A
9 -- Prameters
10 -- p_retention_inv_format_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
11 -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
12 -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
13 -- x_retention_inv_format_id OUT NUMBER REQUIRED
14 -- x_return_status OUT VARCHAR2 REQUIRED
15 -- x_error_msg_code OUT VARCHAR2 REQUIRED
16 --
17 -- History
18 --
19 -- 25-MAY-01 Majid Ansari -Created
20 --
21 --
22
23 PROCEDURE Validate_Retn_Inv_Format(
24 p_retention_inv_format_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
25 p_retention_inv_format_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
26 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
27 x_retention_inv_format_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
28 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
29 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30 );
31
32
33 -- API name : Duplicate_credit_receivers
34 -- Type : Utility Function
35 -- Pre-reqs : None
36 -- Return Value : BOOLEAN
37 -- Prameters
38 -- p_project_id IN NUMBER REQUIRED
39 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
40 -- p_credit_type IN VARCHAR2 REQUIRED
41 -- p_person_id IN NUMBER REQUIRED
42 -- p_effective_from_date IN DATE REQUIRED
43 -- p_effective_to_date IN DATE REQUIRED ,
44 -- p_credit_receiver_id IN NUMBER REQUIRED,
45 -- x_return_status OUT VARCHAR2 REQUIRED
46 --
47 -- History
48 --
49 -- 25-MAY-01 Majid Ansari -Created
50 --
51 --
52
53 FUNCTION Duplicate_credit_receivers(
54 p_project_id IN NUMBER ,
55 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56 p_credit_type IN VARCHAR2 ,
57 p_person_id IN NUMBER ,
58 p_effective_from_date IN DATE ,
59 p_effective_to_date IN DATE ,
60 p_credit_receiver_id IN NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
62 ) RETURN BOOLEAN;
63
64 -- API name : Duplicate_billing_assignments
65 -- Type : Utility Function
66 -- Pre-reqs : None
67 -- Return Value : BOOLEAN
68 -- Prameters
69 -- p_project_id IN NUMBER REQUIRED
70 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
71 -- p_billing_extension_id IN VARCHAR2 REQUIRED
72 -- p_billing_assignment_id IN NUMBER REQUIRED
73 -- p_active_flag IN VARCHAR2 REQUIRED
74 -- x_return_status OUT VARCHAR2 REQUIRED
75 --
76 -- History
77 --
78 -- 25-MAY-01 Majid Ansari -Created
79 --
80 --
81
82 FUNCTION Duplicate_billing_assignments(
83 p_project_id IN NUMBER ,
84 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
85 p_billing_extension_id IN NUMBER ,
86 p_billing_assignment_id IN NUMBER ,
87 p_active_flag IN VARCHAR2,
88 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
89 ) RETURN BOOLEAN;
90
91
92 -- API name : VALIDATE_PERSON_ID_NAME
93 -- Type : Utility procedure
94 -- Pre-reqs : None
95 -- Return Value : N/A
96 -- Prameters
97 -- p_retention_inv_format_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
98 -- p_retention_inv_format_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
99 -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
100 -- x_retention_inv_format_id OUT NUMBER REQUIRED
101 -- x_return_status OUT VARCHAR2 REQUIRED
102 -- x_error_msg_code OUT VARCHAR2 REQUIRED
103 --
104 -- History
105 --
106 -- 25-MAY-01 Majid Ansari -Created
107 --
108 --
109
110 PROCEDURE VALIDATE_PERSON_ID_NAME(
111 p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
112 p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
113 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
114 x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
115 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
116 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
117 );
118
119
120 -- API name : Get_Next_Billing_Date
121 -- Type : Utility Function
122 -- Pre-reqs : None
123 -- Return Value : DATE
124 -- Prameters
125 -- p_project_id IN NUMBER
126 -- x_return_status OUT VARCHAR2 REQUIRED
127 --
128 -- History
129 --
130 -- 25-MAY-01 Majid Ansari -Created
131 --
132 --
133
134 FUNCTION Get_Next_Billing_Date(
135 p_project_id IN NUMBER,
136 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137 ) RETURN DATE;
138
139 -- API name : REV_BILL_INF_REQ_CHECK
140 -- Type : Utility procedure
141 -- Pre-reqs : None
142 -- Return Value : N/A
143 -- Prameters
144 -- p_project_type_class_code IN VARCHAR2 REQUIRED
145 -- p_distribution_rule IN VARCHAR2 REQUIRED
146 -- p_billing_cycle_id IN NUMBER REQUIRED
147 -- p_first_bill_offset IN NUMBER REQUIRED
148 -- p_billing_job_group_id IN NUMBER REQUIRED
149 -- p_labor_id IN NUMBER REQUIRED
150 -- p_non_labor_id IN NUMBER REQUIRED
151 -- x_return_status OUT VARCHAR2 REQUIRED
152 -- x_error_msg_code OUT VARCHAR2 REQUIRED
153 --
154 -- History
155 --
156 -- 25-MAY-01 Majid Ansari -Created
157 --
158 --
159
160 PROCEDURE REV_BILL_INF_REQ_CHECK(
161 p_project_type_class_code IN VARCHAR2 ,
162 p_distribution_rule IN VARCHAR2 ,
163 p_billing_cycle_id IN NUMBER ,
164 p_first_bill_offset IN NUMBER ,
165 p_billing_job_group_id IN NUMBER ,
166 p_labor_id IN NUMBER ,
167 p_non_labor_id IN NUMBER ,
168 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
169 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
170 );
171
172 -- API name : BILL_XTENSION_REQ_CHECK
173 -- Type : Utility procedure
174 -- Pre-reqs : None
175 -- Return Value : N/A
176 -- Prameters
177 -- p_billing_extension_id IN NUMBER REQUIRED
178 -- x_return_status OUT VARCHAR2 REQUIRED
179 -- x_error_msg_code OUT VARCHAR2 REQUIRED
180 --
181 -- History
182 --
183 -- 25-MAY-01 Majid Ansari -Created
184 --
185 --
186
187 PROCEDURE BILL_XTENSION_REQ_CHECK(
188 p_billing_extension_id IN NUMBER ,
189 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
190 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
191 );
192
193 -- API name : VALIDATE_EMP_NO_TO_ID
194 -- Type : Utility procedure
195 -- Pre-reqs : None
196 -- Return Value : N/A
197 -- Prameters
198 -- p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
199 -- p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200 -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
201 -- x_person_id OUT NUMBER ,
202 -- x_return_status OUT VARCHAR2 REQUIRED
203 -- x_error_msg_code OUT VARCHAR2 REQUIRED
204 --
205 -- History
206 --
207 -- 25-MAY-01 Majid Ansari -Created
208 --
209 --
210
211 PROCEDURE VALIDATE_EMP_NO_TO_ID(
212 p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
213 p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214 p_check_id_flag IN VARCHAR2 DEFAULT 'A',
215 x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
216 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
217 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
218 );
219
220 -- API name : VALIDATE_EMP_NO_NAME
221 -- Type : Utility procedure
222 -- Pre-reqs : None
223 -- Return Value : N/A
224 -- Prameters
225 -- p_person_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM,
226 -- p_person_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
227 -- p_emp_number IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR,
228 -- p_check_id IN VARCHAR2 REQUIRED DEFAULT 'A'
229 -- x_person_id OUT NUMBER
230 -- x_return_status OUT VARCHAR2 REQUIRED
231 -- x_error_msg_code OUT VARCHAR2 REQUIRED
232 --
233 -- History
234 --
235 -- 25-MAY-01 Majid Ansari -Created
236 --
237 --
238
239 PROCEDURE VALIDATE_EMP_NO_NAME(
240 p_person_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241 p_person_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242 p_emp_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
243 p_check_id IN VARCHAR2 DEFAULT 'A',
244 x_person_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
245 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
246 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247 );
248
249
250 -- API name : CREDIT_REC_REQ_CHECK
251 -- Type : Utility procedure
252 -- Pre-reqs : None
253 -- Return Value : N/A
254 -- Prameters
255 -- p_credit_type IN VARCHAR2 REQUIRED
256 -- p_person_id IN NUMBER REQUIRED
257 -- p_transfer_to_AR IN VARCHAR2 REQUIRED
258 -- p_effective_from_date IN DATE REQUIRED
259 -- x_return_status OUT VARCHAR2 REQUIRED
260 -- x_error_msg_code OUT VARCHAR2 REQUIRED
261 --
262 -- History
263 --
264 -- 25-MAY-01 Majid Ansari -Created
265 --
266 --
267
268 PROCEDURE CREDIT_REC_REQ_CHECK(
269 p_credit_type IN VARCHAR2 ,
270 p_person_id IN NUMBER,
271 p_transfer_to_AR IN VARCHAR2,
272 p_effective_from_date IN DATE,
273 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
274 x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
275 );
276
277 -- API name : GET_SALES_CREDIT_FLAG
278 -- Type : Utility Function
279 -- Pre-reqs : None
280 -- Return Value : VARCHAR2( 'Y', 'N' )
281 -- Prameters
282 -- x_return_status OUT VARCHAR2 REQUIRED
283 --
284 -- History
285 --
286 -- 21-JUN-01 Majid Ansari -Created
287 --
288 --
289
290 FUNCTION GET_SALES_CREDIT_FLAG(
291 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
292 ) RETURN VARCHAR2;
293
294
295 END PA_BILLING_SETUP_UTILS;