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_PLANNING_TRANSACTION_UTILS dependencies on PA_DATE_TBL_TYPE

Line 252: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

248: PROCEDURE get_default_planning_dates
249: ( p_project_id IN pa_projects_all.project_id%TYPE
250: ,p_element_version_id_tbl IN SYSTEM.pa_num_tbl_type
251: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
252: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
253: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
254: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
255: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
256: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 253: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

249: ( p_project_id IN pa_projects_all.project_id%TYPE
250: ,p_element_version_id_tbl IN SYSTEM.pa_num_tbl_type
251: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
252: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
253: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
254: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
255: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
256: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
257: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 254: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895

250: ,p_element_version_id_tbl IN SYSTEM.pa_num_tbl_type
251: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
252: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
253: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
254: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
255: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
256: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
257: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
258: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 255: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895

251: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
252: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
253: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
254: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
255: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
256: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
257: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
258: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
259: ) IS

Line 328: x_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();

324: pa_debug.g_err_stage:='Looping thru the element version id tbl to derive the dates';
325: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);
326: END IF;
327:
328: x_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();
329: x_planning_end_date_tbl := SYSTEM.pa_date_tbl_type();
330: x_planning_start_date_tbl.extend(p_element_version_id_tbl.LAST);
331: x_planning_end_date_tbl.extend(p_element_version_id_tbl.LAST);
332: --Loop thru the input table and derive the start and end dates

Line 329: x_planning_end_date_tbl := SYSTEM.pa_date_tbl_type();

325: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);
326: END IF;
327:
328: x_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();
329: x_planning_end_date_tbl := SYSTEM.pa_date_tbl_type();
330: x_planning_start_date_tbl.extend(p_element_version_id_tbl.LAST);
331: x_planning_end_date_tbl.extend(p_element_version_id_tbl.LAST);
332: --Loop thru the input table and derive the start and end dates
333: FOR i IN p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST LOOP

Line 561: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type

557: p_source IN VARCHAR2
558: ,p_budget_version_id IN pa_budget_versions.budget_Version_id%TYPE
559: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
560: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
561: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
562: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
563: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type
564: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
565: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type

Line 562: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type

558: ,p_budget_version_id IN pa_budget_versions.budget_Version_id%TYPE
559: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
560: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
561: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
562: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
563: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type
564: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
565: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
566: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type