APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_RESOURCE_ASSIGNMENTS_S

Line 1511: SELECT pa_resource_assignments_s.nextval

1507: AND a.resource_list_member_id = l_resource_list_member_id
1508: AND a.project_assignment_id = l_prj_assignment_id;
1509: EXCEPTION
1510: WHEN NO_DATA_FOUND THEN
1511: SELECT pa_resource_assignments_s.nextval
1512: INTO l_resource_assignment_id
1513: FROM sys.dual;
1514: INSERT INTO pa_resource_assignments(
1515: resource_assignment_id,

Line 1659: UPDATE PA_RESOURCE_ASSIGNMENTS SET

1655:
1656:
1657: /* Update only if some fis are processed for the current assignment id */
1658: IF L_BUDGET_LINES_TBL.COUNT > 0 THEN
1659: UPDATE PA_RESOURCE_ASSIGNMENTS SET
1660: TOTAL_PLAN_REVENUE = NVL(TOTAL_PLAN_REVENUE,0) + l_tot_revenue,
1661: TOTAL_PLAN_RAW_COST = NVL(TOTAL_PLAN_RAW_COST,0) + l_tot_cost,
1662: TOTAL_PLAN_BURDENED_COST = NVL(TOTAL_PLAN_BURDENED_COST,0) + l_tot_bcost,
1663: TOTAL_PLAN_QUANTITY = NVL(TOTAL_PLAN_QUANTITY,0) + l_tot_quantity,

Line 1716: SELECT pa_resource_assignments_s.nextval

1712: AND A.PROJECT_ASSIGNMENT_ID = -1
1713: AND A.RESOURCE_LIST_MEMBER_ID = 103;
1714: EXCEPTION
1715: WHEN NO_DATA_FOUND THEN
1716: SELECT pa_resource_assignments_s.nextval
1717: INTO l_prj_res_assignment_id
1718: FROM sys.dual;
1719: insert into pa_resource_assignments(
1720: resource_assignment_id,

Line 1841: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_NO_PRJ_VALUE'

1837: IF l_project_value IS NULL THEN
1838: PA_DEBUG.g_err_stage := '2400: no prj value : bef updating err msg in event Based';
1839: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1840:
1841: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_NO_PRJ_VALUE'
1842: WHERE
1843: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
1844:
1845: l_plan_processing_code := 'E';

Line 1939: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_PDS_NOT_DEFINED'

1935: ELSE
1936: PA_DEBUG.g_err_stage := '2500: no prj value : bef updating err msg in Event Based';
1937: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1938:
1939: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_PDS_NOT_DEFINED'
1940: WHERE
1941: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
1942:
1943: l_plan_processing_code := 'E';

Line 2019: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = l_cost_based_error_code

2015: ELSE
2016: l_plan_processing_code := 'E';
2017: PA_DEBUG.g_err_stage := '2900: bef upd PA_RES_ASG for err code n COST_BASED_REVENUE';
2018: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2019: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = l_cost_based_error_code
2020: WHERE
2021: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
2022: END IF;
2023: ELSE

Line 2027: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_NO_PRJ_VALUE'

2023: ELSE
2024: PA_DEBUG.g_err_stage := '2900: no prj value : bef updating err msg in Cost Based';
2025: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2026:
2027: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_NO_PRJ_VALUE'
2028: WHERE
2029: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
2030:
2031: l_plan_processing_code := 'E';

Line 2076: UPDATE PA_RESOURCE_ASSIGNMENTS SET

2072: BUDGET_VERSION_ID = l_budget_version_id AND
2073: RESOURCE_ASSIGNMENT_ID <> l_prj_res_assignment_id;
2074:
2075: IF l_tot_prj_quantity > 0 AND l_prj_level_revenue IS NOT NULL THEN
2076: UPDATE PA_RESOURCE_ASSIGNMENTS SET
2077: STANDARD_BILL_RATE = l_prj_level_revenue / l_tot_prj_quantity
2078: WHERE
2079: BUDGET_VERSION_ID = l_budget_version_id AND
2080: RESOURCE_ASSIGNMENT_ID = l_prj_res_assignment_id;