[Home] [Help]
PACKAGE: APPS.PA_FP_VIEW_PLANS_PUB
Source
1 PACKAGE pa_fp_view_plans_pub AUTHID CURRENT_USER as
2 /* $Header: PAFPVPLS.pls 120.1.12010000.2 2009/07/22 01:02:03 snizam ship $
3 Start of Comments
4 Package name : pa_fin_plan_maint_ver_global
5 Purpose : API's for Financial Planning: View Plans Page
6 History :
7 NOTE :
8 End of Comments
9 */
10
11 type av_tab_project_id is
12 TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;
13 type av_tab_task_id is
14 TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15 type av_tab_resource_list_member_id is
16 TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;
17 type av_tab_cost_budget_version_id is
18 TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
19 type av_tab_cost_res_assignment_id is
20 TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
21 type av_tab_rev_budget_version_id is
22 TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
23 type av_tab_rev_res_assignment_id is
24 TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
25 type av_tab_element_name is
26 TABLE of VARCHAR2(1000) index by BINARY_INTEGER;
27 type av_tab_element_level is
28 TABLE of VARCHAR2(50) index by BINARY_INTEGER;
29 type av_tab_labor_hours is
30 TABLE of pa_resource_assignments.total_utilization_hours%TYPE index by BINARY_INTEGER; --Bug 7514054
31 type av_tab_burdened_cost is
32 TABLE of pa_resource_assignments.total_plan_burdened_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
33 type av_tab_raw_cost is
34 TABLE of pa_resource_assignments.total_plan_raw_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
35 type av_tab_revenue is
36 TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
37 type av_tab_margin is
38 TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
39 type av_tab_margin_percent is
40 TABLE of pa_resource_assignments.total_utilization_percent%TYPE index by BINARY_INTEGER; --Bug 7514054
41 type av_tab_line_editable is
42 TABLE of VARCHAR2(1) index by BINARY_INTEGER;
43 type av_tab_row_level is
44 TABLE of NUMBER index by BINARY_INTEGER;
45 type av_tab_amount_type is
46 TABLE of pa_proj_periods_denorm.amount_type_code%TYPE index by BINARY_INTEGER;
47 type av_tab_amount_subtype is
48 TABLE of pa_proj_periods_denorm.amount_subtype_code%TYPE index by BINARY_INTEGER;
49 type av_tab_period_numbers is
50 TABLE of pa_proj_periods_denorm.period_amount1%TYPE index by BINARY_INTEGER;
51 type av_tab_amount_type_id is
52 TABLE of pa_proj_periods_denorm.amount_type_id%TYPE index by BINARY_INTEGER;
53 type av_tab_amount_subtype_id is
54 TABLE of pa_proj_periods_denorm.amount_subtype_id%TYPE index by BINARY_INTEGER;
55 type av_tab_unit_of_measure is
56 TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;
57 type av_tab_preceding_amts is
58 TABLE of pa_proj_periods_denorm.preceding_periods_amount%TYPE index by BINARY_INTEGER;
59 type av_tab_succeeding_amts is
60 TABLE of pa_proj_periods_denorm.succeeding_periods_amount%TYPE index by BINARY_INTEGER;
61 type av_tab_has_child_element is
62 TABLE of VARCHAR2(1) index by BINARY_INTEGER;
63
64 G_DEFAULT_AMOUNT_TYPE_CODE VARCHAR2(30);
65 G_DEFAULT_AMT_SUBTYPE_CODE VARCHAR2(30);
66 G_FP_COST_VERSION_ID NUMBER(15);
67 G_FP_COST_VERSION_NUMBER NUMBER(15);
68 G_FP_COST_VERSION_NAME VARCHAR2(60);
69 G_FP_REV_VERSION_ID NUMBER(15);
70 G_FP_REV_VERSION_NAME VARCHAR2(60);
71 G_FP_REV_VERSION_NUMBER NUMBER(15);
72 G_FP_ALL_VERSION_ID NUMBER(15);
73 G_FP_ALL_VERSION_NAME VARCHAR2(60);
74 G_FP_ALL_VERSION_NUMBER NUMBER(15);
75 G_FP_CALC_MARGIN_FROM VARCHAR2(30);
76 G_FP_CALC_QUANTITY_FROM VARCHAR2(30);
77 G_DISPLAY_FROM VARCHAR2(10); -- 'ANY', 'COST', 'REVENUE', or 'BOTH'
78 G_AMT_OR_PD VARCHAR2(1); -- 'A' for amounts, 'P' for periodic
79 G_UNCAT_RLM_ID NUMBER(15); -- uncategorized resource list member id
80
81 -- Display Customization Variables
82 G_DISPLAY_FLAG_QUANTITY VARCHAR2(1);
83 G_DISPLAY_FLAG_RAWCOST VARCHAR2(1);
84 G_DISPLAY_FLAG_BURDCOST VARCHAR2(1);
85 G_DISPLAY_FLAG_REVENUE VARCHAR2(1);
86 G_DISPLAY_FLAG_MARGIN VARCHAR2(1);
87 G_DISPLAY_FLAG_MARGINPCT VARCHAR2(1);
88 G_DISPLAY_FLAG_PREC VARCHAR2(1);
89 G_DISPLAY_FLAG_SUCC VARCHAR2(1);
90
91 G_FP_ORG_ID number;
92 G_FP_VIEW_VERSION_ID number;
93 G_FP_PLAN_TYPE_ID number;
94 G_FP_RA_ID number;
95 G_FP_AMOUNT_TYPE_CODE VARCHAR2(30);--:='COST';
96 G_FP_ADJ_REASON_CODE VARCHAR2(15);--:='REVENUE';
97 G_FP_CURRENCY_CODE VARCHAR2(15);--:='USD';
98 G_FP_CURRENCY_TYPE VARCHAR2(30);
99 G_FP_VIEW_START_DATE1 date;--:=to_date('01-Mar-02');
100 G_FP_VIEW_START_DATE2 date;--:=to_date('01-Apr_02');
101 G_FP_VIEW_START_DATE3 date;--:=to_date('01-May-02');
102 G_FP_VIEW_START_DATE4 date;--:=to_date('01-Jun-02');
103 G_FP_VIEW_START_DATE5 date;--:=to_date('01-Jul-02');
104 G_FP_VIEW_START_DATE6 date;--:=to_date('01-Aug-02');
105 G_FP_VIEW_START_DATE7 date;--:=to_date('01-Feb-03');
106 G_FP_VIEW_START_DATE8 date;--:=to_date('01-Mar-03');
107 G_FP_VIEW_START_DATE9 date;--:=to_date('01-Apr-03');
108 G_FP_VIEW_START_DATE10 date;--:=to_date('01-May-03');
109 G_FP_VIEW_START_DATE11 date;--:=to_date('01-Jun-03');
110 G_FP_VIEW_START_DATE12 date;--:=to_date('01-Jul-03');
111 G_FP_VIEW_START_DATE13 date;--:=to_date('01-Aug-03');
112 G_FP_VIEW_END_DATE1 date;--:=to_date('31-Mar-02');
113 G_FP_VIEW_END_DATE2 date;--:=to_date('30-Apr-02');
114 G_FP_VIEW_END_DATE3 date;--:=to_date('31-May-02');
115 G_FP_VIEW_END_DATE4 date;--:=to_date('30-Jun-02');
116 G_FP_VIEW_END_DATE5 date;--:=to_date('31-Jul-02');
117 G_FP_VIEW_END_DATE6 date;--:=to_date('31-Aug-02');
118 G_FP_VIEW_END_DATE7 date;--:=to_date('28-Feb-03');
119 G_FP_VIEW_END_DATE8 date;--:=to_date('31-Mar-03');
120 G_FP_VIEW_END_DATE9 date;--:=to_date('30-Apr-03');
121 G_FP_VIEW_END_DATE10 date;--:=to_date('31-May-03');
122 G_FP_VIEW_END_DATE11 date;--:=to_date('30-Jun-03');
123 G_FP_VIEW_END_DATE12 date;--:=to_date('31-Jul-03');
124 G_FP_VIEW_END_DATE13 date;--:=to_date('31-Aug-03');
125 G_FP_PERIOD_TYPE VARCHAR2(30);
126 G_FP_PLAN_START_DATE date;--:=to_date('01-Mar-02');
127 G_FP_PLAN_END_DATE date;--:=to_date('31-Aug-02');
128
129 -- x_primary_pp_bv_id stores the bvid of the version with a valid period profile id
130 -- (in case of COST_AND_REV_SEP and only one has a period profile id)
131 PROCEDURE pa_fp_viewplan_hgrid_init
132 ( p_user_id IN NUMBER,
133 p_orgfcst_version_id IN NUMBER,
134 p_period_start_date IN VARCHAR2,
135 p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
136 p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
137 px_display_quantity IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
138 px_display_rawcost IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
139 px_display_burdcost IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140 px_display_revenue IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
141 px_display_margin IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
142 px_display_marginpct IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
143 p_view_currency_type IN VARCHAR2,
144 p_amt_or_pd IN VARCHAR2,
145 x_view_currency_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
146 x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
147 x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
148 x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
149 x_plan_period_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
150 x_labor_hrs_from_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
151 x_cost_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
152 x_rev_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
153 x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
154 x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
155 x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
156 x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
157 x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
158 x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
159 x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
160 x_diff_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
161 x_old_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
162 x_refresh_pd_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
163 x_cost_rv_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
164 x_rev_rv_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
165 x_time_phase_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
166 -- x_primary_pp_bv_id OUT pa_budget_versions.budget_version_id%TYPE,
167 x_in_period_profile OUT NOCOPY VARCHAR2, -- 'B' for before, 'A' for after --File.Sql.39 bug 4440895
168 x_prec_pds_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
169 x_succ_pds_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
170 x_refresh_req_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
171 x_uncat_rlmid OUT NOCOPY NUMBER, -- for View Link SQL --File.Sql.39 bug 4440895
172 x_def_amt_subt_code OUT NOCOPY VARCHAR2, -- for View Link SQL --File.Sql.39 bug 4440895
173 x_plan_class_code OUT NOCOPY VARCHAR2, -- for Plan Class Security (FP L) --File.Sql.39 bug 4440895
174 x_auto_baselined_flag OUT NOCOPY VARCHAR2, -- for bug 3146974 --File.Sql.39 bug 4440895
175 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
176 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
177 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
178
179 procedure pa_fp_viewplan_hgrid_init_ci
180 (p_project_id IN pa_budget_versions.project_id%TYPE,
181 p_ci_id IN pa_budget_versions.ci_id%TYPE,
182 p_user_id IN NUMBER,
183 p_period_start_date IN VARCHAR2,
184 p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
185 p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
186 p_display_quantity IN VARCHAR2,
187 p_display_rawcost IN VARCHAR2,
188 p_display_burdcost IN VARCHAR2,
189 p_display_revenue IN VARCHAR2,
190 p_display_margin IN VARCHAR2,
191 p_display_marginpct IN VARCHAR2,
192 p_view_currency_type IN VARCHAR2,
193 p_amt_or_pd IN VARCHAR2,
194 x_view_currency_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
195 x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
196 x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
197 x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198 x_plan_period_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
199 x_labor_hrs_from_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
200 x_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
201 x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
202 x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
203 x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
204 x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
205 x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
206 x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
207 x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
208 x_diff_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
209 x_old_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
210 x_refresh_pd_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
211 x_cost_rv_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
212 x_rev_rv_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
213 x_time_phase_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
214 x_auto_baselined_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
215 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
216 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
217 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
218 );
219
220 /*
221 PROCEDURE pa_fp_viewby_set_globals(
222 p_amount_type_code IN VARCHAR2,
223 p_resource_assignment_id IN NUMBER,
224 p_budget_version_id IN NUMBER,
225 p_start_period IN VARCHAR2,
226 x_return_status OUT VARCHAR2,
227 x_msg_count OUT NUMBER,
228 x_msg_data OUT VARCHAR2
229 );
230 */
231 PROCEDURE pa_fp_set_periods (
232 p_period_start_date IN VARCHAR2,
233 p_period_type IN VARCHAR2,
237
234 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
235 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
236 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
238 );
239
240 PROCEDURE pa_fp_set_periods_nav ( p_direction IN VARCHAR2,
241 p_num_of_periods IN NUMBER,
242 p_period_type IN VARCHAR2,
243 x_start_date OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
244 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
245 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
246 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247 );
248
249 FUNCTION Get_Version_ID return Number;
250 FUNCTION Get_Fp_Period_Type return VARCHAR2; /* Added for bug 7514054*/
251 FUNCTION Get_Cost_Version_Id return Number;
252 FUNCTION Get_Rev_Version_Id return Number;
253 FUNCTION Get_Org_ID return Number;
254 FUNCTION Get_Plan_Type_ID return NUMBER;
255 FUNCTION Get_Derive_Margin_From_Code return VARCHAR2;
256 FUNCTION Get_Report_Labor_Hrs_From_Code return VARCHAR2;
257 FUNCTION Get_Resource_assignment_ID return NUMBER;
258 FUNCTION Get_Amount_Type_code return VARCHAR2;
259 FUNCTION Get_Adj_Reason_code return VARCHAR2;
260 FUNCTION Get_Currency_Code return VARCHAR2;
261 FUNCTION Get_Currency_Type return VARCHAR2;
262 FUNCTION Get_Uncat_Res_List_Member_Id return NUMBER;
263 FUNCTION Get_Period_Start_Date1 return Date;
264 FUNCTION Get_Period_Start_Date2 return Date;
265 FUNCTION Get_Period_Start_Date3 return Date;
266 FUNCTION Get_Period_Start_Date4 return Date;
267 FUNCTION Get_Period_Start_Date5 return Date;
268 FUNCTION Get_Period_Start_Date6 return Date;
269 FUNCTION Get_Period_Start_Date7 return Date;
270 FUNCTION Get_Period_Start_Date8 return Date;
271 FUNCTION Get_Period_Start_Date9 return Date;
272 FUNCTION Get_Period_Start_Date10 return Date;
273 FUNCTION Get_Period_Start_Date11 return Date;
274 FUNCTION Get_Period_Start_Date12 return Date;
275 FUNCTION Get_Period_Start_Date13 return Date;
276 FUNCTION Get_Plan_Start_Date return Date;
277 FUNCTION Get_Plan_End_Date return Date;
278 FUNCTION Get_Prec_Pds_Flag return VARCHAR2;
279 FUNCTION Get_Succ_Pds_Flag return VARCHAR2;
280
281 FUNCTION Get_Default_Amount_Type_Code return VARCHAR2;
282 FUNCTION Get_Default_Amt_Subtype_Code return VARCHAR2;
283 FUNCTION Get_Cost_Version_Number return NUMBER;
284 FUNCTION Get_Rev_Version_Number return NUMBER;
285 FUNCTION Get_Cost_Version_Name return VARCHAR2;
286 FUNCTION Get_Rev_Version_Name return VARCHAR2;
287 FUNCTION Get_All_Version_Name return VARCHAR2;
288 FUNCTION Get_All_Version_Number return NUMBER;
289 FUNCTION Get_Period_Type return VARCHAR2;
290 PROCEDURE Set_Cost_Version_Number (p_version_number IN NUMBER);
291 PROCEDURE Set_Rev_Version_Number (p_version_number IN NUMBER);
292 PROCEDURE Set_Cost_Version_Name (p_version_name IN VARCHAR2);
293 PROCEDURE Set_Rev_Version_Name (p_version_name IN VARCHAR2);
294
295 /* ------------------------------------------------------------- */
296
297 /* populates the global temporary tables */
298 procedure view_plan_temp_tables
299 (p_project_id IN pa_budget_versions.project_id%TYPE,
300 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
301 p_cost_or_revenue IN VARCHAR2,
302 p_user_bv_flag IN VARCHAR2,
303 x_cost_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
304 x_rev_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
305 x_cost_version_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
306 x_rev_version_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
307 x_diff_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
308 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
309 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
310 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
311 );
312
313 procedure pa_fp_vp_pop_tables_separate
314 (p_project_id IN pa_budget_versions.project_id%TYPE,
315 p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
316 p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
317 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
318 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
319 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
320 );
321
322 procedure pa_fp_vp_pop_tables_together
323 (p_project_id IN pa_budget_versions.project_id%TYPE,
324 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
325 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
326 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
327 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
328 );
329
330 procedure pa_fp_vp_pop_tables_single
331 (p_project_id IN pa_budget_versions.project_id%TYPE,
332 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
333 p_cost_or_rev IN VARCHAR2,
334 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
335 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
336 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
337 );
338
339 function has_child_rows
340 (p_project_id IN pa_resource_assignments.project_id%TYPE,
341 p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
342 p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
346 p_amt_or_periodic IN VARCHAR2) return VARCHAR2;
343 p_task_id IN pa_resource_assignments.task_id%TYPE,
344 p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
345 p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
347
348 end pa_fp_view_plans_pub;