DBA Data[Home] [Help]

APPS.CSI_COUNTER_PVT dependencies on CSI_CTR_DATASTRUCTURES_PUB

Line 529: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec

525: p_api_version IN NUMBER
526: ,p_init_msg_list IN VARCHAR2
527: ,p_commit IN VARCHAR2
528: ,p_validation_level IN VARCHAR2
529: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
530: ,x_return_status OUT NOCOPY VARCHAR2
531: ,x_msg_count OUT NOCOPY NUMBER
532: ,x_msg_data OUT NOCOPY VARCHAR2
533: ,x_ctr_id OUT NOCOPY NUMBER

Line 613: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;

609: l_time_based_manual_entry VARCHAR2(1);
610: l_eam_required_flag VARCHAR2(1);
611:
612: l_dummy VARCHAR2(1);
613: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
614: l_ctr_group_id NUMBER;
615: BEGIN
616: -- Standard Start of API savepoint
617: SAVEPOINT create_counter_pvt;

Line 1205: ,p_ctr_properties_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_Properties_Rec

1201: p_api_version IN NUMBER
1202: ,p_commit IN VARCHAR2
1203: ,p_init_msg_list IN VARCHAR2
1204: ,p_validation_level IN NUMBER
1205: ,p_ctr_properties_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_Properties_Rec
1206: ,x_return_status OUT NOCOPY VARCHAR2
1207: ,x_msg_count OUT NOCOPY NUMBER
1208: ,x_msg_data OUT NOCOPY VARCHAR2
1209: ,x_ctr_property_id OUT NOCOPY NUMBER

Line 1593: ,P_counter_associations_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec

1589: p_api_version IN NUMBER
1590: ,p_commit IN VARCHAR2
1591: ,p_init_msg_list IN VARCHAR2
1592: ,p_validation_level IN NUMBER
1593: ,P_counter_associations_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec
1594: ,x_return_status OUT NOCOPY VARCHAR2
1595: ,x_msg_count OUT NOCOPY NUMBER
1596: ,x_msg_data OUT NOCOPY VARCHAR2
1597: ,x_instance_association_id OUT NOCOPY NUMBER

Line 1984: ,p_ctr_reading_lock_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec

1980: p_api_version IN NUMBER
1981: ,p_commit IN VARCHAR2
1982: ,p_init_msg_list IN VARCHAR2
1983: ,p_validation_level IN NUMBER
1984: ,p_ctr_reading_lock_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
1985: ,x_return_status OUT NOCOPY VARCHAR2
1986: ,x_msg_count OUT NOCOPY NUMBER
1987: ,x_msg_data OUT NOCOPY VARCHAR2
1988: ,x_reading_lock_id OUT NOCOPY NUMBER

Line 2244: ,p_ctr_usage_forecast_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec

2240: p_api_version IN NUMBER
2241: ,p_commit IN VARCHAR2
2242: ,p_init_msg_list IN VARCHAR2
2243: ,p_validation_level IN NUMBER
2244: ,p_ctr_usage_forecast_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
2245: ,x_return_status OUT NOCOPY VARCHAR2
2246: ,x_msg_count OUT NOCOPY NUMBER
2247: ,x_msg_data OUT NOCOPY VARCHAR2
2248: ,x_instance_forecast_id OUT NOCOPY NUMBER

Line 2468: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec

2464: p_api_version IN NUMBER
2465: ,p_init_msg_list IN VARCHAR2
2466: ,p_commit IN VARCHAR2
2467: ,p_validation_level IN VARCHAR2
2468: ,p_counter_instance_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
2469: ,x_return_status OUT NOCOPY VARCHAR2
2470: ,x_msg_count OUT NOCOPY NUMBER
2471: ,x_msg_data OUT NOCOPY VARCHAR2
2472: )

Line 2485: l_old_counter_instance_rec CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec;

2481: l_count NUMBER;
2482: l_return_message VARCHAR2(100);
2483: l_return_status VARCHAR2(40);
2484:
2485: l_old_counter_instance_rec CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec;
2486: l_counter_instance_rec CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec;
2487:
2488: CURSOR formula_ref_cur(p_counter_id number) IS
2489: SELECT relationship_id

Line 2486: l_counter_instance_rec CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec;

2482: l_return_message VARCHAR2(100);
2483: l_return_status VARCHAR2(40);
2484:
2485: l_old_counter_instance_rec CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec;
2486: l_counter_instance_rec CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec;
2487:
2488: CURSOR formula_ref_cur(p_counter_id number) IS
2489: SELECT relationship_id
2490: FROM csi_counter_relationships

Line 3308: ,P_ctr_properties_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec

3304: p_api_version IN NUMBER
3305: ,p_commit IN VARCHAR2
3306: ,p_init_msg_list IN VARCHAR2
3307: ,p_validation_level IN NUMBER
3308: ,P_ctr_properties_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec
3309: ,x_return_status OUT NOCOPY VARCHAR2
3310: ,x_msg_count OUT NOCOPY NUMBER
3311: ,x_msg_data OUT NOCOPY VARCHAR2
3312: )

Line 3324: l_old_ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_properties_rec;

3320: l_msg_count NUMBER;
3321: l_count NUMBER;
3322: l_return_message VARCHAR2(100);
3323:
3324: l_old_ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_properties_rec;
3325: l_ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_properties_rec;
3326: CURSOR prop_rdgs_cur(p_counter_property_id NUMBER) IS
3327: SELECT counter_prop_value_id
3328: FROM CSI_CTR_PROPERTY_READINGS

Line 3325: l_ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_properties_rec;

3321: l_count NUMBER;
3322: l_return_message VARCHAR2(100);
3323:
3324: l_old_ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_properties_rec;
3325: l_ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_properties_rec;
3326: CURSOR prop_rdgs_cur(p_counter_property_id NUMBER) IS
3327: SELECT counter_prop_value_id
3328: FROM CSI_CTR_PROPERTY_READINGS
3329: WHERE counter_property_id = p_counter_property_id;

Line 3742: ,P_counter_associations_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec

3738: p_api_version IN NUMBER
3739: ,p_commit IN VARCHAR2
3740: ,p_init_msg_list IN VARCHAR2
3741: ,p_validation_level IN NUMBER
3742: ,P_counter_associations_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec
3743: ,x_return_status OUT NOCOPY VARCHAR2
3744: ,x_msg_count OUT NOCOPY NUMBER
3745: ,x_msg_data OUT NOCOPY VARCHAR2
3746: )

Line 3758: l_old_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;

3754: l_msg_count NUMBER;
3755: l_count NUMBER;
3756: l_return_message VARCHAR2(100);
3757:
3758: l_old_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
3759: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
3760:
3761: BEGIN
3762: -- Standard Start of API savepoint

Line 3759: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;

3755: l_count NUMBER;
3756: l_return_message VARCHAR2(100);
3757:
3758: l_old_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
3759: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;
3760:
3761: BEGIN
3762: -- Standard Start of API savepoint
3763: SAVEPOINT update_ctr_associations_pvt;