The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT group_id
FROM csi_ctr_item_associations
WHERE associated_to_group='Y'
AND inventory_item_id = p_inv_item_id;
SELECT ctr_association_id, inventory_item_id
FROM csi_ctr_item_associations
WHERE counter_id = p_counter_id;
SELECT ctr_association_id
FROM csi_ctr_item_associations
WHERE counter_id = p_mapped_counter_id
AND inventory_item_id = p_inv_item_id;
SELECT association_type
INTO l_association_type
FROM cs_counter_groups
WHERE counter_group_id = p_ctr_grp_id;
PROCEDURE Update_Ctr_Grp
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_grp_id IN NUMBER,
p_object_version_number IN NUMBER,
p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
p_cascade_upd_to_instances IN VARCHAR2 := FND_API.G_FALSE,
x_object_version_number OUT NOCOPY NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_GRP';
SAVEPOINT Update_Ctr_Grp_PUB;
CS_COUNTERS_CUHK.Update_Ctr_Grp_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_grp_id => p_ctr_grp_id,
p_object_version_number => p_object_version_number,
p_ctr_grp_rec => p_ctr_grp_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_Ctr_Grp_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_grp_id => p_ctr_grp_id,
p_object_version_number => p_object_version_number,
p_ctr_grp_rec => p_ctr_grp_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CSI_COUNTER_TEMPLATE_PUB.update_counter_group
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => l_validation_level
,p_counter_groups_rec => l_ctr_groups_rec
,p_ctr_item_associations_tbl => l_ctr_item_associations_tbl
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
ROLLBACK TO Update_Ctr_Grp_PUB;
CS_COUNTERS_CUHK.Update_Ctr_Grp_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_grp_id => p_ctr_grp_id,
p_object_version_number => p_object_version_number,
p_ctr_grp_rec => p_ctr_grp_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_Ctr_Grp_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_grp_id => p_ctr_grp_id,
p_object_version_number => p_object_version_number,
p_ctr_grp_rec => p_ctr_grp_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
ROLLBACK TO Update_Ctr_Grp_PUB;
ROLLBACK TO Update_Ctr_Grp_PUB;
ROLLBACK TO Update_Ctr_Grp_PUB;
end Update_Ctr_Grp;
PROCEDURE Update_Counter
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_id IN NUMBER,
p_object_version_number IN NUMBER,
p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
p_cascade_upd_to_instances IN VARCHAR2 := FND_API.G_FALSE,
x_object_version_number OUT NOCOPY NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER';
SAVEPOINT Update_Counter_PUB;
CS_COUNTERS_CUHK.Update_Counter_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_id => p_ctr_id,
p_object_version_number => p_object_version_number,
p_ctr_rec => p_ctr_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_Counter_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_id => p_ctr_id,
p_object_version_number => p_object_version_number,
p_ctr_rec => p_ctr_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CSI_COUNTER_TEMPLATE_PUB.update_counter_template
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => l_validation_level
,p_counter_template_rec => l_counter_template_rec
,p_ctr_item_associations_tbl => l_ctr_item_associations_tbl
,p_ctr_property_template_tbl => l_ctr_property_template_tbl
,p_counter_relationships_tbl => l_counter_relationships_tbl
,p_ctr_derived_filters_tbl => l_ctr_derived_filters_tbl
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
ROLLBACK TO Update_Counter_PUB;
CS_COUNTERS_CUHK.Update_Counter_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_id => p_ctr_id,
p_object_version_number => p_object_version_number,
p_ctr_rec => p_ctr_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_Counter_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_id => p_ctr_id,
p_object_version_number => p_object_version_number,
p_ctr_rec => p_ctr_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
ROLLBACK TO Update_Counter_PUB;
ROLLBACK TO Update_Counter_PUB;
ROLLBACK TO Update_Counter_PUB;
end Update_Counter;
PROCEDURE Update_Ctr_Prop
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_prop_id IN NUMBER,
p_object_version_number IN NUMBER,
p_ctr_prop_rec IN Ctr_Prop_Rec_Type,
p_cascade_upd_to_instances IN VARCHAR2 := FND_API.G_FALSE,
x_object_version_number OUT NOCOPY NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_PROP';
SAVEPOINT Update_Ctr_Prop_PUB;
CS_COUNTERS_CUHK.Update_Ctr_Prop_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_prop_id => p_ctr_prop_id,
p_object_version_number => p_object_version_number,
p_ctr_prop_rec => p_ctr_prop_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_Ctr_Prop_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_prop_id => p_ctr_prop_id,
p_object_version_number => p_object_version_number,
p_ctr_prop_rec => p_ctr_prop_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CSI_COUNTER_TEMPLATE_PUB.update_ctr_property_template
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => l_validation_level
,p_ctr_property_template_rec => l_ctr_property_template_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
ROLLBACK TO Update_Ctr_Prop_PUB;
CS_COUNTERS_CUHK.Update_Ctr_Prop_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_prop_id => p_ctr_prop_id,
p_object_version_number => p_object_version_number,
p_ctr_prop_rec => p_ctr_prop_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_Ctr_Prop_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_prop_id => p_ctr_prop_id,
p_object_version_number => p_object_version_number,
p_ctr_prop_rec => p_ctr_prop_rec,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
ROLLBACK TO Update_Ctr_Prop_PUB;
ROLLBACK TO Update_Ctr_Prop_PUB;
ROLLBACK TO Update_Ctr_Prop_PUB;
end Update_Ctr_Prop;
PROCEDURE Update_Formula_Ref
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_formula_bvar_id IN NUMBER,
p_object_version_number IN NUMBER,
p_counter_id IN NUMBER,
p_bind_var_name IN VARCHAR2,
p_mapped_item_id IN NUMBER := null,
p_mapped_counter_id IN NUMBER,
p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
p_cascade_upd_to_instances IN VARCHAR2 := FND_API.G_FALSE,
x_object_version_number OUT NOCOPY NUMBER,
p_reading_type IN VARCHAR2
) is
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULA_REF';
SAVEPOINT Update_Formula_Ref_PUB;
CS_COUNTERS_CUHK.Update_Formula_Ref_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_formula_bvar_id => p_ctr_formula_bvar_id,
p_object_version_number => p_object_version_number,
p_counter_id => p_counter_id,
p_bind_var_name => p_bind_var_name,
p_mapped_item_id => p_mapped_item_id,
p_mapped_counter_id => p_mapped_counter_id,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number,
p_reading_type => p_reading_type
);
CS_COUNTERS_VUHK.Update_Formula_Ref_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_formula_bvar_id => p_ctr_formula_bvar_id,
p_object_version_number => p_object_version_number,
p_counter_id => p_counter_id,
p_bind_var_name => p_bind_var_name,
p_mapped_item_id => p_mapped_item_id,
p_mapped_counter_id => p_mapped_counter_id,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number,
p_reading_type => p_reading_type
);
CS_COUNTERS_CUHK.Update_Formula_Ref_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_formula_bvar_id => p_ctr_formula_bvar_id,
p_object_version_number => p_object_version_number,
p_counter_id => p_counter_id,
p_bind_var_name => p_bind_var_name,
p_mapped_item_id => p_mapped_item_id,
p_mapped_counter_id => p_mapped_counter_id,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number,
p_reading_type => p_reading_type
);
CS_COUNTERS_VUHK.Update_Formula_Ref_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_formula_bvar_id => p_ctr_formula_bvar_id,
p_object_version_number => p_object_version_number,
p_counter_id => p_counter_id,
p_bind_var_name => p_bind_var_name,
p_mapped_item_id => p_mapped_item_id,
p_mapped_counter_id => p_mapped_counter_id,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number,
p_reading_type => p_reading_type
);
ROLLBACK TO Update_Formula_Ref_PUB;
ROLLBACK TO Update_Formula_Ref_PUB;
ROLLBACK TO Update_Formula_Ref_PUB;
end Update_Formula_Ref;
PROCEDURE Update_GrpOp_Filter
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_der_filter_id IN NUMBER,
p_object_version_number IN NUMBER,
p_seq_no IN NUMBER := null,
p_counter_id IN NUMBER,
p_left_paren IN VARCHAR2,
p_ctr_prop_id IN NUMBER,
p_rel_op IN VARCHAR2,
p_right_val IN VARCHAR2,
p_right_paren IN VARCHAR2,
p_log_op IN VARCHAR2,
p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
p_cascade_upd_to_instances IN VARCHAR2 := FND_API.G_FALSE,
x_object_version_number OUT NOCOPY NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GRPOP_FILTER';
SAVEPOINT Update_GrpOp_Filter_PUB;
CS_COUNTERS_CUHK.Update_GrpOp_Filter_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_der_filter_id => p_ctr_der_filter_id,
p_object_version_number => p_object_version_number,
p_seq_no => p_seq_no,
p_counter_id => p_counter_id,
p_left_paren => p_left_paren,
p_ctr_prop_id => p_ctr_prop_id,
p_rel_op => p_rel_op,
p_right_val => p_right_val,
p_right_paren => p_right_paren,
p_log_op => p_log_op,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_GrpOp_Filter_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_der_filter_id => p_ctr_der_filter_id,
p_object_version_number => p_object_version_number,
p_seq_no => p_seq_no,
p_counter_id => p_counter_id,
p_left_paren => p_left_paren,
p_ctr_prop_id => p_ctr_prop_id,
p_rel_op => p_rel_op,
p_right_val => p_right_val,
p_right_paren => p_right_paren,
p_log_op => p_log_op,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CSI_COUNTER_TEMPLATE_PUB.update_derived_filters
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => l_validation_level
,p_ctr_derived_filters_tbl => l_ctr_derived_filters_tbl
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
ROLLBACK TO Update_GrpOp_Filter_PUB;
CS_COUNTERS_CUHK.Update_GrpOp_Filter_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_der_filter_id => p_ctr_der_filter_id,
p_object_version_number => p_object_version_number,
p_seq_no => p_seq_no,
p_counter_id => p_counter_id,
p_left_paren => p_left_paren,
p_ctr_prop_id => p_ctr_prop_id,
p_rel_op => p_rel_op,
p_right_val => p_right_val,
p_right_paren => p_right_paren,
p_log_op => p_log_op,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_GrpOp_Filter_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_der_filter_id => p_ctr_der_filter_id,
p_object_version_number => p_object_version_number,
p_seq_no => p_seq_no,
p_counter_id => p_counter_id,
p_left_paren => p_left_paren,
p_ctr_prop_id => p_ctr_prop_id,
p_rel_op => p_rel_op,
p_right_val => p_right_val,
p_right_paren => p_right_paren,
p_log_op => p_log_op,
p_cascade_upd_to_instances => p_cascade_upd_to_instances,
x_object_version_number => x_object_version_number
);
ROLLBACK TO Update_GrpOp_Filter_PUB;
ROLLBACK TO Update_GrpOp_Filter_PUB;
ROLLBACK TO Update_GrpOp_Filter_PUB;
end Update_GrpOp_Filter;
PROCEDURE Update_Ctr_Association
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_association_id IN NUMBER,
p_object_version_number IN NUMBER,
p_ctr_grp_id IN NUMBER,
p_source_object_id IN NUMBER,
p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
x_object_version_number OUT NOCOPY NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_ASSOCIATION';
SAVEPOINT Update_Ctr_Association_PUB;
CS_COUNTERS_CUHK.Update_Ctr_Association_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_association_id => p_ctr_association_id,
p_object_version_number => p_object_version_number,
p_ctr_grp_id => p_ctr_grp_id,
p_source_object_id => p_source_object_id,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_Ctr_Association_Pre (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_association_id => p_ctr_association_id,
p_object_version_number => p_object_version_number,
p_ctr_grp_id => p_ctr_grp_id,
p_source_object_id => p_source_object_id,
x_object_version_number => x_object_version_number
);
CSI_COUNTER_TEMPLATE_PUB.update_item_association
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => l_validation_level
,p_ctr_item_associations_rec => l_ctr_item_associations_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
ROLLBACK TO Update_Ctr_Association_PUB;
CS_COUNTERS_CUHK.Update_Ctr_Association_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_association_id => p_ctr_association_id,
p_object_version_number => p_object_version_number,
p_ctr_grp_id => p_ctr_grp_id,
p_source_object_id => p_source_object_id,
x_object_version_number => x_object_version_number
);
CS_COUNTERS_VUHK.Update_Ctr_Association_Post (
p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ctr_association_id => p_ctr_association_id,
p_object_version_number => p_object_version_number,
p_ctr_grp_id => p_ctr_grp_id,
p_source_object_id => p_source_object_id,
x_object_version_number => x_object_version_number
);
ROLLBACK TO Update_Ctr_Association_PUB;
ROLLBACK TO Update_Ctr_Association_PUB;
ROLLBACK TO Update_Ctr_Association_PUB;
end Update_Ctr_Association;
PROCEDURE Delete_Counter
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_id IN NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_COUNTER';
end Delete_Counter;
PROCEDURE Delete_Ctr_Prop
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_prop_id IN NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CTR_PROP';
end Delete_Ctr_Prop;
PROCEDURE Delete_Formula_Ref
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_formula_bvar_id IN NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FORMULA_REF';
end Delete_Formula_Ref;
PROCEDURE Delete_GrpOp_Filter
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_der_filter_id IN NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GRPOP_FILTER';
end Delete_GrpOp_Filter;
PROCEDURE Delete_Ctr_Association
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ctr_association_id IN NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CTR_ASSOCIATION';
end Delete_Ctr_Association;
PROCEDURE DELETE_COUNTER_INSTANCE(
p_Api_Version IN NUMBER,
p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
p_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_SOURCE_OBJECT_ID IN NUMBER,
p_SOURCE_OBJECT_CODE IN VARCHAR2,
x_Return_status OUT NOCOPY VARCHAR2,
x_Msg_Count OUT NOCOPY NUMBER,
x_Msg_Data OUT NOCOPY VARCHAR2,
x_delete_status OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_COUNTER_INSTANCE';
END DELETE_COUNTER_INSTANCE;
PROCEDURE Update_Estimation_Method
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_estimation_id IN NUMBER,
p_object_version_number IN NUMBER,
p_ctr_estimation_rec IN CS_COUNTERS_PUB.Ctr_Estimation_Rec_Type,
x_object_version_number OUT NOCOPY NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATION_METHOD';
SAVEPOINT Update_Estimation_Method_PUB;
CSI_COUNTER_TEMPLATE_PUB.Update_Estimation_Method
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => l_validation_level
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_ctr_estimation_rec => l_ctr_estimation_methods_rec
);
ROLLBACK TO Update_Estimation_Method_PUB;
ROLLBACK TO Update_Estimation_Method_PUB;
ROLLBACK TO Update_Estimation_Method_PUB;
ROLLBACK TO Update_Estimation_Method_PUB;
end Update_Estimation_Method;