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

Line 570: l_tab_access_id dbms_sql.Number_Table;

566: l_dynamic_stmt VARCHAR2(4000);
567:
568: l_primary_key VARCHAR2(4000);
569: l_original_primary_key VARCHAR2(4000);
570: l_tab_access_id dbms_sql.Number_Table;
571: m_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
572:
573: l_cursor INTEGER;
574: l_count INTEGER;

Line 684: l_cursor := dbms_sql.open_cursor;

680: 'LAST_RUN_DATE = ' || to_char(r_query_request.last_run_date)
681: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
682: , v_module => 'jtm_message_log_pkg');
683: END IF;
684: l_cursor := dbms_sql.open_cursor;
685: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
686: dbms_sql.bind_variable( l_cursor, 'last_run_date', r_query_request.last_run_date);
687: l_index := 1;
688: l_tab_access_id.DELETE;

Line 685: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);

681: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
682: , v_module => 'jtm_message_log_pkg');
683: END IF;
684: l_cursor := dbms_sql.open_cursor;
685: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
686: dbms_sql.bind_variable( l_cursor, 'last_run_date', r_query_request.last_run_date);
687: l_index := 1;
688: l_tab_access_id.DELETE;
689: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

Line 686: dbms_sql.bind_variable( l_cursor, 'last_run_date', r_query_request.last_run_date);

682: , v_module => 'jtm_message_log_pkg');
683: END IF;
684: l_cursor := dbms_sql.open_cursor;
685: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
686: dbms_sql.bind_variable( l_cursor, 'last_run_date', r_query_request.last_run_date);
687: l_index := 1;
688: l_tab_access_id.DELETE;
689: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
690: l_count := dbms_sql.execute( l_cursor );

Line 689: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

685: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
686: dbms_sql.bind_variable( l_cursor, 'last_run_date', r_query_request.last_run_date);
687: l_index := 1;
688: l_tab_access_id.DELETE;
689: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
690: l_count := dbms_sql.execute( l_cursor );
691: LOOP
692: l_count := dbms_sql.fetch_rows(l_cursor);
693: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

Line 690: l_count := dbms_sql.execute( l_cursor );

686: dbms_sql.bind_variable( l_cursor, 'last_run_date', r_query_request.last_run_date);
687: l_index := 1;
688: l_tab_access_id.DELETE;
689: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
690: l_count := dbms_sql.execute( l_cursor );
691: LOOP
692: l_count := dbms_sql.fetch_rows(l_cursor);
693: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
694: EXIT WHEN l_count <> 100;

Line 692: l_count := dbms_sql.fetch_rows(l_cursor);

688: l_tab_access_id.DELETE;
689: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
690: l_count := dbms_sql.execute( l_cursor );
691: LOOP
692: l_count := dbms_sql.fetch_rows(l_cursor);
693: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
694: EXIT WHEN l_count <> 100;
695: END LOOP;
696: dbms_sql.close_cursor( l_cursor );

Line 693: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

689: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
690: l_count := dbms_sql.execute( l_cursor );
691: LOOP
692: l_count := dbms_sql.fetch_rows(l_cursor);
693: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
694: EXIT WHEN l_count <> 100;
695: END LOOP;
696: dbms_sql.close_cursor( l_cursor );
697:

Line 696: dbms_sql.close_cursor( l_cursor );

692: l_count := dbms_sql.fetch_rows(l_cursor);
693: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
694: EXIT WHEN l_count <> 100;
695: END LOOP;
696: dbms_sql.close_cursor( l_cursor );
697:
698: IF l_tab_access_id.COUNT > 0 THEN
699: /*** 1 or more acc rows retrieved -> push to resources ***/
700: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 793: l_cursor := dbms_sql.open_cursor;

789: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
790: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
791: , v_module => 'jtm_message_log_pkg');
792: END IF;
793: l_cursor := dbms_sql.open_cursor;
794: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
795: l_index := 1;
796: l_tab_access_id.DELETE;
797: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

Line 794: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);

