APPS.ASO_LINE_ATTRIBS_PVT SQL Statements

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

Line: 139

      ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Insert_Row(
          px_LINE_ATTRIBUTE_ID  => x_LINE_ATTRIB_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_LINE_ATTRIBS_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_LINE_ATTRIBS_rec.PROGRAM_ID,
		p_application_id => p_line_attribs_rec.application_id,
		p_status => p_line_attribs_rec.status,
          p_PROGRAM_UPDATE_DATE  => p_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
          p_QUOTE_HEADER_ID  => p_LINE_ATTRIBS_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => p_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
          p_QUOTE_SHIPMENT_ID  => p_LINE_ATTRIBS_rec.QUOTE_SHIPMENT_ID,
          p_ATTRIBUTE_TYPE_CODE  => p_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
          p_NAME  => p_LINE_ATTRIBS_rec.NAME,
          p_VALUE  => p_LINE_ATTRIBS_rec.VALUE,
		p_VALUE_TYPE => p_LINE_ATTRIBS_REC.value_type,
          p_START_DATE_ACTIVE  => p_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
          p_END_DATE_ACTIVE  => p_LINE_ATTRIBS_rec.END_DATE_ACTIVE,
		p_OBJECT_VERSION_NUMBER => p_LINE_ATTRIBS_rec.OBJECT_VERSION_NUMBER
		);

Line: 242

PROCEDURE Update_line_attribs(
    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_ATTRIBS_Rec     IN    ASO_quote_PUB.LINE_ATTRIBS_EXT_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: 259

	    IS Select --rowid,
           LINE_ATTRIBUTE_ID,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
		 APPLICATION_ID,
		 status,
		 QUOTE_LINE_ID,
		 ATTRIBUTE_TYPE_CODE,
           NAME,
           VALUE,
		 VALUE_TYPE,
           START_DATE_ACTIVE,
           END_DATE_ACTIVE
    From  ASO_QUOTE_LINE_ATTRIBS_EXT
    where LINE_ATTRIBUTE_ID = P_LINE_ATTRIBUTE_ID;

Line: 284

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

Line: 293

      SAVEPOINT UPDATE_LINE_ATTRIBS_PVT;

Line: 327

          AS_CALLOUT_PKG.Update_line_attribs_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_ATTRIBS_Rec      =>  P_LINE_ATTRIBS_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: 354

      ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

Line: 364

               l_ref_LINE_ATTRIBS_rec.LAST_UPDATE_DATE,
               l_ref_LINE_ATTRIBS_rec.LAST_UPDATED_BY,
               l_ref_LINE_ATTRIBS_rec.LAST_UPDATE_LOGIN,
               l_ref_LINE_ATTRIBS_rec.REQUEST_ID,
               l_ref_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
               l_ref_LINE_ATTRIBS_rec.PROGRAM_ID,
               l_ref_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
			l_ref_LINE_ATTRIBS_rec.APPLICATION_ID,
			l_ref_LINE_ATTRIBS_rec.STATUS,
               l_ref_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
               l_ref_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
               l_ref_LINE_ATTRIBS_rec.NAME,
               l_ref_LINE_ATTRIBS_rec.VALUE,
			l_ref_LINE_ATTRIBS_rec.VALUE_TYPE,
               l_ref_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
               l_ref_LINE_ATTRIBS_rec.END_DATE_ACTIVE;

Line: 384

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

Line: 396

      If (l_tar_LINE_ATTRIBS_rec.last_update_date is NULL or
          l_tar_LINE_ATTRIBS_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: 401

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

Line: 407

      If (l_tar_LINE_ATTRIBS_rec.last_update_date <> l_ref_LINE_ATTRIBS_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: 426

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

Line: 443

      ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Update_Row(
          p_LINE_ATTRIBUTE_ID  => p_LINE_ATTRIBS_rec.LINE_ATTRIBUTE_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_LINE_ATTRIBS_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_LINE_ATTRIBS_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => p_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
		p_APPLICATION_ID=> p_LINE_ATTRIBS_rec.application_id,
		p_STATUS => p_LINE_ATTRIBS_rec.status,
          p_QUOTE_HEADER_ID  => p_LINE_ATTRIBS_rec.QUOTE_HEADER_ID,
          p_QUOTE_LINE_ID  => p_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
          p_QUOTE_SHIPMENT_ID  => p_LINE_ATTRIBS_rec.QUOTE_SHIPMENT_ID,
          p_ATTRIBUTE_TYPE_CODE  => p_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
          p_NAME  => p_LINE_ATTRIBS_rec.NAME,
          p_VALUE  => p_LINE_ATTRIBS_rec.VALUE,
		p_VALUE_TYPE => P_LINE_ATTRIBS_rec.VALUE_TYPE,
          p_START_DATE_ACTIVE  => p_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
          p_END_DATE_ACTIVE  => p_LINE_ATTRIBS_rec.END_DATE_ACTIVE,
		p_OBJECT_VERSION_NUMBER => p_LINE_ATTRIBS_rec.OBJECT_VERSION_NUMBER
		);

Line: 493

          AS_CALLOUT_PKG.Update_line_attribs_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_ATTRIBS_Rec      =>  P_LINE_ATTRIBS_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: 536

End Update_line_attribs;

Line: 541

PROCEDURE Delete_line_attribs(
    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_ATTRIBS_Rec     IN ASO_quote_PUB.LINE_ATTRIBS_EXT_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_line_attribs';

Line: 559

      SAVEPOINT DELETE_LINE_ATTRIBS_PVT;

Line: 593

          AS_CALLOUT_PKG.Delete_line_attribs_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_ATTRIBS_Rec      =>  P_LINE_ATTRIBS_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: 620

      ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

Line: 623

      ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Delete_Row(
          p_LINE_ATTRIB_ID  => p_LINE_ATTRIBS_rec.LINE_ATTRIBUTE_ID);

Line: 651

          AS_CALLOUT_PKG.Delete_line_attribs_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_ATTRIBS_Rec      =>  P_LINE_ATTRIBS_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: 694

End Delete_line_attribs;

Line: 737

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

Line: 784

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

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

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

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

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

END Validate_PROGRAM_UPDATE_DATE;

Line: 981

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

Line: 989

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

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

Line: 1047

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

Line: 1094

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

Line: 1104

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

Line: 1113

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

Line: 1162

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

Line: 1171

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

Line: 1179

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

Line: 1228

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

Line: 1275

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

Line: 1322

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