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

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

Line: 117


         select 'X'
         into l_dummy
         from csd_sc_work_entities
	 where service_code_id = p_sc_work_entity_rec.service_code_id
	 and (work_entity_type_code = p_sc_work_entity_rec.work_entity_type_code
	 and  nvl(work_entity_id1, -999) = nvl(p_sc_work_entity_rec.work_entity_id1, -999)
	 and  nvl(work_entity_id2, -999) = nvl(p_sc_work_entity_rec.work_entity_id2, -999)
	 and  nvl(work_entity_id3, -999) = nvl(p_sc_work_entity_rec.work_entity_id3, -999));

Line: 159


         select 'X'
         into l_dummy
         from org_organization_definitions
	 where organization_id = p_sc_work_entity_rec.work_entity_id3;

Line: 195


         select 'X'
         into l_dummy
         from bom_bill_of_materials
	 where bill_sequence_id = p_sc_work_entity_rec.work_entity_id1;

Line: 231


         select 'X'
         into l_dummy
         from bom_operational_routings
	 where routing_sequence_id = p_sc_work_entity_rec.work_entity_id2;

Line: 267


         select 'X'
         into l_dummy
         from jtf_task_temp_groups_vl
	 where task_template_group_id = p_sc_work_entity_rec.work_entity_id1;

Line: 293


                       'Calling Insert_Row table handler');

Line: 299


         CSD_SC_WORK_ENTITIES_PKG.Insert_Row
         (px_sc_work_entity_id 	      => x_sc_work_entity_id,
          p_object_version_number     => l_obj_ver_num,
          p_service_code_id           => p_sc_work_entity_rec.service_code_id,
          p_work_entity_id1           => p_sc_work_entity_rec.work_entity_id1,
          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_work_entity_type_code     => p_sc_work_entity_rec.work_entity_type_code,
          p_work_entity_id2  	      => p_sc_work_entity_rec.work_entity_id2,
          p_work_entity_id3  	      => p_sc_work_entity_rec.work_entity_id3,
          p_attribute_category        => p_sc_work_entity_rec.attribute_category,
          p_attribute1                => p_sc_work_entity_rec.attribute1,
          p_attribute2                => p_sc_work_entity_rec.attribute2,
          p_attribute3                => p_sc_work_entity_rec.attribute3,
          p_attribute4                => p_sc_work_entity_rec.attribute4,
          p_attribute5                => p_sc_work_entity_rec.attribute5,
          p_attribute6                => p_sc_work_entity_rec.attribute6,
          p_attribute7                => p_sc_work_entity_rec.attribute7,
          p_attribute8                => p_sc_work_entity_rec.attribute8,
          p_attribute9                => p_sc_work_entity_rec.attribute9,
          p_attribute10               => p_sc_work_entity_rec.attribute10,
          p_attribute11               => p_sc_work_entity_rec.attribute11,
          p_attribute12               => p_sc_work_entity_rec.attribute12,
          p_attribute13               => p_sc_work_entity_rec.attribute13,
          p_attribute14               => p_sc_work_entity_rec.attribute14,
          p_attribute15               => p_sc_work_entity_rec.attribute15
 	);

Line: 333


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

Line: 344


                       'Returned from Insert_Row table handler');

Line: 565


/* procedure name: Update_SC_Work_Entity            */
/* description   : procedure used to update         */
/*                 sc work entity	            */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_SC_Work_Entity
(
  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_sc_work_entity_rec	 	IN  SC_WORK_ENTITY_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

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

Line: 591


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_sc_work_entities_pvt.update_sc_work_entity';

Line: 592


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

Line: 617


       SAVEPOINT  Update_SC_Work_Entity;

Line: 636


              'Entered Update_SC_Work_Entity');

Line: 688


          select 'X'
          into l_dummy
          from csd_sc_work_entities
 	  where sc_work_entity_id = p_sc_work_entity_rec.sc_work_entity_id;

Line: 718


          select object_version_number
          into l_obj_ver_num
          from csd_sc_work_entities
          where sc_work_entity_id = p_sc_work_entity_rec.sc_work_entity_id;

Line: 767


         select 'X'
         into l_dummy
         from csd_sc_work_entities
	 where sc_work_entity_id <> p_sc_work_entity_rec.sc_work_entity_id
	 and service_code_id = p_sc_work_entity_rec.service_code_id
	 and (work_entity_type_code = p_sc_work_entity_rec.work_entity_type_code
	 and  nvl(work_entity_id1, -999) = nvl(p_sc_work_entity_rec.work_entity_id1, -999)
	 and  nvl(work_entity_id2, -999) = nvl(p_sc_work_entity_rec.work_entity_id2, -999)
	 and  nvl(work_entity_id3, -999) = nvl(p_sc_work_entity_rec.work_entity_id3, -999));

