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.POS_VENDOR_PUB_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 178


   pos_log.log_field('last_update_date', p_vendor_site_rec.last_update_date);

Line: 179


   pos_log.log_field('last_updated_by', p_vendor_site_rec.last_updated_by);

Line: 298


	SELECT organization_id
	  FROM hr_operating_units m
	     , financials_system_params_all fspa
	     , ap_system_parameters_all aspa
	     , po_system_parameters_all pspa
         WHERE m.organization_id = fspa.org_id
           AND m.organization_id = aspa.org_id
	   AND m.organization_id = pspa.org_id
	   AND mo_global.check_access(m.organization_id) = 'Y' ;

Line: 328


    select count(*)
    into l_count
    from ap_suppliers
    where upper(vendor_name) like upper(p_vendor_name)
    AND nvl(VENDOR_TYPE_LOOKUP_CODE,'nonemp') <> 'EMPLOYEE';

Line: 344


    select nls_language
    from fnd_languages_vl
    where language_code = p_language_code;

Line: 393


    select  count(*)
    into l_count
    from ap_supplier_sites_all
    where org_id = l_org_id
    and primary_pay_site_flag = l_primary_pay_flag
    and vendor_id = p_vendor_site_rec.vendor_id
    and vendor_site_id <> l_vendor_site_id
    and ( inactive_date is null or inactive_date > sysdate );

Line: 409


    select  vendor_site_code
    into l_vendor_site_code
    from ap_supplier_sites_all
    where org_id = l_org_id
    and primary_pay_site_flag = l_primary_pay_flag
    and vendor_id = p_vendor_site_rec.vendor_id
    and vendor_site_id <> l_vendor_site_id
    and ( inactive_date is null or inactive_date > sysdate )
    and rownum = 1;

Line: 484


   select segment1, vendor_name, party_id, vendor_id
   INTO l_segment1, l_vendor_name, l_party_id, l_vendor_id
   from ap_suppliers
   where upper(vendor_name) like upper(p_vendor_rec.vendor_name);

Line: 590


PROCEDURE Update_Vendor
( p_vendor_rec      IN  AP_VENDOR_PUB_PKG.r_vendor_rec_type,
  x_return_status   OUT NOCOPY VARCHAR2,
  x_msg_count       OUT NOCOPY NUMBER,
  x_msg_data        OUT NOCOPY VARCHAR2
) IS
   l_step VARCHAR2(100);

Line: 601


                      , 'Enter Update Vendor Procedure'
                      );

Line: 607


   log_vendor_rec (p_vendor_rec, 'update vendor');

Line: 609


   l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor';

Line: 612


   AP_VENDOR_PUB_PKG.Update_Vendor
     (  p_api_version           => 1.0,
        p_init_msg_list         => FND_API.G_TRUE,
        p_commit                => FND_API.G_FALSE,
        p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
        x_return_status         => x_return_status,
        x_msg_count             => x_msg_count,
        x_msg_data              => x_msg_data,
        p_vendor_rec            => p_vendor_rec,
        p_vendor_id             => p_vendor_rec.vendor_id
        );

Line: 648


END Update_Vendor;

Line: 743


	SELECT phone_area_code,
	       phone_number
	  FROM hz_contact_points
	 WHERE owner_table_name = 'HZ_PARTY_SITES'
           AND owner_table_id = p_party_site_id
           AND contact_point_type = 'PHONE'
           AND phone_line_type = 'GEN'
           AND primary_flag = 'Y'
           AND status = 'A' ;

Line: 754


	SELECT phone_area_code fax_area_code,
	       phone_number fax_number
	  FROM hz_contact_points
	 WHERE owner_table_name = 'HZ_PARTY_SITES'
           AND owner_table_id = p_party_site_id
           AND contact_point_type = 'PHONE'
           AND phone_line_type = 'FAX'
	   AND status = 'A' ;

Line: 764


	SELECT email_address
	  FROM hz_contact_points
	 WHERE owner_table_name = 'HZ_PARTY_SITES'
           AND owner_table_id = p_party_site_id
           AND contact_point_type = 'EMAIL'
           AND primary_flag = 'Y'
           AND status = 'A' ;

Line: 905


PROCEDURE Update_Vendor_Site
( p_vendor_site_rec IN  AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
  x_return_status   OUT NOCOPY VARCHAR2,
  x_msg_count       OUT NOCOPY NUMBER,
  x_msg_data        OUT NOCOPY VARCHAR2
  ) IS
     l_step VARCHAR2(100);

Line: 916


                      , 'Enter Update_Vendor_Site Procedure'
                      );

Line: 922


   log_vendor_site_rec (p_vendor_site_rec, 'update vendor site');

Line: 945


   l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor_Site';

