eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_CTR_DATASTRUCTURES_PUB

Line 500: ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec

496: p_api_version IN NUMBER
497: ,p_commit IN VARCHAR2
498: ,p_init_msg_list IN VARCHAR2
499: ,p_validation_level IN NUMBER
500: ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
503: ,x_msg_data OUT NOCOPY VARCHAR2
504: ) IS

Line 839: ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec

835: p_api_version IN NUMBER
836: ,p_commit IN VARCHAR2
837: ,p_init_msg_list IN VARCHAR2
838: ,p_validation_level IN NUMBER
839: ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
840: ,x_return_status OUT NOCOPY VARCHAR2
841: ,x_msg_count OUT NOCOPY NUMBER
842: ,x_msg_data OUT NOCOPY VARCHAR2
843: ) IS

Line 1337: ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec

1333: p_api_version IN NUMBER
1334: ,p_commit IN VARCHAR2
1335: ,p_init_msg_list IN VARCHAR2
1336: ,p_validation_level IN NUMBER
1337: ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
1338: ,x_return_status OUT NOCOPY VARCHAR2
1339: ,x_msg_count OUT NOCOPY NUMBER
1340: ,x_msg_data OUT NOCOPY VARCHAR2
1341: ) IS

Line 1420: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;

1416: l_dummy VARCHAR2(1);
1417: l_time_based_manual_entry VARCHAR2(1);
1418: l_eam_required_flag VARCHAR2(1);
1419:
1420: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
1421: l_valid_start_date DATE;
1422:
1423: CURSOR c1_group(p_group_id NUMBER) IS
1424: select start_date_active

Line 2068: ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec

2064: p_api_version IN NUMBER
2065: ,p_commit IN VARCHAR2
2066: ,p_init_msg_list IN VARCHAR2
2067: ,p_validation_level IN NUMBER
2068: ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
2069: ,x_return_status OUT NOCOPY VARCHAR2
2070: ,x_msg_count OUT NOCOPY NUMBER
2071: ,x_msg_data OUT NOCOPY VARCHAR2
2072: ) IS

Line 2452: ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec

2448: p_api_version IN NUMBER
2449: ,p_commit IN VARCHAR2
2450: ,p_init_msg_list IN VARCHAR2
2451: ,p_validation_level IN NUMBER
2452: ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
2453: ,x_return_status OUT NOCOPY VARCHAR2
2454: ,x_msg_count OUT NOCOPY NUMBER
2455: ,x_msg_data OUT NOCOPY VARCHAR2
2456: ) IS

Line 2877: ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl

2873: p_api_version IN NUMBER
2874: ,p_commit IN VARCHAR2
2875: ,p_init_msg_list IN VARCHAR2
2876: ,p_validation_level IN NUMBER
2877: ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
2878: ,x_return_status OUT NOCOPY VARCHAR2
2879: ,x_msg_count OUT NOCOPY NUMBER
2880: ,x_msg_data OUT NOCOPY VARCHAR2
2881: ) IS

Line 2892: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;

2888: l_msg_data VARCHAR2(2000);
2889: l_msg_count NUMBER;
2890:
2891: --l_rec_number NUMBER;
2892: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
2893: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;
2894: l_type VARCHAR2(30);
2895: l_name VARCHAR2(50);
2896: l_log_op VARCHAR2(30);

Line 2893: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;

2889: l_msg_count NUMBER;
2890:
2891: --l_rec_number NUMBER;
2892: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
2893: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;
2894: l_type VARCHAR2(30);
2895: l_name VARCHAR2(50);
2896: l_log_op VARCHAR2(30);
2897: l_seq_no NUMBER;

Line 3182: ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec

3178: p_api_version IN NUMBER
3179: ,p_commit IN VARCHAR2
3180: ,p_init_msg_list IN VARCHAR2
3181: ,p_validation_level IN NUMBER
3182: ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
3183: ,x_return_status OUT NOCOPY VARCHAR2
3184: ,x_msg_count OUT NOCOPY NUMBER
3185: ,x_msg_data OUT NOCOPY VARCHAR2
3186: ) IS

Line 3236: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;

3232: l_msg_index NUMBER;
3233: l_msg_count NUMBER;
3234: -- l_debug_level NUMBER;
3235:
3236: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
3237: BEGIN
3238: -- Standard Start of API savepoint
3239: SAVEPOINT update_counter_group_pvt;
3240:

Line 3550: ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec

3546: p_api_version IN NUMBER
3547: ,p_commit IN VARCHAR2
3548: ,p_init_msg_list IN VARCHAR2
3549: ,p_validation_level IN NUMBER
3550: ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
3551: ,x_return_status OUT NOCOPY VARCHAR2
3552: ,x_msg_count OUT NOCOPY NUMBER
3553: ,x_msg_data OUT NOCOPY VARCHAR2
3554: ) IS

Line 3609: l_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;

