APPS.PO_RELGEN_PKG dependencies on PO_RELEASES_ALL

Line 239: UPDATE po_releases_all por

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

Line 354: UPDATE po_releases_all por

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

Line 512: UPDATE po_releases_all por

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

Line 611: UPDATE po_releases_all por

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

Line 3263: FROM PO_RELEASES_ALL POR,

3259: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIP_INV_MATCH_NE_R');
3260:
3261: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3262: BULK COLLECT INTO l_error_messages
3263: FROM PO_RELEASES_ALL POR,
3264: PO_LINE_LOCATIONS_ALL PLL
3265: WHERE POR.po_release_id = PLL.po_release_id
3266: AND POR.po_release_id = x_po_release_id
3267: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'