Line: 946


   AP_VENDOR_PUB_PKG.Update_Vendor_Site
     (  p_api_version           => 1.0,
        p_init_msg_list         => FND_API.G_TRUE,
        p_commit                => FND_API.G_FALSE,
        p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
        x_return_status         => x_return_status,
        x_msg_count             => x_msg_count,
        x_msg_data              => x_msg_data,
        p_vendor_site_rec       => p_vendor_site_rec,
        p_vendor_site_id        => p_vendor_site_rec.vendor_site_id
        );

Line: 981


END Update_Vendor_Site;

Line: 1431


PROCEDURE Update_Vendor
(
  p_vendor_id                       IN  NUMBER   ,
  p_segment1                        IN  VARCHAR2 ,
  p_vendor_name                     IN  VARCHAR2 ,
  p_vendor_name_alt                 IN  VARCHAR2 ,
  p_summary_flag                    IN  VARCHAR2 ,
  p_enabled_flag                    IN  VARCHAR2 ,
  p_segment2                        IN  VARCHAR2 ,
  p_segment3                        IN  VARCHAR2 ,
  p_segment4                        IN  VARCHAR2 ,
  p_segment5                        IN  VARCHAR2 ,
  p_employee_id                     IN  NUMBER   ,
  p_vendor_type_lookup_code         IN  VARCHAR2 ,
  p_customer_num                    IN  VARCHAR2 ,
  p_one_time_flag                   IN  VARCHAR2 ,
  p_parent_vendor_id                IN  NUMBER   ,
  p_min_order_amount                IN  NUMBER   ,
  p_terms_id                        IN  NUMBER   ,
  p_set_of_books_id                 IN  NUMBER   ,
  p_always_take_disc_flag           IN  VARCHAR2 ,
  p_pay_date_basis_lookup_code      IN  VARCHAR2 ,
  p_pay_group_lookup_code           IN  VARCHAR2 ,
  p_payment_priority                IN  NUMBER   ,
  p_invoice_currency_code           IN  VARCHAR2 ,
  p_payment_currency_code           IN  VARCHAR2 ,
  p_invoice_amount_limit            IN  NUMBER   ,
  p_hold_all_payments_flag          IN  VARCHAR2 ,
  p_hold_future_payments_flag       IN  VARCHAR2 ,
  p_hold_reason                     IN  VARCHAR2 ,
  p_type_1099                       IN  VARCHAR2 ,
  p_withhold_status_lookup_code     IN  VARCHAR2 ,
  p_withholding_start_date          IN  DATE     ,
  p_org_type_lookup_code            IN  VARCHAR2 ,
  p_start_date_active               IN  DATE     ,
  p_end_date_active                 IN  DATE     ,
  p_minority_group_lookup_code      IN  VARCHAR2 ,
  p_women_owned_flag                IN  VARCHAR2 ,
  p_small_business_flag             IN  VARCHAR2 ,
  p_hold_flag                       IN  VARCHAR2 ,
  p_purchasing_hold_reason          IN  VARCHAR2 ,
  p_hold_by                         IN  NUMBER   ,
  p_hold_date                       IN  DATE     ,
  p_terms_date_basis                IN  VARCHAR2 ,
  p_inspection_required_flag        IN  VARCHAR2 ,
  p_receipt_required_flag           IN  VARCHAR2 ,
  p_qty_rcv_tolerance               IN  NUMBER   ,
  p_qty_rcv_exception_code          IN  VARCHAR2 ,
  p_enforce_ship_to_loc_code        IN  VARCHAR2 ,
  p_days_early_receipt_allowed      IN  NUMBER   ,
  p_days_late_receipt_allowed       IN  NUMBER   ,
  p_receipt_days_exception_code     IN  VARCHAR2 ,
  p_receiving_routing_id            IN  NUMBER   ,
  p_allow_substi_receipts_flag      IN  VARCHAR2 ,
  p_allow_unorder_receipts_flag     IN  VARCHAR2 ,
  p_hold_unmatched_invoices_flag    IN  VARCHAR2 ,
  p_tax_verification_date           IN  DATE     ,
  p_name_control                    IN  VARCHAR2 ,
  p_state_reportable_flag           IN  VARCHAR2 ,
  p_federal_reportable_flag         IN  VARCHAR2 ,
  p_attribute_category              IN  VARCHAR2 ,
  p_attribute1                      IN  VARCHAR2 ,
  p_attribute2                      IN  VARCHAR2 ,
  p_attribute3                      IN  VARCHAR2 ,
  p_attribute4                      IN  VARCHAR2 ,
  p_attribute5                      IN  VARCHAR2 ,
  p_attribute6                      IN  VARCHAR2 ,
  p_attribute7                      IN  VARCHAR2 ,
  p_attribute8                      IN  VARCHAR2 ,
  p_attribute9                      IN  VARCHAR2 ,
  p_attribute10                     IN  VARCHAR2 ,
  p_attribute11                     IN  VARCHAR2 ,
  p_attribute12                     IN  VARCHAR2 ,
  p_attribute13                     IN  VARCHAR2 ,
  p_attribute14                     IN  VARCHAR2 ,
  p_attribute15                     IN  VARCHAR2 ,
  p_auto_calculate_interest_flag    IN  VARCHAR2 ,
  p_validation_number               IN  NUMBER   ,
  p_exclude_freight_from_discnt     IN  VARCHAR2 ,
  p_tax_reporting_name              IN  VARCHAR2 ,
  p_check_digits                    IN  VARCHAR2 ,
  p_allow_awt_flag                  IN  VARCHAR2 ,
  p_awt_group_id                    IN  NUMBER   ,
  p_pay_awt_group_id                IN  NUMBER   ,
  p_awt_group_name                  IN  VARCHAR2 ,
  p_pay_awt_group_name              IN  VARCHAR2 ,
  p_global_attribute1               IN  VARCHAR2 ,
  p_global_attribute2               IN  VARCHAR2 ,
  p_global_attribute3               IN  VARCHAR2 ,
  p_global_attribute4               IN  VARCHAR2 ,
  p_global_attribute5               IN  VARCHAR2 ,
  p_global_attribute6               IN  VARCHAR2 ,
  p_global_attribute7               IN  VARCHAR2 ,
  p_global_attribute8               IN  VARCHAR2 ,
  p_global_attribute9               IN  VARCHAR2 ,
  p_global_attribute10              IN  VARCHAR2 ,
  p_global_attribute11              IN  VARCHAR2 ,
  p_global_attribute12              IN  VARCHAR2 ,
  p_global_attribute13              IN  VARCHAR2 ,
  p_global_attribute14              IN  VARCHAR2 ,
  p_global_attribute15              IN  VARCHAR2 ,
  p_global_attribute16              IN  VARCHAR2 ,
  p_global_attribute17              IN  VARCHAR2 ,
  p_global_attribute18              IN  VARCHAR2 ,
  p_global_attribute19              IN  VARCHAR2 ,
  p_global_attribute20              IN  VARCHAR2 ,
  p_global_attribute_category       IN  VARCHAR2 ,
  p_bank_charge_bearer              IN  VARCHAR2 ,
  p_bank_branch_type                IN  VARCHAR2 ,
  p_match_option                    IN  VARCHAR2 ,
  p_create_debit_memo_flag          IN  VARCHAR2 ,
  p_party_id                        IN  NUMBER   ,
  p_parent_party_id                 IN  NUMBER   ,
  p_jgzz_fiscal_code                IN  VARCHAR2 ,
  p_sic_code                        IN  VARCHAR2 ,
  p_tax_reference                   IN  VARCHAR2 ,
  p_inventory_organization_id       IN  NUMBER   ,
  p_terms_name                      IN  VARCHAR2 ,
  p_default_terms_id                IN  NUMBER   ,
  p_ni_number                       IN  VARCHAR2 ,
  p_last_update_date                IN  DATE DEFAULT NULL,
  x_return_status   OUT NOCOPY VARCHAR2,
  x_error_msg       OUT NOCOPY VARCHAR2
)
  IS
   l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

