DBA Data[Home] [Help]

APPS.QA_CORE_PKG dependencies on FND_DSQL

Line 346: -- Wrapper for fnd_dsql procedures.

342:
343:
344: -- Bug 4270911. CU2 SQL Literal fix.
345: -- Set of procedures to execute a dynamic sql from forms.
346: -- Wrapper for fnd_dsql procedures.
347: -- Use restricted to DDL.
348: -- srhariha. Mon Apr 18 06:11:06 PDT 2005.
349:
350: -- Simple Wrappers around fnd_dsql

Line 350: -- Simple Wrappers around fnd_dsql

346: -- Wrapper for fnd_dsql procedures.
347: -- Use restricted to DDL.
348: -- srhariha. Mon Apr 18 06:11:06 PDT 2005.
349:
350: -- Simple Wrappers around fnd_dsql
351:
352: PROCEDURE dsql_init IS
353:
354: BEGIN

Line 356: fnd_dsql.init;

352: PROCEDURE dsql_init IS
353:
354: BEGIN
355:
356: fnd_dsql.init;
357:
358: END dsql_init;
359:
360:

Line 366: fnd_dsql.add_text(p_text);

362: PROCEDURE dsql_add_text(p_text IN VARCHAR2) IS
363:
364: BEGIN
365:
366: fnd_dsql.add_text(p_text);
367: END dsql_add_text;
368:
369:
370: PROCEDURE dsql_add_bind(p_value IN VARCHAR2) IS

Line 374: fnd_dsql.add_bind(p_value);

370: PROCEDURE dsql_add_bind(p_value IN VARCHAR2) IS
371:
372: BEGIN
373:
374: fnd_dsql.add_bind(p_value);
375: END dsql_add_bind;
376:
377: PROCEDURE dsql_add_bind(p_value IN DATE) IS
378:

Line 381: fnd_dsql.add_bind(p_value);

377: PROCEDURE dsql_add_bind(p_value IN DATE) IS
378:
379: BEGIN
380:
381: fnd_dsql.add_bind(p_value);
382: END dsql_add_bind;
383:
384: PROCEDURE dsql_add_bind(p_value IN NUMBER) IS
385:

Line 388: fnd_dsql.add_bind(p_value);

384: PROCEDURE dsql_add_bind(p_value IN NUMBER) IS
385:
386: BEGIN
387:
388: fnd_dsql.add_bind(p_value);
389: END dsql_add_bind;
390:
391:
392:

Line 406: fnd_dsql.set_cursor(cursor_handle);

402: BEGIN
403:
404: cursor_handle := dbms_sql.open_cursor;
405:
406: fnd_dsql.set_cursor(cursor_handle);
407:
408: sql_text := fnd_dsql.get_text;
409:
410: -- qa_skiplot_utility.insert_error_log(p_module_name => 'cu2.qlttxn.100', p_error_message => sql_text);

Line 408: sql_text := fnd_dsql.get_text;

404: cursor_handle := dbms_sql.open_cursor;
405:
406: fnd_dsql.set_cursor(cursor_handle);
407:
408: sql_text := fnd_dsql.get_text;
409:
410: -- qa_skiplot_utility.insert_error_log(p_module_name => 'cu2.qlttxn.100', p_error_message => sql_text);
411:
412: dbms_sql.parse(cursor_handle,sql_text,dbms_sql.NATIVE);

Line 415: fnd_dsql.do_binds;

411:
412: dbms_sql.parse(cursor_handle,sql_text,dbms_sql.NATIVE);
413:
414: -- bind the variable
415: fnd_dsql.do_binds;
416:
417: ret_value := dbms_sql.execute(cursor_handle);
418:
419: dbms_sql.close_cursor(cursor_handle);