APPS.ICX_TEMPLATE_PARSER dependencies on DBMS_SQL

Line 398: l_dynamic_cursor := dbms_sql.open_cursor;

394: -- execute dynamic plsql call
395: l_dynamic_call := substr(l_dynamic_call,1,length(l_dynamic_call)-2);
396: if length(l_dynamic_call) > 0 then
397: begin
398: l_dynamic_cursor := dbms_sql.open_cursor;
399: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);
400: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);
401: dbms_sql.close_cursor(l_dynamic_cursor);
402: exception

Line 399: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);

395: l_dynamic_call := substr(l_dynamic_call,1,length(l_dynamic_call)-2);
396: if length(l_dynamic_call) > 0 then
397: begin
398: l_dynamic_cursor := dbms_sql.open_cursor;
399: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);
400: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);
401: dbms_sql.close_cursor(l_dynamic_cursor);
402: exception
403: when others then

Line 400: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);

396: if length(l_dynamic_call) > 0 then
397: begin
398: l_dynamic_cursor := dbms_sql.open_cursor;
399: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);
400: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);
401: dbms_sql.close_cursor(l_dynamic_cursor);
402: exception
403: when others then
404: htp.p('SQL being executed was: '||l_dynamic_call||'
');

Line 401: dbms_sql.close_cursor(l_dynamic_cursor);

397: begin
398: l_dynamic_cursor := dbms_sql.open_cursor;
399: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);
400: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);
401: dbms_sql.close_cursor(l_dynamic_cursor);
402: exception
403: when others then
404: htp.p('SQL being executed was: '||l_dynamic_call||'
');
405: htp.p(SQLERRM);

Line 452: l_dynamic_cursor := dbms_sql.open_cursor;

448: l_dynamic_call := l_dynamic_call||l_replace_text_table(replace_tab_num).replace_text;
449: l_dynamic_call := substr(l_dynamic_call,1,length(l_dynamic_call)-2);
450: if length(l_dynamic_call) > 0 then
451: begin
452: l_dynamic_cursor := dbms_sql.open_cursor;
453: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);
454: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);
455: dbms_sql.close_cursor(l_dynamic_cursor);
456: exception

Line 453: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);

449: l_dynamic_call := substr(l_dynamic_call,1,length(l_dynamic_call)-2);
450: if length(l_dynamic_call) > 0 then
451: begin
452: l_dynamic_cursor := dbms_sql.open_cursor;
453: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);
454: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);
455: dbms_sql.close_cursor(l_dynamic_cursor);
456: exception
457: when others then

Line 454: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);

450: if length(l_dynamic_call) > 0 then
451: begin
452: l_dynamic_cursor := dbms_sql.open_cursor;
453: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);
454: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);
455: dbms_sql.close_cursor(l_dynamic_cursor);
456: exception
457: when others then
458: htp.p('SQL being executed was: '||l_dynamic_call||'
');

Line 455: dbms_sql.close_cursor(l_dynamic_cursor);

451: begin
452: l_dynamic_cursor := dbms_sql.open_cursor;
453: dbms_sql.parse(l_dynamic_cursor, 'begin '||l_dynamic_call||'; end;', DBMS_SQL.native);
454: l_dynamic_rows := dbms_sql.execute(l_dynamic_cursor);
455: dbms_sql.close_cursor(l_dynamic_cursor);
456: exception
457: when others then
458: htp.p('SQL being executed was: '||l_dynamic_call||'
');
459: htp.p(SQLERRM);