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

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

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

976:
977: csi_ctr_gen_utility_pvt.put_line('l_sqlstr = '||l_sqlstr);
978:
979: l_cursor_handle := dbms_sql.open_cursor;
980: DBMS_SQL.PARSE(l_cursor_handle, l_sqlstr, dbms_sql.native);
981: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_ctr_value);
982:
983: BINDVAL_DERIVECTRID := ctrs.derive_counter_id;
984: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, ':x_derive_counter_id',BINDVAL_DERIVECTRID);

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

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

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

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

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

986: while lj < i+1
987: loop
988: l_bind_varname := t2(lj).BINDNAME_DEFVAL;
989: l_bind_varvalc := t2(lj).BINDVAL_DEFVAL;
990: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
991: l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;
992: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
993: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
994: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;

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

989: l_bind_varvalc := t2(lj).BINDVAL_DEFVAL;
990: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
991: l_bind_varname := t2(lj).BINDNAME_RIGHTVAL;
992: l_bind_varvalc := t2(lj).BINDVAL_RIGHTVAL;
993: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvalc);
994: l_bind_varname := t2(lj).BINDNAME_CTRPROPID;
995: l_bind_varvaln := t2(lj).BINDVAL_CTRPROPID;
996: DBMS_SQL.BIND_VARIABLE(l_cursor_handle, l_bind_varname, l_bind_varvaln);
997: lj:= lj+1;

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

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

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

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

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

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

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

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

Line 1004: DBMS_SQL.close_cursor(l_cursor_handle);

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

Line 1010: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN

1006: x_valid_flag := 'Y';
1007: END LOOP;
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
1011: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
1012: END IF;
1013: RAISE;
1014: END;

Line 1011: DBMS_SQL.CLOSE_cursor(l_cursor_handle);

1007: END LOOP;
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN
1011: DBMS_SQL.CLOSE_cursor(l_cursor_handle);
1012: END IF;
1013: RAISE;
1014: END;
1015: