DBA Data[Home] [Help]

APPS.CSI_COUNTER_TEMPLATE_VUHK SQL Statements

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

Line: 303

PROCEDURE update_counter_group_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_groups_rec        IN CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
    ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_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: 317

END update_counter_group_pre;
Line: 327

PROCEDURE update_counter_group_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_groups_rec        IN CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
    ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_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: 341

END update_counter_group_post;
Line: 352

PROCEDURE update_item_association_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_item_associations_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_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: 365

END update_item_association_pre;
Line: 376

PROCEDURE update_item_association_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_item_associations_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_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: 389

END update_item_association_post;
Line: 399

PROCEDURE update_counter_template_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_template_rec      IN CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
    ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
    ,p_ctr_property_template_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_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: 416

END update_counter_template_pre;
Line: 426

PROCEDURE update_counter_template_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_template_rec      IN CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
    ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
    ,p_ctr_property_template_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_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: 443

END update_counter_template_post;
Line: 453

PROCEDURE update_ctr_prop_template_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_property_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_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: 466

END update_ctr_prop_template_pre;
Line: 476

PROCEDURE update_ctr_prop_template_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_property_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_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: 489

END update_ctr_prop_template_post;
Line: 499

PROCEDURE update_ctr_relationship_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_relationships_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_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: 512

END update_ctr_relationship_pre;
Line: 522

PROCEDURE update_ctr_relationship_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_relationships_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_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: 535

END update_ctr_relationship_post;
Line: 545

PROCEDURE update_derived_filters_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,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: 558

END update_derived_filters_pre;
Line: 568

PROCEDURE update_derived_filters_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,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: 581

END update_derived_filters_post;
Line: 619

PROCEDURE Update_Estimation_Method_pre
(
    p_api_version                IN      NUMBER
    ,p_init_msg_list             IN      VARCHAR2
    ,p_commit                    IN      VARCHAR2
    ,p_validation_level          IN      VARCHAR2
    ,x_return_status             OUT NOCOPY  VARCHAR2
    ,x_msg_count                 OUT NOCOPY  NUMBER
    ,x_msg_data                  OUT NOCOPY  VARCHAR2
    ,p_ctr_estimation_rec        IN OUT NOCOPY    CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
)	IS
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;
Line: 632

END Update_Estimation_Method_pre;
Line: 636

PROCEDURE Update_Estimation_Method_post
(
    p_api_version                IN      NUMBER
    ,p_init_msg_list             IN      VARCHAR2
    ,p_commit                    IN      VARCHAR2
    ,p_validation_level          IN      VARCHAR2
    ,x_return_status             OUT NOCOPY  VARCHAR2
    ,x_msg_count                 OUT NOCOPY  NUMBER
    ,x_msg_data                  OUT NOCOPY  VARCHAR2
    ,p_ctr_estimation_rec        IN OUT NOCOPY    CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
)	IS
BEGIN
	x_return_status := FND_API.G_RET_STS_SUCCESS;
Line: 649

END Update_Estimation_Method_post;
Line: 735

PROCEDURE delete_item_association_pre
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_associations_id       IN     NUMBER
    ,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: 748

END delete_item_association_pre;
Line: 750

PROCEDURE delete_item_association_post
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_associations_id       IN     NUMBER
    ,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: 763

END delete_item_association_post;