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_ASSIGNMENT_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 29: FROM pa_resource_assignments ra, pa_resource_list_members pr

25: l_resource_aliases VARCHAR2(20000);
26:
27: CURSOR C1_GTR(p_element_version_id in NUMBER) IS
28: SELECT pr.alias
29: FROM pa_resource_assignments ra, pa_resource_list_members pr
30: WHERE ra.resource_list_member_id = pr.resource_list_member_id
31: AND ra.wbs_element_version_id = p_element_version_id
32: AND ra.resource_class_code = 'PEOPLE'
33: AND ra.ta_display_flag = 'Y'

Line 39: FROM pa_resource_assignments ra, pa_resource_list_members pr

35:
36: UNION ALL
37:
38: SELECT pr.alias
39: FROM pa_resource_assignments ra, pa_resource_list_members pr
40: WHERE ra.resource_list_member_id = pr.resource_list_member_id
41: AND ra.wbs_element_version_id = p_element_version_id
42: AND ra.resource_class_code = 'EQUIPMENT'
43: AND ra.ta_display_flag = 'Y'

Line 49: FROM pa_resource_assignments ra, pa_resource_list_members pr

45:
46: UNION ALL
47:
48: SELECT pr.alias
49: FROM pa_resource_assignments ra, pa_resource_list_members pr
50: WHERE ra.resource_list_member_id = pr.resource_list_member_id
51: AND ra.wbs_element_version_id = p_element_version_id
52: AND ra.resource_class_code = 'MATERIAL_ITEMS'
53: AND ra.ta_display_flag = 'Y'

Line 59: FROM pa_resource_assignments ra, pa_resource_list_members pr

55:
56: UNION ALL
57:
58: SELECT pr.alias
59: FROM pa_resource_assignments ra, pa_resource_list_members pr
60: WHERE ra.resource_list_member_id = pr.resource_list_member_id
61: AND ra.wbs_element_version_id = p_element_version_id
62: AND ra.resource_class_code = 'FINANCIAL_ELEMENTS'
63: AND ra.ta_display_flag = 'Y'

Line 138: FROM pa_resource_assignments ra, pa_resource_list_members pr

134: FUNCTION Get_Task_Resources(p_element_version_id IN NUMBER) RETURN VARCHAR2 IS
135:
136: CURSOR C1_GTR(p_element_version_id in NUMBER) IS
137: SELECT count(*) resource_count
138: FROM pa_resource_assignments ra, pa_resource_list_members pr
139: WHERE ra.resource_list_member_id = pr.resource_list_member_id
140: AND ra.wbs_element_version_id = p_element_version_id
141: AND ra.ta_display_flag = 'Y';
142:

Line 213: FROM pa_resource_assignments ra

209: l_exists varchar2(1) := 'N';
210:
211: CURSOR C1_Check_Exists(p_element_version_id IN NUMBER) IS
212: SELECT 'Y'
213: FROM pa_resource_assignments ra
214: WHERE ra.ta_display_flag = 'Y'
215: AND ra.wbs_element_version_id = p_element_version_id
216: AND rownum = 1;
217:

Line 295: FROM pa_resource_assignments ra, pa_map_wp_to_fin_tasks_v map

291:
292: --CURSOR C1_Check_Exists(p_wp_task_id IN NUMBER, p_ei_date IN DATE) IS
293: CURSOR C1_Check_Exists(p_ei_date IN DATE, p_project_id IN NUMBER) IS
294: SELECT 'Y'
295: FROM pa_resource_assignments ra, pa_map_wp_to_fin_tasks_v map
296: WHERE p_ei_date BETWEEN ra.planning_start_date AND ra.planning_end_Date
297: AND ra.person_id = p_person_id
298: AND ra.ta_display_flag = 'Y'
299: AND ra.wbs_element_version_id = map.element_version_id

Line 604: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks

600: SELECT ra.resource_assignment_id, ra.total_plan_quantity,
601: tasks.src_elem_ver_id, tasks.new_task_sch_start, tasks.new_task_sch_end
602: BULK COLLECT INTO l_use_task_sch_asgmt_tbl, l_use_task_quantity_tbl,
603: l_use_task_task_ver_tbl, l_use_task_new_sch_start, l_use_task_new_sch_end --Bug 4153366
604: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks
605: WHERE ra.use_task_schedule_flag = 'Y'
606: AND ra.ta_display_flag is not null
607: AND ra.budget_version_id = l_budget_ver_id -- Bug 4229020
608: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;