Line: 1559


   l_last_update_date DATE;

Line: 1565


   if p_last_update_date is not NULL then
    select last_update_date into l_last_update_date
    from ap_suppliers where vendor_id = p_vendor_id;

Line: 1568


    if l_last_update_date > p_last_update_date then
      x_error_msg :=  fnd_message.get_string('POS','POS_LOCK_SUPPLIER_ROW');

Line: 1698


   Update_Vendor
     (
      p_vendor_rec      => l_vendor_rec,
      x_return_status   => x_return_status,
      x_msg_count       => l_msg_count,
      x_msg_data        => l_msg_data
      );

Line: 1708


END Update_Vendor;

Line: 2020


  p_last_update_date               IN  DATE     DEFAULT NULL,
  p_last_updated_by                IN  NUMBER   DEFAULT NULL,
  p_vendor_id                      IN  NUMBER   DEFAULT NULL,
  p_vendor_site_code               IN  VARCHAR2 DEFAULT NULL,
  p_vendor_site_code_alt           IN  VARCHAR2 DEFAULT NULL,
  p_purchasing_site_flag           IN  VARCHAR2 DEFAULT NULL,
  p_rfq_only_site_flag             IN  VARCHAR2 DEFAULT NULL,
  p_pay_site_flag                  IN  VARCHAR2 DEFAULT NULL,
  p_attention_ar_flag              IN  VARCHAR2 DEFAULT NULL,
  p_hold_all_payments_flag         IN  VARCHAR2 DEFAULT NULL,
  p_hold_future_payments_flag      IN  VARCHAR2 DEFAULT NULL,
  p_hold_reason                    IN  VARCHAR2 DEFAULT NULL,
  p_hold_unmatched_invoices_flag   IN  VARCHAR2 DEFAULT NULL,
  p_tax_reporting_site_flag        IN  VARCHAR2 DEFAULT NULL,
  p_attribute_category             IN  VARCHAR2 DEFAULT NULL,
  p_attribute1                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute2                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute3                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute4                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute5                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute6                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute7                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute8                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute9                     IN  VARCHAR2 DEFAULT NULL,
  p_attribute10                    IN  VARCHAR2 DEFAULT NULL,
  p_attribute11                    IN  VARCHAR2 DEFAULT NULL,
  p_attribute12                    IN  VARCHAR2 DEFAULT NULL,
  p_attribute13                    IN  VARCHAR2 DEFAULT NULL,
  p_attribute14                    IN  VARCHAR2 DEFAULT NULL,
  p_attribute15                    IN  VARCHAR2 DEFAULT NULL,
  p_validation_number              IN  NUMBER   DEFAULT NULL,
  p_exclude_freight_from_discnt    IN  VARCHAR2 DEFAULT NULL,
  p_bank_charge_bearer             IN  VARCHAR2 DEFAULT NULL,
  p_org_id                         IN  NUMBER   DEFAULT NULL,
  p_check_digits                   IN  VARCHAR2 DEFAULT NULL,
  p_allow_awt_flag                 IN  VARCHAR2 DEFAULT NULL,
  p_awt_group_id                   IN  NUMBER   DEFAULT NULL,
  p_pay_awt_group_id                   IN  NUMBER   DEFAULT NULL,
  p_default_pay_site_id            IN  NUMBER   DEFAULT NULL,
  p_pay_on_code                    IN  VARCHAR2 DEFAULT NULL,
  p_pay_on_receipt_summary_code    IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute_category      IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute1              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute2              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute3              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute4              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute5              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute6              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute7              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute8              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute9              IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute10             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute11             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute12             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute13             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute14             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute15             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute16             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute17             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute18             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute19             IN  VARCHAR2 DEFAULT NULL,
  p_global_attribute20             IN  VARCHAR2 DEFAULT NULL,
  p_tp_header_id                   IN  NUMBER   DEFAULT NULL,
  p_edi_id_number                  IN  VARCHAR2 DEFAULT NULL,
  p_ece_tp_location_code           IN  VARCHAR2 DEFAULT NULL,
  p_pcard_site_flag                IN  VARCHAR2 DEFAULT NULL,
  p_match_option                   IN  VARCHAR2 DEFAULT NULL,
  p_country_of_origin_code         IN  VARCHAR2 DEFAULT NULL,
  p_future_dated_payment_ccid      IN  NUMBER   DEFAULT NULL,
  p_create_debit_memo_flag         IN  VARCHAR2 DEFAULT NULL,
  p_supplier_notif_method          IN  VARCHAR2 DEFAULT NULL,
  p_email_address                  IN  VARCHAR2 DEFAULT NULL,
  p_primary_pay_site_flag          IN  VARCHAR2 DEFAULT NULL,
  p_shipping_control               IN  VARCHAR2 DEFAULT NULL,
  p_selling_company_identifier     IN  VARCHAR2 DEFAULT NULL,
  p_gapless_inv_num_flag           IN  VARCHAR2 DEFAULT NULL,
  p_location_id                    IN  NUMBER   DEFAULT NULL,
  p_party_site_id                  IN  NUMBER   DEFAULT NULL,
  p_org_name                       IN  VARCHAR2 DEFAULT NULL,
  p_duns_number                    IN  VARCHAR2 DEFAULT NULL,
  p_address_style                  IN  VARCHAR2 DEFAULT NULL,
  p_language                       IN  VARCHAR2 DEFAULT NULL,
  p_province                       IN  VARCHAR2 DEFAULT NULL,
  p_country                        IN  VARCHAR2 DEFAULT NULL,
  p_address_line1                  IN  VARCHAR2             ,
  p_address_line2                  IN  VARCHAR2 DEFAULT NULL,
  p_address_line3                  IN  VARCHAR2 DEFAULT NULL,
  p_address_line4                  IN  VARCHAR2 DEFAULT NULL,
  p_address_lines_alt              IN  VARCHAR2 DEFAULT NULL,
  p_county                         IN  VARCHAR2 DEFAULT NULL,
  p_city                           IN  VARCHAR2 DEFAULT NULL,
  p_state                          IN  VARCHAR2 DEFAULT NULL,
  p_zip                            IN  VARCHAR2 DEFAULT NULL,
  p_terms_name                     IN  VARCHAR2 DEFAULT NULL,
  p_default_terms_id               IN  NUMBER   DEFAULT NULL,
  p_awt_group_name                 IN  VARCHAR2 DEFAULT NULL,
  p_pay_awt_group_name                 IN  VARCHAR2 DEFAULT NULL,
  p_distribution_set_name          IN  VARCHAR2 DEFAULT NULL,
  p_ship_to_location_code          IN  VARCHAR2 DEFAULT NULL,
  p_bill_to_location_code          IN  VARCHAR2 DEFAULT NULL,
  p_default_dist_set_id            IN  NUMBER   DEFAULT NULL,
  p_default_ship_to_loc_id         IN  NUMBER   DEFAULT NULL,
  p_default_bill_to_loc_id         IN  NUMBER   DEFAULT NULL,
  p_tolerance_id                   IN  NUMBER   DEFAULT NULL,
  p_tolerance_name                 IN  VARCHAR2 DEFAULT NULL,
  p_retainage_rate                 IN  NUMBER   DEFAULT NULL,
  p_service_tolerance_id           IN  NUMBER   DEFAULT NULL,
  x_return_status   OUT NOCOPY VARCHAR2,
  x_error_msg       OUT NOCOPY VARCHAR2,
  x_vendor_site_id  OUT NOCOPY NUMBER,
  x_party_site_id   OUT NOCOPY NUMBER,
  x_location_id     OUT NOCOPY NUMBER
)
  IS
   l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

