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

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

Line: 146


         select 'X'
         into l_dummy
         from csd_dc_domains
	 where diagnostic_code_id = p_dc_domain_rec.diagnostic_code_id
	 and (domain_type_code = p_dc_domain_rec.domain_type_code
	 and inventory_item_id = p_dc_domain_rec.inventory_item_id)
         or (domain_type_code = p_dc_domain_rec.domain_type_code
         and category_set_id = p_dc_domain_rec.category_set_id
         and category_id = p_dc_domain_rec.category_id);

Line: 156


         select 'X'
         into l_dummy
         from csd_dc_domains
	 where (diagnostic_code_id = p_dc_domain_rec.diagnostic_code_id
	 and domain_type_code = p_dc_domain_rec.domain_type_code
	 and inventory_item_id = p_dc_domain_rec.inventory_item_id)
         or (diagnostic_code_id = p_dc_domain_rec.diagnostic_code_id
         and domain_type_code = p_dc_domain_rec.domain_type_code
         and category_set_id = p_dc_domain_rec.category_set_id
         and category_id = p_dc_domain_rec.category_id);

Line: 199


           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_dc_domain_rec.inventory_item_id;

Line: 237


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

Line: 266


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

Line: 308


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

Line: 320


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

Line: 374


                       'Calling Insert_Row table handler');

Line: 379


         CSD_DC_DOMAINS_PKG.Insert_Row
         (px_dc_domain_id 	      => x_dc_domain_id,
          p_object_version_number     => l_obj_ver_num,
          p_diagnostic_code_id        => p_dc_domain_rec.diagnostic_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_dc_domain_rec.domain_type_code,
          p_attribute_category        => p_dc_domain_rec.attribute_category,
          p_attribute1                => p_dc_domain_rec.attribute1,
          p_attribute2                => p_dc_domain_rec.attribute2,
          p_attribute3                => p_dc_domain_rec.attribute3,
          p_attribute4                => p_dc_domain_rec.attribute4,
          p_attribute5                => p_dc_domain_rec.attribute5,
          p_attribute6                => p_dc_domain_rec.attribute6,
          p_attribute7                => p_dc_domain_rec.attribute7,
          p_attribute8                => p_dc_domain_rec.attribute8,
          p_attribute9                => p_dc_domain_rec.attribute9,
          p_attribute10               => p_dc_domain_rec.attribute10,
          p_attribute11               => p_dc_domain_rec.attribute11,
          p_attribute12               => p_dc_domain_rec.attribute12,
          p_attribute13               => p_dc_domain_rec.attribute13,
          p_attribute14               => p_dc_domain_rec.attribute14,
          p_attribute15               => p_dc_domain_rec.attribute15
 	 );

Line: 413


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

Line: 424


                       'Returned from Insert_Row table handler');

Line: 724


