APPS.ASO_LINE_RLTSHIP_PVT SQL Statements

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

Line: 141

        ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
          px_LINE_RELATIONSHIP_ID  => x_LINE_RELATIONSHIP_ID,
          p_CREATION_DATE          => SYSDATE,
          p_CREATED_BY             => G_USER_ID,
          p_LAST_UPDATED_BY         => G_USER_ID,
          p_LAST_UPDATE_DATE       => SYSDATE,
          p_LAST_UPDATE_LOGIN       => G_LOGIN_ID,
          p_REQUEST_ID              => p_LINE_RLTSHIP_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_LINE_RLTSHIP_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_LINE_RLTSHIP_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE => p_LINE_RLTSHIP_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_LINE_ID    => p_LINE_RLTSHIP_rec.QUOTE_LINE_ID,
          p_RELATED_QUOTE_LINE_ID  => p_LINE_RLTSHIP_rec.RELATED_QUOTE_LINE_ID,
   --     p_RELATIONAL_TYPE_CODE  => p_LINE_RLTSHIP_rec.RELATIONAL_TYPE_CODE,
          p_RECIPROCAL_FLAG   => p_LINE_RLTSHIP_rec.RECIPROCAL_FLAG,
          p_RELATIONSHIP_TYPE_CODE => p_LINE_RLTSHIP_rec.RELATIONSHIP_TYPE_CODE,
	     p_OBJECT_VERSION_NUMBER => p_LINE_RLTSHIP_rec.OBJECT_VERSION_NUMBER
		);

Line: 239

PROCEDURE Update_line_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_LINE_RLTSHIP_Rec     IN    ASO_quote_PUB.LINE_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

G_USER_ID         NUMBER := FND_GLOBAL.USER_ID;

Line: 256

    Select --rowid,
           LINE_RELATIONSHIP_ID,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
           QUOTE_LINE_ID,
           RELATED_QUOTE_LINE_ID,
           RELATIONSHIP_TYPE_CODE,
           RECIPROCAL_FLAG
           -- RELATIONSHIP_TYPE_CODE
    From  ASO_LINE_RELATIONSHIPS
    where LINE_RELATIONSHIP_ID = P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID;

Line: 277

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

Line: 286

      SAVEPOINT UPDATE_LINE_RLTSHIP_PVT;

