94: l_head_closed po_releases.closed_code%TYPE;
95:
96: l_user_hold_flag po_releases.hold_flag%TYPE;
97: l_ship_closed po_line_locations.closed_code%TYPE;
98: l_line_closed po_lines.closed_code%TYPE;
99: l_closed_code VARCHAR2(26);
100: l_frozen_flag po_releases.frozen_flag%TYPE;
101:
102: l_state_found BOOLEAN;
135: WHERE poll.line_location_id = shipid;
136:
137: CURSOR line_closed(lineid NUMBER) is
138: SELECT nvl(pol.closed_code, 'OPEN')
139: FROM po_lines pol
140: WHERE pol.po_line_id = lineid;
141:
142:
143: BEGIN