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.CSD_SERVICE_CODES_PVT SQL Statements

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

Line: 109


         select 'X'
         into l_dummy
         from csd_service_codes_b
	 where service_code = UPPER(p_service_code_rec.service_code);

Line: 137


                       'Calling Insert_Row table handler');

Line: 143


         CSD_SERVICE_CODES_PKG.Insert_Row
         (px_rowid 		      => l_rowid,
          px_service_code_id          => x_service_code_id,
          p_object_version_number     => l_obj_ver_num,
          p_created_by                => FND_GLOBAL.USER_ID,
          p_creation_date             => SYSDATE,
          p_last_updated_by           => FND_GLOBAL.USER_ID,
          p_last_update_date          => SYSDATE,
          p_last_update_login         => FND_GLOBAL.LOGIN_ID,
          p_service_code              => p_service_code_rec.service_code,
          p_name	              => p_service_code_rec.name,
          p_description	              => p_service_code_rec.description,
          p_active_from	              => p_service_code_rec.active_from,
          p_active_to	              => p_service_code_rec.active_to,
          p_attribute_category        => p_service_code_rec.attribute_category,
          p_attribute1                => p_service_code_rec.attribute1,
          p_attribute2                => p_service_code_rec.attribute2,
          p_attribute3                => p_service_code_rec.attribute3,
          p_attribute4                => p_service_code_rec.attribute4,
          p_attribute5                => p_service_code_rec.attribute5,
          p_attribute6                => p_service_code_rec.attribute6,
          p_attribute7                => p_service_code_rec.attribute7,
          p_attribute8                => p_service_code_rec.attribute8,
          p_attribute9                => p_service_code_rec.attribute9,
          p_attribute10               => p_service_code_rec.attribute10,
          p_attribute11               => p_service_code_rec.attribute11,
          p_attribute12               => p_service_code_rec.attribute12,
          p_attribute13               => p_service_code_rec.attribute13,
          p_attribute14               => p_service_code_rec.attribute14,
          p_attribute15               => p_service_code_rec.attribute15
 	);

Line: 178


               FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SERVICE_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

Line: 189


                       'Returned from Insert_Row table handler');

Line: 306


/* procedure name: Update_Service_Code              */
/* description   : procedure used to update         */
/*                 service code	                    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Service_Code
(
  p_api_version        		IN  NUMBER,
  p_commit	   		IN  VARCHAR2,
  p_init_msg_list      		IN  VARCHAR2,
  p_validation_level   		IN  NUMBER,
  x_return_status      		OUT NOCOPY VARCHAR2,
  x_msg_count          		OUT NOCOPY NUMBER,
  x_msg_data           		OUT NOCOPY VARCHAR2,
  p_service_code_rec	    	IN  SERVICE_CODE_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

-- CONSTANTS --
 lc_debug_level           CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line: 332


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_service_codes_pvt.update_service_code';

Line: 333


 lc_api_name               CONSTANT VARCHAR2(30)   := 'Update_Service_Code';

Line: 354


       SAVEPOINT  Update_Service_Code;

Line: 372


              'Entered Update_Service_Code');

Line: 421


          select 'X'
          into l_dummy
          from csd_service_codes_b
 	  where service_code_id = p_service_code_rec.service_code_id;

Line: 451


          select object_version_number
          into l_obj_ver_num
          from csd_service_codes_b
 	  where service_code_id = p_service_code_rec.service_code_id;

Line: 489


         select 'X'
         into l_dummy
         from csd_service_codes_b
	 where service_code = UPPER(p_service_code_rec.service_code)
	 and service_code_id <> p_service_code_rec.service_code_id;

Line: 518


                        'Calling Update_Row table handler');

Line: 524


         CSD_SERVICE_CODES_PKG.Update_Row
         (p_service_code_id           => p_service_code_rec.service_code_id,
          p_object_version_number     => l_obj_ver_num + 1,
          p_created_by                => FND_GLOBAL.USER_ID,
          p_creation_date             => SYSDATE,
          p_last_updated_by           => FND_GLOBAL.USER_ID,
          p_last_update_date          => SYSDATE,
          p_last_update_login         => FND_GLOBAL.LOGIN_ID,
          p_service_code              => p_service_code_rec.service_code,
          p_name	              => p_service_code_rec.name,
          p_description	              => p_service_code_rec.description,
          p_active_from	              => p_service_code_rec.active_from,
          p_active_to	              => p_service_code_rec.active_to,
          p_attribute_category        => p_service_code_rec.attribute_category,
          p_attribute1                => p_service_code_rec.attribute1,
          p_attribute2                => p_service_code_rec.attribute2,
          p_attribute3                => p_service_code_rec.attribute3,
          p_attribute4                => p_service_code_rec.attribute4,
          p_attribute5                => p_service_code_rec.attribute5,
          p_attribute6                => p_service_code_rec.attribute6,
          p_attribute7                => p_service_code_rec.attribute7,
          p_attribute8                => p_service_code_rec.attribute8,
          p_attribute9                => p_service_code_rec.attribute9,
          p_attribute10               => p_service_code_rec.attribute10,
          p_attribute11               => p_service_code_rec.attribute11,
          p_attribute12               => p_service_code_rec.attribute12,
          p_attribute13               => p_service_code_rec.attribute13,
          p_attribute14               => p_service_code_rec.attribute14,
          p_attribute15               => p_service_code_rec.attribute15
 	);

Line: 560


              FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_SERVICE_CODES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

Line: 571


                       'Returned from Update_Row table handler');

Line: 588


                       'Leaving Update_Service_Code');

Line: 594


            ROLLBACK TO Update_Service_Code;

Line: 618


            ROLLBACK TO Update_Service_Code;

Line: 642


            ROLLBACK TO Update_Service_Code;

Line: 665


            ROLLBACK TO Update_Service_Code;

Line: 688


            ROLLBACK TO Update_Service_Code;

Line: 711


          ROLLBACK TO Update_Service_Code;

Line: 734


          ROLLBACK TO Update_Service_Code;

Line: 748


          ROLLBACK TO Update_Service_Code;

Line: 774


          ROLLBACK TO Update_Service_Code;

Line: 801


END Update_Service_Code;