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 227: update PO_RELEASES

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

Line 275: from po_releases

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