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 615: x_merge_possible_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type,

611: p_project_id IN NUMBER,
612: p_source_fp_version_id_tbl IN SYSTEM.pa_num_tbl_type,
613: p_target_fp_version_id IN NUMBER,
614: p_calling_mode IN VARCHAR2,
615: x_merge_possible_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type,
616: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
617: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
618: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
619: )

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

756: AND pbv.budget_version_id= l_t_version_id;
757:
758: END IF;
759:
760: x_merge_possible_code_tbl:=SYSTEM.pa_varchar2_1_tbl_type();
761: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 3');
762: FOR i in p_source_fp_version_id_tbl.FIRST.. p_source_fp_version_id_tbl.LAST
763: LOOP
764: l_merge_possible_code := 'Y';

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

3249: l_msg_index_out NUMBER;
3250: l_return_status VARCHAR2(2000);
3251: l_no_of_ci_plan_versions NUMBER;
3252: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
3253: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3254:
3255: BEGIN
3256: x_msg_count := 0;
3257: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4466: l_lookup_code_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4467: l_fin_plan_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4468: l_fin_plan_preference_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4469: l_rep_lab_from_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4470: l_appr_cost_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
4471: l_appr_rev_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
4472:
4473: l_set_cw_url_flag VARCHAR2(1) := 'Y';
4474: l_set_ob_url_flag VARCHAR2(1) := 'Y';

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

4467: l_fin_plan_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4468: l_fin_plan_preference_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4469: l_rep_lab_from_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4470: l_appr_cost_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
4471: l_appr_rev_plan_type_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
4472:
4473: l_set_cw_url_flag VARCHAR2(1) := 'Y';
4474: l_set_ob_url_flag VARCHAR2(1) := 'Y';
4475: l_set_cb_url_flag VARCHAR2(1) := 'Y';

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

