472: --if resource does not exist for the person then insert both resource
473: -- Bug 3086823 : Transaction number should be created once for the entire set of records
474: IF l_transaction_number is null
475: THEN
476: SELECT jtf_rs_transaction_num_s.nextval
477: INTO l_transaction_number
478: FROM dual;
479: END IF;
480: