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 727: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

723: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
724: P_BUDGET_VERSION_ID IN
725: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
726: P_RESOURCE_ASSIGNMENT_ID IN
727: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
728: P_TASK_ID IN
729: PA_TASKS.TASK_ID%TYPE,
730: P_RESOURCE_LIST_MEMBER_ID IN
731: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,

Line 731: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,

727: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
728: P_TASK_ID IN
729: PA_TASKS.TASK_ID%TYPE,
730: P_RESOURCE_LIST_MEMBER_ID IN
731: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,
732: P_TXN_CURRENCY_CODE IN
733: PA_BUDGET_LINES.txn_currency_code%TYPE,
734: X_RES_FORMAT_ID OUT NOCOPY
735: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,

Line 763: FROM pa_resource_assignments ra

759: ,mfc_cost_type_id
760: ,rate_based_flag
761: ,rate_expenditure_org_id
762: ,rate_expenditure_type
763: FROM pa_resource_assignments ra
764: WHERE ra.resource_assignment_id = c_resource_assignment_id;
765:
766: --get_resource_asn_rec get_resource_asn_csr%ROWTYPE;
767:

Line 866: --Local variables for pa_resource_assignments table

862: --get_proj_fp_options_rec get_proj_fp_options_csr%ROWTYPE;
863:
864:
865: /*
866: --Local variables for pa_resource_assignments table
867: g_project_id pa_resource_assignments.project_id%TYPE;
868: l_rate_task_id pa_resource_assignments.task_id%TYPE;
869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

Line 867: g_project_id pa_resource_assignments.project_id%TYPE;

863:
864:
865: /*
866: --Local variables for pa_resource_assignments table
867: g_project_id pa_resource_assignments.project_id%TYPE;
868: l_rate_task_id pa_resource_assignments.task_id%TYPE;
869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
871: l_organization_id pa_resource_assignments.organization_id%TYPE;

Line 868: l_rate_task_id pa_resource_assignments.task_id%TYPE;

864:
865: /*
866: --Local variables for pa_resource_assignments table
867: g_project_id pa_resource_assignments.project_id%TYPE;
868: l_rate_task_id pa_resource_assignments.task_id%TYPE;
869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
871: l_organization_id pa_resource_assignments.organization_id%TYPE;
872: l_job_id pa_resource_assignments.job_id%TYPE;

Line 869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

865: /*
866: --Local variables for pa_resource_assignments table
867: g_project_id pa_resource_assignments.project_id%TYPE;
868: l_rate_task_id pa_resource_assignments.task_id%TYPE;
869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
871: l_organization_id pa_resource_assignments.organization_id%TYPE;
872: l_job_id pa_resource_assignments.job_id%TYPE;
873: l_person_id pa_resource_assignments.person_id%TYPE;

Line 870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

866: --Local variables for pa_resource_assignments table
867: g_project_id pa_resource_assignments.project_id%TYPE;
868: l_rate_task_id pa_resource_assignments.task_id%TYPE;
869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
871: l_organization_id pa_resource_assignments.organization_id%TYPE;
872: l_job_id pa_resource_assignments.job_id%TYPE;
873: l_person_id pa_resource_assignments.person_id%TYPE;
874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;

Line 871: l_organization_id pa_resource_assignments.organization_id%TYPE;

867: g_project_id pa_resource_assignments.project_id%TYPE;
868: l_rate_task_id pa_resource_assignments.task_id%TYPE;
869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
871: l_organization_id pa_resource_assignments.organization_id%TYPE;
872: l_job_id pa_resource_assignments.job_id%TYPE;
873: l_person_id pa_resource_assignments.person_id%TYPE;
874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;

Line 872: l_job_id pa_resource_assignments.job_id%TYPE;

868: l_rate_task_id pa_resource_assignments.task_id%TYPE;
869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
871: l_organization_id pa_resource_assignments.organization_id%TYPE;
872: l_job_id pa_resource_assignments.job_id%TYPE;
873: l_person_id pa_resource_assignments.person_id%TYPE;
874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;

Line 873: l_person_id pa_resource_assignments.person_id%TYPE;

869: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
871: l_organization_id pa_resource_assignments.organization_id%TYPE;
872: l_job_id pa_resource_assignments.job_id%TYPE;
873: l_person_id pa_resource_assignments.person_id%TYPE;
874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;

Line 874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;

870: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
871: l_organization_id pa_resource_assignments.organization_id%TYPE;
872: l_job_id pa_resource_assignments.job_id%TYPE;
873: l_person_id pa_resource_assignments.person_id%TYPE;
874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;

Line 875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;

871: l_organization_id pa_resource_assignments.organization_id%TYPE;
872: l_job_id pa_resource_assignments.job_id%TYPE;
873: l_person_id pa_resource_assignments.person_id%TYPE;
874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;

Line 876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;

872: l_job_id pa_resource_assignments.job_id%TYPE;
873: l_person_id pa_resource_assignments.person_id%TYPE;
874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

Line 877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;

873: l_person_id pa_resource_assignments.person_id%TYPE;
874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;

Line 878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;

874: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;

Line 879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;

875: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;

Line 880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

876: l_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE;
877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
884: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;

Line 881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;

877: l_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE;
878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
884: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
885: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;

Line 882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;

878: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
884: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
885: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
886: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;

Line 883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;

879: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
884: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
885: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
886: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
887:

Line 884: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;

880: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
884: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
885: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
886: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
887:
888: -- Local variables for pa_tasks table

Line 885: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;

881: l_rate_incurred_by_organz_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE;
882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
884: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
885: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
886: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
887:
888: -- Local variables for pa_tasks table
889: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;

Line 886: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;

882: l_rate_override_to_organz_id pa_resource_assignments.rate_override_to_organz_id%TYPE;
883: l_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE;
884: l_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE;
885: l_rate_organization_id pa_resource_assignments.rate_organization_id%TYPE;
886: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
887:
888: -- Local variables for pa_tasks table
889: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;
890: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;

Line 1372: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)

1368: END;
1369:
1370: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1371: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
1372: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)
1373: RETURN NUMBER IS
1374: l_control_flag VARCHAR2(10);
1375: x_rlm_id NUMBER;
1376: BEGIN