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 729: PA_TASKS.TASK_ID%TYPE,

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

Line 737: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,

733: PA_BUDGET_LINES.txn_currency_code%TYPE,
734: X_RES_FORMAT_ID OUT NOCOPY
735: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,
736: X_RESOURCE_ASN_REC OUT NOCOPY RESOURCE_ASN_REC,
737: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,
738: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,
739: X_PROJ_FP_OPTIONS_REC OUT NOCOPY PROJ_FP_OPTIONS_REC,
740: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
741: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 779: FROM pa_tasks t

775: ,labor_bill_rate_org_id
776: ,labor_sch_type
777: ,non_labor_sch_type
778: ,top_task_id
779: FROM pa_tasks t
780: WHERE t.task_id = c_task_id;
781:
782: --get_tasks_rec get_tasks_csr%ROWTYPE;
783:

Line 888: -- Local variables for pa_tasks table

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

Line 889: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%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;
891: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;

Line 890: l_task_sch_discount pa_tasks.non_labor_schedule_discount%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;
891: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;

Line 891: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%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;
891: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;

Line 892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;

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;
891: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;

Line 893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;

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;
891: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;

Line 894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;

890: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;
891: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
898: l_top_task_id pa_tasks.top_task_id%TYPE;

Line 895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;

891: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
898: l_top_task_id pa_tasks.top_task_id%TYPE;
899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;

Line 896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;

892: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
898: l_top_task_id pa_tasks.top_task_id%TYPE;
899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
900:

Line 897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;

893: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
898: l_top_task_id pa_tasks.top_task_id%TYPE;
899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
900:
901: -- Local variables for pa_projects_all table

Line 898: l_top_task_id pa_tasks.top_task_id%TYPE;

894: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
898: l_top_task_id pa_tasks.top_task_id%TYPE;
899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
900:
901: -- Local variables for pa_projects_all table
902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;

Line 899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;

895: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
896: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
898: l_top_task_id pa_tasks.top_task_id%TYPE;
899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
900:
901: -- Local variables for pa_projects_all table
902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

Line 1027: FETCH get_tasks_csr INTO x_pa_tasks_rec;

1023: l_proj_non_labor_sch_type := get_projects_all_rec.non_labor_sch_type; */
1024:
1025:
1026: OPEN get_tasks_csr(p_task_id);
1027: FETCH get_tasks_csr INTO x_pa_tasks_rec;
1028: CLOSE get_tasks_csr;
1029:
1030: /*
1031: IF get_tasks_csr%NOTFOUND THEN

Line 1675: FROM pa_tasks

1671: END IF;
1672: IF l_wp_track_cost_flag = 'N' AND
1673: l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1674: SELECT COUNT(*) INTO l_count
1675: FROM pa_tasks
1676: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1677: AND (gen_etc_source_code = 'WORKPLAN_RESOURCES'
1678: OR gen_etc_source_code = 'WORK_QUANTITY')
1679: AND rownum < 2;

Line 1790: FROM pa_tasks

1786: l_gen_src_code IN ('WORKPLAN_RESOURCES','TASK_LEVEL_SEL') THEN
1787:
1788: IF l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1789: SELECT COUNT(*) INTO l_count
1790: FROM pa_tasks
1791: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1792: AND (gen_etc_source_code = 'WORKPLAN_RESOURCES'
1793: OR gen_etc_source_code = 'WORK_QUANTITY')
1794: AND rownum < 2;

Line 1844: FROM pa_tasks

1840: l_gen_src_code IN ('FINANCIAL_PLAN','TASK_LEVEL_SEL') THEN
1841:
1842: IF l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1843: SELECT COUNT(*) INTO l_count
1844: FROM pa_tasks
1845: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1846: AND gen_etc_source_code = 'FINANCIAL_PLAN'
1847: AND rownum < 2;
1848: END IF;

Line 1983: FROM pa_tasks

1979: SELECT 1 INTO l_count
1980: FROM DUAL
1981: WHERE EXISTS
1982: ( SELECT null
1983: FROM pa_tasks
1984: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1985: AND gen_etc_source_code IN ('WORKPLAN_RESOURCES','WORK_QUANTITY') );
1986: EXCEPTION
1987: WHEN NO_DATA_FOUND THEN

Line 2037: FROM pa_tasks

2033: SELECT 1 INTO l_count
2034: FROM DUAL
2035: WHERE EXISTS
2036: ( SELECT null
2037: FROM pa_tasks
2038: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
2039: AND gen_etc_source_code = 'FINANCIAL_PLAN' );
2040: EXCEPTION
2041: WHEN NO_DATA_FOUND THEN