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

Line 8433: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;

8429: l_task_id pa_tasks.task_id%TYPE := P_task_id; --bug 3860575, Satish
8430: l_top_task_id pa_tasks.task_id%TYPE;
8431: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8432: l_project_type pa_projects_all.project_type%TYPE;
8433: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8434: l_org_id pa_projects_all.org_id%TYPE;
8435: l_expenditure_OU pa_projects_all.org_id%TYPE;
8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;

Line 8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

8432: l_project_type pa_projects_all.project_type%TYPE;
8433: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8434: l_org_id pa_projects_all.org_id%TYPE;
8435: l_expenditure_OU pa_projects_all.org_id%TYPE;
8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8440: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;

Line 8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;

8433: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8434: l_org_id pa_projects_all.org_id%TYPE;
8435: l_expenditure_OU pa_projects_all.org_id%TYPE;
8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8440: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8441: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;

Line 8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;

8434: l_org_id pa_projects_all.org_id%TYPE;
8435: l_expenditure_OU pa_projects_all.org_id%TYPE;
8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8440: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8441: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8442: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;

Line 8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;

8435: l_expenditure_OU pa_projects_all.org_id%TYPE;
8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8440: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8441: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8442: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
8443: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;

Line 8440: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;

8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8440: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8441: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8442: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
8443: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8444: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;

Line 8441: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;

8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8440: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8441: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8442: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
8443: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8444: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
8445: -- l_burden_override_multiplier pa_fp_res_assignments_tmp.b_multiplier_override%TYPE;

Line 8442: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;

8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8440: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8441: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8442: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
8443: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8444: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
8445: -- l_burden_override_multiplier pa_fp_res_assignments_tmp.b_multiplier_override%TYPE;
8446: l_burden_override_multiplier Number;

Line 8454: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;

8450: l_new_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8451: -- added for Bug: 4537865
8452: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8453: l_burden_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8454: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
8455: l_mfc_cost_source CONSTANT NUMBER := 2;
8456: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
8457: l_job_id pa_resource_assignments.job_id%TYPE;
8458: l_person_id pa_resource_list_members.person_id%TYPE;

Line 8456: l_item_category_id pa_resource_assignments.item_category_id%TYPE;

8452: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8453: l_burden_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8454: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
8455: l_mfc_cost_source CONSTANT NUMBER := 2;
8456: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
8457: l_job_id pa_resource_assignments.job_id%TYPE;
8458: l_person_id pa_resource_list_members.person_id%TYPE;
8459:
8460: --Out variables

Line 8457: l_job_id pa_resource_assignments.job_id%TYPE;

8453: l_burden_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8454: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
8455: l_mfc_cost_source CONSTANT NUMBER := 2;
8456: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
8457: l_job_id pa_resource_assignments.job_id%TYPE;
8458: l_person_id pa_resource_list_members.person_id%TYPE;
8459:
8460: --Out variables
8461: l_trxn_curr_code varchar2(100);

Line 8576: FROM pa_resource_assignments pra, ----pa_task_assignments_v 4871809

8572: pra.unit_of_measure,
8573: pra.rate_based_flag,
8574: pra.resource_assignment_id,
8575: rlm.alias
8576: FROM pa_resource_assignments pra, ----pa_task_assignments_v 4871809
8577: pa_budget_versions pbv,
8578: pa_resource_list_members rlm
8579: WHERE pbv.project_structure_version_id = c_structure_version_id
8580: AND pbv.budget_version_id = pra.budget_version_id

Line 10146: pa_resource_assignments ra,

10142: pr.txn_currency_code
10143: FROM
10144: pa_proj_element_versions pev,
10145: pa_proj_elements pe,
10146: pa_resource_assignments ra,
10147: pa_resource_list_members rlm,
10148: pa_budget_lines bl,
10149: pa_progress_rollup pr
10150: WHERE

Line 10288: pa_resource_assignments ra,

10284: rat.schedule_end_date,
10285: decode(pr.structure_version_id, NULL, 'Y', 'N')
10286: FROM
10287: pa_res_asgmts_temp rat,
10288: pa_resource_assignments ra,
10289: pa_proj_element_versions pev,
10290: pa_progress_rollup pr
10291: WHERE
10292: ra.resource_assignment_id = rat.resource_assignment_id AND

Line 10549: FROM pa_resource_assignments pra,

10545: cursor cur_ptav is
10546: select pra.total_project_burdened_cost as planned_bur_cost_proj_cur
10547: , pra.resource_assignment_id -- Bug 4372462
10548: , pra.budget_version_id -- Bug 4372462
10549: FROM pa_resource_assignments pra,
10550: PA_PROJ_ELEMENT_VERSIONS PPEV
10551: where pra.resource_list_member_id = p_resource_list_mem_id
10552: and pra.task_id = p_task_id
10553: AND PPEV.PROJECT_ID = p_project_id

Line 11596: pa_resource_assignments pra

11592: x_brdncost_pc,
11593: x_rawcost_fc,
11594: x_brdncost_fc
11595: FROM pa_budget_lines pbl,
11596: pa_resource_assignments pra
11597: WHERE pra.budget_version_id=p_budget_version_id
11598: AND pra.project_id=p_project_id
11599: AND pra.task_id=p_task_id
11600: AND pra.resource_list_member_id=p_resource_list_mem_id

Line 12612: pa_resource_assignments pra,

12608: p_element_ver_id IN NUMBER ) return varchar2 is
12609: cursor C_TA_PROG_CURSOR is
12610: select 'Y'
12611: from
12612: pa_resource_assignments pra,
12613: pa_progress_rollup ppr
12614: where pra.ta_display_flag = 'N'
12615: and pra.wbs_element_version_id = p_element_ver_id
12616: and pra.project_id = p_project_id