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

Line 707: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

703: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
704: P_BUDGET_VERSION_ID IN
705: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
706: P_RESOURCE_ASSIGNMENT_ID IN
707: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
708: P_TASK_ID IN
709: PA_TASKS.TASK_ID%TYPE,
710: P_RESOURCE_LIST_MEMBER_ID IN
711: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,

Line 711: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,

707: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
708: P_TASK_ID IN
709: PA_TASKS.TASK_ID%TYPE,
710: P_RESOURCE_LIST_MEMBER_ID IN
711: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,
712: P_TXN_CURRENCY_CODE IN
713: PA_BUDGET_LINES.txn_currency_code%TYPE,
714: X_RES_FORMAT_ID OUT NOCOPY
715: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,

Line 743: FROM pa_resource_assignments ra

739: ,mfc_cost_type_id
740: ,rate_based_flag
741: ,rate_expenditure_org_id
742: ,rate_expenditure_type
743: FROM pa_resource_assignments ra
744: WHERE ra.resource_assignment_id = c_resource_assignment_id;
745:
746: --get_resource_asn_rec get_resource_asn_csr%ROWTYPE;
747:

Line 846: --Local variables for pa_resource_assignments table

842: --get_proj_fp_options_rec get_proj_fp_options_csr%ROWTYPE;
843:
844:
845: /*
846: --Local variables for pa_resource_assignments table
847: g_project_id pa_resource_assignments.project_id%TYPE;
848: l_rate_task_id pa_resource_assignments.task_id%TYPE;
849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

Line 847: g_project_id pa_resource_assignments.project_id%TYPE;

843:
844:
845: /*
846: --Local variables for pa_resource_assignments table
847: g_project_id pa_resource_assignments.project_id%TYPE;
848: l_rate_task_id pa_resource_assignments.task_id%TYPE;
849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
851: l_organization_id pa_resource_assignments.organization_id%TYPE;

Line 848: l_rate_task_id pa_resource_assignments.task_id%TYPE;

844:
845: /*
846: --Local variables for pa_resource_assignments table
847: g_project_id pa_resource_assignments.project_id%TYPE;
848: l_rate_task_id pa_resource_assignments.task_id%TYPE;
849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
851: l_organization_id pa_resource_assignments.organization_id%TYPE;
852: l_job_id pa_resource_assignments.job_id%TYPE;

Line 849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

845: /*
846: --Local variables for pa_resource_assignments table
847: g_project_id pa_resource_assignments.project_id%TYPE;
848: l_rate_task_id pa_resource_assignments.task_id%TYPE;
849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
851: l_organization_id pa_resource_assignments.organization_id%TYPE;
852: l_job_id pa_resource_assignments.job_id%TYPE;
853: l_person_id pa_resource_assignments.person_id%TYPE;

Line 850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

846: --Local variables for pa_resource_assignments table
847: g_project_id pa_resource_assignments.project_id%TYPE;
848: l_rate_task_id pa_resource_assignments.task_id%TYPE;
849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
851: l_organization_id pa_resource_assignments.organization_id%TYPE;
852: l_job_id pa_resource_assignments.job_id%TYPE;
853: l_person_id pa_resource_assignments.person_id%TYPE;
854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;

Line 851: l_organization_id pa_resource_assignments.organization_id%TYPE;

847: g_project_id pa_resource_assignments.project_id%TYPE;
848: l_rate_task_id pa_resource_assignments.task_id%TYPE;
849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
851: l_organization_id pa_resource_assignments.organization_id%TYPE;
852: l_job_id pa_resource_assignments.job_id%TYPE;
853: l_person_id pa_resource_assignments.person_id%TYPE;
854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;

Line 852: l_job_id pa_resource_assignments.job_id%TYPE;

848: l_rate_task_id pa_resource_assignments.task_id%TYPE;
849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
851: l_organization_id pa_resource_assignments.organization_id%TYPE;
852: l_job_id pa_resource_assignments.job_id%TYPE;
853: l_person_id pa_resource_assignments.person_id%TYPE;
854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;

Line 853: l_person_id pa_resource_assignments.person_id%TYPE;

849: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
851: l_organization_id pa_resource_assignments.organization_id%TYPE;
852: l_job_id pa_resource_assignments.job_id%TYPE;
853: l_person_id pa_resource_assignments.person_id%TYPE;
854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;

Line 854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;

850: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
851: l_organization_id pa_resource_assignments.organization_id%TYPE;
852: l_job_id pa_resource_assignments.job_id%TYPE;
853: l_person_id pa_resource_assignments.person_id%TYPE;
854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;

Line 855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;

851: l_organization_id pa_resource_assignments.organization_id%TYPE;
852: l_job_id pa_resource_assignments.job_id%TYPE;
853: l_person_id pa_resource_assignments.person_id%TYPE;
854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;

Line 856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;

852: l_job_id pa_resource_assignments.job_id%TYPE;
853: l_person_id pa_resource_assignments.person_id%TYPE;
854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

Line 857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;

853: l_person_id pa_resource_assignments.person_id%TYPE;
854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;

Line 858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;

854: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;

Line 859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;

855: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;

Line 860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

856: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
864: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;

Line 861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;

857: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
864: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
865: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;

Line 862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;

858: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
864: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
865: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
866: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;

Line 863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;

859: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
864: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
865: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
866: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
867:

Line 864: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;

860: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
864: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
865: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
866: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
867:
868: -- Local variables for pa_tasks table

Line 865: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;

861: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
864: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
865: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
866: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
867:
868: -- Local variables for pa_tasks table
869: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;

Line 866: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;

862: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
863: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
864: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
865: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
866: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
867:
868: -- Local variables for pa_tasks table
869: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;
870: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;

Line 1352: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)

1348: END;
1349:
1350: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1351: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
1352: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)
1353: RETURN NUMBER IS
1354: l_control_flag VARCHAR2(10);
1355: x_rlm_id NUMBER;
1356: BEGIN