APPS.RCV_824_SV dependencies on PO_VENDOR_SITES

Line 69: x_entity_address1 po_vendor_sites.address_line1%type := null;

65: x_document_code varchar2(25) := null;
66: x_entity_code varchar2(30) := null;
67: x_entity_name varchar2(80) := null;
68: --
69: x_entity_address1 po_vendor_sites.address_line1%type := null;
70: x_entity_address2 po_vendor_sites.address_line2%type := null;
71: x_entity_address3 po_vendor_sites.address_line3%type := null;
72: x_entity_address4 varchar2(60) := null;
73: x_entity_city varchar2(30) := null;

Line 70: x_entity_address2 po_vendor_sites.address_line2%type := null;

66: x_entity_code varchar2(30) := null;
67: x_entity_name varchar2(80) := null;
68: --
69: x_entity_address1 po_vendor_sites.address_line1%type := null;
70: x_entity_address2 po_vendor_sites.address_line2%type := null;
71: x_entity_address3 po_vendor_sites.address_line3%type := null;
72: x_entity_address4 varchar2(60) := null;
73: x_entity_city varchar2(30) := null;
74: x_entity_postal_code varchar2(30) := null;

Line 71: x_entity_address3 po_vendor_sites.address_line3%type := null;

67: x_entity_name varchar2(80) := null;
68: --
69: x_entity_address1 po_vendor_sites.address_line1%type := null;
70: x_entity_address2 po_vendor_sites.address_line2%type := null;
71: x_entity_address3 po_vendor_sites.address_line3%type := null;
72: x_entity_address4 varchar2(60) := null;
73: x_entity_city varchar2(30) := null;
74: x_entity_postal_code varchar2(30) := null;
75: x_entity_country po_vendor_sites.country%type := null;

Line 75: x_entity_country po_vendor_sites.country%type := null;

71: x_entity_address3 po_vendor_sites.address_line3%type := null;
72: x_entity_address4 varchar2(60) := null;
73: x_entity_city varchar2(30) := null;
74: x_entity_postal_code varchar2(30) := null;
75: x_entity_country po_vendor_sites.country%type := null;
76: x_entity_state po_vendor_sites.state%type := null;
77: x_entity_province po_vendor_sites.province%type := null;
78: x_entity_county varchar2(30) := null;
79: --

Line 76: x_entity_state po_vendor_sites.state%type := null;

72: x_entity_address4 varchar2(60) := null;
73: x_entity_city varchar2(30) := null;
74: x_entity_postal_code varchar2(30) := null;
75: x_entity_country po_vendor_sites.country%type := null;
76: x_entity_state po_vendor_sites.state%type := null;
77: x_entity_province po_vendor_sites.province%type := null;
78: x_entity_county varchar2(30) := null;
79: --
80: x_external_reference_1 varchar2(30) := null;

Line 77: x_entity_province po_vendor_sites.province%type := null;

73: x_entity_city varchar2(30) := null;
74: x_entity_postal_code varchar2(30) := null;
75: x_entity_country po_vendor_sites.country%type := null;
76: x_entity_state po_vendor_sites.state%type := null;
77: x_entity_province po_vendor_sites.province%type := null;
78: x_entity_county varchar2(30) := null;
79: --
80: x_external_reference_1 varchar2(30) := null;
81: x_external_reference_2 varchar2(30) := null;

Line 136: from po_vendor_sites where po_vendor_sites.vendor_site_id = X_interface_header.header_record.vendor_site_id;

132: city, zip, country, state, province, ece_tp_location_code
133: into x_tp_header_id, x_entity_address1, x_entity_address2, x_entity_address3,
134: x_entity_city, x_entity_postal_code, x_entity_country, x_entity_state,
135: x_entity_province, x_tp_location_code
136: from po_vendor_sites where po_vendor_sites.vendor_site_id = X_interface_header.header_record.vendor_site_id;
137:
138: asn_debug.put_line('TP header id ' || to_char(x_tp_header_id));
139:
140: exception