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 77: x_ci_type_class_code := Pa_Control_Items_Utils.GetCiTypeClassCode(p_ci_id);

73: WHEN NO_DATA_FOUND THEN
74: x_baseline_funding_flag := 'N';
75: END;
76:
77: x_ci_type_class_code := Pa_Control_Items_Utils.GetCiTypeClassCode(p_ci_id);
78:
79: SELECT COUNT(*) INTO x_no_of_ci_plan_versions FROM pa_budget_Versions
80: WHERE project_id = p_project_id AND
81: nvl(ci_id,-1) = p_ci_id;

Line 346: FROM pa_control_items paci, pa_ci_types_tl pacitl

342: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
343:
344: SELECT
345: pacitl.name into x_ci_type_name
346: FROM pa_control_items paci, pa_ci_types_tl pacitl
347: WHERE
348: paci.ci_id = p_ci_id
349: and paci.ci_type_id = pacitl.ci_type_id
350: and pacitl.language = userenv('lang');

Line 656: l_ci_number pa_control_items.ci_number%type;

652: l_debug_mode VARCHAR2(30);
653: l_token_v_type VARCHAR2(30);
654: l_res_resgr_mismatch_flag VARCHAR2(1) := 'N';
655: l_chg_doc_token varchar2(250);
656: l_ci_number pa_control_items.ci_number%type;
657: l_ci_type_name pa_ci_types_tl.short_name%type;
658: l_count number;
659: l_token_ci_id pa_control_items.ci_id%type;
660: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';

Line 659: l_token_ci_id pa_control_items.ci_id%type;

655: l_chg_doc_token varchar2(250);
656: l_ci_number pa_control_items.ci_number%type;
657: l_ci_type_name pa_ci_types_tl.short_name%type;
658: l_count number;
659: l_token_ci_id pa_control_items.ci_id%type;
660: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
661: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
663: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 666: l_src_ci_number pa_control_items.ci_number%TYPE;

662: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
663: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
664: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
666: l_src_ci_number pa_control_items.ci_number%TYPE;
667: l_module_name varchar2(30) := 'check is possible';
668: BEGIN
669: IF P_PA_DEBUG_MODE = 'Y' THEN
670: pa_debug.init_err_stack('PAFPCIUB.FP_CI_CHECK_MERGE_POSSIBLE');

Line 764: FROM pa_control_items

760: IF p_calling_mode='INCLUDE' THEN
761:
762: SELECT ci_number
763: INTO l_src_ci_number
764: FROM pa_control_items
765: WHERE ci_id=l_s_ci_id;
766:
767: END IF;
768:

Line 1069: pa_control_items ci,

1065: l_chg_doc_token := null;
1066: begin
1067: select ci.ci_number,cit.short_name into
1068: l_ci_number,l_ci_type_name from
1069: pa_control_items ci,
1070: pa_ci_types_tl cit
1071: where ci.ci_id = l_token_ci_id and
1072: cit.ci_type_id = ci.ci_type_id and
1073: cit.language = userenv('LANG');

Line 2752: l_ci_number pa_control_items.ci_number%type;

2748: l_baseline_funding_Flag pa_projects_All.baseline_funding_flag%type;
2749: l_s_rev_bv_id pa_budget_versions.budget_version_id%type;
2750: l_count number;
2751: l_s_bv_fp_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2752: l_ci_number pa_control_items.ci_number%type;
2753: l_ci_type_name pa_ci_types_tl.short_name%type;
2754: l_s_bv_time_phased_code pa_proj_fp_options.revenue_time_phased_code%type;
2755: l_s_bv_resource_list_id pa_proj_fp_options.revenue_resource_list_id%type;
2756:

Line 2807: pa_control_items ci,

2803:
2804: begin
2805: select ci.ci_number,cit.short_name into
2806: l_ci_number,l_ci_type_name from
2807: pa_control_items ci,
2808: pa_ci_types_tl cit
2809: where ci.ci_id = p_s_ci_id and
2810: cit.ci_type_id = ci.ci_type_id and
2811: cit.language = userenv('LANG');

Line 3371: p_ci_id IN pa_control_items.ci_id%TYPE,

