eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_RELGEN_PKG dependencies on PO_RELEASES

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 725: SELECT PO_RELEASES_S.NEXTVAL

721: ELSE
722: x_authorization_status := 'INCOMPLETE';
723: END IF;
724:
725: SELECT PO_RELEASES_S.NEXTVAL
726: INTO x_po_release_id
727: FROM SYS.DUAL;
728:
729: /* Bug 1834138. pchintal. Code for calculating the shipment number.

Line 741: FROM PO_RELEASES

737: END IF;
738:
739: SELECT NVL(MAX(RELEASE_NUM) +1,1)
740: INTO x_release_num
741: FROM PO_RELEASES
742: WHERE PO_HEADER_ID = req_line.blanket_po_header_id;
743:
744: SELECT PAY_ON_CODE
745: INTO x_pay_on_code

Line 761: INSERT INTO PO_RELEASES

757: );
758: END IF;
759: -- Bug 3570793 END
760:
761: INSERT INTO PO_RELEASES
762: (PO_RELEASE_ID,
763: LAST_UPDATE_DATE,
764: LAST_UPDATED_BY,
765: PO_HEADER_ID,

Line 2027: FROM PO_RELEASES

2023: DECODE(APPROVED_FLAG,
2024: 'R','REQUIRES_REAPPROVAL',
2025: 'F','FAILED_APPROVAL',
2026: 'NEVER_APPROVED'))
2027: FROM PO_RELEASES
2028: WHERE NVL(CANCEL_FLAG,'N') = 'N'
2029: AND NVL(APPROVED_FLAG,'N') <> 'Y'
2030: AND PO_RELEASE_ID = x_po_release_id; */
2031: null;

Line 2268: po_releases por,

2264:
2265: SELECT nvl(sum(poll.quantity * poll.price_override),0)
2266: INTO total_release_amount
2267: FROM po_line_locations poll,
2268: po_releases por,
2269: po_headers poh
2270: WHERE poh.po_header_id = x_old_po_header_id
2271: AND poll.po_header_id = poh.po_header_id
2272: AND poll.shipment_type = 'BLANKET'

Line 2915: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL

2911: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
2912: g_linemsg||g_delim||p_req_line_num||
2913: g_delim||l_textline||g_delim||POL.min_release_amount,1,240)
2914: BULK COLLECT INTO l_error_messages
2915: FROM PO_LINES POL,PO_RELEASES POR,PO_LINE_LOCATIONS PLL
2916: WHERE PLL.po_release_id = POR.po_release_id
2917: AND PLL.po_release_id = x_po_release_id
2918: AND POL.po_line_id = PLL.po_line_id
2919: AND POL.min_release_amount is not null

Line 3076: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,

3072: g_linemsg||g_delim||p_req_line_num||
3073: g_delim||l_textline,1,240)
3074: BULK COLLECT INTO l_error_messages
3075: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3076: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3077: FINANCIALS_SYSTEM_PARAMETERS FSP
3078: WHERE POR.po_release_id = x_po_release_id
3079: AND POR.po_header_id = POH.po_header_id
3080: AND POR.po_header_id = POL.po_header_id

Line 3150: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,

3146: g_linemsg||g_delim||p_req_line_num||
3147: g_delim||l_textline,1,240)
3148: BULK COLLECT INTO l_error_messages
3149: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3150: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3151: FINANCIALS_SYSTEM_PARAMETERS FSP
3152: WHERE POR.po_release_id = x_po_release_id
3153: AND POR.po_header_id = POH.po_header_id
3154: AND POR.po_header_id = POL.po_header_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'

Line 3290: FROM PO_RELEASES_GT POR,

3286:
3287: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||
3288: POD.distribution_num||g_delim||l_textline, 1,240)
3289: BULK COLLECT INTO l_error_messages
3290: FROM PO_RELEASES_GT POR,
3291: PO_LINE_LOCATIONS_GT PLL,
3292: PO_DISTRIBUTIONS_GT POD
3293: WHERE POR.po_release_id = POD.po_release_id
3294: AND POD.line_location_id = PLL.line_location_id