eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PARTY_RLTSHIP_PVT SQL Statements

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

Line: 108


      ASO_PARTY_RELATIONSHIPS_PKG.Insert_Row(
          px_PARTY_RELATIONSHIP_ID  => x_PARTY_RELATIONSHIP_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REQUEST_ID  => p_PARTY_RLTSHIP_rec.REQUEST_ID,
       p_PROGRAM_APPLICATION_ID  => p_PARTY_RLTSHIP_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_PARTY_RLTSHIP_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => p_PARTY_RLTSHIP_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID  => p_PARTY_RLTSHIP_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => p_PARTY_RLTSHIP_rec.QUOTE_LINE_ID,
          p_OBJECT_TYPE_CODE  => p_PARTY_RLTSHIP_rec.OBJECT_TYPE_CODE,
          p_OBJECT_ID  => p_PARTY_RLTSHIP_rec.OBJECT_ID,
      p_RELATIONSHIP_TYPE_CODE  => p_PARTY_RLTSHIP_rec.RELATIONSHIP_TYPE_CODE,
	 p_OBJECT_VERSION_NUMBER => p_PARTY_RLTSHIP_rec.OBJECT_VERSION_NUMBER);

Line: 186


PROCEDURE Update_party_rltship(
    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_Identity_Salesforce_Id     IN   NUMBER       := NULL,
    P_PARTY_RLTSHIP_Rec     IN    ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )

 IS

Cursor C_Get_party_rltship(PARTY_RELATIONSHIP_ID Number) IS
    Select --rowid,
           PARTY_RELATIONSHIP_ID,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
           QUOTE_HEADER_ID,
           QUOTE_LINE_ID,
           OBJECT_TYPE_CODE,
           OBJECT_ID,
           RELATIONSHIP_TYPE_CODE
    From  ASO_PARTY_RELATIONSHIPS
    where PARTY_RELATIONSHIP_ID = P_PARTY_RLTSHIP_Rec.PARTY_RELATIONSHIP_ID;

Line: 221


l_api_name                CONSTANT VARCHAR2(30) := 'Update_party_rltship';

Line: 230


      SAVEPOINT UPDATE_PARTY_RLTSHIP_PVT;

Line: 267


               l_ref_PARTY_RLTSHIP_rec.LAST_UPDATE_DATE,
               l_ref_PARTY_RLTSHIP_rec.LAST_UPDATED_BY,
               l_ref_PARTY_RLTSHIP_rec.LAST_UPDATE_LOGIN,
               l_ref_PARTY_RLTSHIP_rec.REQUEST_ID,
               l_ref_PARTY_RLTSHIP_rec.PROGRAM_APPLICATION_ID,
               l_ref_PARTY_RLTSHIP_rec.PROGRAM_ID,
               l_ref_PARTY_RLTSHIP_rec.PROGRAM_UPDATE_DATE,
               l_ref_PARTY_RLTSHIP_rec.QUOTE_HEADER_ID,
               l_ref_PARTY_RLTSHIP_rec.QUOTE_LINE_ID,
               l_ref_PARTY_RLTSHIP_rec.OBJECT_TYPE_CODE,
               l_ref_PARTY_RLTSHIP_rec.OBJECT_ID,
	       l_ref_PARTY_RLTSHIP_rec.RELATIONSHIP_TYPE_CODE;

Line: 283


               FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');

Line: 294


      If (l_tar_PARTY_RLTSHIP_rec.last_update_date is NULL or
          l_tar_PARTY_RLTSHIP_rec.last_update_date = FND_API.G_MISS_Date ) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

Line: 299


              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 305


      If (l_tar_PARTY_RLTSHIP_rec.last_update_date <> l_ref_PARTY_RLTSHIP_rec.last_update_date) Then
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');

Line: 324


              p_validation_mode  => ASO_UTILITY_PVT.G_UPDATE,
              P_PARTY_RLTSHIP_Rec  =>  P_PARTY_RLTSHIP_Rec,
              x_return_status    => x_return_status,
              x_msg_count        => x_msg_count,
              x_msg_data         => x_msg_data);

Line: 340


      ASO_PARTY_RELATIONSHIPS_PKG.Update_Row(
          p_PARTY_RELATIONSHIP_ID  => p_PARTY_RLTSHIP_rec.PARTY_RELATIONSHIP_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REQUEST_ID  => p_PARTY_RLTSHIP_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_PARTY_RLTSHIP_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_PARTY_RLTSHIP_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => p_PARTY_RLTSHIP_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID  => p_PARTY_RLTSHIP_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => p_PARTY_RLTSHIP_rec.QUOTE_LINE_ID,
          p_OBJECT_TYPE_CODE  => p_PARTY_RLTSHIP_rec.OBJECT_TYPE_CODE,
          p_OBJECT_ID  => p_PARTY_RLTSHIP_rec.OBJECT_ID,
          p_RELATIONSHIP_TYPE_CODE  => p_PARTY_RLTSHIP_rec.RELATIONSHIP_TYPE_CODE,
		p_OBJECT_VERSION_NUMBER => p_PARTY_RLTSHIP_rec.OBJECT_VERSION_NUMBER);

Line: 409


End Update_party_rltship;

Line: 413


PROCEDURE Delete_party_rltship(
    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_identity_salesforce_id     IN   NUMBER       := NULL,
    P_PARTY_RLTSHIP_Rec     IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )

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

Line: 431


      SAVEPOINT DELETE_PARTY_RLTSHIP_PVT;

Line: 462


      ASO_PARTY_RELATIONSHIPS_PKG.Delete_Row(
          p_PARTY_RELATIONSHIP_ID  => p_PARTY_RLTSHIP_rec.PARTY_RELATIONSHIP_ID);

Line: 517


End Delete_party_rltship;

Line: 558


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_PARTY_RELATIONSHIP_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 604


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_REQUEST_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 650


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 696


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_PROGRAM_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 714


PROCEDURE Validate_PROGRAM_UPDATE_DATE (
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Validation_mode            IN   VARCHAR2,
    P_PROGRAM_UPDATE_DATE                IN   DATE,
    X_Return_Status              OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
    X_Msg_Count                  OUT NOCOPY /* file.sql.39 change */    NUMBER,
    X_Msg_Data                   OUT NOCOPY /* file.sql.39 change */    VARCHAR2
    )
IS
BEGIN

      -- Initialize message list if p_init_msg_list is set to TRUE.
      IF FND_API.to_Boolean( p_init_msg_list )
      THEN
          FND_MSG_PUB.initialize;

Line: 742


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 757


END Validate_PROGRAM_UPDATE_DATE;

Line: 788


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_QUOTE_OBJECT_TYPE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 834


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- IF p_QUOTE_OBJECT_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 886


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_RELATIONSHIP_TYPE_CODE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 932


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_RELATED_OBJECT_TYPE_CODE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 978


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_RELATED_OBJECT_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1031


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_QUOTE_HEADER_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1084


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_QUOTE_LINE_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1137


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_OBJECT_TYPE_CODE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1190


      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_OBJECT_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1317


          Validate_PROGRAM_UPDATE_DATE(
              p_init_msg_list          => FND_API.G_FALSE,
              p_validation_mode        => p_validation_mode,
              p_PROGRAM_UPDATE_DATE   => P_PARTY_RLTSHIP_Rec.PROGRAM_UPDATE_DATE,
              x_return_status          => x_return_status,
              x_msg_count              => x_msg_count,
              x_msg_data               => x_msg_data);