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

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

Line: 147


         select 'X'
         into l_dummy
         from csd_sc_domains
	 where service_code_id = p_sc_domain_rec.service_code_id
	 and (domain_type_code = p_sc_domain_rec.domain_type_code
	 and inventory_item_id = p_sc_domain_rec.inventory_item_id)
         or (domain_type_code = p_sc_domain_rec.domain_type_code
         and category_set_id = p_sc_domain_rec.category_set_id
         and category_id = p_sc_domain_rec.category_id);

Line: 157


         select 'X'
         into l_dummy
         from csd_sc_domains
	 where (service_code_id = p_sc_domain_rec.service_code_id
	 and domain_type_code = p_sc_domain_rec.domain_type_code
	 and inventory_item_id = p_sc_domain_rec.inventory_item_id)
         or (service_code_id = p_sc_domain_rec.service_code_id
         and domain_type_code = p_sc_domain_rec.domain_type_code
         and category_set_id = p_sc_domain_rec.category_set_id
         and category_id = p_sc_domain_rec.category_id);

Line: 201


           select 'X'
           into l_dummy
           from mtl_system_items_kfv
           where organization_id = cs_std.get_item_valdn_orgzn_id
           and inventory_item_id = p_sc_domain_rec.inventory_item_id;

Line: 240


           select 'X'
           into l_dummy
           from mtl_category_sets_vl
           where category_set_id = p_sc_domain_rec.category_set_id;

Line: 269


           select validate_flag
           into l_valid_cat_flag
           from mtl_category_sets_vl
           where category_set_id = p_sc_domain_rec.category_set_id;

Line: 311


             select 'X'
             into l_dummy
	     from mtl_category_set_valid_cats_v
             where category_set_id = p_sc_domain_rec.category_set_id
             and category_id = p_sc_domain_rec.category_id;

Line: 323


             select 'X'
             into l_dummy
	     from mtl_category_sets_vl mcs, mtl_categories_v mc
             where mcs.category_set_id = p_sc_domain_rec.category_set_id
             and mcs.structure_id = mc.structure_id
             and mc.category_id = p_sc_domain_rec.category_id;

Line: 377


                       'Calling Insert_Row table handler');

Line: 383


         CSD_SC_DOMAINS_PKG.Insert_Row
         (px_sc_domain_id 	      => x_sc_domain_id,
          p_object_version_number     => l_obj_ver_num,
          p_service_code_id        => p_sc_domain_rec.service_code_id,
          p_inventory_item_id         => l_inventory_item_id,
          p_category_id  	      => l_category_id,
          p_category_set_id  	      => l_category_set_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_domain_type_code          => p_sc_domain_rec.domain_type_code,
          p_attribute_category        => p_sc_domain_rec.attribute_category,
          p_attribute1                => p_sc_domain_rec.attribute1,
          p_attribute2                => p_sc_domain_rec.attribute2,
          p_attribute3                => p_sc_domain_rec.attribute3,
          p_attribute4                => p_sc_domain_rec.attribute4,
          p_attribute5                => p_sc_domain_rec.attribute5,
          p_attribute6                => p_sc_domain_rec.attribute6,
          p_attribute7                => p_sc_domain_rec.attribute7,
          p_attribute8                => p_sc_domain_rec.attribute8,
          p_attribute9                => p_sc_domain_rec.attribute9,
          p_attribute10               => p_sc_domain_rec.attribute10,
          p_attribute11               => p_sc_domain_rec.attribute11,
          p_attribute12               => p_sc_domain_rec.attribute12,
          p_attribute13               => p_sc_domain_rec.attribute13,
          p_attribute14               => p_sc_domain_rec.attribute14,
          p_attribute15               => p_sc_domain_rec.attribute15
 	  );

Line: 417


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

Line: 428


                       'Returned from Insert_Row table handler');

Line: 727


