The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
END update_counter_group_pre;
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;
END update_counter_group_post;
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;
END update_item_association_pre;
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;
END update_item_association_post;
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;
END update_counter_template_pre;
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;
END update_counter_template_post;
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;
END update_ctr_prop_template_pre;
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;
END update_ctr_prop_template_post;
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;
END update_ctr_relationship_pre;
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;
END update_ctr_relationship_post;
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;
END update_derived_filters_pre;
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;
END update_derived_filters_post;
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;
END Update_Estimation_Method_pre;
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;
END Update_Estimation_Method_post;
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;
END delete_item_association_pre;
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;
END delete_item_association_post;