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 588: p_source_fp_version_id_tbl IN SYSTEM.pa_num_tbl_type,

584: ********************************************************************/
585: PROCEDURE FP_CI_CHECK_MERGE_POSSIBLE
586: (
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

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

3187: l_curr_work_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
3188: l_attr_same_flag VARCHAR2(1);
3189:
3190: --Added by Xin Liu. For enhancement.
3191: l_source_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3192:
3193: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
3194: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
3195: --Done by Xin Liu for enhancement

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

3286: --Added by Xin Liu. For enhancement.
3287:
3288: l_source_version_id := l_ci_version_id_tbl(i);
3289: l_source_id_tbl.DELETE;
3290: l_source_id_tbl:= SYSTEM.pa_num_tbl_type();
3291: l_source_id_tbl.extend(1);
3292: l_source_id_tbl(1) := l_source_version_id;
3293: l_target_version_id := l_curr_work_version_id;
3294:

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

4365: ,x_context OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4366: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
4367: ,x_url_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE --File.Sql.39 bug 4440895
4368: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895
4369: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4370: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4371: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4372: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4373: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

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

4366: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
4367: ,x_url_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE --File.Sql.39 bug 4440895
4368: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895
4369: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4370: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4371: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4372: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4373: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4374: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

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

4367: ,x_url_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE --File.Sql.39 bug 4440895
4368: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895
4369: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4370: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4371: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4372: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4373: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4374: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4375: ,x_project_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

4368: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895
4369: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4370: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4371: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4372: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4373: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4374: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4375: ,x_project_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4376: ,x_report_labor_hrs_code OUT NOCOPY VARCHAR2 /* Bug 4038253 */ --File.Sql.39 bug 4440895

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

4369: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4370: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4371: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4372: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4373: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4374: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4375: ,x_project_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4376: ,x_report_labor_hrs_code OUT NOCOPY VARCHAR2 /* Bug 4038253 */ --File.Sql.39 bug 4440895
4377: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

4370: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4371: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4372: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4373: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4374: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
4375: ,x_project_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4376: ,x_report_labor_hrs_code OUT NOCOPY VARCHAR2 /* Bug 4038253 */ --File.Sql.39 bug 4440895
4377: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4378: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

4413: l_cw_equipment_quantity PA_BUDGET_VERSIONS.EQUIPMENT_QUANTITY%TYPE;
4414: l_cw_cost PA_BUDGET_VERSIONS.RAW_COST%TYPE;
4415: l_cw_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE;
4416:
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();

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

4414: l_cw_cost PA_BUDGET_VERSIONS.RAW_COST%TYPE;
4415: l_cw_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE;
4416:
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();

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

4434: l_pa_cb_cost_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
4435: l_pa_cb_revenue_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
4436: l_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
4437: l_version_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4438: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4439: l_next VARCHAR2(30);
4440: l_context VARCHAR2(30);
4441:
4442: l_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

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

4951: END IF;
4952: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
4953: x_url_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
4954: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4955: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
4956: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
4957: x_cost_tbl := SYSTEM.pa_num_tbl_type();
4958: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
4959: x_margin_tbl := SYSTEM.pa_num_tbl_type();

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

4952: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
4953: x_url_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
4954: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4955: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
4956: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
4957: x_cost_tbl := SYSTEM.pa_num_tbl_type();
4958: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
4959: x_margin_tbl := SYSTEM.pa_num_tbl_type();
4960: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

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

4953: x_url_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
4954: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4955: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
4956: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
4957: x_cost_tbl := SYSTEM.pa_num_tbl_type();
4958: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
4959: x_margin_tbl := SYSTEM.pa_num_tbl_type();
4960: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
4961:

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

4954: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4955: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
4956: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
4957: x_cost_tbl := SYSTEM.pa_num_tbl_type();
4958: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
4959: x_margin_tbl := SYSTEM.pa_num_tbl_type();
4960: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
4961:
4962: ----------------------------------------------------

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

4955: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
4956: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
4957: x_cost_tbl := SYSTEM.pa_num_tbl_type();
4958: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
4959: x_margin_tbl := SYSTEM.pa_num_tbl_type();
4960: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
4961:
4962: ----------------------------------------------------
4963: -- Derive Value of x_context

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

4956: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
4957: x_cost_tbl := SYSTEM.pa_num_tbl_type();
4958: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
4959: x_margin_tbl := SYSTEM.pa_num_tbl_type();
4960: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
4961:
4962: ----------------------------------------------------
4963: -- Derive Value of x_context
4964: ----------------------------------------------------

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

6972: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
6973: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
6974: ,p_version_type IN pa_budget_versions.version_type%TYPE
6975: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
6976: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6977: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6978: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6979: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6980: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

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

6973: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
6974: ,p_version_type IN pa_budget_versions.version_type%TYPE
6975: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
6976: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6977: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6978: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6979: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6980: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6981: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

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

6974: ,p_version_type IN pa_budget_versions.version_type%TYPE
6975: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
6976: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6977: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6978: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6979: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6980: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6981: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

6975: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
6976: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6977: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6978: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6979: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6980: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6981: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6983: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

6976: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6977: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6978: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6979: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6980: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6981: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6983: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6984: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

6977: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6978: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6979: ,x_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6980: ,x_margin_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6981: ,x_margin_percent_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
6982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6983: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6984: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6985: ) IS

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