Line: 810


         select 'X'
         into l_dummy
         from org_organization_definitions
	 where organization_id = p_sc_work_entity_rec.work_entity_id3;

Line: 846


         select 'X'
         into l_dummy
         from bom_bill_of_materials
	 where bill_sequence_id = p_sc_work_entity_rec.work_entity_id1;

Line: 882


         select 'X'
         into l_dummy
         from bom_operational_routings
	 where routing_sequence_id = p_sc_work_entity_rec.work_entity_id2;

Line: 918


         select 'X'
         into l_dummy
         from jtf_task_temp_groups_vl
	 where task_template_group_id = p_sc_work_entity_rec.work_entity_id1;

Line: 944


                        'Calling Update_Row table handler');

Line: 950


         CSD_SC_WORK_ENTITIES_PKG.Update_Row
         (p_sc_work_entity_id 	      => p_sc_work_entity_rec.sc_work_entity_id,
          p_object_version_number     => l_obj_ver_num + 1,
          p_service_code_id           => p_sc_work_entity_rec.service_code_id,
          p_work_entity_id1           => p_sc_work_entity_rec.work_entity_id1,
          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_work_entity_type_code     => p_sc_work_entity_rec.work_entity_type_code,
          p_work_entity_id2  	      => p_sc_work_entity_rec.work_entity_id2,
          p_work_entity_id3  	      => p_sc_work_entity_rec.work_entity_id3,
          p_attribute_category        => p_sc_work_entity_rec.attribute_category,
          p_attribute1                => p_sc_work_entity_rec.attribute1,
          p_attribute2                => p_sc_work_entity_rec.attribute2,
          p_attribute3                => p_sc_work_entity_rec.attribute3,
          p_attribute4                => p_sc_work_entity_rec.attribute4,
          p_attribute5                => p_sc_work_entity_rec.attribute5,
          p_attribute6                => p_sc_work_entity_rec.attribute6,
          p_attribute7                => p_sc_work_entity_rec.attribute7,
          p_attribute8                => p_sc_work_entity_rec.attribute8,
          p_attribute9                => p_sc_work_entity_rec.attribute9,
          p_attribute10               => p_sc_work_entity_rec.attribute10,
          p_attribute11               => p_sc_work_entity_rec.attribute11,
          p_attribute12               => p_sc_work_entity_rec.attribute12,
          p_attribute13               => p_sc_work_entity_rec.attribute13,
          p_attribute14               => p_sc_work_entity_rec.attribute14,
          p_attribute15               => p_sc_work_entity_rec.attribute15
 	 );

Line: 986


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

Line: 997


                       'Returned from Update_Row table handler');

Line: 1014


                       'Leaving Update_SC_Work_Entity');

Line: 1020


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1045


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1071


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1096


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1121


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1146


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1171


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1196


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1221


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1246


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1271


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1286


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1313


          ROLLBACK TO Update_SC_Work_Entity;

Line: 1341


END Update_SC_Work_Entity;

Line: 1344


/* procedure name: Delete_SC_Work_Entity            */
/* description   : procedure used to delete         */
/*                 sc work entity	            */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_SC_Work_Entity
(
  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_sc_work_entity_id	 	IN  NUMBER
) IS

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

Line: 1369


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_sc_work_entities_pvt.delete_sc_work_entity';

Line: 1370


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

Line: 1380


       SAVEPOINT  Delete_SC_Work_Entity;

Line: 1398


                'Entered Delete_SC_Work_Entity');

Line: 1421


                         'Calling Delete_Row table handler');

Line: 1427


         CSD_SC_WORK_ENTITIES_PKG.Delete_Row
         (p_sc_work_entity_id 	      => p_sc_work_entity_id	);

Line: 1433


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

Line: 1444


                       'Returned from Delete_Row table handler');

Line: 1461


                       'Leaving Delete_SC_Work_Entity');

Line: 1467


          ROLLBACK TO Delete_SC_Work_Entity;

Line: 1482


          ROLLBACK TO Delete_SC_Work_Entity;

Line: 1509


          ROLLBACK TO Delete_SC_Work_Entity;

Line: 1537


END Delete_SC_Work_Entity;

Line: 1639


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