APPS.AR_CMGT_HZ_COVER_API SQL Statements

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

Line: 58

 |      update_organization()
 | DESCRIPTION
 |
 | PSEUDO CODE/LOGIC
 |
 | PARAMETERS
 |      p_resource_id    IN      resource_id
 |
 | KNOWN ISSUES
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 | Date                  Author            Description of Changes
 |
 *=======================================================================*/
PROCEDURE update_organization(p_party_id           NUMBER,  --15
                              p_year_established   NUMBER,
                              p_employees_total    NUMBER,
                              p_url                VARCHAR2,
                              p_sic_code_type      VARCHAR2,
                              p_sic_code           VARCHAR2,
                              p_tax_reference      VARCHAR2, --50
                              p_duns_number_c      VARCHAR2
                             )
IS
l_party_rec                HZ_PARTY_V2PUB.party_rec_type;

Line: 283

    hz_party_v2pub.update_organization(
                 p_organization_rec => l_organization_rec,
                 p_party_object_version_number => l_party_object_version_number,
                 x_profile_id => l_profile_id,
                 x_return_status => l_return_status,
                 x_msg_count => l_msg_count,
                 x_msg_data => l_msg_data);

Line: 294

END update_organization;

Line: 308

   select cp.profile_class_id
   from	 hz_cust_accounts ca,
  	 hz_customer_profiles cp
   where ca.party_id = p_party_id
   and	 ca.cust_account_id = cp.cust_account_id
   and	 ca.status = 'A'
   and	 cp.status = 'A'
   order by cp.site_use_id desc;