[Home] [Help]
PACKAGE: APPS.PA_PROJECTS_PKG1
Source
1 PACKAGE PA_PROJECTS_PKG1 as
2 /* $Header: PAXPRO1S.pls 120.2.12010000.2 2008/10/27 16:38:52 atshukla ship $ */
3
4 PROCEDURE Update_Row(X_Rowid VARCHAR2,
5 X_Project_Id NUMBER,
6 X_Name VARCHAR2,
7 X_Long_Name VARCHAR2,
8 X_Segment1 VARCHAR2,
9 X_Last_Update_Date DATE,
10 X_Last_Updated_By NUMBER,
11 X_Last_Update_Login NUMBER,
12 X_Project_Type VARCHAR2,
13 X_Carrying_Out_Organization_Id NUMBER,
14 X_Public_Sector_Flag VARCHAR2,
15 -- Commented for Bug 3605235
16 --X_Project_Status_Code VARCHAR2,
17 X_Description VARCHAR2,
18 X_Start_Date DATE,
19 X_Completion_Date DATE,
20 X_Closed_Date DATE,
21 X_Distribution_Rule VARCHAR2,
22 X_Labor_Invoice_Format_Id NUMBER,
23 X_NL_Invoice_Format_Id NUMBER,
24 X_Retention_Invoice_Format_Id NUMBER,
25 X_Retention_Percentage NUMBER,
26 X_Billing_Offset NUMBER,
27 X_Billing_Cycle_Id NUMBER,
28 X_Labor_Std_Bill_Rate_Schdl VARCHAR2,
29 X_Labor_Bill_Rate_Org_Id NUMBER,
30 X_Labor_Schedule_Fixed_Date DATE,
31 X_Labor_Schedule_Discount NUMBER,
32 X_NL_Std_Bill_Rate_Schdl VARCHAR2,
33 X_NL_Bill_Rate_Org_Id NUMBER,
34 X_NL_Schedule_Fixed_Date DATE,
35 X_NL_Schedule_Discount NUMBER,
36 X_Limit_To_Txn_Controls_Flag VARCHAR2,
37 X_Project_Level_Funding_Flag VARCHAR2,
38 X_Invoice_Comment VARCHAR2,
39 X_Unbilled_Receivable_Dr NUMBER,
40 X_Unearned_Revenue_Cr NUMBER,
41 X_Summary_Flag VARCHAR2,
42 X_Enabled_Flag VARCHAR2,
43 X_Segment2 VARCHAR2,
44 X_Segment3 VARCHAR2,
45 X_Segment4 VARCHAR2,
46 X_Segment5 VARCHAR2,
47 X_Segment6 VARCHAR2,
48 X_Segment7 VARCHAR2,
49 X_Segment8 VARCHAR2,
50 X_Segment9 VARCHAR2,
51 X_Segment10 VARCHAR2,
52 X_Attribute_Category VARCHAR2,
53 X_Attribute1 VARCHAR2,
54 X_Attribute2 VARCHAR2,
55 X_Attribute3 VARCHAR2,
56 X_Attribute4 VARCHAR2,
57 X_Attribute5 VARCHAR2,
58 X_Attribute6 VARCHAR2,
59 X_Attribute7 VARCHAR2,
60 X_Attribute8 VARCHAR2,
61 X_Attribute9 VARCHAR2,
62 X_Attribute10 VARCHAR2,
63 X_Cost_Ind_Rate_Sch_Id NUMBER,
64 X_Rev_Ind_Rate_Sch_Id NUMBER,
65 X_Inv_Ind_Rate_Sch_Id NUMBER,
66 X_Cost_Ind_Sch_Fixed_Date DATE,
67 X_Rev_Ind_Sch_Fixed_Date DATE,
68 X_Inv_Ind_Sch_Fixed_Date DATE,
69 X_Labor_Sch_Type VARCHAR2,
70 X_Non_Labor_Sch_Type VARCHAR2,
71 X_Template_Flag VARCHAR2,
72 X_Verification_Date DATE,
73 X_Created_From_Project_Id NUMBER,
74 X_Template_Start_Date DATE,
75 X_Template_End_Date DATE,
76 --added to remove bug#594567 : Ashia Bagai 6-jan-98
77 -- Commented for Bug 3605235
78 --X_Wf_Status_Code VARCHAR2,
79 --End of addition toremove bug#594567
80 X_Project_Currency_Code VARCHAR2,
81 X_Allow_Cross_Charge_Flag VARCHAR2,
82 X_Project_Rate_Date DATE,
83 X_Project_Rate_Type VARCHAR2,
84 X_Output_Tax_Code VARCHAR2,
85 X_Retention_Tax_Code VARCHAR2,
86 X_CC_Process_Labor_Flag VARCHAR2,
87 X_Labor_Tp_Schedule_Id NUMBER,
88 X_Labor_Tp_Fixed_Date DATE,
89 X_CC_Process_NL_Flag VARCHAR2,
90 X_Nl_Tp_Schedule_Id NUMBER,
91 X_Nl_Tp_Fixed_Date DATE,
92 X_CC_Tax_Task_Id NUMBER,
93 -- 17-MAY-00 kkekkar Added the following columns for CBGA project
94 -- bill_job_group_id, cost_job_group_id
95 x_bill_job_group_id NUMBER ,
96 x_cost_job_group_id NUMBER ,
97 x_role_list_id NUMBER,
98 x_work_type_id NUMBER,
99 x_calendar_id NUMBER,
100 x_location_id NUMBER,
101 x_probability_member_id NUMBER,
102 x_project_value NUMBER,
103 x_expected_approval_date DATE,
104 x_team_template_id NUMBER,
105 -- 21-MAR-2001 anlee
106 -- added job_bill_rate_schedule_id,
107 -- emp_bill_rate_schedule_id for
108 -- PRM forecasting changes
109 x_job_bill_rate_schedule_id NUMBER,
110 x_emp_bill_rate_schedule_id NUMBER,
111 --MCA Sakthi for MultiAgreementCurreny Project
112 x_competence_match_wt NUMBER,
113 x_availability_match_wt NUMBER,
114 x_job_level_match_wt NUMBER,
115 x_enable_automated_search VARCHAR2,
116 x_search_min_availability NUMBER,
117 x_search_org_hier_id NUMBER,
118 x_search_starting_org_id NUMBER,
119 x_search_country_code VARCHAR2,
120 x_min_cand_score_reqd_for_nom NUMBER,
121 x_non_lab_std_bill_rt_sch_id NUMBER,
122 x_invproc_currency_type VARCHAR2,
123 x_revproc_currency_code VARCHAR2,
124 x_project_bil_rate_date_code VARCHAR2,
125 x_project_bil_rate_type VARCHAR2,
126 x_project_bil_rate_date DATE,
127 x_project_bil_exchange_rate NUMBER,
128 x_projfunc_currency_code VARCHAR2,
129 x_projfunc_bil_rate_date_code VARCHAR2,
130 x_projfunc_bil_rate_type VARCHAR2,
131 x_projfunc_bil_rate_date DATE,
132 x_projfunc_bil_exchange_rate NUMBER,
133 x_funding_rate_date_code VARCHAR2,
134 x_funding_rate_type VARCHAR2,
135 x_funding_rate_date DATE,
136 x_funding_exchange_rate NUMBER,
137 x_baseline_funding_flag VARCHAR2,
138 x_projfunc_cost_rate_type VARCHAR2,
139 x_projfunc_cost_rate_date DATE,
140 x_multi_currency_billing_flag VARCHAR2,
141 x_inv_by_bill_trans_curr_flag VARCHAR2,
142 --MCA Sakthi for MultiAgreementCurrency Project
143 --MCA
144 x_assign_precedes_task VARCHAR2,
145 --MCA
146 --Structure
147 x_split_cost_from_wokplan_flag VARCHAR2,
148 x_split_cost_from_bill_flag VARCHAR2,
149 --Structure
150 --Advertisement
151 x_adv_action_set_id NUMBER,
152 x_start_adv_action_set_flag VARCHAR2,
153 --Advertisement
154 --Project Setup
155 x_priority_code VARCHAR2,
156 --Project Setup
157 --Retention
158 x_retn_billing_inv_format_id NUMBER,
159 x_retn_accounting_flag VARCHAR2,
160 --Retention
161 -- anlee
162 -- patchset K changes
163 x_revaluate_funding_flag VARCHAR2,
164 x_include_gains_losses_flag VARCHAR2,
165 -- msundare
166 x_security_level NUMBER,
167 x_labor_disc_reason_code VARCHAR2,
168 x_non_labor_disc_reason_code VARCHAR2,
169 -- End of changes
170 x_record_version_number NUMBER,
171 x_btc_cost_base_rev_code VARCHAR2, /* Bug#2638968 */
172 x_revtrans_currency_type VARCHAR2, /* R12 - Bug 4353092 */
173 --PA L
174 x_asset_allocation_method VARCHAR2,
175 x_capital_event_processing VARCHAR2,
176 x_cint_rate_sch_id NUMBER,
177 x_cint_eligible_flag VARCHAR2,
178 x_cint_stop_date DATE,
179 --FP_M Changes. Tracking Bug 3279981
180 x_en_top_task_customer_flag VARCHAR2,
181 x_en_top_task_inv_mth_flag VARCHAR2,
182 x_revenue_accrual_method VARCHAR2,
183 x_invoice_method VARCHAR2,
184 x_projfunc_attr_for_ar_flag VARCHAR2,
185 x_sys_program_flag VARCHAR2,
186 x_allow_multi_program_rollup VARCHAR2,
187 x_proj_req_res_format_id NUMBER,
188 x_proj_asgmt_res_format_id NUMBER,
189 x_date_eff_funds_flag VARCHAR2 --Bug 5511353
190 ,x_ar_rec_notify_flag VARCHAR2 -- 7508661 : EnC
191 ,x_auto_release_pwp_inv VARCHAR2 -- 7508661 : EnC
192 );
193
194 PROCEDURE Delete_Row(X_project_id NUMBER);
195
196 END PA_PROJECTS_PKG1;