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_FS_RPT_UTIL_PKG dependencies on DBMS_SQL

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

652: add_bin_column(p_column7) ||
653: add_bin_column(p_column8) ||
654: ') grp_id from dual';
655:
656: -- we use dbms_sql rather than execute immediate
657: -- as we don't know how many binds we need, dbms_sql
658: -- allows us to "bind by name"
659: l_cur_hdl := dbms_sql.open_cursor;
660: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);

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

653: add_bin_column(p_column8) ||
654: ') grp_id from dual';
655:
656: -- we use dbms_sql rather than execute immediate
657: -- as we don't know how many binds we need, dbms_sql
658: -- allows us to "bind by name"
659: l_cur_hdl := dbms_sql.open_cursor;
660: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
661: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);

Line 659: l_cur_hdl := dbms_sql.open_cursor;

655:
656: -- we use dbms_sql rather than execute immediate
657: -- as we don't know how many binds we need, dbms_sql
658: -- allows us to "bind by name"
659: l_cur_hdl := dbms_sql.open_cursor;
660: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
661: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
662: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
663: l_grp_id := dbms_sql.execute(l_cur_hdl);

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

656: -- we use dbms_sql rather than execute immediate
657: -- as we don't know how many binds we need, dbms_sql
658: -- allows us to "bind by name"
659: l_cur_hdl := dbms_sql.open_cursor;
660: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
661: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
662: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
663: l_grp_id := dbms_sql.execute(l_cur_hdl);
664: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then

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

657: -- as we don't know how many binds we need, dbms_sql
658: -- allows us to "bind by name"
659: l_cur_hdl := dbms_sql.open_cursor;
660: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
661: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
662: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
663: l_grp_id := dbms_sql.execute(l_cur_hdl);
664: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
665: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);

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

658: -- allows us to "bind by name"
659: l_cur_hdl := dbms_sql.open_cursor;
660: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
661: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
662: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
663: l_grp_id := dbms_sql.execute(l_cur_hdl);
664: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
665: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
666: end if;

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

659: l_cur_hdl := dbms_sql.open_cursor;
660: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
661: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
662: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
663: l_grp_id := dbms_sql.execute(l_cur_hdl);
664: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
665: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
666: end if;
667: dbms_sql.close_cursor(l_cur_hdl);

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

660: dbms_sql.parse(l_cur_hdl, l_stmt, dbms_sql.native);
661: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
662: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
663: l_grp_id := dbms_sql.execute(l_cur_hdl);
664: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
665: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
666: end if;
667: dbms_sql.close_cursor(l_cur_hdl);
668:

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

661: dbms_sql.bind_variable(l_cur_hdl, 'p_bmap', p_dim_bmap);
662: dbms_sql.define_column(l_cur_hdl, 1, l_grp_id);
663: l_grp_id := dbms_sql.execute(l_cur_hdl);
664: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
665: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
666: end if;
667: dbms_sql.close_cursor(l_cur_hdl);
668:
669: add_custom_bind_parameter

Line 667: dbms_sql.close_cursor(l_cur_hdl);

663: l_grp_id := dbms_sql.execute(l_cur_hdl);
664: if dbms_sql.fetch_rows(l_cur_hdl) > 0 then
665: dbms_sql.column_value(l_cur_hdl, 1, l_grp_id);
666: end if;
667: dbms_sql.close_cursor(l_cur_hdl);
668:
669: add_custom_bind_parameter
670: ( p_custom_output => p_custom_output
671: , p_parameter_name => '&ISC_GRP_ID'