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_READINGS_PVT dependencies on CSI_CTR_DATASTRUCTURES_PUB

Line 286: ,l_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec

282: ,p_prev_rdg IN NUMBER
283: ,p_curr_adj IN NUMBER
284: ,p_rdg_type IN NUMBER
285: ,p_direction IN VARCHAR2
286: ,l_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
287: ,px_net_rdg OUT NOCOPY NUMBER
288: ,px_ltd_rdg OUT NOCOPY NUMBER
289: ) IS
290: l_curr_adj NUMBER;

Line 400: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec

396: --
397: PROCEDURE Reset_Target_Counters
398: (
399: p_txn_rec IN csi_datastructures_pub.transaction_rec
400: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
401: ,x_return_status OUT NOCOPY VARCHAR2
402: ,x_msg_count OUT NOCOPY NUMBER
403: ,x_msg_data OUT NOCOPY VARCHAR2
404: )

Line 408: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

404: )
405: IS
406: l_rel_type VARCHAR2(30) := 'CONFIGURATION';
407: l_counter_reading NUMBER;
408: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
409: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
410: l_process_flag BOOLEAN;
411: l_mode VARCHAR2(30);
412:

Line 409: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

405: IS
406: l_rel_type VARCHAR2(30) := 'CONFIGURATION';
407: l_counter_reading NUMBER;
408: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
409: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
410: l_process_flag BOOLEAN;
411: l_mode VARCHAR2(30);
412:
413: -- Bug 8214848

Line 1072: ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec

1068: ,p_commit IN VARCHAR2
1069: ,p_init_msg_list IN VARCHAR2
1070: ,p_validation_level IN NUMBER
1071: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1072: ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec
1073: ,x_return_status OUT NOCOPY VARCHAR2
1074: ,x_msg_count OUT NOCOPY NUMBER
1075: ,x_msg_data OUT NOCOPY VARCHAR2
1076: )

Line 1107: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

1103: l_reset_value_id NUMBER;
1104: l_seq_num NUMBER;
1105: l_rdg_lock_date DATE;
1106: l_curr_adj NUMBER;
1107: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1108: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1109: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1110: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1111: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

Line 1108: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

1104: l_seq_num NUMBER;
1105: l_rdg_lock_date DATE;
1106: l_curr_adj NUMBER;
1107: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1108: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1109: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1110: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1111: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1112: l_reset_timestamp DATE;

Line 1109: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

1105: l_rdg_lock_date DATE;
1106: l_curr_adj NUMBER;
1107: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1108: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1109: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1110: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1111: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1112: l_reset_timestamp DATE;
1113: l_exists VARCHAR2(1);

Line 1110: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

1106: l_curr_adj NUMBER;
1107: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1108: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1109: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1110: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1111: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1112: l_reset_timestamp DATE;
1113: l_exists VARCHAR2(1);
1114: l_target_ctr_exist VARCHAR2(1);

Line 1111: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

1107: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1108: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1109: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1110: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
1111: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1112: l_reset_timestamp DATE;
1113: l_exists VARCHAR2(1);
1114: l_target_ctr_exist VARCHAR2(1);
1115: l_update_loop BOOLEAN := FALSE;

Line 1116: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

1112: l_reset_timestamp DATE;
1113: l_exists VARCHAR2(1);
1114: l_target_ctr_exist VARCHAR2(1);
1115: l_update_loop BOOLEAN := FALSE;
1116: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
1117: l_mode VARCHAR2(30);
1118: l_prev_comments VARCHAR2(240);
1119: l_next_comments VARCHAR2(240);
1120: l_rec_count NUMBER;

Line 2950: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec

2946: ,p_commit IN VARCHAR2
2947: ,p_init_msg_list IN VARCHAR2
2948: ,p_validation_level IN NUMBER
2949: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2950: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
2951: ,x_return_status OUT NOCOPY VARCHAR2
2952: ,x_msg_count OUT NOCOPY NUMBER
2953: ,x_msg_data OUT NOCOPY VARCHAR2
2954: )

Line 3526: p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec,

3522: P_Init_Msg_List IN VARCHAR2,
3523: P_Commit IN VARCHAR2,
3524: p_validation_level IN NUMBER,
3525: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3526: p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec,
3527: p_mode IN VARCHAR2,
3528: X_Return_Status OUT NOCOPY VARCHAR2,
3529: X_Msg_Count OUT NOCOPY NUMBER,
3530: X_Msg_Data OUT NOCOPY VARCHAR2

