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 8387: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;

8383: l_task_id pa_tasks.task_id%TYPE := P_task_id; --bug 3860575, Satish
8384: l_top_task_id pa_tasks.task_id%TYPE;
8385: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8386: l_project_type pa_projects_all.project_type%TYPE;
8387: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8388: l_org_id pa_projects_all.org_id%TYPE;
8389: l_expenditure_OU pa_projects_all.org_id%TYPE;
8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;

Line 8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

8386: l_project_type pa_projects_all.project_type%TYPE;
8387: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8388: l_org_id pa_projects_all.org_id%TYPE;
8389: l_expenditure_OU pa_projects_all.org_id%TYPE;
8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8394: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;

Line 8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;

8387: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8388: l_org_id pa_projects_all.org_id%TYPE;
8389: l_expenditure_OU pa_projects_all.org_id%TYPE;
8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8394: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8395: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;

Line 8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;

8388: l_org_id pa_projects_all.org_id%TYPE;
8389: l_expenditure_OU pa_projects_all.org_id%TYPE;
8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8394: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8395: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8396: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;

Line 8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;

8389: l_expenditure_OU pa_projects_all.org_id%TYPE;
8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8394: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8395: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8396: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
8397: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;

Line 8394: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;

8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8394: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8395: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8396: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
8397: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8398: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;

Line 8395: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;

8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8394: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8395: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8396: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
8397: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8398: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
8399: -- l_burden_override_multiplier pa_fp_res_assignments_tmp.b_multiplier_override%TYPE;

Line 8396: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;

8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;
8394: l_rate_incurred_by_organz_id pa_resource_assignments.organization_id%TYPE;
8395: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
8396: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
8397: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8398: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
8399: -- l_burden_override_multiplier pa_fp_res_assignments_tmp.b_multiplier_override%TYPE;
8400: l_burden_override_multiplier Number;

Line 8408: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;

8404: l_new_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8405: -- added for Bug: 4537865
8406: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8407: l_burden_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8408: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
8409: l_mfc_cost_source CONSTANT NUMBER := 2;
8410: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
8411: l_job_id pa_resource_assignments.job_id%TYPE;
8412: l_person_id pa_resource_list_members.person_id%TYPE;

Line 8410: l_item_category_id pa_resource_assignments.item_category_id%TYPE;

8406: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8407: l_burden_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8408: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
8409: l_mfc_cost_source CONSTANT NUMBER := 2;
8410: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
8411: l_job_id pa_resource_assignments.job_id%TYPE;
8412: l_person_id pa_resource_list_members.person_id%TYPE;
8413:
8414: --Out variables

Line 8411: l_job_id pa_resource_assignments.job_id%TYPE;

8407: l_burden_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8408: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
8409: l_mfc_cost_source CONSTANT NUMBER := 2;
8410: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
8411: l_job_id pa_resource_assignments.job_id%TYPE;
8412: l_person_id pa_resource_list_members.person_id%TYPE;
8413:
8414: --Out variables
8415: l_trxn_curr_code varchar2(100);

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

8526: pra.unit_of_measure,
8527: pra.rate_based_flag,
8528: pra.resource_assignment_id,
8529: rlm.alias
8530: FROM pa_resource_assignments pra, ----pa_task_assignments_v 4871809
8531: pa_budget_versions pbv,
8532: pa_resource_list_members rlm
8533: WHERE pbv.project_structure_version_id = c_structure_version_id
8534: AND pbv.budget_version_id = pra.budget_version_id

Line 10072: pa_resource_assignments ra,

10068: pr.txn_currency_code
10069: FROM
10070: pa_proj_element_versions pev,
10071: pa_proj_elements pe,
10072: pa_resource_assignments ra,
10073: pa_resource_list_members rlm,
10074: pa_budget_lines bl,
10075: pa_progress_rollup pr
10076: WHERE

Line 10214: pa_resource_assignments ra,

10210: rat.schedule_end_date,
10211: decode(pr.structure_version_id, NULL, 'Y', 'N')
10212: FROM
10213: pa_res_asgmts_temp rat,
10214: pa_resource_assignments ra,
10215: pa_proj_element_versions pev,
10216: pa_progress_rollup pr
10217: WHERE
10218: ra.resource_assignment_id = rat.resource_assignment_id AND

Line 10474: FROM pa_resource_assignments pra,

10470: cursor cur_ptav is
10471: select pra.total_project_burdened_cost as planned_bur_cost_proj_cur
10472: , pra.resource_assignment_id -- Bug 4372462
10473: , pra.budget_version_id -- Bug 4372462
10474: FROM pa_resource_assignments pra,
10475: PA_PROJ_ELEMENT_VERSIONS PPEV
10476: where pra.resource_list_member_id = p_resource_list_mem_id
10477: and pra.task_id = p_task_id
10478: AND PPEV.PROJECT_ID = p_project_id

Line 11517: pa_resource_assignments pra

11513: x_brdncost_pc,
11514: x_rawcost_fc,
11515: x_brdncost_fc
11516: FROM pa_budget_lines pbl,
11517: pa_resource_assignments pra
11518: WHERE pra.budget_version_id=p_budget_version_id
11519: AND pra.project_id=p_project_id
11520: AND pra.task_id=p_task_id
11521: AND pra.resource_list_member_id=p_resource_list_mem_id

Line 12518: pa_resource_assignments pra,

12514: p_element_ver_id IN NUMBER ) return varchar2 is
12515: cursor C_TA_PROG_CURSOR is
12516: select 'Y'
12517: from
12518: pa_resource_assignments pra,
12519: pa_progress_rollup ppr
12520: where pra.ta_display_flag = 'N'
12521: and pra.wbs_element_version_id = p_element_ver_id
12522: and pra.project_id = p_project_id