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 4366: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895

4362: ,p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE
4363: ,p_page_context IN VARCHAR2
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

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

4948: IF l_debug_mode = 'Y' THEN
4949: pa_debug.g_err_stage:='Initialising all tables to empty tables.';
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();

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

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

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

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

Line 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

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

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

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