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_PRICE_ADJ_RLTSHIP_PVT SQL Statements

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

Line: 138


         ASO_PRICE_RLTSHIPS_PKG.Insert_row
         (
          px_ADJ_RELATIONSHIP_ID  => x_ADJ_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_PROGRAM_APPLICATION_ID => P_PRICE_ADJ_RLTSHIP_Rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID            => P_PRICE_ADJ_RLTSHIP_Rec.PROGRAM_ID ,
          p_PROGRAM_UPDATE_DATE =>P_PRICE_ADJ_RLTSHIP_Rec.PROGRAM_UPDATE_DATE ,
          p_REQUEST_ID           =>P_PRICE_ADJ_RLTSHIP_Rec.Request_id   ,
          p_QUOTE_LINE_ID        =>P_PRICE_ADJ_RLTSHIP_Rec.quote_line_id  ,
          p_PRICE_ADJUSTMENT_ID  =>P_PRICE_ADJ_RLTSHIP_Rec.price_adjustment_id,
          p_RLTD_PRICE_ADJ_ID  => P_PRICE_ADJ_RLTSHIP_Rec.rltd_price_adj_id,
		p_quote_shipment_id  => P_PRICE_ADJ_RLTSHIP_Rec.quote_shipment_id,
		p_OBJECT_VERSION_NUMBER => P_PRICE_ADJ_RLTSHIP_Rec.OBJECT_VERSION_NUMBER);

Line: 256


PROCEDURE Update_price_adj_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_PRICE_ADJ_RLTSHIP_Rec      IN   ASO_QUOTE_PUB.PRICE_ADJ_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: 271


    Select --rowid,
	ADJ_RELATIONSHIP_ID	,
 	CREATION_DATE		,
 	CREATED_BY		,
 	LAST_UPDATE_DATE	,
 	LAST_UPDATED_BY		,
 	LAST_UPDATE_LOGIN	,
 	PROGRAM_APPLICATION_ID 	,
 	PROGRAM_ID		,
 	PROGRAM_UPDATE_DATE	,
 	REQUEST_ID		,
 	QUOTE_LINE_ID		,
 	PRICE_ADJUSTMENT_ID	,
 	RLTD_PRICE_ADJ_ID
    From  ASO_PRICE_ADJ_RELATIONSHIPS
    where ADJ_RELATIONSHIP_ID = lc_ADJ_RELATIONSHIP_ID;

Line: 290


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

Line: 297


      SAVEPOINT UPDATE_PRICE_ADJ_RLTSHIP_PVT;

Line: 327


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


 	l_ref_PRICE_ADJ_RLTSHIP_rec.LAST_UPDATE_DATE	,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.LAST_UPDATED_BY		,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.LAST_UPDATE_LOGIN	,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.PROGRAM_APPLICATION_ID 	,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.PROGRAM_ID		,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.PROGRAM_UPDATE_DATE	,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.REQUEST_ID		,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.QUOTE_LINE_ID		,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.PRICE_ADJUSTMENT_ID	,
 	l_ref_PRICE_ADJ_RLTSHIP_rec.RLTD_PRICE_ADJ_ID	;

Line: 363


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

Line: 375


      If (l_tar_PRICE_ADJ_RLTSHIP_rec.last_update_date is NULL or
          l_tar_PRICE_ADJ_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: 380


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

Line: 386


      If (l_tar_PRICE_ADJ_RLTSHIP_rec.last_update_date <> l_ref_PRICE_ADJ_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: 420


         ASO_PRICE_RLTSHIPS_PKG.Update_row
         (
          p_ADJ_RELATIONSHIP_ID  =>P_PRICE_ADJ_RLTSHIP_Rec.ADJ_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_PROGRAM_APPLICATION_ID => P_PRICE_ADJ_RLTSHIP_Rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID            => P_PRICE_ADJ_RLTSHIP_Rec.PROGRAM_ID ,
          p_PROGRAM_UPDATE_DATE =>P_PRICE_ADJ_RLTSHIP_Rec.PROGRAM_UPDATE_DATE ,
          p_REQUEST_ID           =>P_PRICE_ADJ_RLTSHIP_Rec.Request_id   ,
          p_QUOTE_LINE_ID        =>P_PRICE_ADJ_RLTSHIP_Rec.quote_line_id  ,
          p_PRICE_ADJUSTMENT_ID  =>P_PRICE_ADJ_RLTSHIP_Rec.price_adjustment_id,
          p_RLTD_PRICE_ADJ_ID  => P_PRICE_ADJ_RLTSHIP_Rec.rltd_price_adj_id,
		p_quote_shipment_id  => P_PRICE_ADJ_RLTSHIP_Rec.quote_shipment_id,
		p_OBJECT_VERSION_NUMBER => P_PRICE_ADJ_RLTSHIP_Rec.OBJECT_VERSION_NUMBER);

Line: 461


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


End Update_price_adj_rltship;

Line: 536


PROCEDURE Delete_price_adj_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_PRICE_ADJ_RLTSHIP_Rec     IN ASO_QUOTE_PUB.PRICE_ADJ_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_price_adj_rltship';

Line: 552


 SELECT adj_relationship_id
 FROM aso_price_adj_relationships
 WHERE quote_line_id = P_PRICE_ADJ_RLTSHIP_Rec.quote_line_id;

Line: 558


      SAVEPOINT DELETE_PRICE_ADJ_RLTSHIP_PVT;

Line: 618


        ASO_PRICE_RLTSHIPS_PKG.Delete_Row(
         p_ADJ_RELATIONSHIP_ID => i.adj_relationship_id);

Line: 691


END Delete_price_adj_rltship;

Line: 781


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 */      AS_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
NULL;