Line: 320

          AS_CALLOUT_PKG.Update_line_rltship_BU(
                  p_api_version_number   =>  2.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_LINE_RLTSHIP_Rec      =>  P_LINE_RLTSHIP_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 341

               l_ref_LINE_RLTSHIP_rec.LAST_UPDATED_BY,
               l_ref_LINE_RLTSHIP_rec.LAST_UPDATE_DATE,
               l_ref_LINE_RLTSHIP_rec.LAST_UPDATE_LOGIN,
               l_ref_LINE_RLTSHIP_rec.REQUEST_ID,
               l_ref_LINE_RLTSHIP_rec.PROGRAM_APPLICATION_ID,
               l_ref_LINE_RLTSHIP_rec.PROGRAM_ID,
               l_ref_LINE_RLTSHIP_rec.PROGRAM_UPDATE_DATE,
               l_ref_LINE_RLTSHIP_rec.QUOTE_LINE_ID,
               l_ref_LINE_RLTSHIP_rec.RELATED_QUOTE_LINE_ID,
         --      l_ref_LINE_RLTSHIP_rec.RELATIONAL_TYPE_CODE,
                l_ref_LINE_RLTSHIP_rec.RELATIONSHIP_TYPE_CODE,
               l_ref_LINE_RLTSHIP_rec.RECIPROCAL_FLAG;

Line: 358

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

Line: 370

      If (l_tar_LINE_RLTSHIP_rec.last_update_date is NULL or
          l_tar_LINE_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: 375

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

Line: 381

      If (l_tar_LINE_RLTSHIP_rec.last_update_date <> l_ref_LINE_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: 400

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

Line: 417

      ASO_LINE_RELATIONSHIPS_PKG.Update_Row(
          p_LINE_RELATIONSHIP_ID  => p_LINE_RLTSHIP_rec.LINE_RELATIONSHIP_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => G_USER_ID,
          p_LAST_UPDATED_BY  => G_USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
          p_REQUEST_ID  => p_LINE_RLTSHIP_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_LINE_RLTSHIP_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_LINE_RLTSHIP_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => p_LINE_RLTSHIP_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_LINE_ID  => p_LINE_RLTSHIP_rec.QUOTE_LINE_ID,
          p_RELATED_QUOTE_LINE_ID  => p_LINE_RLTSHIP_rec.RELATED_QUOTE_LINE_ID,
   --       p_RELATIONAL_TYPE_CODE  => p_LINE_RLTSHIP_rec.RELATIONAL_TYPE_CODE,
          p_RECIPROCAL_FLAG  => p_LINE_RLTSHIP_rec.RECIPROCAL_FLAG,
          p_RELATIONSHIP_TYPE_CODE  => p_LINE_RLTSHIP_rec.RELATIONSHIP_TYPE_CODE,
		p_OBJECT_VERSION_NUMBER => p_LINE_RLTSHIP_rec.OBJECT_VERSION_NUMBER);

Line: 460

          AS_CALLOUT_PKG.Update_line_rltship_AU(
                  p_api_version_number   =>  2.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_LINE_RLTSHIP_Rec      =>  P_LINE_RLTSHIP_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 503

End Update_line_rltship;

Line: 521

PROCEDURE Delete_line_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_control_rec                IN  ASO_QUOTE_PUB.control_rec_type 	:= ASO_QUOTE_PUB.G_MISS_Control_Rec,
--    P_identity_salesforce_id     IN   NUMBER       := NULL,
    P_LINE_RLTSHIP_Rec     IN ASO_quote_PUB.LINE_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 C1(line_id NUMBER) IS
select line_relationship_id, quote_line_id, related_quote_line_id, relationship_type_code, reciprocal_flag
from aso_line_relationships
where quote_line_id = line_id;

Line: 543

select line_relationship_id
from aso_line_relationships
where related_quote_line_id = line_id;

Line: 548

select line_relationship_id, quote_line_id, related_quote_line_id, relationship_type_code, reciprocal_flag
from aso_line_relationships
where quote_line_id = line_id
and related_quote_line_id = related_line_id;

Line: 555

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

Line: 565

      SAVEPOINT DELETE_LINE_RLTSHIP_PVT;

Line: 599

          AS_CALLOUT_PKG.Delete_line_rltship_BD(
                  p_api_version_number   =>  2.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_LINE_RLTSHIP_Rec      =>  P_LINE_RLTSHIP_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 637

      ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
          p_LINE_RELATIONSHIP_ID  => i.LINE_RELATIONSHIP_ID);

Line: 647

    ASO_quote_lines_PVT.Delete_Quote_Line(
    P_Api_Version_Number  => 1.0,
    P_qte_line_Rec        => l_qte_line_rec,
    p_control_rec         => p_control_rec,
    P_Update_Header_Flag  =>FND_API.G_FALSE,
    X_Return_Status       => x_return_status,
    X_Msg_Count           => x_msg_count,
    X_Msg_Data            => x_msg_data
    );

Line: 664

      ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
          p_LINE_RELATIONSHIP_ID  => i.LINE_RELATIONSHIP_ID);

Line: 690

         ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
          p_LINE_RELATIONSHIP_ID  => i.LINE_RELATIONSHIP_ID);

Line: 697

    ASO_quote_lines_PVT.Delete_Quote_Line(
    P_Api_Version_Number  => 1.0,
    P_qte_line_Rec        => l_qte_line_rec,
    p_control_rec         => p_control_rec,
    P_Update_Header_Flag  =>FND_API.G_FALSE,
    X_Return_Status       => x_return_status,
    X_Msg_Count           => x_msg_count,
    X_Msg_Data            => x_msg_data
    );

Line: 713

          ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
          p_LINE_RELATIONSHIP_ID  => i.LINE_RELATIONSHIP_ID);

Line: 719

       ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
          p_LINE_RELATIONSHIP_ID  => p_LINE_RLTSHIP_rec.LINE_RELATIONSHIP_ID);

Line: 754

          AS_CALLOUT_PKG.Delete_line_rltship_AD(
                  p_api_version_number   =>  2.0,
                  p_init_msg_list        =>  FND_API.G_FALSE,
                  p_commit               =>  FND_API.G_FALSE,
                  p_validation_level     =>  p_validation_level,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_LINE_RLTSHIP_Rec      =>  P_LINE_RLTSHIP_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 799

End Delete_line_rltship;

Line: 818

      dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);

Line: 910

PROCEDURE Gen_Select(
    x_select_cl   OUT NOCOPY /* file.sql.39 change */     VARCHAR2
)
IS
BEGIN
null;

Line: 916

END Gen_Select;

Line: 1065

      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_LINE_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: 1074

              select count(*) into l_count
              from aso_line_relationships
              where line_relationship_id = p_LINE_RELATIONSHIP_ID;

Line: 1122

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

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

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

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,
    -- Hint: You may add 'X_Item_Property_Rec  OUT NOCOPY /* file.sql.39 change */       ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
    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: 1263

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

END Validate_PROGRAM_UPDATE_DATE;

Line: 1312

               select count(*) into l_count
               from aso_quote_lines_all
               where quote_line_id = p_QUOTE_LINE_ID;

Line: 1362

               select count(*) into l_count
               from aso_quote_lines_all
               where quote_line_id = p_RELATED_QUOTE_LINE_ID;

Line: 1411

      ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_RELATIONAL_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: 1421

            select count(*) into l_count
          from aso_lookups
          where lookup_type = 'ASO_LINE_RELATIONSHIP_TYPE'
          and lookup_code = p_RELATIONAL_TYPE_CODE;

Line: 1470

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

Line: 1524

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

          Validate_PROGRAM_UPDATE_DATE(
              p_init_msg_list          => FND_API.G_FALSE,
              p_validation_mode        => p_validation_mode,
              p_PROGRAM_UPDATE_DATE   => P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE,
              -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY /* file.sql.39 change */   parameter if you'd like to pass back item property.
              x_return_status          => x_return_status,
              x_msg_count              => x_msg_count,
              x_msg_data               => x_msg_data);