267: IF ( p_lock_records = 'Y' ) THEN
268:
269: SELECT pool.requisition_line_id
270: BULK COLLECT INTO x_req_line_id_in_pool_tbl
271: FROM po_req_lines_in_pool_sec_v pool
272: WHERE pool.requisition_line_id IN ( SELECT selected.index_num1
273: FROM po_session_gt selected
274: WHERE selected.key = l_key
275: )
282: ELSE
283:
284: SELECT pool.requisition_line_id
285: BULK COLLECT INTO x_req_line_id_in_pool_tbl
286: FROM po_req_lines_in_pool_sec_v pool
287: WHERE pool.requisition_line_id IN ( SELECT selected.index_num1
288: FROM po_session_gt selected
289: WHERE selected.key = l_key
290: );