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

Line 596: -- we use dbms_sql rather than execute immediate

592: add_bin_column(p_column7) ||
593: add_bin_column(p_column8) ||
594: ') grp_id from dual';
595:
596: -- we use dbms_sql rather than execute immediate
597: -- as we don't know how many binds we need, dbms_sql
598: -- allows us to "bind by name"
599: l_cur_hdl := dbms_sql.open_cursor;
600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);

Line 597: -- as we don't know how many binds we need, dbms_sql

593: add_bin_column(p_column8) ||
594: ') grp_id from dual';
595:
596: -- we use dbms_sql rather than execute immediate
597: -- as we don't know how many binds we need, dbms_sql
598: -- allows us to "bind by name"
599: l_cur_hdl := dbms_sql.open_cursor;
600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);

Line 599: l_cur_hdl := dbms_sql.open_cursor;

595:
596: -- we use dbms_sql rather than execute immediate
597: -- as we don't know how many binds we need, dbms_sql
598: -- allows us to "bind by name"
599: l_cur_hdl := dbms_sql.open_cursor;
600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
602: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
603: l_grp_id := dbms_sql.execute(l_cur_hdl);

Line 600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);

596: -- we use dbms_sql rather than execute immediate
597: -- as we don't know how many binds we need, dbms_sql
598: -- allows us to "bind by name"
599: l_cur_hdl := dbms_sql.open_cursor;
600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
602: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
603: l_grp_id := dbms_sql.execute(l_cur_hdl);
604: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then

Line 601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);

597: -- as we don't know how many binds we need, dbms_sql
598: -- allows us to "bind by name"
599: l_cur_hdl := dbms_sql.open_cursor;
600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
602: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
603: l_grp_id := dbms_sql.execute(l_cur_hdl);
604: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
605: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);

Line 602: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);

598: -- allows us to "bind by name"
599: l_cur_hdl := dbms_sql.open_cursor;
600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
602: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
603: l_grp_id := dbms_sql.execute(l_cur_hdl);
604: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
605: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
606: end if;

Line 603: l_grp_id := dbms_sql.execute(l_cur_hdl);

599: l_cur_hdl := dbms_sql.open_cursor;
600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
602: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
603: l_grp_id := dbms_sql.execute(l_cur_hdl);
604: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
605: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
606: end if;
607: dbms_sql.close_cursor(l_cur_hdl);

Line 604: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then

600: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
602: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
603: l_grp_id := dbms_sql.execute(l_cur_hdl);
604: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
605: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
606: end if;
607: dbms_sql.close_cursor(l_cur_hdl);
608:

Line 605: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);

601: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
602: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
603: l_grp_id := dbms_sql.execute(l_cur_hdl);
604: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
605: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
606: end if;
607: dbms_sql.close_cursor(l_cur_hdl);
608:
609: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

Line 607: dbms_sql.close_cursor(l_cur_hdl);

603: l_grp_id := dbms_sql.execute(l_cur_hdl);
604: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
605: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
606: end if;
607: dbms_sql.close_cursor(l_cur_hdl);
608:
609: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
610:
611: l_custom_rec.attribute_name := '&ISC_GRP_ID' ;