APPS.JAI_RETRO_PRC_PKG dependencies on PO_HEADERS_ALL

Line 3314: lv_doc_number po_headers_all.segment1%TYPE;

3310: , jai_cmn_taxes_all jcta
3311: WHERE jpt.tax_id = jcta.tax_id
3312: AND jpt.line_location_id = pr_old.line_location_id;
3313:
3314: lv_doc_number po_headers_all.segment1%TYPE;
3315: ln_vendor_id po_headers_all.vendor_id%TYPE;
3316: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;
3317: ln_item_id mtl_system_items_b.inventory_item_id%TYPE;
3318: ln_revision_num po_headers_all.revision_num%TYPE;

Line 3315: ln_vendor_id po_headers_all.vendor_id%TYPE;

3311: WHERE jpt.tax_id = jcta.tax_id
3312: AND jpt.line_location_id = pr_old.line_location_id;
3313:
3314: lv_doc_number po_headers_all.segment1%TYPE;
3315: ln_vendor_id po_headers_all.vendor_id%TYPE;
3316: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;
3317: ln_item_id mtl_system_items_b.inventory_item_id%TYPE;
3318: ln_revision_num po_headers_all.revision_num%TYPE;
3319: ln_retro_line_changes_id NUMBER;

Line 3316: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;

3312: AND jpt.line_location_id = pr_old.line_location_id;
3313:
3314: lv_doc_number po_headers_all.segment1%TYPE;
3315: ln_vendor_id po_headers_all.vendor_id%TYPE;
3316: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;
3317: ln_item_id mtl_system_items_b.inventory_item_id%TYPE;
3318: ln_revision_num po_headers_all.revision_num%TYPE;
3319: ln_retro_line_changes_id NUMBER;
3320: ln_retro_tax_changes_id NUMBER;

Line 3318: ln_revision_num po_headers_all.revision_num%TYPE;

3314: lv_doc_number po_headers_all.segment1%TYPE;
3315: ln_vendor_id po_headers_all.vendor_id%TYPE;
3316: ln_vendor_site_id po_headers_all.vendor_site_id%TYPE;
3317: ln_item_id mtl_system_items_b.inventory_item_id%TYPE;
3318: ln_revision_num po_headers_all.revision_num%TYPE;
3319: ln_retro_line_changes_id NUMBER;
3320: ln_retro_tax_changes_id NUMBER;
3321: lv_third_party_flag VARCHAR2(1);
3322:

Line 3407: po_headers_all

3403: lv_doc_number
3404: , ln_vendor_id
3405: , ln_vendor_site_id
3406: FROM
3407: po_headers_all
3408: WHERE po_header_id = pr_old.from_header_id;
3409:
3410: ELSIF pr_old.shipment_type = 'BLANKET'
3411: THEN

Line 3421: po_headers_all

3417: lv_doc_number
3418: , ln_vendor_id
3419: , ln_vendor_site_id
3420: FROM
3421: po_headers_all
3422: WHERE po_header_id = pr_old.po_header_id;
3423:
3424: END IF;
3425: EXCEPTION