3605: l_inventory_item_id NUMBER;
3606: l_associated_to_group VARCHAR2(1);
3607: l_item_found VARCHAR2(1);
3608: l_item_invalid VARCHAR2(1);
3609: l_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;
3610: BEGIN
3611: -- Standard Start of API savepoint
3612: SAVEPOINT update_item_association_pvt;
3613:

Line 4017: ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec

4013: p_api_version IN NUMBER
4014: ,p_commit IN VARCHAR2
4015: ,p_init_msg_list IN VARCHAR2
4016: ,p_validation_level IN NUMBER
4017: ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
4018: ,x_return_status OUT NOCOPY VARCHAR2
4019: ,x_msg_count OUT NOCOPY NUMBER
4020: ,x_msg_data OUT NOCOPY VARCHAR2
4021: ) IS

Line 4128: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;

4124: l_msg_index NUMBER;
4125: l_msg_count NUMBER;
4126: -- l_debug_level NUMBER;
4127:
4128: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
4129: l_formula_ref_count NUMBER;
4130: l_der_filter_count NUMBER;
4131: l_target_ctr_exist NUMBER;
4132: l_rdg_exists NUMBER;

Line 4828: ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec

4824: p_api_version IN NUMBER
4825: ,p_commit IN VARCHAR2
4826: ,p_init_msg_list IN VARCHAR2
4827: ,p_validation_level IN NUMBER
4828: ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
4829: ,x_return_status OUT NOCOPY VARCHAR2
4830: ,x_msg_count OUT NOCOPY NUMBER
4831: ,x_msg_data OUT NOCOPY VARCHAR2
4832: ) IS

Line 4884: l_ctr_property_tmpl_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;

4880: l_msg_index NUMBER;
4881: l_msg_count NUMBER;
4882: -- l_debug_level NUMBER;
4883:
4884: l_ctr_property_tmpl_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;
4885: BEGIN
4886: -- Standard Start of API savepoint
4887: SAVEPOINT update_ctr_property_tmpl_pvt;
4888:

Line 5237: ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec

5233: p_api_version IN NUMBER
5234: ,p_commit IN VARCHAR2
5235: ,p_init_msg_list IN VARCHAR2
5236: ,p_validation_level IN NUMBER
5237: ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
5238: ,x_return_status OUT NOCOPY VARCHAR2
5239: ,x_msg_count OUT NOCOPY NUMBER
5240: ,x_msg_data OUT NOCOPY VARCHAR2
5241: ) IS

Line 5289: l_ctr_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;

5285: l_msg_index NUMBER;
5286: l_msg_count NUMBER;
5287: -- l_debug_level NUMBER;
5288:
5289: l_ctr_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
5290: l_source_direction VARCHAR2(1);
5291: l_object_direction VARCHAR2(1);
5292: l_valid_flag VARCHAR2(1);
5293: l_src_ctr_start_date DATE;

Line 5690: ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl

5686: p_api_version IN NUMBER
5687: ,p_commit IN VARCHAR2
5688: ,p_init_msg_list IN VARCHAR2
5689: ,p_validation_level IN NUMBER
5690: ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
5691: ,x_return_status OUT NOCOPY VARCHAR2
5692: ,x_msg_count OUT NOCOPY NUMBER
5693: ,x_msg_data OUT NOCOPY VARCHAR2
5694: ) IS

Line 5708: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;

5704: l_msg_count NUMBER;
5705:
5706: l_count NUMBER;
5707: l_return_message VARCHAR2(100);
5708: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
5709: l_old_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
5710: l_counter_id NUMBER;
5711: l_type VARCHAR2(30);
5712: l_name VARCHAR2(50);

Line 5709: l_old_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;

5705:
5706: l_count NUMBER;
5707: l_return_message VARCHAR2(100);
5708: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
5709: l_old_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
5710: l_counter_id NUMBER;
5711: l_type VARCHAR2(30);
5712: l_name VARCHAR2(50);
5713: l_log_op VARCHAR2(30);

Line 5714: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;

5710: l_counter_id NUMBER;
5711: l_type VARCHAR2(30);
5712: l_name VARCHAR2(50);
5713: l_log_op VARCHAR2(30);
5714: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;
5715:
5716: l_return_status VARCHAR2(1);
5717: l_valid_flag VARCHAR2(1);
5718:

Line 6080: ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec

6076: ,p_validation_level IN NUMBER
6077: ,x_return_status OUT NOCOPY VARCHAR2
6078: ,x_msg_count OUT NOCOPY NUMBER
6079: ,x_msg_data OUT NOCOPY VARCHAR2
6080: ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
6081: ) IS
6082:
6083:
6084: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATION_METHOD';

Line 6442: ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec

6438: ,p_validation_level IN NUMBER
6439: ,x_return_status OUT NOCOPY VARCHAR2
6440: ,x_msg_count OUT NOCOPY NUMBER
6441: ,x_msg_data OUT NOCOPY VARCHAR2
6442: ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
6443: ) IS
6444:
6445: CURSOR cur_estimation_rec(p_estimation_id IN NUMBER) IS
6446: SELECT name

Line 6490: l_ctr_estimation_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;

