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 DBMS_SQL

Line 2646: l_cursor_handle := dbms_sql.open_cursor;

2642: when no_data_found then
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);

Line 2650: DBMS_SQL.PARSE(l_cursor_handle, l_formula_text, dbms_sql.native);

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
2652: when others then
2653: csi_ctr_gen_utility_pvt.ExitWithErrMsg
2654: ( p_msg_name => 'CSI_API_CTR_FORMULA_DEF_INV',

Line 2660: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);

2656: p_token1_val => l_formula_text
2657: );
2658: End;
2659: --
2660: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);
2661: --
2662: l_src_count := 0;
2663: l_src_ctr_tbl.DELETE;
2664: -- l_src_ctr_bl will be used when we re-calculate the later readings of this formula counter

Line 2702: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));

2698: --
2699: OPEN GET_NET_RDG_CUR(sub_cur.source_counter_id,p_ctr_rdg_rec.value_timestamp);
2700: FETCH GET_NET_RDG_CUR INTO l_bind_var_value;
2701: CLOSE GET_NET_RDG_CUR;
2702: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));
2703: END LOOP; -- Sub Cursor
2704: --
2705: l_n_temp := dbms_sql.execute(l_cursor_handle);
2706: --Get the value

Line 2705: l_n_temp := dbms_sql.execute(l_cursor_handle);

2701: CLOSE GET_NET_RDG_CUR;
2702: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));
2703: END LOOP; -- Sub Cursor
2704: --
2705: l_n_temp := dbms_sql.execute(l_cursor_handle);
2706: --Get the value
2707: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
2708: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
2709: ELSE

Line 2707: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN

2703: END LOOP; -- Sub Cursor
2704: --
2705: l_n_temp := dbms_sql.execute(l_cursor_handle);
2706: --Get the value
2707: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
2708: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
2709: ELSE
2710: l_counter_reading := 0;
2711: END IF;

Line 2708: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);

2704: --
2705: l_n_temp := dbms_sql.execute(l_cursor_handle);
2706: --Get the value
2707: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
2708: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
2709: ELSE
2710: l_counter_reading := 0;
2711: END IF;
2712: --Close cursor

Line 2713: DBMS_SQL.close_cursor(l_cursor_handle);

2709: ELSE
2710: l_counter_reading := 0;
2711: END IF;
2712: --Close cursor
2713: DBMS_SQL.close_cursor(l_cursor_handle);
2714: --
2715: -- If the source counter reading is not disabled then we update/insert the row for formula
2716: -- counter.
2717: --

Line 2911: l_cursor_handle := dbms_sql.open_cursor;

2907: -- Re-compute Later Formula Counter Readings
2908: -- For this Formula counter, pick up the readings later than passed timestamp and re-compute
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

Line 2916: DBMS_SQL.PARSE(l_cursor_handle, l_formula_text, dbms_sql.native);

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
2918: when others then
2919: csi_ctr_gen_utility_pvt.ExitWithErrMsg
2920: ( p_msg_name => 'CSI_API_CTR_FORMULA_DEF_INV',

Line 2926: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);

2922: p_token1_val => l_formula_text
2923: );
2924: End;
2925: --
2926: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);
2927: --
2928: -- Since we already have the list of Source counters for this Object (Formula) we are using it.
2929: IF l_src_ctr_tbl.count > 0 THEN
2930: FOR src_rec in l_src_ctr_tbl.FIRST .. l_src_ctr_tbl.LAST LOOP

Line 2936: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));

2932: l_bind_var_value := NULL;
2933: OPEN GET_NET_RDG_CUR(l_src_ctr_tbl(src_rec).source_counter_id,later_rec.value_timestamp);
2934: FETCH GET_NET_RDG_CUR INTO l_bind_var_value;
2935: CLOSE GET_NET_RDG_CUR;
2936: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));
2937: END LOOP;
2938: END IF;
2939: --
2940: l_n_temp := dbms_sql.execute(l_cursor_handle);

Line 2940: l_n_temp := dbms_sql.execute(l_cursor_handle);

2936: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));
2937: END LOOP;
2938: END IF;
2939: --
2940: l_n_temp := dbms_sql.execute(l_cursor_handle);
2941: --Get the value
2942: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
2943: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
2944: -- Updating Formula Counter

Line 2942: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN

2938: END IF;
2939: --
2940: l_n_temp := dbms_sql.execute(l_cursor_handle);
2941: --Get the value
2942: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
2943: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
2944: -- Updating Formula Counter
2945: csi_ctr_gen_utility_pvt.put_line('Re-computing later formula Ctr Value ID '||to_char(later_rec.counter_value_id));
2946: Update CSI_COUNTER_READINGS

Line 2943: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);

2939: --
2940: l_n_temp := dbms_sql.execute(l_cursor_handle);
2941: --Get the value
2942: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
2943: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
2944: -- Updating Formula Counter
2945: csi_ctr_gen_utility_pvt.put_line('Re-computing later formula Ctr Value ID '||to_char(later_rec.counter_value_id));
2946: Update CSI_COUNTER_READINGS
2947: set counter_reading = l_counter_reading,