/* procedure name: Update_SC_Domain                 */
/* description   : procedure used to update         */
/*                 sc domain	                    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_SC_Domain
(
  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_domain_rec	 	IN  SC_DOMAIN_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

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

Line: 753


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_sc_domains_pvt.update_sc_domain';

Line: 754


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

Line: 788


       SAVEPOINT  Update_SC_Domain;

Line: 806


               'Entered Update_SC_Domain');

Line: 873


          select 'X'
          into l_dummy
          from csd_sc_domains
 	  where sc_domain_id = p_sc_domain_rec.sc_domain_id;

Line: 902


          select object_version_number
          into l_obj_ver_num
          from csd_sc_domains
 	  where sc_domain_id = p_sc_domain_rec.sc_domain_id;

Line: 951


         select 'X'
         into l_dummy
         from csd_sc_domains
	 where sc_domain_id <> p_sc_domain_rec.sc_domain_id
 	 and service_code_id = p_sc_domain_rec.service_code_id
	 and domain_type_code = p_sc_domain_rec.domain_type_code
	 and inventory_item_id = p_sc_domain_rec.inventory_item_id
         and category_set_id = p_sc_domain_rec.category_set_id
         and category_id = p_sc_domain_rec.category_id;

Line: 961


         select 'X'
         into l_dummy
         from csd_sc_domains
	 where sc_domain_id <> p_sc_domain_rec.sc_domain_id
 	 and (service_code_id = p_sc_domain_rec.service_code_id
	 and domain_type_code = p_sc_domain_rec.domain_type_code
	 and inventory_item_id = p_sc_domain_rec.inventory_item_id)
	 or  (service_code_id = p_sc_domain_rec.service_code_id
	 and domain_type_code = p_sc_domain_rec.domain_type_code
	 and category_set_id = p_sc_domain_rec.category_set_id
         and category_id = p_sc_domain_rec.category_id);

Line: 1012


           select inventory_item_id
           into l_inventory_item_id
           from csd_sc_domains_v
           where sc_domain_id = p_sc_domain_rec.sc_domain_id
           and domain_type_code = p_sc_domain_rec.domain_type_code;

Line: 1043


           select inventory_item_id
           into l_inventory_item_id
           from mtl_system_items_kfv
           where organization_id = cs_std.get_item_valdn_orgzn_id
           and inventory_item_id = p_sc_domain_rec.inventory_item_id;

Line: 1089


           select category_set_id
           into l_category_set_id
           from csd_sc_domains_v
           where sc_domain_id = p_sc_domain_rec.sc_domain_id
           and domain_type_code = p_sc_domain_rec.domain_type_code;

Line: 1121


           select category_set_id
           into l_category_set_id
           from mtl_category_sets_vl
           where category_set_id = p_sc_domain_rec.category_set_id;

Line: 1154


           select validate_flag
           into l_valid_cat_flag
           from mtl_category_sets_vl
           where category_set_id = l_category_set_id;

Line: 1185


             select category_id
             into l_category_id
             from csd_sc_domains_v
             where sc_domain_id = p_sc_domain_rec.sc_domain_id
             and domain_type_code = p_sc_domain_rec.domain_type_code;

Line: 1234


             select 'X'
             into l_dummy
	     from mtl_category_set_valid_cats_v
             where category_set_id = l_category_set_id
             and category_id = l_category_id;

Line: 1246


             select 'X'
             into l_dummy
	     from mtl_category_sets_vl mcs, mtl_categories_v mc
             where mcs.category_set_id = l_category_set_id
             and mcs.structure_id = mc.structure_id
             and mc.category_id = l_category_id;

Line: 1297


                        'Calling Update_Row table handler');

Line: 1303


         CSD_SC_DOMAINS_PKG.Update_Row
         (p_sc_domain_id 	      => p_sc_domain_rec.sc_domain_id,
          p_object_version_number     => l_obj_ver_num + 1,
          p_service_code_id        => p_sc_domain_rec.service_code_id,
          p_inventory_item_id         => l_inventory_item_id,
          p_category_id  	      => l_category_id,
          p_category_set_id  	      => l_category_set_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_domain_type_code          => p_sc_domain_rec.domain_type_code,
          p_attribute_category        => p_sc_domain_rec.attribute_category,
          p_attribute1                => p_sc_domain_rec.attribute1,
          p_attribute2                => p_sc_domain_rec.attribute2,
          p_attribute3                => p_sc_domain_rec.attribute3,
          p_attribute4                => p_sc_domain_rec.attribute4,
          p_attribute5                => p_sc_domain_rec.attribute5,
          p_attribute6                => p_sc_domain_rec.attribute6,
          p_attribute7                => p_sc_domain_rec.attribute7,
          p_attribute8                => p_sc_domain_rec.attribute8,
          p_attribute9                => p_sc_domain_rec.attribute9,
          p_attribute10               => p_sc_domain_rec.attribute10,
          p_attribute11               => p_sc_domain_rec.attribute11,
          p_attribute12               => p_sc_domain_rec.attribute12,
          p_attribute13               => p_sc_domain_rec.attribute13,
          p_attribute14               => p_sc_domain_rec.attribute14,
          p_attribute15               => p_sc_domain_rec.attribute15
         );

Line: 1339


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

Line: 1350


                       'Returned from Update_Row table handler');

Line: 1367


                       'Leaving Update_SC_Domain');

Line: 1372


          ROLLBACK TO Update_SC_Domain;

Line: 1397


          ROLLBACK TO Update_SC_Domain;

Line: 1423


          ROLLBACK TO Update_SC_Domain;

Line: 1448


          ROLLBACK TO Update_SC_Domain;

Line: 1473


          ROLLBACK TO Update_SC_Domain;

Line: 1498


          ROLLBACK TO Update_SC_Domain;

Line: 1523


          ROLLBACK TO Update_SC_Domain;

Line: 1548


          ROLLBACK TO Update_SC_Domain;

Line: 1573


          ROLLBACK TO Update_SC_Domain;

Line: 1598


          ROLLBACK TO Update_SC_Domain;

Line: 1623


          ROLLBACK TO Update_SC_Domain;

Line: 1648


          ROLLBACK TO Update_SC_Domain;

Line: 1673


          ROLLBACK TO Update_SC_Domain;

Line: 1698


          ROLLBACK TO Update_SC_Domain;

Line: 1713


          ROLLBACK TO Update_SC_Domain;

Line: 1740


          ROLLBACK TO Update_SC_Domain;

Line: 1768


END Update_SC_Domain;

Line: 1771


/* procedure name: Delete_SC_Domain                 */
/* description   : procedure used to delete         */
/*                 sc domain	                    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_SC_Domain
(
  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_domain_id	 	IN  NUMBER
) IS

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

Line: 1796


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_sc_domains_pvt.delete_sc_domain';

Line: 1797


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

Line: 1807


       SAVEPOINT  Delete_SC_Domain;

Line: 1825


                'Entered Delete_SC_Domain');

Line: 1848


                         'Calling Delete_Row table handler');

Line: 1854


         CSD_SC_DOMAINS_PKG.Delete_Row
         (p_sc_domain_id 	      => p_sc_domain_id	);

Line: 1860


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

Line: 1871


                       'Returned from Delete_Row table handler');

Line: 1888


                       'Leaving Delete_SC_Domain');

Line: 1894


          ROLLBACK TO Delete_SC_Domain;

Line: 1909


          ROLLBACK TO Delete_SC_Domain;

Line: 1936


          ROLLBACK TO Delete_SC_Domain;

Line: 1964


END Delete_SC_Domain;

Line: 2068


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