DBA Data[Home] [Help]

APPS.CSI_COUNTER_PUB dependencies on CSI_CTR_DATASTRUCTURES_PUB

Line 23: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec

19: p_api_version IN NUMBER
20: ,p_init_msg_list IN VARCHAR2
21: ,p_commit IN VARCHAR2
22: ,p_validation_level IN NUMBER
23: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
24: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
25: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
26: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
27: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl

Line 24: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl

20: ,p_init_msg_list IN VARCHAR2
21: ,p_commit IN VARCHAR2
22: ,p_validation_level IN NUMBER
23: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
24: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
25: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
26: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
27: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
28: ,x_return_status out NOCOPY VARCHAR2

Line 25: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl

21: ,p_commit IN VARCHAR2
22: ,p_validation_level IN NUMBER
23: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
24: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
25: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
26: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
27: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
28: ,x_return_status out NOCOPY VARCHAR2
29: ,x_msg_count out NOCOPY NUMBER

Line 26: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl

22: ,p_validation_level IN NUMBER
23: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
24: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
25: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
26: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
27: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
28: ,x_return_status out NOCOPY VARCHAR2
29: ,x_msg_count out NOCOPY NUMBER
30: ,x_msg_data out NOCOPY VARCHAR2

Line 27: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl

23: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
24: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
25: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
26: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
27: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
28: ,x_return_status out NOCOPY VARCHAR2
29: ,x_msg_count out NOCOPY NUMBER
30: ,x_msg_data out NOCOPY VARCHAR2
31: ,x_ctr_id out NOCOPY NUMBER

Line 45: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;

41: l_count NUMBER;
42: l_return_message VARCHAR2(100);
43:
44: l_counter_id NUMBER;
45: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
46: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
47: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
48: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
49:

Line 46: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;

42: l_return_message VARCHAR2(100);
43:
44: l_counter_id NUMBER;
45: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
46: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
47: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
48: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
49:
50: -- Added for inserting initial reading

Line 47: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;

43:
44: l_counter_id NUMBER;
45: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
46: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
47: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
48: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
49:
50: -- Added for inserting initial reading
51: l_c_ind_txn BINARY_INTEGER := 0;

Line 48: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;

44: l_counter_id NUMBER;
45: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
46: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
47: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
48: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
49:
50: -- Added for inserting initial reading
51: l_c_ind_txn BINARY_INTEGER := 0;
52: l_c_ind_rdg BINARY_INTEGER := 0;

Line 56: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;

52: l_c_ind_rdg BINARY_INTEGER := 0;
53: l_c_ind_prop BINARY_INTEGER := 0;
54: l_transaction_type_id NUMBER;
55: l_transaction_tbl csi_datastructures_pub.transaction_tbl;
56: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
57: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
58: l_src_obj_cd VARCHAR2(30);
59: l_src_obj_id NUMBER;
60: CURSOR DFLT_PROP_RDG(p_counter_id IN NUMBER) IS

Line 57: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;

53: l_c_ind_prop BINARY_INTEGER := 0;
54: l_transaction_type_id NUMBER;
55: l_transaction_tbl csi_datastructures_pub.transaction_tbl;
56: l_counter_readings_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
57: l_ctr_property_readings_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
58: l_src_obj_cd VARCHAR2(30);
59: l_src_obj_id NUMBER;
60: CURSOR DFLT_PROP_RDG(p_counter_id IN NUMBER) IS
61: SELECT ccp.counter_property_id,ccp.default_value,ccp.property_data_type, ccp.is_nullable

Line 511: p_ctr_rdg_tbl => l_counter_readings_tbl, --IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_tbl

