APPS.PO_CHANGE_API1_S dependencies on PO_RELEASES

Line 55: from po_releases

51: and type_lookup_code in ('STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED');
52:
53: CURSOR c_po_release IS
54: select po_release_id
55: from po_releases
56: where po_header_id = l_po_header_id
57: and release_num = X_RELEASE_NUMBER;
58:
59: BEGIN

Line 149: 'PO_RELEASES',

145: l_po_release_id is null) then
146: PO_CHANGE_API1_S.insert_error(l_interface_type,
147: l_transaction_id,
148: 'PO_RELEASE_ID',
149: 'PO_RELEASES',
150: 'PO_CHNG_INVALID_RELEASE_NUM',
151: NULL,
152: NULL);
153: return 0;

Line 229: update PO_RELEASES

225: last_update_date = g_sysdate,
226: last_updated_by = g_user_id
227: where PO_HEADER_ID = l_po_header_id;
228: ELSE
229: update PO_RELEASES
230: set ACCEPTANCE_REQUIRED_FLAG = 'N', -- bug 4721255
231: ACCEPTANCE_DUE_DATE = null,
232: last_update_date = g_sysdate,
233: last_updated_by = g_user_id

Line 277: from po_releases

273: l_status,
274: l_cancel_flag,
275: X_current_revision,
276: X_employee_id
277: from po_releases
278: where po_release_id = X_po_release_id;
279:
280: ELSIF (X_po_header_id is not null) then
281: select nvl(closed_code, 'OPEN'),