eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_BUDGET_VERSIONS

Line 135: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

Line 136: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

Line 154: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --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

Line 155: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --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

Line 156: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --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

Line 166: -- x_primary_pp_bv_id OUT pa_budget_versions.budget_version_id%TYPE,

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

Line 180: (p_project_id IN pa_budget_versions.project_id%TYPE,

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,

Line 181: p_ci_id IN pa_budget_versions.ci_id%TYPE,

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,

Line 184: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

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,

Line 185: p_user_rev_version_id IN pa_budget_versions.budget_version_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,

Line 202: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --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

Line 203: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --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

Line 204: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --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

Line 298: (p_project_id IN pa_budget_versions.project_id%TYPE,

294: /* ------------------------------------------------------------- */
295:
296: /* populates the global temporary tables */
297: procedure view_plan_temp_tables
298: (p_project_id IN pa_budget_versions.project_id%TYPE,
299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
300: p_cost_or_revenue IN VARCHAR2,
301: p_user_bv_flag IN VARCHAR2,
302: x_cost_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

295:
296: /* populates the global temporary tables */
297: procedure view_plan_temp_tables
298: (p_project_id IN pa_budget_versions.project_id%TYPE,
299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
300: p_cost_or_revenue IN VARCHAR2,
301: p_user_bv_flag IN VARCHAR2,
302: x_cost_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
303: x_rev_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 313: (p_project_id IN pa_budget_versions.project_id%TYPE,

309: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
310: );
311:
312: procedure pa_fp_vp_pop_tables_separate
313: (p_project_id IN pa_budget_versions.project_id%TYPE,
314: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
315: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
316: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
317: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 314: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

310: );
311:
312: procedure pa_fp_vp_pop_tables_separate
313: (p_project_id IN pa_budget_versions.project_id%TYPE,
314: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
315: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
316: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
317: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
318: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 315: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

311:
312: procedure pa_fp_vp_pop_tables_separate
313: (p_project_id IN pa_budget_versions.project_id%TYPE,
314: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
315: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
316: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
317: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
318: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
319: );

Line 322: (p_project_id IN pa_budget_versions.project_id%TYPE,

318: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
319: );
320:
321: procedure pa_fp_vp_pop_tables_together
322: (p_project_id IN pa_budget_versions.project_id%TYPE,
323: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
324: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
325: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
326: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 323: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

319: );
320:
321: procedure pa_fp_vp_pop_tables_together
322: (p_project_id IN pa_budget_versions.project_id%TYPE,
323: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
324: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
325: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
326: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
327: );

Line 330: (p_project_id IN pa_budget_versions.project_id%TYPE,

326: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
327: );
328:
329: procedure pa_fp_vp_pop_tables_single
330: (p_project_id IN pa_budget_versions.project_id%TYPE,
331: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
332: p_cost_or_rev IN VARCHAR2,
333: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
334: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 331: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

327: );
328:
329: procedure pa_fp_vp_pop_tables_single
330: (p_project_id IN pa_budget_versions.project_id%TYPE,
331: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
332: p_cost_or_rev IN VARCHAR2,
333: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
334: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
335: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895