790: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
791: , v_module => 'jtm_message_log_pkg');
792: END IF;
793: l_cursor := dbms_sql.open_cursor;
794: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
795: l_index := 1;
796: l_tab_access_id.DELETE;
797: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
798: l_count := dbms_sql.execute( l_cursor );

Line 797: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

793: l_cursor := dbms_sql.open_cursor;
794: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
795: l_index := 1;
796: l_tab_access_id.DELETE;
797: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
798: l_count := dbms_sql.execute( l_cursor );
799: LOOP
800: l_count := dbms_sql.fetch_rows(l_cursor);
801: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

Line 798: l_count := dbms_sql.execute( l_cursor );

794: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
795: l_index := 1;
796: l_tab_access_id.DELETE;
797: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
798: l_count := dbms_sql.execute( l_cursor );
799: LOOP
800: l_count := dbms_sql.fetch_rows(l_cursor);
801: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
802: EXIT WHEN l_count <> 100;

Line 800: l_count := dbms_sql.fetch_rows(l_cursor);

796: l_tab_access_id.DELETE;
797: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
798: l_count := dbms_sql.execute( l_cursor );
799: LOOP
800: l_count := dbms_sql.fetch_rows(l_cursor);
801: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
802: EXIT WHEN l_count <> 100;
803: END LOOP;
804: dbms_sql.close_cursor( l_cursor );

Line 801: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

797: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
798: l_count := dbms_sql.execute( l_cursor );
799: LOOP
800: l_count := dbms_sql.fetch_rows(l_cursor);
801: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
802: EXIT WHEN l_count <> 100;
803: END LOOP;
804: dbms_sql.close_cursor( l_cursor );
805:

Line 804: dbms_sql.close_cursor( l_cursor );

800: l_count := dbms_sql.fetch_rows(l_cursor);
801: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
802: EXIT WHEN l_count <> 100;
803: END LOOP;
804: dbms_sql.close_cursor( l_cursor );
805:
806: IF l_tab_access_id.COUNT > 0 THEN
807: /*** 1 or more acc rows retrieved -> push to resources ***/
808: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 875: l_cursor := dbms_sql.open_cursor;

871: ' WHERE (' || l_primary_key || ') NOT IN (SELECT ' ||
872: l_primary_key || ' FROM (' || r_query_request.con_query || '))';
873: END IF;
874:
875: l_cursor := dbms_sql.open_cursor;
876: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
877: l_index := 1;
878: l_tab_access_id.DELETE;
879: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

Line 876: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);

872: l_primary_key || ' FROM (' || r_query_request.con_query || '))';
873: END IF;
874:
875: l_cursor := dbms_sql.open_cursor;
876: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
877: l_index := 1;
878: l_tab_access_id.DELETE;
879: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
880: l_count := dbms_sql.execute( l_cursor );

Line 879: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

875: l_cursor := dbms_sql.open_cursor;
876: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
877: l_index := 1;
878: l_tab_access_id.DELETE;
879: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
880: l_count := dbms_sql.execute( l_cursor );
881: LOOP
882: l_count := dbms_sql.fetch_rows(l_cursor);
883: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

Line 880: l_count := dbms_sql.execute( l_cursor );

876: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
877: l_index := 1;
878: l_tab_access_id.DELETE;
879: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
880: l_count := dbms_sql.execute( l_cursor );
881: LOOP
882: l_count := dbms_sql.fetch_rows(l_cursor);
883: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
884: EXIT WHEN l_count <> 100;

Line 882: l_count := dbms_sql.fetch_rows(l_cursor);

878: l_tab_access_id.DELETE;
879: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
880: l_count := dbms_sql.execute( l_cursor );
881: LOOP
882: l_count := dbms_sql.fetch_rows(l_cursor);
883: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
884: EXIT WHEN l_count <> 100;
885: END LOOP;
886: dbms_sql.close_cursor( l_cursor );

Line 883: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

879: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
880: l_count := dbms_sql.execute( l_cursor );
881: LOOP
882: l_count := dbms_sql.fetch_rows(l_cursor);
883: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
884: EXIT WHEN l_count <> 100;
885: END LOOP;
886: dbms_sql.close_cursor( l_cursor );
887:

