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

80: WHEN NO_DATA_FOUND THEN
81: x_baseline_funding_flag := 'N';
82: END;
83:
84: x_ci_type_class_code := Pa_Control_Items_Utils.GetCiTypeClassCode(p_ci_id);
85:
86: SELECT COUNT(*) INTO x_no_of_ci_plan_versions FROM pa_budget_Versions
87: WHERE project_id = p_project_id AND
88: nvl(ci_id,-1) = p_ci_id;

Line 119: FROM pa_ci_types_b typ,pa_control_items ci

115: -- typ.SUPP_COST_REG_FLAG,
116: decode(typ.DIR_REG_REV_COL_FLAG,'N','COST_ONLY','COST_AND_REV_SAME')
117: INTO
118: x_fp_pref_code
119: FROM pa_ci_types_b typ,pa_control_items ci
120: WHERE ci.ci_type_id = typ.ci_type_id
121: and ci.Project_Id = p_project_id
122: and ci.ci_id = p_ci_id
123: and typ.impact_budget_type_code in('DIRECT_COST_ENTRY');

Line 370: FROM pa_control_items paci, pa_ci_types_tl pacitl

366: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
367:
368: SELECT
369: pacitl.name into x_ci_type_name
370: FROM pa_control_items paci, pa_ci_types_tl pacitl
371: WHERE
372: paci.ci_id = p_ci_id
373: and paci.ci_type_id = pacitl.ci_type_id
374: and pacitl.language = userenv('lang');

Line 680: l_ci_number pa_control_items.ci_number%type;

676: l_debug_mode VARCHAR2(30);
677: l_token_v_type VARCHAR2(30);
678: l_res_resgr_mismatch_flag VARCHAR2(1) := 'N';
679: l_chg_doc_token varchar2(250);
680: l_ci_number pa_control_items.ci_number%type;
681: l_ci_type_name pa_ci_types_tl.short_name%type;
682: l_count number;
683: l_token_ci_id pa_control_items.ci_id%type;
684: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';

Line 683: l_token_ci_id pa_control_items.ci_id%type;

679: l_chg_doc_token varchar2(250);
680: l_ci_number pa_control_items.ci_number%type;
681: l_ci_type_name pa_ci_types_tl.short_name%type;
682: l_count number;
683: l_token_ci_id pa_control_items.ci_id%type;
684: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
685: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
686: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
687: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 690: l_src_ci_number pa_control_items.ci_number%TYPE;

686: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
687: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
688: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
689: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
690: l_src_ci_number pa_control_items.ci_number%TYPE;
691: l_module_name varchar2(30) := 'check is possible';
692:
693: -- Bug 5845142
694: l_s_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 793: FROM pa_control_items

789: IF p_calling_mode='INCLUDE' THEN
790:
791: SELECT ci_number
792: INTO l_src_ci_number
793: FROM pa_control_items
794: WHERE ci_id=l_s_ci_id;
795:
796: END IF;
797:

Line 1103: pa_control_items ci,

1099: l_chg_doc_token := null;
1100: begin
1101: select ci.ci_number,cit.short_name into
1102: l_ci_number,l_ci_type_name from
1103: pa_control_items ci,
1104: pa_ci_types_tl cit
1105: where ci.ci_id = l_token_ci_id and
1106: cit.ci_type_id = ci.ci_type_id and
1107: cit.language = userenv('LANG');

Line 2801: l_ci_number pa_control_items.ci_number%type;

2797: l_baseline_funding_Flag pa_projects_All.baseline_funding_flag%type;
2798: l_s_rev_bv_id pa_budget_versions.budget_version_id%type;
2799: l_count number;
2800: l_s_bv_fp_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2801: l_ci_number pa_control_items.ci_number%type;
2802: l_ci_type_name pa_ci_types_tl.short_name%type;
2803: l_s_bv_time_phased_code pa_proj_fp_options.revenue_time_phased_code%type;
2804: l_s_bv_resource_list_id pa_proj_fp_options.revenue_resource_list_id%type;
2805:

Line 2856: pa_control_items ci,

2852:
2853: begin
2854: select ci.ci_number,cit.short_name into
2855: l_ci_number,l_ci_type_name from
2856: pa_control_items ci,
2857: pa_ci_types_tl cit
2858: where ci.ci_id = p_s_ci_id and
2859: cit.ci_type_id = ci.ci_type_id and
2860: cit.language = userenv('LANG');

Line 3420: p_ci_id IN pa_control_items.ci_id%TYPE,

