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 148: FROM pa_resource_assignments ra

144: l_exists varchar2(1) := 'N';
145:
146: CURSOR C1_Check_Exists(p_element_version_id IN NUMBER) IS
147: SELECT 'Y'
148: FROM pa_resource_assignments ra
149: WHERE ra.ta_display_flag = 'Y'
150: AND ra.wbs_element_version_id = p_element_version_id
151: AND rownum = 1;
152:

Line 230: FROM pa_resource_assignments ra, pa_map_wp_to_fin_tasks_v map

226:
227: --CURSOR C1_Check_Exists(p_wp_task_id IN NUMBER, p_ei_date IN DATE) IS
228: CURSOR C1_Check_Exists(p_ei_date IN DATE, p_project_id IN NUMBER) IS
229: SELECT 'Y'
230: FROM pa_resource_assignments ra, pa_map_wp_to_fin_tasks_v map
231: WHERE p_ei_date BETWEEN ra.planning_start_date AND ra.planning_end_Date
232: AND ra.person_id = p_person_id
233: AND ra.ta_display_flag = 'Y'
234: AND ra.wbs_element_version_id = map.element_version_id

Line 538: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks

534: SELECT ra.resource_assignment_id, ra.total_plan_quantity,
535: tasks.src_elem_ver_id, tasks.new_task_sch_start, tasks.new_task_sch_end
536: BULK COLLECT INTO l_use_task_sch_asgmt_tbl, l_use_task_quantity_tbl,
537: l_use_task_task_ver_tbl, l_use_task_new_sch_start, l_use_task_new_sch_end --Bug 4153366
538: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks
539: WHERE ra.use_task_schedule_flag = 'Y'
540: AND ra.ta_display_flag is not null
541: AND ra.budget_version_id = l_budget_ver_id -- Bug 4229020
542: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;

Line 569: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks

565: tasks.src_elem_ver_id
566: BULK COLLECT INTO
567: l_adj_dates_asgmt_tbl, l_adj_task_quantity_tbl, l_delay_tbl, l_duration_tbl,
568: 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
569: FROM pa_resource_assignments ra, pa_copy_asgmts_temp tasks
570: WHERE nvl(ra.use_task_schedule_flag, 'N') <> 'Y'
571: AND ra.ta_display_flag is not null
572: AND ra.budget_version_id = l_budget_ver_id
573: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;

Line 1195: UPDATE pa_resource_assignments

1191: -- p_task_assignment_tbl(1).unplanned_flag = FND_API.G_MISS_CHAR OR
1192: -- p_task_assignment_tbl(1).unplanned_flag <> 'Y') THEN
1193:
1194: FORALL k IN l_task_rec_project_id_tbl.FIRST .. l_task_rec_project_id_tbl.LAST
1195: UPDATE pa_resource_assignments
1196: SET ta_display_flag = 'Y',
1197: record_version_number = record_version_number + 1
1198: WHERE project_id = l_task_rec_project_id_tbl(k)
1199: AND wbs_element_version_id = l_task_rec_task_ver_id_tbl(k)

Line 1338: FROM pa_resource_assignments

1334: AND pev.project_id = pevs.project_id;
1335:
1336: CURSOR C_Res_Assignment_Info(p_resource_assignment_id IN NUMBER) IS
1337: SELECT *
1338: FROM pa_resource_assignments
1339: WHERE resource_assignment_id = p_resource_assignment_id;
1340:
1341: CURSOR C_Budget_Version_Info (p_resource_assignment_id IN NUMBER) IS
1342: SELECT budget_version_id

Line 1343: FROM pa_resource_assignments

1339: WHERE resource_assignment_id = p_resource_assignment_id;
1340:
1341: CURSOR C_Budget_Version_Info (p_resource_assignment_id IN NUMBER) IS
1342: SELECT budget_version_id
1343: FROM pa_resource_assignments
1344: WHERE resource_assignment_id = p_resource_assignment_id;
1345:
1346: CURSOR C2_Task_Effort_Assignment(p_resource_assignment_id IN NUMBER) IS
1347: SELECT ra.ta_display_flag, ra.resource_list_member_id, ra.project_id, ra.task_id, bv.project_structure_version_id

Line 1348: FROM pa_resource_assignments ra, pa_budget_versions bv

