APPS.AR_CMGT_HZ_COVER_API SQL Statements

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

Line: 48

 |      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: 273

    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: 284

END update_organization;

Line: 295

 SELECT 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;