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

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

Line: 266


PROCEDURE update_counter_pre
 (
     p_api_version	             IN	NUMBER
    ,p_init_msg_list	         IN	VARCHAR2	:= FND_API.G_FALSE
    ,p_commit		             IN	VARCHAR2	:= FND_API.G_FALSE
    ,p_validation_level			 IN NUMBER
    ,p_counter_instance_rec	     IN CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
    ,P_ctr_properties_tbl        IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
    ,P_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
    ,P_ctr_derived_filters_tbl   IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
    ,x_return_status             out NOCOPY VARCHAR2
    ,x_msg_count                 out NOCOPY NUMBER
    ,x_msg_data                  out NOCOPY VARCHAR2
 ) IS
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 282


END update_counter_pre;

Line: 292


PROCEDURE update_counter_post
 (
     p_api_version	             IN	NUMBER
    ,p_init_msg_list	         IN	VARCHAR2	:= FND_API.G_FALSE
    ,p_commit		             IN	VARCHAR2	:= FND_API.G_FALSE
    ,p_validation_level			 IN NUMBER
    ,p_counter_instance_rec	     IN CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
    ,P_ctr_properties_tbl        IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
    ,P_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
    ,P_ctr_derived_filters_tbl   IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
    ,x_return_status             out NOCOPY VARCHAR2
    ,x_msg_count                 out NOCOPY NUMBER
    ,x_msg_data                  out NOCOPY VARCHAR2
 ) IS
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 308


END update_counter_post;

Line: 318


PROCEDURE update_ctr_property_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2  := FND_API.G_FALSE
    ,p_init_msg_list             IN     VARCHAR2  := FND_API.G_FALSE
    ,p_validation_level          IN     NUMBER
    ,P_ctr_properties_tbl        IN 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
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 331


END update_ctr_property_pre;

Line: 341


PROCEDURE update_ctr_property_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2  := FND_API.G_FALSE
    ,p_init_msg_list             IN     VARCHAR2  := FND_API.G_FALSE
    ,p_validation_level          IN     NUMBER
    ,P_ctr_properties_tbl        IN 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
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 354


END update_ctr_property_post;

Line: 364


PROCEDURE update_ctr_associations_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2  := FND_API.G_FALSE
    ,p_init_msg_list             IN     VARCHAR2  := FND_API.G_FALSE
    ,p_validation_level          IN     NUMBER
    ,P_counter_associations_tbl  IN 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
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 377


END update_ctr_associations_pre;

Line: 387


PROCEDURE update_ctr_associations_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2  := FND_API.G_FALSE
    ,p_init_msg_list             IN     VARCHAR2  := FND_API.G_FALSE
    ,p_validation_level          IN     NUMBER
    ,P_counter_associations_tbl  IN 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
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 400


END update_ctr_associations_post;

Line: 410


PROCEDURE update_reading_lock_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2  := FND_API.G_FALSE
    ,p_init_msg_list             IN     VARCHAR2  := FND_API.G_FALSE
    ,p_validation_level          IN     NUMBER
    ,p_ctr_reading_lock_rec		 IN CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
    ,x_return_status			 OUT    NOCOPY VARCHAR2
    ,x_msg_count                 OUT    NOCOPY NUMBER
    ,x_msg_data                  OUT    NOCOPY VARCHAR2
 ) IS
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 423


END update_reading_lock_pre;

Line: 433


PROCEDURE update_reading_lock_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2  := FND_API.G_FALSE
    ,p_init_msg_list             IN     VARCHAR2  := FND_API.G_FALSE
    ,p_validation_level          IN     NUMBER
    ,p_ctr_reading_lock_rec		 IN CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
    ,x_return_status			 OUT    NOCOPY VARCHAR2
    ,x_msg_count                 OUT    NOCOPY NUMBER
    ,x_msg_data                  OUT    NOCOPY VARCHAR2
 ) IS
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 446


END update_reading_lock_post;

Line: 456


PROCEDURE update_daily_usage_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2  := FND_API.G_FALSE
    ,p_init_msg_list             IN     VARCHAR2  := FND_API.G_FALSE
    ,p_validation_level          IN     NUMBER
    ,p_ctr_usage_forecast_rec    IN CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
    ,x_return_status             OUT    NOCOPY VARCHAR2
    ,x_msg_count                 OUT    NOCOPY NUMBER
    ,x_msg_data                  OUT    NOCOPY VARCHAR2
 ) IS
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 469


END update_daily_usage_pre;

Line: 479


PROCEDURE update_daily_usage_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2  := FND_API.G_FALSE
    ,p_init_msg_list             IN     VARCHAR2  := FND_API.G_FALSE
    ,p_validation_level          IN     NUMBER
    ,p_ctr_usage_forecast_rec    IN CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
    ,x_return_status             OUT    NOCOPY VARCHAR2
    ,x_msg_count                 OUT    NOCOPY NUMBER
    ,x_msg_data                  OUT    NOCOPY VARCHAR2
 ) IS
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 492


END update_daily_usage_post;