DBA Data[Home] [Help]

APPS.CS_COUNTERS_PUB SQL Statements

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

Line: 259

   SELECT group_id
   FROM csi_ctr_item_associations
   WHERE associated_to_group='Y'
   AND inventory_item_id = p_inv_item_id;
Line: 956

 SELECT ctr_association_id, inventory_item_id
 FROM csi_ctr_item_associations
 WHERE counter_id = p_counter_id;
Line: 963

 SELECT ctr_association_id
 FROM csi_ctr_item_associations
 WHERE counter_id = p_mapped_counter_id
 AND inventory_item_id = p_inv_item_id;
Line: 1495

		SELECT association_type
		INTO l_association_type
		FROM cs_counter_groups
		WHERE counter_group_id = p_ctr_grp_id;
Line: 2011

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';
Line: 2034

	SAVEPOINT	Update_Ctr_Grp_PUB;
Line: 2050

           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
           );
Line: 2071

           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
           );
Line: 2119

 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
 );
Line: 2133

	  ROLLBACK TO Update_Ctr_Grp_PUB;
Line: 2142

            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
           );
Line: 2163

           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
           );
Line: 2196

		ROLLBACK TO Update_Ctr_Grp_PUB;
Line: 2203

		ROLLBACK TO Update_Ctr_Grp_PUB;
Line: 2210

		ROLLBACK TO Update_Ctr_Grp_PUB;
Line: 2220

end Update_Ctr_Grp;
Line: 2222

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';
Line: 2248

	SAVEPOINT	Update_Counter_PUB;
Line: 2265

           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
           );
Line: 2286

           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
           );
Line: 2354

 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
 );
Line: 2371

	  ROLLBACK TO Update_Counter_PUB;
Line: 2381

            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
           );
Line: 2402

            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
           );
Line: 2434

		ROLLBACK TO Update_Counter_PUB;
Line: 2441

		ROLLBACK TO Update_Counter_PUB;
Line: 2448

		ROLLBACK TO Update_Counter_PUB;
Line: 2458

end Update_Counter;
Line: 2460

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';
Line: 2482

	SAVEPOINT	Update_Ctr_Prop_PUB;
Line: 2500

           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
           );
Line: 2521

           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
           );
Line: 2576

 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
 );
Line: 2589

	  ROLLBACK TO Update_Ctr_Prop_PUB;
Line: 2597

            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
           );
Line: 2618

            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
           );
Line: 2650

		ROLLBACK TO Update_Ctr_Prop_PUB;
Line: 2657

		ROLLBACK TO Update_Ctr_Prop_PUB;
Line: 2664

		ROLLBACK TO Update_Ctr_Prop_PUB;
Line: 2674

end Update_Ctr_Prop;
Line: 2676

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';
Line: 2703

	SAVEPOINT	Update_Formula_Ref_PUB;
Line: 2720

           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
           );
Line: 2745

           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
           );
Line: 2819

            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
           );
Line: 2844

            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
           );
Line: 2880

		ROLLBACK TO Update_Formula_Ref_PUB;
Line: 2887

		ROLLBACK TO Update_Formula_Ref_PUB;
Line: 2894

		ROLLBACK TO Update_Formula_Ref_PUB;
Line: 2904

end Update_Formula_Ref;
Line: 2907

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';
Line: 2937

	SAVEPOINT	Update_GrpOp_Filter_PUB;
Line: 2953

           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
           );
Line: 2981

           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
           );
Line: 3040

 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
 );
Line: 3053

	  ROLLBACK TO Update_GrpOp_Filter_PUB;
Line: 3061

            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
           );
Line: 3089

            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
           );
Line: 3129

		ROLLBACK TO Update_GrpOp_Filter_PUB;
Line: 3136

		ROLLBACK TO Update_GrpOp_Filter_PUB;
Line: 3143

		ROLLBACK TO Update_GrpOp_Filter_PUB;
Line: 3153

end Update_GrpOp_Filter;
Line: 3155

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';
Line: 3178

	SAVEPOINT	Update_Ctr_Association_PUB;
Line: 3194

           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
           );
Line: 3215

           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
           );
Line: 3262

 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
 );
Line: 3276

	  ROLLBACK TO Update_Ctr_Association_PUB;
Line: 3284

            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
           );
Line: 3305

            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
           );
Line: 3337

		ROLLBACK TO Update_Ctr_Association_PUB;
Line: 3344

		ROLLBACK TO Update_Ctr_Association_PUB;
Line: 3351

		ROLLBACK TO Update_Ctr_Association_PUB;
Line: 3361

end Update_Ctr_Association;
Line: 3363

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';
Line: 3378

end Delete_Counter;
Line: 3380

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';
Line: 3395

end Delete_Ctr_Prop;
Line: 3398

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';
Line: 3413

end Delete_Formula_Ref;
Line: 3416

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';
Line: 3431

end Delete_GrpOp_Filter;
Line: 3434

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';
Line: 3449

end Delete_Ctr_Association;
Line: 3451

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';
Line: 3467

 END  DELETE_COUNTER_INSTANCE;
Line: 3793

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';
Line: 3813

	SAVEPOINT	Update_Estimation_Method_PUB;
Line: 3858

 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
);
Line: 3871

	  ROLLBACK TO Update_Estimation_Method_PUB;
Line: 3889

		ROLLBACK TO Update_Estimation_Method_PUB;
Line: 3896

		ROLLBACK TO Update_Estimation_Method_PUB;
Line: 3903

		ROLLBACK TO Update_Estimation_Method_PUB;
Line: 3913

end Update_Estimation_Method;