APPS.JAI_RETRO_PRC_PKG dependencies on PO_HEADERS_ALL

Line 3359: lv_doc_number po_headers_all.segment1%TYPE;

3355: , jai_cmn_taxes_all jcta
3356: WHERE jpt.tax_id = jcta.tax_id
3357: AND jpt.line_location_id = pr_old.line_location_id;
3358:
3359: lv_doc_number po_headers_all.segment1%TYPE;
3360: ln_vendor_id po_headers_all.vendor_id%TYPE;
3361: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;
3362: ln_item_id mtl_system_items_b.inventory_item_id%TYPE;
3363: ln_revision_num po_headers_all.revision_num%TYPE;

Line 3360: ln_vendor_id po_headers_all.vendor_id%TYPE;

3356: WHERE jpt.tax_id = jcta.tax_id
3357: AND jpt.line_location_id = pr_old.line_location_id;
3358:
3359: lv_doc_number po_headers_all.segment1%TYPE;
3360: ln_vendor_id po_headers_all.vendor_id%TYPE;
3361: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;
3362: ln_item_id mtl_system_items_b.inventory_item_id%TYPE;
3363: ln_revision_num po_headers_all.revision_num%TYPE;
3364: ln_retro_line_changes_id NUMBER;

Line 3361: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;

3357: AND jpt.line_location_id = pr_old.line_location_id;
3358:
3359: lv_doc_number po_headers_all.segment1%TYPE;
3360: ln_vendor_id po_headers_all.vendor_id%TYPE;
3361: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;
3362: ln_item_id mtl_system_items_b.inventory_item_id%TYPE;
3363: ln_revision_num po_headers_all.revision_num%TYPE;
3364: ln_retro_line_changes_id NUMBER;
3365: ln_retro_tax_changes_id NUMBER;

Line 3363: ln_revision_num po_headers_all.revision_num%TYPE;

3359: lv_doc_number po_headers_all.segment1%TYPE;
3360: ln_vendor_id po_headers_all.vendor_id%TYPE;
3361: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;
3362: ln_item_id mtl_system_items_b.inventory_item_id%TYPE;
3363: ln_revision_num po_headers_all.revision_num%TYPE;
3364: ln_retro_line_changes_id NUMBER;
3365: ln_retro_tax_changes_id NUMBER;
3366: lv_third_party_flag VARCHAR2(1);
3367:

Line 3452: po_headers_all

3448: lv_doc_number
3449: , ln_vendor_id
3450: , ln_vendor_site_id
3451: FROM
3452: po_headers_all
3453: WHERE po_header_id = pr_old.from_header_id;
3454:
3455: ELSIF pr_old.shipment_type = 'BLANKET'
3456: THEN

Line 3466: po_headers_all

3462: lv_doc_number
3463: , ln_vendor_id
3464: , ln_vendor_site_id
3465: FROM
3466: po_headers_all
3467: WHERE po_header_id = pr_old.po_header_id;
3468:
3469: END IF;
3470: EXCEPTION