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 3095: l_cursor_handle := dbms_sql.open_cursor;

3091: when no_data_found then
3092: RAISE Process_Next;
3093: End;
3094: --
3095: l_cursor_handle := dbms_sql.open_cursor;
3096: l_formula_text := 'SELECT '||l_formula_text||' FROM DUAL';
3097: --
3098: Begin
3099: DBMS_SQL.PARSE(l_cursor_handle, l_formula_text, dbms_sql.native);

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

3095: l_cursor_handle := dbms_sql.open_cursor;
3096: l_formula_text := 'SELECT '||l_formula_text||' FROM DUAL';
3097: --
3098: Begin
3099: DBMS_SQL.PARSE(l_cursor_handle, l_formula_text, dbms_sql.native);
3100: Exception
3101: when others then
3102: csi_ctr_gen_utility_pvt.ExitWithErrMsg
3103: ( p_msg_name => 'CSI_API_CTR_FORMULA_DEF_INV',

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

3105: p_token1_val => l_formula_text
3106: );
3107: End;
3108: --
3109: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);
3110: --
3111: l_src_count := 0;
3112: l_src_ctr_tbl.DELETE;
3113: -- l_src_ctr_bl will be used when we re-calculate the later readings of this formula counter

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

3177: FETCH GET_NET_RDG_CUR INTO l_bind_var_value;
3178: CLOSE GET_NET_RDG_CUR;
3179: END IF;
3180: -- End Bug 9230940
3181: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));
3182: END LOOP; -- Sub Cursor
3183: --
3184: l_n_temp := dbms_sql.execute(l_cursor_handle);
3185: --Get the value

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

3180: -- End Bug 9230940
3181: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));
3182: END LOOP; -- Sub Cursor
3183: --
3184: l_n_temp := dbms_sql.execute(l_cursor_handle);
3185: --Get the value
3186: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3187: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
3188: ELSE

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

3182: END LOOP; -- Sub Cursor
3183: --
3184: l_n_temp := dbms_sql.execute(l_cursor_handle);
3185: --Get the value
3186: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3187: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
3188: ELSE
3189: l_counter_reading := 0;
3190: END IF;

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

3183: --
3184: l_n_temp := dbms_sql.execute(l_cursor_handle);
3185: --Get the value
3186: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3187: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
3188: ELSE
3189: l_counter_reading := 0;
3190: END IF;
3191: --Close cursor

Line 3192: DBMS_SQL.close_cursor(l_cursor_handle);

3188: ELSE
3189: l_counter_reading := 0;
3190: END IF;
3191: --Close cursor
3192: DBMS_SQL.close_cursor(l_cursor_handle);
3193: --
3194: -- If the source counter reading is not disabled then we update/insert the row for formula
3195: -- counter.
3196: --

Line 3396: l_cursor_handle := dbms_sql.open_cursor;

3392: -- Re-compute Later Formula Counter Readings
3393: -- For this Formula counter, pick up the readings later than passed timestamp and re-compute
3394: --
3395: FOR later_rec IN LATER_FORMULA_CUR(obj_cur.object_counter_id,p_ctr_rdg_rec.value_timestamp) LOOP
3396: l_cursor_handle := dbms_sql.open_cursor;
3397: -- Formula Text is reused from the above
3398: -- l_formula_text := 'SELECT '||l_formula_text||' FROM DUAL';
3399: --
3400: Begin

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

3397: -- Formula Text is reused from the above
3398: -- l_formula_text := 'SELECT '||l_formula_text||' FROM DUAL';
3399: --
3400: Begin
3401: DBMS_SQL.PARSE(l_cursor_handle, l_formula_text, dbms_sql.native);
3402: Exception
3403: when others then
3404: csi_ctr_gen_utility_pvt.ExitWithErrMsg
3405: ( p_msg_name => 'CSI_API_CTR_FORMULA_DEF_INV',

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

3407: p_token1_val => l_formula_text
3408: );
3409: End;
3410: --
3411: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);
3412: --
3413: -- Since we already have the list of Source counters for this Object (Formula) we are using it.
3414: IF l_src_ctr_tbl.count > 0 THEN
3415: FOR src_rec in l_src_ctr_tbl.FIRST .. l_src_ctr_tbl.LAST LOOP

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

3446: FETCH GET_NET_RDG_CUR INTO l_bind_var_value;
3447: CLOSE GET_NET_RDG_CUR;
3448: END IF;
3449: -- End Bug 9230940
3450: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));
3451: END LOOP;
3452: END IF;
3453: --
3454: l_n_temp := dbms_sql.execute(l_cursor_handle);

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

3450: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, nvl(l_bind_var_value,0));
3451: END LOOP;
3452: END IF;
3453: --
3454: l_n_temp := dbms_sql.execute(l_cursor_handle);
3455: --Get the value
3456: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3457: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
3458: -- Updating Formula Counter

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

3452: END IF;
3453: --
3454: l_n_temp := dbms_sql.execute(l_cursor_handle);
3455: --Get the value
3456: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3457: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
3458: -- Updating Formula Counter
3459: IF (l_debug_level > 0) THEN -- 8214848 - dsingire
3460: csi_ctr_gen_utility_pvt.put_line('Re-computing later formula Ctr Value ID '||to_char(later_rec.counter_value_id));

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

