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_AWARD_DELETE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36


         FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_EVENT_EXIST');

Line: 58


      SELECT 1 --COUNT(*) bug 2355648
      FROM   gms_summary_project_fundings gspf,gms_installments gi
      WHERE  gi.award_id = p_award_Id
      AND    gspf.installment_id=gi.installment_id
      AND   rownum <=1;

Line: 80


         FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_FUNDING_EXISTS');

Line: 99


    SELECT 	1 --COUNT(*) bug 2355648
    FROM 	gms_budget_versions
    WHERE      	award_id = p_award_id
    AND      	budget_status_code IN ('B','S')
    AND         rownum <=1;

Line: 123


    	     FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_BASELINED_BUDGET_EXIST');

Line: 139


    SELECT 	1 --COUNT(*)  bug 2355648
    FROM 	gms_award_distributions
    WHERE       award_id = p_award_id
    AND         rownum <=1;

Line: 162


    	     FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_ADL_EXIST');

Line: 171


PROCEDURE DELETE_AWARD_DETAIL( 	p_award_id 		IN  NUMBER ,
                                p_award_project_id      IN  NUMBER,
                                p_agreement_id          IN  NUMBER,
                                p_Award_Template_flag   IN  VARCHAR2,
                                p_msg_count             OUT NOCOPY NUMBER,
				retcode 	        OUT NOCOPY VARCHAR2,
       				errbuff                 OUT NOCOPY VARCHAR2 )  IS

CURSOR  GET_PROJECT_ID   IS
        	SELECT   DISTINCT PROJECT_ID
        	FROM     gms_summary_project_fundings gspf,gms_installments gi
        	WHERE   gi.award_id = p_award_id  --:gms_awards_v.Award_Id bug 2355648
        	AND     gspf.installment_id=gi.installment_id;

Line: 187


              SELECT    GI.INSTALLMENT_ID,
              		FUNDING_AMOUNT,
              		PROJECT_FUNDING_ID,
			GMS_PROJECT_FUNDING_ID,
              		PROJECT_ID ,
              		TASK_ID
 		FROM    GMS_PROJECT_FUNDINGS GPF ,GMS_INSTALLMENTS GI
       		WHERE   GPF.INSTALLMENT_ID=GI.INSTALLMENT_ID
     		AND     GI.AWARD_ID= p_award_id ;  --:GMS_AWARDS_V.AWARD_ID; 2355648

Line: 205


       l_Funding_Exists:= GMS_AWARD_DELETE_PKG.CHECK_FUNDING_EXISTS
    			(p_Award_Id	=>p_Award_id,
                         p_msg_count    =>p_msg_count,
    			 RETCODE	=>retcode,
    			 ERRBUFF	=>errbuff);

Line: 216


            l_Draft_Budget_Exists:=GMS_AWARD_DELETE_PKG.CHECK_DRAFT_BUDGET_EXISTS
						(p_Award_Id	=>p_Award_id,
                                                 p_msg_count    =>p_msg_count,
						 RETCODE	=>retcode,
						 ERRBUFF	=>errbuff);

Line: 228


      		   gms_budget_pub.delete_draft_budget(
      				p_api_version_number => 1.0,
      				p_pm_product_code => 'GMS',
      				x_err_code =>  l_err_code,
      				x_err_stage => l_err_stage,
      				x_err_stack => l_err_stack,
      				p_project_id => project_info.project_id,
      				p_award_id => p_Award_id,
      				p_budget_type_code =>'AC');

Line: 243


                      FND_MESSAGE.SET_NAME('GMS','GMS_DELETE_DRAFT_FAIL');

Line: 253


      		GMS_PROJECT_FUNDINGS_PKG.DELETE_ROW
 			(X_GMS_PROJECT_FUNDING_ID =>FUNDING_INFO.GMS_PROJECT_FUNDING_ID);

Line: 255


         	GMS_SUMM_FUNDING_PKG.DELETE_GMS_SUMMARY_FUNDING
    			( X_Installment_Id 	=> FUNDING_INFO.INSTALLMENT_ID,
	    		  X_Project_Id 		=> FUNDING_INFO.PROJECT_ID,
    		  	  X_Task_Id 		=> FUNDING_INFO.TASK_ID,
    		  	  X_Funding_Amount 	=> FUNDING_INFO.FUNDING_AMOUNT,
    		  	  RETCODE          	=> retcode,
    		  	  ERRBUF           	=> errbuff);

