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_VARCHAR2_1_TBL_TYPE

Line 591: x_merge_possible_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type,

587: p_project_id IN NUMBER,
588: p_source_fp_version_id_tbl IN SYSTEM.pa_num_tbl_type,
589: p_target_fp_version_id IN NUMBER,
590: p_calling_mode IN VARCHAR2,
591: x_merge_possible_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type,
592: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
593: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
594: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
595: )

Line 731: x_merge_possible_code_tbl:=SYSTEM.pa_varchar2_1_tbl_type();

727: AND pbv.budget_version_id= l_t_version_id;
728:
729: END IF;
730:
731: x_merge_possible_code_tbl:=SYSTEM.pa_varchar2_1_tbl_type();
732: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 3');
733: FOR i in p_source_fp_version_id_tbl.FIRST.. p_source_fp_version_id_tbl.LAST
734: LOOP
735: l_merge_possible_code := 'Y';

Line 3204: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

3200: l_msg_index_out NUMBER;
3201: l_return_status VARCHAR2(2000);
3202: l_no_of_ci_plan_versions NUMBER;
3203: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
3204: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3205:
3206: BEGIN
3207: x_msg_count := 0;
3208: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4421: l_appr_cost_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

4417: l_lookup_code_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4418: l_fin_plan_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4419: l_fin_plan_preference_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4420: l_rep_lab_from_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4421: l_appr_cost_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
4422: l_appr_rev_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
4423:
4424: l_set_cw_url_flag VARCHAR2(1) := 'Y';
4425: l_set_ob_url_flag VARCHAR2(1) := 'Y';

Line 4422: l_appr_rev_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

4418: l_fin_plan_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4419: l_fin_plan_preference_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4420: l_rep_lab_from_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4421: l_appr_cost_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
4422: l_appr_rev_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
4423:
4424: l_set_cw_url_flag VARCHAR2(1) := 'Y';
4425: l_set_ob_url_flag VARCHAR2(1) := 'Y';
4426: l_set_cb_url_flag VARCHAR2(1) := 'Y';

Line 7801: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895

