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_CTR_GEN_UTILITY_PVT dependencies on DBMS_SQL

Line 705: l_cursor_handle := dbms_sql.open_cursor;

701: -- Debug Message
702: --Start Process
703: BEGIN
704: --Open the cursor
705: l_cursor_handle := dbms_sql.open_cursor;
706: l_formula := 'SELECT '||l_formula||' FROM DUAL';
707:
708: -- parse the formula using dual table
709: -- if formula is :a/2, in a sql statement it will become 'select :a/2 from dual'

Line 711: DBMS_SQL.PARSE(l_cursor_handle, l_formula, dbms_sql.native);

707:
708: -- parse the formula using dual table
709: -- if formula is :a/2, in a sql statement it will become 'select :a/2 from dual'
710:
711: DBMS_SQL.PARSE(l_cursor_handle, l_formula, dbms_sql.native);
712:
713: --define column to select value
714:
715: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);

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

711: DBMS_SQL.PARSE(l_cursor_handle, l_formula, dbms_sql.native);
712:
713: --define column to select value
714:
715: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_counter_reading);
716:
717: FOR bvars IN ctr_bvars LOOP
718: l_bind_var_value := 100;
719: l_bind_var_name := ':'||ltrim(bvars.bind_variable_name);

Line 720: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, l_bind_var_value);

716:
717: FOR bvars IN ctr_bvars LOOP
718: l_bind_var_value := 100;
719: l_bind_var_name := ':'||ltrim(bvars.bind_variable_name);
720: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, l_bind_var_value);
721: END LOOP bvars;
722:
723: l_n_temp := dbms_sql.execute(l_cursor_handle);
724:

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

719: l_bind_var_name := ':'||ltrim(bvars.bind_variable_name);
720: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_var_name, l_bind_var_value);
721: END LOOP bvars;
722:
723: l_n_temp := dbms_sql.execute(l_cursor_handle);
724:
725: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
726: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
727: x_valid_flag := 'Y';

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

721: END LOOP bvars;
722:
723: l_n_temp := dbms_sql.execute(l_cursor_handle);
724:
725: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
726: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
727: x_valid_flag := 'Y';
728: END IF;
729:

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

722:
723: l_n_temp := dbms_sql.execute(l_cursor_handle);
724:
725: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
726: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
727: x_valid_flag := 'Y';
728: END IF;
729:
730: DBMS_SQL.close_cursor(l_cursor_handle);

Line 730: DBMS_SQL.close_cursor(l_cursor_handle);

726: dbms_sql.column_value(l_cursor_handle,1,l_counter_reading);
727: x_valid_flag := 'Y';
728: END IF;
729:
730: DBMS_SQL.close_cursor(l_cursor_handle);
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
734: DBMS_SQL.CLOSE_cursor(l_cursor_handle);

Line 733: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN

729:
730: DBMS_SQL.close_cursor(l_cursor_handle);
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
734: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
735: END IF;
736:
737: if sqlcode <> -1008 then

Line 734: DBMS_SQL.CLOSE_cursor(l_cursor_handle);

730: DBMS_SQL.close_cursor(l_cursor_handle);
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
734: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
735: END IF;
736:
737: if sqlcode <> -1008 then
738: RAISE;

Line 983: l_cursor_handle := dbms_sql.open_cursor;

979: l_sqlstr := l_sqlstr || l_sqlfrom || ' where '||l_sqlwhere||')';
980:
981: csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);
982:
983: l_cursor_handle := dbms_sql.open_cursor;
984: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
985: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
986:
987: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;

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

980:
981: csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);
982:
983: l_cursor_handle := dbms_sql.open_cursor;
984: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
985: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
986:
987: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
988: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);

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

981: csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);
982:
983: l_cursor_handle := dbms_sql.open_cursor;
984: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
985: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
986:
987: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
988: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
989:

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

984: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
985: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
986:
987: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
988: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);
989:
990: while lj < i+1
991: loop
992: l_bind_varname := t2(lj).BINDNAME_DEFVAL;

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

990: while lj < i+1
991: loop
992: l_bind_varname := t2(lj).BINDNAME_DEFVAL;
993: l_bind_varvalc := t2(lj).BINDVAL_DEFVAL;
994: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
995: l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;
996: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
997: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
998: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;

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

993: l_bind_varvalc := t2(lj).BINDVAL_DEFVAL;
994: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
995: l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;
996: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
997: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
998: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
999: l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
1000: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
1001: lj:= lj+1;

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

996: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
997: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
998: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
999: l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
1000: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
1001: lj:= lj+1;
1002: end loop;
1003:
1004: /* l_n_temp := dbms_sql.execute(l_cursor_handle);

Line 1004: /* l_n_temp := dbms_sql.execute(l_cursor_handle);

1000: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
1001: lj:= lj+1;
1002: end loop;
1003:
1004: /* l_n_temp := dbms_sql.execute(l_cursor_handle);
1005: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
1006: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
1007: END IF;
1008: DBMS_SQL.close_cursor(l_cursor_handle);

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

1001: lj:= lj+1;
1002: end loop;
1003:
1004: /* l_n_temp := dbms_sql.execute(l_cursor_handle);
1005: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
1006: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
1007: END IF;
1008: DBMS_SQL.close_cursor(l_cursor_handle);
1009: */

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

1002: end loop;
1003:
1004: /* l_n_temp := dbms_sql.execute(l_cursor_handle);
1005: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
1006: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
1007: END IF;
1008: DBMS_SQL.close_cursor(l_cursor_handle);
1009: */
1010: x_valid_flag := 'Y';

Line 1008: DBMS_SQL.close_cursor(l_cursor_handle);

1004: /* l_n_temp := dbms_sql.execute(l_cursor_handle);
1005: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
1006: dbms_sql.column_value(l_cursor_handle,1,l_ctr_value);
1007: END IF;
1008: DBMS_SQL.close_cursor(l_cursor_handle);
1009: */
1010: x_valid_flag := 'Y';
1011: END LOOP;
1012: EXCEPTION

Line 1014: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN

1010: x_valid_flag := 'Y';
1011: END LOOP;
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
1015: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
1016: END IF;
1017: RAISE;
1018: END;

Line 1015: DBMS_SQL.CLOSE_cursor(l_cursor_handle);

1011: END LOOP;
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
1015: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
1016: END IF;
1017: RAISE;
1018: END;
1019: