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.ASG_PUB_SEQUENCE_PKG dependencies on DBMS_SQL

Line 127: v_id := DBMS_SQL.OPEN_CURSOR;

123: ' where MOD(' || x_primary_key || ',' || v_max_users ||
124: ') = '|| x_client_number;
125:
126:
127: v_id := DBMS_SQL.OPEN_CURSOR;
128: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
129: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
130: dummy_num := DBMS_SQL.EXECUTE(v_id);
131: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then

Line 128: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);

124: ') = '|| x_client_number;
125:
126:
127: v_id := DBMS_SQL.OPEN_CURSOR;
128: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
129: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
130: dummy_num := DBMS_SQL.EXECUTE(v_id);
131: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
132: return -1;

Line 129: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);

125:
126:
127: v_id := DBMS_SQL.OPEN_CURSOR;
128: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
129: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
130: dummy_num := DBMS_SQL.EXECUTE(v_id);
131: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
132: return -1;
133: END if;

Line 130: dummy_num := DBMS_SQL.EXECUTE(v_id);

126:
127: v_id := DBMS_SQL.OPEN_CURSOR;
128: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
129: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
130: dummy_num := DBMS_SQL.EXECUTE(v_id);
131: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
132: return -1;
133: END if;
134: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);

Line 131: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then

127: v_id := DBMS_SQL.OPEN_CURSOR;
128: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
129: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
130: dummy_num := DBMS_SQL.EXECUTE(v_id);
131: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
132: return -1;
133: END if;
134: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);
135: DBMS_SQL.CLOSE_CURSOR(v_id);

Line 134: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);

130: dummy_num := DBMS_SQL.EXECUTE(v_id);
131: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
132: return -1;
133: END if;
134: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);
135: DBMS_SQL.CLOSE_CURSOR(v_id);
136: END IF;
137:
138: if(v_start > v_start_mobile) then

Line 135: DBMS_SQL.CLOSE_CURSOR(v_id);

131: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
132: return -1;
133: END if;
134: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);
135: DBMS_SQL.CLOSE_CURSOR(v_id);
136: END IF;
137:
138: if(v_start > v_start_mobile) then
139: v_minValue := v_start;