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 285: ,l_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec

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

Line 385: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec

381: --
382: PROCEDURE Reset_Target_Counters
383: (
384: p_txn_rec IN csi_datastructures_pub.transaction_rec
385: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
386: ,x_return_status OUT NOCOPY VARCHAR2
387: ,x_msg_count OUT NOCOPY NUMBER
388: ,x_msg_data OUT NOCOPY VARCHAR2
389: )

Line 393: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

389: )
390: IS
391: l_rel_type VARCHAR2(30) := 'CONFIGURATION';
392: l_counter_reading NUMBER;
393: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
394: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
395: l_process_flag BOOLEAN;
396: l_mode VARCHAR2(30);
397: --

Line 394: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

390: IS
391: l_rel_type VARCHAR2(30) := 'CONFIGURATION';
392: l_counter_reading NUMBER;
393: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
394: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
395: l_process_flag BOOLEAN;
396: l_mode VARCHAR2(30);
397: --
398: CURSOR OBJECT_CTR_CUR IS

Line 948: ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec

944: ,p_commit IN VARCHAR2
945: ,p_init_msg_list IN VARCHAR2
946: ,p_validation_level IN NUMBER
947: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
948: ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec
949: ,x_return_status OUT NOCOPY VARCHAR2
950: ,x_msg_count OUT NOCOPY NUMBER
951: ,x_msg_data OUT NOCOPY VARCHAR2
952: )

Line 983: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

979: l_reset_value_id NUMBER;
980: l_seq_num NUMBER;
981: l_rdg_lock_date DATE;
982: l_curr_adj NUMBER;
983: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
984: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
985: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
986: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
987: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

Line 984: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

980: l_seq_num NUMBER;
981: l_rdg_lock_date DATE;
982: l_curr_adj NUMBER;
983: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
984: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
985: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
986: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
987: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
988: l_reset_timestamp DATE;

Line 985: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

981: l_rdg_lock_date DATE;
982: l_curr_adj NUMBER;
983: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
984: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
985: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
986: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
987: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
988: l_reset_timestamp DATE;
989: l_exists VARCHAR2(1);

Line 986: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

982: l_curr_adj NUMBER;
983: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
984: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
985: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
986: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
987: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
988: l_reset_timestamp DATE;
989: l_exists VARCHAR2(1);
990: l_target_ctr_exist VARCHAR2(1);

Line 987: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

983: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
984: l_reset_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
985: l_recalc_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
986: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
987: l_disabled_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
988: l_reset_timestamp DATE;
989: l_exists VARCHAR2(1);
990: l_target_ctr_exist VARCHAR2(1);
991: l_update_loop BOOLEAN := FALSE;

Line 992: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

988: l_reset_timestamp DATE;
989: l_exists VARCHAR2(1);
990: l_target_ctr_exist VARCHAR2(1);
991: l_update_loop BOOLEAN := FALSE;
992: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
993: l_mode VARCHAR2(30);
994: l_prev_comments VARCHAR2(240);
995: l_next_comments VARCHAR2(240);
996: l_rec_count NUMBER;

Line 2517: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec

2513: ,p_commit IN VARCHAR2
2514: ,p_init_msg_list IN VARCHAR2
2515: ,p_validation_level IN NUMBER
2516: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2517: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
2518: ,x_return_status OUT NOCOPY VARCHAR2
2519: ,x_msg_count OUT NOCOPY NUMBER
2520: ,x_msg_data OUT NOCOPY VARCHAR2
2521: )

Line 3010: p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec,

3006: P_Init_Msg_List IN VARCHAR2,
3007: P_Commit IN VARCHAR2,
3008: p_validation_level IN NUMBER,
3009: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3010: p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec,
3011: p_mode IN VARCHAR2,
3012: X_Return_Status OUT NOCOPY VARCHAR2,
3013: X_Msg_Count OUT NOCOPY NUMBER,
3014: X_Msg_Data OUT NOCOPY VARCHAR2

Line 3073: l_ctr_in csi_ctr_datastructures_pub.counter_readings_rec;

