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_30_TBL_TYPE

Line 4368: ,x_reference_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE --File.Sql.39 bug 4440895

4364: ,p_calling_mode IN VARCHAR2 DEFAULT 'APPROVED' --Bug 5278200 kchaitan
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

Line 4419: l_fin_plan_preference_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_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();
4423:

Line 4420: l_rep_lab_from_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_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();
4423:
4424: l_set_cw_url_flag VARCHAR2(1) := 'Y';

Line 4437: l_version_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

4433: l_pa_ob_revenue_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%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:

Line 4954: x_reference_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

4950: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
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();

Line 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

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
7818: X_all_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for all bv id --File.Sql.39 bug 4440895

Line 7936: X_margin_derived_code_tbl := SYSTEM.pa_varchar2_30_tbl_type(); -- Bug 3734840

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