[Home] [Help]
PACKAGE: APPS.PA_PROJECTS_PKG
Source
1 PACKAGE PA_PROJECTS_PKG AUTHID CURRENT_USER as
2 /* $Header: PAXPROJS.pls 120.7 2011/03/18 12:11:30 pcheruvu ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, -- 4537865
6 X_Project_Id IN OUT NOCOPY NUMBER, -- 4537865
7 x_org_id NUMBER, --R12 Bug 4363092
8 X_Name VARCHAR2,
9 X_Long_name VARCHAR2,
10 X_Segment1 VARCHAR2,
11 X_Last_Update_Date DATE,
12 X_Last_Updated_By NUMBER,
13 X_Creation_Date DATE,
14 X_Created_By NUMBER,
15 X_Last_Update_Login NUMBER,
16 X_Project_Type VARCHAR2,
17 X_Carrying_Out_Organization_Id NUMBER,
18 X_Public_Sector_Flag VARCHAR2,
19 X_Project_Status_Code VARCHAR2,
20 X_Description VARCHAR2,
21 X_Start_Date DATE,
22 X_Completion_Date DATE,
23 X_Closed_Date DATE,
24 X_Distribution_Rule VARCHAR2,
25 X_Labor_Invoice_Format_Id NUMBER,
26 X_NL_Invoice_Format_Id NUMBER,
27 X_Retention_Invoice_Format_Id NUMBER,
28 X_Retention_Percentage NUMBER,
29 X_Billing_Offset NUMBER,
30 X_Billing_Cycle_Id NUMBER,
31 X_Labor_Std_Bill_Rate_Schdl VARCHAR2,
32 X_Labor_Bill_Rate_Org_Id NUMBER,
33 X_Labor_Schedule_Fixed_Date DATE,
34 X_Labor_Schedule_Discount NUMBER,
35 X_NL_Std_Bill_Rate_Schdl VARCHAR2,
36 X_NL_Bill_Rate_Org_Id NUMBER,
37 X_NL_Schedule_Fixed_Date DATE,
38 X_NL_Schedule_Discount NUMBER,
39 X_Limit_To_Txn_Controls_Flag VARCHAR2,
40 X_Project_Level_Funding_Flag VARCHAR2,
41 X_Invoice_Comment VARCHAR2,
42 X_Unbilled_Receivable_Dr NUMBER,
43 X_Unearned_Revenue_Cr NUMBER,
44 X_Summary_Flag VARCHAR2,
45 X_Enabled_Flag VARCHAR2,
46 X_Segment2 VARCHAR2,
47 X_Segment3 VARCHAR2,
48 X_Segment4 VARCHAR2,
49 X_Segment5 VARCHAR2,
50 X_Segment6 VARCHAR2,
51 X_Segment7 VARCHAR2,
52 X_Segment8 VARCHAR2,
53 X_Segment9 VARCHAR2,
54 X_Segment10 VARCHAR2,
55 X_Attribute_Category VARCHAR2,
56 X_Attribute1 VARCHAR2,
57 X_Attribute2 VARCHAR2,
58 X_Attribute3 VARCHAR2,
59 X_Attribute4 VARCHAR2,
60 X_Attribute5 VARCHAR2,
61 X_Attribute6 VARCHAR2,
62 X_Attribute7 VARCHAR2,
63 X_Attribute8 VARCHAR2,
64 X_Attribute9 VARCHAR2,
65 X_Attribute10 VARCHAR2,
66 X_Cost_Ind_Rate_Sch_Id NUMBER,
67 X_Rev_Ind_Rate_Sch_Id NUMBER,
68 X_Inv_Ind_Rate_Sch_Id NUMBER,
69 X_Cost_Ind_Sch_Fixed_Date DATE,
70 X_Rev_Ind_Sch_Fixed_Date DATE,
71 X_Inv_Ind_Sch_Fixed_Date DATE,
72 X_Labor_Sch_Type VARCHAR2,
73 X_Non_Labor_Sch_Type VARCHAR2,
74 X_Template_Flag VARCHAR2,
75 X_Verification_Date DATE,
76 X_Created_From_Project_Id NUMBER,
77 X_Template_Start_Date DATE,
78 X_Template_End_Date DATE,
79 X_Project_Currency_Code VARCHAR2,
80 X_Allow_Cross_Charge_Flag VARCHAR2,
81 X_Project_Rate_Date DATE,
82 X_Project_Rate_Type VARCHAR2,
83 X_Output_Tax_Code VARCHAR2,
84 X_Retention_Tax_Code VARCHAR2,
85 X_CC_Process_Labor_Flag VARCHAR2,
86 X_Labor_Tp_Schedule_Id NUMBER,
87 X_Labor_Tp_Fixed_Date DATE,
88 X_CC_Process_NL_Flag VARCHAR2,
89 X_Nl_Tp_Schedule_Id NUMBER,
90 X_Nl_Tp_Fixed_Date DATE,
91 X_CC_Tax_Task_Id NUMBER,
92 -- 17-MAY-00 kkekkar Added the following columns for CBGA project
93 -- bill_job_group_id, cost_job_group_id
94 x_bill_job_group_id NUMBER ,
95 x_cost_job_group_id NUMBER ,
96 x_role_list_id NUMBER,
97 x_work_type_id NUMBER,
98 x_calendar_id NUMBER,
99 x_location_id NUMBER,
100 x_probability_member_id NUMBER,
101 x_project_value NUMBER,
102 x_expected_approval_date DATE,
103 x_team_template_id NUMBER,
104 -- 21-MAR-2001 anlee
105 -- added job_bill_rate_schedule_id,
106 -- emp_bill_rate_schedule_id for
107 -- PRM forecasting changes
108 x_job_bill_rate_schedule_id NUMBER,
109 x_emp_bill_rate_schedule_id NUMBER,
110 --MCA Sakthi for MultiAgreementCurreny Project
111 x_competence_match_wt NUMBER,
112 x_availability_match_wt NUMBER,
113 x_job_level_match_wt NUMBER,
114 x_enable_automated_search VARCHAR2,
115 x_search_min_availability NUMBER,
116 x_search_org_hier_id NUMBER,
117 x_search_starting_org_id NUMBER,
118 x_search_country_code VARCHAR2,
119 x_min_cand_score_reqd_for_nom NUMBER,
120 x_non_lab_std_bill_rt_sch_id NUMBER,
121 x_invproc_currency_type VARCHAR2,
122 x_revproc_currency_code VARCHAR2,
123 x_project_bil_rate_date_code VARCHAR2,
124 x_project_bil_rate_type VARCHAR2,
125 x_project_bil_rate_date DATE,
126 x_project_bil_exchange_rate NUMBER,
127 x_projfunc_currency_code VARCHAR2,
128 x_projfunc_bil_rate_date_code VARCHAR2,
129 x_projfunc_bil_rate_type VARCHAR2,
130 x_projfunc_bil_rate_date DATE,
131 x_projfunc_bil_exchange_rate NUMBER,
132 x_funding_rate_date_code VARCHAR2,
133 x_funding_rate_type VARCHAR2,
134 x_funding_rate_date DATE,
135 x_funding_exchange_rate NUMBER,
136 x_baseline_funding_flag VARCHAR2,
137 x_projfunc_cost_rate_type VARCHAR2,
138 x_projfunc_cost_rate_date DATE,
139 x_multi_currency_billing_flag VARCHAR2,
140 x_inv_by_bill_trans_curr_flag VARCHAR2,
141 --MCA Sakthi for MultiAgreementCurrency Project
142 x_assign_precedes_task VARCHAR2,
143 --Structure
144 x_split_cost_from_wokplan_flag VARCHAR2,
145 x_split_cost_from_bill_flag VARCHAR2,
146 --Structure
147 --Advertisement
148 x_adv_action_set_id NUMBER,
149 x_start_adv_action_set_flag VARCHAR2,
150 --Advertisement
151 --Project Setup
152 x_priority_code VARCHAR2,
153 --Project Setup
154 --Retention
155 x_retn_billing_inv_format_id NUMBER,
156 x_retn_accounting_flag VARCHAR2,
157 --Retention
158 -- anlee
159 -- patchset K changes
160 x_revaluate_funding_flag VARCHAR2,
161 x_include_gains_losses_flag VARCHAR2,
162 -- msundare
163 x_security_level NUMBER,
164 x_labor_disc_reason_code VARCHAR2,
165 x_non_labor_disc_reason_code VARCHAR2,
166 -- End of changes
167 x_record_version_number NUMBER,
168 x_btc_cost_base_rev_code VARCHAR2, /* bug#2638968 */
169 x_revtrans_currency_type VARCHAR2, /* R12 - Bug 4363092 */
170 --PA L
171 x_asset_allocation_method VARCHAR2,
172 x_capital_event_processing VARCHAR2,
173 x_cint_rate_sch_id NUMBER,
174 x_cint_eligible_flag VARCHAR2,
175 x_cint_stop_date DATE,
176 --FP_M Changes. Tracking Bug 3279981
177 x_en_top_task_customer_flag VARCHAR2,
178 x_en_top_task_inv_mth_flag VARCHAR2,
179 x_revenue_accrual_method VARCHAR2,
180 x_invoice_method VARCHAR2,
181 x_projfunc_attr_for_ar_flag VARCHAR2,
182 x_sys_program_flag VARCHAR2,
183 x_allow_multi_program_rollup VARCHAR2,
184 x_proj_req_res_format_id NUMBER,
185 x_proj_asgmt_res_format_id NUMBER,
186 --sunkalya:federal Bug#5511353
187 x_date_eff_funds_flag VARCHAR2
188 --sunkalya:federal Bug#5511353
189 ,x_ar_rec_notify_flag VARCHAR2 -- 7508661 : EnC
190 ,x_auto_release_pwp_inv VARCHAR2 -- 7508661 : EnC
191 /* Added for 12.2 Payroll billing ER 11847616 */
192 ,x_bill_labor_accrual VARCHAR2 default 'N',
193 x_adj_on_std_inv VARCHAR2 default 'N'
194 /* Added for 12.2 Payroll billing ER 11847616 */
195 );
196
197
198 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
199 X_Project_Id NUMBER,
200 X_Name VARCHAR2,
201 X_Long_Name VARCHAR2,
202 X_Segment1 VARCHAR2,
203 X_Project_Type VARCHAR2,
204 X_Carrying_Out_Organization_Id NUMBER,
205 X_Public_Sector_Flag VARCHAR2,
206 X_Project_Status_Code VARCHAR2,
207 X_Description VARCHAR2,
208 X_Start_Date DATE,
209 X_Completion_Date DATE,
210 X_Closed_Date DATE,
211 X_Distribution_Rule VARCHAR2,
212 X_Labor_Invoice_Format_Id NUMBER,
213 X_NL_Invoice_Format_Id NUMBER,
214 X_Retention_Invoice_Format_Id NUMBER,
215 X_Retention_Percentage NUMBER,
216 X_Billing_Offset NUMBER,
217 X_Billing_Cycle_Id NUMBER,
218 X_Labor_Std_Bill_Rate_Schdl VARCHAR2,
219 X_Labor_Bill_Rate_Org_Id NUMBER,
220 X_Labor_Schedule_Fixed_Date DATE,
221 X_Labor_Schedule_Discount NUMBER,
222 X_NL_Std_Bill_Rate_Schdl VARCHAR2,
223 X_NL_Bill_Rate_Org_Id NUMBER,
224 X_NL_Schedule_Fixed_Date DATE,
225 X_NL_Schedule_Discount NUMBER,
226 X_Limit_To_Txn_Controls_Flag VARCHAR2,
227 X_Project_Level_Funding_Flag VARCHAR2,
228 X_Invoice_Comment VARCHAR2,
229 X_Unbilled_Receivable_Dr NUMBER,
230 X_Unearned_Revenue_Cr NUMBER,
231 X_Summary_Flag VARCHAR2,
232 X_Enabled_Flag VARCHAR2,
233 X_Segment2 VARCHAR2,
234 X_Segment3 VARCHAR2,
235 X_Segment4 VARCHAR2,
236 X_Segment5 VARCHAR2,
237 X_Segment6 VARCHAR2,
238 X_Segment7 VARCHAR2,
239 X_Segment8 VARCHAR2,
240 X_Segment9 VARCHAR2,
241 X_Segment10 VARCHAR2,
242 X_Attribute_Category VARCHAR2,
243 X_Attribute1 VARCHAR2,
244 X_Attribute2 VARCHAR2,
245 X_Attribute3 VARCHAR2,
246 X_Attribute4 VARCHAR2,
247 X_Attribute5 VARCHAR2,
248 X_Attribute6 VARCHAR2,
249 X_Attribute7 VARCHAR2,
250 X_Attribute8 VARCHAR2,
251 X_Attribute9 VARCHAR2,
252 X_Attribute10 VARCHAR2,
253 X_Cost_Ind_Rate_Sch_Id NUMBER,
254 X_Rev_Ind_Rate_Sch_Id NUMBER,
255 X_Inv_Ind_Rate_Sch_Id NUMBER,
256 X_Cost_Ind_Sch_Fixed_Date DATE,
257 X_Rev_Ind_Sch_Fixed_Date DATE,
258 X_Inv_Ind_Sch_Fixed_Date DATE,
259 X_Labor_Sch_Type VARCHAR2,
260 X_Non_Labor_Sch_Type VARCHAR2,
261 X_Template_Flag VARCHAR2,
262 X_Verification_Date DATE,
263 X_Created_From_Project_Id NUMBER,
264 X_Template_Start_Date DATE,
265 X_Template_End_Date DATE,
266 X_Project_Currency_Code VARCHAR2,
267 X_Allow_Cross_Charge_Flag VARCHAR2,
268 X_Project_Rate_Date DATE,
269 X_Project_Rate_Type VARCHAR2,
270 X_Output_Tax_Code VARCHAR2,
271 X_Retention_Tax_Code VARCHAR2,
272 X_CC_Process_Labor_Flag VARCHAR2,
273 X_Labor_Tp_Schedule_Id NUMBER,
274 X_Labor_Tp_Fixed_Date DATE,
275 X_CC_Process_NL_Flag VARCHAR2,
279 -- 17-MAY-00 kkekkar Added the following columns for CBGA project
276 X_Nl_Tp_Schedule_Id NUMBER,
277 X_Nl_Tp_Fixed_Date DATE,
278 X_CC_Tax_Task_Id NUMBER,
280 -- bill_job_group_id, cost_job_group_id
281 x_bill_job_group_id NUMBER ,
282 x_cost_job_group_id NUMBER ,
283 x_role_list_id NUMBER,
284 x_work_type_id NUMBER,
285 x_calendar_id NUMBER,
286 x_location_id NUMBER,
287 x_probability_member_id NUMBER,
288 x_project_value NUMBER,
289 x_expected_approval_date DATE,
290 x_team_template_id NUMBER,
291 -- 21-MAR-2001 anlee
292 -- added job_bill_rate_schedule_id,
293 -- emp_bill_rate_schedule_id for
294 -- PRM forecasting changes
295 x_job_bill_rate_schedule_id NUMBER,
296 x_emp_bill_rate_schedule_id NUMBER,
297 --MCA Sakthi for MultiAgreementCurreny Project
298 x_competence_match_wt NUMBER,
299 x_availability_match_wt NUMBER,
300 x_job_level_match_wt NUMBER,
301 x_enable_automated_search VARCHAR2,
302 x_search_min_availability NUMBER,
303 x_search_org_hier_id NUMBER,
304 x_search_starting_org_id NUMBER,
305 x_search_country_code VARCHAR2,
306 x_min_cand_score_reqd_for_nom NUMBER,
307 x_non_lab_std_bill_rt_sch_id NUMBER,
308 x_invproc_currency_type VARCHAR2,
309 x_revproc_currency_code VARCHAR2,
310 x_project_bil_rate_date_code VARCHAR2,
311 x_project_bil_rate_type VARCHAR2,
312 x_project_bil_rate_date DATE,
313 x_project_bil_exchange_rate NUMBER,
314 x_projfunc_currency_code VARCHAR2,
315 x_projfunc_bil_rate_date_code VARCHAR2,
316 x_projfunc_bil_rate_type VARCHAR2,
317 x_projfunc_bil_rate_date DATE,
318 x_projfunc_bil_exchange_rate NUMBER,
319 x_funding_rate_date_code VARCHAR2,
320 x_funding_rate_type VARCHAR2,
321 x_funding_rate_date DATE,
322 x_funding_exchange_rate NUMBER,
323 x_baseline_funding_flag VARCHAR2,
324 x_projfunc_cost_rate_type VARCHAR2,
325 x_projfunc_cost_rate_date DATE,
326 x_multi_currency_billing_flag VARCHAR2,
327 x_inv_by_bill_trans_curr_flag VARCHAR2,
328 --MCA Sakthi for MultiAgreementCurrency Project
329 x_assign_precedes_task VARCHAR2,
330 --Structure
331 x_split_cost_from_wokplan_flag VARCHAR2,
332 x_split_cost_from_bill_flag VARCHAR2,
333 --Structure
334 --Advertisement
335 x_adv_action_set_id NUMBER,
336 x_start_adv_action_set_flag VARCHAR2,
337 --Advertisement
338 --Project Setup
339 x_priority_code VARCHAR2,
340 --Project Setup
341 --Retention
342 x_retn_billing_inv_format_id NUMBER,
343 x_retn_accounting_flag VARCHAR2,
344 --Retention
345 -- anlee
346 -- patchset K changes
347 x_revaluate_funding_flag VARCHAR2,
348 x_include_gains_losses_flag VARCHAR2,
349 -- msundare
350 x_security_level NUMBER,
351 x_labor_disc_reason_code VARCHAR2,
352 x_non_labor_disc_reason_code VARCHAR2,
353 -- End of changes
354 x_record_version_number NUMBER,
355 x_btc_cost_base_rev_code VARCHAR2, /* bug#2638968 */
356 x_revtrans_currency_type VARCHAR2, /* R12 - Bug 4363092 */
357 --PA L
358 x_asset_allocation_method VARCHAR2,
359 x_capital_event_processing VARCHAR2,
360 x_cint_rate_sch_id NUMBER,
361 x_cint_eligible_flag VARCHAR2,
362 x_cint_stop_date DATE,
363 --FP_M Changes. Tracking Bug 3279981
364 x_en_top_task_customer_flag VARCHAR2,
365 x_en_top_task_inv_mth_flag VARCHAR2,
366 x_revenue_accrual_method VARCHAR2,
367 x_invoice_method VARCHAR2,
368 x_projfunc_attr_for_ar_flag VARCHAR2,
369 --sunkalya:federal Bug#5511353
370 x_date_eff_funds_flag VARCHAR2
371 --sunkalya:federal Bug#5511353
372 ,x_ar_rec_notify_flag VARCHAR2 -- 7508661 : EnC
373 ,x_auto_release_pwp_inv VARCHAR2 -- 7508661 : EnC
374
375 /* Added for 12.2 Payroll billing ER 11847616 */
376 ,x_bill_labor_accrual VARCHAR2,
377 x_adj_on_std_inv VARCHAR2
378 /* Added for 12.2 Payroll billing ER 11847616 */
379 );
380
381
382 END PA_PROJECTS_PKG;