Line 635: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks

631: tasks.src_elem_ver_id
632: BULK COLLECT INTO
633: l_adj_dates_asgmt_tbl, l_adj_task_quantity_tbl, l_delay_tbl, l_duration_tbl,
634: l_new_start_tbl, l_new_end_tbl, l_finish_flg_tbl, l_new_task_sch_start, l_new_task_sch_finish, l_adj_task_task_ver_tbl
635: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks
636: WHERE nvl(ra.use_task_schedule_flag, 'N') <> 'Y'
637: AND ra.ta_display_flag is not null
638: AND ra.budget_version_id = l_budget_ver_id
639: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;

Line 1303: UPDATE pa_resource_assignments

1299: -- p_task_assignment_tbl(1).unplanned_flag = FND_API.G_MISS_CHAR OR
1300: -- p_task_assignment_tbl(1).unplanned_flag <> 'Y') THEN
1301:
1302: FORALL k IN l_task_rec_project_id_tbl.FIRST .. l_task_rec_project_id_tbl.LAST
1303: UPDATE pa_resource_assignments
1304: SET ta_display_flag = 'Y',
1305: record_version_number = record_version_number + 1
1306: WHERE project_id = l_task_rec_project_id_tbl(k)
1307: AND wbs_element_version_id = l_task_rec_task_ver_id_tbl(k)

Line 1446: FROM pa_resource_assignments

1442: AND pev.project_id = pevs.project_id;
1443:
1444: CURSOR C_Res_Assignment_Info(p_resource_assignment_id IN NUMBER) IS
1445: SELECT *
1446: FROM pa_resource_assignments
1447: WHERE resource_assignment_id = p_resource_assignment_id;
1448:
1449: CURSOR C_Budget_Version_Info (p_resource_assignment_id IN NUMBER) IS
1450: SELECT budget_version_id

Line 1451: FROM pa_resource_assignments

1447: WHERE resource_assignment_id = p_resource_assignment_id;
1448:
1449: CURSOR C_Budget_Version_Info (p_resource_assignment_id IN NUMBER) IS
1450: SELECT budget_version_id
1451: FROM pa_resource_assignments
1452: WHERE resource_assignment_id = p_resource_assignment_id;
1453:
1454: CURSOR C2_Task_Effort_Assignment(p_resource_assignment_id IN NUMBER) IS
1455: SELECT ra.ta_display_flag, ra.resource_list_member_id, ra.project_id, ra.task_id, bv.project_structure_version_id

Line 1456: FROM pa_resource_assignments ra, pa_budget_versions bv

1452: WHERE resource_assignment_id = p_resource_assignment_id;
1453:
1454: CURSOR C2_Task_Effort_Assignment(p_resource_assignment_id IN NUMBER) IS
1455: SELECT ra.ta_display_flag, ra.resource_list_member_id, ra.project_id, ra.task_id, bv.project_structure_version_id
1456: FROM pa_resource_assignments ra, pa_budget_versions bv
1457: WHERE ra.resource_assignment_id = p_resource_assignment_id
1458: AND ra.budget_version_id = bv.budget_version_id;
1459:
1460: CURSOR C_Get_Actuals(p_resource_assignment_id IN NUMBER) IS

Line 1469: FROM pa_resource_assignments

1465: and rownum = 1;
1466:
1467: CURSOR C_Get_Project_Id IS
1468: SELECT project_id
1469: FROM pa_resource_assignments
1470: WHERE resource_assignment_id = p_task_assignment_tbl(1).resource_assignment_id;
1471:
1472: R_Res_Assignment_Rec C_Res_Assignment_Info%ROWTYPE;
1473: l_proj_element_id NUMBER;

Line 1648: UPDATE pa_resource_assignments

1644:
1645: IF l_rlm_id <> p_task_assignment_tbl(i).resource_list_member_id AND
1646: l_ta_display_flag = 'N' THEN
1647:
1648: UPDATE pa_resource_assignments
1649: SET ta_display_flag = 'Y'
1650: WHERE resource_assignment_id = p_task_assignment_tbl(i).resource_assignment_id;
1651:
1652: END IF; -- l_rlm_id <> p_task_assignment_tbl(i).resource_list_member_id

