APPS.FND_GLOBAL dependencies on DBMS_SQL

Line 2213: curs := dbms_sql.open_cursor;

2209: put(FND_CONST.FND_INIT_SQL,sqlbuf);
2210: end if;
2211:
2212: -- FND_INIT_SQL needs to execute for each initialization
2213: curs := dbms_sql.open_cursor;
2214: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);
2215: rows := dbms_sql.execute(curs);
2216: dbms_sql.close_cursor(curs);
2217:

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

2210: end if;
2211:
2212: -- FND_INIT_SQL needs to execute for each initialization
2213: curs := dbms_sql.open_cursor;
2214: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);
2215: rows := dbms_sql.execute(curs);
2216: dbms_sql.close_cursor(curs);
2217:
2218: end if;

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

2211:
2212: -- FND_INIT_SQL needs to execute for each initialization
2213: curs := dbms_sql.open_cursor;
2214: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);
2215: rows := dbms_sql.execute(curs);
2216: dbms_sql.close_cursor(curs);
2217:
2218: end if;
2219: exception

Line 2216: dbms_sql.close_cursor(curs);

2212: -- FND_INIT_SQL needs to execute for each initialization
2213: curs := dbms_sql.open_cursor;
2214: dbms_sql.parse(curs, sqlbuf, dbms_sql.v7);
2215: rows := dbms_sql.execute(curs);
2216: dbms_sql.close_cursor(curs);
2217:
2218: end if;
2219: exception
2220: when others then

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

2218: end if;
2219: exception
2220: when others then
2221: -- Just in case...
2222: if (dbms_sql.is_open(curs)) then
2223: dbms_sql.close_cursor(curs);
2224: end if;
2225: throw('fnd_global.initialize[fnd_init_sql]',
2226: sqlcode, dbms_utility.format_error_stack);

Line 2223: dbms_sql.close_cursor(curs);

2219: exception
2220: when others then
2221: -- Just in case...
2222: if (dbms_sql.is_open(curs)) then
2223: dbms_sql.close_cursor(curs);
2224: end if;
2225: throw('fnd_global.initialize[fnd_init_sql]',
2226: sqlcode, dbms_utility.format_error_stack);
2227: end;