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.CSI_COUNTER_PUB SQL Statements

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

Line: 61


    SELECT ccp.counter_property_id,ccp.default_value,ccp.property_data_type, ccp.is_nullable
    FROM CSI_COUNTER_PROPERTIES_B ccp
    WHERE ccp.counter_id = p_counter_id AND NVL(ccp.is_nullable,'N') = 'N'
    AND   NVL(end_date_active,(SYSDATE+1)) > SYSDATE;

Line: 1770


PROCEDURE update_counter
 (
     p_api_version	             IN	NUMBER
    ,p_init_msg_list	          	IN	VARCHAR2
    ,p_commit		                 IN	VARCHAR2
    ,p_validation_level         IN NUMBER
    ,p_counter_instance_rec	    IN out	NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
    ,P_ctr_properties_tbl       IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
    ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
    ,P_ctr_derived_filters_tbl  IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
    ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
    ,x_return_status               out NOCOPY VARCHAR2
    ,x_msg_count                   out NOCOPY NUMBER
    ,x_msg_data                    out NOCOPY VARCHAR2
 )
 IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_COUNTER';

Line: 1803


   SAVEPOINT  update_counter_pub;

Line: 1830


      csi_ctr_gen_utility_pvt.put_line( 'update_counter');

Line: 1835


      csi_ctr_gen_utility_pvt.put_line( 'update_counter'     ||
                                     p_api_version         ||'-'||
                                     p_commit              ||'-'||
                                     p_init_msg_list       ||'-'||
                                     p_validation_level );

