Standard API for Supplier Sites (R11 i)

DECLARE
   CURSOR cur_suppsites_r11 (p_vendor_site_id NUMBER)
   IS
      SELECT pvsa.*, pvsa.ROWID
        FROM po_vendor_sites_all pvsa
       WHERE 1 = 1
       AND pvsa.vendor_site_id = p_vendor_site_id;
   v_date             DATE;
   v_itemkey          VARCHAR2 (100);
   v_vendor_site_id   NUMBER;
   v_user_id          NUMBER;
   v_resp_id          NUMBER;

BEGIN
   v_user_id := 7240; --fnd_profile.VALUE ('USER_ID');
   v_resp_id := 51683;--fnd_profile.VALUE ('RESP_ID');
   v_vendor_site_id := 37425;

   fnd_global.apps_initialize (user_id           => v_user_id,
                               resp_id           => v_resp_id,
                               resp_appl_id      => 200
                              );

   FOR v_site IN cur_suppsites_r11 (v_vendor_site_id)
   LOOP
      ap_vendor_sites_pkg.update_row
         (x_rowid                                => v_site.rowid,
          x_vendor_site_id                   => v_site.vendor_site_id,
          x_last_update_date               => v_site.last_update_date,
          x_last_updated_by                => v_site.last_updated_by,
          x_vendor_id                          => v_site.vendor_id,
          x_vendor_site_code              => v_site.vendor_site_code,
          x_last_update_login               => v_site.last_update_login,
          x_creation_date                     => v_site.creation_date,
          x_created_by                        => v_site.created_by,
          x_purchasing_site_flag           => v_site.purchasing_site_flag,
          x_rfq_only_site_flag              => v_site.rfq_only_site_flag,
          x_pay_site_flag                     => v_site.pay_site_flag,
          x_attention_ar_flag                => v_site.attention_ar_flag,
          x_address_line1                    => v_site.address_line1,
          x_address_line2                    => v_site.address_line2,
          x_address_line3                    => v_site.address_line3,
          x_city                                   => v_site.city,
          x_state                                 => v_site.state,
          x_zip                                    => v_site.zip,
          x_province                           => v_site.province,
          x_country                             => v_site.country,
          x_area_code                        => v_site.area_code,
          x_phone                               => v_site.phone,
          x_customer_num                  => v_site.customer_num,
          x_ship_to_location_id          => v_site.ship_to_location_id,
          x_bill_to_location_id           => v_site.bill_to_location_id,
          x_ship_via_lookup_code    => v_site.ship_via_lookup_code,
          x_freight_terms_lookup_code         => v_site.freight_terms_lookup_code,
          x_fob_lookup_code            => v_site.fob_lookup_code,
          x_inactive_date                   => v_date,
          x_fax                                  => v_site.fax,
          x_fax_area_code                => v_site.fax_area_code,
          x_telex                               => v_site.telex,
          x_payment_method_lookup_code        => v_site.payment_method_lookup_code,
          x_bank_account_name       => v_site.bank_account_name,
          x_bank_account_num         => v_site.bank_account_num,
          x_bank_num                      => v_site.bank_num,
          x_bank_account_type        => v_site.bank_account_type,
          x_terms_date_basis           => v_site.terms_date_basis,
          x_current_catalog_num      => v_site.current_catalog_num,
          x_vat_code                       => v_site.vat_code,
          x_distribution_set_id         => v_site.distribution_set_id,
          x_accts_pay_ccid             => v_site.accts_pay_code_combination_id,
          x_future_dated_payment_ccid         => v_site.future_dated_payment_ccid,
          x_prepay_code_combination_id        => v_site.prepay_code_combination_id,
          x_pay_group_lookup_code             => v_site.pay_group_lookup_code,
          x_payment_priority                  => v_site.payment_priority,
          x_terms_id                          => v_site.terms_id,
          x_invoice_amount_limit              => v_site.invoice_amount_limit,
          x_pay_date_basis_lookup_code        => v_site.pay_date_basis_lookup_code,
          x_always_take_disc_flag             => v_site.always_take_disc_flag,
          x_invoice_currency_code             => v_site.invoice_currency_code,
          x_payment_currency_code             => v_site.payment_currency_code,
          x_hold_all_payments_flag            => v_site.hold_all_payments_flag,
          x_hold_future_payments_flag         => v_site.hold_future_payments_flag,
          x_hold_reason                       => v_site.hold_reason,
          x_hold_unmatched_invoices_flag      => v_site.hold_unmatched_invoices_flag,
          x_match_option                      => v_site.match_option,
          x_create_debit_memo_flag            => v_site.create_debit_memo_flag,
          x_exclusive_payment_flag            => v_site.exclusive_payment_flag,
          x_tax_reporting_site_flag           => v_site.tax_reporting_site_flag,
          x_attribute_category                => v_site.attribute_category,
          x_attribute1                        => v_site.attribute1,
          x_attribute2                        => v_site.attribute2,
          x_attribute3                        => v_site.attribute3,
          x_attribute4                        => v_site.attribute4,
          x_attribute5                        => v_site.attribute5,
          x_attribute6                        => v_site.attribute6,
          x_attribute7                        => v_site.attribute7,
          x_attribute8                        => v_site.attribute8,
          x_attribute9                        => v_site.attribute9,
          x_attribute10                       => v_site.attribute10,
          x_attribute11                       => v_site.attribute11,
          x_attribute12                       => v_site.attribute12,
          x_attribute13                       => v_site.attribute13,
          x_attribute14                       => v_site.attribute14,
          x_attribute15                       => v_site.attribute15,
          x_validation_number                 => v_site.validation_number,
          x_exclude_freight_from_disc         => v_site.exclude_freight_from_discount,
          x_vat_registration_num              => v_site.vat_registration_num,
          x_offset_tax_flag                   => v_site.offset_tax_flag,
          x_check_digits                      => v_site.check_digits,
          x_bank_number                       => v_site.bank_number,
          x_address_line4                     => v_site.address_line4,
          x_county                            => v_site.county,
          x_address_style                     => v_site.address_style,
          x_language                          => v_site.LANGUAGE,
          x_allow_awt_flag                    => v_site.allow_awt_flag,
          x_awt_group_id                      => v_site.awt_group_id,
          x_pay_on_code                       => v_site.pay_on_code,
          x_default_pay_site_id               => v_site.default_pay_site_id,
          x_pay_on_receipt_summary_code       => v_site.pay_on_receipt_summary_code,
          x_bank_branch_type                  => v_site.bank_branch_type,
          x_edi_id_number                     => v_site.edi_id_number,
          x_edi_payment_method                => v_site.edi_payment_method,
          x_edi_payment_format                => v_site.edi_payment_format,
          x_edi_remittance_method             => v_site.edi_remittance_method,
          x_edi_remittance_instruction        => v_site.edi_remittance_instruction,
          x_edi_transaction_handling          => v_site.edi_transaction_handling,
          x_auto_tax_calc_flag                => v_site.auto_tax_calc_flag,
          x_auto_tax_calc_override            => v_site.auto_tax_calc_override,
          x_amount_includes_tax_flag          => v_site.amount_includes_tax_flag,
          x_ap_tax_rounding_rule              => v_site.ap_tax_rounding_rule,
          x_vendor_site_code_alt              => v_site.vendor_site_code_alt,
          x_address_lines_alt                 => v_site.address_lines_alt,
          x_global_attribute_category         => v_site.global_attribute_category,
          x_global_attribute1                 => v_site.global_attribute1,
          x_global_attribute2                 => v_site.global_attribute2,
          x_global_attribute3                 => v_site.global_attribute3,
          x_global_attribute4                 => v_site.global_attribute4,
          x_global_attribute5                 => v_site.global_attribute5,
          x_global_attribute6                 => v_site.global_attribute6,
          x_global_attribute7                 => v_site.global_attribute7,
          x_global_attribute8                 => v_site.global_attribute8,
          x_global_attribute9                 => v_site.global_attribute9,
          x_global_attribute10                => v_site.global_attribute10,
          x_global_attribute11                => v_site.global_attribute11,
          x_global_attribute12                => v_site.global_attribute12,
          x_global_attribute13                => v_site.global_attribute13,
          x_global_attribute14                => v_site.global_attribute14,
          x_global_attribute15                => v_site.global_attribute15,
          x_global_attribute16                => v_site.global_attribute16,
          x_global_attribute17                => v_site.global_attribute17,
          x_global_attribute18                => v_site.global_attribute18,
          x_global_attribute19                => v_site.global_attribute19,
          x_global_attribute20                => v_site.global_attribute20,
          x_bank_charge_bearer                => v_site.bank_charge_bearer,
          x_ece_tp_location_code              => v_site.ece_tp_location_code,
          x_pcard_site_flag                   => v_site.pcard_site_flag,
          x_country_of_origin_code            => v_site.country_of_origin_code,
          x_calling_sequence                  => NULL,
          x_shipping_location_id              => NULL,
          x_supplier_notif_method             => v_site.supplier_notif_method,
          x_email_address                     => 'anilmca02@gmail.com',
          x_remittance_email                  => v_site.remittance_email,
          x_primary_pay_site_flag             => v_site.primary_pay_site_flag,
          x_shipping_control                  => v_site.shipping_control,
          x_gapless_inv_num_flag              => v_site.gapless_inv_num_flag,
          x_selling_company_identifier        => v_site.selling_company_identifier,
          x_duns_number                       => v_site.duns_number,
          x_tolerance_id                      => v_site.tolerance_id
         );
   END LOOP;
   COMMIT;
END;