eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_RECON_REP dependencies on DBMS_SQL

Line 929: l_xml_build DBMS_SQL.VARCHAR2A;

925: /* Changes for bug 10177944 */
926: l_nls_numeric_char VARCHAR2(5);
927: l_nls_altered BOOLEAN;
928: l_alter_str VARCHAR2(100);
929: l_xml_build DBMS_SQL.VARCHAR2A;
930: l_xml_build_sql VARCHAR2(32767);
931: l_cur_id INTEGER;
932: TYPE ref_cur2 IS REF CURSOR;
933: l_xml_ref ref_cur2;

Line 1940: /* DBMS_SQL.TO_REFCURSOR is a feature of 11G database so there will be a compilation error for the customers in 10G to overcome it we have used execute immediate to serve the purpose */

1936: l_alter_str:= NULL;
1937: END IF;
1938: --OPEN l_xml_ref FOR l_xml_query;
1939:
1940: /* DBMS_SQL.TO_REFCURSOR is a feature of 11G database so there will be a compilation error for the customers in 10G to overcome it we have used execute immediate to serve the purpose */
1941:
1942: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
1943: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
1944: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

Line 1943: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);

1939:
1940: /* DBMS_SQL.TO_REFCURSOR is a feature of 11G database so there will be a compilation error for the customers in 10G to overcome it we have used execute immediate to serve the purpose */
1941:
1942: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
1943: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
1944: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1945: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';
1946: execute immediate l_dyn_block using in l_xml_query,out l_result,out l_rows_processed;
1947:

Line 2148: l_xml_build DBMS_SQL.VARCHAR2A;

2144: /* Changes for bug 10177944 */
2145: l_nls_numeric_char VARCHAR2(5);
2146: l_nls_altered BOOLEAN;
2147: l_alter_str VARCHAR2(100);
2148: l_xml_build DBMS_SQL.VARCHAR2A;
2149: l_xml_build_sql VARCHAR2(32767);
2150: l_cur_id INTEGER;
2151: TYPE l_xml_ref_cur IS REF CURSOR;
2152: l_xml_ref l_xml_ref_cur;

Line 3050: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);

3046: l_alter_str:= NULL;
3047: END IF;
3048: --OPEN l_xml_ref FOR l_xml_query;
3049: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
3050: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
3051: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3052: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';
3053: execute immediate l_dyn_block using in l_xml_query,out l_result,out l_rows_processed;
3054:

Line 3718: l_insert_stmt DBMS_SQL.VARCHAR2A;

3714: l_nls_altered BOOLEAN;
3715: l_alter_str VARCHAR2(100);
3716:
3717: l_temp_stmt VARCHAR2(32767);
3718: l_insert_stmt DBMS_SQL.VARCHAR2A;
3719: l_cursor_id NUMBER;
3720: ret INTEGER;
3721: l_increment NUMBER := 0;
3722: BEGIN

Line 4658: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

4654:
4655: l_increment := l_increment+1;
4656: l_insert_stmt(l_increment):= l_temp_stmt;
4657:
4658: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
4659:
4660: DBMS_SQL.PARSE(l_cursor_id, l_insert_stmt,1,l_insert_stmt.last,FALSE, DBMS_SQL.NATIVE);
4661:
4662: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_from', l_gl_date_from);

Line 4660: DBMS_SQL.PARSE(l_cursor_id, l_insert_stmt,1,l_insert_stmt.last,FALSE, DBMS_SQL.NATIVE);

4656: l_insert_stmt(l_increment):= l_temp_stmt;
4657:
4658: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
4659:
4660: DBMS_SQL.PARSE(l_cursor_id, l_insert_stmt,1,l_insert_stmt.last,FALSE, DBMS_SQL.NATIVE);
4661:
4662: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_from', l_gl_date_from);
4663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_to', l_gl_date_to);
4664: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'reporting_entity_id', p_reporting_entity_id);

Line 4662: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_from', l_gl_date_from);

4658: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
4659:
4660: DBMS_SQL.PARSE(l_cursor_id, l_insert_stmt,1,l_insert_stmt.last,FALSE, DBMS_SQL.NATIVE);
4661:
4662: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_from', l_gl_date_from);
4663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_to', l_gl_date_to);
4664: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'reporting_entity_id', p_reporting_entity_id);
4665:
4666: ret := DBMS_SQL.EXECUTE(l_cursor_id);

Line 4663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_to', l_gl_date_to);

4659:
4660: DBMS_SQL.PARSE(l_cursor_id, l_insert_stmt,1,l_insert_stmt.last,FALSE, DBMS_SQL.NATIVE);
4661:
4662: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_from', l_gl_date_from);
4663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_to', l_gl_date_to);
4664: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'reporting_entity_id', p_reporting_entity_id);
4665:
4666: ret := DBMS_SQL.EXECUTE(l_cursor_id);
4667: /* USING

Line 4664: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'reporting_entity_id', p_reporting_entity_id);

4660: DBMS_SQL.PARSE(l_cursor_id, l_insert_stmt,1,l_insert_stmt.last,FALSE, DBMS_SQL.NATIVE);
4661:
4662: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_from', l_gl_date_from);
4663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_to', l_gl_date_to);
4664: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'reporting_entity_id', p_reporting_entity_id);
4665:
4666: ret := DBMS_SQL.EXECUTE(l_cursor_id);
4667: /* USING
4668: l_gl_date_from, l_gl_date_to, p_reporting_entity_id,

Line 4666: ret := DBMS_SQL.EXECUTE(l_cursor_id);

4662: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_from', l_gl_date_from);
4663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'gl_date_to', l_gl_date_to);
4664: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'reporting_entity_id', p_reporting_entity_id);
4665:
4666: ret := DBMS_SQL.EXECUTE(l_cursor_id);
4667: /* USING
4668: l_gl_date_from, l_gl_date_to, p_reporting_entity_id,
4669: l_gl_date_from, l_gl_date_to,
4670: l_gl_date_from, l_gl_date_to,