1344: WHERE resource_assignment_id = p_resource_assignment_id;
1345:
1346: CURSOR C2_Task_Effort_Assignment(p_resource_assignment_id IN NUMBER) IS
1347: SELECT ra.ta_display_flag, ra.resource_list_member_id, ra.project_id, ra.task_id, bv.project_structure_version_id
1348: FROM pa_resource_assignments ra, pa_budget_versions bv
1349: WHERE ra.resource_assignment_id = p_resource_assignment_id
1350: AND ra.budget_version_id = bv.budget_version_id;
1351:
1352: CURSOR C_Get_Actuals(p_resource_assignment_id IN NUMBER) IS

Line 1361: FROM pa_resource_assignments

1357: and rownum = 1;
1358:
1359: CURSOR C_Get_Project_Id IS
1360: SELECT project_id
1361: FROM pa_resource_assignments
1362: WHERE resource_assignment_id = p_task_assignment_tbl(1).resource_assignment_id;
1363:
1364: R_Res_Assignment_Rec C_Res_Assignment_Info%ROWTYPE;
1365: l_proj_element_id NUMBER;

Line 1540: UPDATE pa_resource_assignments

1536:
1537: IF l_rlm_id <> p_task_assignment_tbl(i).resource_list_member_id AND
1538: l_ta_display_flag = 'N' THEN
1539:
1540: UPDATE pa_resource_assignments
1541: SET ta_display_flag = 'Y'
1542: WHERE resource_assignment_id = p_task_assignment_tbl(i).resource_assignment_id;
1543:
1544: END IF; -- l_rlm_id <> p_task_assignment_tbl(i).resource_list_member_id

Line 2316: FROM pa_resource_assignments ra, pa_proj_element_versions pev

2312: WHERE pev.element_version_id = p_wbs_element_version_id AND pe.proj_element_id = pev.proj_element_id;
2313:
2314: CURSOR C_Element_Info2(p_resource_assignment_id IN NUMBER) IS
2315: 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
2316: FROM pa_resource_assignments ra, pa_proj_element_versions pev
2317: WHERE resource_assignment_id = p_resource_assignment_id
2318: and pev.element_version_id = ra.wbs_element_version_id;
2319:
2320: CURSOR C_Task_Asgmts(p_element_version_id IN NUMBER) IS

Line 2322: FROM pa_resource_assignments

2318: and pev.element_version_id = ra.wbs_element_version_id;
2319:
2320: CURSOR C_Task_Asgmts(p_element_version_id IN NUMBER) IS
2321: SELECT resource_assignment_id
2322: FROM pa_resource_assignments
2323: WHERE wbs_element_version_id = p_element_version_id;
2324:
2325: -- Bug 4492493: Check if Progress Rollup is required on DELETION
2326: CURSOR C_Planned_Effort_Exists(p_element_version_id IN NUMBER) IS

Line 2328: FROM pa_resource_assignments

2324:
2325: -- Bug 4492493: Check if Progress Rollup is required on DELETION
2326: CURSOR C_Planned_Effort_Exists(p_element_version_id IN NUMBER) IS
2327: SELECT 'Y'
2328: FROM pa_resource_assignments
2329: WHERE wbs_element_version_id = p_element_version_id
2330: AND total_plan_quantity > 0
2331: AND rownum = 1;
2332:

Line 2335: FROM pa_resource_assignments

2331: AND rownum = 1;
2332:
2333: CURSOR C_Asgmt_Planned_Effort_Exists(p_resource_assignment_id IN NUMBER) IS
2334: SELECT 'Y'
2335: FROM pa_resource_assignments
2336: WHERE resource_assignment_id = p_resource_assignment_id
2337: AND total_plan_quantity > 0;
2338:
2339: CURSOR C_Task_Get_Project_Id(p_elem_version_id IN NUMBER) IS

Line 2346: FROM pa_resource_assignments

2342: WHERE element_version_id = p_elem_version_id;
2343:
2344: CURSOR C_Asgmt_Get_Project_Id(p_resource_assignment_id IN NUMBER) IS
2345: SELECT project_id
2346: FROM pa_resource_assignments
2347: WHERE resource_assignment_id = p_resource_assignment_id;
2348:
2349: -- End of Bug 4492493
2350:

Line 2764: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;

2760: l_people_class_index NUMBER := -999;
2761: l_equip_class_index NUMBER := -999;
2762: l_mat_item_class_index NUMBER := -999;
2763: l_fin_elem_class_index NUMBER := -999;
2764: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2765: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2766: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2767: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;

Line 2765: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

