APPS.PA_FP_GEN_FCST_PG_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 852: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;

848: l_msg_data VARCHAR2(2000);
849: l_data VARCHAR2(2000);
850: l_msg_index_out NUMBER:=0;
851:
852: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;
853: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;
854: l_sysdate DATE;
855:
856: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

Line 853: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;

849: l_data VARCHAR2(2000);
850: l_msg_index_out NUMBER:=0;
851:
852: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;
853: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;
854: l_sysdate DATE;
855:
856: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
857: l_wp_version_id number;

Line 1085: DELETE FROM pa_resource_assignments

1081: IF p_ret_manual_lns_flag = 'N' THEN
1082: DELETE FROM pa_budget_lines
1083: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1084:
1085: DELETE FROM pa_resource_assignments
1086: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1087:
1088: -- IPM: New Entity ER ------------------------------------------
1089: -- Call the maintenance api in DELETE mode

Line 1137: FROM PA_RESOURCE_ASSIGNMENTS

1133: /* Bug 4227963: Clean up additional options' budget line data. */
1134: SELECT resource_assignment_id
1135: BULK COLLECT INTO
1136: l_res_asg_id_del_tab
1137: FROM PA_RESOURCE_ASSIGNMENTS
1138: WHERE budget_version_id = p_budget_version_id AND
1139: transaction_source_code IS NOT NULL;
1140:
1141: IF (l_res_asg_id_del_tab.count > 0) THEN

Line 1147: UPDATE PA_RESOURCE_ASSIGNMENTS

1143: DELETE FROM PA_BUDGET_LINES
1144: WHERE resource_assignment_id = l_res_asg_id_del_tab(i);
1145:
1146: FORALL j IN 1 .. l_res_asg_id_del_tab.count
1147: UPDATE PA_RESOURCE_ASSIGNMENTS
1148: SET transaction_source_code = null
1149: WHERE resource_assignment_id = l_res_asg_id_del_tab(j);
1150:
1151: -- IPM: New Entity ER ------------------------------------------