Line 886: dbms_sql.close_cursor( l_cursor );

882: l_count := dbms_sql.fetch_rows(l_cursor);
883: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
884: EXIT WHEN l_count <> 100;
885: END LOOP;
886: dbms_sql.close_cursor( l_cursor );
887:
888: IF l_tab_access_id.COUNT > 0 THEN
889: /*** 1 or more acc rows retrieved -> push to resources ***/
890: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 992: l_tab_access_id dbms_sql.Number_Table;

988: l_query_start date;
989: l_dynamic_stmt VARCHAR2(4000);
990:
991: l_primary_key VARCHAR2(2000);
992: l_tab_access_id dbms_sql.Number_Table;
993: m_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
994:
995: l_cursor INTEGER;
996: l_count INTEGER;

Line 1181: l_cursor := dbms_sql.open_cursor;

1177: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
1178: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
1179: , v_module => 'jtm_message_log_pkg');
1180: END IF;
1181: l_cursor := dbms_sql.open_cursor;
1182: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1183: l_index := 1;
1184: l_tab_access_id.DELETE;
1185: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

Line 1182: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);

1178: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
1179: , v_module => 'jtm_message_log_pkg');
1180: END IF;
1181: l_cursor := dbms_sql.open_cursor;
1182: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1183: l_index := 1;
1184: l_tab_access_id.DELETE;
1185: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1186: l_count := dbms_sql.execute( l_cursor );

Line 1185: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

1181: l_cursor := dbms_sql.open_cursor;
1182: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1183: l_index := 1;
1184: l_tab_access_id.DELETE;
1185: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1186: l_count := dbms_sql.execute( l_cursor );
1187: LOOP
1188: l_count := dbms_sql.fetch_rows(l_cursor);
1189: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

Line 1186: l_count := dbms_sql.execute( l_cursor );

1182: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1183: l_index := 1;
1184: l_tab_access_id.DELETE;
1185: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1186: l_count := dbms_sql.execute( l_cursor );
1187: LOOP
1188: l_count := dbms_sql.fetch_rows(l_cursor);
1189: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
1190: EXIT WHEN l_count <> 100;

Line 1188: l_count := dbms_sql.fetch_rows(l_cursor);

1184: l_tab_access_id.DELETE;
1185: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1186: l_count := dbms_sql.execute( l_cursor );
1187: LOOP
1188: l_count := dbms_sql.fetch_rows(l_cursor);
1189: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
1190: EXIT WHEN l_count <> 100;
1191: END LOOP;
1192: dbms_sql.close_cursor( l_cursor );

Line 1189: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

1185: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1186: l_count := dbms_sql.execute( l_cursor );
1187: LOOP
1188: l_count := dbms_sql.fetch_rows(l_cursor);
1189: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
1190: EXIT WHEN l_count <> 100;
1191: END LOOP;
1192: dbms_sql.close_cursor( l_cursor );
1193:

Line 1192: dbms_sql.close_cursor( l_cursor );

1188: l_count := dbms_sql.fetch_rows(l_cursor);
1189: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
1190: EXIT WHEN l_count <> 100;
1191: END LOOP;
1192: dbms_sql.close_cursor( l_cursor );
1193:
1194: IF l_tab_access_id.COUNT > 0 THEN
1195: /*** 1 or more acc rows retrieved -> push to resources ***/
1196: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 1248: l_cursor := dbms_sql.open_cursor;

1244: l_dynamic_stmt := 'SELECT ACCESS_ID FROM ' || r_query_request.acc_table_name ||
1245: ' WHERE (' || l_primary_key || ') NOT IN (SELECT ' ||
1246: l_primary_key || ' FROM (' || r_query_request.con_query || '))';
1247:
1248: l_cursor := dbms_sql.open_cursor;
1249: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1250: l_index := 1;
1251: l_tab_access_id.DELETE;
1252: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

Line 1249: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);

