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

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

Line: 141


         select 'X'
         into l_dummy
         from csd_ro_service_codes
	 where repair_line_id = p_ro_service_code_rec.repair_line_id
         and   service_code_id = p_ro_service_code_rec.service_code_id;

Line: 171


                       'Calling Insert_Row table handler');

Line: 177


         CSD_RO_SERVICE_CODES_PKG.Insert_Row
         (px_ro_service_code_id       => x_ro_service_code_id,
          p_object_version_number     => l_obj_ver_num,
          p_repair_line_id            => p_ro_service_code_rec.repair_line_id,
          p_service_code_id           => p_ro_service_code_rec.service_code_id,
          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_source_type_code          => p_ro_service_code_rec.source_type_code,
          p_source_solution_id        => p_ro_service_code_rec.source_solution_id,
          p_applicable_flag  	      => p_ro_service_code_rec.applicable_flag,
          p_applied_to_est_flag       => 'N',
          p_applied_to_work_flag      => 'N',
          p_attribute_category        => p_ro_service_code_rec.attribute_category,
          p_attribute1                => p_ro_service_code_rec.attribute1,
          p_attribute2                => p_ro_service_code_rec.attribute2,
          p_attribute3                => p_ro_service_code_rec.attribute3,
          p_attribute4                => p_ro_service_code_rec.attribute4,
          p_attribute5                => p_ro_service_code_rec.attribute5,
          p_attribute6                => p_ro_service_code_rec.attribute6,
          p_attribute7                => p_ro_service_code_rec.attribute7,
          p_attribute8                => p_ro_service_code_rec.attribute8,
          p_attribute9                => p_ro_service_code_rec.attribute9,
          p_attribute10               => p_ro_service_code_rec.attribute10,
          p_attribute11               => p_ro_service_code_rec.attribute11,
          p_attribute12               => p_ro_service_code_rec.attribute12,
          p_attribute13               => p_ro_service_code_rec.attribute13,
          p_attribute14               => p_ro_service_code_rec.attribute14,
          p_attribute15               => p_ro_service_code_rec.attribute15,
		p_service_item_id		   => p_ro_service_code_rec.service_item_id --rfieldma, 4666403
 	);

Line: 214


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

Line: 225


                       'Returned from Insert_Row table handler');

Line: 347


/* procedure name: Update_RO_Service_Code           */
/* description   : procedure used to update         */
/*                 ro service code	            */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_RO_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_ro_service_code_rec	 	IN  RO_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: 373


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_ro_service_codes_pvt.update_ro_service_code';

Line: 374


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

Line: 399


       SAVEPOINT  Update_RO_Service_Code;

Line: 417


              'Entered Update_RO_Service_Code');

Line: 479


          select 'X'
          into l_dummy
          from csd_ro_service_codes
 	  where ro_service_code_id = p_ro_service_code_rec.ro_service_code_id;

Line: 509


          select object_version_number
          into l_obj_ver_num
          from csd_ro_service_codes
 	  where ro_service_code_id = p_ro_service_code_rec.ro_service_code_id;

Line: 564


                        'Calling Update_Row table handler');

Line: 569


         CSD_RO_SERVICE_CODES_PKG.Update_Row
         (p_ro_service_code_id        => p_ro_service_code_rec.ro_service_code_id,
          p_object_version_number     => l_obj_ver_num + 1,
          p_repair_line_id            => p_ro_service_code_rec.repair_line_id,
          p_service_code_id           => p_ro_service_code_rec.service_code_id,
          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_source_type_code          => p_ro_service_code_rec.source_type_code,
          p_source_solution_id        => p_ro_service_code_rec.source_solution_id,
          p_applicable_flag  	      => p_ro_service_code_rec.applicable_flag,
          p_applied_to_est_flag       => p_ro_service_code_rec.applied_to_est_flag,
          p_applied_to_work_flag      => p_ro_service_code_rec.applied_to_work_flag,
          p_attribute_category        => p_ro_service_code_rec.attribute_category,
          p_attribute1                => p_ro_service_code_rec.attribute1,
          p_attribute2                => p_ro_service_code_rec.attribute2,
          p_attribute3                => p_ro_service_code_rec.attribute3,
          p_attribute4                => p_ro_service_code_rec.attribute4,
          p_attribute5                => p_ro_service_code_rec.attribute5,
          p_attribute6                => p_ro_service_code_rec.attribute6,
          p_attribute7                => p_ro_service_code_rec.attribute7,
          p_attribute8                => p_ro_service_code_rec.attribute8,
          p_attribute9                => p_ro_service_code_rec.attribute9,
          p_attribute10               => p_ro_service_code_rec.attribute10,
          p_attribute11               => p_ro_service_code_rec.attribute11,
          p_attribute12               => p_ro_service_code_rec.attribute12,
          p_attribute13               => p_ro_service_code_rec.attribute13,
          p_attribute14               => p_ro_service_code_rec.attribute14,
          p_attribute15               => p_ro_service_code_rec.attribute15,
		p_service_item_id		   => p_ro_service_code_rec.service_item_id -- rfieldma, 4666403
 	 );