Line 2416: FROM pa_resource_assignments ra, pa_proj_element_versions pev

2412: WHERE pev.element_version_id = p_wbs_element_version_id AND pe.proj_element_id = pev.proj_element_id;
2413:
2414: CURSOR C_Element_Info2(p_resource_assignment_id IN NUMBER) IS
2415: SELECT ra.wbs_element_version_id, ra.project_id, pev.proj_element_id, ra.resource_list_member_id, ra.ta_display_flag, ra.task_id, ra.unplanned_flag, ra.total_plan_quantity
2416: FROM pa_resource_assignments ra, pa_proj_element_versions pev
2417: WHERE resource_assignment_id = p_resource_assignment_id
2418: and pev.element_version_id = ra.wbs_element_version_id;
2419:
2420: CURSOR C_Task_Asgmts(p_element_version_id IN NUMBER) IS

Line 2422: FROM pa_resource_assignments

2418: and pev.element_version_id = ra.wbs_element_version_id;
2419:
2420: CURSOR C_Task_Asgmts(p_element_version_id IN NUMBER) IS
2421: SELECT resource_assignment_id
2422: FROM pa_resource_assignments
2423: WHERE wbs_element_version_id = p_element_version_id;
2424:
2425: -- Bug 4492493: Check if Progress Rollup is required on DELETION
2426: CURSOR C_Planned_Effort_Exists(p_element_version_id IN NUMBER) IS

Line 2428: FROM pa_resource_assignments

2424:
2425: -- Bug 4492493: Check if Progress Rollup is required on DELETION
2426: CURSOR C_Planned_Effort_Exists(p_element_version_id IN NUMBER) IS
2427: SELECT 'Y'
2428: FROM pa_resource_assignments
2429: WHERE wbs_element_version_id = p_element_version_id
2430: AND total_plan_quantity > 0
2431: AND rownum = 1;
2432:

Line 2435: FROM pa_resource_assignments

2431: AND rownum = 1;
2432:
2433: CURSOR C_Asgmt_Planned_Effort_Exists(p_resource_assignment_id IN NUMBER) IS
2434: SELECT 'Y'
2435: FROM pa_resource_assignments
2436: WHERE resource_assignment_id = p_resource_assignment_id
2437: AND total_plan_quantity > 0;
2438:
2439: CURSOR C_Task_Get_Project_Id(p_elem_version_id IN NUMBER) IS

Line 2446: FROM pa_resource_assignments

2442: WHERE element_version_id = p_elem_version_id;
2443:
2444: CURSOR C_Asgmt_Get_Project_Id(p_resource_assignment_id IN NUMBER) IS
2445: SELECT project_id
2446: FROM pa_resource_assignments
2447: WHERE resource_assignment_id = p_resource_assignment_id;
2448: -- Added for Bug16847708
2449: CURSOR C_getCbsElementId(c_resource_assignment_id IN NUMBER) IS
2450: Select cbs_element_id

Line 2451: FROM pa_resource_assignments

2447: WHERE resource_assignment_id = p_resource_assignment_id;
2448: -- Added for Bug16847708
2449: CURSOR C_getCbsElementId(c_resource_assignment_id IN NUMBER) IS
2450: Select cbs_element_id
2451: FROM pa_resource_assignments
2452: WHERE resource_assignment_id = c_resource_assignment_id;
2453: l_Cbs_Enabled VARCHAR2(1) := 'N';
2454: l_cbs_element_id Number;
2455:

Line 2879: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;

2875: l_people_class_index NUMBER := -999;
2876: l_equip_class_index NUMBER := -999;
2877: l_mat_item_class_index NUMBER := -999;
2878: l_fin_elem_class_index NUMBER := -999;
2879: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2880: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2881: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2882: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;

Line 2880: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

2876: l_equip_class_index NUMBER := -999;
2877: l_mat_item_class_index NUMBER := -999;
2878: l_fin_elem_class_index NUMBER := -999;
2879: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2880: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2881: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2882: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2884: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;

Line 2881: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;

2877: l_mat_item_class_index NUMBER := -999;
2878: l_fin_elem_class_index NUMBER := -999;
2879: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2880: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2881: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2882: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2884: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2885: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

Line 2882: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;

2878: l_fin_elem_class_index NUMBER := -999;
2879: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2880: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2881: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2882: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2884: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2885: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2886: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;