2761: l_equip_class_index NUMBER := -999;
2762: l_mat_item_class_index NUMBER := -999;
2763: l_fin_elem_class_index NUMBER := -999;
2764: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2765: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2766: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2767: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;

Line 2766: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;

2762: l_mat_item_class_index NUMBER := -999;
2763: l_fin_elem_class_index NUMBER := -999;
2764: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2765: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2766: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2767: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2770: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

Line 2767: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;

2763: l_fin_elem_class_index NUMBER := -999;
2764: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2765: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2766: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2767: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2770: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2771: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;

2764: l_ta_res_type_code pa_resource_assignments.res_type_code%TYPE;
2765: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2766: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2767: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2770: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2771: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2772: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;

Line 2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;

2765: l_ta_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
2766: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2767: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2770: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2771: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2772: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2773: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

Line 2770: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

2766: l_ta_resource_class_flag pa_resource_assignments.resource_class_flag%TYPE;
2767: l_ta_total_plan_quantity pa_resource_assignments.total_plan_quantity%TYPE;
2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2770: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2771: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2772: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2773: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2774: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

Line 2772: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;

2768: l_ta_total_plan_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE;
2769: l_ta_total_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
2770: l_ta_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
2771: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2772: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2773: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2774: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
2775: l_ta_task_id pa_resource_assignments.task_id%TYPE;
2776: l_ta_res_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 2775: l_ta_task_id pa_resource_assignments.task_id%TYPE;

2771: l_ta_tar_res_mem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2772: l_ta_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2773: l_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
2774: l_ta_tr_res_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
2775: l_ta_task_id pa_resource_assignments.task_id%TYPE;
2776: l_ta_res_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2777: l_ta_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2778: l_ta_resource_class_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2779: l_ta_total_plan_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2792: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;

2788: l_add_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2789: l_ta_tr_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2790: l_add_projfunc_cur_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2791: l_ta_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2792: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2793: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2794: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2795: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2796: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 2911: pa_resource_assignments ra,

2907: ra.inventory_item_id
2908: FROM
2909: pa_copy_asgmts_temp temp,
2910: pa_proj_element_versions pev,
2911: pa_resource_assignments ra,
2912: pa_project_assignments asgn,
2913: pa_budget_lines bl,
2914: pa_resource_list_members rlm,
2915: pa_res_formats_b rf

Line 3004: pa_resource_assignments ra,

3000: ra.inventory_item_id
3001: FROM
3002: pa_copy_asgmts_temp temp,
3003: pa_proj_element_versions pev,
3004: pa_resource_assignments ra,
3005: pa_project_assignments asgn,
3006: pa_resource_list_members rlm,
3007: pa_res_formats_b rf
3008: WHERE

Line 3067: pa_resource_assignments ra,

3063: ra.inventory_item_id
3064: FROM
3065: pa_copy_asgmts_temp temp,
3066: pa_proj_element_versions pev,
3067: pa_resource_assignments ra,
3068: pa_project_assignments asgn,
3069: pa_budget_lines bl,
3070: pa_resource_list_members source_rlm,
3071: pa_resource_list_members target_rlm,

Line 3167: pa_resource_assignments ra,

3163: ra.inventory_item_id
3164: FROM
3165: pa_copy_asgmts_temp temp,
3166: pa_proj_element_versions pev,
3167: pa_resource_assignments ra,
3168: pa_project_assignments asgn,
3169: pa_resource_list_members source_rlm,
3170: pa_resource_list_members target_rlm,
3171: pa_res_formats_b rf

Line 4984: FROM pa_resource_assignments

4980: l_wbs_element_version_id number;
4981:
4982: CURSOR C_Wbs_Element_Version_Id(p_resource_assignment_id IN NUMBER) IS
4983: SELECT wbs_element_version_id
4984: FROM pa_resource_assignments
4985: WHERE resource_assignment_id = p_resource_assignment_id;
4986:
4987: CURSOR C_structure_Version_Id(p_element_version_id IN NUMBER) IS
4988: SELECT parent_structure_version_id, project_id

Line 5168: from pa_resource_assignments ra

5164: L_FuncProc varchar2(250) ;
5165:
5166: Cursor C_Min_Date IS
5167: select min(ra.SCHEDULE_START_DATE)
5168: from pa_resource_assignments ra
5169: where resource_list_member_id = p_resource_list_member_id
5170: and project_id = p_project_id
5171: and budget_version_id = p_budget_version_id
5172: and ('Y' <> p_unstaffed_only or nvl(project_assignment_id, -1) = -1);

