eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SOURCING_PVT dependencies on PO_VENDORS

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

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

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

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

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

Line 154: type_1099 PO_VENDORS.type_1099%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,
156: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
157: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
158: num_1099 PO_VENDORS.num_1099%TYPE := null,

Line 155: hold_flag PO_VENDORS.hold_flag%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,
156: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
157: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
158: num_1099 PO_VENDORS.num_1099%TYPE := null,
159: vat_registration_num PO_VENDORS.vat_registration_num%TYPE := NULL,

Line 156: invoice_currency_code PO_VENDORS.invoice_currency_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,
156: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
157: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
158: num_1099 PO_VENDORS.num_1099%TYPE := null,
159: vat_registration_num PO_VENDORS.vat_registration_num%TYPE := NULL,
160: /*Bug 10203569 the variable vat_registration_num was initially declared as number but

Line 157: receipt_required_flag PO_VENDORS.receipt_required_flag%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,
156: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
157: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
158: num_1099 PO_VENDORS.num_1099%TYPE := null,
159: vat_registration_num PO_VENDORS.vat_registration_num%TYPE := NULL,
160: /*Bug 10203569 the variable vat_registration_num was initially declared as number but
161: in the view po_vendors this variable is a varchar, hence ORA-06502: PL/SQL:

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

154: type_1099 PO_VENDORS.type_1099%TYPE := null,
155: hold_flag PO_VENDORS.hold_flag%TYPE := null,
156: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
157: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
158: num_1099 PO_VENDORS.num_1099%TYPE := null,
159: vat_registration_num PO_VENDORS.vat_registration_num%TYPE := NULL,
160: /*Bug 10203569 the variable vat_registration_num was initially declared as number but
161: in the view po_vendors this variable is a varchar, hence ORA-06502: PL/SQL:
162: numeric or value error: character to number conversion error. was encountered.

Line 159: vat_registration_num PO_VENDORS.vat_registration_num%TYPE := NULL,

155: hold_flag PO_VENDORS.hold_flag%TYPE := null,
156: invoice_currency_code PO_VENDORS.invoice_currency_code%TYPE := null,
157: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
158: num_1099 PO_VENDORS.num_1099%TYPE := null,
159: vat_registration_num PO_VENDORS.vat_registration_num%TYPE := NULL,
160: /*Bug 10203569 the variable vat_registration_num was initially declared as number but
161: in the view po_vendors this variable is a varchar, hence ORA-06502: PL/SQL:
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*/

Line 161: in the view po_vendors this variable is a varchar, hence ORA-06502: PL/SQL:

157: receipt_required_flag PO_VENDORS.receipt_required_flag%TYPE := null,
158: num_1099 PO_VENDORS.num_1099%TYPE := null,
159: vat_registration_num PO_VENDORS.vat_registration_num%TYPE := NULL,
160: /*Bug 10203569 the variable vat_registration_num was initially declared as number but
161: in the view po_vendors this variable is a varchar, hence ORA-06502: PL/SQL:
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,

Line 163: Changed the data type to PO_VENDORS.vat_registration_num%TYPE := NULL*/

159: vat_registration_num PO_VENDORS.vat_registration_num%TYPE := NULL,
160: /*Bug 10203569 the variable vat_registration_num was initially declared as number but
161: in the view po_vendors this variable is a varchar, hence ORA-06502: PL/SQL:
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: );

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

160: /*Bug 10203569 the variable vat_registration_num was initially declared as number but
161: in the view po_vendors this variable is a varchar, hence ORA-06502: PL/SQL:
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:

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

161: in the view po_vendors this variable is a varchar, hence ORA-06502: PL/SQL:
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

Line 383: PO_VENDORS_SV.get_vendor_info (

379: p_token => g_progress,
380: p_message => 'Before calling get_vendor_info');
381: END IF;
382:
383: PO_VENDORS_SV.get_vendor_info (
384: X_vendor_id => g_cpa_csr.vendor_id,
385: X_ship_to_location_id => g_vendor_default_rec.ship_to_location_id,
386: X_bill_to_location_id => g_vendor_default_rec.bill_to_location_id,
387: X_ship_via_lookup_code => l_ship_via_lookup_code,

Line 483: po_vendors_sv.val_freight_carrier(

479:
480: -- Defaulting the ship_via_lookup_code
481: IF g_cpa_csr.ship_via_lookup_code IS NULL THEN
482: if l_vs_ship_via_lookup_code is not null then
483: po_vendors_sv.val_freight_carrier(
484: X_temp_ship_via => l_vs_ship_via_lookup_code,
485: X_org_id => g_params_rec.inventory_organization_id,
486: X_res_ship_via => g_cpa_csr.ship_via_lookup_code
487: );

Line 491: po_vendors_sv.val_freight_carrier(

487: );
488: end if;
489: IF g_cpa_csr.ship_via_lookup_code IS NULL THEN
490: if l_ship_via_lookup_code is not null then
491: po_vendors_sv.val_freight_carrier(
492: X_temp_ship_via => l_ship_via_lookup_code,
493: X_org_id => g_params_rec.inventory_organization_id,
494: X_res_ship_via => g_cpa_csr.ship_via_lookup_code
495: );

Line 506: po_vendors_sv.val_fob(

502:
503: -- Defaulting the fob_lookup_code
504: IF g_cpa_csr.fob_lookup_code IS NULL THEN
505: if l_vs_fob_lookup_code is not null then
506: po_vendors_sv.val_fob(
507: X_temp_fob_lookup_code => l_vs_fob_lookup_code,
508: X_res_fob => g_cpa_csr.fob_lookup_code
509: );
510: end if;

Line 513: po_vendors_sv.val_fob(

509: );
510: end if;
511: IF g_cpa_csr.fob_lookup_code IS NULL THEN
512: if l_fob_lookup_code is not null then
513: po_vendors_sv.val_fob(
514: X_temp_fob_lookup_code => l_fob_lookup_code,
515: X_res_fob => g_cpa_csr.fob_lookup_code
516: );
517: end if;

Line 532: po_vendors_sv.val_freight_terms(

528:
529: -- Defaulting the freight_terms_lookup_code
530: IF g_cpa_csr.freight_terms_lookup_code IS NULL THEN
531: if l_vs_freight_lookup_code is not null then
532: po_vendors_sv.val_freight_terms(
533: X_temp_freight_terms => l_vs_freight_lookup_code,
534: X_res_freight_terms => g_cpa_csr.freight_terms_lookup_code
535: );
536: end if;

Line 539: po_vendors_sv.val_freight_terms(

535: );
536: end if;
537: IF g_cpa_csr.freight_terms_lookup_code IS NULL THEN
538: if l_freight_lookup_code is not null then
539: po_vendors_sv.val_freight_terms(
540: X_temp_freight_terms => l_freight_lookup_code,
541: X_res_freight_terms => g_cpa_csr.freight_terms_lookup_code
542: );
543: end if;