Line: 2170


   l_vendor_site_rec.last_update_date              := p_last_update_date;

Line: 2171


   l_vendor_site_rec.last_updated_by               := p_last_updated_by;

Line: 2304


PROCEDURE Update_Vendor_Site
(
  p_area_code                      IN  VARCHAR2 ,
  p_phone                          IN  VARCHAR2 ,
  p_customer_num                   IN  VARCHAR2 ,
  p_ship_to_location_id            IN  NUMBER   ,
  p_bill_to_location_id            IN  NUMBER   ,
  p_ship_via_lookup_code           IN  VARCHAR2 ,
  p_freight_terms_lookup_code      IN  VARCHAR2 ,
  p_fob_lookup_code                IN  VARCHAR2 ,
  p_inactive_date                  IN  DATE     ,
  p_fax                            IN  VARCHAR2 ,
  p_fax_area_code                  IN  VARCHAR2 ,
  p_telex                          IN  VARCHAR2 ,
  p_terms_date_basis               IN  VARCHAR2 ,
  p_distribution_set_id            IN  NUMBER   ,
  p_accts_pay_code_combo_id        IN  NUMBER   ,
  p_prepay_code_combination_id     IN  NUMBER   ,
  p_pay_group_lookup_code          IN  VARCHAR2 ,
  p_payment_priority               IN  NUMBER   ,
  p_terms_id                       IN  NUMBER   ,
  p_invoice_amount_limit           IN  NUMBER   ,
  p_pay_date_basis_lookup_code     IN  VARCHAR2 ,
  p_always_take_disc_flag          IN  VARCHAR2 ,
  p_invoice_currency_code          IN  VARCHAR2 ,
  p_payment_currency_code          IN  VARCHAR2 ,
  p_vendor_site_id                 IN  NUMBER   ,
  p_last_update_date               IN  DATE     ,
  p_last_updated_by                IN  NUMBER   ,
  p_vendor_id                      IN  NUMBER   ,
  p_vendor_site_code               IN  VARCHAR2 ,
  p_vendor_site_code_alt           IN  VARCHAR2 ,
  p_purchasing_site_flag           IN  VARCHAR2 ,
  p_rfq_only_site_flag             IN  VARCHAR2 ,
  p_pay_site_flag                  IN  VARCHAR2 ,
  p_attention_ar_flag              IN  VARCHAR2 ,
  p_hold_all_payments_flag         IN  VARCHAR2 ,
  p_hold_future_payments_flag      IN  VARCHAR2 ,
  p_hold_reason                    IN  VARCHAR2 ,
  p_hold_unmatched_invoices_flag   IN  VARCHAR2 ,
  p_tax_reporting_site_flag        IN  VARCHAR2 ,
  p_attribute_category             IN  VARCHAR2 ,
  p_attribute1                     IN  VARCHAR2 ,
  p_attribute2                     IN  VARCHAR2 ,
  p_attribute3                     IN  VARCHAR2 ,
  p_attribute4                     IN  VARCHAR2 ,
  p_attribute5                     IN  VARCHAR2 ,
  p_attribute6                     IN  VARCHAR2 ,
  p_attribute7                     IN  VARCHAR2 ,
  p_attribute8                     IN  VARCHAR2 ,
  p_attribute9                     IN  VARCHAR2 ,
  p_attribute10                    IN  VARCHAR2 ,
  p_attribute11                    IN  VARCHAR2 ,
  p_attribute12                    IN  VARCHAR2 ,
  p_attribute13                    IN  VARCHAR2 ,
  p_attribute14                    IN  VARCHAR2 ,
  p_attribute15                    IN  VARCHAR2 ,
  p_validation_number              IN  NUMBER   ,
  p_exclude_freight_from_discnt    IN  VARCHAR2 ,
  p_bank_charge_bearer             IN  VARCHAR2 ,
  p_org_id                         IN  NUMBER   ,
  p_check_digits                   IN  VARCHAR2 ,
  p_allow_awt_flag                 IN  VARCHAR2 ,
  p_awt_group_id                   IN  NUMBER   ,
  p_pay_awt_group_id                   IN  NUMBER   ,
  p_default_pay_site_id            IN  NUMBER   ,
  p_pay_on_code                    IN  VARCHAR2 ,
  p_pay_on_receipt_summary_code    IN  VARCHAR2 ,
  p_global_attribute_category      IN  VARCHAR2 ,
  p_global_attribute1              IN  VARCHAR2 ,
  p_global_attribute2              IN  VARCHAR2 ,
  p_global_attribute3              IN  VARCHAR2 ,
  p_global_attribute4              IN  VARCHAR2 ,
  p_global_attribute5              IN  VARCHAR2 ,
  p_global_attribute6              IN  VARCHAR2 ,
  p_global_attribute7              IN  VARCHAR2 ,
  p_global_attribute8              IN  VARCHAR2 ,
  p_global_attribute9              IN  VARCHAR2 ,
  p_global_attribute10             IN  VARCHAR2 ,
  p_global_attribute11             IN  VARCHAR2 ,
  p_global_attribute12             IN  VARCHAR2 ,
  p_global_attribute13             IN  VARCHAR2 ,
  p_global_attribute14             IN  VARCHAR2 ,
  p_global_attribute15             IN  VARCHAR2 ,
  p_global_attribute16             IN  VARCHAR2 ,
  p_global_attribute17             IN  VARCHAR2 ,
  p_global_attribute18             IN  VARCHAR2 ,
  p_global_attribute19             IN  VARCHAR2 ,
  p_global_attribute20             IN  VARCHAR2 ,
  p_tp_header_id                   IN  NUMBER   ,
  p_edi_id_number                  IN  VARCHAR2 ,
  p_ece_tp_location_code           IN  VARCHAR2 ,
  p_pcard_site_flag                IN  VARCHAR2 ,
  p_match_option                   IN  VARCHAR2 ,
  p_country_of_origin_code         IN  VARCHAR2 ,
  p_future_dated_payment_ccid      IN  NUMBER   ,
  p_create_debit_memo_flag         IN  VARCHAR2 ,
  p_supplier_notif_method          IN  VARCHAR2 ,
  p_email_address                  IN  VARCHAR2 ,
  p_primary_pay_site_flag          IN  VARCHAR2 ,
  p_shipping_control               IN  VARCHAR2 ,
  p_selling_company_identifier     IN  VARCHAR2 ,
  p_gapless_inv_num_flag           IN  VARCHAR2 ,
  p_location_id                    IN  NUMBER   ,
  p_party_site_id                  IN  NUMBER   ,
  p_org_name                       IN  VARCHAR2 ,
  p_duns_number                    IN  VARCHAR2 ,
  p_address_style                  IN  VARCHAR2 ,
  p_language                       IN  VARCHAR2 ,
  p_province                       IN  VARCHAR2 ,
  p_country                        IN  VARCHAR2 ,
  p_address_line1                  IN  VARCHAR2 ,
  p_address_line2                  IN  VARCHAR2 ,
  p_address_line3                  IN  VARCHAR2 ,
  p_address_line4                  IN  VARCHAR2 ,
  p_address_lines_alt              IN  VARCHAR2 ,
  p_county                         IN  VARCHAR2 ,
  p_city                           IN  VARCHAR2 ,
  p_state                          IN  VARCHAR2 ,
  p_zip                            IN  VARCHAR2 ,
  p_terms_name                     IN  VARCHAR2 ,
  p_default_terms_id               IN  NUMBER   ,
  p_awt_group_name                 IN  VARCHAR2 ,
  p_pay_awt_group_name                 IN  VARCHAR2 ,
  p_distribution_set_name          IN  VARCHAR2 ,
  p_ship_to_location_code          IN  VARCHAR2 ,
  p_bill_to_location_code          IN  VARCHAR2 ,
  p_default_dist_set_id            IN  NUMBER   ,
  p_default_ship_to_loc_id         IN  NUMBER   ,
  p_default_bill_to_loc_id         IN  NUMBER   ,
  p_tolerance_id                   IN  NUMBER   ,
  p_tolerance_name                 IN  VARCHAR2 ,
  p_retainage_rate                 IN  NUMBER   ,
  p_service_tolerance_id           IN  NUMBER   ,
  p_ship_network_loc_id            IN  NUMBER   ,
  p_cage_code                      IN  VARCHAR2,
  p_legal_business_name            IN  VARCHAR2,
  p_doing_business_as              IN  VARCHAR2,
  p_division_name                  IN  VARCHAR2,
  p_small_bus_code                 IN  VARCHAR2,
  p_ccr_comments                   IN  VARCHAR2,
  p_dbr_st_date                    IN  DATE,
  p_dbr_ed_date                    IN  DATE,
  x_return_status   OUT NOCOPY VARCHAR2,
  x_error_msg       OUT NOCOPY VARCHAR2
  )