7887: (P_ci_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE, -- Id of the Change Document
7888: P_project_id IN Pa_budget_versions.project_id%TYPE, -- Id of the Project
7889: X_pt_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for fin plan type ids --File.Sql.39 bug 4440895
7890: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
7891: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7892: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7893: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895
7894: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895
7895: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --File.Sql.39 bug 4440895

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

7888: P_project_id IN Pa_budget_versions.project_id%TYPE, -- Id of the Project
7889: X_pt_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for fin plan type ids --File.Sql.39 bug 4440895
7890: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
7891: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7892: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7893: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895
7894: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895
7895: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --File.Sql.39 bug 4440895
7896: X_burd_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for burdened cost --File.Sql.39 bug 4440895

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

7889: X_pt_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for fin plan type ids --File.Sql.39 bug 4440895
7890: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
7891: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7892: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7893: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895
7894: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895
7895: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --File.Sql.39 bug 4440895
7896: X_burd_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for burdened cost --File.Sql.39 bug 4440895
7897: X_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue --File.Sql.39 bug 4440895

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

7890: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
7891: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7892: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
7893: X_cost_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Cost Flag --File.Sql.39 bug 4440895
7894: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895
7895: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --File.Sql.39 bug 4440895
7896: X_burd_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for burdened cost --File.Sql.39 bug 4440895
7897: X_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue --File.Sql.39 bug 4440895
7898: X_labor_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Cost --File.Sql.39 bug 4440895

Line 7909: 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

7905: 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
7906: X_cost_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for cost bv id --File.Sql.39 bug 4440895
7907: X_rev_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue bv id --File.Sql.39 bug 4440895
7908: X_all_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for all bv id --File.Sql.39 bug 4440895
7909: 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
7910: X_agreement_num OUT NOCOPY Pa_agreements_all.agreement_num%TYPE, -- Agreement number of the agreement --File.Sql.39 bug 4440895
7911: 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
7912: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
7913: 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 7919: 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

7915: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895
7916: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895
7917: x_rem_equip_qty OUT NOCOPY pa_budget_versions.equipment_quantity%TYPE, --File.Sql.39 bug 4440895
7918: 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
7919: 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
7920: x_return_status OUT NOCOPY VARCHAR2, -- Indicates the exit status of the API --File.Sql.39 bug 4440895
7921: x_msg_data OUT NOCOPY VARCHAR2, -- Indicates the error occurred --File.Sql.39 bug 4440895
7922: X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
7923: IS

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

7983: l_submit_cost_appr VARCHAR2(1);
7984: l_submit_revenue_appr VARCHAR2(1);
7985: l_submit_cost_forecast VARCHAR2(1);
7986: l_submit_revenue_forecast VARCHAR2(1);
7987: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7988: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7989: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7990: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7991: l_submit_cost_check VARCHAR2(1);

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

7984: l_submit_revenue_appr VARCHAR2(1);
7985: l_submit_cost_forecast VARCHAR2(1);
7986: l_submit_revenue_forecast VARCHAR2(1);
7987: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7988: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7989: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7990: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7991: l_submit_cost_check VARCHAR2(1);
7992: l_submit_revenue_check VARCHAR2(1);

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

7985: l_submit_cost_forecast VARCHAR2(1);
7986: l_submit_revenue_forecast VARCHAR2(1);
7987: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7988: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7989: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7990: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7991: l_submit_cost_check VARCHAR2(1);
7992: l_submit_revenue_check VARCHAR2(1);
7993:

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

7986: l_submit_revenue_forecast VARCHAR2(1);
7987: l_render_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7988: l_render_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7989: l_disable_impl_cost_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7990: l_disable_impl_revenue_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
7991: l_submit_cost_check VARCHAR2(1);
7992: l_submit_revenue_check VARCHAR2(1);
7993:
7994: -- Bug 11708214

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

8010:
8011: -- initialising all the output tables
8012: X_pt_id_tbl := SYSTEM.pa_num_tbl_type();
8013: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();
8014: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8015: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8016: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8017: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8018: X_raw_cost_tbl := SYSTEM.pa_num_tbl_type();

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

8011: -- initialising all the output tables
8012: X_pt_id_tbl := SYSTEM.pa_num_tbl_type();
8013: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();
8014: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8015: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8016: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8017: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8018: X_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
8019: X_burd_cost_tbl := SYSTEM.pa_num_tbl_type();

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

8012: X_pt_id_tbl := SYSTEM.pa_num_tbl_type();
8013: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();
8014: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8015: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8016: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8017: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8018: X_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
8019: X_burd_cost_tbl := SYSTEM.pa_num_tbl_type();
8020: X_revenue_tbl := SYSTEM.pa_num_tbl_type();

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

8013: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();
8014: x_cost_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8015: x_rev_impact_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8016: X_cost_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8017: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8018: X_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
8019: X_burd_cost_tbl := SYSTEM.pa_num_tbl_type();
8020: X_revenue_tbl := SYSTEM.pa_num_tbl_type();
8021: X_labor_hrs_c_tbl := SYSTEM.pa_num_tbl_type();

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

8026: X_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
8027: X_cost_bv_id_tbl := SYSTEM.pa_num_tbl_type();
8028: X_rev_bv_id_tbl := SYSTEM.pa_num_tbl_type();
8029: X_all_bv_id_tbl := SYSTEM.pa_num_tbl_type();
8030: X_select_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8031: X_margin_derived_code_tbl := SYSTEM.pa_varchar2_30_tbl_type(); -- Bug 3734840
8032: x_disable_baseline_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type(); -- Bug 3735309
8033: -- Check for business rules violations
8034:

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

8028: X_rev_bv_id_tbl := SYSTEM.pa_num_tbl_type();
8029: X_all_bv_id_tbl := SYSTEM.pa_num_tbl_type();
8030: X_select_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
8031: X_margin_derived_code_tbl := SYSTEM.pa_varchar2_30_tbl_type(); -- Bug 3734840
8032: x_disable_baseline_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type(); -- Bug 3735309
8033: -- Check for business rules violations
8034:
8035: IF l_debug_mode = 'Y' THEN
8036: pa_debug.g_err_stage:='Validating input parameters';