APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_RELEASES_ALL

Line 247: l_release_number PO_RELEASES_ALL.release_num%TYPE;

243: l_doc_revision NUMBER;
244: l_blanket_revision PO_HEADERS_ALL.revision_num%TYPE;
245: l_org_name HR_ALL_ORGANIZATION_UNITS.name%TYPE;
246: l_po_number PO_HEADERS_ALL.segment1%TYPE;
247: l_release_number PO_RELEASES_ALL.release_num%TYPE;
248: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
249: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --
250: l_approved_date PO_HEADERS_ALL.approved_date%TYPE; --7449918
251:

Line 363: FROM po_releases_all por

359: SELECT por.shipping_control
360: , por.approved_date
361: INTO l_shipping_control
362: , l_approved_date --7449918
363: FROM po_releases_all por
364: WHERE por.po_release_id = p_doc_id;
365:
366: d_progress := '240';
367: ELSE

Line 2288: , po_releases_all por

2284: , x_otm_doc.po_number
2285: , x_otm_doc.release_number
2286: , x_otm_doc.org_name
2287: FROM po_headers_archive_all poha
2288: , po_releases_all por
2289: , hr_all_organization_units hou
2290: WHERE por.po_release_id = p_doc_id
2291: AND poha.po_header_id = por.po_header_id
2292: AND poha.revision_num = p_blanket_revision

Line 2592: FROM po_releases_all POR

2588: WHERE POH.otm_recovery_flag = 'Y';
2589:
2590: CURSOR c_get_failed_releases IS
2591: SELECT po_release_id
2592: FROM po_releases_all POR
2593: WHERE POR.otm_recovery_flag = 'Y';
2594:
2595: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'recover_failed_orders';
2596: d_progress VARCHAR2(3);

Line 2908: FROM po_releases_all POR,

2904: POL.line_num,
2905: PLL.shipment_num,
2906: NVL(PLL.cancel_flag, 'N'),
2907: NVL(PLL.closed_code, 'OPEN')
2908: FROM po_releases_all POR,
2909: po_lines_all POL,
2910: po_line_locations_all PLL,
2911: mtl_system_items MSI
2912: WHERE POR.po_release_id = p_doc_id

Line 2957: FROM po_releases_all POR,

2953: l_header_cancel_flag,
2954: l_header_closed_code,
2955: l_header_user_hold_flag,
2956: l_inv_org_id
2957: FROM po_releases_all POR,
2958: po_headers_all POH,
2959: hr_all_organization_units HOU,
2960: financials_system_params_all FSP
2961: WHERE POR.po_release_id = p_doc_id

Line 3080: UPDATE po_releases_all POR

3076: -- 'R': Reset the flag to NULL
3077: -- 'N': Keep the flag as is
3078:
3079: IF (p_doc_type = 'RELEASE') THEN
3080: UPDATE po_releases_all POR
3081: SET POR.otm_status_code = p_order_otm_status,
3082: POR.otm_recovery_flag = DECODE (p_otm_recovery_flag,
3083: 'R', null,
3084: 'N', POR.otm_recovery_flag,