85: SELECT serial_transaction_temp_id
86: FROM mtl_transaction_lots_temp
87: WHERE transaction_temp_id = p_temp_id;
88:
89: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
90:
91: BEGIN
92: IF (l_debug = 1) THEN
93: mydebug(' in unload_task ');
736: )
737: ORDER BY dummy_sort;
738:
739:
740: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
741: l_parent_deleted BOOLEAN := FALSE;
742: l_dum_sort NUMBER;
743:
744: BEGIN