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

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

Line: 128


         select 'X'
         into l_dummy
         from csd_ro_diagnostic_codes
	 where repair_line_id = p_ro_diagnostic_code_rec.repair_line_id
         and   diagnostic_code_id = p_ro_diagnostic_code_rec.diagnostic_code_id;

Line: 157


                       'Calling Insert_Row table handler');

Line: 163


         CSD_RO_DIAGNOSTIC_CODES_PKG.Insert_Row
         (px_ro_diagnostic_code_id    => x_ro_diagnostic_code_id,
          p_object_version_number     => l_obj_ver_num,
          p_repair_line_id            => p_ro_diagnostic_code_rec.repair_line_id,
          p_diagnostic_code_id        => p_ro_diagnostic_code_rec.diagnostic_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_attribute_category        => p_ro_diagnostic_code_rec.attribute_category,
          p_attribute1                => p_ro_diagnostic_code_rec.attribute1,
          p_attribute2                => p_ro_diagnostic_code_rec.attribute2,
          p_attribute3                => p_ro_diagnostic_code_rec.attribute3,
          p_attribute4                => p_ro_diagnostic_code_rec.attribute4,
          p_attribute5                => p_ro_diagnostic_code_rec.attribute5,
          p_attribute6                => p_ro_diagnostic_code_rec.attribute6,
          p_attribute7                => p_ro_diagnostic_code_rec.attribute7,
          p_attribute8                => p_ro_diagnostic_code_rec.attribute8,
          p_attribute9                => p_ro_diagnostic_code_rec.attribute9,
          p_attribute10               => p_ro_diagnostic_code_rec.attribute10,
          p_attribute11               => p_ro_diagnostic_code_rec.attribute11,
          p_attribute12               => p_ro_diagnostic_code_rec.attribute12,
          p_attribute13               => p_ro_diagnostic_code_rec.attribute13,
          p_attribute14               => p_ro_diagnostic_code_rec.attribute14,
          p_attribute15               => p_ro_diagnostic_code_rec.attribute15,
		p_diagnostic_item_id	   => p_ro_diagnostic_code_rec.diagnostic_item_id  -- rfieldma, 4666403
 	);

Line: 195


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

Line: 206


                       'Returned from Insert_Row table handler');

Line: 326


/* procedure name: Update_RO_Diagnostic_Code        */
/* description   : procedure used to update         */
/*                 ro diagnostic code	            */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_RO_Diagnostic_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_diagnostic_code_rec	IN  RO_DIAGNOSTIC_CODE_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
)IS

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

Line: 352


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_ro_diagnostic_codes_pvt.update_ro_diagnostic_code';

Line: 353


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

Line: 373


       SAVEPOINT  Update_RO_Diagnostic_Code;

Line: 391


              'Entered Update_RO_Diagnostic_Code');

Line: 443


          select 'X'
          into l_dummy
          from csd_ro_diagnostic_codes
 	  where ro_diagnostic_code_id = p_ro_diagnostic_code_rec.ro_diagnostic_code_id;

Line: 473


          select object_version_number
          into l_obj_ver_num
          from csd_ro_diagnostic_codes
 	  where ro_diagnostic_code_id = p_ro_diagnostic_code_rec.ro_diagnostic_code_id;

Line: 536


         select 'X'
         into l_dummy
         from csd_ro_diagnostic_codes
	 where ro_diagnostic_code_id <> p_ro_diagnostic_code_rec.ro_diagnostic_code_id
	 and   repair_line_id = p_ro_diagnostic_code_rec.repair_line_id
         and   diagnostic_code_id = p_ro_diagnostic_code_rec.diagnostic_code_id;

Line: 566


                        'Calling Update_Row table handler');

