DBA Data[Home] [Help]

APPS.PO_SOURCING_PVT dependencies on PO_VENDOR_SITES

Line 147: pay_on_code PO_VENDOR_SITES_ALL.pay_on_code%TYPE := null,

143: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE := null,
144: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE := null,
145: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE := null,
146: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%TYPE := null,
147: pay_on_code PO_VENDOR_SITES_ALL.pay_on_code%TYPE := null,
148: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE := null,
149: terms_id po_vendors.terms_id%TYPE := null,
150: type_1099 PO_VENDORS.type_1099%TYPE := null,
151: hold_flag PO_VENDORS.hold_flag%TYPE := null,

Line 158: shipping_control PO_VENDOR_SITES.shipping_control%TYPE := NULL

154: num_1099 PO_VENDORS.num_1099%TYPE := null,
155: vat_registration_num NUMBER := null,
156: inspection_required_flag PO_VENDORS.inspection_required_flag%TYPE := null,
157: invoice_match_option PO_VENDORS.match_option%TYPE := null,
158: shipping_control PO_VENDOR_SITES.shipping_control%TYPE := NULL
159: );
160:
161: -- Type declaration for WHO information structure
162: TYPE who_rec_type IS RECORD

Line 396: -- po_vendor_sites_sv.get_vendor_site_info

392:
393: END IF;
394: -- Default the relevant vendor site information. You would then require this for
395: -- defaulting the pay_on_code , shipping_control using the procedure
396: -- po_vendor_sites_sv.get_vendor_site_info
397: IF(g_cpa_csr.vendor_site_id is not null) THEN
398: g_progress := '204';
399: IF g_debug_stmt THEN
400: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 405: PO_VENDOR_SITES_SV.get_vendor_site_info(

401: p_token => g_progress,
402: p_message => 'Before calling get_vendor_site_info');
403: END IF;
404:
405: PO_VENDOR_SITES_SV.get_vendor_site_info(
406: X_vendor_site_id => g_cpa_csr.vendor_site_id,
407: X_vs_ship_to_location_id => g_vendor_rec.ship_to_location_id,
408: X_vs_bill_to_location_id => g_vendor_rec.bill_to_location_id,
409: X_vs_ship_via_lookup_code => l_vs_ship_via_lookup_code,