Line: 1845


     CSI_COUNTER_CUHK.update_counter_pre
     (
      p_api_version	                => p_api_version
      ,p_init_msg_list	             => p_init_msg_list
      ,p_commit		                   => p_commit
      ,p_validation_level           => p_validation_level
      ,p_counter_instance_rec	      => p_counter_instance_rec
      ,P_ctr_properties_tbl         => P_ctr_properties_tbl
      ,P_counter_relationships_tbl  => P_counter_relationships_tbl
      ,P_ctr_derived_filters_tbl    => P_ctr_derived_filters_tbl
      --,P_counter_associations_tbl   => P_counter_associations_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 1868


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_COUNTER_PRE API');

Line: 1878


     CSI_COUNTER_VUHK.update_counter_pre
     (
      p_api_version	                => p_api_version
      ,p_init_msg_list	             => p_init_msg_list
      ,p_commit		                   => p_commit
      ,p_validation_level           => p_validation_level
      ,p_counter_instance_rec	      => p_counter_instance_rec
      ,P_ctr_properties_tbl         => P_ctr_properties_tbl
      ,P_counter_relationships_tbl  => P_counter_relationships_tbl
      ,P_ctr_derived_filters_tbl    => P_ctr_derived_filters_tbl
      --,P_counter_associations_tbl   => P_counter_associations_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 1901


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_COUNTER_PRE API');

Line: 1911


   CSI_COUNTER_PVT.update_counter
   (
     p_api_version	=>	1.0
    ,p_init_msg_list	=>	p_init_msg_list
    ,p_commit		=>	p_commit
    ,p_validation_level	=>	p_validation_level
    ,p_counter_instance_rec => p_counter_instance_rec
    ,x_return_status	=>	x_return_status
    ,x_msg_count	=>	x_msg_count
    ,x_msg_data		=>	x_msg_data
    );

Line: 1930


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_COUNTER API');

Line: 1981


              CSI_COUNTER_PVT.update_ctr_property
            	 (
           	   p_api_version	=>	1.0
           	  ,p_init_msg_list	=>	p_init_msg_list
           	  ,p_commit		=>	p_commit
           	  ,p_validation_level	=>	p_validation_level
              ,p_ctr_properties_rec => l_ctr_properties_rec
           	  ,x_return_status	=>	x_return_status
           	  ,x_msg_count		=>	x_msg_count
           	  ,x_msg_data		=>	x_msg_data
           	  );

Line: 2000


                  csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_PROPERTY API');

Line: 2007


             ELSE -- PROPERTY ID IS NULL. INSERT NEW PROPERTY
              l_Ctr_properties_rec.counter_id := p_counter_instance_rec.counter_id;

Line: 2078


              CSI_COUNTER_TEMPLATE_PVT.update_counter_relationship
            	 (
          	   p_api_version	=>	1.0
           	  ,p_init_msg_list	=>	p_init_msg_list
           	  ,p_commit		=>	p_commit
           	  ,p_validation_level	=>	p_validation_level
              ,p_counter_relationships_rec => l_counter_relationships_rec
           	  ,x_return_status	=>	x_return_status
           	  ,x_msg_count		=>	x_msg_count
           	  ,x_msg_data		=>	x_msg_data
            	 );

Line: 2097


                  csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP API');

Line: 2104


             ELSE --RELATIONSHIP_ID is null, call to insert counter relationship
              l_counter_relationships_rec.OBJECT_COUNTER_ID := p_counter_instance_rec.counter_id;

Line: 2147


             CSI_COUNTER_TEMPLATE_PVT.update_derived_filters
           	 (
           	   p_api_version	=>	1.0
           	  ,p_init_msg_list	=>	p_init_msg_list
           	  ,p_commit		=>	p_commit
           	  ,p_validation_level	=>	p_validation_level
              ,p_ctr_derived_filters_tbl => p_ctr_derived_filters_tbl
           	  ,x_return_status	=>	x_return_status
           	  ,x_msg_count		=>	x_msg_count
           	  ,x_msg_data		=>	x_msg_data
           	 );

Line: 2166


                  csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS API');

Line: 2212


              CSI_COUNTER_PVT.update_ctr_associations
            	 (
           	   p_api_version	=>	1.0
           	  ,p_init_msg_list	=>	p_init_msg_list
           	  ,p_commit		=>	p_commit
           	  ,p_validation_level	=>	p_validation_level
              ,p_counter_associations_rec => l_counter_associations_rec
           	  ,x_return_status	=>	x_return_status
           	  ,x_msg_count		=>	x_msg_count
           	  ,x_msg_data		=>	x_msg_data
            	 );

Line: 2231


                  csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_ASSOCIATIONS API');

Line: 2238


             ELSE --instance_association_id is null. insert new counter association
              l_counter_associations_rec.COUNTER_ID  := p_counter_instance_rec.counter_id;

Line: 2277


     CSI_COUNTER_CUHK.update_counter_post
     (
      p_api_version	            => p_api_version
      ,p_init_msg_list	            => p_init_msg_list
      ,p_commit		            => p_commit
      ,p_validation_level           => p_validation_level
      ,p_counter_instance_rec       => p_counter_instance_rec
      ,P_ctr_properties_tbl         => P_ctr_properties_tbl
      ,P_counter_relationships_tbl  => P_counter_relationships_tbl
      ,P_ctr_derived_filters_tbl    => P_ctr_derived_filters_tbl
      --,P_counter_associations_tbl   => P_counter_associations_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2300


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_COUNTER_POST API');

Line: 2310


     CSI_COUNTER_VUHK.update_counter_post
     (
      p_api_version	            => p_api_version
      ,p_init_msg_list	            => p_init_msg_list
      ,p_commit		            => p_commit
      ,p_validation_level           => p_validation_level
      ,p_counter_instance_rec       => p_counter_instance_rec
      ,P_ctr_properties_tbl         => P_ctr_properties_tbl
      ,P_counter_relationships_tbl  => P_counter_relationships_tbl
      ,P_ctr_derived_filters_tbl    => P_ctr_derived_filters_tbl
      --,P_counter_associations_tbl   => P_counter_associations_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2333


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_COUNTER_POST API');

Line: 2350


      ROLLBACK TO update_counter_pub;

Line: 2358


      ROLLBACK TO update_counter_pub;

Line: 2365


      ROLLBACK TO update_counter_pub;

Line: 2378


END update_counter;

Line: 2386


PROCEDURE update_ctr_property
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,P_ctr_properties_tbl        IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
    ,x_return_status             OUT    NOCOPY VARCHAR2
    ,x_msg_count                 OUT    NOCOPY NUMBER
    ,x_msg_data                  OUT    NOCOPY VARCHAR2
 )
 IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_CTR_PROPERTY';

Line: 2412


   SAVEPOINT  update_ctr_property_pub;

Line: 2439


      csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property');

Line: 2444


      csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property'     ||
                                     p_api_version         ||'-'||
                                     p_commit              ||'-'||
                                     p_init_msg_list       ||'-'||
                                     p_validation_level );

Line: 2454


     CSI_COUNTER_CUHK.update_ctr_property_pre
     (
      p_api_version	                => p_api_version
      ,p_init_msg_list	             => p_init_msg_list
      ,p_commit		                   => p_commit
      ,p_validation_level           => p_validation_level
      ,P_ctr_properties_tbl 	       => P_ctr_properties_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2473


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_PROPERTY_PRE API');

Line: 2483


     CSI_COUNTER_VUHK.update_ctr_property_pre
     (
      p_api_version	                => p_api_version
      ,p_init_msg_list	             => p_init_msg_list
      ,p_commit		                   => p_commit
      ,p_validation_level           => p_validation_level
      ,P_ctr_properties_tbl 	       => P_ctr_properties_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2502


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_CTR_PROPERTY_PRE API');

Line: 2549


             CSI_COUNTER_PVT.update_ctr_property
           	 (
           	   p_api_version	=> 1.0
           	  ,p_init_msg_list	=> p_init_msg_list
           	  ,p_commit		=> p_commit
           	  ,p_validation_level	=> p_validation_level
                  ,p_ctr_properties_rec => l_ctr_properties_rec
           	  ,x_return_status	=> x_return_status
           	  ,x_msg_count		=> x_msg_count
           	  ,x_msg_data		=> x_msg_data
           	  );

Line: 2568


                  csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_PROPERTY API');

Line: 2583


     CSI_COUNTER_CUHK.update_ctr_property_post
     (
      p_api_version	                => p_api_version
      ,p_init_msg_list	             => p_init_msg_list
      ,p_commit		                   => p_commit
      ,p_validation_level           => p_validation_level
      ,P_ctr_properties_tbl 	       => P_ctr_properties_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2602


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_PROPERTY_POST API');

Line: 2612


     CSI_COUNTER_VUHK.update_ctr_property_post
     (
      p_api_version	                => p_api_version
      ,p_init_msg_list	             => p_init_msg_list
      ,p_commit		                   => p_commit
      ,p_validation_level           => p_validation_level
      ,P_ctr_properties_tbl 	       => P_ctr_properties_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2631


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_CTR_PROPERTY_POST API');

Line: 2648


      ROLLBACK TO update_ctr_property_pub;

Line: 2656


      ROLLBACK TO update_ctr_property_pub;

Line: 2663


      ROLLBACK TO update_ctr_property_pub;

Line: 2676


END update_ctr_property;

Line: 2678


PROCEDURE update_ctr_associations
 (
   p_api_version               IN     NUMBER
  ,p_commit                    IN     VARCHAR2
  ,p_init_msg_list             IN     VARCHAR2
  ,p_validation_level          IN     NUMBER
  ,p_counter_associations_tbl  IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
  ,x_return_status                OUT    NOCOPY VARCHAR2
  ,x_msg_count                    OUT    NOCOPY NUMBER
  ,x_msg_data                     OUT    NOCOPY VARCHAR2
 )
IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_CTR_ASSOCIATIONS';

Line: 2704


   SAVEPOINT update_ctr_associations_pub;

Line: 2731


      csi_ctr_gen_utility_pvt.put_line( 'update_ctr_associations');

Line: 2736


      csi_ctr_gen_utility_pvt.put_line( 'update_ctr_associations'     ||
                                     p_api_version         ||'-'||
                                     p_commit              ||'-'||
                                     p_init_msg_list       ||'-'||
                                     p_validation_level );

Line: 2746


     CSI_COUNTER_CUHK.update_ctr_associations_pre
     (
       p_api_version	           => p_api_version
      ,p_init_msg_list	           => p_init_msg_list
      ,p_commit		           => p_commit
      ,p_validation_level          => p_validation_level
      ,P_counter_associations_tbl  => P_counter_associations_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2765


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_PRE API');

Line: 2776


     CSI_COUNTER_VUHK.update_ctr_associations_pre
     (
       p_api_version               => p_api_version
      ,p_init_msg_list             => p_init_msg_list
      ,p_commit                    => p_commit
      ,p_validation_level          => p_validation_level
      ,P_counter_associations_tbl  => P_counter_associations_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2795


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_PRE API');

Line: 2836


             CSI_COUNTER_PVT.update_ctr_associations
           	 (
           	   p_api_version	=>	1.0
           	  ,p_init_msg_list	=>	p_init_msg_list
           	  ,p_commit		=>	p_commit
           	  ,p_validation_level	=>	p_validation_level
                  ,p_counter_associations_rec => l_counter_associations_rec
           	  ,x_return_status	=>	x_return_status
           	  ,x_msg_count		=>	x_msg_count
           	  ,x_msg_data		=>	x_msg_data
           	 );

Line: 2855


                  csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_ASSOCIATIONS API');

Line: 2870


     CSI_COUNTER_CUHK.update_ctr_associations_post
     (
       p_api_version               => p_api_version
      ,p_init_msg_list             => p_init_msg_list
      ,p_commit                    => p_commit
      ,p_validation_level          => p_validation_level
      ,P_counter_associations_tbl  => P_counter_associations_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2889


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_POST API');

Line: 2900


     CSI_COUNTER_VUHK.update_ctr_associations_post
     (
       p_api_version               => p_api_version
      ,p_init_msg_list             => p_init_msg_list
      ,p_commit                    => p_commit
      ,p_validation_level          => p_validation_level
      ,P_counter_associations_tbl  => P_counter_associations_tbl
      ,x_return_status              => x_return_status
      ,x_msg_count                  => x_msg_count
      ,x_msg_data                   => x_msg_data
     );

Line: 2919


             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_POST API');

Line: 2936


      ROLLBACK TO update_ctr_associations_pub;

Line: 2944


      ROLLBACK TO update_ctr_associations_pub;

Line: 2951


      ROLLBACK TO update_ctr_associations_pub;

Line: 2964


END update_ctr_associations;