1245: ' WHERE (' || l_primary_key || ') NOT IN (SELECT ' ||
1246: l_primary_key || ' FROM (' || r_query_request.con_query || '))';
1247:
1248: l_cursor := dbms_sql.open_cursor;
1249: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1250: l_index := 1;
1251: l_tab_access_id.DELETE;
1252: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1253: l_count := dbms_sql.execute( l_cursor );

Line 1252: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);

1248: l_cursor := dbms_sql.open_cursor;
1249: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1250: l_index := 1;
1251: l_tab_access_id.DELETE;
1252: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1253: l_count := dbms_sql.execute( l_cursor );
1254: LOOP
1255: l_count := dbms_sql.fetch_rows(l_cursor);
1256: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

Line 1253: l_count := dbms_sql.execute( l_cursor );

1249: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1250: l_index := 1;
1251: l_tab_access_id.DELETE;
1252: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1253: l_count := dbms_sql.execute( l_cursor );
1254: LOOP
1255: l_count := dbms_sql.fetch_rows(l_cursor);
1256: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
1257: EXIT WHEN l_count <> 100;

Line 1255: l_count := dbms_sql.fetch_rows(l_cursor);

1251: l_tab_access_id.DELETE;
1252: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1253: l_count := dbms_sql.execute( l_cursor );
1254: LOOP
1255: l_count := dbms_sql.fetch_rows(l_cursor);
1256: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
1257: EXIT WHEN l_count <> 100;
1258: END LOOP;
1259: dbms_sql.close_cursor( l_cursor );

Line 1256: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);

1252: dbms_sql.define_array( l_cursor, 1, l_tab_access_id, 100, l_index);
1253: l_count := dbms_sql.execute( l_cursor );
1254: LOOP
1255: l_count := dbms_sql.fetch_rows(l_cursor);
1256: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
1257: EXIT WHEN l_count <> 100;
1258: END LOOP;
1259: dbms_sql.close_cursor( l_cursor );
1260:

Line 1259: dbms_sql.close_cursor( l_cursor );

1255: l_count := dbms_sql.fetch_rows(l_cursor);
1256: dbms_sql.column_value( l_cursor, '1', l_tab_access_id);
1257: EXIT WHEN l_count <> 100;
1258: END LOOP;
1259: dbms_sql.close_cursor( l_cursor );
1260:
1261: IF l_tab_access_id.COUNT > 0 THEN
1262: /*** 1 or more acc rows retrieved -> push to resources ***/
1263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 1300: l_cursor := dbms_sql.open_cursor;

1296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
1297: , v_module => 'jtm_message_log_pkg');
1298: END IF;
1299:
1300: l_cursor := dbms_sql.open_cursor;
1301: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1302: l_count := dbms_sql.execute( l_cursor );
1303: dbms_sql.close_cursor( l_cursor );
1304: END IF;

Line 1301: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);

1297: , v_module => 'jtm_message_log_pkg');
1298: END IF;
1299:
1300: l_cursor := dbms_sql.open_cursor;
1301: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1302: l_count := dbms_sql.execute( l_cursor );
1303: dbms_sql.close_cursor( l_cursor );
1304: END IF;
1305: /*************************** 3. PROCESS DELETES DONE***************************/

Line 1302: l_count := dbms_sql.execute( l_cursor );

1298: END IF;
1299:
1300: l_cursor := dbms_sql.open_cursor;
1301: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1302: l_count := dbms_sql.execute( l_cursor );
1303: dbms_sql.close_cursor( l_cursor );
1304: END IF;
1305: /*************************** 3. PROCESS DELETES DONE***************************/
1306:

Line 1303: dbms_sql.close_cursor( l_cursor );

1299:
1300: l_cursor := dbms_sql.open_cursor;
1301: dbms_sql.parse( l_cursor, l_dynamic_stmt, dbms_sql.v7);
1302: l_count := dbms_sql.execute( l_cursor );
1303: dbms_sql.close_cursor( l_cursor );
1304: END IF;
1305: /*************************** 3. PROCESS DELETES DONE***************************/
1306:
1307: p_message := 'Successfully processing with query id ' ||