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_150_TBL_TYPE

Line 4415: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895

4411: ,p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE
4412: ,p_page_context IN VARCHAR2
4413: ,p_calling_mode IN VARCHAR2 DEFAULT 'APPROVED' --Bug 5278200 kchaitan
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

Line 5008: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

5004: IF l_debug_mode = 'Y' THEN
5005: pa_debug.g_err_stage:='Initialising all tables to empty tables.';
5006: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
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();

Line 7047: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895

7043: ( p_project_id IN NUMBER
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

Line 7277: x_summary_tbl := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

7273: IF l_debug_mode = 'Y' THEN
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();

Line 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

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
7894: x_rev_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Implement Rev Flag --File.Sql.39 bug 4440895

Line 8013: X_pt_name_tbl := SYSTEM.pa_varchar2_150_tbl_type();

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();
8017: x_rev_impl_tbl := SYSTEM.pa_varchar2_1_tbl_type();