2879: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2880: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2881: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2882: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2884: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2885: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2886: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2887: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;

Line 2884: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;

2880: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2881: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2882: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2884: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2885: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2886: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2887: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2888: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

Line 2885: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

2881: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2882: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2884: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2885: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2886: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2887: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2888: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2889: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

Line 2887: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;

2883: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2884: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2885: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2886: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2887: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2888: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2889: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
2890: l_ta_task_id pa_resource_assignments.task_id%TYPE;
2891: l_ta_res_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 2890: l_ta_task_id pa_resource_assignments.task_id%TYPE;

2886: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2887: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2888: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2889: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
2890: l_ta_task_id pa_resource_assignments.task_id%TYPE;
2891: l_ta_res_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2892: l_ta_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2893: l_ta_resource_class_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2894: l_ta_total_plan_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2907: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;

2903: l_add_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2904: l_ta_tr_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2905: l_add_projfunc_cur_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2906: l_ta_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2907: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2908: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2909: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2910: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2911: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 3026: pa_resource_assignments ra,

3022: ra.inventory_item_id
3023: FROM
3024: pa_copy_asgmts_temp temp,
3025: pa_proj_element_versions pev,
3026: pa_resource_assignments ra,
3027: pa_project_assignments asgn,
3028: pa_budget_lines bl,
3029: pa_resource_list_members rlm,
3030: pa_res_formats_b rf

Line 3119: pa_resource_assignments ra,

3115: ra.inventory_item_id
3116: FROM
3117: pa_copy_asgmts_temp temp,
3118: pa_proj_element_versions pev,
3119: pa_resource_assignments ra,
3120: pa_project_assignments asgn,
3121: pa_resource_list_members rlm,
3122: pa_res_formats_b rf
3123: WHERE

Line 3182: pa_resource_assignments ra,

3178: ra.inventory_item_id
3179: FROM
3180: pa_copy_asgmts_temp temp,
3181: pa_proj_element_versions pev,
3182: pa_resource_assignments ra,
3183: pa_project_assignments asgn,
3184: pa_budget_lines bl,
3185: pa_resource_list_members source_rlm,
3186: pa_resource_list_members target_rlm,

Line 3282: pa_resource_assignments ra,

3278: ra.inventory_item_id
3279: FROM
3280: pa_copy_asgmts_temp temp,
3281: pa_proj_element_versions pev,
3282: pa_resource_assignments ra,
3283: pa_project_assignments asgn,
3284: pa_resource_list_members source_rlm,
3285: pa_resource_list_members target_rlm,
3286: pa_res_formats_b rf

Line 5100: FROM pa_resource_assignments

5096: l_wbs_element_version_id number;
5097:
5098: CURSOR C_Wbs_Element_Version_Id(p_resource_assignment_id IN NUMBER) IS
5099: SELECT wbs_element_version_id
5100: FROM pa_resource_assignments
5101: WHERE resource_assignment_id = p_resource_assignment_id;
5102:
5103: CURSOR C_structure_Version_Id(p_element_version_id IN NUMBER) IS
5104: SELECT parent_structure_version_id, project_id

Line 5284: from pa_resource_assignments ra

5280: L_FuncProc varchar2(250) ;
5281:
5282: Cursor C_Min_Date IS
5283: select min(ra.SCHEDULE_START_DATE)
5284: from pa_resource_assignments ra
5285: where resource_list_member_id = p_resource_list_member_id
5286: and project_id = p_project_id
5287: and budget_version_id = p_budget_version_id
5288: and ('Y' <> p_unstaffed_only or nvl(project_assignment_id, -1) = -1);

Line 5292: from pa_resource_assignments ra

5288: and ('Y' <> p_unstaffed_only or nvl(project_assignment_id, -1) = -1);
5289:
5290: Cursor C_Max_Date IS
5291: select max(ra.SCHEDULE_END_DATE)
5292: from pa_resource_assignments ra
5293: where resource_list_member_id = p_resource_list_member_id
5294: and project_id = p_project_id
5295: and budget_version_id = p_budget_version_id
5296: and ('Y' <> p_unstaffed_only or nvl(project_assignment_id, -1) = -1);

Line 5356: from pa_resource_assignments ra

