1 PACKAGE PA_INVOICE_DETAIL_PROCESS AUTHID CURRENT_USER as
2 /* $Header: PAICINDS.pls 120.0 2005/05/30 19:50:48 appldev noship $*/
3
4 --
5 -- Table to store the project type - Cost Accrual/Non Cost Accrual
6 --
7 G_project_category PA_PLSQL_DATATYPES.Char1TabTyp;
8
9
10 /* Cursor to get CC Distribution */
11 cursor get_cc_dist ( l_exp_item_id IN NUMBER )
12 is
13 SELECT CCDIST.rowid,CCDIST.*
14 FROM PA_CC_DIST_LINES CCDIST
18 WHERE L.EXPENDITURE_ITEM_ID =
15 WHERE CCDIST.EXPENDITURE_ITEM_ID = l_exp_item_id
16 AND CCDIST.LINE_NUM = ( SELECT MAX(L.LINE_NUM)
17 FROM PA_CC_DIST_LINES L
19 CCDIST.EXPENDITURE_ITEM_ID);
20
21 --
22 -- This package will create invoice details and provider reclass entry
23 -- Parameter :
24 -- P_Project_Id - Project Id
25 -- P_Draft_Inv_Num - Draft Invoice Number
26 -- P_Customer_Id - Customer Id
27 -- P_Bill_to_site_use_id - Bill to site Use id
28 -- P_Ship_to_site_use_id - Ship to Site Use id
29 -- P_Sets_of_books_id - Sets of Books Id
30 -- P_User_Id - User Id
31 -- P_Request_id - Request Id
32 -- P_TP_sch_line_id - Transfer Price Schedule Line Id
33 -- P_revenue_ccid - Revenue account ccid
34 -- P_Cross_charge_code - Cross Charge Code
35 --
36 --
37 PROCEDURE process_invoice_details
38 ( P_Project_Id IN number ,
39 P_Customer_Id IN number,
40 P_Bill_to_site_use_id IN number,
41 P_Ship_to_site_use_id IN number ,
42 P_Set_of_books_id IN number ,
43 P_Acct_curr_code IN varchar2 ,
44 P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
45 P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
46 P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
47 P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
48 P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
49 P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
50 P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
51 P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
52 P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
53 P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
54 P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
55 P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
56 P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
57 P_Revenue_distributed_flag
58 IN PA_PLSQL_DATATYPES.Char1TabTyp ,
59 P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
60 P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
61 P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
62 P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
63 P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
64 P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
65 P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
66 P_Denom_burdened_cost_amt
67 IN PA_PLSQL_DATATYPES.Char30TabTyp ,
68 P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
69 P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
70 P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
71 P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
72 P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
73 P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
74 P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
75 P_NL_resource_organization
76 IN PA_PLSQL_DATATYPES.IdTabTyp ,
77 P_Incurred_by_person_id
78 IN PA_PLSQL_DATATYPES.IdTabTyp ,
79 P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
80 P_Denom_TP_currency_code
81 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
82 P_Denom_transfer_price
83 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
84 P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
85 P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
86 P_Acct_TP_exchange_rate
87 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
88 P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
89 P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
90 P_TP_ind_compiled_set_id
91 IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
92 P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
93 P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
94 P_TP_bill_markup_percentage
95 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
96 P_TP_schedule_line_percentage
97 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
98 P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
99 P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
100 P_ca_prov_code IN Varchar2,
101 P_nca_prov_code IN Varchar2,
102 P_Processed_thru_date IN Date ,
103 P_No_of_records IN NUMBER ,
104 P_User_Id IN NUMBER ,
105 P_Request_id IN NUMBER ,
106 P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
107 P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
108 P_prov_proj_bill_job_id
109 IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
110 /*Added for cross proj*/
111 P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
112 P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
113 P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
114 P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
115 P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
116 P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
117 P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
118 P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
119 P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
120 P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
121 P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
122 /*End for cross proj*/
123 /* Bill rate Discount*/
124 p_dist_rule IN PA_PLSQL_DATATYPES.Char30TabTyp,
125 p_mcb_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
126 p_bill_rate_multiplier IN PA_PLSQL_DATATYPES.Char30TabTyp,
127 p_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
128 /* p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.NumTabTyp, Commented for bug 3252190 */
129 p_labor_schdl_discnt IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed the data type from Num to char for bug3252190 */
130 p_labor_schdl_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
131 p_bill_job_grp_id IN PA_PLSQL_DATATYPES.NumTabTyp,
132 p_labor_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
133 p_project_org_id IN PA_PLSQL_DATATYPES.NumTabTyp ,
134 p_project_type IN PA_PLSQL_DATATYPES.Char30TabTyp,
135 p_exp_func_curr_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
136 p_incurred_by_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
137 p_raw_cost_rate IN PA_PLSQL_DATATYPES.Char30TabTyp,
138 p_override_to_organz_id IN PA_PLSQL_DATATYPES.NumTabTyp,
139 p_emp_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
140 p_job_bill_rate_schedule_id IN PA_PLSQL_DATATYPES.NumTabTyp,
141 p_exp_raw_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
142 p_assignment_precedes_task IN PA_PLSQL_DATATYPES.Char1TabTyp,
143
144 p_burden_cost IN PA_PLSQL_DATATYPES.Char30TabTyp,
145 p_task_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
146 p_proj_nl_bill_rate_org_id IN PA_PLSQL_DATATYPES.IdTabTyp,
147 p_task_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
148 p_proj_nl_std_bill_rate_sch IN PA_PLSQL_DATATYPES.Char30TabTyp,
149 p_nl_sch_type IN PA_PLSQL_DATATYPES.Char1TabTyp,
150 p_nl_task_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
151 p_nl_proj_sch_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
152 p_nl_task_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
153 p_nl_proj_sch_discount IN PA_PLSQL_DATATYPES.NumTabTyp,
154 /* Added the last two parameters for Doosan Rate api changes */
155 p_task_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
156 p_proj_nl_std_bill_rate_sch_id IN PA_PLSQL_DATATYPES.NumTabTyp DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab,
157 p_uom_flag IN PA_PLSQL_DATATYPES.NumTabTyp
158 DEFAULT PA_PLSQL_DATATYPES.EmptyNumTab
159 );
160
161 /* !!!!This is overloaded procedure for compilation of pro*c files of Patchset H */
162 /* !!!!Note: This .pls with overload function should not be sent along with the patch for Patchset H customers */
163 PROCEDURE process_invoice_details
164 ( P_Project_Id IN number ,
165 P_Customer_Id IN number,
166 P_Bill_to_site_use_id IN number,
167 P_Ship_to_site_use_id IN number ,
168 P_Set_of_books_id IN number ,
169 P_Acct_curr_code IN varchar2 ,
170 P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
171 P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
172 P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
173 P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
174 P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
175 P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
176 P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
177 P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
178 P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
179 P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
180 P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
181 P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
182 P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
183 P_Revenue_distributed_flag
184 IN PA_PLSQL_DATATYPES.Char1TabTyp ,
185 P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
186 P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
187 P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
188 P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
189 P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
190 P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
191 P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
192 P_Denom_burdened_cost_amt
193 IN PA_PLSQL_DATATYPES.Char30TabTyp ,
194 P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
195 P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
196 P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
197 P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
198 P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199 P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
200 P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
201 P_NL_resource_organization
202 IN PA_PLSQL_DATATYPES.IdTabTyp ,
203 P_Incurred_by_person_id
204 IN PA_PLSQL_DATATYPES.IdTabTyp ,
205 P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
206 P_Denom_TP_currency_code
207 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
208 P_Denom_transfer_price
209 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
210 P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
211 P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
212 P_Acct_TP_exchange_rate
213 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
214 P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
215 P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
216 P_TP_ind_compiled_set_id
217 IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
218 P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
219 P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
220 P_TP_bill_markup_percentage
221 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
222 P_TP_schedule_line_percentage
223 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
224 P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
225 P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
226 P_ca_prov_code IN Varchar2,
227 P_nca_prov_code IN Varchar2,
228 P_Processed_thru_date IN Date ,
229 P_No_of_records IN NUMBER ,
230 P_User_Id IN NUMBER ,
231 P_Request_id IN NUMBER ,
232 P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
233 P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
234 P_prov_proj_bill_job_id
235 IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp);
236
237
238 /* !!!!This is overloaded procedure for compilation of pro*c files of Patchset J */
239 /* !!!!Note: This .pls with overload function should not be sent along with the patch for Patchset J customers */
240
241 PROCEDURE process_invoice_details
242 ( P_Project_Id IN number ,
243 P_Customer_Id IN number,
244 P_Bill_to_site_use_id IN number,
245 P_Ship_to_site_use_id IN number ,
246 P_Set_of_books_id IN number ,
247 P_Acct_curr_code IN varchar2 ,
248 P_Expenditure_category IN PA_PLSQL_DATATYPES.Char30TabTyp,
249 P_CC_Project_Id IN PA_PLSQL_DATATYPES.IdTabTyp ,
250 P_CC_Tax_task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
251 P_EI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
252 P_AdjEI_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
253 P_Net_zero_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
254 P_TP_sch_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
255 P_revenue_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
256 P_provider_cr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
257 P_provider_dr_ccid IN PA_PLSQL_DATATYPES.IdTabTyp ,
258 P_Task_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
259 P_Cross_charge_code IN PA_PLSQL_DATATYPES.Char1TabTyp ,
260 P_Labor_nl_flag IN PA_PLSQL_DATATYPES.Char1TabTyp ,
261 P_Revenue_distributed_flag
262 IN PA_PLSQL_DATATYPES.Char1TabTyp ,
263 P_Expend_type IN PA_PLSQL_DATATYPES.Char30TabTyp ,
264 P_EI_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
265 P_Sys_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp ,
266 P_Denom_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
267 P_Prj_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
268 P_TP_fixed_date IN PA_PLSQL_DATATYPES.Char30TabTyp ,
269 P_Denom_raw_cost_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
270 P_Denom_burdened_cost_amt
271 IN PA_PLSQL_DATATYPES.Char30TabTyp ,
272 P_Raw_revenue_amt IN PA_PLSQL_DATATYPES.Char30TabTyp ,
273 P_Quantity IN PA_PLSQL_DATATYPES.Char30TabTyp ,
274 P_Non_labor_resource IN PA_PLSQL_DATATYPES.Char20TabTyp ,
275 P_Prvdr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
276 P_Recvr_org_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
277 P_Recvr_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
278 P_Expnd_Organization IN PA_PLSQL_DATATYPES.IdTabTyp ,
279 P_NL_resource_organization
280 IN PA_PLSQL_DATATYPES.IdTabTyp ,
281 P_Incurred_by_person_id
282 IN PA_PLSQL_DATATYPES.IdTabTyp ,
283 P_Job_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
284 P_Denom_TP_currency_code
285 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp ,
286 P_Denom_transfer_price
287 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
288 P_Acct_TP_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
289 P_Acct_TP_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
290 P_Acct_TP_exchange_rate
291 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
292 P_Acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
293 P_CC_markup_base_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
294 P_TP_ind_compiled_set_id
295 IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
296 P_TP_bill_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
297 P_TP_base_amt IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
298 P_TP_bill_markup_percentage
299 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
300 P_TP_schedule_line_percentage
301 IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
302 P_TP_rule_percentage IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
303 P_burden_disp_method IN PA_PLSQL_DATATYPES.Char1TabTyp ,
304 P_ca_prov_code IN Varchar2,
305 P_nca_prov_code IN Varchar2,
306 P_Processed_thru_date IN Date ,
307 P_No_of_records IN NUMBER ,
308 P_User_Id IN NUMBER ,
309 P_Request_id IN NUMBER ,
310 P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
311 P_tp_job_id IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
312 P_prov_proj_bill_job_id
313 IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
314 /*Added for cross proj*/
315 P_tp_amt_type_code IN PA_PLSQL_DATATYPES.Char30TabTyp ,
316 P_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char15TabTyp ,
317 P_project_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
318 P_project_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
319 P_project_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
320 P_projfunc_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
321 P_projfunc_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
322 P_projfunc_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
323 P_assignment_id IN PA_PLSQL_DATATYPES.IdTabTyp,
324 P_project_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp ,
325 P_projfunc_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
326 /*End for cross proj*/
327 );
328 --Procedure to initialize global counter
329 PROCEDURE init;
330
331 --Procedure to add record in update buffer
332 /* Added the parameter p_adjusted_ei for bug 2770182 */
333
334 PROCEDURE reverse_row ( p_inv_rec IN OUT NOCOPY pa_draft_invoice_details%rowtype,
335 p_adjusted_ei IN NUMBER DEFAULT NULL );
336
337 -- Apply all pending insert changes in Bulk
338 PROCEDURE apply_ins_changes ;
339
340 -- Procedure to reverse crosscharge distribution
341 PROCEDURE reverse_cc_dist ( P_INV_DET_ID IN NUMBER,
342 P_EI_DATE IN DATE,
343 P_Sys_linkage IN VARCHAR2, /* Added for 3857986 */
344 P_CC_REC IN OUT NOCOPY get_cc_dist%rowtype,
345 P_index IN number);
346
347 -- Procedure to reverse the provider reclass entries
348 -- from invoice cancellation
349 --
350 PROCEDURE reverse_preclass (
351 P_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
352 P_new_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp,
353 P_EI_id PA_PLSQL_DATATYPES.IdTabTyp,
354 P_EI_date PA_PLSQL_DATATYPES.Char30TabTyp,
355 P_Sys_Linkage PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for 3857986 */
356 P_tab_count NUMBER);
357
358 END PA_INVOICE_DETAIL_PROCESS;
[Home] [Help]