APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_LINE_LOCATIONS

Line 117: l_ship_closed po_line_locations.closed_code%TYPE;

113: l_auth_status po_releases.authorization_status%TYPE;
114: l_head_closed po_releases.closed_code%TYPE;
115:
116: l_user_hold_flag po_releases.hold_flag%TYPE;
117: l_ship_closed po_line_locations.closed_code%TYPE;
118: l_line_closed po_lines.closed_code%TYPE;
119: l_closed_code VARCHAR2(26);
120: l_frozen_flag po_releases.frozen_flag%TYPE;
121:

Line 165: FROM po_line_locations poll

161: WHERE prh.requisition_header_id = docid;
162:
163: CURSOR ship_closed(shipid NUMBER) IS
164: SELECT nvl(poll.closed_code, 'OPEN')
165: FROM po_line_locations poll
166: WHERE poll.line_location_id = shipid;
167:
168: -- CLM Apprvl
169: CURSOR ship_closed_mod(shipid NUMBER, draftId NUMBER) IS

Line 171: FROM po_line_locations_merge_v poll

167:
168: -- CLM Apprvl
169: CURSOR ship_closed_mod(shipid NUMBER, draftId NUMBER) IS
170: SELECT nvl(poll.closed_code, 'OPEN')
171: FROM po_line_locations_merge_v poll
172: WHERE poll.line_location_id = shipid
173: AND poll.draft_id = draftId;
174:
175: CURSOR line_closed(lineid NUMBER) is

Line 2075: UPDATE PO_LINE_LOCATIONS_ALL poll

2071: END IF;
2072:
2073: d_progress := 90;
2074:
2075: UPDATE PO_LINE_LOCATIONS_ALL poll
2076: SET poll.approved_flag = 'Y'
2077: , poll.approved_date = SYSDATE
2078: , poll.last_update_date = SYSDATE
2079: , poll.last_updated_by = p_user_id

Line 2104: UPDATE PO_LINE_LOCATIONS_ALL poll

2100: THEN
2101:
2102: d_progress := 100;
2103:
2104: UPDATE PO_LINE_LOCATIONS_ALL poll
2105: SET poll.approved_flag = 'R'
2106: , poll.last_update_date = SYSDATE
2107: , poll.last_updated_by = p_user_id
2108: , poll.last_update_login = p_login_id

Line 2143: UPDATE PO_LINE_LOCATIONS_ALL poll

2139: THEN
2140:
2141: d_progress := 120;
2142:
2143: UPDATE PO_LINE_LOCATIONS_ALL poll
2144: SET poll.approved_flag = 'Y'
2145: , poll.approved_date = SYSDATE
2146: , poll.last_update_date = SYSDATE
2147: , poll.last_updated_by = p_user_id

Line 2159: UPDATE PO_LINE_LOCATIONS_ALL poll

2155: THEN
2156:
2157: d_progress := 130;
2158:
2159: UPDATE PO_LINE_LOCATIONS_ALL poll
2160: SET poll.approved_flag = 'R'
2161: , poll.last_update_date = SYSDATE
2162: , poll.last_updated_by = p_user_id
2163: , poll.last_update_login = p_login_id