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_TASKS

Line 709: PA_TASKS.TASK_ID%TYPE,

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,
712: P_TXN_CURRENCY_CODE IN
713: PA_BUDGET_LINES.txn_currency_code%TYPE,

Line 717: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,

713: PA_BUDGET_LINES.txn_currency_code%TYPE,
714: X_RES_FORMAT_ID OUT NOCOPY
715: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,
716: X_RESOURCE_ASN_REC OUT NOCOPY RESOURCE_ASN_REC,
717: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,
718: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,
719: X_PROJ_FP_OPTIONS_REC OUT NOCOPY PROJ_FP_OPTIONS_REC,
720: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
721: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 759: FROM pa_tasks t

755: ,labor_bill_rate_org_id
756: ,labor_sch_type
757: ,non_labor_sch_type
758: ,top_task_id
759: FROM pa_tasks t
760: WHERE t.task_id = c_task_id;
761:
762: --get_tasks_rec get_tasks_csr%ROWTYPE;
763:

Line 868: -- Local variables for pa_tasks table

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;
871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;

Line 869: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%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;
871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;

Line 870: l_task_sch_discount pa_tasks.non_labor_schedule_discount%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;
871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;

Line 871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%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;
871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;

Line 872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;

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;
871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;

Line 873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;

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;
871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;

Line 874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;

870: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;
871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
878: l_top_task_id pa_tasks.top_task_id%TYPE;

Line 875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;

871: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
878: l_top_task_id pa_tasks.top_task_id%TYPE;
879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;

Line 876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;

872: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
878: l_top_task_id pa_tasks.top_task_id%TYPE;
879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
880:

Line 877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;

873: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
878: l_top_task_id pa_tasks.top_task_id%TYPE;
879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
880:
881: -- Local variables for pa_projects_all table

Line 878: l_top_task_id pa_tasks.top_task_id%TYPE;

874: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
878: l_top_task_id pa_tasks.top_task_id%TYPE;
879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
880:
881: -- Local variables for pa_projects_all table
882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;

Line 879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;

875: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
876: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
878: l_top_task_id pa_tasks.top_task_id%TYPE;
879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
880:
881: -- Local variables for pa_projects_all table
882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

Line 1007: FETCH get_tasks_csr INTO x_pa_tasks_rec;

1003: l_proj_non_labor_sch_type := get_projects_all_rec.non_labor_sch_type; */
1004:
1005:
1006: OPEN get_tasks_csr(p_task_id);
1007: FETCH get_tasks_csr INTO x_pa_tasks_rec;
1008: CLOSE get_tasks_csr;
1009:
1010: /*
1011: IF get_tasks_csr%NOTFOUND THEN

Line 1652: FROM pa_tasks

1648: END IF;
1649: IF l_wp_track_cost_flag = 'N' AND
1650: l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1651: SELECT COUNT(*) INTO l_count
1652: FROM pa_tasks
1653: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1654: AND (gen_etc_source_code = 'WORKPLAN_RESOURCES'
1655: OR gen_etc_source_code = 'WORK_QUANTITY')
1656: AND rownum < 2;

Line 1709: FROM pa_tasks

1705: l_gen_src_code IN ('WORKPLAN_RESOURCES','TASK_LEVEL_SEL') THEN
1706:
1707: IF l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1708: SELECT COUNT(*) INTO l_count
1709: FROM pa_tasks
1710: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1711: AND (gen_etc_source_code = 'WORKPLAN_RESOURCES'
1712: OR gen_etc_source_code = 'WORK_QUANTITY')
1713: AND rownum < 2;

Line 1763: FROM pa_tasks

1759: l_gen_src_code IN ('FINANCIAL_PLAN','TASK_LEVEL_SEL') THEN
1760:
1761: IF l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1762: SELECT COUNT(*) INTO l_count
1763: FROM pa_tasks
1764: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1765: AND gen_etc_source_code = 'FINANCIAL_PLAN'
1766: AND rownum < 2;
1767: END IF;

Line 1902: FROM pa_tasks

1898: SELECT 1 INTO l_count
1899: FROM DUAL
1900: WHERE EXISTS
1901: ( SELECT null
1902: FROM pa_tasks
1903: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1904: AND gen_etc_source_code IN ('WORKPLAN_RESOURCES','WORK_QUANTITY') );
1905: EXCEPTION
1906: WHEN NO_DATA_FOUND THEN

Line 1956: FROM pa_tasks

1952: SELECT 1 INTO l_count
1953: FROM DUAL
1954: WHERE EXISTS
1955: ( SELECT null
1956: FROM pa_tasks
1957: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1958: AND gen_etc_source_code = 'FINANCIAL_PLAN' );
1959: EXCEPTION
1960: WHEN NO_DATA_FOUND THEN