APPS.PO_RELGEN_PKG dependencies on PO_RELEASES_ALL

Line 240: UPDATE po_releases_all por

236: --
237:
238: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
239:
240: UPDATE po_releases_all por
241: SET por.authorization_status = 'INCOMPLETE',
242: por.approved_flag = 'N'
243: WHERE por.po_release_id = x_po_release_id;
244:

Line 355: UPDATE po_releases_all por

351: ELSIF (l_check_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
352:
353: -- 354: -- LCM submission check fails>
355: UPDATE po_releases_all por
356: SET por.authorization_status = 'INCOMPLETE',
357: por.approved_flag = 'N',
358: por.approved_date = NULL
359: WHERE por.po_release_id = x_po_release_id;

Line 513: UPDATE po_releases_all por

509: -- as the tax calculation has failed
510: --
511: /*Bug 7609663: Update the approved_flag in po_releses_all and po_line_locations_all */
512:
513: UPDATE po_releases_all por
514: SET por.authorization_status = 'INCOMPLETE',
515: por.approved_flag = 'N'
516: WHERE por.po_release_id = x_po_release_id;
517:

Line 612: UPDATE po_releases_all por

608: ELSIF (l_check_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
609:
610: -- 611: -- LCM submission check fails>
612: UPDATE po_releases_all por
613: SET por.authorization_status = 'INCOMPLETE',
614: por.approved_flag = 'N',
615: por.approved_date = NULL
616: WHERE por.po_release_id = x_po_release_id;

Line 747: Same would be inserted into po_releases_all table */

743: FROM PO_RELEASES
744: WHERE PO_HEADER_ID = req_line.blanket_po_header_id;
745:
746: /* Bug 6454219 Added code to fetch shipping_control from the BPA.
747: Same would be inserted into po_releases_all table */
748: SELECT PAY_ON_CODE, SHIPPING_CONTROL
749: INTO x_pay_on_code, x_shipping_control
750: FROM PO_HEADERS
751: WHERE PO_HEADER_ID = req_line.blanket_po_header_id;

Line 3317: FROM PO_RELEASES_ALL POR,

3313: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIP_INV_MATCH_NE_R');
3314:
3315: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3316: BULK COLLECT INTO l_error_messages
3317: FROM PO_RELEASES_ALL POR,
3318: PO_LINE_LOCATIONS_ALL PLL
3319: WHERE POR.po_release_id = PLL.po_release_id
3320: AND POR.po_release_id = x_po_release_id
3321: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'