APPS.GR_DISCLOSURE_PKG SQL Statements

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

Line: 25

   SELECT dc.rowid
   FROM	  gr_disclosures dc
   WHERE  dc.disclosure_code = p_disclosure_code;

Line: 61

				(delete_disclosure gr_disclosures.disclosure_code%TYPE)

 IS

/*	Alpha Variables */
L_CODE_BLOCK		VARCHAR2(2000);

Line: 82

      SELECT 	COUNT(1)
      FROM 		gr_country_profiles cp
      WHERE 	cp.disclosure_code = delete_disclosure;

Line: 89

      SELECT	COUNT(1)
      FROM 		gr_item_disclosures id
      WHERE 	id.disclosure_code = delete_disclosure;

Line: 96

      SELECT	COUNT(1)
      FROM 		gr_document_print dp
      WHERE 	dp.disclosure_code_recipient = delete_disclosure;

Line: 103

      SELECT	COUNT(1)
      FROM 		gr_document_print dp
      WHERE 	dp.disclosure_code_country = delete_disclosure;

Line: 110

      SELECT	COUNT(1)
      FROM 		gr_recipient_info ri
      WHERE 	ri.disclosure_code = delete_disclosure;

Line: 119

**	Open cursor which counts total records that match the item code to be deleted
*/
   OPEN country_disclosure_cursor;

Line: 181

     FND_MESSAGE.SET_TOKEN('CODE', delete_disclosure,
     					   FALSE);