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_RESOURCE_ASSIGNMENTS

Line 78: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;

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;
79: l_sp_fixed_date DATE;
80:
81: Cursor C_Spread_Curve_Id(p_resource_assignment_id IN NUMBER) IS
82: select spread_curve_id, sp_fixed_date

Line 83: from pa_resource_assignments

79: l_sp_fixed_date DATE;
80:
81: Cursor C_Spread_Curve_Id(p_resource_assignment_id IN NUMBER) IS
82: select spread_curve_id, sp_fixed_date
83: from pa_resource_assignments
84: where resource_assignment_id = p_resource_assignment_id ;
85: -- bug#13059417.changes ends here.
86:
87: CURSOR C_Get_txn_Currency(p_resource_assignment_id IN NUMBER) IS

Line 97: procure_resource_flag, use_task_schedule_flag, rate_based_flag from pa_resource_assignments where

93: CURSOR C_Res_Asgmt_Data(p_resource_assignment_id IN NUMBER) IS
94: select task_id, wbs_element_version_id, supplier_id, resource_class_code, resource_assignment_id,
95: project_role_id, organization_id,
96: fc_res_type_code, named_role,res_type_code, planning_start_date, planning_end_date,
97: procure_resource_flag, use_task_schedule_flag, rate_based_flag from pa_resource_assignments where
98: resource_assignment_id = p_resource_assignment_id;
99: C_Res_Asgmt_Data_Rec C_Res_Asgmt_Data%ROWTYPE;
100:
101: CURSOR C_Get_res_info(p_resource_assignment_id IN NUMBER) IS

Line 103: from pa_resource_assignments r

99: C_Res_Asgmt_Data_Rec C_Res_Asgmt_Data%ROWTYPE;
100:
101: CURSOR C_Get_res_info(p_resource_assignment_id IN NUMBER) IS
102: select rate_based_flag , resource_list_member_id, planning_start_date, planning_end_date
103: from pa_resource_assignments r
104: where resource_assignment_id = p_resource_assignment_id;
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

Line 160: pa_resource_assignments pra

156: CURSOR C_Prog_Date(p_resource_assignment_id IN NUMBER) IS
157: select ppr.as_of_date
158: from pa_progress_rollup ppr,
159: pa_proj_element_versions ppv,
160: pa_resource_assignments pra
161: where ppv.parent_structure_version_id=p_pa_structure_version_id
162: and ppv.project_id=p_pa_project_id
163: and pra.resource_assignment_id=p_resource_assignment_id
164: and pra.project_id=ppv.project_id

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 1243: update pa_resource_assignments set sp_fixed_date=null,spread_curve_id =null, record_version_number=(record_version_number+1)

1239: -- delete from pa_budget_lines where resource_assignment_id = l_resource_assignment_id_tbl(i);
1240: -- END IF;
1241:
1242: /* commented for bug#13059417
1243: update pa_resource_assignments set sp_fixed_date=null,spread_curve_id =null, record_version_number=(record_version_number+1)
1244: where resource_assignment_id = l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id; */ -- commented for bug#13059417
1245:
1246: --bug#13059417. changes starts here.
1247: l_spread_curve_id := NULL;

Line 1254: update pa_resource_assignments set sp_fixed_date=l_sp_fixed_date, spread_curve_id =l_spread_curve_id, record_version_number=(record_version_number+1)

1250: OPEN C_Spread_Curve_Id(l_resource_assignment_id_tbl(i));
1251: FETCH C_Spread_Curve_Id INTO l_spread_curve_id, l_sp_fixed_date;
1252: CLOSE C_Spread_Curve_Id;
1253:
1254: update pa_resource_assignments set sp_fixed_date=l_sp_fixed_date, spread_curve_id =l_spread_curve_id, record_version_number=(record_version_number+1)
1255: where resource_assignment_id = l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id;
1256:
1257: --bug#13059417. changes ends here.
1258:

Line 1745: ,p_cbs_element_id IN PA_RESOURCE_ASSIGNMENTS.cbs_element_id%TYPE DEFAULT NULL

1741: ,p_scheduled_end IN DATE
1742: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
1743: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE
1744: --CBS Change in Derive_Task_Assignments
1745: ,p_cbs_element_id IN PA_RESOURCE_ASSIGNMENTS.cbs_element_id%TYPE DEFAULT NULL
1746: -- End CBS Change in Derive_Task_Assignments
1747: ,p_unplanned_flag IN PA_RESOURCE_ASSIGNMENTS.unplanned_flag%TYPE
1748: ,x_resource_assignment_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint
1749: ,x_task_version_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint

Line 1747: ,p_unplanned_flag IN PA_RESOURCE_ASSIGNMENTS.unplanned_flag%TYPE

1743: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE
1744: --CBS Change in Derive_Task_Assignments
1745: ,p_cbs_element_id IN PA_RESOURCE_ASSIGNMENTS.cbs_element_id%TYPE DEFAULT NULL
1746: -- End CBS Change in Derive_Task_Assignments
1747: ,p_unplanned_flag IN PA_RESOURCE_ASSIGNMENTS.unplanned_flag%TYPE
1748: ,x_resource_assignment_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint
1749: ,x_task_version_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint
1750: ,x_resource_list_member_id OUT NOCOPY NUMBER -- 4537865 Added Nocopy hint
1751: ,x_currency_code OUT NOCOPY VARCHAR2 -- 4537865 Added Nocopy hint

Line 1769: FROM pa_resource_assignments

1765: SELECT resource_assignment_id,
1766: DECODE(ta_display_flag, 'N', wbs_element_version_id, NULL),
1767: rate_based_flag,
1768: rbs_element_id
1769: FROM pa_resource_assignments
1770: WHERE resource_list_member_id = c_resource_list_member_id
1771: --CBS Change in Derive_Task_Assignments
1772: AND nvl(cbs_element_id,-1) = nvl(c_cbs_element_id, -1) -- Bug 16743324
1773: --End CBS Change in Derive_Task_Assignments

Line 1780: FROM pa_resource_assignments

1776: AND rownum = 1;
1777:
1778: CURSOR get_task_level_rec IS
1779: SELECT resource_assignment_id, resource_list_member_id
1780: FROM pa_resource_assignments
1781: WHERE wbs_element_version_id = p_task_version_id
1782: AND ta_display_flag = 'N'
1783: AND rownum = 1;
1784:

Line 1787: FROM pa_resource_assignments

1783: AND rownum = 1;
1784:
1785: CURSOR get_people_class_asgmt IS
1786: SELECT resource_assignment_id, resource_list_member_id
1787: FROM pa_resource_assignments
1788: WHERE wbs_element_version_id = p_task_version_id
1789: AND ta_display_flag = 'Y'
1790: AND resource_class_code = 'PEOPLE'
1791: AND rownum = 1;

Line 2027: UPDATE pa_resource_assignments

2023: -- 2. in shared case, the RL is None and the rlm is of People class
2024: -- AND no assignment exists on the task version
2025: IF l_toggle_ta_display_flag = 'Y' THEN
2026:
2027: UPDATE pa_resource_assignments
2028: SET ta_display_flag = 'N'
2029: WHERE resource_assignment_id = l_resource_assignment_id;
2030:
2031: END IF;

Line 2137: pa_resource_assignments ra_old,

2133: 'Y',
2134: ra_old.ta_display_flag,
2135: ra_old.cbs_element_id -- Added for 16200605
2136: FROM
2137: pa_resource_assignments ra_old,
2138: pa_proj_element_versions pev,
2139: pa_proj_elem_ver_schedule pevs
2140: WHERE
2141: ra_old.budget_version_id = old_budget_version_id AND

Line 2159: pa_resource_assignments ra_new

2155: (
2156: SELECT
2157: ra_new.resource_assignment_id
2158: FROM
2159: pa_resource_assignments ra_new
2160: WHERE
2161: ra_new.resource_list_member_id = ra_old.resource_list_member_id AND
2162: NVL(ra_new.cbs_element_id,-1) = NVL(ra_old.cbs_element_id,-1) AND -- Added for 16200605
2163: ra_new.task_id = ra_old.task_id AND

Line 2236: UPDATE pa_resource_assignments

2232:
2233: -- Workaround to the fact that Add_Planning_Transactions only accept planning_*_date
2234: -- which are then stemed to schedule_*_date in Validate_Create_Assignment
2235: FORALL i IN 1..l_element_version_id_tbl.COUNT
2236: UPDATE pa_resource_assignments
2237: SET planning_start_date = l_planning_start_date_tbl(i),
2238: planning_end_date = l_planning_end_date_tbl(i),
2239: ta_display_flag = l_ta_display_flag_tbl(i)
2240: WHERE wbs_element_version_id = l_element_version_id_tbl(i)