7797: (P_ci_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE, -- Id of the Change Document
7798: P_project_id IN Pa_budget_versions.project_id%TYPE, -- Id of the Project
7799: X_pt_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for fin plan type ids --File.Sql.39 bug 4440895
7800: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
7801: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7802: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7803: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895
7804: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895
7805: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --File.Sql.39 bug 4440895

Line 7802: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895

7798: P_project_id IN Pa_budget_versions.project_id%TYPE, -- Id of the Project
7799: X_pt_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for fin plan type ids --File.Sql.39 bug 4440895
7800: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
7801: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7802: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7803: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895
7804: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895
7805: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --File.Sql.39 bug 4440895
7806: X_burd_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for burdened cost --File.Sql.39 bug 4440895

Line 7803: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895

7799: X_pt_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for fin plan type ids --File.Sql.39 bug 4440895
7800: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
7801: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7802: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7803: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895
7804: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895
7805: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --File.Sql.39 bug 4440895
7806: X_burd_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for burdened cost --File.Sql.39 bug 4440895
7807: X_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue --File.Sql.39 bug 4440895

Line 7804: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895

7800: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
7801: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7802: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7803: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895
7804: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895
7805: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --File.Sql.39 bug 4440895
7806: X_burd_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for burdened cost --File.Sql.39 bug 4440895
7807: X_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue --File.Sql.39 bug 4440895
7808: X_labor_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Cost --File.Sql.39 bug 4440895

Line 7819: X_select_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- The flag which indicates whether the select flag can be checked by default or not --File.Sql.39 bug 4440895

7815: x_approved_fin_pt_id OUT NOCOPY Pa_fin_plan_types_b.fin_plan_type_id%TYPE, -- Contains the ID of the approved plan type --File.Sql.39 bug 4440895
7816: X_cost_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for cost bv id --File.Sql.39 bug 4440895
7817: X_rev_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue bv id --File.Sql.39 bug 4440895
7818: X_all_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for all bv id --File.Sql.39 bug 4440895
7819: X_select_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- The flag which indicates whether the select flag can be checked by default or not --File.Sql.39 bug 4440895
7820: X_agreement_num OUT NOCOPY Pa_agreements_all.agreement_num%TYPE, -- Agreement number of the agreement --File.Sql.39 bug 4440895
7821: X_partially_impl_flag OUT NOCOPY VARCHAR2, -- A flag that indicates whether a partially implemented CO exists for the plan type or not. Possible values are Y/N --File.Sql.39 bug 4440895
7822: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
7823: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895

Line 7829: x_disable_baseline_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Disable Baseline Checkbox Flag -- 3735309 --File.Sql.39 bug 4440895

7825: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895
7826: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895
7827: x_rem_equip_qty OUT NOCOPY pa_budget_versions.equipment_quantity%TYPE, --File.Sql.39 bug 4440895
7828: X_autobaseline_project OUT NOCOPY VARCHAR2, -- This flag will be set to Y if the project is enabled for autobaseline --File.Sql.39 bug 4440895
7829: x_disable_baseline_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Disable Baseline Checkbox Flag -- 3735309 --File.Sql.39 bug 4440895
7830: x_return_status OUT NOCOPY VARCHAR2, -- Indicates the exit status of the API --File.Sql.39 bug 4440895
7831: x_msg_data OUT NOCOPY VARCHAR2, -- Indicates the error occurred --File.Sql.39 bug 4440895
7832: X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
7833: IS

Line 7896: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

7892: l_submit_cost_appr VARCHAR2(1);
7893: l_submit_revenue_appr VARCHAR2(1);
7894: l_submit_cost_forecast VARCHAR2(1);
7895: l_submit_revenue_forecast VARCHAR2(1);
7896: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7897: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7898: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7899: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7900: l_submit_cost_check VARCHAR2(1);

Line 7897: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

7893: l_submit_revenue_appr VARCHAR2(1);
7894: l_submit_cost_forecast VARCHAR2(1);
7895: l_submit_revenue_forecast VARCHAR2(1);
7896: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7897: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7898: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7899: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7900: l_submit_cost_check VARCHAR2(1);
7901: l_submit_revenue_check VARCHAR2(1);

Line 7898: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

7894: l_submit_cost_forecast VARCHAR2(1);
7895: l_submit_revenue_forecast VARCHAR2(1);
7896: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7897: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7898: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7899: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7900: l_submit_cost_check VARCHAR2(1);
7901: l_submit_revenue_check VARCHAR2(1);
7902:

Line 7899: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

7895: l_submit_revenue_forecast VARCHAR2(1);
7896: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7897: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7898: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7899: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7900: l_submit_cost_check VARCHAR2(1);
7901: l_submit_revenue_check VARCHAR2(1);
7902:
7903: BEGIN

Line 7919: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();

7915:
7916: -- initialising all the output tables
7917: X_pt_id_tbl := SYSTEM.pa_num_tbl_type();
7918: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();
7919: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7920: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7921: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7922: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7923: X_raw_cost_tbl := SYSTEM.pa_num_tbl_type();

Line 7920: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();

7916: -- initialising all the output tables
7917: X_pt_id_tbl := SYSTEM.pa_num_tbl_type();
7918: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();
7919: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7920: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7921: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7922: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7923: X_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
7924: X_burd_cost_tbl := SYSTEM.pa_num_tbl_type();

Line 7921: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();

7917: X_pt_id_tbl := SYSTEM.pa_num_tbl_type();
7918: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();
7919: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7920: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7921: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7922: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7923: X_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
7924: X_burd_cost_tbl := SYSTEM.pa_num_tbl_type();
7925: X_revenue_tbl := SYSTEM.pa_num_tbl_type();

Line 7922: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();

7918: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();
7919: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7920: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7921: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7922: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7923: X_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
7924: X_burd_cost_tbl := SYSTEM.pa_num_tbl_type();
7925: X_revenue_tbl := SYSTEM.pa_num_tbl_type();
7926: X_labor_hrs_c_tbl := SYSTEM.pa_num_tbl_type();

Line 7935: X_select_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();

7931: X_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7932: X_cost_bv_id_tbl := SYSTEM.pa_num_tbl_type();
7933: X_rev_bv_id_tbl := SYSTEM.pa_num_tbl_type();
7934: X_all_bv_id_tbl := SYSTEM.pa_num_tbl_type();
7935: X_select_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7936: X_margin_derived_code_tbl := SYSTEM.pa_varchar2_30_tbl_type(); -- Bug 3734840
7937: x_disable_baseline_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type(); -- Bug 3735309
7938: -- Check for business rules violations
7939:

Line 7937: x_disable_baseline_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type(); -- Bug 3735309

7933: X_rev_bv_id_tbl := SYSTEM.pa_num_tbl_type();
7934: X_all_bv_id_tbl := SYSTEM.pa_num_tbl_type();
7935: X_select_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7936: X_margin_derived_code_tbl := SYSTEM.pa_varchar2_30_tbl_type(); -- Bug 3734840
7937: x_disable_baseline_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type(); -- Bug 3735309
7938: -- Check for business rules violations
7939:
7940: IF l_debug_mode = 'Y' THEN
7941: pa_debug.g_err_stage:='Validating input parameters';