Line: 265


                      FND_MESSAGE.SET_NAME('GMS','GMS_DELETE_FUNDING_FAIL');

Line: 272


	        GMS_MULTI_FUNDING.DELETE_AWARD_FUNDING
    			(X_INSTALLMENT_ID 	=> FUNDING_INFO.INSTALLMENT_ID,
    		  	X_ALLOCATED_AMOUNT 	=> FUNDING_INFO.FUNDING_AMOUNT,
    		  	X_PROJECT_FUNDING_ID	=> FUNDING_INFO.PROJECT_FUNDING_ID,
    		  	X_APP_SHORT_NAME 	=> l_app_name,
    		  	ERRBUF  		=> errbuff,
    		  	X_msg_count 		=> p_msg_count,
    		  	RETCODE 		=> retcode   );

Line: 287


        GMS_MULTI_FUNDING.DELETE_AWARD_PROJECT(
	 X_Award_id         => p_award_id ,
	 X_AWARD_PROJECT_ID => p_award_project_id ,
	 X_AGREEMENT_ID     => p_agreement_id ,
	 X_MSG_COUNT        => p_msg_count      ,
	 X_APP_SHORT_NAME   => l_app_name,
	 RETCODE            => retcode,
	 ERRBUF             => errbuff );

Line: 301


                       DELETE_AWARD_ALL(p_Award_Id	=>p_Award_id,
                                          p_msg_count   =>p_msg_count,
				          RETCODE       =>retcode,
				       	  ERRBUFF       =>errbuff);

Line: 322


             FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_DETAIL');

Line: 330


END DELETE_AWARD_DETAIL;

Line: 335


 FUNCTION delete_award_ok
 (
 	p_Award_Id 	IN	NUMBER,
  	p_Billing_Rule 	IN	VARCHAR2, --Not Using this parameter  bug 2355648
   	p_Revenue_Rule	IN	VARCHAR2, --Not Using this parameter bug 2355648
  	RETCODE		OUT NOCOPY	VARCHAR2,
  	ERRBUFF		OUT NOCOPY	VARCHAR2
 ) RETURN BOOLEAN AS

   l_errbuff      VARCHAR2(200);

Line: 441


             FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_OK');

Line: 446


  END delete_award_ok;

Line: 458


    SELECT 	1  --COUNT(*) bug 2355648
    FROM 	gms_budget_versions
    WHERE       award_id = p_award_id
    AND      	budget_status_code = 'W';

Line: 483


	  FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: CHECK_DRAFT_BUDGET_EXISTS');

Line: 497


PROCEDURE delete_award_all( p_award_Id  IN   NUMBER ,
                            p_msg_count OUT NOCOPY  NUMBER,
                            retcode     OUT NOCOPY  VARCHAR2 ,
                            errbuff     OUT NOCOPY  VARCHAR2
                          )   AS
        CURSOR notification_lock  IS
            SELECT  1 FROM gms_notifications
            WHERE   award_id=p_award_Id
            FOR UPDATE NOWAIT;

Line: 508


            SELECT  1 FROM gms_installments
            WHERE    award_id=p_award_Id
            FOR UPDATE NOWAIT;

Line: 518


        DELETE FROM gms_reports WHERE  installment_id in (select installment_id from gms_installments WHERE   award_id =p_award_id);

Line: 519


        DELETE FROM gms_installments WHERE  award_id=p_award_id;

Line: 520


        DELETE FROM gms_default_reports WHERE  award_id = p_award_id;

Line: 521


        DELETE FROM gms_notifications WHERE  award_id= p_award_id;

Line: 522


        DELETE FROM gms_awards_terms_conditions WHERE  award_id=p_award_id;

Line: 525


        DELETE FROM gms_personnel WHERE  award_id =p_award_id;

Line: 526


        DELETE FROM gms_reference_numbers WHERE  award_id=p_award_id;

Line: 527


        DELETE FROM gms_awards_contacts WHERE  award_id=p_award_id;

Line: 528


        DELETE FROM pa_credit_receivers WHERE  project_id= p_award_Id;

Line: 530


        DELETE FROM gms_override_schedules WHERE award_id=p_award_id;

Line: 540


                   FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARD_DELETE_PKG: DELETE_AWARD_ALL');

Line: 547


END DELETE_AWARD_ALL;