The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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';
SAVEPOINT update_counter_pub;
csi_ctr_gen_utility_pvt.put_line( 'update_counter');
csi_ctr_gen_utility_pvt.put_line( 'update_counter' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_COUNTER_PRE API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_COUNTER_PRE API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_COUNTER API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_PROPERTY API');
ELSE -- PROPERTY ID IS NULL. INSERT NEW PROPERTY
l_Ctr_properties_rec.counter_id := p_counter_instance_rec.counter_id;
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP API');
ELSE --RELATIONSHIP_ID is null, call to insert counter relationship
l_counter_relationships_rec.OBJECT_COUNTER_ID := p_counter_instance_rec.counter_id;
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_ASSOCIATIONS API');
ELSE --instance_association_id is null. insert new counter association
l_counter_associations_rec.COUNTER_ID := p_counter_instance_rec.counter_id;
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_COUNTER_POST API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_COUNTER_POST API');
ROLLBACK TO update_counter_pub;
ROLLBACK TO update_counter_pub;
ROLLBACK TO update_counter_pub;
END update_counter;
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';
SAVEPOINT update_ctr_property_pub;
csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property');
csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_PROPERTY_PRE API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_CTR_PROPERTY_PRE API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_PROPERTY API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_PROPERTY_POST API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_CTR_PROPERTY_POST API');
ROLLBACK TO update_ctr_property_pub;
ROLLBACK TO update_ctr_property_pub;
ROLLBACK TO update_ctr_property_pub;
END update_ctr_property;
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';
SAVEPOINT update_ctr_associations_pub;
csi_ctr_gen_utility_pvt.put_line( 'update_ctr_associations');
csi_ctr_gen_utility_pvt.put_line( 'update_ctr_associations' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_PRE API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_PRE API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_ASSOCIATIONS API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_POST API');
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
);
csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_POST API');
ROLLBACK TO update_ctr_associations_pub;
ROLLBACK TO update_ctr_associations_pub;
ROLLBACK TO update_ctr_associations_pub;
END update_ctr_associations;