APPS.GML_PO_RECV2_PKG dependencies on PO_RELEASES_ALL

Line 249: DESCRIPTION Procedure to update the status in po_releases_all

245: /*========================================================================
246:
247: PROCEDURE NAME update_release_status
248:
249: DESCRIPTION Procedure to update the status in po_releases_all
250:
251: MODIFICATION HISTORY
252:
253: 11/12/97 Kenny Jiang created

Line 274: FROM po_releases_all

270: AND org_id = v_org_id;
271:
272: CURSOR status_cur IS
273: SELECT closed_code
274: FROM po_releases_all
275: WHERE po_header_id = v_po_header_id
276: AND po_release_id = v_po_release_id
277: AND org_id = v_org_id;
278:

Line 313: UPDATE po_releases_all

309: FETCH status_cur INTO v_old_status;
310: CLOSE status_cur;
311:
312: IF v_old_status IS NULL OR v_new_status <> v_old_status THEN
313: UPDATE po_releases_all
314: SET closed_code = v_new_status,
315: last_update_date= v_last_update_date,
316: last_updated_by = v_last_updated_by
317: WHERE po_header_id = v_po_header_id

Line 552: /*BUG#:1222247 leave status code in po_releases_all unchanged -- */

548: v_last_updated_by,
549: v_timestamp);
550: */
551:
552: /*BUG#:1222247 leave status code in po_releases_all unchanged -- */
553: /* commented the call to update_release_status */
554:
555: /* IF v_po_release_id IS NOT NULL THEN -- it's a Planned/Blanket PO shipment */
556: /* update_release_status(v_po_header_id, */