7000: l_labor_quantity PA_BUDGET_VERSIONS.LABOR_QUANTITY%TYPE;
7001: l_equipment_quantity PA_BUDGET_VERSIONS.EQUIPMENT_QUANTITY%TYPE;
7002: l_cost PA_BUDGET_VERSIONS.RAW_COST%TYPE;
7003: l_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE;
7004: l_lookup_code_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7005: l_assigned_flag VARCHAR2(1) := 'N';
7006: l_module_name VARCHAR2(30) := 'ctrl_itm_utls.get_not_incl';
7007:
7008:

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

7202: pa_debug.g_err_stage:='Initialising all tables to empty tables.';
7203: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
7204: END IF;
7205: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
7206: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7207: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7208: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7209: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7210: x_margin_tbl := SYSTEM.pa_num_tbl_type();

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

7203: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
7204: END IF;
7205: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
7206: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7207: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7208: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7209: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7210: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7211: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

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

7204: END IF;
7205: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
7206: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7207: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7208: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7209: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7210: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7211: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7212:

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

7205: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
7206: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7207: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7208: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7209: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7210: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7211: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7212:
7213:

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

7206: x_equipment_hours_tbl := SYSTEM.pa_num_tbl_type();
7207: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7208: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7209: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7210: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7211: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7212:
7213:
7214: ----------------------------------------------------

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

7207: x_labor_hours_tbl := SYSTEM.pa_num_tbl_type();
7208: x_cost_tbl := SYSTEM.pa_num_tbl_type();
7209: x_revenue_tbl := SYSTEM.pa_num_tbl_type();
7210: x_margin_tbl := SYSTEM.pa_num_tbl_type();
7211: x_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7212:
7213:
7214: ----------------------------------------------------
7215: -- Fetch Lookup_code ,summary and reference details.

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

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

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

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

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

Line 7808: X_labor_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Cost --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
7809: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7810: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7811: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7812: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895

Line 7809: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --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
7809: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7810: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7811: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7812: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7813: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895

Line 7810: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --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
7809: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7810: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7811: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7812: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7813: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7814: 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 7811: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --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
7809: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7810: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7811: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7812: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7813: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7814: 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
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

Line 7812: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --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
7809: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7810: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7811: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7812: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7813: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7814: 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
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

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

7809: X_equipment_hrs_c_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Cost --File.Sql.39 bug 4440895
7810: X_labor_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for labor hrs -Rev --File.Sql.39 bug 4440895
7811: X_equipment_hrs_r_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql tabe for equipment hrs -Rev --File.Sql.39 bug 4440895
7812: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7813: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7814: 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
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

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

7812: X_margin_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin --File.Sql.39 bug 4440895
7813: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7814: 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
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

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

7813: X_margin_percent_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for margin percent --File.Sql.39 bug 4440895
7814: 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
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

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

7814: 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
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

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

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

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

Line 7924: X_burd_cost_tbl := SYSTEM.pa_num_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();
7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();

Line 7925: X_revenue_tbl := SYSTEM.pa_num_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();
7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7929: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();

Line 7926: X_labor_hrs_c_tbl := SYSTEM.pa_num_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();
7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7929: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7930: X_margin_tbl := SYSTEM.pa_num_tbl_type();

Line 7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_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();
7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7929: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7930: X_margin_tbl := SYSTEM.pa_num_tbl_type();
7931: X_margin_percent_tbl := SYSTEM.pa_num_tbl_type();

Line 7928: X_labor_hrs_r_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();
7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7929: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7930: X_margin_tbl := SYSTEM.pa_num_tbl_type();
7931: X_margin_percent_tbl := SYSTEM.pa_num_tbl_type();
7932: X_cost_bv_id_tbl := SYSTEM.pa_num_tbl_type();

Line 7929: X_equipment_hrs_r_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();
7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7929: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7930: X_margin_tbl := SYSTEM.pa_num_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();

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

7926: X_labor_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7929: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7930: X_margin_tbl := SYSTEM.pa_num_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();

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

7927: X_equipment_hrs_c_tbl := SYSTEM.pa_num_tbl_type();
7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7929: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7930: X_margin_tbl := SYSTEM.pa_num_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();

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

7928: X_labor_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7929: X_equipment_hrs_r_tbl := SYSTEM.pa_num_tbl_type();
7930: X_margin_tbl := SYSTEM.pa_num_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

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

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

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

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