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 501: ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec

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

Line 847: ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec

843: p_api_version IN NUMBER
844: ,p_commit IN VARCHAR2
845: ,p_init_msg_list IN VARCHAR2
846: ,p_validation_level IN NUMBER
847: ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
848: ,x_return_status OUT NOCOPY VARCHAR2
849: ,x_msg_count OUT NOCOPY NUMBER
850: ,x_msg_data OUT NOCOPY VARCHAR2
851: ) IS

Line 1345: ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec

1341: p_api_version IN NUMBER
1342: ,p_commit IN VARCHAR2
1343: ,p_init_msg_list IN VARCHAR2
1344: ,p_validation_level IN NUMBER
1345: ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
1346: ,x_return_status OUT NOCOPY VARCHAR2
1347: ,x_msg_count OUT NOCOPY NUMBER
1348: ,x_msg_data OUT NOCOPY VARCHAR2
1349: ) IS

Line 1428: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;

1424: l_dummy VARCHAR2(1);
1425: l_time_based_manual_entry VARCHAR2(1);
1426: l_eam_required_flag VARCHAR2(1);
1427:
1428: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
1429: l_valid_start_date DATE;
1430:
1431: CURSOR c1_group(p_group_id NUMBER) IS
1432: select start_date_active

Line 2076: ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec

2072: p_api_version IN NUMBER
2073: ,p_commit IN VARCHAR2
2074: ,p_init_msg_list IN VARCHAR2
2075: ,p_validation_level IN NUMBER
2076: ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
2077: ,x_return_status OUT NOCOPY VARCHAR2
2078: ,x_msg_count OUT NOCOPY NUMBER
2079: ,x_msg_data OUT NOCOPY VARCHAR2
2080: ) IS

Line 2460: ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec

2456: p_api_version IN NUMBER
2457: ,p_commit IN VARCHAR2
2458: ,p_init_msg_list IN VARCHAR2
2459: ,p_validation_level IN NUMBER
2460: ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
2461: ,x_return_status OUT NOCOPY VARCHAR2
2462: ,x_msg_count OUT NOCOPY NUMBER
2463: ,x_msg_data OUT NOCOPY VARCHAR2
2464: ) IS

Line 2890: ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl

2886: p_api_version IN NUMBER
2887: ,p_commit IN VARCHAR2
2888: ,p_init_msg_list IN VARCHAR2
2889: ,p_validation_level IN NUMBER
2890: ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
2891: ,x_return_status OUT NOCOPY VARCHAR2
2892: ,x_msg_count OUT NOCOPY NUMBER
2893: ,x_msg_data OUT NOCOPY VARCHAR2
2894: ) IS

Line 2905: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;

2901: l_msg_data VARCHAR2(2000);
2902: l_msg_count NUMBER;
2903:
2904: --l_rec_number NUMBER;
2905: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
2906: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;
2907: l_type VARCHAR2(30);
2908: l_name VARCHAR2(50);
2909: l_log_op VARCHAR2(30);

Line 2906: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;

2902: l_msg_count NUMBER;
2903:
2904: --l_rec_number NUMBER;
2905: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
2906: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;
2907: l_type VARCHAR2(30);
2908: l_name VARCHAR2(50);
2909: l_log_op VARCHAR2(30);
2910: l_seq_no NUMBER;

Line 3195: ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec

3191: p_api_version IN NUMBER
3192: ,p_commit IN VARCHAR2
3193: ,p_init_msg_list IN VARCHAR2
3194: ,p_validation_level IN NUMBER
3195: ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
3196: ,x_return_status OUT NOCOPY VARCHAR2
3197: ,x_msg_count OUT NOCOPY NUMBER
3198: ,x_msg_data OUT NOCOPY VARCHAR2
3199: ) IS

Line 3249: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;

3245: l_msg_index NUMBER;
3246: l_msg_count NUMBER;
3247: -- l_debug_level NUMBER;
3248:
3249: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
3250: BEGIN
3251: -- Standard Start of API savepoint
3252: SAVEPOINT update_counter_group_pvt;
3253:

Line 3563: ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec

3559: p_api_version IN NUMBER
3560: ,p_commit IN VARCHAR2
3561: ,p_init_msg_list IN VARCHAR2
3562: ,p_validation_level IN NUMBER
3563: ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
3564: ,x_return_status OUT NOCOPY VARCHAR2
3565: ,x_msg_count OUT NOCOPY NUMBER
3566: ,x_msg_data OUT NOCOPY VARCHAR2
3567: ) IS

Line 3622: l_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;

3618: l_inventory_item_id NUMBER;
3619: l_associated_to_group VARCHAR2(1);
3620: l_item_found VARCHAR2(1);
3621: l_item_invalid VARCHAR2(1);
3622: l_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;
3623: BEGIN
3624: -- Standard Start of API savepoint
3625: SAVEPOINT update_item_association_pvt;
3626:

Line 4030: ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec

