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_PROJECTS_ALL

Line 8: PROCEDURE Get_Fin_Plan_Dtls(p_project_id IN Pa_Projects_All.Project_Id%TYPE,

4: --Merge exception
5: RAISE_MERGE_ERROR EXCEPTION;
6: PRAGMA EXCEPTION_INIT(RAISE_MERGE_ERROR, -501);
7:
8: PROCEDURE Get_Fin_Plan_Dtls(p_project_id IN Pa_Projects_All.Project_Id%TYPE,
9: p_ci_id IN NUMBER,
10: x_fin_plan_type_id_cost OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
11: x_fin_plan_type_id_rev OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
12: x_fin_plan_type_id_all OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 146: p_project_id IN pa_projects_all.project_id%TYPE,

142: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
143: ) ;
144:
145: FUNCTION GET_FUNINDG_AMOUNT(
146: p_project_id IN pa_projects_all.project_id%TYPE,
147: p_agreement_id IN pa_agreements_all.agreement_id%TYPE)
148: RETURN NUMBER;
149:
150: PROCEDURE CHK_APRV_CUR_WORKING_BV_EXISTS

Line 151: ( p_project_id IN pa_projects_all.project_id%TYPE

147: p_agreement_id IN pa_agreements_all.agreement_id%TYPE)
148: RETURN NUMBER;
149:
150: PROCEDURE CHK_APRV_CUR_WORKING_BV_EXISTS
151: ( p_project_id IN pa_projects_all.project_id%TYPE
152: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
153: ,p_version_type IN pa_budget_versions.version_type%TYPE
154: ,x_cur_work_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 356: p_project_id IN pa_projects_all.project_id%TYPE)

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 */
360: -- Added New Params for Quantity in GET_PLAN_TYPES_FOR_IMPL - Bug 3902176

Line 442: (p_project_id IN pa_projects_all.project_id%TYPE,

438: --If there is only one version which is approved for both cost and revenue and the same version id will be
439: --populated in both x_app_cost_cw_ver_id and x_app_rev_cw_ver_id
440: --If the current working versions do not exist then null will be returned
441: PROCEDURE get_app_cw_ver_ids_for_proj
442: (p_project_id IN pa_projects_all.project_id%TYPE,
443: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
444: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
445: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
446: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 454: (p_project_id IN pa_projects_all.project_id%TYPE,

450: --that page
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,

Line 463: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895

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
467: x_plan_class_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 480: FUNCTION get_impl_agr_revenue (p_project_id IN pa_projects_all.project_id%TYPE,

476:
477: /* Bug 3731948- New Function to return the CO amount already implemented
478: * for REVENUE implementation in agreement currency
479: */
480: FUNCTION get_impl_agr_revenue (p_project_id IN pa_projects_all.project_id%TYPE,
481: p_ci_id IN pa_fp_merged_ctrl_items.ci_id%TYPE)
482: RETURN NUMBER;
483:
484: /* Function returns 'Y' if the change order has been implemented/included into ANY budget version. */

Line 492: p_project_id IN pa_projects_all.project_id%TYPE

488: /* This API returns the txn_currency_code and the ci version id of the budget lines of a REVENUE or ALL ci version, if lines exist. Else it returns NULL
489: All the lines of a revenue change order version will be in a single currency
490: */
491: PROCEDURE get_txn_curr_code_of_ci_ver(
492: p_project_id IN pa_projects_all.project_id%TYPE
493: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
494: ,x_txn_currency_code OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
495: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
496: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895