APPS.JTF_FM_INT_REQUEST_PKG dependencies on DBMS_SQL

Line 24: l_rec_tab DBMS_SQL.desc_tab;

20: l_length NUMBER;
21: l_no_of_chunks NUMBER;
22: l_cursor NUMBER;
23: l_col_cnt NUMBER;
24: l_rec_tab DBMS_SQL.desc_tab;
25: l_parser xmlparser.parser;
26: l_doc xmldom.domdocument;
27: nl xmldom.DOMNodeList;
28: len1 NUMBER;

Line 488: l_cursor := DBMS_SQL.OPEN_CURSOR;

484: l_buffer := utl_raw.cast_to_varchar2(var);
485:
486: l_fnd_query := LTRIM(RTRIM(l_buffer)) ;
487:
488: l_cursor := DBMS_SQL.OPEN_CURSOR;
489: DBMS_SQL.PARSE(l_cursor, l_buffer, DBMS_SQL.NATIVE);
490:
491: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
492:

Line 489: DBMS_SQL.PARSE(l_cursor, l_buffer, DBMS_SQL.NATIVE);

485:
486: l_fnd_query := LTRIM(RTRIM(l_buffer)) ;
487:
488: l_cursor := DBMS_SQL.OPEN_CURSOR;
489: DBMS_SQL.PARSE(l_cursor, l_buffer, DBMS_SQL.NATIVE);
490:
491: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
492:
493: FOR i IN l_col_cnt +1 .. 100

Line 491: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);

487:
488: l_cursor := DBMS_SQL.OPEN_CURSOR;
489: DBMS_SQL.PARSE(l_cursor, l_buffer, DBMS_SQL.NATIVE);
490:
491: DBMS_SQL.DESCRIBE_COLUMNS(l_cursor, l_col_cnt, l_rec_tab);
492:
493: FOR i IN l_col_cnt +1 .. 100
494: LOOP
495: l_rec_tab(i).col_name := '';

Line 897: --Explored using DBMS_SQL but the performance is compromised

893:
894:
895: --Execute immediate requires the bind variables individually mentioned in the USING part.
896: --Dynamic Statements cannot be used if the input count is not known.
897: --Explored using DBMS_SQL but the performance is compromised
898: --We have therefore limited the number of bind variables to 5 and mentioned each case individually
899: IF l_bind_value.COUNT = 0
900: THEN
901: EXECUTE IMMEDIATE l_insert_statement;