6486: l_msg_index NUMBER;
6487: l_msg_count NUMBER;
6488: -- l_debug_level NUMBER;
6489:
6490: l_ctr_estimation_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;
6491: BEGIN
6492: -- Standard Start of API savepoint
6493: SAVEPOINT update_estimation_method_pvt;
6494:

Line 6818: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;

6814: l_msg_index NUMBER;
6815: l_msg_count NUMBER;
6816: -- l_debug_level NUMBER;
6817:
6818: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6819: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6820: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;

Line 6819: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;

6815: l_msg_count NUMBER;
6816: -- l_debug_level NUMBER;
6817:
6818: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6819: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6820: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6823: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;

Line 6820: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;

6816: -- l_debug_level NUMBER;
6817:
6818: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6819: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6820: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6823: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6824: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;

Line 6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;

6817:
6818: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6819: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6820: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6823: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6824: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6825: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;

Line 6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;

6818: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6819: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6820: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6823: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6824: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6825: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
6826:

Line 6823: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;

6819: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6820: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6823: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6824: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6825: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
6826:
6827: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);

Line 6824: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;

6820: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6823: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6824: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6825: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
6826:
6827: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
6828: l_source_object_cd VARCHAR2(30);

Line 6825: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;

6821: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6822: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6823: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6824: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6825: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
6826:
6827: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
6828: l_source_object_cd VARCHAR2(30);
6829: l_source_object_id_instance NUMBER;

Line 6840: l_desc_flex csi_ctr_datastructures_pub.dff_rec_type;

6836: l_new_ctr_der_filter_id NUMBER;
6837: l_new_der_ctr_prop_id NUMBER;
6838: l_ctr_grp_id_instance NUMBER;
6839: l_maint_organization_id NUMBER;
6840: l_desc_flex csi_ctr_datastructures_pub.dff_rec_type;
6841: l_item VARCHAR2(40);
6842: l_config_root_id NUMBER;
6843: l_mapped_item_id NUMBER;
6844: l_org_id NUMBER;

Line 6846: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;

6842: l_config_root_id NUMBER;
6843: l_mapped_item_id NUMBER;
6844: l_org_id NUMBER;
6845: l_reading_type NUMBER;
6846: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6847: p_relationship_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
6848: x_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;
6849:
6850: l_validation_level NUMBER;

Line 6860: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;

6856: l_c_ind_prop BINARY_INTEGER := 0;
6857: l_transaction_type_id NUMBER;
6858: l_new_derive_counter_id NUMBER;
6859: l_transaction_tbl csi_datastructures_pub.transaction_tbl;
6860: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
6861: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
6862:
6863: CURSOR DFLT_PROP_RDG(p_counter_id IN NUMBER) IS
6864: SELECT ccp.counter_property_id,ccp.default_value,ccp.property_data_type, ccp.is_nullable

Line 6861: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;

6857: l_transaction_type_id NUMBER;
6858: l_new_derive_counter_id NUMBER;
6859: l_transaction_tbl csi_datastructures_pub.transaction_tbl;
6860: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
6861: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
6862:
6863: CURSOR DFLT_PROP_RDG(p_counter_id IN NUMBER) IS
6864: SELECT ccp.counter_property_id,ccp.default_value,ccp.property_data_type, ccp.is_nullable
6865: FROM CSI_COUNTER_PROPERTIES_B ccp

Line 7743: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;

7739: l_msg_index NUMBER;
7740: l_msg_count NUMBER;
7741: -- l_debug_level NUMBER;
7742:
7743: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7744: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7745: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;

Line 7744: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;

7740: l_msg_count NUMBER;
7741: -- l_debug_level NUMBER;
7742:
7743: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7744: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7745: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7748: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;

Line 7745: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;

7741: -- l_debug_level NUMBER;
7742:
7743: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7744: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7745: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7748: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7749: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;

Line 7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;

7742:
7743: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7744: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7745: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7748: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7749: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7750: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;

Line 7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;

7743: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7744: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7745: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7748: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7749: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7750: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
7751:

Line 7748: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;

7744: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7745: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7748: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7749: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7750: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
7751:
7752: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);

Line 7749: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;

7745: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7748: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7749: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7750: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
7751:
7752: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
7753: l_source_object_cd VARCHAR2(30);

Line 7750: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;

7746: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7747: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7748: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7749: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7750: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
7751:
7752: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
7753: l_source_object_cd VARCHAR2(30);
7754: l_source_object_id_instance NUMBER;

Line 7766: l_desc_flex csi_ctr_datastructures_pub.dff_rec_type;

7762: l_new_der_ctr_prop_id NUMBER;
7763: l_counter_group_id NUMBER;
7764: l_ctr_grp_id_instance NUMBER;
7765: l_maint_organization_id NUMBER;
7766: l_desc_flex csi_ctr_datastructures_pub.dff_rec_type;
7767: l_item VARCHAR2(40);
7768: l_config_root_id NUMBER;
7769: l_mapped_item_id NUMBER;
7770: l_org_id NUMBER;