APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_LINE_LOCATIONS

Line 97: l_ship_closed po_line_locations.closed_code%TYPE;

93: l_auth_status po_releases.authorization_status%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:

Line 134: FROM po_line_locations poll

130: WHERE prh.requisition_header_id = docid;
131:
132: CURSOR ship_closed(shipid NUMBER) IS
133: SELECT nvl(poll.closed_code, 'OPEN')
134: FROM po_line_locations poll
135: WHERE poll.line_location_id = shipid;
136:
137: CURSOR line_closed(lineid NUMBER) is
138: SELECT nvl(pol.closed_code, 'OPEN')

Line 1778: UPDATE PO_LINE_LOCATIONS_ALL poll

1774: END IF; -- l_pending_signature = 'Y'
1775:
1776: d_progress := 90;
1777:
1778: UPDATE PO_LINE_LOCATIONS_ALL poll
1779: SET poll.approved_flag = 'Y'
1780: , poll.approved_date = SYSDATE
1781: , poll.last_update_date = SYSDATE
1782: , poll.last_updated_by = p_user_id

Line 1799: UPDATE PO_LINE_LOCATIONS_ALL poll

1795: THEN
1796:
1797: d_progress := 100;
1798:
1799: UPDATE PO_LINE_LOCATIONS_ALL poll
1800: SET poll.approved_flag = 'R'
1801: , poll.last_update_date = SYSDATE
1802: , poll.last_updated_by = p_user_id
1803: , poll.last_update_login = p_login_id

Line 1838: UPDATE PO_LINE_LOCATIONS_ALL poll

1834: THEN
1835:
1836: d_progress := 120;
1837:
1838: UPDATE PO_LINE_LOCATIONS_ALL poll
1839: SET poll.approved_flag = 'Y'
1840: , poll.approved_date = SYSDATE
1841: , poll.last_update_date = SYSDATE
1842: , poll.last_updated_by = p_user_id

Line 1854: UPDATE PO_LINE_LOCATIONS_ALL poll

1850: THEN
1851:
1852: d_progress := 130;
1853:
1854: UPDATE PO_LINE_LOCATIONS_ALL poll
1855: SET poll.approved_flag = 'R'
1856: , poll.last_update_date = SYSDATE
1857: , poll.last_updated_by = p_user_id
1858: , poll.last_update_login = p_login_id