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_NUM_TBL_TYPE

Line 612: p_source_fp_version_id_tbl IN SYSTEM.pa_num_tbl_type,

608: ********************************************************************/
609: PROCEDURE FP_CI_CHECK_MERGE_POSSIBLE
610: (
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

Line 3240: l_source_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

3236: l_curr_work_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
3237: l_attr_same_flag VARCHAR2(1);
3238:
3239: --Added by Xin Liu. For enhancement.
3240: l_source_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3241:
3242: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
3243: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
3244: --Done by Xin Liu for enhancement

Line 3339: l_source_id_tbl:= SYSTEM.pa_num_tbl_type();

3335: --Added by Xin Liu. For enhancement.
3336:
3337: l_source_version_id := l_ci_version_id_tbl(i);
3338: l_source_id_tbl.DELETE;
3339: l_source_id_tbl:= SYSTEM.pa_num_tbl_type();
3340: l_source_id_tbl.extend(1);
3341: l_source_id_tbl(1) := l_source_version_id;
3342: l_target_version_id := l_curr_work_version_id;
3343:

Line 4418: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

4414: ,x_context OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4415: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
4416: ,x_url_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE --File.Sql.39 bug 4440895
4417: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895
4418: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4419: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4420: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4421: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4422: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 4419: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

4415: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
4416: ,x_url_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE --File.Sql.39 bug 4440895
4417: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895
4418: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4419: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4420: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4421: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4422: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4423: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 4420: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

4416: ,x_url_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE --File.Sql.39 bug 4440895
4417: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895
4418: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4419: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4420: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4421: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4422: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4423: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4424: ,x_project_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4421: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

4417: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895
4418: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4419: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4420: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4421: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4422: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4423: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4424: ,x_project_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4425: ,x_report_labor_hrs_code OUT NOCOPY VARCHAR2 /* Bug 4038253 */ --File.Sql.39 bug 4440895

Line 4422: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

4418: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4419: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4420: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4421: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4422: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4423: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4424: ,x_project_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4425: ,x_report_labor_hrs_code OUT NOCOPY VARCHAR2 /* Bug 4038253 */ --File.Sql.39 bug 4440895
4426: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4423: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

4419: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4420: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4421: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4422: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4423: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4424: ,x_project_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4425: ,x_report_labor_hrs_code OUT NOCOPY VARCHAR2 /* Bug 4038253 */ --File.Sql.39 bug 4440895
4426: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4427: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4466: l_lookup_code_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

4462: l_cw_equipment_quantity PA_BUDGET_VERSIONS.EQUIPMENT_QUANTITY%TYPE;
4463: l_cw_cost PA_BUDGET_VERSIONS.RAW_COST%TYPE;
4464: l_cw_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE;
4465:
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();

Line 4467: l_fin_plan_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

4463: l_cw_cost PA_BUDGET_VERSIONS.RAW_COST%TYPE;
4464: l_cw_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE;
4465:
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();

Line 4487: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

4483: l_pa_cb_cost_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
4484: l_pa_cb_revenue_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
4485: l_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
4486: l_version_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4487: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4488: l_next VARCHAR2(30);
4489: l_context VARCHAR2(30);
4490:
4491: l_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

Line 5011: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();

5007: END IF;
5008: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
5009: x_url_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5010: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5011: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
5012: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
5013: x_cost_tbl := SYSTEM.pa_num_tbl_type();
5014: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
5015: x_margin_tbl := SYSTEM.pa_num_tbl_type();

Line 5012: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();

5008: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
5009: x_url_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5010: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5011: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
5012: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
5013: x_cost_tbl := SYSTEM.pa_num_tbl_type();
5014: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
5015: x_margin_tbl := SYSTEM.pa_num_tbl_type();
5016: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

Line 5013: x_cost_tbl := SYSTEM.pa_num_tbl_type();

5009: x_url_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5010: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5011: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
5012: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
5013: x_cost_tbl := SYSTEM.pa_num_tbl_type();
5014: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
5015: x_margin_tbl := SYSTEM.pa_num_tbl_type();
5016: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
5017:

Line 5014: x_revenue_tbl := SYSTEM.pa_num_tbl_type();

5010: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5011: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
5012: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
5013: x_cost_tbl := SYSTEM.pa_num_tbl_type();
5014: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
5015: x_margin_tbl := SYSTEM.pa_num_tbl_type();
5016: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
5017:
5018: ----------------------------------------------------

Line 5015: x_margin_tbl := SYSTEM.pa_num_tbl_type();

5011: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
5012: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
5013: x_cost_tbl := SYSTEM.pa_num_tbl_type();
5014: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
5015: x_margin_tbl := SYSTEM.pa_num_tbl_type();
5016: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
5017:
5018: ----------------------------------------------------
5019: -- Derive Value of x_context

Line 5016: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

5012: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
5013: x_cost_tbl := SYSTEM.pa_num_tbl_type();
5014: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
5015: x_margin_tbl := SYSTEM.pa_num_tbl_type();
5016: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
5017:
5018: ----------------------------------------------------
5019: -- Derive Value of x_context
5020: ----------------------------------------------------

Line 7048: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

7044: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7045: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
7046: ,p_version_type IN pa_budget_versions.version_type%TYPE
7047: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
7048: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7049: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7050: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7051: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7052: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 7049: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

7045: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
7046: ,p_version_type IN pa_budget_versions.version_type%TYPE
7047: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
7048: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7049: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7050: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7051: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7052: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7053: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 7050: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

7046: ,p_version_type IN pa_budget_versions.version_type%TYPE
7047: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
7048: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7049: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7050: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7051: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7052: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7053: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7054: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7051: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

7047: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
7048: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7049: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7050: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7051: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7052: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7053: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7054: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7055: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7052: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

7048: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7049: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7050: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7051: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7052: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7053: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7054: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7055: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7056: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7053: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

7049: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7050: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7051: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7052: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7053: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
7054: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7055: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7056: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7057: ) IS

