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 3305: ,P_ctr_properties_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_rec

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

Line 3321: l_old_ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_properties_rec;

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

Line 3322: l_ctr_properties_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_properties_rec;

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

Line 3739: ,P_counter_associations_rec IN out NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec

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

Line 3755: l_old_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;

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

Line 3756: l_counter_associations_rec CSI_CTR_DATASTRUCTURES_PUB.counter_associations_rec;

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