APPS.WSH_SITE_CONTACT_INFO_PKG SQL Statements

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

Line: 169

PROCEDURE UPDATE_CONTACTINFO(
    P_CONTACT_POINT_ID          IN  NUMBER,
    P_COUNTRY_CODE              IN  VARCHAR2,
    P_AREA_CODE                 IN  VARCHAR2,
    P_PHONE_NUMBER              IN  VARCHAR2,
    P_EXTENSION                 IN  VARCHAR2,
    P_PHONE_LINE_TYPE           IN  VARCHAR2,
    X_RETURN_STATUS             OUT NOCOPY  VARCHAR2,
    X_EXCEPTION_MSG             OUT NOCOPY  VARCHAR2,
    X_POSITION                  OUT NOCOPY  NUMBER,
    X_PROCEDURE                 OUT NOCOPY  VARCHAR2,
    X_SQLERR                    OUT NOCOPY  VARCHAR2,
    X_SQL_CODE                  OUT NOCOPY  VARCHAR2 ) IS

  l_contact_points_rec_type  hz_contact_point_v2pub.contact_point_rec_type;

Line: 199

  select object_version_number
  from   hz_contact_points
  where  contact_point_id = p_contact_point_id;

Line: 206

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_CONTACTINFO';

Line: 266

  l_procedure := 'Calling Update_Contact_Points';

Line: 272

      WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.UPDATE_CONTACT_POINT',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 276

     HZ_CONTACT_POINT_V2PUB.Update_Contact_Point
      (
        p_init_msg_list           => FND_API.G_TRUE,
        p_contact_point_rec       => l_contact_points_rec_type,
        p_phone_rec               => l_phone_rec_type,
        p_object_version_number   => l_object_version_number,
        x_return_status           => l_return_status,
        x_msg_count               => l_msg_count,
        x_msg_data                => l_msg_data
      );

Line: 352

END UPDATE_CONTACTINFO;