APPS.WSH_CARRIER_CONTACT_INFO_PKG SQL Statements

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

Line: 180

PROCEDURE UPDATE_CONTACTINFO
  (
        P_CARRIER_PARTY_ID          IN  NUMBER,
        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_PRIMARY                   IN  VARCHAR2,
        P_STATUS                    IN  VARCHAR2,
	P_CONTACT_TYPE              IN  VARCHAR2,--Added parameter for contact type - bug 5298638
        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: 214

  select object_version_number
  from   hz_contact_points
  where  contact_point_id = p_contact_point_id;

Line: 221

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

Line: 287

  l_procedure := 'Calling Update_Contact_Points';

Line: 293

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

Line: 297

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

END UPDATE_CONTACTINFO;