118:
119: update GMS_SUMMARY_PROJECT_FUNDINGS
120: set TOTAL_FUNDING_AMOUNT = X_Funding_Amount,
121: LAST_UPDATE_DATE = SYSDATE ,
122: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
123: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
124: where
125: INSTALLMENT_ID = X_Installment_Id and
126: PROJECT_ID = X_Project_Id and
119: update GMS_SUMMARY_PROJECT_FUNDINGS
120: set TOTAL_FUNDING_AMOUNT = X_Funding_Amount,
121: LAST_UPDATE_DATE = SYSDATE ,
122: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
123: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
124: where
125: INSTALLMENT_ID = X_Installment_Id and
126: PROJECT_ID = X_Project_Id and
127: (TASK_ID = X_Task_Id
167: X_Project_Id,
168: X_Task_Id,
169: X_Funding_Amount,
170: SYSDATE,
171: FND_GLOBAL.USER_ID,
172: SYSDATE,
173: FND_GLOBAL.USER_ID,
174: FND_GLOBAL.LOGIN_ID);
175: X_Err_Code := 'S';
169: X_Funding_Amount,
170: SYSDATE,
171: FND_GLOBAL.USER_ID,
172: SYSDATE,
173: FND_GLOBAL.USER_ID,
174: FND_GLOBAL.LOGIN_ID);
175: X_Err_Code := 'S';
176: EXCEPTION
177:
170: SYSDATE,
171: FND_GLOBAL.USER_ID,
172: SYSDATE,
173: FND_GLOBAL.USER_ID,
174: FND_GLOBAL.LOGIN_ID);
175: X_Err_Code := 'S';
176: EXCEPTION
177:
178: WHEN OTHERS THEN