4 --Declare empty pl/sql tables so that they can be used for defaulting
1 PACKAGE pa_fp_planning_transaction_pub AUTHID CURRENT_USER AS
2 /* $Header: PAFPPTPS.pls 120.8.12020000.3 2013/03/26 15:44:19 bpottipa ship $ */
3
5
6 /*=====================================================================
7 Procedure Name: add_planning_transactions
8 Purpose: This procedure should be called to create planning
9 transactions valid values for p_context are 'BUDGET'
10 ,'FORECAST', 'WORKPLAN' and 'TASK_ASSIGNMENT'.valid
11 values for p_default_resource_attribs are 'Y' or 'N'
12 When Y, the api will honor only resource list member
13 id, resource name and resource class flag in the
14 resource rec type and default all the other values
15 by calling the get resurce defaults api of resource
16 foundation.
17 If p_calling_module parameter is CREATE_VERSION,
18 donot call calculate api.
19
20 Creates resource assignments and budget lines for
21 workplan/budget/forecast. It is assumed that the
22 duplicate rlm ids are not passed . If this API finds
23 that there is no corresponding budget version then
24 this API goes and creates a budget version for the
25 work plan version.
26 =======================================================================*/
27 /*******************************************************************************************************
28 As part of Bug 3749516 All References to Equipment Effort or Equip Resource Class has been removed in
29 PROCEDURE add_planning_transactions.
30 p_planned_equip_effort_tbl IN parameter has also been removed as they were not being used/referred.
31 ********************************************************************************************************/
32 PROCEDURE add_planning_transactions
33 (
34 p_context IN VARCHAR2
35 ,p_extraction_type IN VARCHAR2 DEFAULT NULL -- Added for Bug 13419867
36 ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
37 ,p_one_to_one_mapping_flag IN VARCHAR2 DEFAULT 'N'
38 ,p_calling_module IN VARCHAR2 DEFAULT NULL
39 ,p_project_id IN Pa_projects_all.project_id%TYPE
40 ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
41 ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
42 ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
43 ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
44 DEFAULT SYSTEM.PA_NUM_TBL_TYPE() --bug#16200605
45 ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
46 ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
47 ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
48 ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
49 -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added
50 ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
51 ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
52 ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
53 ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
54 --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
55 ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
56 ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
57 /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
58 ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
59 ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
60 ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
61 ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
62 ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
63 ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
64 ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
65 ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
66 ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
67 ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
68 ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE() --added for Enc
69 ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
73 ,p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
70 ,p_pm_res_asgmt_ref IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
71 ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
72 ,p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
74 ,p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
75 ,p_attribute4 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
76 ,p_attribute5 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
77 ,p_attribute6 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
78 ,p_attribute7 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
79 ,p_attribute8 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
80 ,p_attribute9 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
81 ,p_attribute10 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
82 ,p_attribute11 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
83 ,p_attribute12 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
84 ,p_attribute13 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
85 ,p_attribute14 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
86 ,p_attribute15 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
87 ,p_attribute16 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
88 ,p_attribute17 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
89 ,p_attribute18 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
90 ,p_attribute19 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
91 ,p_attribute20 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
92 ,p_attribute21 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
93 ,p_attribute22 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
94 ,p_attribute23 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
95 ,p_attribute24 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
96 ,p_attribute25 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
97 ,p_attribute26 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
98 ,p_attribute27 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
99 ,p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
100 ,p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
101 ,p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
102 ,p_apply_progress_flag IN VARCHAR2 DEFAULT 'N' /* Bug# 3720357 */
103 ,p_scheduled_delay IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()--For bug 3948128
104 ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug# 4200168 */
105 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
106 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
107 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108 );
109
110 /*This procedure should be called to update planning transactions
111 valid values for p_context are 'BUDGET' , 'FORECAST', 'WORKPLAN' and 'TASK_ASSIGNMENT'
112 */
113 /*******************************************************************************************************
114 As part of Bug 3749516 All References to Equipment Effort or Equip Resource Class has been removed in
115 PROCEDURE update_planning_transactions.
116 All _addl_ and p_equip_people_effort_tbl IN parameters have also been removed as they were not being
117 used/referred.
118 ********************************************************************************************************/
119 PROCEDURE update_planning_transactions
120 (
121 p_context IN VARCHAR2
122 ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
123 ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
124 ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
125 ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
129 ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
126 ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
127 ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
128 ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
130 ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
131 -- One pl/sql record in The Above tables
132 ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
133 ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
134 ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
135 ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
136 ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
137 ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
138 ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
139 ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
140 ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
141 ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
142 ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
143 ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
144 ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
145 ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
146 ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
147 ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_20_TBL_TYPE()
148 ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
149 ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
150 ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
151 ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
152 ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
153 ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
154 ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
155 ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
156 ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
157 ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
158 ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
159 ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
160 ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
161 ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
162 ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
163 ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
164 ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
165 ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
166 ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
167 ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
168 ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
169 ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
170 ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
171 ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
172 ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
176 ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
173 ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
174 ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
175 ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
177 ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
178 ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
179 ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180 ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181 ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
182 ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
183 ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
184 ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
185 ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
186 ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
187 ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
188 ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
189 ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
190 ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
191 ,p_financial_category_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
192 ,p_supplier_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
193 ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
194 ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
195 ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
196 ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
197 ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
198 ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
199 ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
200 ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
201 ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
202 ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
203 ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
204 ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
205 ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
206 ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
207 ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
208 ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
209 ,p_attribute16_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
210 ,p_attribute17_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
211 ,p_attribute18_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
212 ,p_attribute19_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
213 ,p_attribute20_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
214 ,p_attribute21_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
215 ,p_attribute22_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
216 ,p_attribute23_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
217 ,p_attribute24_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
218 ,p_attribute25_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
222 ,p_attribute29_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
219 ,p_attribute26_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
220 ,p_attribute27_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
221 ,p_attribute28_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
223 ,p_attribute30_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
224 ,p_apply_progress_flag IN VARCHAR2 DEFAULT 'N' /* Passed from apply_progress api (sakthi's team) */
225 ,p_scheduled_delay IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()--For bug 3948128
226 ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug# 4200168 */
227 ,p_upd_cost_amts_too_for_ta_flg IN VARCHAR2 DEFAULT 'N' --Added for bug #4538286
228 ,p_distrib_amts IN VARCHAR2 DEFAULT 'Y' -- Bug 5684639.
229 ,p_direct_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE() --added for Enc
230 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
231 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
232 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
233
234
235
236 );
237
238 /*This procedure should be called to copy planning transactions
239 valid values for p_context are 'BUDGET' , 'FORECAST', 'WORKPLAN' and 'TASK_ASSIGNMENT'
240 valid values for p_copy_amt_qty are 'Y' and 'N'
241
242 The parameters
243 p_copy_people_flag
244 p_copy_equip_flag
245 p_copy_mat_item_flag
246 p_copy_fin_elem_flag
247 will be used only when the p_context is TASK_ASSIGNMENT.
248 Irrespective of the context in which the API is called,
249 the p_src_targ_version_id_tbl should never be empty.
250 The other parameters can be derived based on the values
251 in p_src_targ_version_id_tbl table.
252 */
253 PROCEDURE copy_planning_transactions
254 (
255 p_context IN VARCHAR2
256 ,p_copy_external_flag IN VARCHAR2
257 ,p_src_project_id IN pa_projects_all.project_id%TYPE
258 ,p_target_project_id IN pa_projects_all.project_id%TYPE
259 ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
260 ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
261 ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
262 ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
263 ,p_copy_people_flag IN VARCHAR2 := NULL
264 ,p_copy_equip_flag IN VARCHAR2 := NULL
265 ,p_copy_mat_item_flag IN VARCHAR2 := NULL
266 ,p_copy_fin_elem_flag IN VARCHAR2 := NULL
267 -- Added this field p_pji_rollup_required for the 4200168
268 ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y'
269 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
270 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
271 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
272
273 );
274
275
276
277 /*This procedure should be called to delete planning transactions
278 valid values for p_context are 'BUDGET' , 'FORECAST', 'WORKPLAN' and 'TASK_ASSIGNMENT'
279 valid values for p_task_or_res are 'TASKS','ASSIGNMENT'
280 In the context of 'TASK_ASSIGNMENT' the fields task_number and task_name are required in p_task_rec_tbl
281 If p_task_or_res is TASKS, p_element_version_id_tbl, p_task_number_tbl, p_task_name_tbl are used.
282 If p_task_or_res is ASSIGNMENT, p_resource_assignment_tbl is used.
283
284 p_calling_module can be NULL or PROCESS_RES_CHG_DERV_CALC_PRMS. If passed as Y
285 resource assignments will be deleted otherwise they
286 will not be deleted.(Please note that budget lines will be deleted
287 always irrespective of the value for this parameter).
288 Please note that this parameter cannot be PROCESS_RES_CHG_DERV_CALC_PRMS
289 when p_task_or_res is passed as TASKS
290 Whenever p_calling_module is passed as PROCESS_RES_CHG_DERV_CALC_PRMS,
291 the parameters p_task_id_tbl,p_resource_class_code_tbl
292 p_rbs_element_id_tbl and p_rate_based_flag_tbl should ALSO be
293 passed. These tbls must be equal in length to p_resource_assignment_tbl
294 and should contain the task id, rbs element id and rate based flag
295 for the resource assignment
296
297 Bug - 3719918. New param p_currency_code_tbl is added below
298 When p_context - Budget/Forecast and p_task_or_res is Assignment then only the bugdet lines
299 Corresponding to currency code passed will be deleted. After deleting of the budget lines
300 the corresponding RA will only we deleted if the budget line count is 0 from the RA.
301 p_calling_module will be'EDIT_PLAN' when called from edit plan pages.
302
303 */
304 PROCEDURE delete_planning_transactions
305 (
306 p_context IN VARCHAR2
307 ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
308 ,p_task_or_res IN VARCHAR2 DEFAULT 'TASKS'
309 ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
313 --Introduced for bug 3589130. If this parameter is passed as Y then an error will be thrown
310 ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
311 ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
312 ,p_resource_assignment_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
314 --When its required to delete a resource assignment containing budget lines. This parameter
315 --will be considered only for BUDGET and FORECAST context
316 ,p_validate_delete_flag IN VARCHAR2 DEFAULT 'N'
317 -- This param will be used for B/F Context. Bug - 3719918
318 ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
319 ,p_calling_module IN VARCHAR2 DEFAULT NULL
320 ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
321 ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
322 ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
323 ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
324 --For Bug 3937716. Calls to PJI and budget version rollup APIs will be skipped if p_rollup_required_flag is N.
325 ,p_rollup_required_flag IN VARCHAR2 DEFAULT 'Y'
326 ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug 4200168 */
327 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
328 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
329 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
330 );
331
332
333 /*=====================================================================
334 Procedure Name: ADD_WP_PLAN_TYPE
335 Purpose: This API checks if a Work Plan type is present in
336 the system.If is it not then it throws a error.
337 If WorkPlan Type is not attached to the project
338 then it attaches it.
339 This would be called when workplan is enabled for
340 a project or template.
341 Parameters:
342 IN 1)p_project_id IN SYSTEM.PA_NUM_TBL_TYPE
343 =======================================================================*/
344 PROCEDURE add_wp_plan_type
345 (
346 p_src_project_id IN pa_projects_all.project_id%TYPE
347 ,p_targ_project_id IN pa_projects_all.project_id%TYPE
348 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
349 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
350 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
351 );
352
353
354
355 /*=====================================================================
356 Procedure Name: check_and_create_task_rec_info
357 Purpose: This is a private api in the package. This API will
358 validate the task data passed to the
359 update_planning_transactions api This API checks
360 for the existence of the element version id passed
361 in pa_resource_assignments. If some of the element
362 version Ids are not there then it call
363 add_planning_transactions API to create records in
364 pa_resource_assignments. This API will be called
365 only when the context is WORKPLAN
366 =======================================================================*/
367 /*******************************************************************************************************
368 As part of Bug 3749516 All References to Equipment Effort or Equip Resource Class has been removed in
369 PROCEDURE check_and_create_task_rec_info.
370 p_planned_equip_effort_tbl IN parameter has also been removed as they were not being used/referred.
371 ********************************************************************************************************/
372 PROCEDURE check_and_create_task_rec_info
373 (
374 p_project_id IN Pa_projects_all.project_id%TYPE
375 ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
376 ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
377 ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
378 ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
379 ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
380 ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
381 ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
382 ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
383 ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
384 ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
385 ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
386 ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
387 ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
388 ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
389 ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
390 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
391 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
395
392 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
393 );
394
396
397 /*=============================================================================
398 This api would be called for a finplan version, whenever there is a change
399 either in planning level or resource list or rbs version.
400 ==============================================================================*/
401
402 PROCEDURE Refresh_Plan_Txns(
403 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
404 ,p_plan_level_change IN VARCHAR2
405 ,p_resource_list_change IN VARCHAR2
406 ,p_rbs_version_change IN VARCHAR2
407 ,p_time_phase_change_flag IN VARCHAR2
408 ,p_ci_ver_agr_change_flag IN VARCHAR2 DEFAULT 'N' --IPM enhancement
409 ,p_rev_der_method_change IN VARCHAR2 DEFAULT 'N' --Bug 5462471
410 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
411 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
412 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
413
414
415 /* This API creates default task planning transactions for a new plan
416 * version . Modified for IPM Changes added two parameters to see
417 if it is being called from select tasks page and if all the
418 resources have to be added. */
419
420 PROCEDURE Create_Default_Task_Plan_Txns (
421 P_budget_version_id IN Number
422 ,P_version_plan_level_code IN VARCHAR2
423 ,p_calling_context IN VARCHAR2 DEFAULT 'CREATE_VERSION'
424 ,p_add_all_resources_flag IN VARCHAR2 DEFAULT 'N'
425 ,X_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
426 ,X_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
427 ,X_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
428
429 /*=============================================================================
430 This api is called upon save from Additional Workplan Options page. Whenever
431 there is a change in the Additional Workplan setting page, all the chages should
432 be propagated to all the underlying workplan versions immediately upon save.
433 ===============================================================================*/
434
435 PROCEDURE REFRESH_WP_SETTINGS(
436 p_project_id IN pa_budget_versions.project_id%TYPE
437 ,p_resource_list_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
438 ,p_time_phase_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
439 ,p_rbs_version_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
440 ,p_track_costs_flag_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
441 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
442 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
443 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
444
445 /*=============================================================================
446 This api is called when ever RBS should be changed for budget versions.
447
448 Usage:
449 p_calling_context --> 'ALL_CHILD_VERSIONS'
450 p_budget_version_id --> null
451 If there is a change in RBS for a financial plan type
452 to push the change to the underlying budget version.
453 p_budget_version_id would be null
454
455 p_calling_context --> 'SINGLE_VERSION'
456 p_budget_version_id --> not null, version id should be passed
457 --> This mode is useful for creation of working versions
458 out of published versions, or copy amounts case from
459 a different version
460 ==============================================================================*/
461
462 PROCEDURE Refresh_rbs_for_versions(
463 p_project_id IN pa_projects_all.project_id%TYPE
464 ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
465 ,p_calling_context IN VARCHAR2 Default 'ALL_CHILD_VERSIONS'
466 ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE Default null
467 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
468 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
469 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
470
471 --This function returns 'N' if a record already exists in pa_resource_assignments
472 --for a given budget version id, task id and resource list member id
473 --Returns 'Y' if the record is not already there
474 FUNCTION DUP_EXISTS
475 ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
476 ,p_task_id IN pa_tasks.task_id%TYPE
477 ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
478 ,p_project_id IN pa_projects_all.project_id%TYPE)
479 RETURN VARCHAR2;
480
481 END PA_FP_PLANNING_TRANSACTION_PUB;
482
483