APPS.PA_FP_GEN_FCST_PG_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1037: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;

1033: l_msg_data VARCHAR2(2000);
1034: l_data VARCHAR2(2000);
1035: l_msg_index_out NUMBER:=0;
1036:
1037: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;
1038: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;
1039: l_sysdate DATE;
1040:
1041: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

Line 1038: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;

1034: l_data VARCHAR2(2000);
1035: l_msg_index_out NUMBER:=0;
1036:
1037: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;
1038: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;
1039: l_sysdate DATE;
1040:
1041: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
1042: l_wp_version_id number;

Line 1358: DELETE FROM pa_resource_assignments

1354: IF p_ret_manual_lns_flag = 'N' THEN
1355: DELETE FROM pa_budget_lines
1356: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1357:
1358: DELETE FROM pa_resource_assignments
1359: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1360:
1361: -- IPM: New Entity ER ------------------------------------------
1362: -- Call the maintenance api in DELETE mode

Line 1400: UPDATE pa_resource_assignments

1396:
1397: -- 8947560: As per functional requirement, we need to retain the user
1398: -- entered etc values for the generated lines with etc source of None
1399: -- i.e. these lines should be treated similar to manually added lines
1400: UPDATE pa_resource_assignments
1401: SET transaction_source_code = NULL
1402: WHERE budget_version_id = p_budget_version_id AND
1403: transaction_source_code = 'NONE';
1404:

Line 1418: FROM PA_RESOURCE_ASSIGNMENTS

1414: /* Bug 4227963: Clean up additional options' budget line data. */
1415: SELECT resource_assignment_id
1416: BULK COLLECT INTO
1417: l_res_asg_id_del_tab
1418: FROM PA_RESOURCE_ASSIGNMENTS
1419: WHERE budget_version_id = p_budget_version_id AND
1420: transaction_source_code IS NOT NULL;
1421:
1422: IF (l_res_asg_id_del_tab.count > 0) THEN

Line 1428: UPDATE PA_RESOURCE_ASSIGNMENTS

1424: DELETE FROM PA_BUDGET_LINES
1425: WHERE resource_assignment_id = l_res_asg_id_del_tab(i);
1426:
1427: FORALL j IN 1 .. l_res_asg_id_del_tab.count
1428: UPDATE PA_RESOURCE_ASSIGNMENTS
1429: SET transaction_source_code = null
1430: WHERE resource_assignment_id = l_res_asg_id_del_tab(j);
1431:
1432: -- IPM: New Entity ER ------------------------------------------