Line 2957: DBMS_SQL.close_cursor(l_cursor_handle);

2953: ELSE
2954: l_counter_reading := 0;
2955: END IF;
2956: --Close cursor
2957: DBMS_SQL.close_cursor(l_cursor_handle);
2958: END LOOP; -- Later Formula Readings Loop
2959: Exception
2960: when Process_Next then
2961: null;

Line 3294: l_cursor_handle := dbms_sql.open_cursor;

3290: END LOOP;
3291: --
3292: if l_sqlwhere is null then
3293: l_sqlstr := l_sqlstr_init || ' where cv.counter_id = :x_derive_counter_id';
3294: l_cursor_handle := dbms_sql.open_cursor;
3295: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3296: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3297: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3298: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);

Line 3295: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);

3291: --
3292: if l_sqlwhere is null then
3293: l_sqlstr := l_sqlstr_init || ' where cv.counter_id = :x_derive_counter_id';
3294: l_cursor_handle := dbms_sql.open_cursor;
3295: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3296: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3297: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3298: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3299: else

Line 3296: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);

3292: if l_sqlwhere is null then
3293: l_sqlstr := l_sqlstr_init || ' where cv.counter_id = :x_derive_counter_id';
3294: l_cursor_handle := dbms_sql.open_cursor;
3295: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3296: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3297: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3298: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3299: else
3300: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';

Line 3298: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);

3294: l_cursor_handle := dbms_sql.open_cursor;
3295: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3296: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3297: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3298: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3299: else
3300: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
3301: l_cursor_handle := dbms_sql.open_cursor;
3302: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);

Line 3301: l_cursor_handle := dbms_sql.open_cursor;

3297: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3298: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3299: else
3300: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
3301: l_cursor_handle := dbms_sql.open_cursor;
3302: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3303: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3304:
3305: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;

Line 3302: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);

3298: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3299: else
3300: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
3301: l_cursor_handle := dbms_sql.open_cursor;
3302: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3303: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3304:
3305: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3306: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);

Line 3303: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);

3299: else
3300: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
3301: l_cursor_handle := dbms_sql.open_cursor;
3302: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3303: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3304:
3305: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3306: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3307:

Line 3306: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);

3302: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3303: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3304:
3305: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3306: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3307:
3308: while lj < i+1
3309: loop
3310: l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;

Line 3312: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);

3308: while lj < i+1
3309: loop
3310: l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;
3311: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
3312: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
3313: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
3314: l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
3315: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
3316: lj:= lj+1;

Line 3315: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);

3311: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
3312: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
3313: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
3314: l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
3315: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
3316: lj:= lj+1;
3317: end loop;
3318: end if;
3319: --

Line 3321: l_n_temp := dbms_sql.execute(l_cursor_handle);

3317: end loop;
3318: end if;
3319: --
3320: csi_ctr_gen_utility_pvt.put_line('SQL String is '||l_sqlstr);
3321: l_n_temp := dbms_sql.execute(l_cursor_handle);
3322: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3323: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
3324: END IF;
3325: DBMS_SQL.close_cursor(l_cursor_handle);

Line 3322: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN

3318: end if;
3319: --
3320: csi_ctr_gen_utility_pvt.put_line('SQL String is '||l_sqlstr);
3321: l_n_temp := dbms_sql.execute(l_cursor_handle);
3322: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3323: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
3324: END IF;
3325: DBMS_SQL.close_cursor(l_cursor_handle);
3326: END IF;

Line 3323: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);

3319: --
3320: csi_ctr_gen_utility_pvt.put_line('SQL String is '||l_sqlstr);
3321: l_n_temp := dbms_sql.execute(l_cursor_handle);
3322: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3323: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
3324: END IF;
3325: DBMS_SQL.close_cursor(l_cursor_handle);
3326: END IF;
3327: --

Line 3325: DBMS_SQL.close_cursor(l_cursor_handle);

3321: l_n_temp := dbms_sql.execute(l_cursor_handle);
3322: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3323: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
3324: END IF;
3325: DBMS_SQL.close_cursor(l_cursor_handle);
3326: END IF;
3327: --
3328: -- Capture Reading
3329: IF l_ctr_value IS NOT NULL THEN

Line 3486: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN

3482: FND_MSG_PUB.Count_And_Get
3483: ( p_count => x_msg_count,
3484: p_data => x_msg_data
3485: );
3486: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
3487: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
3488: END IF;
3489: END Compute_Derive_Counters;
3490: --

Line 3487: DBMS_SQL.CLOSE_cursor(l_cursor_handle);

3483: ( p_count => x_msg_count,
3484: p_data => x_msg_data
3485: );
3486: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
3487: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
3488: END IF;
3489: END Compute_Derive_Counters;
3490: --
3491: PROCEDURE Compute_Target_Counters