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