APPS.IEC_RECORD_FILTER_PVT dependencies on DBMS_SQL

Line 246: l_create_statement DBMS_SQL.VARCHAR2S;

242: ----------------------------------------------------------------
243: -- A table of VARCHAR2(256) that is used to build the record
244: -- filter query.
245: ----------------------------------------------------------------
246: l_create_statement DBMS_SQL.VARCHAR2S;
247:
248: ----------------------------------------------------------------
249: -- The identifier for the DBMS_SQL cursor that we are going to
250: -- use.

Line 249: -- The identifier for the DBMS_SQL cursor that we are going to

245: ----------------------------------------------------------------
246: l_create_statement DBMS_SQL.VARCHAR2S;
247:
248: ----------------------------------------------------------------
249: -- The identifier for the DBMS_SQL cursor that we are going to
250: -- use.
251: ----------------------------------------------------------------
252: l_work_cursor NUMBER;
253:

Line 300: l_work_cursor := DBMS_SQL.OPEN_CURSOR;

296: , l_create_statement
297: , l_status_code);
298:
299: IF l_status_code = FND_API.G_RET_STS_SUCCESS THEN
300: l_work_cursor := DBMS_SQL.OPEN_CURSOR;
301:
302: DBMS_SQL.PARSE( c => l_work_cursor
303: , statement => l_create_statement
304: , lb => 1

Line 302: DBMS_SQL.PARSE( c => l_work_cursor

298:
299: IF l_status_code = FND_API.G_RET_STS_SUCCESS THEN
300: l_work_cursor := DBMS_SQL.OPEN_CURSOR;
301:
302: DBMS_SQL.PARSE( c => l_work_cursor
303: , statement => l_create_statement
304: , lb => 1
305: , ub => l_create_statement.COUNT
306: , lfflg => FALSE

Line 307: , language_flag => DBMS_SQL.NATIVE);

303: , statement => l_create_statement
304: , lb => 1
305: , ub => l_create_statement.COUNT
306: , lfflg => FALSE
307: , language_flag => DBMS_SQL.NATIVE);
308:
309:
310: l_dummy := DBMS_SQL.EXECUTE(l_work_cursor);
311:

Line 310: l_dummy := DBMS_SQL.EXECUTE(l_work_cursor);

306: , lfflg => FALSE
307: , language_flag => DBMS_SQL.NATIVE);
308:
309:
310: l_dummy := DBMS_SQL.EXECUTE(l_work_cursor);
311:
312: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
313:
314: ELSIF l_status_code = 'N' THEN

Line 312: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);

308:
309:
310: l_dummy := DBMS_SQL.EXECUTE(l_work_cursor);
311:
312: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
313:
314: ELSIF l_status_code = 'N' THEN
315: Log( 'View creation for record filter ' || p_record_filter_id
316: , 'Create_RecordFilterView'

Line 317: , 'CREATE_VIEW_DBMS_SQL'

313:
314: ELSIF l_status_code = 'N' THEN
315: Log( 'View creation for record filter ' || p_record_filter_id
316: , 'Create_RecordFilterView'
317: , 'CREATE_VIEW_DBMS_SQL'
318: , NULL
319: , 'Error building record filter criteria WHERE clause.'
320: );
321:

Line 332: IF DBMS_SQL.IS_OPEN(l_work_cursor)

328: COMMIT;
329:
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: IF DBMS_SQL.IS_OPEN(l_work_cursor)
333: THEN
334: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
335: END IF;
336: ROLLBACK;

Line 334: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);

330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: IF DBMS_SQL.IS_OPEN(l_work_cursor)
333: THEN
334: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
335: END IF;
336: ROLLBACK;
337: X_RETURN_CODE := 'E';
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 339: IF DBMS_SQL.IS_OPEN(l_work_cursor)

335: END IF;
336: ROLLBACK;
337: X_RETURN_CODE := 'E';
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: IF DBMS_SQL.IS_OPEN(l_work_cursor)
340: THEN
341: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
342: END IF;
343: ROLLBACK;

Line 341: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);

337: X_RETURN_CODE := 'E';
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: IF DBMS_SQL.IS_OPEN(l_work_cursor)
340: THEN
341: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
342: END IF;
343: ROLLBACK;
344: X_RETURN_CODE := 'U';
345: WHEN OTHERS THEN

Line 346: IF DBMS_SQL.IS_OPEN(l_work_cursor)

342: END IF;
343: ROLLBACK;
344: X_RETURN_CODE := 'U';
345: WHEN OTHERS THEN
346: IF DBMS_SQL.IS_OPEN(l_work_cursor)
347: THEN
348: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
349: END IF;
350: ROLLBACK;

Line 348: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);

344: X_RETURN_CODE := 'U';
345: WHEN OTHERS THEN
346: IF DBMS_SQL.IS_OPEN(l_work_cursor)
347: THEN
348: DBMS_SQL.CLOSE_CURSOR(l_work_cursor);
349: END IF;
350: ROLLBACK;
351: X_RETURN_CODE := 'U';
352: