DBA Data[Home] [Help]

APPS.ORACLEAPPS dependencies on DBMS_SQL

Line 2852: c_call := dbms_sql.open_cursor;

2848: end loop;
2849: c_procedure_call := c_procedure_call||')';
2850: end if;
2851:
2852: c_call := dbms_sql.open_cursor;
2853: dbms_sql.parse(c_call,'begin '||c_procedure_call||'; end;',dbms_sql.native);
2854: c_dummy := dbms_sql.execute(c_call);
2855: dbms_sql.close_cursor(c_call);
2856:

Line 2853: dbms_sql.parse(c_call,'begin '||c_procedure_call||'; end;',dbms_sql.native);

2849: c_procedure_call := c_procedure_call||')';
2850: end if;
2851:
2852: c_call := dbms_sql.open_cursor;
2853: dbms_sql.parse(c_call,'begin '||c_procedure_call||'; end;',dbms_sql.native);
2854: c_dummy := dbms_sql.execute(c_call);
2855: dbms_sql.close_cursor(c_call);
2856:
2857: else

Line 2854: c_dummy := dbms_sql.execute(c_call);

2850: end if;
2851:
2852: c_call := dbms_sql.open_cursor;
2853: dbms_sql.parse(c_call,'begin '||c_procedure_call||'; end;',dbms_sql.native);
2854: c_dummy := dbms_sql.execute(c_call);
2855: dbms_sql.close_cursor(c_call);
2856:
2857: else
2858: fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');

Line 2855: dbms_sql.close_cursor(c_call);

2851:
2852: c_call := dbms_sql.open_cursor;
2853: dbms_sql.parse(c_call,'begin '||c_procedure_call||'; end;',dbms_sql.native);
2854: c_dummy := dbms_sql.execute(c_call);
2855: dbms_sql.close_cursor(c_call);
2856:
2857: else
2858: fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2859: c_error_msg := fnd_message.get;