3416: --Bug 3550073. Included x_upd_cost_impact_allowed and x_upd_rev_impact_allowed
3417: PROCEDURE FP_CI_VALIDATE_UPDATE_IMPACT
3418: (
3419: p_project_id IN pa_budget_versions.project_id%TYPE,
3420: p_ci_id IN pa_control_items.ci_id%TYPE,
3421: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
3422: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
3423: x_upd_cost_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3424: x_upd_rev_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3447: (c_ci_id pa_control_items.ci_id%TYPE,

3443: l_merged_count NUMBER := 0;
3444: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
3445:
3446: CURSOR c_upd_impact_val_csr
3447: (c_ci_id pa_control_items.ci_id%TYPE,
3448: c_version_type pa_fp_merged_ctrl_items.version_type%TYPE)
3449: IS
3450: SELECT 'Y'
3451: FROM pa_fp_merged_ctrl_items

Line 4818: ,pa_control_items pci

4814: ,PBV.EQUIPMENT_QUANTITY AS EQUIPMENT_EFFORT
4815: ,PBV.TOTAL_PROJECT_RAW_COST AS RAW_COST
4816: ,PBV.TOTAL_PROJECT_BURDENED_COST AS BURDENED_COST
4817: FROM pa_budget_versions pbv
4818: ,pa_control_items pci
4819: ,pa_project_statuses pcs
4820: ,pa_ci_types_vl pct
4821: WHERE PBV.CI_ID = PCI.CI_ID
4822: AND PBV.PROJECT_ID = PCI.PROJECT_ID

Line 4882: ,pa_control_items pci

4878: ,PBV.EQUIPMENT_QUANTITY AS EQUIPMENT_EFFORT
4879: ,PBV.TOTAL_PROJECT_REVENUE AS REVENUE
4880: ,nvl(PBV.REV_PARTIALLY_IMPL_FLAG,'N') AS REV_PARTIALLY_IMPL_FLAG
4881: FROM pa_budget_versions pbv
4882: ,pa_control_items pci
4883: ,pa_project_statuses pcs
4884: ,pa_ci_types_vl pct
4885: WHERE PBV.CI_ID = PCI.CI_ID
4886: AND PBV.PROJECT_ID = PCI.PROJECT_ID

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

7655:
7656: /* FP.M- This function checks for the particular ci type, the Cost Impact or
7657: * Revenue Impact has been enabled for Financial implementation
7658: */
7659: FUNCTION is_fin_impact_enabled(p_ci_id IN pa_control_items.ci_id%TYPE,
7660: p_project_id IN pa_projects_all.project_id%TYPE)
7661: RETURN VARCHAR2
7662: IS
7663:

Line 7684: FROM pa_control_items

7680:
7681: BEGIN
7682: SELECT ci_type_id
7683: INTO l_ci_type_id
7684: FROM pa_control_items
7685: WHERE ci_id = p_ci_id
7686: AND project_id = p_project_id;
7687:
7688: SELECT cost_impact_flag, revenue_impact_flag

Line 7968: l_status_code pa_control_items.status_code%TYPE;

7964: l_cost_impact_impl_flag VARCHAR2(1);
7965: l_rev_impact_impl_flag VARCHAR2(1);
7966: l_partially_impl_flag VARCHAR2(1);
7967:
7968: l_status_code pa_control_items.status_code%TYPE;
7969: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7970:
7971: l_ci_version_type pa_budget_versions.version_type%TYPE;
7972:

Line 7969: l_ci_type_id pa_control_items.ci_type_id%TYPE;

7965: l_rev_impact_impl_flag VARCHAR2(1);
7966: l_partially_impl_flag VARCHAR2(1);
7967:
7968: l_status_code pa_control_items.status_code%TYPE;
7969: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7970:
7971: l_ci_version_type pa_budget_versions.version_type%TYPE;
7972:
7973: l_budget_version_id Pa_budget_versions.budget_version_id%TYPE;

Line 8206: FROM pa_control_items

8202: BEGIN
8203:
8204: SELECT ci_type_id,status_code
8205: INTO l_ci_type_id,l_status_code
8206: FROM pa_control_items
8207: WHERE ci_id=p_ci_id;
8208:
8209: EXCEPTION
8210: WHEN NO_DATA_FOUND THEN

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

8625: 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
8626: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
8627: ,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
8628: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
8629: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
8630: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
8631: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
8632: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
8633: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version

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

8626: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
8627: ,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
8628: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
8629: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
8630: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
8631: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
8632: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
8633: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version
8634: ,p_targ_bv_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the target budget version. Bug 3745163

Line 8694: l_ci_type_id pa_control_items.ci_type_id%TYPE;

8690: l_cost_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
8691: l_rev_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
8692: l_all_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
8693:
8694: l_ci_type_id pa_control_items.ci_type_id%TYPE;
8695:
8696: l_status_allows_cost_impl VARCHAR2(1);
8697: l_status_allows_rev_impl VARCHAR2(1);
8698:

Line 8708: l_status_code pa_control_items.status_code%TYPE;

8704: l_ci_cost_version_id Pa_budget_versions.budget_version_id%TYPE;
8705: l_ci_rev_version_id Pa_budget_versions.budget_version_id%TYPE;
8706: l_ci_all_version_id Pa_budget_versions.budget_version_id%TYPE;
8707:
8708: l_status_code pa_control_items.status_code%TYPE;
8709: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
8710:
8711: l_rev_impl_full VARCHAR2(1); -- Will indicate if revenue has been implemented in full or not
8712:

Line 8775: FROM pa_control_items

8771: IF p_ci_status IS NULL OR p_ci_type_id IS NULL THEN
8772: BEGIN
8773: SELECT status_code, ci_type_id
8774: INTO l_status_code, l_ci_type_id
8775: FROM pa_control_items
8776: WHERE ci_id=p_ci_id;
8777: EXCEPTION
8778: WHEN NO_DATA_FOUND THEN
8779: RAISE ;

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

9255: -- This function returns either Y or N. If the user status code passed exists in
9256: -- pa_pt_co_impl_statuses, meaning that there exists a ci type whose change
9257: -- documents can be implemented/included into the working versions of a
9258: -- plan type, then Y is returned. N is returned otherwise
9259: FUNCTION is_user_status_implementable(p_status_code IN pa_control_items.status_code%TYPE)
9260: RETURN VARCHAR2
9261: IS
9262: l_status_implementable VARCHAR2(1);
9263: BEGIN

Line 9287: p_ci_id IN pa_control_items.ci_id%TYPE,

9283: --p_budget_version_id is the target version id with which comparision happens in the view fin impact page. If this
9284: --is available its not required to fetch the approved cost/rev current working ids.
9285: PROCEDURE get_dtls_for_view_fin_imp_pg
9286: (p_project_id IN pa_projects_all.project_id%TYPE,
9287: p_ci_id IN pa_control_items.ci_id%TYPE,
9288: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
9289: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
9290: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
9291: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

9290: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
9291: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
9292: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9293: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9294: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
9295: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
9296: x_impact_in_mc_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9297: x_targ_version_type OUT NOCOPY pa_budget_Versions.version_type%TYPE, --File.Sql.39 bug 4440895
9298: x_show_resources_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

9300: x_report_cost_using OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9301: x_cost_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9302: x_rev_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9303: x_ci_type OUT NOCOPY pa_ci_types_vl.name%TYPE, --File.Sql.39 bug 4440895
9304: x_ci_number OUT NOCOPY pa_control_items.ci_number%TYPE, --File.Sql.39 bug 4440895
9305: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9306: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9307: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
9308: IS

Line 9421: FROM pa_control_items pci,

9417:
9418: --Get the CI status code
9419: SELECT pps.project_system_status_code
9420: INTO x_ci_status_code
9421: FROM pa_control_items pci,
9422: pa_project_statuses pps
9423: WHERE pci.ci_id=p_ci_id
9424: AND pps.project_status_code=pci.status_code;
9425:

Line 9636: FROM pa_control_items ci,pa_ci_types_vl ct

9632: --For bug 3957561
9633:
9634: SELECT ci.ci_number,ct.name
9635: INTO x_ci_number,x_ci_type
9636: FROM pa_control_items ci,pa_ci_types_vl ct
9637: WHERE ci_id=p_ci_id
9638: AND ci.ci_type_id=ct.ci_type_id;
9639:
9640: IF l_debug_mode = 'Y' THEN

Line 10003: WHERE CI_TYPE_ID = (SELECT CI_TYPE_ID FROM PA_CONTROL_ITEMS WHERE CI_ID = p_ci_id)

9999: INTO l_is_editplanned_enabled
10000: FROM DUAL
10001: WHERE EXISTS (SELECT 1
10002: FROM PA_CI_TYPES_V
10003: WHERE CI_TYPE_ID = (SELECT CI_TYPE_ID FROM PA_CONTROL_ITEMS WHERE CI_ID = p_ci_id)
10004: AND (IMPACT_BUDGET_TYPE_CODE = 'EDIT_PLANNED_AMOUNTS' OR
10005: /* Added OR contion Bug 13960686 */
10006: IMPACT_BUDGET_TYPE_CODE = 'DIRECT_COST_ENTRY' )
10007: );/* Changed the Query for E&C 12.1.3 */