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 FND_GLOBAL

Line 459: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

455: l_source_direction VARCHAR2(1);
456: l_uom_rate NUMBER;
457: l_src_reading_type VARCHAR2(1);
458: l_debug_level NUMBER; -- 8214848 - dsingire
459: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
460: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
461: -- Added for bug#14561696
462: l_ctr_name VARCHAR2(50);
463: l_ctr_type VARCHAR2(30);

Line 460: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

456: l_uom_rate NUMBER;
457: l_src_reading_type VARCHAR2(1);
458: l_debug_level NUMBER; -- 8214848 - dsingire
459: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
460: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
461: -- Added for bug#14561696
462: l_ctr_name VARCHAR2(50);
463: l_ctr_type VARCHAR2(30);
464: l_rollover_last_rdg NUMBER;

Line 807: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

803: l_msg_index NUMBER;
804: l_msg_count NUMBER;
805: x_msg_data VARCHAR2(2000);
806: x_msg_count NUMBER;
807: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
808:
809: CURSOR derived_readings_cur IS
810: SELECT counter_value_id, counter_id
811: FROM csi_counter_readings

Line 892: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

888: l_process_flag BOOLEAN := TRUE;
889: l_dummy VARCHAR2(1);
890: l_api_name VARCHAR2(30) := 'CREATE_READING_TRANSACTION';
891: l_debug_level NUMBER; -- 8214848 - dsingire
892: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
893: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
894: BEGIN
895: SAVEPOINT create_reading_transaction;
896: --

Line 893: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

889: l_dummy VARCHAR2(1);
890: l_api_name VARCHAR2(30) := 'CREATE_READING_TRANSACTION';
891: l_debug_level NUMBER; -- 8214848 - dsingire
892: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
893: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
894: BEGIN
895: SAVEPOINT create_reading_transaction;
896: --
897: -- Read the debug profiles values in to global variable 7197402

Line 1134: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

1130: l_prev_value_max_timestamp DATE;
1131: l_prev_max_comments VARCHAR2(240);
1132: l_counter_id NUMBER;
1133: l_debug_level NUMBER; -- 8214848 - dsingire
1134: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
1135: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
1136: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
1137: -- Bug 9148094
1138: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');

Line 1135: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

1131: l_prev_max_comments VARCHAR2(240);
1132: l_counter_id NUMBER;
1133: l_debug_level NUMBER; -- 8214848 - dsingire
1134: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
1135: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
1136: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
1137: -- Bug 9148094
1138: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');
1139:

Line 2976: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

2972: l_process_flag BOOLEAN;
2973: l_mode VARCHAR2(30);
2974: Process_Next EXCEPTION;
2975: l_debug_level NUMBER; -- 8214848 - dsingire
2976: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
2977: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
2978: l_ctr_val_max NUMBER := -1;
2979: l_net_reading_bind NUMBER;
2980: l_value_max_timestamp DATE;

Line 2977: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

2973: l_mode VARCHAR2(30);
2974: Process_Next EXCEPTION;
2975: l_debug_level NUMBER; -- 8214848 - dsingire
2976: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
2977: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
2978: l_ctr_val_max NUMBER := -1;
2979: l_net_reading_bind NUMBER;
2980: l_value_max_timestamp DATE;
2981: l_net_max_reading NUMBER;

Line 3611: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

3607: l_bind_varname VARCHAR2(240);
3608: l_bind_varvalc VARCHAR2(240);
3609: l_bind_varvaln NUMBER;
3610: l_debug_level NUMBER; -- 8214848 - dsingire
3611: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
3612: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
3613:
3614: BEGIN
3615: -- Standard Start of API savepoint

Line 3612: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

3608: l_bind_varvalc VARCHAR2(240);
3609: l_bind_varvaln NUMBER;
3610: l_debug_level NUMBER; -- 8214848 - dsingire
3611: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
3612: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
3613:
3614: BEGIN
3615: -- Standard Start of API savepoint
3616: SAVEPOINT compute_derive_counters;

Line 4116: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

4112: l_source_direction VARCHAR2(1);
4113: l_uom_rate NUMBER;
4114: l_src_reading_type VARCHAR2(1);
4115: l_debug_level NUMBER; -- 8214848 - dsingire
4116: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
4117: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
4118: BEGIN
4119: -- Standard Start of API savepoint
4120: SAVEPOINT compute_target_counters;

Line 4117: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

4113: l_uom_rate NUMBER;
4114: l_src_reading_type VARCHAR2(1);
4115: l_debug_level NUMBER; -- 8214848 - dsingire
4116: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
4117: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
4118: BEGIN
4119: -- Standard Start of API savepoint
4120: SAVEPOINT compute_target_counters;
4121: -- Standard call to check for call compatibility.

Line 5082: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

5078: l_prev_ltd_max_reading NUMBER;
5079: l_prev_value_max_timestamp DATE;
5080: l_prev_max_comments VARCHAR2(240);
5081: l_debug_level NUMBER; -- 8214848 - dsingire
5082: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
5083: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
5084: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
5085: --
5086: -- Bug 9148094

Line 5083: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

5079: l_prev_value_max_timestamp DATE;
5080: l_prev_max_comments VARCHAR2(240);
5081: l_debug_level NUMBER; -- 8214848 - dsingire
5082: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
5083: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
5084: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
5085: --
5086: -- Bug 9148094
5087: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');

Line 6077: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

6073: l_n_temp NUMBER;
6074: l_d_temp DATE;
6075: l_process_flag BOOLEAN := TRUE;
6076: l_debug_level NUMBER; -- 8214848 - dsingire
6077: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
6078: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
6079: --
6080: CURSOR PROP_LOV_CUR(p_prop_id IN NUMBER) IS
6081: select lookup_code,meaning --Meaning added for bug #6904836

Line 6078: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

6074: l_d_temp DATE;
6075: l_process_flag BOOLEAN := TRUE;
6076: l_debug_level NUMBER; -- 8214848 - dsingire
6077: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
6078: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
6079: --
6080: CURSOR PROP_LOV_CUR(p_prop_id IN NUMBER) IS
6081: select lookup_code,meaning --Meaning added for bug #6904836
6082: from CSI_LOOKUPS

Line 7333: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire

7329: and nvl(disabled_flag,'N') = 'N';
7330: --
7331: l_ctr_val_id NUMBER;
7332: l_debug_level NUMBER; -- 8214848 - dsingire
7333: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
7334: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
7335: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
7336: BEGIN
7337: SAVEPOINT ESTIMATE_COUNTER_READING;

Line 7334: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire

7330: --
7331: l_ctr_val_id NUMBER;
7332: l_debug_level NUMBER; -- 8214848 - dsingire
7333: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
7334: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
7335: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
7336: BEGIN
7337: SAVEPOINT ESTIMATE_COUNTER_READING;
7338: -- Initialize message list if p_init_msg_list is set to TRUE.