4026: p_api_version IN NUMBER
4027: ,p_commit IN VARCHAR2
4028: ,p_init_msg_list IN VARCHAR2
4029: ,p_validation_level IN NUMBER
4030: ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
4031: ,x_return_status OUT NOCOPY VARCHAR2
4032: ,x_msg_count OUT NOCOPY NUMBER
4033: ,x_msg_data OUT NOCOPY VARCHAR2
4034: ) IS

Line 4141: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;

4137: l_msg_index NUMBER;
4138: l_msg_count NUMBER;
4139: -- l_debug_level NUMBER;
4140:
4141: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
4142: l_formula_ref_count NUMBER;
4143: l_der_filter_count NUMBER;
4144: l_target_ctr_exist NUMBER;
4145: l_rdg_exists NUMBER;

Line 4849: ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec

4845: p_api_version IN NUMBER
4846: ,p_commit IN VARCHAR2
4847: ,p_init_msg_list IN VARCHAR2
4848: ,p_validation_level IN NUMBER
4849: ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
4850: ,x_return_status OUT NOCOPY VARCHAR2
4851: ,x_msg_count OUT NOCOPY NUMBER
4852: ,x_msg_data OUT NOCOPY VARCHAR2
4853: ) IS

Line 4905: l_ctr_property_tmpl_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;

4901: l_msg_index NUMBER;
4902: l_msg_count NUMBER;
4903: -- l_debug_level NUMBER;
4904:
4905: l_ctr_property_tmpl_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;
4906: BEGIN
4907: -- Standard Start of API savepoint
4908: SAVEPOINT update_ctr_property_tmpl_pvt;
4909:

Line 5258: ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec

5254: p_api_version IN NUMBER
5255: ,p_commit IN VARCHAR2
5256: ,p_init_msg_list IN VARCHAR2
5257: ,p_validation_level IN NUMBER
5258: ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
5259: ,x_return_status OUT NOCOPY VARCHAR2
5260: ,x_msg_count OUT NOCOPY NUMBER
5261: ,x_msg_data OUT NOCOPY VARCHAR2
5262: ) IS

Line 5310: l_ctr_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;

5306: l_msg_index NUMBER;
5307: l_msg_count NUMBER;
5308: -- l_debug_level NUMBER;
5309:
5310: l_ctr_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
5311: l_source_direction VARCHAR2(1);
5312: l_object_direction VARCHAR2(1);
5313: l_valid_flag VARCHAR2(1);
5314: l_src_ctr_start_date DATE;

Line 5711: ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl

5707: p_api_version IN NUMBER
5708: ,p_commit IN VARCHAR2
5709: ,p_init_msg_list IN VARCHAR2
5710: ,p_validation_level IN NUMBER
5711: ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
5712: ,x_return_status OUT NOCOPY VARCHAR2
5713: ,x_msg_count OUT NOCOPY NUMBER
5714: ,x_msg_data OUT NOCOPY VARCHAR2
5715: ) IS

Line 5729: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;

5725: l_msg_count NUMBER;
5726:
5727: l_count NUMBER;
5728: l_return_message VARCHAR2(100);
5729: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
5730: l_old_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
5731: l_counter_id NUMBER;
5732: l_type VARCHAR2(30);
5733: l_name VARCHAR2(50);

Line 5730: l_old_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;

5726:
5727: l_count NUMBER;
5728: l_return_message VARCHAR2(100);
5729: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
5730: l_old_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
5731: l_counter_id NUMBER;
5732: l_type VARCHAR2(30);
5733: l_name VARCHAR2(50);
5734: l_log_op VARCHAR2(30);

Line 5735: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;

5731: l_counter_id NUMBER;
5732: l_type VARCHAR2(30);
5733: l_name VARCHAR2(50);
5734: l_log_op VARCHAR2(30);
5735: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.dff_rec_type;
5736:
5737: l_return_status VARCHAR2(1);
5738: l_valid_flag VARCHAR2(1);
5739:

Line 6101: ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec

6097: ,p_validation_level IN NUMBER
6098: ,x_return_status OUT NOCOPY VARCHAR2
6099: ,x_msg_count OUT NOCOPY NUMBER
6100: ,x_msg_data OUT NOCOPY VARCHAR2
6101: ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
6102: ) IS
6103:
6104:
6105: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATION_METHOD';

Line 6463: ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec

6459: ,p_validation_level IN NUMBER
6460: ,x_return_status OUT NOCOPY VARCHAR2
6461: ,x_msg_count OUT NOCOPY NUMBER
6462: ,x_msg_data OUT NOCOPY VARCHAR2
6463: ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
6464: ) IS
6465:
6466: CURSOR cur_estimation_rec(p_estimation_id IN NUMBER) IS
6467: SELECT name

Line 6511: l_ctr_estimation_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;

6507: l_msg_index NUMBER;
6508: l_msg_count NUMBER;
6509: -- l_debug_level NUMBER;
6510:
6511: l_ctr_estimation_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;
6512: BEGIN
6513: -- Standard Start of API savepoint
6514: SAVEPOINT update_estimation_method_pvt;
6515:

Line 6839: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;

6835: l_msg_index NUMBER;
6836: l_msg_count NUMBER;
6837: -- l_debug_level NUMBER;
6838:
6839: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6840: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6841: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;

