APPS.OEONUM dependencies on DBMS_SQL

Line 124: cid := dbms_sql.open_cursor;

120: ' INCREMENT BY 1 ' ||
121: 'NOCYCLE ' ||
122: 'ORDER';
123:
124: cid := dbms_sql.open_cursor;
125:
126: dbms_sql.parse(cid,
127: sql_buffer,
128: dbms_sql.v7);

Line 126: dbms_sql.parse(cid,

122: 'ORDER';
123:
124: cid := dbms_sql.open_cursor;
125:
126: dbms_sql.parse(cid,
127: sql_buffer,
128: dbms_sql.v7);
129:
130: dbms_sql.close_cursor(cid);

Line 128: dbms_sql.v7);

124: cid := dbms_sql.open_cursor;
125:
126: dbms_sql.parse(cid,
127: sql_buffer,
128: dbms_sql.v7);
129:
130: dbms_sql.close_cursor(cid);
131:
132: return_status := 0;

Line 130: dbms_sql.close_cursor(cid);

126: dbms_sql.parse(cid,
127: sql_buffer,
128: dbms_sql.v7);
129:
130: dbms_sql.close_cursor(cid);
131:
132: return_status := 0;
133: else /* oexoenum found */
134:

Line 143: cid := dbms_sql.open_cursor;

139: 'min_value => :min_value, ' ||
140: 'start_with => :start_with );' ||
141: 'END;';
142:
143: cid := dbms_sql.open_cursor;
144: dbms_sql.parse(cid,
145: sql_buffer,
146: dbms_sql.v7);
147:

Line 144: dbms_sql.parse(cid,

140: 'start_with => :start_with );' ||
141: 'END;';
142:
143: cid := dbms_sql.open_cursor;
144: dbms_sql.parse(cid,
145: sql_buffer,
146: dbms_sql.v7);
147:
148: dbms_sql.bind_variable(cid,':sequence_name',sequence_name);

Line 146: dbms_sql.v7);

142:
143: cid := dbms_sql.open_cursor;
144: dbms_sql.parse(cid,
145: sql_buffer,
146: dbms_sql.v7);
147:
148: dbms_sql.bind_variable(cid,':sequence_name',sequence_name);
149: dbms_sql.bind_variable(cid,':cache',cache);
150: dbms_sql.bind_variable(cid,':min_value',min_value);

Line 148: dbms_sql.bind_variable(cid,':sequence_name',sequence_name);

144: dbms_sql.parse(cid,
145: sql_buffer,
146: dbms_sql.v7);
147:
148: dbms_sql.bind_variable(cid,':sequence_name',sequence_name);
149: dbms_sql.bind_variable(cid,':cache',cache);
150: dbms_sql.bind_variable(cid,':min_value',min_value);
151: dbms_sql.bind_variable(cid,':start_with',start_with);
152:

Line 149: dbms_sql.bind_variable(cid,':cache',cache);

145: sql_buffer,
146: dbms_sql.v7);
147:
148: dbms_sql.bind_variable(cid,':sequence_name',sequence_name);
149: dbms_sql.bind_variable(cid,':cache',cache);
150: dbms_sql.bind_variable(cid,':min_value',min_value);
151: dbms_sql.bind_variable(cid,':start_with',start_with);
152:
153: package_result := dbms_sql.execute(cid);

Line 150: dbms_sql.bind_variable(cid,':min_value',min_value);

146: dbms_sql.v7);
147:
148: dbms_sql.bind_variable(cid,':sequence_name',sequence_name);
149: dbms_sql.bind_variable(cid,':cache',cache);
150: dbms_sql.bind_variable(cid,':min_value',min_value);
151: dbms_sql.bind_variable(cid,':start_with',start_with);
152:
153: package_result := dbms_sql.execute(cid);
154:

Line 151: dbms_sql.bind_variable(cid,':start_with',start_with);

147:
148: dbms_sql.bind_variable(cid,':sequence_name',sequence_name);
149: dbms_sql.bind_variable(cid,':cache',cache);
150: dbms_sql.bind_variable(cid,':min_value',min_value);
151: dbms_sql.bind_variable(cid,':start_with',start_with);
152:
153: package_result := dbms_sql.execute(cid);
154:
155: dbms_sql.close_cursor(cid);

Line 153: package_result := dbms_sql.execute(cid);

149: dbms_sql.bind_variable(cid,':cache',cache);
150: dbms_sql.bind_variable(cid,':min_value',min_value);
151: dbms_sql.bind_variable(cid,':start_with',start_with);
152:
153: package_result := dbms_sql.execute(cid);
154:
155: dbms_sql.close_cursor(cid);
156:
157: return_status := 0;

Line 155: dbms_sql.close_cursor(cid);

151: dbms_sql.bind_variable(cid,':start_with',start_with);
152:
153: package_result := dbms_sql.execute(cid);
154:
155: dbms_sql.close_cursor(cid);
156:
157: return_status := 0;
158:
159: end if; /* not oexoenum_found */

Line 219: cid := dbms_sql.open_cursor;

215: '); ' ||
216: 'END;';
217: end if;
218:
219: cid := dbms_sql.open_cursor;
220: dbms_sql.parse(cid,
221: sql_buffer,
222: dbms_sql.v7);
223:

Line 220: dbms_sql.parse(cid,

216: 'END;';
217: end if;
218:
219: cid := dbms_sql.open_cursor;
220: dbms_sql.parse(cid,
221: sql_buffer,
222: dbms_sql.v7);
223:
224: package_result := dbms_sql.execute(cid);

Line 222: dbms_sql.v7);

218:
219: cid := dbms_sql.open_cursor;
220: dbms_sql.parse(cid,
221: sql_buffer,
222: dbms_sql.v7);
223:
224: package_result := dbms_sql.execute(cid);
225:
226: dbms_sql.close_cursor(cid);

Line 224: package_result := dbms_sql.execute(cid);

220: dbms_sql.parse(cid,
221: sql_buffer,
222: dbms_sql.v7);
223:
224: package_result := dbms_sql.execute(cid);
225:
226: dbms_sql.close_cursor(cid);
227:
228: return_status := 0;

Line 226: dbms_sql.close_cursor(cid);

222: dbms_sql.v7);
223:
224: package_result := dbms_sql.execute(cid);
225:
226: dbms_sql.close_cursor(cid);
227:
228: return_status := 0;
229:
230:

Line 237: if dbms_sql.is_open(cid) then

233:
234: EXCEPTION
235:
236: WHEN OTHERS THEN
237: if dbms_sql.is_open(cid) then
238: dbms_sql.close_cursor(cid);
239: end if;
240: return_status := -1;
241: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',

Line 238: dbms_sql.close_cursor(cid);

234: EXCEPTION
235:
236: WHEN OTHERS THEN
237: if dbms_sql.is_open(cid) then
238: dbms_sql.close_cursor(cid);
239: end if;
240: return_status := -1;
241: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',
242: Operation=>'Create Source',

Line 269: cid := dbms_sql.open_cursor;

265: sql_buffer := 'SELECT ' || sequence_name ||
266: '.NEXTVAL ' ||
267: ' FROM SYS.DUAL';
268:
269: cid := dbms_sql.open_cursor;
270:
271:
272: dbms_sql.parse(cid,
273: sql_buffer,

Line 272: dbms_sql.parse(cid,

268:
269: cid := dbms_sql.open_cursor;
270:
271:
272: dbms_sql.parse(cid,
273: sql_buffer,
274: dbms_sql.v7);
275:
276: dbms_sql.define_column(cid,1,sequence_number);

Line 274: dbms_sql.v7);

270:
271:
272: dbms_sql.parse(cid,
273: sql_buffer,
274: dbms_sql.v7);
275:
276: dbms_sql.define_column(cid,1,sequence_number);
277:
278: package_result := dbms_sql.execute(cid);

Line 276: dbms_sql.define_column(cid,1,sequence_number);

272: dbms_sql.parse(cid,
273: sql_buffer,
274: dbms_sql.v7);
275:
276: dbms_sql.define_column(cid,1,sequence_number);
277:
278: package_result := dbms_sql.execute(cid);
279:
280:

Line 278: package_result := dbms_sql.execute(cid);

274: dbms_sql.v7);
275:
276: dbms_sql.define_column(cid,1,sequence_number);
277:
278: package_result := dbms_sql.execute(cid);
279:
280:
281: if dbms_sql.fetch_rows(cid) > 0 then
282: dbms_sql.column_value(cid,1,sequence_number);

Line 281: if dbms_sql.fetch_rows(cid) > 0 then

277:
278: package_result := dbms_sql.execute(cid);
279:
280:
281: if dbms_sql.fetch_rows(cid) > 0 then
282: dbms_sql.column_value(cid,1,sequence_number);
283: else
284: dbms_sql.close_cursor(cid);
285: return_status := -1;

Line 282: dbms_sql.column_value(cid,1,sequence_number);

278: package_result := dbms_sql.execute(cid);
279:
280:
281: if dbms_sql.fetch_rows(cid) > 0 then
282: dbms_sql.column_value(cid,1,sequence_number);
283: else
284: dbms_sql.close_cursor(cid);
285: return_status := -1;
286: OEONUM.Raise_Exception(Routine=>'OEONUM.GetNextNumber',

Line 284: dbms_sql.close_cursor(cid);

280:
281: if dbms_sql.fetch_rows(cid) > 0 then
282: dbms_sql.column_value(cid,1,sequence_number);
283: else
284: dbms_sql.close_cursor(cid);
285: return_status := -1;
286: OEONUM.Raise_Exception(Routine=>'OEONUM.GetNextNumber',
287: Operation=>'Get next number',
288: Message=>' Sql stmt 4');

Line 294: dbms_sql.close_cursor(cid);

290:
291: end if;
292:
293:
294: dbms_sql.close_cursor(cid);
295:
296: returned_sequence := sequence_number;
297:
298: return_status := 0;

Line 304: if dbms_sql.is_open(cid) then

300:
301: EXCEPTION
302:
303: WHEN OTHERS THEN
304: if dbms_sql.is_open(cid) then
305: dbms_sql.close_cursor(cid);
306: end if;
307: return_status := -1;
308: OEONUM.Raise_Exception(Routine=>'OEONUM.GetNextNumber',

Line 305: dbms_sql.close_cursor(cid);

301: EXCEPTION
302:
303: WHEN OTHERS THEN
304: if dbms_sql.is_open(cid) then
305: dbms_sql.close_cursor(cid);
306: end if;
307: return_status := -1;
308: OEONUM.Raise_Exception(Routine=>'OEONUM.GetNextNumber',
309: Operation=>'Get next number',