DBA Data[Home] [Help]

APPS.FND_GLOBAL dependencies on DBMS_SQL

Line 2484: curs := dbms_sql.open_cursor;

2480: put(FND_CONST.FND_INIT_SQL,sqlbuf);
2481: end if;
2482:
2483: -- FND_INIT_SQL needs to execute for each initialization
2484: curs := dbms_sql.open_cursor;
2485: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);
2486: rows := dbms_sql.execute(curs);
2487: dbms_sql.close_cursor(curs);
2488: end if;

Line 2485: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);

2481: end if;
2482:
2483: -- FND_INIT_SQL needs to execute for each initialization
2484: curs := dbms_sql.open_cursor;
2485: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);
2486: rows := dbms_sql.execute(curs);
2487: dbms_sql.close_cursor(curs);
2488: end if;
2489:

Line 2486: rows := dbms_sql.execute(curs);

2482:
2483: -- FND_INIT_SQL needs to execute for each initialization
2484: curs := dbms_sql.open_cursor;
2485: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);
2486: rows := dbms_sql.execute(curs);
2487: dbms_sql.close_cursor(curs);
2488: end if;
2489:
2490: -- Set flag to indicate that the code is exiting this code block.

Line 2487: dbms_sql.close_cursor(curs);

2483: -- FND_INIT_SQL needs to execute for each initialization
2484: curs := dbms_sql.open_cursor;
2485: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);
2486: rows := dbms_sql.execute(curs);
2487: dbms_sql.close_cursor(curs);
2488: end if;
2489:
2490: -- Set flag to indicate that the code is exiting this code block.
2491: in_fnd_init_sql := FALSE;

Line 2503: if (dbms_sql.is_open(curs)) then

2499: end if; -- in_fnd_init_sql
2500: exception
2501: when others then
2502: -- Just in case...
2503: if (dbms_sql.is_open(curs)) then
2504: dbms_sql.close_cursor(curs);
2505: end if;
2506: in_fnd_init_sql := FALSE;
2507: throw('fnd_global.initialize[fnd_init_sql]',

Line 2504: dbms_sql.close_cursor(curs);

2500: exception
2501: when others then
2502: -- Just in case...
2503: if (dbms_sql.is_open(curs)) then
2504: dbms_sql.close_cursor(curs);
2505: end if;
2506: in_fnd_init_sql := FALSE;
2507: throw('fnd_global.initialize[fnd_init_sql]',
2508: sqlcode, dbms_utility.format_error_stack);