Line 7076: l_lookup_code_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

7072: l_labor_quantity PA_BUDGET_VERSIONS.LABOR_QUANTITY%TYPE;
7073: l_equipment_quantity PA_BUDGET_VERSIONS.EQUIPMENT_QUANTITY%TYPE;
7074: l_cost PA_BUDGET_VERSIONS.RAW_COST%TYPE;
7075: l_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE;
7076: l_lookup_code_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7077: l_assigned_flag VARCHAR2(1) := 'N';
7078: l_module_name VARCHAR2(30) := 'ctrl_itm_utls.get_not_incl';
7079:
7080:

Line 7278: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();

7274: pa_debug.g_err_stage:='Initialising all tables to empty tables.';
7275: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
7276: END IF;
7277: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
7278: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7279: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7280: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7281: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7282: x_margin_tbl := SYSTEM.pa_num_tbl_type();

Line 7279: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();

7275: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
7276: END IF;
7277: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
7278: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7279: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7280: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7281: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7282: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7283: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

Line 7280: x_cost_tbl := SYSTEM.pa_num_tbl_type();

7276: END IF;
7277: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
7278: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7279: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7280: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7281: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7282: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7283: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7284:

Line 7281: x_revenue_tbl := SYSTEM.pa_num_tbl_type();

7277: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
7278: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7279: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7280: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7281: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7282: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7283: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7284:
7285:

Line 7282: x_margin_tbl := SYSTEM.pa_num_tbl_type();

7278: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7279: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7280: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7281: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7282: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7283: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7284:
7285:
7286: ----------------------------------------------------

Line 7283: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

7279: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7280: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7281: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7282: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7283: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7284:
7285:
7286: ----------------------------------------------------
7287: -- Fetch Lookup_code ,summary and reference details.

Line 7889: X_pt_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for fin plan type ids --File.Sql.39 bug 4440895

7885: -- Added New Params for Quantity in GET_PLAN_TYPES_FOR_IMPL - Bug 3902176
7886: PROCEDURE GET_PLAN_TYPES_FOR_IMPL
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

Line 7895: X_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for raw cost --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
7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895

Line 7896: X_burd_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for burdened cost --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
7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895

Line 7897: X_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue --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
7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7901: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895

Line 7898: X_labor_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Cost --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
7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7901: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7902: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895

Line 7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --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
7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7901: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7902: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7903: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895

Line 7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --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
7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7901: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7902: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7903: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7904: X_margin_derived_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, -- Plsql table for Margin Derived From Code - Bug 3734840 --File.Sql.39 bug 4440895

Line 7901: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --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
7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7901: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7902: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7903: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7904: X_margin_derived_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, -- Plsql table for Margin Derived From Code - Bug 3734840 --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

Line 7902: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --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
7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7901: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7902: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7903: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7904: X_margin_derived_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, -- Plsql table for Margin Derived From Code - Bug 3734840 --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

Line 7903: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895

7899: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7900: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7901: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7902: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7903: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7904: X_margin_derived_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, -- Plsql table for Margin Derived From Code - Bug 3734840 --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

Line 7906: X_cost_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for cost bv id --File.Sql.39 bug 4440895

7902: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7903: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7904: X_margin_derived_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, -- Plsql table for Margin Derived From Code - Bug 3734840 --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

Line 7907: X_rev_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for revenue bv id --File.Sql.39 bug 4440895

7903: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7904: X_margin_derived_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, -- Plsql table for Margin Derived From Code - Bug 3734840 --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

Line 7908: X_all_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for all bv id --File.Sql.39 bug 4440895

7904: X_margin_derived_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, -- Plsql table for Margin Derived From Code - Bug 3734840 --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

Line 8012: X_pt_id_tbl := SYSTEM.pa_num_tbl_type();

8008: x_msg_count := 0;
8009: x_return_status := FND_API.G_RET_STS_SUCCESS;
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();

Line 8018: X_raw_cost_tbl := SYSTEM.pa_num_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();
8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();

Line 8019: X_burd_cost_tbl := SYSTEM.pa_num_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();
8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();

Line 8020: X_revenue_tbl := SYSTEM.pa_num_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();
8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();

Line 8021: X_labor_hrs_c_tbl := SYSTEM.pa_num_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();
8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8025: X_margin_tbl := SYSTEM.pa_num_tbl_type();

Line 8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_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();
8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8025: X_margin_tbl := SYSTEM.pa_num_tbl_type();
8026: X_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

Line 8023: X_labor_hrs_r_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();
8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8025: X_margin_tbl := SYSTEM.pa_num_tbl_type();
8026: X_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
8027: X_cost_bv_id_tbl := SYSTEM.pa_num_tbl_type();

Line 8024: X_equipment_hrs_r_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();
8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8025: X_margin_tbl := SYSTEM.pa_num_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();

Line 8025: X_margin_tbl := SYSTEM.pa_num_tbl_type();

8021: X_labor_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8025: X_margin_tbl := SYSTEM.pa_num_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();

Line 8026: X_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

8022: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8025: X_margin_tbl := SYSTEM.pa_num_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();

Line 8027: X_cost_bv_id_tbl := SYSTEM.pa_num_tbl_type();

8023: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8025: X_margin_tbl := SYSTEM.pa_num_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

Line 8028: X_rev_bv_id_tbl := SYSTEM.pa_num_tbl_type();

8024: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
8025: X_margin_tbl := SYSTEM.pa_num_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

Line 8029: X_all_bv_id_tbl := SYSTEM.pa_num_tbl_type();

8025: X_margin_tbl := SYSTEM.pa_num_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