Line 6840: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;

6836: l_msg_count NUMBER;
6837: -- l_debug_level NUMBER;
6838:
6839: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6840: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6841: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6844: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;

Line 6841: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;

6837: -- l_debug_level NUMBER;
6838:
6839: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6840: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6841: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6844: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6845: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;

Line 6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;

6838:
6839: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6840: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6841: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6844: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6845: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6846: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;

Line 6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;

6839: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6840: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6841: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6844: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6845: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6846: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
6847:

Line 6844: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;

6840: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
6841: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6844: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6845: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6846: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
6847:
6848: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);

Line 6845: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;

6841: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6844: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6845: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6846: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
6847:
6848: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
6849: l_source_object_cd VARCHAR2(30);

Line 6846: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;

6842: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
6843: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
6844: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
6845: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
6846: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
6847:
6848: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
6849: l_source_object_cd VARCHAR2(30);
6850: l_source_object_id_instance NUMBER;

Line 6861: l_desc_flex csi_ctr_datastructures_pub.dff_rec_type;

6857: l_new_ctr_der_filter_id NUMBER;
6858: l_new_der_ctr_prop_id NUMBER;
6859: l_ctr_grp_id_instance NUMBER;
6860: l_maint_organization_id NUMBER;
6861: l_desc_flex csi_ctr_datastructures_pub.dff_rec_type;
6862: l_item VARCHAR2(40);
6863: l_config_root_id NUMBER;
6864: l_mapped_item_id NUMBER;
6865: l_org_id NUMBER;

Line 6867: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;

6863: l_config_root_id NUMBER;
6864: l_mapped_item_id NUMBER;
6865: l_org_id NUMBER;
6866: l_reading_type NUMBER;
6867: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
6868: p_relationship_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
6869: x_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;
6870:
6871: l_validation_level NUMBER;

Line 6881: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;

6877: l_c_ind_prop BINARY_INTEGER := 0;
6878: l_transaction_type_id NUMBER;
6879: l_new_derive_counter_id NUMBER;
6880: l_transaction_tbl csi_datastructures_pub.transaction_tbl;
6881: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
6882: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
6883:
6884: CURSOR DFLT_PROP_RDG(p_counter_id IN NUMBER) IS
6885: SELECT ccp.counter_property_id,ccp.default_value,ccp.property_data_type, ccp.is_nullable

Line 6882: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;

6878: l_transaction_type_id NUMBER;
6879: l_new_derive_counter_id NUMBER;
6880: l_transaction_tbl csi_datastructures_pub.transaction_tbl;
6881: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
6882: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
6883:
6884: CURSOR DFLT_PROP_RDG(p_counter_id IN NUMBER) IS
6885: SELECT ccp.counter_property_id,ccp.default_value,ccp.property_data_type, ccp.is_nullable
6886: FROM CSI_COUNTER_PROPERTIES_B ccp

Line 7786: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;

7782: l_msg_index NUMBER;
7783: l_msg_count NUMBER;
7784: -- l_debug_level NUMBER;
7785:
7786: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7787: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7788: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;

Line 7787: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;

7783: l_msg_count NUMBER;
7784: -- l_debug_level NUMBER;
7785:
7786: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7787: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7788: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7791: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;

Line 7788: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;

7784: -- l_debug_level NUMBER;
7785:
7786: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7787: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7788: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7791: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7792: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;

Line 7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;

7785:
7786: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7787: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7788: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7791: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7792: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7793: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;

Line 7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;

7786: l_ctr_grp_rec csi_ctr_datastructures_pub.counter_groups_rec;
7787: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7788: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7791: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7792: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7793: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
7794:

Line 7791: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;

7787: l_counter_instance_rec csi_ctr_datastructures_pub.counter_instance_rec;
7788: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7791: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7792: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7793: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
7794:
7795: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);

Line 7792: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;

7788: l_ctr_properties_rec csi_ctr_datastructures_pub.ctr_properties_rec;
7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7791: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7792: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7793: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
7794:
7795: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
7796: l_source_object_cd VARCHAR2(30);

Line 7793: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;

7789: l_ctr_rec csi_ctr_datastructures_pub.ctr_rec_type;
7790: l_ctr_prop_rec csi_ctr_datastructures_pub.ctr_prop_rec_type;
7791: l_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
7792: l_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
7793: l_counter_associations_rec csi_ctr_datastructures_pub.counter_associations_rec;
7794:
7795: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
7796: l_source_object_cd VARCHAR2(30);
7797: l_source_object_id_instance NUMBER;

Line 7809: l_desc_flex csi_ctr_datastructures_pub.dff_rec_type;

7805: l_new_der_ctr_prop_id NUMBER;
7806: l_counter_group_id NUMBER;
7807: l_ctr_grp_id_instance NUMBER;
7808: l_maint_organization_id NUMBER;
7809: l_desc_flex csi_ctr_datastructures_pub.dff_rec_type;
7810: l_item VARCHAR2(40);
7811: l_config_root_id NUMBER;
7812: l_mapped_item_id NUMBER;
7813: l_org_id NUMBER;