APPS.GMS_SUMM_FUNDING_PKG dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 17: GMS_SUMMARY_PROJECT_FUNDINGS

13: 1
14: into
15: Row_Check
16: from
17: GMS_SUMMARY_PROJECT_FUNDINGS
18: where
19: INSTALLMENT_ID = X_Installment_Id and
20: PROJECT_ID = X_Project_Id and
21: (TASK_ID = X_Task_Id

Line 76: gms_summary_project_fundings gmf

72: X_Total_Funding_Amount,
73: X_Total_Billed_Amount,
74: X_Total_Revenue_Amount
75: from
76: gms_summary_project_fundings gmf
77: where
78: gmf.installment_id = X_Installment_Id and
79: gmf.project_id = X_Project_Id and
80: (gmf.task_id = X_Task_Id

Line 87: X_Err_Stage := 'No row found for Project and Task specified in GMS_SUMMARY_PROJECT_FUNDINGS';

83: X_Err_Code := 'S';
84: EXCEPTION
85: WHEN NO_DATA_FOUND THEN
86: X_Err_Code := 'E';
87: X_Err_Stage := 'No row found for Project and Task specified in GMS_SUMMARY_PROJECT_FUNDINGS';
88: X_Total_Funding_Amount := -99;
89: X_Total_Billed_Amount := -99;
90: X_Total_Revenue_Amount := -99;
91: FND_MESSAGE.SET_NAME('GMS','GMS_NO_ACT_PRJ_TSK_IN_SF');

Line 119: update GMS_SUMMARY_PROJECT_FUNDINGS

115: St_Total_Funding NUMBER(22,5);
116: Begin
117: fnd_msg_pub.initialize;
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

Line 155: INSERT INTO GMS_SUMMARY_PROJECT_FUNDINGS

151: X_Err_Stage OUT NOCOPY VARCHAR2) IS
152: Begin
153: fnd_msg_pub.initialize;
154:
155: INSERT INTO GMS_SUMMARY_PROJECT_FUNDINGS
156: (INSTALLMENT_ID ,
157: PROJECT_ID,
158: TASK_ID ,
159: TOTAL_FUNDING_AMOUNT ,

Line 280: -- deleting records from gms_summary_project_fundings

276: --X_funding_exists VARCHAR2(1) := 'Y';
277:
278: -- Bug 2270436 : Added function gms_funding_exists
279: -- This function checks for existence of any record in gms_project_fundings before
280: -- deleting records from gms_summary_project_fundings
281:
282: FUNCTION gms_funding_exists (p_installment_id NUMBER, p_project_id NUMBER, p_task_id NUMBER)
283: RETURN BOOLEAN
284: IS

Line 379: DELETE FROM GMS_SUMMARY_PROJECT_FUNDINGS

375:
376: If (((X_Total_Funding_Amount - X_Funding_Amount) = 0)
377: and not gms_funding_exists(X_installment_id,x_project_id,x_task_id)) -- Bug 2270436
378: then
379: DELETE FROM GMS_SUMMARY_PROJECT_FUNDINGS
380: WHERE
381: INSTALLMENT_ID = X_Installment_Id and
382: PROJECT_ID = X_Project_Id and
383: (TASK_ID = X_Task_Id