eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_SUMM_FUNDING_PKG dependencies on GMS_PROJECT_FUNDINGS

Line 279: -- This function checks for existence of any record in gms_project_fundings before

275: X_Total_Revenue_Amount NUMBER(22,5);
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

Line 288: FROM gms_project_fundings

284: IS
285: CURSOR c_funding_exists
286: IS SELECT 1 FROM DUAL
287: WHERE EXISTS (SELECT 1
288: FROM gms_project_fundings
289: WHERE installment_id = p_installment_id
290: AND project_id = p_project_id
291: AND nvl(task_id,0) = nvl(p_task_id,0));
292:

Line 330: where exists ( select 1 from gms_project_fundings

326: /*
327: Begin
328: select 'Y' into x_funding_exists
329: from dual
330: where exists ( select 1 from gms_project_fundings
331: where installment_id = x_installment_id
332: and project_id = x_project_id);
333: exception
334: when no_data_found then