The following lines contain the word 'select', 'insert', 'update' or 'delete':
* It contains routines to Create and Update Counter Grouping,
* Counter Template, Item Associations, Derived Filters,
* Counter Relationships
* @rep:scope public
* @rep:product CSI
* @rep:displayname Manage Counter Template
* @rep:lifecycle active
* @rep:compatibility S
* @rep:category BUSINESS_ENTITY CSI_COUNTER
*/
-- --------------------------------------------------------
-- Define global variables
-- --------------------------------------------------------
-- G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_TEMPLATE_PUB';
* This procedure is used to update counter group
* In this process, it also update/create counter item associations
* @param p_api_version Current API version
* @param p_commit API commits if set to fnd_api.g_true
* @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
* @param p_validation_level API validation level
* @param p_counter_groups_rec Counter Group Record structure
* @param p_ctr_item_associations_tbl Counter Item Associations Table structure
* @param x_return_status API Return Status
* @param x_msg_count Message count
* @param x_msg_data Message Data
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Update Counter Group
*/
PROCEDURE update_counter_group
(
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 OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
,p_ctr_item_associations_tbl IN OUT NOCOPY 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
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER_GROUP';
SELECT counter_id
FROM csi_ctr_item_associations
WHERE nvl(associated_to_group,'N') = 'Y'
AND counter_id IS NOT NULL
AND group_id = p_counter_group_id
AND inventory_item_id = p_inventory_item_id; --Modified for 6112648
SAVEPOINT update_counter_group;
csi_ctr_gen_utility_pvt.put_line( 'update_counter_group');
csi_ctr_gen_utility_pvt.put_line( 'update_counter_group' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_groups_rec => p_counter_groups_rec
,p_ctr_item_associations_tbl => p_ctr_item_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_TEMPLATE_CUHK.update_counter_group_pre API ');
CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_groups_rec => p_counter_groups_rec
,p_ctr_item_associations_tbl => p_ctr_item_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_TEMPLATE_VUHK.update_counter_group_pre API ');
csi_counter_template_pvt.update_counter_group
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_groups_rec => p_counter_groups_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_GROUP');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post ..');
CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_counter_groups_rec => p_counter_groups_rec
,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post API ');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post ..');
CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_counter_groups_rec => p_counter_groups_rec
,p_ctr_item_associations_tbl => p_ctr_item_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_TEMPLATE_VUHK.update_counter_group_Post API ');
update_item_association
(p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_item_associations_rec => p_ctr_item_associations_tbl(tab_row)
,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_PUB.UPDATE_ITEM_ASSOCIATIONS');
ROLLBACK TO update_counter_group;
ROLLBACK TO update_counter_group;
ROLLBACK TO update_counter_group;
END update_counter_group;
* This procedure is used to update counter item associations
* @param p_api_version Current API version
* @param p_commit API commits if set to fnd_api.g_true
* @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
* @param p_validation_level API validation level
* @param p_ctr_item_associations_rec Counter Item Associations Record structure
* @param x_return_status API Return Status
* @param x_msg_count Message count
* @param x_msg_data Message Data
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Update Item Association
*/
PROCEDURE update_item_association
(
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 OUT NOCOPY 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
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_ASSOCIATION';
SAVEPOINT update_item_association;
csi_ctr_gen_utility_pvt.put_line( 'update_item_association');
csi_ctr_gen_utility_pvt.put_line( 'update_item_association' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
CSI_COUNTER_TEMPLATE_CUHK.update_item_association_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_item_associations_rec => p_ctr_item_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_TEMPLATE_CUHK.update_item_association_pre API ');
CSI_COUNTER_TEMPLATE_VUHK.update_item_association_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_item_associations_rec => p_ctr_item_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_TEMPLATE_VUHK.update_item_association_pre API ');
csi_counter_template_pvt.update_item_association
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_item_associations_rec => p_ctr_item_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_TEMPLATE_PVT.UPDATE_ITEM_ASSOCIATION');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post ..');
CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_ctr_item_associations_rec => p_ctr_item_associations_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post API ');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post ..');
CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_ctr_item_associations_rec => p_ctr_item_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_TEMPLATE_VUHK.update_item_association_Post API ');
ROLLBACK TO update_item_association;
ROLLBACK TO update_item_association;
ROLLBACK TO update_item_association;
END update_item_association;
* This procedure is used to update counter template.
* This will also create/update Item Association, Properties
* derived filters, relationships.
* @param p_api_version Current API version
* @param p_commit API commits if set to fnd_api.g_true
* @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
* @param p_validation_level API validation level
* @param p_counter_template_rec Counter Template Record structure
* @param p_ctr_item_associations_tbl Counter Item Associations Table structure
* @param p_ctr_property_template_tbl Counter property template Table structure
* @param p_counter_relationships_tbl Counter relationships Table structure
* @param p_ctr_derived_filters_tbl Counter Derived Filters Table structure
* @param x_return_status API Return Status
* @param x_msg_count Message count
* @param x_msg_data Message Data
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Update Counter Template
*/
PROCEDURE update_counter_template
(
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 OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
,p_ctr_item_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
,p_ctr_property_template_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_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
,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_TEMPLATE';
SAVEPOINT update_counter_template ;
csi_ctr_gen_utility_pvt.put_line( 'update_counter_template');
csi_ctr_gen_utility_pvt.put_line( 'update_counter_template' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_template_rec => p_counter_template_rec
,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
,p_ctr_property_template_tbl => p_ctr_property_template_tbl
,p_counter_relationships_tbl => p_counter_relationships_tbl
,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_CUHK.update_counter_template_pre API ');
CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_template_rec => p_counter_template_rec
,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
,p_ctr_property_template_tbl => p_ctr_property_template_tbl
,p_counter_relationships_tbl => p_counter_relationships_tbl
,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_VUHK.update_counter_template_pre API ');
csi_counter_template_pvt.update_counter_template
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_template_rec => p_counter_template_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_TEMPLATE');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post ..');
CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_counter_template_rec => p_counter_template_rec
,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
,p_ctr_property_template_tbl => p_ctr_property_template_tbl
,p_counter_relationships_tbl => p_counter_relationships_tbl
,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_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post API ');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post ..');
CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_counter_template_rec => p_counter_template_rec
,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
,p_ctr_property_template_tbl => p_ctr_property_template_tbl
,p_counter_relationships_tbl => p_counter_relationships_tbl
,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_VUHK.update_counter_template_Post API ');
update_item_association
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_item_associations_rec => p_ctr_item_associations_tbl(tab_row)
,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_PUB.UPDATE_ITEM_ASSOCIATIONS');
update_ctr_property_template
(p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_property_template_rec => p_ctr_property_template_tbl(tab_row)
,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_PUB.UPDATE_CTR_PROPERTY_TEMPLATE');
update_counter_relationship
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_relationships_rec => p_counter_relationships_tbl(tab_row)
,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_PUB.UPDATE_COUNTER_RELATIONSHIP');
update_derived_filters
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,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_PUB.UPDATE_DERIVED_FILTERS');
ROLLBACK TO update_counter_template;
ROLLBACK TO update_counter_template;
ROLLBACK TO update_counter_template;
END update_counter_template;
* This procedure is used to update counter property template.
* @param p_api_version Current API version
* @param p_commit API commits if set to fnd_api.g_true
* @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
* @param p_validation_level API validation level
* @param p_ctr_property_template_rec Counter property template record structure
* @param x_return_status API Return Status
* @param x_msg_count Message count
* @param x_msg_data Message Data
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Update Counter Property Template
*/
PROCEDURE update_ctr_property_template
(
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 OUT NOCOPY 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
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_PROPERTY_TEMPLATE';
SAVEPOINT update_ctr_property_template;
csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template');
csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_property_template_rec => p_ctr_property_template_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_CUHK.update_ctr_prop_template_pre API ');
CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_property_template_rec => p_ctr_property_template_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_VUHK.update_ctr_prop_template_pre API ');
csi_counter_template_pvt.update_ctr_property_template
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_property_template_rec => p_ctr_property_template_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_CTR_PROPERTY_TEMPLATE');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post ..');
CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_ctr_property_template_rec => p_ctr_property_template_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post API ');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post ..');
CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_ctr_property_template_rec => p_ctr_property_template_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_VUHK.update_ctr_prop_template_post API ');
ROLLBACK TO update_ctr_property_template;
ROLLBACK TO update_ctr_property_template;
ROLLBACK TO update_ctr_property_template;
END update_ctr_property_template;
* This procedure is used to update counter relationship.
* @param p_api_version Current API version
* @param p_commit API commits if set to fnd_api.g_true
* @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
* @param p_validation_level API validation level
* @param p_counter_relationships_rec Counter relationships Record structure
* @param x_return_status API Return Status
* @param x_msg_count Message count
* @param x_msg_data Message Data
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Update Counter Relationship
*/
PROCEDURE update_counter_relationship
(
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 OUT NOCOPY 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
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER_RELATIONSHIP';
SAVEPOINT update_counter_relationship;
csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship');
csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_relationships_rec => p_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_CUHK.update_ctr_relationship_pre API ');
CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_relationships_rec => p_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_VUHK.update_ctr_relationship_pre API ');
csi_counter_template_pvt.update_counter_relationship
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_counter_relationships_rec => p_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');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post ..');
CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_counter_relationships_rec => p_counter_relationships_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post API ');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post ..');
CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_counter_relationships_rec => p_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_VUHK.update_ctr_relationship_post API ');
ROLLBACK TO update_counter_relationship;
ROLLBACK TO update_counter_relationship;
ROLLBACK TO update_counter_relationship;
END update_counter_relationship;
* This procedure is used to update derived filters
* @param p_api_version Current API version
* @param p_commit API commits if set to fnd_api.g_true
* @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
* @param p_validation_level API validation level
* @param p_ctr_derived_filters_rec Counter Derived Filters Record structure
* @param x_return_status API Return Status
* @param x_msg_count Message count
* @param x_msg_data Message Data
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Update Derived Filters
*/
PROCEDURE update_derived_filters
(
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 OUT NOCOPY 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
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_DERIVED_FILTERS';
SAVEPOINT update_derived_filters;
csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters');
csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,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_CUHK.update_derived_filters_pre API ');
CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_pre
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,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_CUHK.update_derived_filters_pre API ');
csi_counter_template_pvt.update_derived_filters
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,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');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post ..');
CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,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_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post API ');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post ..');
CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,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_VUHK.update_derived_filters_post API ');
ROLLBACK TO update_derived_filters;
ROLLBACK TO update_derived_filters;
ROLLBACK TO update_derived_filters;
END update_derived_filters;
* This procedure is used to update estimation method
* @param p_api_version Current API version
* @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
* @param p_commit API commits if set to fnd_api.g_true
* @param p_validation_level API validation level
* @param x_return_status API Return Status
* @param x_msg_count Message count
* @param x_msg_data Message Data
* @param p_ctr_estimation_rec Counter Estimation Record structure
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Update Estimation Method
*/
PROCEDURE Update_Estimation_Method
(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,p_commit IN VARCHAR2
,p_validation_level IN NUMBER
,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
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATION_METHOD';
SAVEPOINT update_estimation_method;
csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method');
csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method ' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_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
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_ctr_estimation_rec => p_ctr_estimation_rec
);
csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');
CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_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
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_ctr_estimation_rec => p_ctr_estimation_rec
);
csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');
csi_counter_template_pvt.update_estimation_method
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_estimation_rec => p_ctr_estimation_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_ESTIMATION_METHOD');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post ..');
CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_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
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_ctr_estimation_rec => p_ctr_estimation_rec
);
csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post API ');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post ..');
CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_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
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_ctr_estimation_rec => p_ctr_estimation_rec
);
csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_post API ');
ROLLBACK TO update_estimation_method;
ROLLBACK TO update_estimation_method;
ROLLBACK TO update_estimation_method;
END update_estimation_method;
SELECT cia.counter_id, cia.group_id, cia.associated_to_group,
ctr.counter_type, cia.primary_failure_flag
FROM csi_ctr_item_associations cia, csi_counter_template_b ctr
WHERE cia.counter_id = ctr.counter_id
AND inventory_item_id = p_source_object_id_template
AND nvl(cia.associated_to_group,'N') = 'N'
AND nvl (cia.end_date_active, sysdate+1) > sysdate
ORDER BY counter_type DESC;
SELECT cia.counter_id, cia.group_id,
cia.associated_to_group, cia.primary_failure_flag
FROM csi_ctr_item_associations cia, cs_csi_counter_groups cg
WHERE cia.group_id = cg.counter_group_id
AND cia.inventory_item_id = p_source_object_id_template
AND cia.counter_id IS NULL
AND nvl (cia.end_date_active, sysdate+1) > sysdate
AND nvl(cia.associated_to_group,'N') = 'Y';
SELECT COMMS_NL_TRACKABLE_FLAG,
concatenated_segments
INTO l_COMMS_NL_TRACKABLE_FLAG,
l_item
FROM mtl_system_items_kfv
WHERE inventory_item_id = p_source_object_id_template
AND organization_id = p_organization_id --cs_std.get_item_valdn_orgzn_id
AND (NVL(COMMS_NL_TRACKABLE_FLAG,'N') = 'Y' or NVL(service_item_flag,'N') = 'Y');
SELECT eam_item_type
INTO l_eam_item_type
FROM mtl_system_items_b
WHERE inventory_item_id = p_source_object_id_template
AND organization_id = p_organization_id;
SELECT maint_organization_id
INTO l_curr_maint_org_id
FROM mtl_parameters
WHERE organization_id = p_organization_id;
SELECT counter_id
INTO l_counter_id
FROM csi_ctr_item_associations
WHERE inventory_item_id = p_source_object_id_template;
* This procedure is used to delete item associations
* @param p_api_version Current API version
* @param p_commit API commits if set to fnd_api.g_true
* @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
* @param p_validation_level API validation level
* @param p_ctr_association_id Item Associations Unique ID
* @param x_return_status API Return Status
* @param x_msg_count Message count
* @param x_msg_data Message Data
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Delete Item Association
*/
PROCEDURE delete_item_association
(
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
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ITEM_ASSOCIATION';
SAVEPOINT delete_item_association;
csi_ctr_gen_utility_pvt.put_line( 'delete_item_association');
csi_ctr_gen_utility_pvt.put_line('delete_item_association' ||
p_api_version ||'-'||
p_commit ||'-'||
p_init_msg_list ||'-'||
p_validation_level );
CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_PRE
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_associations_id => p_ctr_associations_id
,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_CUHK.DELETE_ITEM_ASSOCIATION_PRE API ');
CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_PRE
(
p_api_version => p_api_version
,p_commit => p_commit
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_associations_id => p_ctr_associations_id
,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_VUHK.DELETE_ITEM_ASSOCIATION_PRE API ');
csi_counter_template_pvt.delete_item_association
(
p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_ctr_associations_id => p_ctr_associations_id
,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.DELETE_ITEM_ASSOCIATION');
csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post ..');
CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_ctr_associations_id => p_ctr_associations_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post API ');
CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_Post
(
p_api_version => 1.0
,p_commit => fnd_api.g_false
,p_init_msg_list => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_ctr_associations_id => p_ctr_associations_id
,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_VUHK.DELETE_ITEM_ASSOCIATION_Post API ');
ROLLBACK TO delete_item_association;
ROLLBACK TO delete_item_association;
ROLLBACK TO delete_item_association;
END delete_item_association;