Line 3589: l_ctr_in csi_ctr_datastructures_pub.counter_readings_rec;

3585: l_ctr_value NUMBER;
3586: l_n_temp NUMBER;
3587: l_ctr_value_id NUMBER;
3588: l_process_flag BOOLEAN;
3589: l_ctr_in csi_ctr_datastructures_pub.counter_readings_rec;
3590: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
3591: --
3592: --variable and arrays for binding dbmssql
3593: TYPE FILTS IS RECORD(

Line 3590: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

3586: l_n_temp NUMBER;
3587: l_ctr_value_id NUMBER;
3588: l_process_flag BOOLEAN;
3589: l_ctr_in csi_ctr_datastructures_pub.counter_readings_rec;
3590: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
3591: --
3592: --variable and arrays for binding dbmssql
3593: TYPE FILTS IS RECORD(
3594: BINDNAME_RIGHTVAL VARCHAR2(240),

Line 4028: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec

4024: ,p_commit IN VARCHAR2
4025: ,p_init_msg_list IN VARCHAR2
4026: ,p_validation_level IN NUMBER
4027: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4028: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
4029: ,p_mode IN VARCHAR2
4030: ,x_return_status OUT NOCOPY VARCHAR2
4031: ,x_msg_count OUT NOCOPY NUMBER
4032: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4048: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

4044: l_prev_ltd_reading NUMBER;
4045: l_prev_value_timestamp DATE;
4046: l_net_reading NUMBER;
4047: l_ltd_reading NUMBER;
4048: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4049: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4050: l_process_flag BOOLEAN;
4051: l_mode VARCHAR2(30);
4052: Process_next EXCEPTION;

Line 4049: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

4045: l_prev_value_timestamp DATE;
4046: l_net_reading NUMBER;
4047: l_ltd_reading NUMBER;
4048: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4049: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4050: l_process_flag BOOLEAN;
4051: l_mode VARCHAR2(30);
4052: Process_next EXCEPTION;
4053: l_instance_id NUMBER;

Line 5025: ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec

5021: p_api_version IN NUMBER
5022: ,p_commit IN VARCHAR2
5023: ,p_init_msg_list IN VARCHAR2
5024: ,p_validation_level IN NUMBER
5025: ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec
5026: ,x_return_status OUT NOCOPY VARCHAR2
5027: ,x_msg_count OUT NOCOPY NUMBER
5028: ,x_msg_data OUT NOCOPY VARCHAR2
5029: )

Line 5063: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

5059: l_previous_ltd NUMBER;
5060: l_process_flag BOOLEAN := TRUE;
5061: l_seq_num NUMBER;
5062: l_rdg_lock_date DATE;
5063: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
5064: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
5065: l_exists VARCHAR2(1);
5066: l_update_loop BOOLEAN := FALSE;
5067: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

Line 5064: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

5060: l_process_flag BOOLEAN := TRUE;
5061: l_seq_num NUMBER;
5062: l_rdg_lock_date DATE;
5063: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
5064: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
5065: l_exists VARCHAR2(1);
5066: l_update_loop BOOLEAN := FALSE;
5067: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
5068: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

Line 5067: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

5063: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
5064: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
5065: l_exists VARCHAR2(1);
5066: l_update_loop BOOLEAN := FALSE;
5067: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
5068: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
5069: l_txn_rec csi_datastructures_pub.transaction_rec;
5070: l_mode VARCHAR2(30);
5071: l_txn_type_id NUMBER;

Line 5068: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

5064: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
5065: l_exists VARCHAR2(1);
5066: l_update_loop BOOLEAN := FALSE;
5067: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
5068: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
5069: l_txn_rec csi_datastructures_pub.transaction_rec;
5070: l_mode VARCHAR2(30);
5071: l_txn_type_id NUMBER;
5072: l_ctr_val_max_seq_no NUMBER;

Line 6058: ,p_ctr_prop_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.ctr_property_readings_rec

6054: p_api_version IN NUMBER
6055: ,p_commit IN VARCHAR2
6056: ,p_init_msg_list IN VARCHAR2
6057: ,p_validation_level IN NUMBER
6058: ,p_ctr_prop_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.ctr_property_readings_rec
6059: ,x_return_status OUT NOCOPY VARCHAR2
6060: ,x_msg_count OUT NOCOPY NUMBER
6061: ,x_msg_data OUT NOCOPY VARCHAR2
6062: )