[Home] [Help]
PACKAGE: APPS.PA_PROJECTS_PKG
Source
1 PACKAGE PA_PROJECTS_PKG as
2 /* $Header: PAXPROJS.pls 120.4.12010000.2 2008/10/27 16:55:45 atshukla 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 );
192
193 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
194 X_Project_Id NUMBER,
195 X_Name VARCHAR2,
196 X_Long_Name VARCHAR2,
197 X_Segment1 VARCHAR2,
198 X_Project_Type VARCHAR2,
199 X_Carrying_Out_Organization_Id NUMBER,
200 X_Public_Sector_Flag VARCHAR2,
201 X_Project_Status_Code VARCHAR2,
202 X_Description VARCHAR2,
203 X_Start_Date DATE,
204 X_Completion_Date DATE,
205 X_Closed_Date DATE,
206 X_Distribution_Rule VARCHAR2,
207 X_Labor_Invoice_Format_Id NUMBER,
208 X_NL_Invoice_Format_Id NUMBER,
209 X_Retention_Invoice_Format_Id NUMBER,
210 X_Retention_Percentage NUMBER,
211 X_Billing_Offset NUMBER,
212 X_Billing_Cycle_Id NUMBER,
213 X_Labor_Std_Bill_Rate_Schdl VARCHAR2,
214 X_Labor_Bill_Rate_Org_Id NUMBER,
215 X_Labor_Schedule_Fixed_Date DATE,
216 X_Labor_Schedule_Discount NUMBER,
217 X_NL_Std_Bill_Rate_Schdl VARCHAR2,
218 X_NL_Bill_Rate_Org_Id NUMBER,
219 X_NL_Schedule_Fixed_Date DATE,
220 X_NL_Schedule_Discount NUMBER,
221 X_Limit_To_Txn_Controls_Flag VARCHAR2,
222 X_Project_Level_Funding_Flag VARCHAR2,
223 X_Invoice_Comment VARCHAR2,
224 X_Unbilled_Receivable_Dr NUMBER,
225 X_Unearned_Revenue_Cr NUMBER,
226 X_Summary_Flag VARCHAR2,
227 X_Enabled_Flag VARCHAR2,
228 X_Segment2 VARCHAR2,
229 X_Segment3 VARCHAR2,
230 X_Segment4 VARCHAR2,
231 X_Segment5 VARCHAR2,
232 X_Segment6 VARCHAR2,
233 X_Segment7 VARCHAR2,
234 X_Segment8 VARCHAR2,
235 X_Segment9 VARCHAR2,
236 X_Segment10 VARCHAR2,
237 X_Attribute_Category VARCHAR2,
238 X_Attribute1 VARCHAR2,
239 X_Attribute2 VARCHAR2,
240 X_Attribute3 VARCHAR2,
241 X_Attribute4 VARCHAR2,
242 X_Attribute5 VARCHAR2,
243 X_Attribute6 VARCHAR2,
244 X_Attribute7 VARCHAR2,
245 X_Attribute8 VARCHAR2,
246 X_Attribute9 VARCHAR2,
247 X_Attribute10 VARCHAR2,
248 X_Cost_Ind_Rate_Sch_Id NUMBER,
249 X_Rev_Ind_Rate_Sch_Id NUMBER,
250 X_Inv_Ind_Rate_Sch_Id NUMBER,
251 X_Cost_Ind_Sch_Fixed_Date DATE,
252 X_Rev_Ind_Sch_Fixed_Date DATE,
253 X_Inv_Ind_Sch_Fixed_Date DATE,
254 X_Labor_Sch_Type VARCHAR2,
255 X_Non_Labor_Sch_Type VARCHAR2,
256 X_Template_Flag VARCHAR2,
257 X_Verification_Date DATE,
258 X_Created_From_Project_Id NUMBER,
259 X_Template_Start_Date DATE,
260 X_Template_End_Date DATE,
261 X_Project_Currency_Code VARCHAR2,
262 X_Allow_Cross_Charge_Flag VARCHAR2,
263 X_Project_Rate_Date DATE,
267 X_CC_Process_Labor_Flag VARCHAR2,
264 X_Project_Rate_Type VARCHAR2,
265 X_Output_Tax_Code VARCHAR2,
266 X_Retention_Tax_Code VARCHAR2,
268 X_Labor_Tp_Schedule_Id NUMBER,
269 X_Labor_Tp_Fixed_Date DATE,
270 X_CC_Process_NL_Flag VARCHAR2,
271 X_Nl_Tp_Schedule_Id NUMBER,
272 X_Nl_Tp_Fixed_Date DATE,
273 X_CC_Tax_Task_Id NUMBER,
274 -- 17-MAY-00 kkekkar Added the following columns for CBGA project
275 -- bill_job_group_id, cost_job_group_id
276 x_bill_job_group_id NUMBER ,
277 x_cost_job_group_id NUMBER ,
278 x_role_list_id NUMBER,
279 x_work_type_id NUMBER,
280 x_calendar_id NUMBER,
281 x_location_id NUMBER,
282 x_probability_member_id NUMBER,
283 x_project_value NUMBER,
284 x_expected_approval_date DATE,
285 x_team_template_id NUMBER,
286 -- 21-MAR-2001 anlee
287 -- added job_bill_rate_schedule_id,
288 -- emp_bill_rate_schedule_id for
289 -- PRM forecasting changes
290 x_job_bill_rate_schedule_id NUMBER,
291 x_emp_bill_rate_schedule_id NUMBER,
292 --MCA Sakthi for MultiAgreementCurreny Project
293 x_competence_match_wt NUMBER,
294 x_availability_match_wt NUMBER,
295 x_job_level_match_wt NUMBER,
296 x_enable_automated_search VARCHAR2,
297 x_search_min_availability NUMBER,
298 x_search_org_hier_id NUMBER,
299 x_search_starting_org_id NUMBER,
300 x_search_country_code VARCHAR2,
301 x_min_cand_score_reqd_for_nom NUMBER,
302 x_non_lab_std_bill_rt_sch_id NUMBER,
303 x_invproc_currency_type VARCHAR2,
304 x_revproc_currency_code VARCHAR2,
305 x_project_bil_rate_date_code VARCHAR2,
306 x_project_bil_rate_type VARCHAR2,
307 x_project_bil_rate_date DATE,
308 x_project_bil_exchange_rate NUMBER,
309 x_projfunc_currency_code VARCHAR2,
310 x_projfunc_bil_rate_date_code VARCHAR2,
311 x_projfunc_bil_rate_type VARCHAR2,
312 x_projfunc_bil_rate_date DATE,
313 x_projfunc_bil_exchange_rate NUMBER,
314 x_funding_rate_date_code VARCHAR2,
315 x_funding_rate_type VARCHAR2,
316 x_funding_rate_date DATE,
317 x_funding_exchange_rate NUMBER,
318 x_baseline_funding_flag VARCHAR2,
319 x_projfunc_cost_rate_type VARCHAR2,
320 x_projfunc_cost_rate_date DATE,
321 x_multi_currency_billing_flag VARCHAR2,
322 x_inv_by_bill_trans_curr_flag VARCHAR2,
323 --MCA Sakthi for MultiAgreementCurrency Project
324 x_assign_precedes_task VARCHAR2,
325 --Structure
326 x_split_cost_from_wokplan_flag VARCHAR2,
327 x_split_cost_from_bill_flag VARCHAR2,
328 --Structure
329 --Advertisement
330 x_adv_action_set_id NUMBER,
331 x_start_adv_action_set_flag VARCHAR2,
332 --Advertisement
333 --Project Setup
334 x_priority_code VARCHAR2,
335 --Project Setup
336 --Retention
337 x_retn_billing_inv_format_id NUMBER,
338 x_retn_accounting_flag VARCHAR2,
339 --Retention
340 -- anlee
341 -- patchset K changes
342 x_revaluate_funding_flag VARCHAR2,
343 x_include_gains_losses_flag VARCHAR2,
344 -- msundare
345 x_security_level NUMBER,
346 x_labor_disc_reason_code VARCHAR2,
347 x_non_labor_disc_reason_code VARCHAR2,
348 -- End of changes
349 x_record_version_number NUMBER,
350 x_btc_cost_base_rev_code VARCHAR2, /* bug#2638968 */
351 x_revtrans_currency_type VARCHAR2, /* R12 - Bug 4363092 */
352 --PA L
353 x_asset_allocation_method VARCHAR2,
354 x_capital_event_processing VARCHAR2,
355 x_cint_rate_sch_id NUMBER,
356 x_cint_eligible_flag VARCHAR2,
357 x_cint_stop_date DATE,
358 --FP_M Changes. Tracking Bug 3279981
359 x_en_top_task_customer_flag VARCHAR2,
360 x_en_top_task_inv_mth_flag VARCHAR2,
364 --sunkalya:federal Bug#5511353
361 x_revenue_accrual_method VARCHAR2,
362 x_invoice_method VARCHAR2,
363 x_projfunc_attr_for_ar_flag VARCHAR2,
365 x_date_eff_funds_flag VARCHAR2
366 --sunkalya:federal Bug#5511353
367 ,x_ar_rec_notify_flag VARCHAR2 -- 7508661 : EnC
368 ,x_auto_release_pwp_inv VARCHAR2 -- 7508661 : EnC
369 );
370
371
372 END PA_PROJECTS_PKG;