[Home] [Help]
1640: l_eam_item_type NUMBER;
1641:
1642: CURSOR association_exist(p_ctr_id number, p_src_obj_id number) IS
1643: select 'X'
1644: from csi_counter_associations
1645: where counter_id = p_ctr_id
1646: and source_object_id = p_src_obj_id;
1647:
1648: BEGIN
1889: END IF;
1890:
1891: -- call table handler here
1892:
1893: CSI_COUNTER_ASSOCIATIONS_PKG.INSERT_ROW
1894: (
1895: px_INSTANCE_ASSOCIATION_ID => l_instance_association_id
1896: ,p_SOURCE_OBJECT_CODE => l_source_object_code
1897: ,p_SOURCE_OBJECT_ID => l_source_object_id
3848: , l_old_counter_associations_rec.ATTRIBUTE_CATEGORY
3849: , l_old_counter_associations_rec.object_version_number
3850: , l_old_counter_associations_rec.maint_organization_id
3851: , l_old_counter_associations_rec.primary_failure_flag
3852: FROM CSI_COUNTER_ASSOCIATIONS
3853: WHERE INSTANCE_ASSOCIATION_ID = P_counter_associations_rec.INSTANCE_ASSOCIATION_ID
3854: FOR UPDATE OF OBJECT_VERSION_NUMBER;
3855: IF SQL%NOTFOUND THEN
3856: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_ASSOC_INVALID');
4006: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_INVALID_START_DATE');
4007: END IF;
4008:
4009: -- call table handler here
4010: CSI_COUNTER_ASSOCIATIONS_PKG.UPDATE_ROW
4011: (
4012: p_INSTANCE_ASSOCIATION_ID => p_counter_associations_rec.INSTANCE_ASSOCIATION_ID
4013: ,p_SOURCE_OBJECT_CODE => p_counter_associations_rec.SOURCE_OBJECT_CODE
4014: ,p_SOURCE_OBJECT_ID => p_counter_associations_rec.SOURCE_OBJECT_ID