DBA Data[Home] [Help]

APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_PROJECT_FUNDINGS

Line 193: FROM GMS_PROJECT_FUNDINGS GPF ,GMS_INSTALLMENTS GI

189: PROJECT_FUNDING_ID,
190: GMS_PROJECT_FUNDING_ID,
191: PROJECT_ID ,
192: TASK_ID
193: FROM GMS_PROJECT_FUNDINGS GPF ,GMS_INSTALLMENTS GI
194: WHERE GPF.INSTALLMENT_ID=GI.INSTALLMENT_ID
195: AND GI.AWARD_ID= p_award_id ; --:GMS_AWARDS_V.AWARD_ID; 2355648
196: l_err_code number;
197: l_app_name varchar2(10);

Line 253: GMS_PROJECT_FUNDINGS_PKG.DELETE_ROW

249: END IF; --End if for l_Draft_Budget_Exists
250:
251: FOR FUNDING_INFO IN PROJECT_FUNDING
252: LOOP
253: GMS_PROJECT_FUNDINGS_PKG.DELETE_ROW
254: (X_GMS_PROJECT_FUNDING_ID =>FUNDING_INFO.GMS_PROJECT_FUNDING_ID);
255: GMS_SUMM_FUNDING_PKG.DELETE_GMS_SUMMARY_FUNDING
256: ( X_Installment_Id => FUNDING_INFO.INSTALLMENT_ID,
257: X_Project_Id => FUNDING_INFO.PROJECT_ID,