APPS.PO_INTERFACE_S dependencies on PO_VENDOR_SITES

Line 62: shipping_control PO_VENDOR_SITES.shipping_control%TYPE := NULL --

58: * Used to default invoice match flag from financial system parameter,
59: * vendor and vendor site
60: */
61: invoice_match_option po_vendors.match_option%type := null,
62: shipping_control PO_VENDOR_SITES.shipping_control%TYPE := NULL --
63: );
64:
65: /* Type declaration for Item defaults structure */
66: /*Bug 1391523 . Added market price to the record

Line 1483: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;

1479:
1480:
1481: --
1482: l_default_method VARCHAR2(30);
1483: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
1484: l_fax_number VARCHAR2(100);
1485: l_document_num PO_HEADERS_ALL.segment1%TYPE;
1486: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
1487: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;

Line 1486: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;

1482: l_default_method VARCHAR2(30);
1483: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
1484: l_fax_number VARCHAR2(100);
1485: l_document_num PO_HEADERS_ALL.segment1%TYPE;
1486: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
1487: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
1488: --
1489:
1490:

Line 1487: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;

1483: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
1484: l_fax_number VARCHAR2(100);
1485: l_document_num PO_HEADERS_ALL.segment1%TYPE;
1486: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
1487: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
1488: --
1489:
1490:
1491: BEGIN

Line 1654: po_vendor_sites_sv.get_vendor_site_info

1650: vendor.vat_registration_num,
1651: vendor.inspection_required_flag);
1652:
1653: IF(interface.vendor_site_id is not null) THEN
1654: po_vendor_sites_sv.get_vendor_site_info
1655: (interface.vendor_site_id,
1656: vendor.ship_to_location_id,
1657: vendor.bill_to_location_id,
1658: l_vs_ship_via_lookup_code,

Line 2313: Calling PO_VENDOR_SITES_SV.get_transmission_defaults only when vendor_id and

2309: p_message => 'After Insert into PO_headers');
2310: END IF;
2311:
2312: /* Bug#13542989: Start : Get Default document transimmision information and
2313: Calling PO_VENDOR_SITES_SV.get_transmission_defaults only when vendor_id and
2314: vendor_site_id is present on PO to avoid no_data_found exception. */
2315:
2316: SELECT vendor_id, vendor_site_id
2317: INTO l_vendor_id, l_vendor_site_id

Line 2323: PO_VENDOR_SITES_SV.get_transmission_defaults

2319: WHERE po_header_id = INTERFACE.po_header_id;
2320: IF l_vendor_id IS NOT NULL AND
2321: l_vendor_site_id IS NOT NULL THEN
2322:
2323: PO_VENDOR_SITES_SV.get_transmission_defaults
2324: ( p_document_id => interface.po_header_id,
2325: p_document_type => g_document_type,
2326: p_document_subtype => interface.document_subtype,
2327: p_preparer_id => interface.agent_id,

Line 3157: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878

3153: l_interface_line_id_tbl interface_line_id_tbl;
3154: --
3155:
3156: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --
3157: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878
3158:
3159: --
3160: l_enhanced_pricing_flag po_doc_style_headers.enhanced_pricing_flag%type;
3161: l_pricing_call_src VARCHAR2(5);

Line 4363: FROM po_vendor_sites_all

4359: -- Bug 13556601 Included complex work flag to avoid copying retainage rate for other document types.
4360: IF(interface.vendor_site_id is not null AND p_is_complex_work_po)THEN
4361: SELECT retainage_rate
4362: into l_retainage_rate
4363: FROM po_vendor_sites_all
4364: WHERE vendor_site_id = interface.vendor_site_id;
4365: END IF;
4366: -- bug 4887900 END
4367:

Line 8397: FROM po_vendor_sites_all --

8393: l_progress := '010';
8394: /* Retrieve Invoice Match Option from Vendor site*/
8395: SELECT match_option
8396: INTO x_invoice_match_option
8397: FROM po_vendor_sites_all --
8398: WHERE vendor_site_id = X_vendor_site_id;
8399: end if;
8400:
8401: if(x_invoice_match_option is NULL) then