3069: l_ctr_value NUMBER;
3070: l_n_temp NUMBER;
3071: l_ctr_value_id NUMBER;
3072: l_process_flag BOOLEAN;
3073: l_ctr_in csi_ctr_datastructures_pub.counter_readings_rec;
3074: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
3075: --
3076: --variable and arrays for binding dbmssql
3077: TYPE FILTS IS RECORD(

Line 3074: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

3070: l_n_temp NUMBER;
3071: l_ctr_value_id NUMBER;
3072: l_process_flag BOOLEAN;
3073: l_ctr_in csi_ctr_datastructures_pub.counter_readings_rec;
3074: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
3075: --
3076: --variable and arrays for binding dbmssql
3077: TYPE FILTS IS RECORD(
3078: BINDNAME_RIGHTVAL VARCHAR2(240),

Line 3498: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec

3494: ,p_commit IN VARCHAR2
3495: ,p_init_msg_list IN VARCHAR2
3496: ,p_validation_level IN NUMBER
3497: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
3498: ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
3499: ,p_mode IN VARCHAR2
3500: ,x_return_status OUT NOCOPY VARCHAR2
3501: ,x_msg_count OUT NOCOPY NUMBER
3502: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3518: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

3514: l_prev_ltd_reading NUMBER;
3515: l_prev_value_timestamp DATE;
3516: l_net_reading NUMBER;
3517: l_ltd_reading NUMBER;
3518: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
3519: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
3520: l_process_flag BOOLEAN;
3521: l_mode VARCHAR2(30);
3522: Process_next EXCEPTION;

Line 3519: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

3515: l_prev_value_timestamp DATE;
3516: l_net_reading NUMBER;
3517: l_ltd_reading NUMBER;
3518: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
3519: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
3520: l_process_flag BOOLEAN;
3521: l_mode VARCHAR2(30);
3522: Process_next EXCEPTION;
3523: l_instance_id NUMBER;

Line 4323: ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec

4319: p_api_version IN NUMBER
4320: ,p_commit IN VARCHAR2
4321: ,p_init_msg_list IN VARCHAR2
4322: ,p_validation_level IN NUMBER
4323: ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec
4324: ,x_return_status OUT NOCOPY VARCHAR2
4325: ,x_msg_count OUT NOCOPY NUMBER
4326: ,x_msg_data OUT NOCOPY VARCHAR2
4327: )

Line 4361: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

4357: l_previous_ltd NUMBER;
4358: l_process_flag BOOLEAN := TRUE;
4359: l_seq_num NUMBER;
4360: l_rdg_lock_date DATE;
4361: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
4362: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4363: l_exists VARCHAR2(1);
4364: l_update_loop BOOLEAN := FALSE;
4365: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

Line 4362: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

4358: l_process_flag BOOLEAN := TRUE;
4359: l_seq_num NUMBER;
4360: l_rdg_lock_date DATE;
4361: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
4362: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4363: l_exists VARCHAR2(1);
4364: l_update_loop BOOLEAN := FALSE;
4365: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4366: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

Line 4365: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;

4361: l_target_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
4362: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4363: l_exists VARCHAR2(1);
4364: l_update_loop BOOLEAN := FALSE;
4365: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4366: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
4367: l_txn_rec csi_datastructures_pub.transaction_rec;
4368: l_mode VARCHAR2(30);
4369: l_txn_type_id NUMBER;

Line 4366: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;

4362: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4363: l_exists VARCHAR2(1);
4364: l_update_loop BOOLEAN := FALSE;
4365: l_upd_fl_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
4366: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
4367: l_txn_rec csi_datastructures_pub.transaction_rec;
4368: l_mode VARCHAR2(30);
4369: l_txn_type_id NUMBER;
4370: l_ctr_val_max_seq_no NUMBER;

Line 5217: ,p_ctr_prop_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.ctr_property_readings_rec

5213: p_api_version IN NUMBER
5214: ,p_commit IN VARCHAR2
5215: ,p_init_msg_list IN VARCHAR2
5216: ,p_validation_level IN NUMBER
5217: ,p_ctr_prop_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.ctr_property_readings_rec
5218: ,x_return_status OUT NOCOPY VARCHAR2
5219: ,x_msg_count OUT NOCOPY NUMBER
5220: ,x_msg_data OUT NOCOPY VARCHAR2
5221: )