1 PACKAGE PA_BILLING_SCHEDULE_PUB AS
2 /* $Header: PABLINPS.pls 120.1 2005/08/19 16:16:22 mwasowic noship $ */
3
4 -- API name : Update_Project_Task_Bill_Info
5 -- Type : Public procedure
6 -- Pre-reqs : None
7 -- Return Value : N/A
8 -- Prameters
9 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
10 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
11 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
12 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
13 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
14 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
15 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
16 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
17 -- p_project_id IN NUMBER REQUIRED
18 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
19 -- p_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
20 -- p_non_lbr_schedule_type IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
21 -- p_emp_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
22 -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
23 -- p_job_bill_rate_sch_name IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
24 -- p_job_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
25 -- p_lbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
26 -- p_lbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
27 -- p_rev_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
28 -- p_rev_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
29 -- p_inv_schedule IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
30 -- p_inv_schedule_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
31 -- p_rev_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
32 -- p_inv_ind_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
33 -- p_nlbr_bill_rate_org IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
34 -- p_nlbr_bill_rate_org_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
35 -- p_nlbr_std_bill_rate_sch IN VARCHAR2 OPTIONAL DEFAULT=FND_API.G_MISS_CHAR
36 -- p_nlbr_sch_fxd_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
37 -- p_nlbr_sch_discount IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
38 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
39 -- x_return_status OUT VARCHAR2 REQUIRED
40 -- x_msg_count OUT VARCHAR2 REQUIRED
41 -- x_msg_data OUT VARCHAR2 REQUIRED
42 --
43 -- History
44 --
45 -- 21-MAY-01 Majid Ansari -Created
46 --
47 --
48
49 PROCEDURE Update_Project_Task_Bill_Info(
50 p_api_version IN NUMBER DEFAULT 1.0,
51 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
52 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
54 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
56 p_debug_mode IN VARCHAR2 DEFAULT 'N',
57 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
58 p_project_id IN NUMBER ,
59 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60 p_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61 p_non_lbr_schedule_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62 p_emp_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
63 p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64 p_job_bill_rate_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65 p_job_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66 p_lbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
67 p_lbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
68 p_rev_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69 p_rev_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
70 p_inv_schedule IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
71 p_inv_schedule_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
72 p_rev_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
73 p_inv_ind_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
74 p_nlbr_bill_rate_org IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75 p_nlbr_bill_rate_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76 p_nlbr_std_bill_rate_sch IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77 p_nlbr_sch_fxd_date IN DATE DEFAULT FND_API.G_MISS_DATE,
78 p_nlbr_sch_discount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
79 p_record_version_number IN NUMBER DEFAULT 1,
80 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
81 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
82 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
83 );
84
85 -- API name : update_billing_schedule_type
86 -- Type : Public procedure
87 -- Pre-reqs : None
88 -- Return Value : N/A
89 -- Prameters
90 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
91 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
92 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
93 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
94 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
95 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
96 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
97 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
98 -- p_project_id IN NUMBER REQUIRED
99 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
100 -- p_lbr_schedule_type IN VARCHAR2 REQUIRED,
101 -- p_non_lbr_schedule_type IN VARCHAR2 REQUIRED,
102 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
103 -- x_return_status OUT VARCHAR2 REQUIRED
104 -- x_msg_count OUT VARCHAR2 REQUIRED
105 -- x_msg_data OUT VARCHAR2 REQUIRED
106 --
107 -- History
108 --
109 -- 21-MAY-01 Majid Ansari -Created
110 --
111 --
112 PROCEDURE update_billing_schedule_type(
113 p_api_version IN NUMBER DEFAULT 1.0,
114 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
115 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
117 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
119 p_debug_mode IN VARCHAR2 DEFAULT 'N',
120 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
121 p_project_id IN NUMBER ,
122 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
123 p_lbr_schedule_type IN VARCHAR2,
124 p_non_lbr_schedule_type IN VARCHAR2,
125 p_record_version_number IN NUMBER DEFAULT 1,
126 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
127 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
128 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129 );
130
131
132 -- API name : create_labor_multiplier
133 -- Type : Public procedure
134 -- Pre-reqs : None
135 -- Return Value : N/A
136 -- Prameters
137 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
138 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
139 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
140 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
141 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
142 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
143 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
144 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
145 -- p_project_id IN NUMBER REQUIRED
146 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
147 -- p_labor_multiplier IN NUMBER REQUIRED
148 -- p_effective_from_date IN DATE REQUIRED
149 -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
150 -- x_labor_multiplier_id OUT NUMBER REQUIRED
151 -- x_return_status OUT VARCHAR2 REQUIRED
152 -- x_msg_count OUT VARCHAR2 REQUIRED
153 -- x_msg_data OUT VARCHAR2 REQUIRED
154 --
155 -- History
156 --
157 -- 21-MAY-01 Majid Ansari -Created
158 --
159 --
160 PROCEDURE Create_Labor_Multiplier(
161 p_api_version IN NUMBER DEFAULT 1.0,
162 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
163 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
164 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
165 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
166 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
167 p_debug_mode IN VARCHAR2 DEFAULT 'N',
168 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
169 p_project_id IN NUMBER ,
170 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
171 p_labor_multiplier IN NUMBER ,
172 p_effective_from_date IN DATE ,
173 p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
174 x_labor_multiplier_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
175 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
176 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
177 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
178 );
179
180 -- API name : update_labor_multiplier
181 -- Type : Public procedure
182 -- Pre-reqs : None
183 -- Return Value : N/A
184 -- Prameters
185 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
186 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
187 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
188 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
189 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
190 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
191 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
192 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
193 -- p_labor_multiplier_id IN NUMBER REQUIRED
194 -- p_project_id IN NUMBER REQUIRED
195 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
196 -- p_labor_multiplier IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
197 -- p_effective_from_date IN DATE REQUIRED
198 -- p_effective_to_date IN DATE OPTIONAL DEFAULT=FND_API.G_MISS_DATE
199 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
200 -- x_return_status OUT VARCHAR2 REQUIRED
201 -- x_msg_count OUT VARCHAR2 REQUIRED
202 -- x_msg_data OUT VARCHAR2 REQUIRED
203 --
204 -- History
205 --
206 -- 21-MAY-01 Majid Ansari -Created
207 --
208 --
209 PROCEDURE Update_Labor_Multiplier(
210 p_api_version IN NUMBER DEFAULT 1.0,
211 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
213 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
214 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
215 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
216 p_debug_mode IN VARCHAR2 DEFAULT 'N',
217 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
218 p_labor_multiplier_id IN NUMBER,
219 p_project_id IN NUMBER ,
220 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
221 p_labor_multiplier IN NUMBER ,
222 p_effective_from_date IN DATE ,
223 p_effective_to_date IN DATE DEFAULT FND_API.G_MISS_DATE,
224 p_record_version_number IN NUMBER DEFAULT 1,
225 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
226 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
227 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
228 );
229
230 -- API name : delete_labor_multiplier
231 -- Type : Public procedure
232 -- Pre-reqs : None
233 -- Return Value : N/A
234 -- Prameters
235 -- p_api_version IN NUMBER REQUIRED DEFAULT=1.0
236 -- p_init_msg_list IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
237 -- p_commit IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_FALSE
238 -- p_validate_only IN VARCHAR2 REQUIRED DEFAULT=FND_API.G_TRUE
239 -- p_validation_level IN NUMBER OPTIONAL DEFAULT=FND_API.G_VALID_LEVEL_FULL
240 -- p_calling_module IN VARCHAR2 OPTIONAL DEFAULT='SELF_SERVICE'
241 -- p_debug_mode IN VARCHAR2 OPTIONAL DEFAULT='N'
242 -- p_max_msg_count IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
243 -- p_labor_multiplier_id IN NUMBER REQUIRED
244 -- p_project_id IN NUMBER REQUIRED
245 -- p_task_id IN NUMBER OPTIONAL DEFAULT=FND_API.G_MISS_NUM
246 -- p_labor_multiplier IN NUMBER OPTIONAL
247 -- p_effective_from_date IN DATE REQUIRED
248 -- p_record_version_number IN NUMBER REQUIRED DEFAULT=1
249 -- x_return_status OUT VARCHAR2 REQUIRED
250 -- x_msg_count OUT VARCHAR2 REQUIRED
251 -- x_msg_data OUT VARCHAR2 REQUIRED
252 --
253 -- History
254 --
255 -- 21-MAY-01 Majid Ansari -Created
256 --
257 --
258 PROCEDURE delete_Labor_Multiplier(
259 p_api_version IN NUMBER DEFAULT 1.0,
260 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
261 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
262 p_validate_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
263 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
264 p_calling_module IN VARCHAR2 DEFAULT 'SELF_SERVICE',
265 p_debug_mode IN VARCHAR2 DEFAULT 'N',
266 p_max_msg_count IN NUMBER DEFAULT FND_API.G_MISS_NUM,
267 p_labor_multiplier_id IN NUMBER,
268 p_project_id IN NUMBER ,
269 p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
270 p_labor_multiplier IN NUMBER ,
271 p_effective_from_date IN DATE ,
272 p_record_version_number IN NUMBER DEFAULT 1,
273 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
274 x_msg_count OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
275 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
276 );
277
278 END PA_BILLING_SCHEDULE_PUB;