7273: END IF;
7274:
7275: IF (l_array_packet_id.COUNT > 0) THEN
7276: FORALL i IN 1..l_array_packet_id.COUNT
7277: DELETE FROM gl_bc_packet_arrival_order
7278: WHERE packet_id = l_array_packet_id(i);
7279:
7280: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7281: trace(p_msg => '# gl_bc_packet_arrival_order deleted = '||SQL%ROWCOUNT
7277: DELETE FROM gl_bc_packet_arrival_order
7278: WHERE packet_id = l_array_packet_id(i);
7279:
7280: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7281: trace(p_msg => '# gl_bc_packet_arrival_order deleted = '||SQL%ROWCOUNT
7282: ,p_level => C_LEVEL_STATEMENT
7283: ,p_module => l_log_module);
7284: END IF;
7285: END IF;