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_TASK_ASSIGNMENTS_PVT dependencies on PA_BUDGET_VERSIONS

Line 49: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

45:
46: l_context varchar2(200);
47: l_calling_module varchar2(200);
48: l_struct_elem_version_id number;
49: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
50: l_task_elem_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
51: l_start_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
52: l_end_date_tbl system.pa_date_tbl_type := system.pa_date_tbl_type();
53: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 95: from pa_budget_versions a, pa_projects_all b

91: C_Get_res_info_rec C_Get_res_info%ROWTYPE;
92:
93: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER, p_project_id IN NUMBER) is
94: select a.budget_version_id, b.project_currency_code
95: from pa_budget_versions a, pa_projects_all b
96: where a.project_structure_version_id = p_structure_version_id
97: and a.project_id = b.project_id
98: and a.project_id = p_project_id;
99:

Line 181: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

177: p_project_id IN NUMBER,
178: p_wbs_version_id IN NUMBER,
179: p_resource_list_member_id IN NUMBER ) IS
180: Select a.alias, b.resource_assignment_id
181: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
182: where a.resource_list_member_id = b.resource_list_member_id
183: and b.resource_list_member_id = p_resource_list_member_id
184: and b.ta_display_flag = 'Y'
185: and b.budget_version_id = bv.budget_version_id

Line 210: ,pa_budget_versions pbv

206: ppfo.all_time_phased_code) time_phase_code
207: FROM gl_sets_of_books gsb
208: ,pa_implementations_all pia
209: ,pa_projects_all ppa
210: ,pa_budget_versions pbv
211: ,pa_proj_fp_options ppfo
212: WHERE ppa.project_id = pbv.project_id
213: AND pbv.budget_version_id = ppfo.fin_plan_version_id
214: AND ppa.org_id = pia.org_id

Line 1333: ,pa_budget_versions pbv

1329: ,glp.start_date period_start_date,glp.end_date period_end_date
1330: FROM gl_sets_of_books gsb
1331: ,pa_implementations_all pia
1332: ,pa_projects_all ppa
1333: ,pa_budget_versions pbv
1334: ,pa_proj_fp_options ppfo
1335: ,gl_periods glp
1336: WHERE ppa.project_id = pbv.project_id
1337: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 1571: FROM pa_budget_versions bv,

1567: AND rownum = 1;
1568:
1569: CURSOR get_budget_version_id IS
1570: SELECT bv.budget_version_id
1571: FROM pa_budget_versions bv,
1572: pa_proj_element_versions ev,
1573: pa_proj_elem_ver_structure evs
1574: WHERE bv.project_id = p_project_id
1575: AND bv.wp_version_flag = 'Y'

Line 1853: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,

1849: (
1850: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
1851: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1852: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1853: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
1854: x_msg_count OUT NOCOPY NUMBER,
1855: x_msg_data OUT NOCOPY VARCHAR2,
1856: x_return_status OUT NOCOPY VARCHAR2
1857: )

Line 1861: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

1857: )
1858:
1859: IS
1860:
1861: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1862: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1863:
1864: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1865: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1862: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

1858:
1859: IS
1860:
1861: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1862: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1863:
1864: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1865: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1866: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1880: FROM pa_budget_versions

1876: k NUMBER;
1877:
1878: CURSOR c_get_budget_version_id(structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE) IS
1879: SELECT budget_version_id
1880: FROM pa_budget_versions
1881: WHERE project_structure_version_id = structure_version_id
1882: AND wp_version_flag = 'Y';
1883:
1884: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

Line 1886: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

1882: AND wp_version_flag = 'Y';
1883:
1884: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1885: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1886: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1887: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS
1888: SELECT
1889: pev.element_version_id,
1890: ra_old.resource_list_member_id,

Line 1887: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS

1883:
1884: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1885: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1886: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1887: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS
1888: SELECT
1889: pev.element_version_id,
1890: ra_old.resource_list_member_id,
1891: 0,

Line 2018: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,

2014: END Copy_Missing_Unplanned_Asgmts;
2015:
2016:
2017: PROCEDURE Check_Period_Details(
2018: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2019: p_period_set_name IN gl_periods.period_set_name%TYPE,
2020: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2021: p_accounted_period_type IN gl_periods.period_type%TYPE,
2022: p_pa_period_type IN gl_periods.period_type%TYPE,