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

Line 1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

1908: ,p_src_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1909: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1913: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1914: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1915: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1916: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1913: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

1909: ,p_targ_elem_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1913: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1914: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1915: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1916: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1917: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1914: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

1910: ,p_targ_proj_assmt_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1913: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1914: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1915: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1916: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1917: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1918: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1915: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

1911: ,p_targ_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE -- Bug 3615617
1912: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1913: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1914: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1915: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1916: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1917: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1918: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1919: IS

Line 1932: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1928: l_debug_mode VARCHAR2(30);
1929: l_debug_level3 CONSTANT NUMBER :=3;
1930: l_debug_level5 CONSTANT NUMBER :=5;
1931: l_module_name VARCHAR2(200) := g_module_name || '.create_res_task_maps';
1932: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1933: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1934: --End of variables used for debugging
1935: --Bug 4201936
1936: l_temp VARCHAR2(15);

Line 1933: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1929: l_debug_level3 CONSTANT NUMBER :=3;
1930: l_debug_level5 CONSTANT NUMBER :=5;
1931: l_module_name VARCHAR2(200) := g_module_name || '.create_res_task_maps';
1932: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1933: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1934: --End of variables used for debugging
1935: --Bug 4201936
1936: l_temp VARCHAR2(15);
1937: l_src_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;

Line 9382: l_end_dateTab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE ();

9378: l_project_revenueTab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
9379: l_txn_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9380: l_projfunc_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9381: l_project_currency_codeTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9382: l_end_dateTab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE ();
9383: l_period_nameTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9384:
9385: CURSOR Cur_group_source_budget_lines IS
9386: SELECT distinct pbl.resource_assignment_id resource_assignment_id, pbl.start_date start_date,pra.rate_based_flag