APPS.IEX_CASE_CONTACTS_PVT SQL Statements

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

Line: 43

Cursor c2 is SELECT IEX_CASE_CONTACTS_S.nextval from dual;

Line: 46

   SELECT PARTY_SITE_ID
   FROM HZ_PARTY_SITES
   WHERE PARTY_ID = P_PARTY_ID
   AND IDENTIFYING_ADDRESS_FLAG = 'Y';

Line: 52

    select contact_point_id
    from hz_contact_points
    where owner_table_id = x_owner_table_id
    and owner_table_name = 'HZ_PARTIES'
    and contact_point_type = 'PHONE'
    and primary_flag = 'Y';

Line: 180

           IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'Before calling IEX_CASE_CONTACTS_PKG.Insert_Row');

Line: 183

      IEX_CASE_CONTACTS_PKG.Insert_Row(
          x_rowid                  =>v_rowid,
          p_CAS_CONTACT_ID         => v_CAS_CONTACT_ID,
          p_CAS_ID                 => p_case_contact_rec.CAS_ID,
          p_CONTACT_PARTY_ID       => p_case_contact_rec.CONTACT_PARTY_ID,
          p_OBJECT_VERSION_NUMBER  => v_OBJECT_VERSION_NUMBER,
          p_ACTIVE_FLAG            => v_ACTIVE_FLAG,
          p_address_id             => v_address_id,
          p_phone_id               => v_phone_id,
          p_REQUEST_ID             => p_case_contact_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID => p_case_contact_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID             => p_case_contact_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE    => p_case_contact_rec.PROGRAM_UPDATE_DATE,
          p_ATTRIBUTE_CATEGORY     => p_case_contact_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_case_contact_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_case_contact_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_case_contact_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_case_contact_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_case_contact_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_case_contact_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_case_contact_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_case_contact_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_case_contact_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_case_contact_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_case_contact_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_case_contact_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_case_contact_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_case_contact_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_case_contact_rec.ATTRIBUTE15,
          p_CREATED_BY         => FND_GLOBAL.USER_ID,
          p_CREATION_DATE      => SYSDATE,
          p_LAST_UPDATED_BY    => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE   => SYSDATE,
          p_LAST_UPDATE_LOGIN  => p_case_contact_rec.LAST_UPDATE_LOGIN,
          p_PRIMARY_FLAG       => V_PRIMARY_FLAG
          );

Line: 223

             IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Calling IEX_CASE_CONTACTS_PKG.Insert_Row and cas Contact id => '
                                    ||x_cas_contact_id);

Line: 287

PROCEDURE Update_case_contact(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    P_case_contact_Rec           IN    case_contact_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2,
    xo_object_version_number     OUT NOCOPY NUMBER

    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'UPDATE_CASE_CONTACT';

Line: 307

         IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_CASE_CONTACTS_PVT.update_case_contact ******** ');

Line: 310

      SAVEPOINT UPDATE_case_contact_PVT;

Line: 344

      IEX_CASE_CONTACTS_PKG.Update_Row(
          p_CAS_CONTACT_ID         => p_case_contact_rec.CAS_CONTACT_ID,
          p_CAS_ID                 => p_case_contact_rec.CAS_ID,
          p_CONTACT_PARTY_ID       => p_case_contact_rec.CONTACT_PARTY_ID,
          p_OBJECT_VERSION_NUMBER  => l_OBJECT_VERSION_NUMBER +1,
          p_ACTIVE_FLAG           => p_case_contact_rec.ACTIVE_FLAG,
          p_REQUEST_ID             => p_case_contact_rec.REQUEST_ID,
          p_address_id             => p_case_contact_rec.address_id,
          p_phone_id               => p_case_contact_rec.phone_id,
          p_PROGRAM_APPLICATION_ID => p_case_contact_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID             => p_case_contact_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE    => p_case_contact_rec.PROGRAM_UPDATE_DATE,
          p_ATTRIBUTE_CATEGORY     => p_case_contact_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_case_contact_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_case_contact_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_case_contact_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_case_contact_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_case_contact_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_case_contact_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_case_contact_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_case_contact_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_case_contact_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_case_contact_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_case_contact_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_case_contact_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_case_contact_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_case_contact_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_case_contact_rec.ATTRIBUTE15,
          p_LAST_UPDATED_BY    => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE   => SYSDATE,
          p_LAST_UPDATE_LOGIN  => p_case_contact_rec.LAST_UPDATE_LOGIN,
          p_PRIMARY_FLAG       => p_case_contact_rec.PRIMARY_FLAG);

Line: 399

         IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_CONTACTS_PVT.update_case_contact ******** ');

Line: 433

End Update_case_contact;

Line: 438

PROCEDURE Delete_case_contact(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    P_cas_contact_ID             IN   NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'DELETE_CASE_CONTACT';

Line: 456

         IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_CASE_CONTACTS_PVT.delete_case_contact ******** ');

Line: 459

      SAVEPOINT DELETE_case_contact_PVT;

Line: 485

      IEX_CASE_CONTACTS_PKG.Delete_Row(
          p_CAS_CONTACT_ID  => p_CAS_CONTACT_ID);

Line: 506

         IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_CONTACTS_PVT.delete_case_contact ******** ');

Line: 540

End Delete_case_contact;