Line: 608


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

Line: 619


                       'Returned from Update_Row table handler');

Line: 636


                       'Leaving Update_RO_Service_Code');

Line: 641


          ROLLBACK TO Update_RO_Service_Code;

Line: 666


          ROLLBACK TO Update_RO_Service_Code;

Line: 691


          ROLLBACK TO Update_RO_Service_Code;

Line: 717


          ROLLBACK TO Update_RO_Service_Code;

Line: 743


          ROLLBACK TO Update_RO_Service_Code;

Line: 769


          ROLLBACK TO Update_RO_Service_Code;

Line: 795


          ROLLBACK TO Update_RO_Service_Code;

Line: 820


          ROLLBACK TO Update_RO_Service_Code;

Line: 845


          ROLLBACK TO Update_RO_Service_Code;

Line: 870


          ROLLBACK TO Update_RO_Service_Code;

Line: 885


          ROLLBACK TO Update_RO_Service_Code;

Line: 912


          ROLLBACK TO Update_RO_Service_Code;

Line: 940


END Update_RO_Service_Code;

Line: 944


/* procedure name: Delete_RO_Service_Code           */
/* description   : procedure used to delete         */
/*                 ro service code	            */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_RO_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_ro_service_code_id	 	IN  NUMBER
) IS

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

Line: 969


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_ro_service_codes_pvt.delete_ro_service_code';

Line: 970


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

Line: 980


       SAVEPOINT  Delete_RO_Service_Code;

Line: 998


              'Entered Delete_RO_Service_Code');

Line: 1021


                         'Calling Delete_Row table handler');

Line: 1026


         CSD_RO_SERVICE_CODES_PKG.Delete_Row
         (p_ro_service_code_id       => p_ro_service_code_id);

Line: 1032


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

Line: 1043


                       'Returned from Delete_Row table handler');

Line: 1060


                       'Leaving Delete_RO_Service_Code');

Line: 1065


          ROLLBACK TO Delete_RO_Service_Code;

Line: 1080


          ROLLBACK TO Delete_RO_Service_Code;

Line: 1107


          ROLLBACK TO Delete_RO_Service_Code;

Line: 1135


END Delete_RO_Service_Code;

Line: 1236


          p_last_updated_by           => null,
          p_last_update_date          => null,
          p_last_update_login         => null,
          p_source_type_code          => p_ro_service_code_rec.source_type_code,
          p_source_solution_id        => p_ro_service_code_rec.source_solution_id,
          p_applicable_flag  	      => p_ro_service_code_rec.applicable_flag,
          p_applied_to_est_flag       => null,
          p_applied_to_work_flag      => null,
          p_attribute_category        => p_ro_service_code_rec.attribute_category,
          p_attribute1                => p_ro_service_code_rec.attribute1,
          p_attribute2                => p_ro_service_code_rec.attribute2,
          p_attribute3                => p_ro_service_code_rec.attribute3,
          p_attribute4                => p_ro_service_code_rec.attribute4,
          p_attribute5                => p_ro_service_code_rec.attribute5,
          p_attribute6                => p_ro_service_code_rec.attribute6,
          p_attribute7                => p_ro_service_code_rec.attribute7,
          p_attribute8                => p_ro_service_code_rec.attribute8,
          p_attribute9                => p_ro_service_code_rec.attribute9,
          p_attribute10               => p_ro_service_code_rec.attribute10,
          p_attribute11               => p_ro_service_code_rec.attribute11,
          p_attribute12               => p_ro_service_code_rec.attribute12,
          p_attribute13               => p_ro_service_code_rec.attribute13,
          p_attribute14               => p_ro_service_code_rec.attribute14,
          p_attribute15               => p_ro_service_code_rec.attribute15
          */
          --
 	);