The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Vendor_Site_Id IN OUT NOCOPY NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Vendor_Id NUMBER,
X_Vendor_Site_Code IN OUT NOCOPY VARCHAR2,
X_Last_Update_Login NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Purchasing_Site_Flag VARCHAR2,
X_Rfq_Only_Site_Flag VARCHAR2,
X_Pay_Site_Flag VARCHAR2,
X_Attention_Ar_Flag VARCHAR2,
X_Address_Line1 VARCHAR2,
X_Address_Line2 VARCHAR2,
X_Address_Line3 VARCHAR2,
X_City VARCHAR2,
X_State VARCHAR2,
X_Zip VARCHAR2,
X_Province VARCHAR2,
X_Country VARCHAR2,
X_Area_Code VARCHAR2,
X_Phone VARCHAR2,
X_Customer_Num VARCHAR2,
X_Ship_To_Location_Id NUMBER,
X_Bill_To_Location_Id NUMBER,
X_Ship_Via_Lookup_Code VARCHAR2,
X_Freight_Terms_Lookup_Code VARCHAR2,
X_Fob_Lookup_Code VARCHAR2,
X_Inactive_Date DATE,
X_Fax VARCHAR2,
X_Fax_Area_Code VARCHAR2,
X_Telex VARCHAR2,
--4552701 X_Payment_Method_Lookup_Code VARCHAR2,
X_Bank_Account_Name VARCHAR2,
X_Bank_Account_Num VARCHAR2,
X_Bank_Num VARCHAR2,
X_Bank_Account_Type VARCHAR2,
X_Terms_Date_Basis VARCHAR2,
X_Current_Catalog_Num VARCHAR2,
-- eTax Uptake X_Vat_Code VARCHAR2,
X_Distribution_Set_Id NUMBER,
X_Accts_Pay_CCID NUMBER,
X_Future_Dated_Payment_CCID NUMBER,
X_Prepay_Code_Combination_Id NUMBER,
X_Pay_Group_Lookup_Code VARCHAR2,
X_Payment_Priority NUMBER,
X_Terms_Id NUMBER,
X_Invoice_Amount_Limit NUMBER,
X_Pay_Date_Basis_Lookup_Code VARCHAR2,
X_Always_Take_Disc_Flag VARCHAR2,
X_Invoice_Currency_Code VARCHAR2,
X_Payment_Currency_Code VARCHAR2,
X_Hold_All_Payments_Flag VARCHAR2,
X_Hold_Future_Payments_Flag VARCHAR2,
X_Hold_Reason VARCHAR2,
X_Hold_Unmatched_Invoices_Flag VARCHAR2,
X_Match_Option VARCHAR2,
X_Create_Debit_Memo_Flag VARCHAR2,
--4552701 X_Exclusive_Payment_Flag VARCHAR2,
X_Tax_Reporting_Site_Flag VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Validation_Number NUMBER,
X_Exclude_Freight_From_Disc VARCHAR2,
X_Vat_Registration_Num VARCHAR2,
-- eTax Uptake X_Offset_Tax_Flag VARCHAR2,
X_Check_Digits VARCHAR2,
X_Bank_Number VARCHAR2,
X_Address_Line4 VARCHAR2,
X_County VARCHAR2,
X_Address_Style VARCHAR2,
X_Language VARCHAR2,
X_Allow_Awt_Flag VARCHAR2,
X_Awt_Group_Id NUMBER,
X_Pay_Awt_Group_Id NUMBER,--bug6664407
X_pay_on_code VARCHAR2,
X_default_pay_site_id NUMBER,
X_pay_on_receipt_summary_code VARCHAR2,
X_Bank_Branch_Type VARCHAR2,
X_EDI_ID_Number VARCHAR2, --Bug 7437549
/* 4552701
X_EDI_ID_Number VARCHAR2,
X_EDI_Payment_Method VARCHAR2,
X_EDI_Payment_Format VARCHAR2,
X_EDI_Remittance_Method VARCHAR2,
X_EDI_Remittance_Instruction VARCHAR2,
X_EDI_transaction_handling VARCHAR2,
eTax Uptake
X_Auto_Tax_Calc_Flag VARCHAR2,
X_Auto_Tax_Calc_Override VARCHAR2,
X_Amount_Includes_Tax_Flag VARCHAR2,
X_AP_Tax_Rounding_Rule VARCHAR2, */
X_Vendor_Site_Code_Alt VARCHAR2,
X_Address_Lines_Alt VARCHAR2,
X_global_attribute_category VARCHAR2 DEFAULT NULL,
X_global_attribute1 VARCHAR2 DEFAULT NULL,
X_global_attribute2 VARCHAR2 DEFAULT NULL,
X_global_attribute3 VARCHAR2 DEFAULT NULL,
X_global_attribute4 VARCHAR2 DEFAULT NULL,
X_global_attribute5 VARCHAR2 DEFAULT NULL,
X_global_attribute6 VARCHAR2 DEFAULT NULL,
X_global_attribute7 VARCHAR2 DEFAULT NULL,
X_global_attribute8 VARCHAR2 DEFAULT NULL,
X_global_attribute9 VARCHAR2 DEFAULT NULL,
X_global_attribute10 VARCHAR2 DEFAULT NULL,
X_global_attribute11 VARCHAR2 DEFAULT NULL,
X_global_attribute12 VARCHAR2 DEFAULT NULL,
X_global_attribute13 VARCHAR2 DEFAULT NULL,
X_global_attribute14 VARCHAR2 DEFAULT NULL,
X_global_attribute15 VARCHAR2 DEFAULT NULL,
X_global_attribute16 VARCHAR2 DEFAULT NULL,
X_global_attribute17 VARCHAR2 DEFAULT NULL,
X_global_attribute18 VARCHAR2 DEFAULT NULL,
X_global_attribute19 VARCHAR2 DEFAULT NULL,
X_global_attribute20 VARCHAR2 DEFAULT NULL,
X_Bank_Charge_Bearer VARCHAR2 DEFAULT NULL,
X_Ece_Tp_Location_Code VARCHAR2 DEFAULT NULL,
X_Pcard_Site_Flag VARCHAR2,
X_Country_of_Origin_Code VARCHAR2,
X_calling_sequence IN VARCHAR2,
X_Shipping_Location_id IN NUMBER,
X_Supplier_Notif_Method VARCHAR2, -- New Column
X_Email_Address VARCHAR2, -- New Column
--4552701 X_Remittance_email VARCHAR2 DEFAULT NULL,
X_Primary_pay_site_flag VARCHAR2 DEFAULT NULL,
--MO Access Control
X_Org_ID NUMBER DEFAULT mo_global.get_current_org_id
) IS
CURSOR C IS SELECT rowid
FROM po_vendor_sites
WHERE vendor_site_id = X_vendor_site_id;
current_calling_sequence := 'AP_VENDOR_SITES_PKG.INSERT_ROW<-' ||
X_calling_sequence;
debug_info := 'Select vendor site id for any other site with same site_code';
Select max(vendor_site_id)
into x_vendor_site_id
from po_vendor_sites_all
where vendor_id = x_vendor_id
and vendor_site_code = x_vendor_site_code; */
debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
Select PO_VENDOR_SITES_S.NEXTVAL
into x_vendor_site_id
from sys.dual;
debug_info := 'Insert values into PO_VENDOR_SITES';
INSERT INTO ap_supplier_sites_all(
vendor_site_id,
last_update_date,
last_updated_by,
vendor_id,
vendor_site_code,
last_update_login,
creation_date,
created_by,
purchasing_site_flag,
rfq_only_site_flag,
pay_site_flag,
attention_ar_flag,
address_line1,
address_line2,
address_line3,
city,
state,
zip,
province,
country,
area_code,
phone,
customer_num,
ship_to_location_id,
bill_to_location_id,
ship_via_lookup_code,
freight_terms_lookup_code,
fob_lookup_code,
inactive_date,
fax,
fax_area_code,
telex,
bank_account_name,
bank_account_num,
bank_num,
bank_account_type,
terms_date_basis,
current_catalog_num,
distribution_set_id,
accts_pay_code_combination_id,
future_dated_payment_ccid,
prepay_code_combination_id,
pay_group_lookup_code,
payment_priority,
terms_id,
invoice_amount_limit,
pay_date_basis_lookup_code,
always_take_disc_flag,
invoice_currency_code,
payment_currency_code,
hold_all_payments_flag,
hold_future_payments_flag,
hold_reason,
hold_unmatched_invoices_flag,
match_option,
create_debit_memo_flag,
tax_reporting_site_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
validation_number,
exclude_freight_from_discount,
vat_registration_num,
check_digits,
bank_number,
address_line4,
county,
address_style,
language,
allow_awt_flag,
awt_group_id,
pay_awt_group_id,--bug6664407
pay_on_code,
default_pay_site_id,
pay_on_receipt_summary_code,
Bank_Branch_Type,
vendor_site_code_alt,
address_lines_alt,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
Bank_charge_bearer,
Ece_Tp_Location_Code,
Country_of_Origin_Code,
Pcard_Site_Flag,
Supplier_Notif_Method, -- New Column
Email_Address, -- New Column
Primary_pay_site_flag ,
org_id, /* MO Access Control */
edi_id_number -- Bug 7437549
)
VALUES (
X_Vendor_Site_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Vendor_Id,
X_Vendor_Site_Code,
X_Last_Update_Login,
X_Creation_Date,
X_Created_By,
X_Purchasing_Site_Flag,
X_Rfq_Only_Site_Flag,
X_Pay_Site_Flag,
X_Attention_Ar_Flag,
X_Address_Line1,
X_Address_Line2,
X_Address_Line3,
X_City,
X_State,
X_Zip,
X_Province,
X_Country,
X_Area_Code,
X_Phone,
X_Customer_Num,
X_Ship_To_Location_Id,
X_Bill_To_Location_Id,
X_Ship_Via_Lookup_Code,
X_Freight_Terms_Lookup_Code,
X_Fob_Lookup_Code,
X_Inactive_Date,
X_Fax,
X_Fax_Area_Code,
X_Telex,
X_Bank_Account_Name,
X_Bank_Account_Num,
X_Bank_Num,
X_Bank_Account_Type,
X_Terms_Date_Basis,
X_Current_Catalog_Num,
X_Distribution_Set_Id,
X_Accts_Pay_CCID,
X_Future_Dated_Payment_CCID,
X_Prepay_Code_Combination_Id,
X_Pay_Group_Lookup_Code,
X_Payment_Priority,
X_Terms_Id,
X_Invoice_Amount_Limit,
X_Pay_Date_Basis_Lookup_Code,
X_Always_Take_Disc_Flag,
X_Invoice_Currency_Code,
X_Payment_Currency_Code,
X_Hold_All_Payments_Flag,
X_Hold_Future_Payments_Flag,
X_Hold_Reason,
X_Hold_Unmatched_Invoices_Flag,
X_Match_Option,
X_Create_Debit_Memo_Flag,
X_Tax_Reporting_Site_Flag,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Validation_Number,
X_Exclude_Freight_From_Disc,
X_Vat_Registration_Num,
X_Check_Digits,
X_Bank_Number,
X_Address_Line4,
X_County,
X_Address_Style,
X_Language,
X_Allow_Awt_Flag,
X_Awt_Group_Id,
X_Pay_Awt_Group_Id,--bug6664407
X_pay_on_code,
X_default_pay_site_id,
X_pay_on_receipt_summary_code,
X_Bank_Branch_Type,
X_Vendor_Site_Code_Alt,
X_Address_Lines_Alt,
X_global_attribute_category,
X_global_attribute1,
X_global_attribute2,
X_global_attribute3,
X_global_attribute4,
X_global_attribute5,
X_global_attribute6,
X_global_attribute7,
X_global_attribute8,
X_global_attribute9,
X_global_attribute10,
X_global_attribute11,
X_global_attribute12,
X_global_attribute13,
X_global_attribute14,
X_global_attribute15,
X_global_attribute16,
X_global_attribute17,
X_global_attribute18,
X_global_attribute19,
X_global_attribute20,
X_Bank_Charge_Bearer,
X_Ece_Tp_Location_Code,
X_Country_of_Origin_Code,
X_Pcard_Site_Flag,
X_Supplier_Notif_Method, -- New Column
X_Email_Address, -- New Column
X_Primary_pay_site_flag ,
X_org_id, /* MO Access Control */
X_EDI_ID_Number -- Bug 7437549
);
debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';
ap_po_locn_association_pkg.insert_row( p_location_id => X_Shipping_Location_id,
p_vendor_id => X_Vendor_Id,
p_vendor_site_id => X_Vendor_Site_Id,
p_last_update_date => X_Last_Update_Date,
p_last_updated_by => X_Last_Updated_By,
p_last_update_login => X_Last_Update_Login,
p_creation_date => X_Creation_Date,
p_created_by => X_Created_By,
p_org_id => X_Org_ID); --MO Access Control
END Insert_Row;
PROCEDURE Insert_Row(
p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
p_last_update_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER,
p_creation_date IN DATE,
p_created_by IN NUMBER,
p_request_id IN NUMBER,
p_program_application_id IN NUMBER,
p_program_id IN NUMBER,
p_program_update_date IN DATE,
x_rowid OUT NOCOPY VARCHAR2,
x_vendor_site_id OUT NOCOPY NUMBER
) IS
CURSOR C IS SELECT rowid
FROM po_vendor_sites
WHERE vendor_site_id = X_vendor_site_id;
debug_info := 'Select next vendor_site_id from PO_VENDOR_SITES_S sequence';
Select PO_VENDOR_SITES_S.NEXTVAL
into x_vendor_site_id
from sys.dual;
debug_info := 'Insert values into PO_VENDOR_SITES';
INSERT INTO ap_supplier_sites_all(
vendor_site_id,
last_update_date,
last_updated_by,
vendor_id,
vendor_site_code,
last_update_login,
creation_date,
created_by,
purchasing_site_flag,
rfq_only_site_flag,
pay_site_flag,
attention_ar_flag,
area_code,
phone,
customer_num,
ship_to_location_id,
bill_to_location_id,
ship_via_lookup_code,
freight_terms_lookup_code,
fob_lookup_code,
inactive_date,
fax,
fax_area_code,
telex,
terms_date_basis,
distribution_set_id,
accts_pay_code_combination_id,
future_dated_payment_ccid,
prepay_code_combination_id,
pay_group_lookup_code,
payment_priority,
terms_id,
invoice_amount_limit,
pay_date_basis_lookup_code,
always_take_disc_flag,
invoice_currency_code,
payment_currency_code,
hold_all_payments_flag,
hold_future_payments_flag,
hold_reason,
hold_unmatched_invoices_flag,
match_option,
create_debit_memo_flag,
tax_reporting_site_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
validation_number,
exclude_freight_from_discount,
check_digits,
allow_awt_flag,
awt_group_id,
pay_awt_group_id,--bug6664407
pay_on_code,
default_pay_site_id,
pay_on_receipt_summary_code,
vendor_site_code_alt,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
Bank_charge_bearer,
Ece_Tp_Location_Code,
Country_of_Origin_Code,
Pcard_Site_Flag,
Supplier_Notif_Method,
Email_Address,
Primary_pay_site_flag ,
org_id ,
location_id,
party_site_id,
tolerance_id,
retainage_rate,
shipping_control,
services_tolerance_id,
gapless_inv_num_flag,
selling_company_identifier,
duns_number, --bug6388041
vat_code, -- Bug 6645014
-- Bug 7300553 Start
address_line1,
address_line2,
address_line3,
address_line4,
city,
state,
zip,
province,
country,
county,
address_style,
language,
address_lines_alt,
-- Bug 7300553 End
edi_id_number, -- Bug 7437549
OFFSET_TAX_FLAG, -- Bug#7506443
AUTO_TAX_CALC_FLAG -- Bug#7506443
)
VALUES (
x_Vendor_Site_Id,
p_Last_Update_Date,
p_Last_Updated_By,
p_vendor_site_rec.Vendor_Id,
p_vendor_site_rec.Vendor_Site_Code,
p_Last_Update_Login,
p_Creation_Date,
p_Created_By,
p_vendor_site_rec.Purchasing_Site_Flag,
p_vendor_site_rec.Rfq_Only_Site_Flag,
p_vendor_site_rec.Pay_Site_Flag,
p_vendor_site_rec.Attention_Ar_Flag,
p_vendor_site_rec.Area_Code,
p_vendor_site_rec.Phone,
p_vendor_site_rec.Customer_Num,
p_vendor_site_rec.Ship_To_Location_Id,
p_vendor_site_rec.Bill_To_Location_Id,
p_vendor_site_rec.Ship_Via_Lookup_Code,
p_vendor_site_rec.Freight_Terms_Lookup_Code,
p_vendor_site_rec.Fob_Lookup_Code,
p_vendor_site_rec.Inactive_Date,
p_vendor_site_rec.Fax,
p_vendor_site_rec.Fax_area_code,
p_vendor_site_rec.Telex,
p_vendor_site_rec.Terms_Date_Basis,
p_vendor_site_rec.Distribution_Set_Id,
p_vendor_site_rec.Accts_Pay_Code_Combination_ID,
p_vendor_site_rec.Future_Dated_Payment_CCID,
p_vendor_site_rec.Prepay_Code_Combination_Id,
p_vendor_site_rec.Pay_Group_Lookup_Code,
p_vendor_site_rec.Payment_Priority,
p_vendor_site_rec.Terms_Id,
p_vendor_site_rec.Invoice_Amount_Limit,
p_vendor_site_rec.Pay_Date_Basis_Lookup_Code,
p_vendor_site_rec.Always_Take_Disc_Flag,
p_vendor_site_rec.Invoice_Currency_Code,
p_vendor_site_rec.Payment_Currency_Code,
p_vendor_site_rec.Hold_All_Payments_Flag,
p_vendor_site_rec.Hold_Future_Payments_Flag,
p_vendor_site_rec.Hold_Reason,
p_vendor_site_rec.Hold_Unmatched_Invoices_Flag,
p_vendor_site_rec.Match_Option,
p_vendor_site_rec.Create_Debit_Memo_Flag,
p_vendor_site_rec.Tax_Reporting_Site_Flag,
p_vendor_site_rec.Attribute_Category,
p_vendor_site_rec.Attribute1,
p_vendor_site_rec.Attribute2,
p_vendor_site_rec.Attribute3,
p_vendor_site_rec.Attribute4,
p_vendor_site_rec.Attribute5,
p_vendor_site_rec.Attribute6,
p_vendor_site_rec.Attribute7,
p_vendor_site_rec.Attribute8,
p_vendor_site_rec.Attribute9,
p_vendor_site_rec.Attribute10,
p_vendor_site_rec.Attribute11,
p_vendor_site_rec.Attribute12,
p_vendor_site_rec.Attribute13,
p_vendor_site_rec.Attribute14,
p_vendor_site_rec.Attribute15,
p_vendor_site_rec.Validation_Number,
p_vendor_site_rec.Exclude_Freight_From_Discount,
p_vendor_site_rec.Check_Digits,
p_vendor_site_rec.Allow_Awt_Flag,
p_vendor_site_rec.Awt_Group_Id,
p_vendor_site_rec.Pay_Awt_Group_Id,--bug6664407
p_vendor_site_rec.pay_on_code,
p_vendor_site_rec.default_pay_site_id,
p_vendor_site_rec.pay_on_receipt_summary_code,
p_vendor_site_rec.Vendor_Site_Code_Alt,
p_vendor_site_rec.global_attribute_category,
p_vendor_site_rec.global_attribute1,
p_vendor_site_rec.global_attribute2,
p_vendor_site_rec.global_attribute3,
p_vendor_site_rec.global_attribute4,
p_vendor_site_rec.global_attribute5,
p_vendor_site_rec.global_attribute6,
p_vendor_site_rec.global_attribute7,
p_vendor_site_rec.global_attribute8,
p_vendor_site_rec.global_attribute9,
p_vendor_site_rec.global_attribute10,
p_vendor_site_rec.global_attribute11,
p_vendor_site_rec.global_attribute12,
p_vendor_site_rec.global_attribute13,
p_vendor_site_rec.global_attribute14,
p_vendor_site_rec.global_attribute15,
p_vendor_site_rec.global_attribute16,
p_vendor_site_rec.global_attribute17,
p_vendor_site_rec.global_attribute18,
p_vendor_site_rec.global_attribute19,
p_vendor_site_rec.global_attribute20,
p_vendor_site_rec.Bank_Charge_Bearer,
p_vendor_site_rec.Ece_Tp_Location_Code,
p_vendor_site_rec.Country_of_Origin_Code,
p_vendor_site_rec.Pcard_Site_Flag,
p_vendor_site_rec.Supplier_Notif_Method,
p_vendor_site_rec.Email_Address,
p_vendor_site_rec.Primary_pay_site_flag ,
p_vendor_site_rec.org_id,
p_vendor_site_rec.location_id,
p_vendor_site_rec.party_site_id,
p_vendor_site_rec.tolerance_id,
p_vendor_site_rec.retainage_rate,
p_vendor_site_rec.shipping_control,
p_vendor_site_rec.services_tolerance_id,
p_vendor_site_rec.gapless_inv_num_flag,
p_vendor_site_rec.selling_company_identifier,
p_vendor_site_rec.duns_number, --bug6388041
p_vendor_site_rec.vat_code, -- bug 6645014
-- Bug 7300553 Start
p_vendor_site_rec.address_line1,
p_vendor_site_rec.address_line2,
p_vendor_site_rec.address_line3,
p_vendor_site_rec.address_line4,
p_vendor_site_rec.city,
p_vendor_site_rec.state,
p_vendor_site_rec.zip,
p_vendor_site_rec.province,
p_vendor_site_rec.country,
p_vendor_site_rec.county,
p_vendor_site_rec.address_style,
p_vendor_site_rec.language,
p_vendor_site_rec.address_lines_alt,
-- Bug 7300553 End
p_vendor_site_rec.edi_id_number, -- Bug 7437549
p_vendor_site_rec.offset_tax_flag, -- Bug#7506443
p_vendor_site_rec.auto_tax_calc_flag -- Bug#7506443
);
debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';
ap_po_locn_association_pkg.insert_row(
p_location_id => p_vendor_site_rec.Ship_to_Location_id,
p_vendor_id => p_vendor_site_rec.Vendor_Id,
p_vendor_site_id => x_Vendor_Site_Id,
p_last_update_date => p_Last_Update_Date,
p_last_updated_by => p_Last_Updated_By,
p_last_update_login => p_Last_Update_Login,
p_creation_date => p_Creation_Date,
p_created_by => p_Created_By,
p_org_id => p_vendor_site_rec.Org_ID); --MO Access Control
END Insert_Row;
SELECT *
FROM ap_supplier_sites
WHERE rowid = X_Rowid
FOR UPDATE of vendor_site_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
select address_style
into recinfo.address_style
from fnd_territories
where territory_code = x_country;
select location_id
into l_shipping_location_id
from po_location_associations
where vendor_site_id = X_Vendor_Site_Id;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Vendor_Site_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Vendor_Id NUMBER,
X_Vendor_Site_Code VARCHAR2,
X_Last_Update_Login NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Purchasing_Site_Flag VARCHAR2,
X_Rfq_Only_Site_Flag VARCHAR2,
X_Pay_Site_Flag VARCHAR2,
X_Attention_Ar_Flag VARCHAR2,
X_Address_Line1 VARCHAR2,
X_Address_Line2 VARCHAR2,
X_Address_Line3 VARCHAR2,
X_City VARCHAR2,
X_State VARCHAR2,
X_Zip VARCHAR2,
X_Province VARCHAR2,
X_Country VARCHAR2,
X_Area_Code VARCHAR2,
X_Phone VARCHAR2,
X_Customer_Num VARCHAR2,
X_Ship_To_Location_Id NUMBER,
X_Bill_To_Location_Id NUMBER,
X_Ship_Via_Lookup_Code VARCHAR2,
X_Freight_Terms_Lookup_Code VARCHAR2,
X_Fob_Lookup_Code VARCHAR2,
X_Inactive_Date DATE,
X_Fax VARCHAR2,
X_Fax_Area_Code VARCHAR2,
X_Telex VARCHAR2,
--4552701 X_Payment_Method_Lookup_Code VARCHAR2,
X_Bank_Account_Name VARCHAR2,
X_Bank_Account_Num VARCHAR2,
X_Bank_Num VARCHAR2,
X_Bank_Account_Type VARCHAR2,
X_Terms_Date_Basis VARCHAR2,
X_Current_Catalog_Num VARCHAR2,
-- eTax Uptake X_Vat_Code VARCHAR2,
X_Distribution_Set_Id NUMBER,
X_Accts_Pay_CCID NUMBER,
X_Future_Dated_Payment_CCID NUMBER,
X_Prepay_Code_Combination_Id NUMBER,
X_Pay_Group_Lookup_Code VARCHAR2,
X_Payment_Priority NUMBER,
X_Terms_Id NUMBER,
X_Invoice_Amount_Limit NUMBER,
X_Pay_Date_Basis_Lookup_Code VARCHAR2,
X_Always_Take_Disc_Flag VARCHAR2,
X_Invoice_Currency_Code VARCHAR2,
X_Payment_Currency_Code VARCHAR2,
X_Hold_All_Payments_Flag VARCHAR2,
X_Hold_Future_Payments_Flag VARCHAR2,
X_Hold_Reason VARCHAR2,
X_Hold_Unmatched_Invoices_Flag VARCHAR2,
X_Match_Option VARCHAR2,
X_Create_Debit_Memo_Flag VARCHAR2,
--4552701 X_Exclusive_Payment_Flag VARCHAR2,
X_Tax_Reporting_Site_Flag VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Validation_Number NUMBER,
X_Exclude_Freight_From_Disc VARCHAR2,
X_Vat_Registration_Num VARCHAR2,
-- eTax Uptake X_Offset_Tax_Flag VARCHAR2,
X_Check_Digits VARCHAR2,
X_Bank_Number VARCHAR2,
X_Address_Line4 VARCHAR2,
X_County VARCHAR2,
X_Address_Style VARCHAR2,
X_Language VARCHAR2,
X_Allow_Awt_Flag VARCHAR2,
X_Awt_Group_Id NUMBER,
X_Pay_Awt_Group_Id NUMBER,--bug6664407
X_pay_on_code VARCHAR2,
X_default_pay_site_id NUMBER,
X_pay_on_receipt_summary_code VARCHAR2,
X_Bank_Branch_Type VARCHAR2,
X_EDI_ID_Number VARCHAR2, --Bug 7437549
/* 4552701
X_EDI_ID_Number VARCHAR2,
X_EDI_Payment_Method VARCHAR2,
X_EDI_Payment_Format VARCHAR2,
X_EDI_Remittance_Method VARCHAR2,
X_EDI_Remittance_Instruction VARCHAR2,
X_EDI_transaction_handling VARCHAR2,
eTax Uptake
X_Auto_Tax_Calc_Flag VARCHAR2,
X_Auto_Tax_Calc_Override VARCHAR2,
X_Amount_Includes_Tax_Flag VARCHAR2,
X_AP_Tax_Rounding_Rule VARCHAR2, */
X_Vendor_Site_Code_Alt VARCHAR2,
X_Address_Lines_Alt VARCHAR2,
X_global_attribute_category VARCHAR2 DEFAULT NULL,
X_global_attribute1 VARCHAR2 DEFAULT NULL,
X_global_attribute2 VARCHAR2 DEFAULT NULL,
X_global_attribute3 VARCHAR2 DEFAULT NULL,
X_global_attribute4 VARCHAR2 DEFAULT NULL,
X_global_attribute5 VARCHAR2 DEFAULT NULL,
X_global_attribute6 VARCHAR2 DEFAULT NULL,
X_global_attribute7 VARCHAR2 DEFAULT NULL,
X_global_attribute8 VARCHAR2 DEFAULT NULL,
X_global_attribute9 VARCHAR2 DEFAULT NULL,
X_global_attribute10 VARCHAR2 DEFAULT NULL,
X_global_attribute11 VARCHAR2 DEFAULT NULL,
X_global_attribute12 VARCHAR2 DEFAULT NULL,
X_global_attribute13 VARCHAR2 DEFAULT NULL,
X_global_attribute14 VARCHAR2 DEFAULT NULL,
X_global_attribute15 VARCHAR2 DEFAULT NULL,
X_global_attribute16 VARCHAR2 DEFAULT NULL,
X_global_attribute17 VARCHAR2 DEFAULT NULL,
X_global_attribute18 VARCHAR2 DEFAULT NULL,
X_global_attribute19 VARCHAR2 DEFAULT NULL,
X_global_attribute20 VARCHAR2 DEFAULT NULL,
X_Bank_Charge_Bearer VARCHAR2 DEFAULT NULL,
X_Ece_Tp_Location_Code VARCHAR2 DEFAULT NULL,
X_Pcard_Site_Flag VARCHAR2,
X_Country_of_Origin_Code VARCHAR2,
X_calling_sequence IN VARCHAR2,
X_Shipping_Location_id IN NUMBER,
X_Supplier_Notif_Method VARCHAR2, -- New Column
X_Email_Address VARCHAR2, -- New Column
--4552701 X_Remittance_email VARCHAR2 DEFAULT NULL,
X_Primary_pay_site_flag VARCHAR2 DEFAULT NULL,
--MO Access Control
X_Org_ID NUMBER DEFAULT mo_global.get_current_org_id
) IS
current_calling_sequence varchar2(2000);
current_calling_sequence := 'AP_VENDOR_SITES_PKG.UPDATE_ROW<-' ||
X_calling_sequence;
/* select vendor_site_code
into vendor_site_old
from po_vendor_sites
where rowid = X_rowid;
select count(*)
into total_sites
from po_vendor_sites_all
where vendor_site_id = X_vendor_site_id;
debug_info := 'Update PO_VENDOR_SITES';
UPDATE ap_supplier_sites
SET
vendor_site_id = X_Vendor_Site_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
vendor_id = X_Vendor_Id,
vendor_site_code = X_Vendor_Site_Code,
last_update_login = X_Last_Update_Login,
purchasing_site_flag = X_Purchasing_Site_Flag,
rfq_only_site_flag = X_Rfq_Only_Site_Flag,
pay_site_flag = X_Pay_Site_Flag,
attention_ar_flag = X_Attention_Ar_Flag,
address_line1 = X_Address_Line1,
address_line2 = X_Address_Line2,
address_line3 = X_Address_Line3,
city = X_City,
state = X_State,
zip = X_Zip,
province = X_Province,
country = X_Country,
area_code = X_Area_Code,
phone = X_Phone,
customer_num = X_Customer_Num,
ship_to_location_id = X_Ship_To_Location_Id,
bill_to_location_id = X_Bill_To_Location_Id,
ship_via_lookup_code = X_Ship_Via_Lookup_Code,
freight_terms_lookup_code = X_Freight_Terms_Lookup_Code,
fob_lookup_code = X_Fob_Lookup_Code,
inactive_date = X_Inactive_Date,
fax = X_Fax,
fax_area_code = X_Fax_Area_Code,
telex = X_Telex,
bank_account_name = X_Bank_Account_Name,
bank_account_num = X_Bank_Account_Num,
bank_num = X_Bank_Num,
bank_account_type = X_Bank_Account_Type,
terms_date_basis = X_Terms_Date_Basis,
current_catalog_num = X_Current_Catalog_Num,
distribution_set_id = X_Distribution_Set_Id,
accts_pay_code_combination_id = X_Accts_Pay_CCID,
future_dated_payment_ccid = X_Future_Dated_Payment_CCID,
prepay_code_combination_id = X_Prepay_Code_Combination_Id,
pay_group_lookup_code = X_Pay_Group_Lookup_Code,
payment_priority = X_Payment_Priority,
terms_id = X_Terms_Id,
invoice_amount_limit = X_Invoice_Amount_Limit,
pay_date_basis_lookup_code = X_Pay_Date_Basis_Lookup_Code,
always_take_disc_flag = X_Always_Take_Disc_Flag,
invoice_currency_code = X_Invoice_Currency_Code,
payment_currency_code = X_Payment_Currency_Code,
hold_all_payments_flag = X_Hold_All_Payments_Flag,
hold_future_payments_flag = X_Hold_Future_Payments_Flag,
hold_reason = X_Hold_Reason,
hold_unmatched_invoices_flag = X_Hold_Unmatched_Invoices_Flag,
match_option = X_Match_Option,
create_debit_memo_flag = X_Create_Debit_Memo_Flag,
tax_reporting_site_flag = X_Tax_Reporting_Site_Flag,
attribute_category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
validation_number = X_Validation_Number,
exclude_freight_from_discount = X_Exclude_Freight_From_Disc,
vat_registration_num = X_Vat_Registration_Num,
check_digits = X_Check_Digits,
bank_number = X_Bank_Number,
address_line4 = X_Address_Line4,
county = X_County,
address_style = X_Address_Style,
language = X_Language,
allow_awt_flag = X_Allow_Awt_Flag,
awt_group_id = X_Awt_Group_Id,
pay_awt_group_id = X_Pay_Awt_Group_Id,--bug6664407
pay_on_code = X_pay_on_code,
default_pay_site_id = X_default_pay_site_id,
pay_on_receipt_summary_code = X_pay_on_receipt_summary_code,
Bank_Branch_Type = X_Bank_Branch_Type,
vendor_site_code_alt = X_Vendor_Site_Code_Alt,
address_lines_alt = X_Address_Lines_Alt,
global_attribute_category = X_global_attribute_category,
global_attribute1 = X_global_attribute1,
global_attribute2 = X_global_attribute2,
global_attribute3 = X_global_attribute3,
global_attribute4 = X_global_attribute4,
global_attribute5 = X_global_attribute5,
global_attribute6 = X_global_attribute6,
global_attribute7 = X_global_attribute7,
global_attribute8 = X_global_attribute8,
global_attribute9 = X_global_attribute9,
global_attribute10 = X_global_attribute10,
global_attribute11 = X_global_attribute11,
global_attribute12 = X_global_attribute12,
global_attribute13 = X_global_attribute13,
global_attribute14 = X_global_attribute14,
global_attribute15 = X_global_attribute15,
global_attribute16 = X_global_attribute16,
global_attribute17 = X_global_attribute17,
global_attribute18 = X_global_attribute18,
global_attribute19 = X_global_attribute19,
global_attribute20 = X_global_attribute20,
Bank_Charge_Bearer = X_Bank_Charge_Bearer,
Ece_Tp_Location_Code = X_Ece_Tp_Location_Code,
Country_of_Origin_Code = X_Country_of_Origin_Code,
Pcard_Site_Flag = X_Pcard_Site_Flag,
Supplier_Notif_Method = X_Supplier_Notif_Method, -- New Column
Email_Address = X_Email_Address, -- New Column
Primary_pay_site_flag = X_Primary_pay_site_flag,
Edi_id_number = X_EDI_ID_Number -- bug 7437549
WHERE rowid = X_Rowid;
debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';
ap_po_locn_association_pkg.update_row(p_location_id => X_Shipping_Location_id,
p_vendor_id => X_Vendor_Id,
p_vendor_site_id => X_Vendor_Site_Id,
p_last_update_date => X_Last_Update_Date,
p_last_updated_by => X_Last_Updated_By,
p_last_update_login => X_Last_Update_Login,
p_creation_date => X_Creation_Date,
p_created_by => X_Created_By,
p_org_id => X_Org_ID); --MO Access Control
END Update_Row;
PROCEDURE update_row(
p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
p_last_update_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER,
p_request_id IN NUMBER,
p_program_application_id IN NUMBER,
p_program_id IN NUMBER,
p_program_update_date IN DATE,
p_vendor_site_id IN NUMBER
) IS
current_calling_sequence varchar2(2000);
debug_info := 'Update PO_VENDOR_SITES';
IGI_CIS2007_UTIL_PKG.SUPPLIER_SITE_UPDATE(
p_vendor_id => p_vendor_site_rec.Vendor_Id,
p_vendor_site_id => p_vendor_site_id,
p_tax_grp_id => p_vendor_site_rec.Awt_Group_Id,
p_pay_tax_grp_id => p_vendor_site_rec.Pay_Awt_Group_Id
);
UPDATE ap_supplier_sites_all
SET
last_update_date = p_Last_Update_Date,
last_updated_by = p_Last_Updated_By,
vendor_id = p_vendor_site_rec.Vendor_Id,
vendor_site_code = p_vendor_site_rec.Vendor_Site_Code,
last_update_login = p_Last_Update_Login,
purchasing_site_flag = p_vendor_site_rec.Purchasing_Site_Flag,
rfq_only_site_flag = p_vendor_site_rec.Rfq_Only_Site_Flag,
pay_site_flag = p_vendor_site_rec.Pay_Site_Flag,
attention_ar_flag = p_vendor_site_rec.Attention_Ar_Flag,
area_code = p_vendor_site_rec.Area_Code,
phone = p_vendor_site_rec.Phone,
customer_num = p_vendor_site_rec.Customer_Num,
ship_to_location_id = p_vendor_site_rec.Ship_To_Location_Id,
bill_to_location_id = p_vendor_site_rec.Bill_To_Location_Id,
ship_via_lookup_code = p_vendor_site_rec.Ship_Via_Lookup_Code,
freight_terms_lookup_code = p_vendor_site_rec.Freight_Terms_Lookup_Code,
fob_lookup_code = p_vendor_site_rec.Fob_Lookup_Code,
inactive_date = p_vendor_site_rec.Inactive_Date,
fax = p_vendor_site_rec.Fax,
fax_area_code = p_vendor_site_rec.Fax_Area_Code,
telex = p_vendor_site_rec.Telex,
terms_date_basis = p_vendor_site_rec.Terms_Date_Basis,
distribution_set_id = p_vendor_site_rec.Distribution_Set_Id,
accts_pay_code_combination_id = p_vendor_site_rec.Accts_Pay_Code_Combination_ID,
future_dated_payment_ccid = p_vendor_site_rec.Future_Dated_Payment_CCID,
prepay_code_combination_id = p_vendor_site_rec.Prepay_Code_Combination_Id,
pay_group_lookup_code = p_vendor_site_rec.Pay_Group_Lookup_Code,
payment_priority = p_vendor_site_rec.Payment_Priority,
terms_id = p_vendor_site_rec.Terms_Id,
invoice_amount_limit = p_vendor_site_rec.Invoice_Amount_Limit,
pay_date_basis_lookup_code = p_vendor_site_rec.Pay_Date_Basis_Lookup_Code,
always_take_disc_flag = p_vendor_site_rec.Always_Take_Disc_Flag,
invoice_currency_code = p_vendor_site_rec.Invoice_Currency_Code,
payment_currency_code = p_vendor_site_rec.Payment_Currency_Code,
hold_all_payments_flag = p_vendor_site_rec.Hold_All_Payments_Flag,
hold_future_payments_flag = p_vendor_site_rec.Hold_Future_Payments_Flag,
hold_reason = p_vendor_site_rec.Hold_Reason,
hold_unmatched_invoices_flag = p_vendor_site_rec.Hold_Unmatched_Invoices_Flag,
match_option = p_vendor_site_rec.Match_Option,
create_debit_memo_flag = p_vendor_site_rec.Create_Debit_Memo_Flag,
tax_reporting_site_flag = p_vendor_site_rec.Tax_Reporting_Site_Flag,
attribute_category = p_vendor_site_rec.Attribute_Category,
attribute1 = p_vendor_site_rec.Attribute1,
attribute2 = p_vendor_site_rec.Attribute2,
attribute3 = p_vendor_site_rec.Attribute3,
attribute4 = p_vendor_site_rec.Attribute4,
attribute5 = p_vendor_site_rec.Attribute5,
attribute6 = p_vendor_site_rec.Attribute6,
attribute7 = p_vendor_site_rec.Attribute7,
attribute8 = p_vendor_site_rec.Attribute8,
attribute9 = p_vendor_site_rec.Attribute9,
attribute10 = p_vendor_site_rec.Attribute10,
attribute11 = p_vendor_site_rec.Attribute11,
attribute12 = p_vendor_site_rec.Attribute12,
attribute13 = p_vendor_site_rec.Attribute13,
attribute14 = p_vendor_site_rec.Attribute14,
attribute15 = p_vendor_site_rec.Attribute15,
validation_number = p_vendor_site_rec.Validation_Number,
exclude_freight_from_discount = p_vendor_site_rec.Exclude_Freight_From_Discount,
check_digits = p_vendor_site_rec.Check_Digits,
allow_awt_flag = p_vendor_site_rec.Allow_Awt_Flag,
awt_group_id = p_vendor_site_rec.Awt_Group_Id,
pay_awt_group_id = p_vendor_site_rec.Pay_Awt_Group_Id,--bug6664407
pay_on_code = p_vendor_site_rec.pay_on_code,
default_pay_site_id = p_vendor_site_rec.default_pay_site_id,
pay_on_receipt_summary_code = p_vendor_site_rec.pay_on_receipt_summary_code,
vendor_site_code_alt = p_vendor_site_rec.Vendor_Site_Code_Alt,
global_attribute_category = p_vendor_site_rec.global_attribute_category,
global_attribute1 = p_vendor_site_rec.global_attribute1,
global_attribute2 = p_vendor_site_rec.global_attribute2,
global_attribute3 = p_vendor_site_rec.global_attribute3,
global_attribute4 = p_vendor_site_rec.global_attribute4,
global_attribute5 = p_vendor_site_rec.global_attribute5,
global_attribute6 = p_vendor_site_rec.global_attribute6,
global_attribute7 = p_vendor_site_rec.global_attribute7,
global_attribute8 = p_vendor_site_rec.global_attribute8,
global_attribute9 = p_vendor_site_rec.global_attribute9,
global_attribute10 = p_vendor_site_rec.global_attribute10,
global_attribute11 = p_vendor_site_rec.global_attribute11,
global_attribute12 = p_vendor_site_rec.global_attribute12,
global_attribute13 = p_vendor_site_rec.global_attribute13,
global_attribute14 = p_vendor_site_rec.global_attribute14,
global_attribute15 = p_vendor_site_rec.global_attribute15,
global_attribute16 = p_vendor_site_rec.global_attribute16,
global_attribute17 = p_vendor_site_rec.global_attribute17,
global_attribute18 = p_vendor_site_rec.global_attribute18,
global_attribute19 = p_vendor_site_rec.global_attribute19,
global_attribute20 = p_vendor_site_rec.global_attribute20,
Bank_Charge_Bearer = p_vendor_site_rec.Bank_Charge_Bearer,
Ece_Tp_Location_Code = p_vendor_site_rec.Ece_Tp_Location_Code,
Country_of_Origin_Code = p_vendor_site_rec.Country_of_Origin_Code,
Pcard_Site_Flag = p_vendor_site_rec.Pcard_Site_Flag,
Supplier_Notif_Method = p_vendor_site_rec.Supplier_Notif_Method,
Email_Address = p_vendor_site_rec.Email_Address,
Primary_pay_site_flag = p_vendor_site_rec.Primary_pay_site_flag,
Location_Id = p_vendor_site_rec.location_id,
Party_Site_ID = p_vendor_site_rec.party_site_id,
Tolerance_Id = p_vendor_site_rec.tolerance_id,
Retainage_Rate = p_vendor_site_rec.retainage_rate,
Shipping_Control = p_vendor_site_rec.shipping_control,
services_tolerance_id = p_vendor_site_rec.services_tolerance_id,
gapless_inv_num_flag = p_vendor_site_rec.gapless_inv_num_flag,
selling_company_identifier = p_vendor_site_rec.selling_company_identifier,
duns_number = p_vendor_site_rec.duns_number, --bug6388041
-- Bug 7300553 Start
address_line1 = p_vendor_site_rec.address_line1,
address_line2 = p_vendor_site_rec.address_line2,
address_line3 = p_vendor_site_rec.address_line3,
address_line4 = p_vendor_site_rec.address_line4,
city = p_vendor_site_rec.city,
state = p_vendor_site_rec.state,
zip = p_vendor_site_rec.zip,
province = p_vendor_site_rec.province,
country = p_vendor_site_rec.country,
county = p_vendor_site_rec.county,
address_style = p_vendor_site_rec.address_style,
language = p_vendor_site_rec.language,
address_lines_alt = p_vendor_site_rec.address_lines_alt,
-- Bug 7300553 End
edi_id_number = p_vendor_site_rec.edi_id_number -- bug 7437549
WHERE vendor_site_id = p_vendor_site_id;
debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';
ap_po_locn_association_pkg.update_row(
p_location_id => p_vendor_site_rec.Shipping_Location_id,
/* 5945837: Shipping_Location_id is stored in po_location_associations*/
p_vendor_id => p_vendor_site_rec.Vendor_Id,
p_vendor_site_id => P_Vendor_Site_Id,
p_last_update_date => p_Last_Update_Date,
p_last_updated_by => p_Last_Updated_By,
p_last_update_login => p_Last_Update_Login,
p_creation_date => sysdate,
p_created_by => -1,
p_org_id => p_vendor_site_rec.Org_ID);
END Update_Row;
SELECT count(1)
INTO l_offset_count
FROM ap_supplier_sites
WHERE vendor_id = x_vendor_id
AND nvl(offset_tax_flag, 'N') <> 'N';
SELECT count(1)
INTO L_Duplicate_count
FROM po_vendor_sites
WHERE (rowid <> x_rowid or x_rowid IS NULL)
AND vendor_id = x_vendor_id
AND UPPER(vendor_site_code) = UPPER(x_vendor_site_code)
AND nvl(org_id,-99) = nvl(x_org_id,-99); --MO Access Control
SELECT count(1)
INTO L_Multiple_count
FROM ap_supplier_sites
WHERE vendor_id = x_vendor_id
AND tax_reporting_site_flag = 'Y'
AND vendor_site_id <> nvl(x_vendor_site_id,-999)
AND nvl(org_id,-99) = nvl(x_org_id,-99); --MO Access Control
SELECT count(1)
INTO L_overlap_count
FROM po_vendor_sites
WHERE vendor_id = x_vendor_id
AND (invoice_currency_code <> x_Base_Currency_Code
OR invoice_currency_code IS NULL);
SELECT vendor_site_code
INTO x_vendor_site_code
FROM po_vendor_sites_all
WHERE vendor_id = x_vendor_id
AND nvl(org_id,-99) = nvl(x_org_id,-99)
AND Tax_Reporting_Site_Flag = 'Y';
SELECT count(1)
INTO L_Return_Count
FROM po_vendor_sites
WHERE vendor_id = x_vendor_id
AND country = 'US'
AND nvl(state,'99') not in (SELECT region_short_name
FROM AP_income_tax_regions);
SELECT count(1)
INTO L_Duplicate_count
FROM po_vendor_sites
WHERE (rowid <> x_rowid or x_rowid IS NULL)
AND vendor_id = x_vendor_id
AND UPPER(ece_tp_location_code) = UPPER(x_ece_tp_location_code)
--MO Access Control
AND nvl(org_id,-99) = nvl(x_org_id,-99);