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 DUAL

Line 154: from dual

150: BEGIN
151: Begin
152: select '1'
153: into l_exists
154: from dual
155: where exists (select 'x'
156: from CSI_COUNTER_RELATIONSHIPS
157: where object_counter_id = p_counter_id
158: and relationship_type_code = l_rel_type);

Line 177: from dual

173: BEGIN
174: Begin
175: select '1'
176: into l_exists
177: from dual
178: where exists (select 'x'
179: from CSI_COUNTER_RELATIONSHIPS
180: where object_counter_id = p_counter_id
181: and relationship_type_code = l_rel_type

Line 505: into l_ctr_rdg_rec.counter_value_id from dual;

501: -- Generate the Value_id for insert
502: l_process_flag := TRUE;
503: WHILE l_process_flag LOOP
504: select CSI_COUNTER_READINGS_S.nextval
505: into l_ctr_rdg_rec.counter_value_id from dual;
506: IF NOT Counter_Value_Exists(l_ctr_rdg_rec.counter_value_id) THEN
507: l_process_flag := FALSE;
508: END IF;
509:

Line 795: into p_txn_rec.transaction_id from dual;

791: p_txn_rec.transaction_id = FND_API.G_MISS_NUM THEN
792: l_process_flag := TRUE;
793: WHILE l_process_flag LOOP
794: select CSI_TRANSACTIONS_S.nextval
795: into p_txn_rec.transaction_id from dual;
796: IF NOT csi_counter_readings_pvt.Transaction_ID_Exists(p_txn_rec.transaction_id) THEN
797: l_process_flag := FALSE;
798: END IF;
799: END LOOP;

Line 1179: from dual

1175: IF p_txn_rec.transaction_type_id in (91,92,94,95) THEN
1176: BEGIN
1177: select 'x'
1178: into l_exists
1179: from dual
1180: where exists (select 'x'
1181: from CSI_COUNTER_READINGS
1182: where counter_id = p_ctr_rdg_rec.counter_id
1183: and value_timestamp = p_ctr_rdg_rec.value_timestamp

Line 1858: into p_ctr_rdg_rec.counter_value_id from dual;

1854: IF p_ctr_rdg_rec.counter_value_id IS NULL OR
1855: p_ctr_rdg_rec.counter_value_id = FND_API.G_MISS_NUM THEN
1856: WHILE l_process_flag LOOP
1857: select CSI_COUNTER_READINGS_S.nextval
1858: into p_ctr_rdg_rec.counter_value_id from dual;
1859: IF NOT Counter_Value_Exists(p_ctr_rdg_rec.counter_value_id) THEN
1860: l_process_flag := FALSE;
1861: END IF;
1862: END LOOP;

Line 2310: into l_reset_rdg_rec.counter_value_id from dual;

2306: -- Generate the Value_id
2307: l_process_flag := TRUE;
2308: WHILE l_process_flag LOOP
2309: select CSI_COUNTER_READINGS_S.nextval
2310: into l_reset_rdg_rec.counter_value_id from dual;
2311: IF NOT Counter_Value_Exists(l_reset_rdg_rec.counter_value_id) THEN
2312: l_process_flag := FALSE;
2313: END IF;
2314: END LOOP;

Line 2647: l_formula_text := 'SELECT '||l_formula_text||' FROM DUAL';

2643: RAISE Process_Next;
2644: End;
2645: --
2646: l_cursor_handle := dbms_sql.open_cursor;
2647: l_formula_text := 'SELECT '||l_formula_text||' FROM DUAL';
2648: --
2649: Begin
2650: DBMS_SQL.PARSE(l_cursor_handle, l_formula_text, dbms_sql.native);
2651: Exception

Line 2679: into l_exists from dual

2675: sub_cur.source_counter_id <> p_ctr_rdg_rec.counter_id AND
2676: l_other_src_captured <> 'T' THEN
2677: Begin
2678: select '1'
2679: into l_exists from dual
2680: where exists (select 'x'
2681: from CSI_COUNTER_READINGS
2682: where counter_id = sub_cur.source_counter_id
2683: and value_timestamp = p_ctr_rdg_rec.value_timestamp

Line 2735: into l_ctr_value_id from dual;

2731: -- Generate the Value_id for insert
2732: l_process_flag := TRUE;
2733: WHILE l_process_flag LOOP
2734: select CSI_COUNTER_READINGS_S.nextval
2735: into l_ctr_value_id from dual;
2736: IF NOT Counter_Value_Exists(l_ctr_value_id) THEN
2737: l_process_flag := FALSE;
2738: END IF;
2739: END LOOP;

Line 2913: -- l_formula_text := 'SELECT '||l_formula_text||' FROM DUAL';

2909: --
2910: FOR later_rec IN LATER_FORMULA_CUR(obj_cur.object_counter_id,p_ctr_rdg_rec.value_timestamp) LOOP
2911: l_cursor_handle := dbms_sql.open_cursor;
2912: -- Formula Text is reused from the above
2913: -- l_formula_text := 'SELECT '||l_formula_text||' FROM DUAL';
2914: --
2915: Begin
2916: DBMS_SQL.PARSE(l_cursor_handle, l_formula_text, dbms_sql.native);
2917: Exception

Line 3362: into l_ctr_value_id from dual;

3358: -- Generate the Value_id for insert
3359: l_process_flag := TRUE;
3360: WHILE l_process_flag LOOP
3361: select CSI_COUNTER_READINGS_S.nextval
3362: into l_ctr_value_id from dual;
3363: IF NOT Counter_Value_Exists(l_ctr_value_id) THEN
3364: l_process_flag := FALSE;
3365: END IF;
3366: END LOOP;

Line 4169: into l_ctr_rdg_rec.counter_value_id from dual;

4165: -- Generate the Value_id for insert
4166: l_process_flag := TRUE;
4167: WHILE l_process_flag LOOP
4168: select CSI_COUNTER_READINGS_S.nextval
4169: into l_ctr_rdg_rec.counter_value_id from dual;
4170: IF NOT Counter_Value_Exists(l_ctr_rdg_rec.counter_value_id) THEN
4171: l_process_flag := FALSE;
4172: END IF;
4173: END LOOP;

Line 5371: into p_ctr_prop_rdg_rec.counter_prop_value_id from dual;

5367: IF p_ctr_prop_rdg_rec.counter_prop_value_id IS NULL OR
5368: p_ctr_prop_rdg_rec.counter_prop_value_id = FND_API.G_MISS_NUM THEN
5369: WHILE l_process_flag LOOP
5370: select CSI_CTR_PROPERTY_READINGS_S.nextval
5371: into p_ctr_prop_rdg_rec.counter_prop_value_id from dual;
5372: IF NOT Counter_Prop_Value_Exists(p_ctr_prop_rdg_rec.counter_prop_value_id) THEN
5373: l_process_flag := FALSE;
5374: END IF;
5375: END LOOP;

Line 6677: into l_estimated_rdg_id from dual;

6673: -- Generate the Value_id for insert
6674: l_process_flag := TRUE;
6675: WHILE l_process_flag LOOP
6676: select CSI_CTR_ESTIMATED_READINGS_S.nextval
6677: into l_estimated_rdg_id from dual;
6678: IF NOT Estimated_Rdg_ID_Exists(l_estimated_rdg_id) THEN
6679: l_process_flag := FALSE;
6680: END IF;
6681: END LOOP;