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.XLA_ANALYTICAL_CRITERIA_PKG dependencies on DBMS_SQL

Line 4405: l_statement DBMS_SQL.VARCHAR2S;

4401: ;
4402: --FOR UPDATE NOWAIT;
4403:
4404:
4405: l_statement DBMS_SQL.VARCHAR2S;
4406: --l_hdr_statement DBMS_SQL.VARCHAR2S;
4407: l_rep_ln_statement DBMS_SQL.VARCHAR2S;
4408: l_rep_hdr_statement DBMS_SQL.VARCHAR2S;
4409: l_cursor_handle NUMBER;

Line 4406: --l_hdr_statement DBMS_SQL.VARCHAR2S;

4402: --FOR UPDATE NOWAIT;
4403:
4404:
4405: l_statement DBMS_SQL.VARCHAR2S;
4406: --l_hdr_statement DBMS_SQL.VARCHAR2S;
4407: l_rep_ln_statement DBMS_SQL.VARCHAR2S;
4408: l_rep_hdr_statement DBMS_SQL.VARCHAR2S;
4409: l_cursor_handle NUMBER;
4410: l_view_column_number INTEGER;

Line 4407: l_rep_ln_statement DBMS_SQL.VARCHAR2S;

4403:
4404:
4405: l_statement DBMS_SQL.VARCHAR2S;
4406: --l_hdr_statement DBMS_SQL.VARCHAR2S;
4407: l_rep_ln_statement DBMS_SQL.VARCHAR2S;
4408: l_rep_hdr_statement DBMS_SQL.VARCHAR2S;
4409: l_cursor_handle NUMBER;
4410: l_view_column_number INTEGER;
4411:

Line 4408: l_rep_hdr_statement DBMS_SQL.VARCHAR2S;

4404:
4405: l_statement DBMS_SQL.VARCHAR2S;
4406: --l_hdr_statement DBMS_SQL.VARCHAR2S;
4407: l_rep_ln_statement DBMS_SQL.VARCHAR2S;
4408: l_rep_hdr_statement DBMS_SQL.VARCHAR2S;
4409: l_cursor_handle NUMBER;
4410: l_view_column_number INTEGER;
4411:
4412: l_current_anacri_code VARCHAR2(30);

Line 4854: l_cursor_handle:= dbms_sql.open_cursor;

4850: */
4851: /*
4852: END IF;
4853:
4854: l_cursor_handle:= dbms_sql.open_cursor;
4855: --parse the statement
4856: dbms_sql.parse (
4857: c => l_cursor_handle
4858: ,statement => l_statement

Line 4856: dbms_sql.parse (

4852: END IF;
4853:
4854: l_cursor_handle:= dbms_sql.open_cursor;
4855: --parse the statement
4856: dbms_sql.parse (
4857: c => l_cursor_handle
4858: ,statement => l_statement
4859: ,lb => 1
4860: ,ub => l_statement.LAST

Line 4862: ,language_flag => DBMS_SQL.NATIVE);

4858: ,statement => l_statement
4859: ,lb => 1
4860: ,ub => l_statement.LAST
4861: ,lfflg => TRUE --line feed
4862: ,language_flag => DBMS_SQL.NATIVE);
4863: dbms_sql.close_cursor(l_cursor_handle);
4864:
4865: l_cursor_handle:= dbms_sql.open_cursor;
4866: --parse the statement

Line 4863: dbms_sql.close_cursor(l_cursor_handle);

4859: ,lb => 1
4860: ,ub => l_statement.LAST
4861: ,lfflg => TRUE --line feed
4862: ,language_flag => DBMS_SQL.NATIVE);
4863: dbms_sql.close_cursor(l_cursor_handle);
4864:
4865: l_cursor_handle:= dbms_sql.open_cursor;
4866: --parse the statement
4867: dbms_sql.parse (

Line 4865: l_cursor_handle:= dbms_sql.open_cursor;

4861: ,lfflg => TRUE --line feed
4862: ,language_flag => DBMS_SQL.NATIVE);
4863: dbms_sql.close_cursor(l_cursor_handle);
4864:
4865: l_cursor_handle:= dbms_sql.open_cursor;
4866: --parse the statement
4867: dbms_sql.parse (
4868: c => l_cursor_handle
4869: ,statement => l_rep_ln_statement

Line 4867: dbms_sql.parse (

4863: dbms_sql.close_cursor(l_cursor_handle);
4864:
4865: l_cursor_handle:= dbms_sql.open_cursor;
4866: --parse the statement
4867: dbms_sql.parse (
4868: c => l_cursor_handle
4869: ,statement => l_rep_ln_statement
4870: ,lb => 1
4871: ,ub => l_rep_ln_statement.LAST

Line 4873: ,language_flag => DBMS_SQL.NATIVE);

4869: ,statement => l_rep_ln_statement
4870: ,lb => 1
4871: ,ub => l_rep_ln_statement.LAST
4872: ,lfflg => TRUE --line feed
4873: ,language_flag => DBMS_SQL.NATIVE);
4874: dbms_sql.close_cursor(l_cursor_handle);
4875:
4876: l_cursor_handle:= dbms_sql.open_cursor;
4877: l_cursor_handle:= dbms_sql.open_cursor;

Line 4874: dbms_sql.close_cursor(l_cursor_handle);

4870: ,lb => 1
4871: ,ub => l_rep_ln_statement.LAST
4872: ,lfflg => TRUE --line feed
4873: ,language_flag => DBMS_SQL.NATIVE);
4874: dbms_sql.close_cursor(l_cursor_handle);
4875:
4876: l_cursor_handle:= dbms_sql.open_cursor;
4877: l_cursor_handle:= dbms_sql.open_cursor;
4878: --parse the statement

Line 4876: l_cursor_handle:= dbms_sql.open_cursor;

4872: ,lfflg => TRUE --line feed
4873: ,language_flag => DBMS_SQL.NATIVE);
4874: dbms_sql.close_cursor(l_cursor_handle);
4875:
4876: l_cursor_handle:= dbms_sql.open_cursor;
4877: l_cursor_handle:= dbms_sql.open_cursor;
4878: --parse the statement
4879: dbms_sql.parse (
4880: c => l_cursor_handle

Line 4877: l_cursor_handle:= dbms_sql.open_cursor;

4873: ,language_flag => DBMS_SQL.NATIVE);
4874: dbms_sql.close_cursor(l_cursor_handle);
4875:
4876: l_cursor_handle:= dbms_sql.open_cursor;
4877: l_cursor_handle:= dbms_sql.open_cursor;
4878: --parse the statement
4879: dbms_sql.parse (
4880: c => l_cursor_handle
4881: ,statement => l_rep_hdr_statement

Line 4879: dbms_sql.parse (

4875:
4876: l_cursor_handle:= dbms_sql.open_cursor;
4877: l_cursor_handle:= dbms_sql.open_cursor;
4878: --parse the statement
4879: dbms_sql.parse (
4880: c => l_cursor_handle
4881: ,statement => l_rep_hdr_statement
4882: ,lb => 1
4883: ,ub => l_rep_hdr_statement.LAST

Line 4885: ,language_flag => DBMS_SQL.NATIVE);

4881: ,statement => l_rep_hdr_statement
4882: ,lb => 1
4883: ,ub => l_rep_hdr_statement.LAST
4884: ,lfflg => TRUE --line feed
4885: ,language_flag => DBMS_SQL.NATIVE);
4886: dbms_sql.close_cursor(l_cursor_handle);
4887:
4888: /*
4889: l_cursor_handle:= dbms_sql.open_cursor;

Line 4886: dbms_sql.close_cursor(l_cursor_handle);

4882: ,lb => 1
4883: ,ub => l_rep_hdr_statement.LAST
4884: ,lfflg => TRUE --line feed
4885: ,language_flag => DBMS_SQL.NATIVE);
4886: dbms_sql.close_cursor(l_cursor_handle);
4887:
4888: /*
4889: l_cursor_handle:= dbms_sql.open_cursor;
4890: --parse the statement

Line 4889: l_cursor_handle:= dbms_sql.open_cursor;

4885: ,language_flag => DBMS_SQL.NATIVE);
4886: dbms_sql.close_cursor(l_cursor_handle);
4887:
4888: /*
4889: l_cursor_handle:= dbms_sql.open_cursor;
4890: --parse the statement
4891: dbms_sql.parse (
4892: c => l_cursor_handle
4893: ,statement => l_hdr_statement

Line 4891: dbms_sql.parse (

4887:
4888: /*
4889: l_cursor_handle:= dbms_sql.open_cursor;
4890: --parse the statement
4891: dbms_sql.parse (
4892: c => l_cursor_handle
4893: ,statement => l_hdr_statement
4894: ,lb => 1
4895: ,ub => l_hdr_statement.LAST

Line 4897: ,language_flag => DBMS_SQL.NATIVE);

4893: ,statement => l_hdr_statement
4894: ,lb => 1
4895: ,ub => l_hdr_statement.LAST
4896: ,lfflg => TRUE --line feed
4897: ,language_flag => DBMS_SQL.NATIVE);
4898: dbms_sql.close_cursor(l_cursor_handle);
4899: */
4900: /* END IF;
4901:

Line 4898: dbms_sql.close_cursor(l_cursor_handle);

4894: ,lb => 1
4895: ,ub => l_hdr_statement.LAST
4896: ,lfflg => TRUE --line feed
4897: ,language_flag => DBMS_SQL.NATIVE);
4898: dbms_sql.close_cursor(l_cursor_handle);
4899: */
4900: /* END IF;
4901:
4902: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN