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 74: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

70: l_period_end_date DATE;
71: -- 10/22/04: To handle only lines after the progress as of date
72: l_finplan_line_count NUMBER := 1;
73:
74: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
75: l_project_name pa_projects_all.name%TYPE;
76:
77: --bug#13059417.changes starts here.
78: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;

Line 109: from pa_budget_versions a, pa_projects_all b

105: C_Get_res_info_rec C_Get_res_info%ROWTYPE;
106:
107: CURSOR C_Get_Budget_Version_Id(p_structure_version_id IN NUMBER, p_project_id IN NUMBER) is
108: select a.budget_version_id, b.project_currency_code
109: from pa_budget_versions a, pa_projects_all b
110: where a.project_structure_version_id = p_structure_version_id
111: and a.project_id = b.project_id
112: and a.project_id = p_project_id;
113:

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

194: p_project_id IN NUMBER,
195: p_wbs_version_id IN NUMBER,
196: p_resource_list_member_id IN NUMBER ) IS
197: Select a.alias, b.resource_assignment_id
198: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
199: where a.resource_list_member_id = b.resource_list_member_id
200: and b.resource_list_member_id = p_resource_list_member_id
201: and b.ta_display_flag = 'Y'
202: and b.budget_version_id = bv.budget_version_id

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

211: p_project_id IN NUMBER,
212: p_wbs_version_id IN NUMBER,
213: p_resource_list_member_id IN NUMBER,p_cbs_element_id IN NUMBER ) IS
214: Select a.alias, b.resource_assignment_id
215: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
216: where a.resource_list_member_id = b.resource_list_member_id
217: and b.resource_list_member_id = p_resource_list_member_id
218: and b.ta_display_flag = 'Y'
219: and b.budget_version_id = bv.budget_version_id

Line 246: ,pa_budget_versions pbv

242: ,pbv.etc_start_date
243: FROM gl_sets_of_books gsb
244: ,pa_implementations_all pia
245: ,pa_projects_all ppa
246: ,pa_budget_versions pbv
247: ,pa_proj_fp_options ppfo
248: WHERE ppa.project_id = pbv.project_id
249: AND pbv.budget_version_id = ppfo.fin_plan_version_id
250: AND ppa.org_id = pia.org_id

Line 1546: ,pa_budget_versions pbv

1542: ,glp.start_date period_start_date,glp.end_date period_end_date
1543: FROM gl_sets_of_books gsb
1544: ,pa_implementations_all pia
1545: ,pa_projects_all ppa
1546: ,pa_budget_versions pbv
1547: ,pa_proj_fp_options ppfo
1548: ,gl_periods glp
1549: WHERE ppa.project_id = pbv.project_id
1550: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 1795: FROM pa_budget_versions bv,

1791: AND rownum = 1;
1792:
1793: CURSOR get_budget_version_id IS
1794: SELECT bv.budget_version_id
1795: FROM pa_budget_versions bv,
1796: pa_proj_element_versions ev,
1797: pa_proj_elem_ver_structure evs
1798: WHERE bv.project_id = p_project_id
1799: AND bv.wp_version_flag = 'Y'

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

2084: (
2085: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2086: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2087: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2088: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
2089: x_msg_count OUT NOCOPY NUMBER,
2090: x_msg_data OUT NOCOPY VARCHAR2,
2091: x_return_status OUT NOCOPY VARCHAR2
2092: )

Line 2096: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

2092: )
2093:
2094: IS
2095:
2096: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2097: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2098:
2099: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2100: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2097: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

2093:
2094: IS
2095:
2096: l_old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2097: l_new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2098:
2099: l_parent_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2100: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2101: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2116: FROM pa_budget_versions

2112: k NUMBER;
2113:
2114: CURSOR c_get_budget_version_id(structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE) IS
2115: SELECT budget_version_id
2116: FROM pa_budget_versions
2117: WHERE project_structure_version_id = structure_version_id
2118: AND wp_version_flag = 'Y';
2119:
2120: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

Line 2122: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

2118: AND wp_version_flag = 'Y';
2119:
2120: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2121: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2122: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2123: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS
2124: SELECT
2125: pev.element_version_id,
2126: ra_old.resource_list_member_id,

Line 2123: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS

2119:
2120: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2121: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2122: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2123: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS
2124: SELECT
2125: pev.element_version_id,
2126: ra_old.resource_list_member_id,
2127: 0,

Line 2258: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,

2254: END Copy_Missing_Unplanned_Asgmts;
2255:
2256:
2257: PROCEDURE Check_Period_Details(
2258: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%TYPE,
2259: p_period_set_name IN gl_periods.period_set_name%TYPE,
2260: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2261: p_accounted_period_type IN gl_periods.period_type%TYPE,
2262: p_pa_period_type IN gl_periods.period_type%TYPE,