/* procedure name: Update_DC_Domain                 */
/* description   : procedure used to update         */
/*                 dc domain	                    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_DC_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_dc_domain_rec	 	IN  DC_DOMAIN_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

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

Line: 750


 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_diagnostic_codes_pvt.update_dc_domain';

Line: 751


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

Line: 785


       SAVEPOINT  Update_DC_Domain;

Line: 803


               'Entered Update_DC_Domain');

Line: 870


         select 'X'
         into l_dummy
         from csd_dc_domains
 	 where dc_domain_id = p_dc_domain_rec.dc_domain_id;

Line: 900


          select object_version_number
          into l_obj_ver_num
          from csd_dc_domains
 	  where dc_domain_id = p_dc_domain_rec.dc_domain_id;

Line: 938


         select 'X'
         into l_dummy
         from csd_dc_domains
	 where dc_domain_id <> p_dc_domain_rec.dc_domain_id
 	 and diagnostic_code_id = p_dc_domain_rec.diagnostic_code_id
	 and domain_type_code = p_dc_domain_rec.domain_type_code
	 and inventory_item_id = p_dc_domain_rec.inventory_item_id
         and category_set_id = p_dc_domain_rec.category_set_id
         and category_id = p_dc_domain_rec.category_id;

Line: 948


         select 'X'
         into l_dummy
         from csd_dc_domains
	 where dc_domain_id <> p_dc_domain_rec.dc_domain_id
 	 and (diagnostic_code_id = p_dc_domain_rec.diagnostic_code_id
	 and domain_type_code = p_dc_domain_rec.domain_type_code
	 and inventory_item_id = p_dc_domain_rec.inventory_item_id)
	 or  (diagnostic_code_id = p_dc_domain_rec.diagnostic_code_id
	 and domain_type_code = p_dc_domain_rec.domain_type_code
	 and category_set_id = p_dc_domain_rec.category_set_id
         and category_id = p_dc_domain_rec.category_id);

Line: 999


           select inventory_item_id
           into l_inventory_item_id
           from csd_dc_domains_v
           where dc_domain_id = p_dc_domain_rec.dc_domain_id
           and domain_type_code = p_dc_domain_rec.domain_type_code;

Line: 1030


           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_dc_domain_rec.inventory_item_id;

Line: 1076


           select category_set_id
           into l_category_set_id
           from csd_dc_domains_v
           where dc_domain_id = p_dc_domain_rec.dc_domain_id
           and domain_type_code = p_dc_domain_rec.domain_type_code;

Line: 1108


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

Line: 1141


           select validate_flag
           into l_valid_cat_flag
           from mtl_category_sets_vl
           where category_set_id = l_category_set_id;

Line: 1172


             select category_id
             into l_category_id
             from csd_dc_domains_v
             where dc_domain_id = p_dc_domain_rec.dc_domain_id
             and domain_type_code = p_dc_domain_rec.domain_type_code;

Line: 1221


             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: 1233


             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: 1284


                        'Calling Update_Row table handler');

Line: 1289


         CSD_DC_DOMAINS_PKG.Update_Row
         (p_dc_domain_id 	      => p_dc_domain_rec.dc_domain_id,
          p_object_version_number     => l_obj_ver_num + 1,
          p_diagnostic_code_id        => p_dc_domain_rec.diagnostic_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_dc_domain_rec.domain_type_code,
          p_attribute_category        => p_dc_domain_rec.attribute_category,
          p_attribute1                => p_dc_domain_rec.attribute1,
          p_attribute2                => p_dc_domain_rec.attribute2,
          p_attribute3                => p_dc_domain_rec.attribute3,
          p_attribute4                => p_dc_domain_rec.attribute4,
          p_attribute5                => p_dc_domain_rec.attribute5,
          p_attribute6                => p_dc_domain_rec.attribute6,
          p_attribute7                => p_dc_domain_rec.attribute7,
          p_attribute8                => p_dc_domain_rec.attribute8,
          p_attribute9                => p_dc_domain_rec.attribute9,
          p_attribute10               => p_dc_domain_rec.attribute10,
          p_attribute11               => p_dc_domain_rec.attribute11,
          p_attribute12               => p_dc_domain_rec.attribute12,
          p_attribute13               => p_dc_domain_rec.attribute13,
          p_attribute14               => p_dc_domain_rec.attribute14,
          p_attribute15               => p_dc_domain_rec.attribute15
         );

Line: 1325


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

Line: 1336


                       'Returned from Update_Row table handler');

Line: 1353


                       'Leaving Update_DC_Domain');

Line: 1358


          ROLLBACK TO Update_DC_Domain;

Line: 1383


          ROLLBACK TO Update_DC_Domain;

Line: 1409


          ROLLBACK TO Update_DC_Domain;

Line: 1434


          ROLLBACK TO Update_DC_Domain;

Line: 1459


          ROLLBACK TO Update_DC_Domain;

Line: 1484


          ROLLBACK TO Update_DC_Domain;

Line: 1509


          ROLLBACK TO Update_DC_Domain;

Line: 1534


          ROLLBACK TO Update_DC_Domain;

Line: 1559


          ROLLBACK TO Update_DC_Domain;

Line: 1584


          ROLLBACK TO Update_DC_Domain;

Line: 1609


          ROLLBACK TO Update_DC_Domain;

Line: 1634


          ROLLBACK TO Update_DC_Domain;

Line: 1659


          ROLLBACK TO Update_DC_Domain;

Line: 1684


          ROLLBACK TO Update_DC_Domain;

Line: 1699


          ROLLBACK TO Update_DC_Domain;

Line: 1726


          ROLLBACK TO Update_DC_Domain;

Line: 1754


END Update_DC_Domain;

Line: 1757


/* procedure name: Delete_DC_Domain                 */
/* description   : procedure used to delete         */
/*                 dc domain	                    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_DC_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_dc_domain_id	 	IN  NUMBER
) IS

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

Line: 1783


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

Line: 1793


       SAVEPOINT  Delete_DC_Domain;

Line: 1811


                'Entered Delete_DC_Domain');

Line: 1834


                        'Calling Delete_Row table handler');

Line: 1840


         CSD_DC_DOMAINS_PKG.Delete_Row
         (  p_dc_domain_id 	      => p_dc_domain_id	);

Line: 1846


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

Line: 1857


                       'Returned from Delete_Row table handler');

Line: 1874


                       'Leaving Delete_DC_Domain');

Line: 1880


          ROLLBACK TO Delete_DC_Domain;

Line: 1895


          ROLLBACK TO Delete_DC_Domain;

Line: 1922


          ROLLBACK TO Delete_DC_Domain;

Line: 1950


END Delete_DC_Domain;

Line: 2054


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

Line: 2081


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