3367: --Bug 3550073. Included x_upd_cost_impact_allowed and x_upd_rev_impact_allowed
3368: PROCEDURE FP_CI_VALIDATE_UPDATE_IMPACT
3369: (
3370: p_project_id IN pa_budget_versions.project_id%TYPE,
3371: p_ci_id IN pa_control_items.ci_id%TYPE,
3372: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
3373: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
3374: x_upd_cost_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3375: x_upd_rev_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3398: (c_ci_id pa_control_items.ci_id%TYPE,

3394: l_merged_count NUMBER := 0;
3395: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
3396:
3397: CURSOR c_upd_impact_val_csr
3398: (c_ci_id pa_control_items.ci_id%TYPE,
3399: c_version_type pa_fp_merged_ctrl_items.version_type%TYPE)
3400: IS
3401: SELECT 'Y'
3402: FROM pa_fp_merged_ctrl_items

Line 4762: ,pa_control_items pci

4758: ,PBV.EQUIPMENT_QUANTITY AS EQUIPMENT_EFFORT
4759: ,PBV.TOTAL_PROJECT_RAW_COST AS RAW_COST
4760: ,PBV.TOTAL_PROJECT_BURDENED_COST AS BURDENED_COST
4761: FROM pa_budget_versions pbv
4762: ,pa_control_items pci
4763: ,pa_project_statuses pcs
4764: ,pa_ci_types_vl pct
4765: WHERE PBV.CI_ID = PCI.CI_ID
4766: AND PBV.PROJECT_ID = PCI.PROJECT_ID

Line 4826: ,pa_control_items pci

4822: ,PBV.EQUIPMENT_QUANTITY AS EQUIPMENT_EFFORT
4823: ,PBV.TOTAL_PROJECT_REVENUE AS REVENUE
4824: ,nvl(PBV.REV_PARTIALLY_IMPL_FLAG,'N') AS REV_PARTIALLY_IMPL_FLAG
4825: FROM pa_budget_versions pbv
4826: ,pa_control_items pci
4827: ,pa_project_statuses pcs
4828: ,pa_ci_types_vl pct
4829: WHERE PBV.CI_ID = PCI.CI_ID
4830: AND PBV.PROJECT_ID = PCI.PROJECT_ID

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

7583:
7584: /* FP.M- This function checks for the particular ci type, the Cost Impact or
7585: * Revenue Impact has been enabled for Financial implementation
7586: */
7587: FUNCTION is_fin_impact_enabled(p_ci_id IN pa_control_items.ci_id%TYPE,
7588: p_project_id IN pa_projects_all.project_id%TYPE)
7589: RETURN VARCHAR2
7590: IS
7591:

Line 7612: FROM pa_control_items

7608:
7609: BEGIN
7610: SELECT ci_type_id
7611: INTO l_ci_type_id
7612: FROM pa_control_items
7613: WHERE ci_id = p_ci_id
7614: AND project_id = p_project_id;
7615:
7616: SELECT cost_impact_flag, revenue_impact_flag

Line 7877: l_status_code pa_control_items.status_code%TYPE;

7873: l_cost_impact_impl_flag VARCHAR2(1);
7874: l_rev_impact_impl_flag VARCHAR2(1);
7875: l_partially_impl_flag VARCHAR2(1);
7876:
7877: l_status_code pa_control_items.status_code%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879:
7880: l_ci_version_type pa_budget_versions.version_type%TYPE;
7881:

Line 7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;

7874: l_rev_impact_impl_flag VARCHAR2(1);
7875: l_partially_impl_flag VARCHAR2(1);
7876:
7877: l_status_code pa_control_items.status_code%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879:
7880: l_ci_version_type pa_budget_versions.version_type%TYPE;
7881:
7882: l_budget_version_id Pa_budget_versions.budget_version_id%TYPE;

Line 8111: FROM pa_control_items

8107: BEGIN
8108:
8109: SELECT ci_type_id,status_code
8110: INTO l_ci_type_id,l_status_code
8111: FROM pa_control_items
8112: WHERE ci_id=p_ci_id;
8113:
8114: EXCEPTION
8115: WHEN NO_DATA_FOUND THEN

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

8493: 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
8494: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
8495: ,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
8496: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
8497: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
8498: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
8499: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
8500: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
8501: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version

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

8494: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
8495: ,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
8496: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
8497: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
8498: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
8499: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
8500: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
8501: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version
8502: ,p_targ_bv_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the target budget version. Bug 3745163

Line 8562: l_ci_type_id pa_control_items.ci_type_id%TYPE;

8558: l_cost_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
8559: l_rev_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
8560: l_all_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
8561:
8562: l_ci_type_id pa_control_items.ci_type_id%TYPE;
8563:
8564: l_status_allows_cost_impl VARCHAR2(1);
8565: l_status_allows_rev_impl VARCHAR2(1);
8566:

Line 8576: l_status_code pa_control_items.status_code%TYPE;

8572: l_ci_cost_version_id Pa_budget_versions.budget_version_id%TYPE;
8573: l_ci_rev_version_id Pa_budget_versions.budget_version_id%TYPE;
8574: l_ci_all_version_id Pa_budget_versions.budget_version_id%TYPE;
8575:
8576: l_status_code pa_control_items.status_code%TYPE;
8577: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
8578:
8579: l_rev_impl_full VARCHAR2(1); -- Will indicate if revenue has been implemented in full or not
8580:

Line 8638: FROM pa_control_items

8634: IF p_ci_status IS NULL OR p_ci_type_id IS NULL THEN
8635: BEGIN
8636: SELECT status_code, ci_type_id
8637: INTO l_status_code, l_ci_type_id
8638: FROM pa_control_items
8639: WHERE ci_id=p_ci_id;
8640: EXCEPTION
8641: WHEN NO_DATA_FOUND THEN
8642: RAISE ;

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

9097: -- This function returns either Y or N. If the user status code passed exists in
9098: -- pa_pt_co_impl_statuses, meaning that there exists a ci type whose change
9099: -- documents can be implemented/included into the working versions of a
9100: -- plan type, then Y is returned. N is returned otherwise
9101: FUNCTION is_user_status_implementable(p_status_code IN pa_control_items.status_code%TYPE)
9102: RETURN VARCHAR2
9103: IS
9104: l_status_implementable VARCHAR2(1);
9105: BEGIN

Line 9129: p_ci_id IN pa_control_items.ci_id%TYPE,

9125: --p_budget_version_id is the target version id with which comparision happens in the view fin impact page. If this
9126: --is available its not required to fetch the approved cost/rev current working ids.
9127: PROCEDURE get_dtls_for_view_fin_imp_pg
9128: (p_project_id IN pa_projects_all.project_id%TYPE,
9129: p_ci_id IN pa_control_items.ci_id%TYPE,
9130: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
9131: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
9132: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
9133: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

9132: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
9133: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
9134: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9135: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9136: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
9137: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
9138: x_impact_in_mc_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9139: x_targ_version_type OUT NOCOPY pa_budget_Versions.version_type%TYPE, --File.Sql.39 bug 4440895
9140: x_show_resources_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

9142: x_report_cost_using OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9143: x_cost_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9144: x_rev_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9145: x_ci_type OUT NOCOPY pa_ci_types_vl.name%TYPE, --File.Sql.39 bug 4440895
9146: x_ci_number OUT NOCOPY pa_control_items.ci_number%TYPE, --File.Sql.39 bug 4440895
9147: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9148: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9149: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
9150: IS

Line 9263: FROM pa_control_items pci,

9259:
9260: --Get the CI status code
9261: SELECT pps.project_system_status_code
9262: INTO x_ci_status_code
9263: FROM pa_control_items pci,
9264: pa_project_statuses pps
9265: WHERE pci.ci_id=p_ci_id
9266: AND pps.project_status_code=pci.status_code;
9267:

Line 9478: FROM pa_control_items ci,pa_ci_types_vl ct

9474: --For bug 3957561
9475:
9476: SELECT ci.ci_number,ct.name
9477: INTO x_ci_number,x_ci_type
9478: FROM pa_control_items ci,pa_ci_types_vl ct
9479: WHERE ci_id=p_ci_id
9480: AND ci.ci_type_id=ct.ci_type_id;
9481:
9482: IF l_debug_mode = 'Y' THEN