3453: --
3454: l_n_temp := dbms_sql.execute(l_cursor_handle);
3455: --Get the value
3456: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3457: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
3458: -- Updating Formula Counter
3459: IF (l_debug_level > 0) THEN -- 8214848 - dsingire
3460: csi_ctr_gen_utility_pvt.put_line('Re-computing later formula Ctr Value ID '||to_char(later_rec.counter_value_id));
3461: END IF; -- 8214848 - dsingire

Line 3473: DBMS_SQL.close_cursor(l_cursor_handle);

3469: ELSE
3470: l_counter_reading := 0;
3471: END IF;
3472: --Close cursor
3473: DBMS_SQL.close_cursor(l_cursor_handle);
3474: END LOOP; -- Later Formula Readings Loop
3475: Exception
3476: when Process_Next then
3477: null;

Line 3821: l_cursor_handle := dbms_sql.open_cursor;

3817: END LOOP;
3818: --
3819: if l_sqlwhere is null then
3820: l_sqlstr := l_sqlstr_init || ' where cv.counter_id = :x_derive_counter_id';
3821: l_cursor_handle := dbms_sql.open_cursor;
3822: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3823: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3824: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3825: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);

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

3818: --
3819: if l_sqlwhere is null then
3820: l_sqlstr := l_sqlstr_init || ' where cv.counter_id = :x_derive_counter_id';
3821: l_cursor_handle := dbms_sql.open_cursor;
3822: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3823: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3824: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3825: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3826: else

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

3819: if l_sqlwhere is null then
3820: l_sqlstr := l_sqlstr_init || ' where cv.counter_id = :x_derive_counter_id';
3821: l_cursor_handle := dbms_sql.open_cursor;
3822: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3823: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3824: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3825: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3826: else
3827: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';

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

3821: l_cursor_handle := dbms_sql.open_cursor;
3822: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3823: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3824: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3825: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3826: else
3827: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
3828: l_cursor_handle := dbms_sql.open_cursor;
3829: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);

Line 3828: l_cursor_handle := dbms_sql.open_cursor;

3824: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3825: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3826: else
3827: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
3828: l_cursor_handle := dbms_sql.open_cursor;
3829: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3830: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3831:
3832: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;

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

3825: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3826: else
3827: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
3828: l_cursor_handle := dbms_sql.open_cursor;
3829: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3830: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3831:
3832: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3833: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);

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

3826: else
3827: l_sqlstr := l_sqlstr_init||l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
3828: l_cursor_handle := dbms_sql.open_cursor;
3829: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3830: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3831:
3832: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3833: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3834:

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

3829: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
3830: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
3831:
3832: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
3833: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
3834:
3835: while lj < i+1
3836: loop
3837: l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;

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

3835: while lj < i+1
3836: loop
3837: l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;
3838: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
3839: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
3840: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
3841: l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
3842: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
3843: lj:= lj+1;

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

3838: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
3839: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
3840: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
3841: l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
3842: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
3843: lj:= lj+1;
3844: end loop;
3845: end if;
3846: --

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

3846: --
3847: IF (l_debug_level > 0) THEN -- 8214848 - dsingire
3848: csi_ctr_gen_utility_pvt.put_line('SQL String is '||l_sqlstr);
3849: END IF; -- 8214848 - dsingire
3850: l_n_temp := dbms_sql.execute(l_cursor_handle);
3851: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3852: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
3853: END IF;
3854: DBMS_SQL.close_cursor(l_cursor_handle);

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

3847: IF (l_debug_level > 0) THEN -- 8214848 - dsingire
3848: csi_ctr_gen_utility_pvt.put_line('SQL String is '||l_sqlstr);
3849: END IF; -- 8214848 - dsingire
3850: l_n_temp := dbms_sql.execute(l_cursor_handle);
3851: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3852: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
3853: END IF;
3854: DBMS_SQL.close_cursor(l_cursor_handle);
3855: END IF;

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

3848: csi_ctr_gen_utility_pvt.put_line('SQL String is '||l_sqlstr);
3849: END IF; -- 8214848 - dsingire
3850: l_n_temp := dbms_sql.execute(l_cursor_handle);
3851: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3852: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
3853: END IF;
3854: DBMS_SQL.close_cursor(l_cursor_handle);
3855: END IF;
3856: --

Line 3854: DBMS_SQL.close_cursor(l_cursor_handle);

3850: l_n_temp := dbms_sql.execute(l_cursor_handle);
3851: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
3852: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
3853: END IF;
3854: DBMS_SQL.close_cursor(l_cursor_handle);
3855: END IF;
3856: --
3857: -- Capture Reading
3858: IF l_ctr_value IS NOT NULL THEN

Line 4016: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN

4012: FND_MSG_PUB.Count_And_Get
4013: ( p_count => x_msg_count,
4014: p_data => x_msg_data
4015: );
4016: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
4017: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
4018: END IF;
4019: END Compute_Derive_Counters;
4020: --

Line 4017: DBMS_SQL.CLOSE_cursor(l_cursor_handle);

4013: ( p_count => x_msg_count,
4014: p_data => x_msg_data
4015: );
4016: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
4017: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
4018: END IF;
4019: END Compute_Derive_Counters;
4020: --
4021: PROCEDURE Compute_Target_Counters