APPS.PO_MULTI_MOD_PVT dependencies on PO_VENDOR_SITES_ALL

Line 1571: l_fax_area po_vendor_sites_all.FAX_AREA_CODE%type;

1567: d_api_name CONSTANT VARCHAR2(30) := 'FETCH_SUPPLIER_COMM_DEFAULTS';
1568: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1569: d_position NUMBER;
1570:
1571: l_fax_area po_vendor_sites_all.FAX_AREA_CODE%type;
1572: l_faxnum varchar2(30);
1573: l_po_comm_email_default VARCHAR2(10);
1574:
1575:

Line 1625: po_vendor_sites_all pvs

1621: BEGIN
1622: SELECT etd.edi_flag
1623: INTO x_edi_flag
1624: FROM ece_tp_details etd,
1625: po_vendor_sites_all pvs
1626: WHERE pvs.tp_header_id = etd.tp_header_id
1627: AND etd.document_id = 'POO'
1628: AND pvs.vendor_site_id = p_vendor_site_id
1629: AND etd.document_type = p_doc_sub_type;

Line 1647: FROM po_vendor_sites_all

1643: INTO x_default_method,
1644: x_email_address,
1645: l_fax_area,
1646: l_faxnum
1647: FROM po_vendor_sites_all
1648: WHERE vendor_site_id = p_vendor_site_id;
1649:
1650: -- Check Contact-level defaults only if Contact exists
1651: IF p_vendor_contact_id IS NOT NULL THEN

Line 2217: --Get the new denormalized Supplier Site name from PO_VENDOR_SITES_ALL and Supplier Name from PO_VENDORS_ALL

2213: debug(d_module, d_position, 'l_new_remit_to_addr: '||l_new_remit_to_addr);
2214:
2215: --Get the default values for Supplier Site/Contact dependent attributes (including the two Denormalized Name Attrs)
2216:
2217: --Get the new denormalized Supplier Site name from PO_VENDOR_SITES_ALL and Supplier Name from PO_VENDORS_ALL
2218: SELECT vendor_site_code
2219: INTO l_new_vendor_site_name
2220: FROM po_vendor_sites_all
2221: WHERE vendor_site_id = l_new_vendor_site_id;

Line 2220: FROM po_vendor_sites_all

2216:
2217: --Get the new denormalized Supplier Site name from PO_VENDOR_SITES_ALL and Supplier Name from PO_VENDORS_ALL
2218: SELECT vendor_site_code
2219: INTO l_new_vendor_site_name
2220: FROM po_vendor_sites_all
2221: WHERE vendor_site_id = l_new_vendor_site_id;
2222:
2223: d_position := 65;
2224: debug(d_module, d_position, 'Calling fetch_supplier_comm_defaults API to fetch Supplier communication defaults', FND_API.G_TRUE);