Line: 572


         CSD_RO_DIAGNOSTIC_CODES_PKG.Update_Row
         (p_ro_diagnostic_code_id     => p_ro_diagnostic_code_rec.ro_diagnostic_code_id,
          p_object_version_number     => l_obj_ver_num + 1,
          p_repair_line_id            => p_ro_diagnostic_code_rec.repair_line_id,
          p_diagnostic_code_id        => p_ro_diagnostic_code_rec.diagnostic_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_attribute_category        => p_ro_diagnostic_code_rec.attribute_category,
          p_attribute1                => p_ro_diagnostic_code_rec.attribute1,
          p_attribute2                => p_ro_diagnostic_code_rec.attribute2,
          p_attribute3                => p_ro_diagnostic_code_rec.attribute3,
          p_attribute4                => p_ro_diagnostic_code_rec.attribute4,
          p_attribute5                => p_ro_diagnostic_code_rec.attribute5,
          p_attribute6                => p_ro_diagnostic_code_rec.attribute6,
          p_attribute7                => p_ro_diagnostic_code_rec.attribute7,
          p_attribute8                => p_ro_diagnostic_code_rec.attribute8,
          p_attribute9                => p_ro_diagnostic_code_rec.attribute9,
          p_attribute10               => p_ro_diagnostic_code_rec.attribute10,
          p_attribute11               => p_ro_diagnostic_code_rec.attribute11,
          p_attribute12               => p_ro_diagnostic_code_rec.attribute12,
          p_attribute13               => p_ro_diagnostic_code_rec.attribute13,
          p_attribute14               => p_ro_diagnostic_code_rec.attribute14,
          p_attribute15               => p_ro_diagnostic_code_rec.attribute15,
		p_diagnostic_item_id	   => p_ro_diagnostic_code_rec.diagnostic_item_id -- rfieldma, 4666403
 	 );

Line: 606


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

Line: 617


                       'Returned from Update_Row table handler');

Line: 634


                       'Leaving Update_RO_Diagnostic_Code');

Line: 640


          ROLLBACK TO Update_RO_Diagnostic_Code;

Line: 665


          ROLLBACK TO Update_RO_Diagnostic_Code;

Line: 715


          ROLLBACK TO Update_RO_Diagnostic_Code;

Line: 740


          ROLLBACK TO Update_RO_Diagnostic_Code;

Line: 765


          ROLLBACK TO Update_RO_Diagnostic_Code;

Line: 790


          ROLLBACK TO Update_RO_Diagnostic_Code;

Line: 805


          ROLLBACK TO Update_RO_Diagnostic_Code;

Line: 832


          ROLLBACK TO Update_RO_Diagnostic_Code;

Line: 860


END Update_RO_Diagnostic_Code;

Line: 864


/* procedure name: Delete_RO_Diagnostic_Code        */
/* description   : procedure used to delete         */
/*                 ro diagnostic code	            */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_RO_Diagnostic_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_diagnostic_code_id	IN  NUMBER
) IS

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

Line: 889


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_ro_diagnostic_codes_pvt.delete_ro_diagnostic_code';

Line: 890


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

Line: 900


       SAVEPOINT  Delete_RO_Diagnostic_Code;

Line: 918


              'Entered Delete_RO_Diagnostic_Code');

Line: 941


                         'Calling Delete_Row table handler');

Line: 947


         CSD_RO_DIAGNOSTIC_CODES_PKG.Delete_Row
         (p_ro_diagnostic_code_id       => p_ro_diagnostic_code_id);

Line: 953


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

Line: 964


                       'Returned from Delete_Row table handler');

Line: 981


                       'Leaving Delete_RO_Diagnostic_Code');

Line: 986


          ROLLBACK TO Delete_RO_Diagnostic_Code;

Line: 1001


          ROLLBACK TO Delete_RO_Diagnostic_Code;

Line: 1028


          ROLLBACK TO Delete_RO_Diagnostic_Code;

Line: 1056


END Delete_RO_Diagnostic_Code;

Line: 1157


          p_last_updated_by           => FND_GLOBAL.USER_ID,
          p_last_update_date          => SYSDATE,
          p_last_update_login         => FND_GLOBAL.LOGIN_ID,
          p_attribute_category        => p_ro_diagnostic_code_rec.attribute_category,
          p_attribute1                => p_ro_diagnostic_code_rec.attribute1,
          p_attribute2                => p_ro_diagnostic_code_rec.attribute2,
          p_attribute3                => p_ro_diagnostic_code_rec.attribute3,
          p_attribute4                => p_ro_diagnostic_code_rec.attribute4,
          p_attribute5                => p_ro_diagnostic_code_rec.attribute5,
          p_attribute6                => p_ro_diagnostic_code_rec.attribute6,
          p_attribute7                => p_ro_diagnostic_code_rec.attribute7,
          p_attribute8                => p_ro_diagnostic_code_rec.attribute8,
          p_attribute9                => p_ro_diagnostic_code_rec.attribute9,
          p_attribute10               => p_ro_diagnostic_code_rec.attribute10,
          p_attribute11               => p_ro_diagnostic_code_rec.attribute11,
          p_attribute12               => p_ro_diagnostic_code_rec.attribute12,
          p_attribute13               => p_ro_diagnostic_code_rec.attribute13,
          p_attribute14               => p_ro_diagnostic_code_rec.attribute14,
          p_attribute15               => p_ro_diagnostic_code_rec.attribute15
          */
          --
 	);