IS
   l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

Line: 2454


   l_last_update_date DATE;

Line: 2459


   IF p_last_update_date IS NOT NULL then
      SELECT last_update_date INTO l_last_update_date
        FROM ap_supplier_sites_all
       WHERE vendor_site_id = p_vendor_site_id
         AND vendor_id = p_vendor_id;

Line: 2464


      IF l_last_update_date > p_last_update_date then
        x_error_msg := fnd_message.get_string('POS','POS_LOCK_SITE_ROW');

Line: 2497


   l_vendor_site_rec.last_update_date              := Nvl(p_last_update_date, fnd_api.g_null_date);

Line: 2498


   l_vendor_site_rec.last_updated_by               := Nvl(p_last_updated_by, fnd_api.g_null_num);

Line: 2650


   Update_Vendor_Site
     (
      p_vendor_site_rec => l_vendor_site_rec,
      x_return_status   => x_return_status,
      x_msg_count       => l_msg_count,
      x_msg_data        => l_msg_data
      );

Line: 2660


END Update_Vendor_Site;

Line: 2696


  p_last_update_date               IN  DATE     ,
  p_last_updated_by                IN  NUMBER   ,
  p_vendor_id                      IN  NUMBER   ,
  p_vendor_site_code               IN  VARCHAR2 ,
  p_vendor_site_code_alt           IN  VARCHAR2 ,
  p_purchasing_site_flag           IN  VARCHAR2 ,
  p_rfq_only_site_flag             IN  VARCHAR2 ,
  p_pay_site_flag                  IN  VARCHAR2 ,
  p_attention_ar_flag              IN  VARCHAR2 ,
  p_hold_all_payments_flag         IN  VARCHAR2 ,
  p_hold_future_payments_flag      IN  VARCHAR2 ,
  p_hold_reason                    IN  VARCHAR2 ,
  p_hold_unmatched_invoices_flag   IN  VARCHAR2 ,
  p_tax_reporting_site_flag        IN  VARCHAR2 ,
  p_attribute_category             IN  VARCHAR2 ,
  p_attribute1                     IN  VARCHAR2 ,
  p_attribute2                     IN  VARCHAR2 ,
  p_attribute3                     IN  VARCHAR2 ,
  p_attribute4                     IN  VARCHAR2 ,
  p_attribute5                     IN  VARCHAR2 ,
  p_attribute6                     IN  VARCHAR2 ,
  p_attribute7                     IN  VARCHAR2 ,
  p_attribute8                     IN  VARCHAR2 ,
  p_attribute9                     IN  VARCHAR2 ,
  p_attribute10                    IN  VARCHAR2 ,
  p_attribute11                    IN  VARCHAR2 ,
  p_attribute12                    IN  VARCHAR2 ,
  p_attribute13                    IN  VARCHAR2 ,
  p_attribute14                    IN  VARCHAR2 ,
  p_attribute15                    IN  VARCHAR2 ,
  p_validation_number              IN  NUMBER   ,
  p_exclude_freight_from_discnt    IN  VARCHAR2 ,
  p_bank_charge_bearer             IN  VARCHAR2 ,
  p_org_id                         IN  NUMBER   ,
  p_check_digits                   IN  VARCHAR2 ,
  p_allow_awt_flag                 IN  VARCHAR2 ,
  p_awt_group_id                   IN  NUMBER   ,
  p_pay_awt_group_id                   IN  NUMBER   ,
  p_default_pay_site_id            IN  NUMBER   ,
  p_pay_on_code                    IN  VARCHAR2 ,
  p_pay_on_receipt_summary_code    IN  VARCHAR2 ,
  p_global_attribute_category      IN  VARCHAR2 ,
  p_global_attribute1              IN  VARCHAR2 ,
  p_global_attribute2              IN  VARCHAR2 ,
  p_global_attribute3              IN  VARCHAR2 ,
  p_global_attribute4              IN  VARCHAR2 ,
  p_global_attribute5              IN  VARCHAR2 ,
  p_global_attribute6              IN  VARCHAR2 ,
  p_global_attribute7              IN  VARCHAR2 ,
  p_global_attribute8              IN  VARCHAR2 ,
  p_global_attribute9              IN  VARCHAR2 ,
  p_global_attribute10             IN  VARCHAR2 ,
  p_global_attribute11             IN  VARCHAR2 ,
  p_global_attribute12             IN  VARCHAR2 ,
  p_global_attribute13             IN  VARCHAR2 ,
  p_global_attribute14             IN  VARCHAR2 ,
  p_global_attribute15             IN  VARCHAR2 ,
  p_global_attribute16             IN  VARCHAR2 ,
  p_global_attribute17             IN  VARCHAR2 ,
  p_global_attribute18             IN  VARCHAR2 ,
  p_global_attribute19             IN  VARCHAR2 ,
  p_global_attribute20             IN  VARCHAR2 ,
  p_tp_header_id                   IN  NUMBER   ,
  p_edi_id_number                  IN  VARCHAR2 ,
  p_ece_tp_location_code           IN  VARCHAR2 ,
  p_pcard_site_flag                IN  VARCHAR2 ,
  p_match_option                   IN  VARCHAR2 ,
  p_country_of_origin_code         IN  VARCHAR2 ,
  p_future_dated_payment_ccid      IN  NUMBER   ,
  p_create_debit_memo_flag         IN  VARCHAR2 ,
  p_supplier_notif_method          IN  VARCHAR2 ,
  p_email_address                  IN  VARCHAR2 ,
  p_primary_pay_site_flag          IN  VARCHAR2 ,
  p_shipping_control               IN  VARCHAR2 ,
  p_selling_company_identifier     IN  VARCHAR2 ,
  p_gapless_inv_num_flag           IN  VARCHAR2 ,
  p_location_id                    IN  NUMBER   ,
  p_party_site_id                  IN  NUMBER   ,
  p_org_name                       IN  VARCHAR2 ,
  p_duns_number                    IN  VARCHAR2 ,
  p_address_style                  IN  VARCHAR2 ,
  p_language                       IN  VARCHAR2 ,
  p_province                       IN  VARCHAR2 ,
  p_country                        IN  VARCHAR2 ,
  p_address_line1                  IN  VARCHAR2 ,
  p_address_line2                  IN  VARCHAR2 ,
  p_address_line3                  IN  VARCHAR2 ,
  p_address_line4                  IN  VARCHAR2 ,
  p_address_lines_alt              IN  VARCHAR2 ,
  p_county                         IN  VARCHAR2 ,
  p_city                           IN  VARCHAR2 ,
  p_state                          IN  VARCHAR2 ,
  p_zip                            IN  VARCHAR2 ,
  p_terms_name                     IN  VARCHAR2 ,
  p_default_terms_id               IN  NUMBER   ,
  p_awt_group_name                 IN  VARCHAR2 ,
  p_pay_awt_group_name                 IN  VARCHAR2 ,
  p_distribution_set_name          IN  VARCHAR2 ,
  p_ship_to_location_code          IN  VARCHAR2 ,
  p_bill_to_location_code          IN  VARCHAR2 ,
  p_default_dist_set_id            IN  NUMBER   ,
  p_default_ship_to_loc_id         IN  NUMBER   ,
  p_default_bill_to_loc_id         IN  NUMBER   ,
  p_tolerance_id                   IN  NUMBER   ,
  p_tolerance_name                 IN  VARCHAR2 ,
  p_retainage_rate                 IN  NUMBER   ,
  p_mode                           IN  VARCHAR2,
  p_cage_code                      IN  VARCHAR2,
  p_legal_business_name            IN  VARCHAR2,
  p_doing_business_as              IN  VARCHAR2,
  p_division_name                  IN  VARCHAR2,
  p_small_bus_code                 IN  VARCHAR2,
  p_ccr_comments                   IN  VARCHAR2,
  p_dbr_st_date                    IN  DATE,
  p_dbr_ed_date                    IN  DATE,
  x_return_status     OUT NOCOPY VARCHAR2,
  x_error_msg         OUT NOCOPY VARCHAR2,
  x_party_site_valid  OUT NOCOPY VARCHAR2,
  x_location_valid    OUT NOCOPY VARCHAR2
)
IS
   l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

Line: 2849


   l_vendor_site_rec.last_update_date              := Nvl(p_last_update_date, fnd_api.g_null_date);

Line: 2850


   l_vendor_site_rec.last_updated_by               := Nvl(p_last_updated_by, fnd_api.g_null_num);

Line: 2981


   l_vendor_site_rec.last_update_date              := p_last_update_date;

Line: 2982


   l_vendor_site_rec.last_updated_by               := p_last_updated_by;

Line: 3219


          l_row_attrs_table.DELETE;