5352: L_FuncProc varchar2(250) ;
5353:
5354: Cursor C_Single_UOM IS
5355: select count(distinct ra.unit_of_measure) cnt
5356: from pa_resource_assignments ra
5357: where ta_display_flag = 'Y' and
5358: ra.project_id = p_project_id and
5359: ra.budget_version_id = p_budget_version_id and
5360: ra.resource_class_code = p_class;

Line 5608: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

5604: p_project_id IN pa_projects_all.project_id%TYPE,
5605:
5606: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5607:
5608: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5609:
5610: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5611:
5612: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

Line 5628: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

5624: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5625:
5626: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5627:
5628: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5629:
5630: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5631:
5632:

Line 5630: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;

5626: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5627:
5628: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5629:
5630: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5631:
5632:
5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5634:

Line 5645: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;

5641:
5642:
5643: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5644:
5645: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5646:
5647: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5648:
5649: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5647: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;

5643: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5644:
5645: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5646:
5647: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5648:
5649: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5650:
5651: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5676: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS

5672:
5673: l_msg_data VARCHAR2(200);
5674:
5675:
5676: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5677: SELECT bl.txn_currency_code
5678: FROM pa_budget_lines bl
5679: WHERE bl.resource_assignment_id = p_resource_assignment_id
5680: AND rownum = 1;

Line 5791: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

5787: p_project_id IN pa_projects_all.project_id%TYPE,
5788:
5789: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5790:
5791: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5792:
5793: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5794:
5795: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

Line 5811: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

5807: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5808:
5809: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5810:
5811: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5812:
5813: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5814:
5815:

Line 5813: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;

5809: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5810:
5811: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5812:
5813: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5814:
5815:
5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5817:

Line 5828: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;

5824:
5825:
5826: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5827:
5828: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5829:
5830: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5831:
5832: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5830: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;

5826: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5827:
5828: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5829:
5830: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5831:
5832: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5833:
5834: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5859: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS

5855:
5856: l_msg_data VARCHAR2(200);
5857:
5858:
5859: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5860: SELECT bl.txn_currency_code
5861: FROM pa_budget_lines bl
5862: WHERE bl.resource_assignment_id = p_resource_assignment_id
5863: AND rownum = 1;

Line 5977: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

5973:
5974: /* Commented for 4994791
5975:
5976: FUNCTION get_planned_asgmt_amounts(
5977: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5978: p_code IN VARCHAR2) RETURN NUMBER IS
5979:
5980:
5981: CURSOR get_resource_assignment_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS

Line 5981: CURSOR get_resource_assignment_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS

5977: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5978: p_code IN VARCHAR2) RETURN NUMBER IS
5979:
5980:
5981: CURSOR get_resource_assignment_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5982:
5983: SELECT
5984: SUM(bl.quantity) as planned_quantity,
5985: SUM(bl.txn_burdened_cost) as planned_bur_cost_txn_cur,

Line 6090: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

6086:
6087:
6088: FUNCTION get_planned_currency_info (
6089:
6090: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
6091:
6092: p_project_id IN pa_projects_all.project_id%TYPE,
6093:
6094: p_code IN VARCHAR2) RETURN VARCHAR2 IS

Line 6097: CURSOR get_bl_currency_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS

6093:
6094: p_code IN VARCHAR2) RETURN VARCHAR2 IS
6095:
6096: -- Bug 9675606
6097: CURSOR get_bl_currency_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
6098: SELECT prac.txn_currency_code as txn_currency_code
6099: FROM pa_resource_asgn_curr prac
6100: WHERE prac.resource_assignment_id = p_resource_assignment_id
6101: AND rownum = 1;

Line 6104: CURSOR get_bl_currency_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS

6100: WHERE prac.resource_assignment_id = p_resource_assignment_id
6101: AND rownum = 1;
6102:
6103: /* Commented for bug 9675606
6104: CURSOR get_bl_currency_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
6105: SELECT bl.txn_currency_code as txn_currency_code
6106: FROM pa_budget_lines bl
6107: WHERE bl.resource_assignment_id = p_resource_assignment_id
6108: AND rownum = 1;

Line 6163: from pa_resource_assignments

6159: CURSOR get_task_level_record IS
6160:
6161: select resource_assignment_id
6162:
6163: from pa_resource_assignments
6164:
6165: where ta_display_flag = 'N'
6166:
6167: and wbs_element_version_id = p_element_version_id