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

Line 883: l_cursor_name := dbms_sql.open_cursor;

879: :l_mode,
880: :l_gms_partial_flag
881: );
882: end ;' ;
883: l_cursor_name := dbms_sql.open_cursor;
884: dbms_sql.parse(l_cursor_name,l_sql_string,dbms_sql.native);
885: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_packet_id', p_packet_id, 20);
886: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_mode', p_mode, 2);
887: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_gms_partial_flag', p_gms_partial_flag, 2);

Line 884: dbms_sql.parse(l_cursor_name,l_sql_string,dbms_sql.native);

880: :l_gms_partial_flag
881: );
882: end ;' ;
883: l_cursor_name := dbms_sql.open_cursor;
884: dbms_sql.parse(l_cursor_name,l_sql_string,dbms_sql.native);
885: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_packet_id', p_packet_id, 20);
886: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_mode', p_mode, 2);
887: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_gms_partial_flag', p_gms_partial_flag, 2);
888: l_string_execute := dbms_sql.execute(l_cursor_name);

Line 885: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_packet_id', p_packet_id, 20);

881: );
882: end ;' ;
883: l_cursor_name := dbms_sql.open_cursor;
884: dbms_sql.parse(l_cursor_name,l_sql_string,dbms_sql.native);
885: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_packet_id', p_packet_id, 20);
886: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_mode', p_mode, 2);
887: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_gms_partial_flag', p_gms_partial_flag, 2);
888: l_string_execute := dbms_sql.execute(l_cursor_name);
889: dbms_sql.close_cursor(l_cursor_name);

Line 886: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_mode', p_mode, 2);

882: end ;' ;
883: l_cursor_name := dbms_sql.open_cursor;
884: dbms_sql.parse(l_cursor_name,l_sql_string,dbms_sql.native);
885: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_packet_id', p_packet_id, 20);
886: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_mode', p_mode, 2);
887: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_gms_partial_flag', p_gms_partial_flag, 2);
888: l_string_execute := dbms_sql.execute(l_cursor_name);
889: dbms_sql.close_cursor(l_cursor_name);
890: END IF;

Line 887: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_gms_partial_flag', p_gms_partial_flag, 2);

883: l_cursor_name := dbms_sql.open_cursor;
884: dbms_sql.parse(l_cursor_name,l_sql_string,dbms_sql.native);
885: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_packet_id', p_packet_id, 20);
886: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_mode', p_mode, 2);
887: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_gms_partial_flag', p_gms_partial_flag, 2);
888: l_string_execute := dbms_sql.execute(l_cursor_name);
889: dbms_sql.close_cursor(l_cursor_name);
890: END IF;
891:

Line 888: l_string_execute := dbms_sql.execute(l_cursor_name);

884: dbms_sql.parse(l_cursor_name,l_sql_string,dbms_sql.native);
885: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_packet_id', p_packet_id, 20);
886: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_mode', p_mode, 2);
887: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_gms_partial_flag', p_gms_partial_flag, 2);
888: l_string_execute := dbms_sql.execute(l_cursor_name);
889: dbms_sql.close_cursor(l_cursor_name);
890: END IF;
891:
892: EXCEPTION

Line 889: dbms_sql.close_cursor(l_cursor_name);

885: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_packet_id', p_packet_id, 20);
886: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_mode', p_mode, 2);
887: DBMS_SQL.BIND_VARIABLE(l_cursor_name,':l_gms_partial_flag', p_gms_partial_flag, 2);
888: l_string_execute := dbms_sql.execute(l_cursor_name);
889: dbms_sql.close_cursor(l_cursor_name);
890: END IF;
891:
892: EXCEPTION
893: WHEN OTHERS THEN