Line 5176: from pa_resource_assignments ra

5172: and ('Y' <> p_unstaffed_only or nvl(project_assignment_id, -1) = -1);
5173:
5174: Cursor C_Max_Date IS
5175: select max(ra.SCHEDULE_END_DATE)
5176: from pa_resource_assignments ra
5177: where resource_list_member_id = p_resource_list_member_id
5178: and project_id = p_project_id
5179: and budget_version_id = p_budget_version_id
5180: and ('Y' <> p_unstaffed_only or nvl(project_assignment_id, -1) = -1);

Line 5240: from pa_resource_assignments ra

5236: L_FuncProc varchar2(250) ;
5237:
5238: Cursor C_Single_UOM IS
5239: select count(distinct ra.unit_of_measure) cnt
5240: from pa_resource_assignments ra
5241: where ta_display_flag = 'Y' and
5242: ra.project_id = p_project_id and
5243: ra.budget_version_id = p_budget_version_id and
5244: ra.resource_class_code = p_class;

Line 5492: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

5488: p_project_id IN pa_projects_all.project_id%TYPE,
5489:
5490: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5491:
5492: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5493:
5494: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5495:
5496: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

Line 5512: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

5508: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5509:
5510: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5511:
5512: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5513:
5514: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5515:
5516:

Line 5514: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;

5510: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5511:
5512: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5513:
5514: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5515:
5516:
5517: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5518:

Line 5529: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;

5525:
5526:
5527: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5528:
5529: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5530:
5531: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5532:
5533: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5531: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;

5527: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5528:
5529: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5530:
5531: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5532:
5533: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5534:
5535: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

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

5556:
5557: l_msg_data VARCHAR2(200);
5558:
5559:
5560: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5561: SELECT bl.txn_currency_code
5562: FROM pa_budget_lines bl
5563: WHERE bl.resource_assignment_id = p_resource_assignment_id
5564: AND rownum = 1;

Line 5675: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

5671: p_project_id IN pa_projects_all.project_id%TYPE,
5672:
5673: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5674:
5675: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5676:
5677: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5678:
5679: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

Line 5695: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

5691: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5692:
5693: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5694:
5695: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5696:
5697: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5698:
5699:

Line 5697: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;

5693: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5694:
5695: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5696:
5697: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5698:
5699:
5700: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5701:

Line 5712: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;

5708:
5709:
5710: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5711:
5712: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5713:
5714: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5715:
5716: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5714: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;

5710: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5711:
5712: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5713:
5714: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5715:
5716: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5717:
5718: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

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

5739:
5740: l_msg_data VARCHAR2(200);
5741:
5742:
5743: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5744: SELECT bl.txn_currency_code
5745: FROM pa_budget_lines bl
5746: WHERE bl.resource_assignment_id = p_resource_assignment_id
5747: AND rownum = 1;

Line 5861: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

5857:
5858: /* Commented for 4994791
5859:
5860: FUNCTION get_planned_asgmt_amounts(
5861: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5862: p_code IN VARCHAR2) RETURN NUMBER IS
5863:
5864:
5865: CURSOR get_resource_assignment_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS

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

5861: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5862: p_code IN VARCHAR2) RETURN NUMBER IS
5863:
5864:
5865: CURSOR get_resource_assignment_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5866:
5867: SELECT
5868: SUM(bl.quantity) as planned_quantity,
5869: SUM(bl.txn_burdened_cost) as planned_bur_cost_txn_cur,

Line 5974: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

5970:
5971:
5972: FUNCTION get_planned_currency_info (
5973:
5974: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5975:
5976: p_project_id IN pa_projects_all.project_id%TYPE,
5977:
5978: p_code IN VARCHAR2) RETURN VARCHAR2 IS

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

5976: p_project_id IN pa_projects_all.project_id%TYPE,
5977:
5978: p_code IN VARCHAR2) RETURN VARCHAR2 IS
5979:
5980: CURSOR get_bl_currency_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5981: SELECT bl.txn_currency_code as txn_currency_code
5982: FROM pa_budget_lines bl
5983: WHERE bl.resource_assignment_id = p_resource_assignment_id
5984: AND rownum = 1;

Line 6038: from pa_resource_assignments

6034: CURSOR get_task_level_record IS
6035:
6036: select resource_assignment_id
6037:
6038: from pa_resource_assignments
6039:
6040: where ta_display_flag = 'N'
6041:
6042: and wbs_element_version_id = p_element_version_id