117: g_last_tran_id := -1;
118: g_curr_tran_id := 1;
119: ELSE
120: SELECT max(transaction_id) into g_last_tran_id
121: FROM asg_system_dirty_queue
122: WHERE client_id = p_user_name;
123: IF g_last_tran_id IS NULL THEN
124: g_last_tran_id := 1;
125: END IF;
204: g_last_tran_id := -1;
205: g_curr_tran_id := 1;
206: ELSE
207: SELECT max(transaction_id) into g_last_tran_id
208: FROM asg_system_dirty_queue
209: WHERE client_id = p_user_name;
210: IF g_last_tran_id IS NULL THEN
211: g_last_tran_id := 1;
212: END IF;