[Home] [Help]
147: ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE := null,
148: bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE := null,
149: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE := null,
150: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%TYPE := null,
151: pay_on_code PO_VENDOR_SITES_ALL.pay_on_code%TYPE := null,
152: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%TYPE := null,
153: terms_id po_vendors.terms_id%TYPE := null,
154: type_1099 PO_VENDORS.type_1099%TYPE := null,
155: hold_flag PO_VENDORS.hold_flag%TYPE := null,
162: numeric or value error: character to number conversion error. was encountered.
163: Changed the data type to PO_VENDORS.vat_registration_num%TYPE := NULL*/
164: inspection_required_flag PO_VENDORS.inspection_required_flag%TYPE := null,
165: invoice_match_option PO_VENDORS.match_option%TYPE := null,
166: shipping_control PO_VENDOR_SITES.shipping_control%TYPE := NULL
167: );
168:
169: -- Type declaration for WHO information structure
170: TYPE who_rec_type IS RECORD
406:
407: END IF;
408: -- Default the relevant vendor site information. You would then require this for
409: -- defaulting the pay_on_code , shipping_control using the procedure
410: -- po_vendor_sites_sv.get_vendor_site_info
411: IF(g_cpa_csr.vendor_site_id is not null) THEN
412: g_progress := '204';
413: IF g_debug_stmt THEN
414: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
415: p_token => g_progress,
416: p_message => 'Before calling get_vendor_site_info');
417: END IF;
418:
419: PO_VENDOR_SITES_SV.get_vendor_site_info(
420: X_vendor_site_id => g_cpa_csr.vendor_site_id,
421: X_vs_ship_to_location_id => g_vendor_rec.ship_to_location_id,
422: X_vs_bill_to_location_id => g_vendor_rec.bill_to_location_id,
423: X_vs_ship_via_lookup_code => l_vs_ship_via_lookup_code,