1 Reply Latest reply on Dec 5, 2009 5:59 AM by S.PDASH

    R12- Update Party Site- Active/Inactive

    Jason ORCL
      Hi- I need to activate an inactive site in a custom interface.

      If I go to SQL and run this it works!

      UPDATE hz_party_sites
      SET status = 'A'
      WHERE party_site_id = l_party_site_id;

      But in my program i cannot do this as I have insufficient privledges.

      Is there an API I can call to activate a site?

      Thanks!
        • 1. Re: R12- Update Party Site- Active/Inactive
          S.PDASH
          Hi Jason,
          Please check below list for customer update APIs

          CUSTOMER UPDATE API are as follows_

          apps.hz_party_v2pub.update_organization
          apps.hz_cust_account_v2pub.update_cust_account
          apps.hz_party_v2pub.update_person
          apps.hz_contact_point_v2pub.update_email_contact_point
          apps.hz_contact_point_v2pub.update_phone_contact_point
          apps.hz_cust_account_v2pub.update_cust_acct_relate
          apps.hz_location_v2pub.update_location
          apps.hz_party_site_v2pub.update_party_site+
          apps.hz_cust_account_site_v2pub.update_cust_acct_site
          apps.hz_cust_account_site_v2pub.update_cust_site_use
          apps.hz_customer_profile_v2pub.update_customer_profile
          apps.hz_customer_profile_v2pub.update_cust_profile_amt

          Hope this will help.

          Regards,
          S.P DASH