507: p_commit => p_commit,
508: p_init_msg_list => p_init_msg_list,
509: p_validation_level => p_validation_level,
510: p_txn_tbl => l_transaction_tbl, --IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
511: p_ctr_rdg_tbl => l_counter_readings_tbl, --IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_tbl
512: p_ctr_prop_rdg_tbl => l_ctr_property_readings_tbl, --IN OUT NOCOPY csi_ctr_datastructures_pub.ctr_property_readings_tbl
513: x_return_status => x_return_status,
514: x_msg_count => x_msg_count,
515: x_msg_data => x_msg_data

Line 512: p_ctr_prop_rdg_tbl => l_ctr_property_readings_tbl, --IN OUT NOCOPY csi_ctr_datastructures_pub.ctr_property_readings_tbl

508: p_init_msg_list => p_init_msg_list,
509: p_validation_level => p_validation_level,
510: p_txn_tbl => l_transaction_tbl, --IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
511: p_ctr_rdg_tbl => l_counter_readings_tbl, --IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_tbl
512: p_ctr_prop_rdg_tbl => l_ctr_property_readings_tbl, --IN OUT NOCOPY csi_ctr_datastructures_pub.ctr_property_readings_tbl
513: x_return_status => x_return_status,
514: x_msg_count => x_msg_count,
515: x_msg_data => x_msg_data
516: );

Line 640: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl

636: p_api_version IN NUMBER
637: ,p_commit IN VARCHAR2
638: ,p_init_msg_list IN VARCHAR2
639: ,p_validation_level IN NUMBER
640: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
641: ,x_return_status OUT NOCOPY VARCHAR2
642: ,x_msg_count OUT NOCOPY NUMBER
643: ,x_msg_data OUT NOCOPY VARCHAR2
644: ,x_ctr_property_id OUT NOCOPY NUMBER

Line 657: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;

653: l_msg_count NUMBER;
654: l_count NUMBER;
655: l_return_message VARCHAR2(100);
656:
657: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
658:
659: BEGIN
660: -- Standard Start of API savepoint
661: SAVEPOINT create_ctr_property_pub;

Line 944: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl

940: p_api_version IN NUMBER
941: ,p_commit IN VARCHAR2
942: ,p_init_msg_list IN VARCHAR2
943: ,p_validation_level IN NUMBER
944: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
945: ,x_return_status OUT NOCOPY VARCHAR2
946: ,x_msg_count OUT NOCOPY NUMBER
947: ,x_msg_data OUT NOCOPY VARCHAR2
948: ,x_instance_association_id OUT NOCOPY NUMBER

Line 961: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;

957: l_msg_count NUMBER;
958: l_count NUMBER;
959: l_return_message VARCHAR2(100);
960:
961: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
962:
963: BEGIN
964: -- Standard Start of API savepoint
965: SAVEPOINT create_ctr_associations_pub;

Line 1244: ,p_ctr_reading_lock_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec

1240: p_api_version IN NUMBER
1241: ,p_commit IN VARCHAR2
1242: ,p_init_msg_list IN VARCHAR2
1243: ,p_validation_level IN NUMBER
1244: ,p_ctr_reading_lock_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
1245: ,x_return_status OUT NOCOPY VARCHAR2
1246: ,x_msg_count OUT NOCOPY NUMBER
1247: ,x_msg_data OUT NOCOPY VARCHAR2
1248: ,x_reading_lock_id OUT NOCOPY NUMBER

Line 1511: ,p_ctr_usage_forecast_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec

1507: p_api_version IN NUMBER
1508: ,p_commit IN VARCHAR2
1509: ,p_init_msg_list IN VARCHAR2
1510: ,p_validation_level IN NUMBER
1511: ,p_ctr_usage_forecast_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
1512: ,x_return_status OUT NOCOPY VARCHAR2
1513: ,x_msg_count OUT NOCOPY NUMBER
1514: ,x_msg_data OUT NOCOPY VARCHAR2
1515: ,x_instance_forecast_id OUT NOCOPY NUMBER

Line 1776: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec

1772: p_api_version IN NUMBER
1773: ,p_init_msg_list IN VARCHAR2
1774: ,p_commit IN VARCHAR2
1775: ,p_validation_level IN NUMBER
1776: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
1777: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
1778: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
1779: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
1780: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl

Line 1777: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl

1773: ,p_init_msg_list IN VARCHAR2
1774: ,p_commit IN VARCHAR2
1775: ,p_validation_level IN NUMBER
1776: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
1777: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
1778: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
1779: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
1780: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
1781: ,x_return_status out NOCOPY VARCHAR2

Line 1778: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl

1774: ,p_commit IN VARCHAR2
1775: ,p_validation_level IN NUMBER
1776: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
1777: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
1778: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
1779: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
1780: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
1781: ,x_return_status out NOCOPY VARCHAR2
1782: ,x_msg_count out NOCOPY NUMBER

Line 1779: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl

1775: ,p_validation_level IN NUMBER
1776: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
1777: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
1778: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
1779: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
1780: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
1781: ,x_return_status out NOCOPY VARCHAR2
1782: ,x_msg_count out NOCOPY NUMBER
1783: ,x_msg_data out NOCOPY VARCHAR2

Line 1780: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl

1776: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
1777: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
1778: ,P_counter_relationships_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
1779: ,P_ctr_derived_filters_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
1780: ,P_counter_associations_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
1781: ,x_return_status out NOCOPY VARCHAR2
1782: ,x_msg_count out NOCOPY NUMBER
1783: ,x_msg_data out NOCOPY VARCHAR2
1784: )

Line 1796: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;

1792: l_msg_count NUMBER;
1793: l_count NUMBER;
1794: l_return_message VARCHAR2(100);
1795:
1796: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
1797: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
1798: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
1799: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
1800:

Line 1797: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;

1793: l_count NUMBER;
1794: l_return_message VARCHAR2(100);
1795:
1796: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
1797: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
1798: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
1799: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
1800:
1801: BEGIN

Line 1798: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;

1794: l_return_message VARCHAR2(100);
1795:
1796: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
1797: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
1798: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
1799: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
1800:
1801: BEGIN
1802: -- Standard Start of API savepoint

Line 1799: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;

1795:
1796: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
1797: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
1798: l_ctr_derived_filters_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec;
1799: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
1800:
1801: BEGIN
1802: -- Standard Start of API savepoint
1803: SAVEPOINT update_counter_pub;

Line 2392: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl

2388: p_api_version IN NUMBER
2389: ,p_commit IN VARCHAR2
2390: ,p_init_msg_list IN VARCHAR2
2391: ,p_validation_level IN NUMBER
2392: ,P_ctr_properties_tbl IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
2393: ,x_return_status OUT NOCOPY VARCHAR2
2394: ,x_msg_count OUT NOCOPY NUMBER
2395: ,x_msg_data OUT NOCOPY VARCHAR2
2396: )

Line 2408: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;

2404: l_msg_count NUMBER;
2405: l_count NUMBER;
2406: l_return_message VARCHAR2(100);
2407:
2408: l_Ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec;
2409:
2410: BEGIN
2411: -- Standard Start of API savepoint
2412: SAVEPOINT update_ctr_property_pub;

Line 2684: ,p_counter_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl

2680: p_api_version IN NUMBER
2681: ,p_commit IN VARCHAR2
2682: ,p_init_msg_list IN VARCHAR2
2683: ,p_validation_level IN NUMBER
2684: ,p_counter_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
2685: ,x_return_status OUT NOCOPY VARCHAR2
2686: ,x_msg_count OUT NOCOPY NUMBER
2687: ,x_msg_data OUT NOCOPY VARCHAR2
2688: )

Line 2700: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;

2696: l_msg_count NUMBER;
2697: l_count NUMBER;
2698: l_return_message VARCHAR2(100);
2699:
2700: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
2701:
2702: BEGIN
2703: -- Standard Start of API savepoint
2704: SAVEPOINT update_ctr_associations_pub;