DBA Data[Home] [Help]

APPS.PO_SOURCING_PVT dependencies on PO_VENDORS

Line 140: (vendor_id PO_VENDORS.vendor_id%TYPE := null,

136: period_name GL_PERIOD_STATUSES.period_name%type);
137:
138: -- Type declaration for Vendor defaults structure
139: TYPE vendor_defaults_rec_type IS RECORD
140: (vendor_id PO_VENDORS.vendor_id%TYPE := null,
141: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have
142: -- been modified to point to PO_HEADERS_ALL type.
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,

Line 141: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have

137:
138: -- Type declaration for Vendor defaults structure
139: TYPE vendor_defaults_rec_type IS RECORD
140: (vendor_id PO_VENDORS.vendor_id%TYPE := null,
141: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have
142: -- been modified to point to PO_HEADERS_ALL type.
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,

Line 149: terms_id po_vendors.terms_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,
152: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
153: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,

Line 150: type_1099 PO_VENDORS.type_1099%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,
152: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
153: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
154: num_1099 PO_VENDORS.num_1099%TYPE := null,

Line 151: hold_flag PO_VENDORS.hold_flag%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,
152: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
153: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
154: num_1099 PO_VENDORS.num_1099%TYPE := null,
155: vat_registration_num NUMBER := null,

Line 152: invoice_currency_code PO_VENDORS.invoice_currency_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,
152: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
153: receipt_required_flag PO_VENDORS.receipt_required_flag%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,

Line 153: receipt_required_flag PO_VENDORS.receipt_required_flag%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,
152: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
153: receipt_required_flag PO_VENDORS.receipt_required_flag%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,

Line 154: num_1099 PO_VENDORS.num_1099%TYPE := null,

150: type_1099 PO_VENDORS.type_1099%TYPE := null,
151: hold_flag PO_VENDORS.hold_flag%TYPE := null,
152: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
153: receipt_required_flag PO_VENDORS.receipt_required_flag%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

Line 156: inspection_required_flag PO_VENDORS.inspection_required_flag%TYPE := null,

152: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
153: receipt_required_flag PO_VENDORS.receipt_required_flag%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:

Line 157: invoice_match_option PO_VENDORS.match_option%TYPE := null,

153: receipt_required_flag PO_VENDORS.receipt_required_flag%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

Line 369: PO_VENDORS_SV.get_vendor_info (

365: p_token => g_progress,
366: p_message => 'Before calling get_vendor_info');
367: END IF;
368:
369: PO_VENDORS_SV.get_vendor_info (
370: X_vendor_id => g_cpa_csr.vendor_id,
371: X_ship_to_location_id => g_vendor_default_rec.ship_to_location_id,
372: X_bill_to_location_id => g_vendor_default_rec.bill_to_location_id,
373: X_ship_via_lookup_code => l_ship_via_lookup_code,

Line 469: po_vendors_sv.val_freight_carrier(

465:
466: -- Defaulting the ship_via_lookup_code
467: IF g_cpa_csr.ship_via_lookup_code IS NULL THEN
468: if l_vs_ship_via_lookup_code is not null then
469: po_vendors_sv.val_freight_carrier(
470: X_temp_ship_via => l_vs_ship_via_lookup_code,
471: X_org_id => g_params_rec.inventory_organization_id,
472: X_res_ship_via => g_cpa_csr.ship_via_lookup_code
473: );

Line 477: po_vendors_sv.val_freight_carrier(

473: );
474: end if;
475: IF g_cpa_csr.ship_via_lookup_code IS NULL THEN
476: if l_ship_via_lookup_code is not null then
477: po_vendors_sv.val_freight_carrier(
478: X_temp_ship_via => l_ship_via_lookup_code,
479: X_org_id => g_params_rec.inventory_organization_id,
480: X_res_ship_via => g_cpa_csr.ship_via_lookup_code
481: );

Line 492: po_vendors_sv.val_fob(

488:
489: -- Defaulting the fob_lookup_code
490: IF g_cpa_csr.fob_lookup_code IS NULL THEN
491: if l_vs_fob_lookup_code is not null then
492: po_vendors_sv.val_fob(
493: X_temp_fob_lookup_code => l_vs_fob_lookup_code,
494: X_res_fob => g_cpa_csr.fob_lookup_code
495: );
496: end if;

Line 499: po_vendors_sv.val_fob(

495: );
496: end if;
497: IF g_cpa_csr.fob_lookup_code IS NULL THEN
498: if l_fob_lookup_code is not null then
499: po_vendors_sv.val_fob(
500: X_temp_fob_lookup_code => l_fob_lookup_code,
501: X_res_fob => g_cpa_csr.fob_lookup_code
502: );
503: end if;

Line 518: po_vendors_sv.val_freight_terms(

514:
515: -- Defaulting the freight_terms_lookup_code
516: IF g_cpa_csr.freight_terms_lookup_code IS NULL THEN
517: if l_vs_freight_lookup_code is not null then
518: po_vendors_sv.val_freight_terms(
519: X_temp_freight_terms => l_vs_freight_lookup_code,
520: X_res_freight_terms => g_cpa_csr.freight_terms_lookup_code
521: );
522: end if;

Line 525: po_vendors_sv.val_freight_terms(

521: );
522: end if;
523: IF g_cpa_csr.freight_terms_lookup_code IS NULL THEN
524: if l_freight_lookup_code is not null then
525: po_vendors_sv.val_freight_terms(
526: X_temp_freight_terms => l_freight_lookup_code,
527: X_res_freight_terms => g_cpa_csr.freight_terms_lookup_code
528: );
529: end if;