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_CONTROL_ITEMS_UTILS dependencies on PA_CONTROL_ITEMS

Line 223: p_ci_id IN pa_control_items.ci_id%TYPE,

219: --Bug 3550073. Included x_upd_cost_impact_allowed and x_upd_rev_impact_allowed
220: PROCEDURE FP_CI_VALIDATE_UPDATE_IMPACT
221: (
222: p_project_id IN pa_budget_versions.project_id%TYPE,
223: p_ci_id IN pa_control_items.ci_id%TYPE,
224: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
225: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
226: x_upd_cost_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
227: x_upd_rev_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 355: FUNCTION is_fin_impact_enabled(p_ci_id IN pa_control_items.ci_id%TYPE,

351: /* FP.M -dbora */
352: FUNCTION is_impact_exists(p_ci_id IN pa_ci_impacts.ci_id%TYPE)
353: RETURN VARCHAR2;
354:
355: FUNCTION is_fin_impact_enabled(p_ci_id IN pa_control_items.ci_id%TYPE,
356: p_project_id IN pa_projects_all.project_id%TYPE)
357: RETURN VARCHAR2;
358:
359: /* Returns the plan types into which a change order can be implemented along with other information */

Line 414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL

410: PROCEDURE GET_IMPL_DETAILS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan type
411: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
412: ,P_app_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE DEFAULT NULL -- Indicates whether the plan type passed is approved rev_plan_type or not. If the value is NULL the value will be derived
413: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
417: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
418: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version

Line 415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order

411: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
412: ,P_app_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE DEFAULT NULL -- Indicates whether the plan type passed is approved rev_plan_type or not. If the value is NULL the value will be derived
413: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
417: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
418: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version
419: ,p_targ_bv_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the target budget version. Bug 3745163

Line 434: FUNCTION is_user_status_implementable(p_status_code IN pa_control_items.status_code%TYPE)

430:
431: --This function returns either Y or N. If the user status code passed exists in pa_pt_co_impl_statuses, meaning
432: --that there exists a ci type whose change documents can be implemented/included into the working versions of a
433: --plan type, then Y is returned. N is returned otherwise
434: FUNCTION is_user_status_implementable(p_status_code IN pa_control_items.status_code%TYPE)
435: RETURN VARCHAR2 ;
436:
437: --This procedure will return the approved cost/rev current working version ids for a project.
438: --If there is only one version which is approved for both cost and revenue and the same version id will be

Line 455: p_ci_id IN pa_control_items.ci_id%TYPE,

451: --p_budget_version_id is the target version id with which comparision happens in the view fin impact page. If this
452: --is available its not required to fetch the approved cost/rev current working ids.
453: PROCEDURE get_dtls_for_view_fin_imp_pg
454: (p_project_id IN pa_projects_all.project_id%TYPE,
455: p_ci_id IN pa_control_items.ci_id%TYPE,
456: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
457: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 462: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895

458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
460: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
461: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
462: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
463: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
464: x_impact_in_mc_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
465: x_targ_version_type OUT NOCOPY pa_budget_Versions.version_type%TYPE, --File.Sql.39 bug 4440895
466: x_show_resources_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 472: x_ci_number OUT NOCOPY pa_control_items.ci_number%TYPE, --File.Sql.39 bug 4440895

468: x_report_cost_using OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
469: x_cost_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
470: x_rev_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
471: x_ci_type OUT NOCOPY pa_ci_types_vl.name%TYPE, --File.Sql.39 bug 4440895
472: x_ci_number OUT NOCOPY pa_control_items.ci_number%TYPE, --File.Sql.39 bug 4440895
473: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
474: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
475: x_return_status OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
476: