DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_LINES

Line 98: l_line_closed po_lines.closed_code%TYPE;

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;

Line 139: FROM po_lines pol

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