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_OTM_INTEGRATION_PVT dependencies on PO_HEADERS_ALL

Line 244: l_blanket_revision PO_HEADERS_ALL.revision_num%TYPE;

240: l_param_list PO_EVENT_PARAMS_TYPE;
241: l_command VARCHAR2(30);
242:
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;

Line 246: l_po_number PO_HEADERS_ALL.segment1%TYPE;

242:
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

Line 248: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;

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:
252: l_return_status VARCHAR2(1);

Line 250: l_approved_date PO_HEADERS_ALL.approved_date%TYPE; --7449918

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:
252: l_return_status VARCHAR2(1);
253:
254: d_progress VARCHAR2(3);

Line 374: FROM po_headers_all poh

370: SELECT poh.shipping_control
371: , poh.approved_date
372: INTO l_shipping_control
373: , l_approved_date --7449918
374: FROM po_headers_all poh
375: WHERE poh.po_header_id = p_doc_id;
376:
377: d_progress := '260';
378: END IF;

Line 2587: FROM po_headers_all POH

2583: ) IS
2584:
2585: CURSOR c_get_failed_orders IS
2586: SELECT po_header_id
2587: FROM po_headers_all POH
2588: WHERE POH.otm_recovery_flag = 'Y';
2589:
2590: CURSOR c_get_failed_releases IS
2591: SELECT po_release_id

Line 2764: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

2760: AND MSI.organization_id(+) = p_inv_org_id
2761: AND NVL(MSI.outside_operation_flag, 'N') = 'N';
2762:
2763: l_inv_org_id NUMBER;
2764: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2765: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2766: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2767: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2768: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;

Line 2765: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;

2761: AND NVL(MSI.outside_operation_flag, 'N') = 'N';
2762:
2763: l_inv_org_id NUMBER;
2764: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2765: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2766: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2767: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2768: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2769:

Line 2766: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;

2762:
2763: l_inv_org_id NUMBER;
2764: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2765: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2766: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2767: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2768: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2769:
2770: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

Line 2795: FROM po_headers_all POH,

2791: l_header_cancel_flag,
2792: l_header_closed_code,
2793: l_header_user_hold_flag,
2794: l_inv_org_id
2795: FROM po_headers_all POH,
2796: hr_all_organization_units HOU,
2797: financials_system_params_all FSP
2798: WHERE POH.po_header_id = p_doc_id
2799: AND POH.org_id = HOU.organization_id

Line 2922: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

2918: AND MSI.organization_id(+) = p_inv_org_id
2919: AND NVL(MSI.outside_operation_flag, 'N') = 'N';
2920:
2921: l_inv_org_id NUMBER;
2922: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2923: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2924: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2925: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2926: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;

Line 2923: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;

2919: AND NVL(MSI.outside_operation_flag, 'N') = 'N';
2920:
2921: l_inv_org_id NUMBER;
2922: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2923: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2924: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2925: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2926: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2927:

Line 2924: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;

2920:
2921: l_inv_org_id NUMBER;
2922: l_header_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
2923: l_header_closed_code PO_HEADERS_ALL.closed_code%TYPE;
2924: l_header_user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE;
2925: l_shipment_cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE;
2926: l_shipment_closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE;
2927:
2928: l_otm_schedule_line PO_OTM_SCHEDULE_LINE_TYPE;

Line 2958: po_headers_all POH,

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
2962: AND POR.po_header_id = POH.po_header_id

Line 3088: UPDATE po_headers_all POH

3084: 'N', POR.otm_recovery_flag,
3085: p_otm_recovery_flag)
3086: WHERE POR.po_release_id = p_doc_id;
3087: ELSE -- PO
3088: UPDATE po_headers_all POH
3089: SET POH.otm_status_code = p_order_otm_status,
3090: POH.otm_recovery_flag = DECODE (p_otm_recovery_flag,
3091: 'R', null,
3092: 'N', POH.otm_recovery_flag,