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

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

Line: 171


PROCEDURE Update_Line_Relationship(
    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_Line_Rltship_Rec      IN   ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_REC,
    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_version_number NUMBER := 1.0;

Line: 182


l_api_name   VARCHAR2(240)  := 'UPDATE_LINE_RELATIONSHIP';

Line: 186


      SAVEPOINT UPDATE_LINE_RELATIONSHIP_PUB;

Line: 228


    ASO_LINE_RLTSHIP_PVT.Update_line_rltship(
    P_Api_Version_Number  => 1.0,
    P_Init_Msg_List       => FND_API.G_FALSE,
    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: 287


End Update_line_relationship;

Line: 307


PROCEDURE Delete_Line_Relationship(
    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_control_rec                IN  ASO_QUOTE_PUB.control_rec_type    := ASO_QUOTE_PUB.G_MISS_Control_Rec,
    P_Line_Rltship_Rec      IN   ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_rec,
    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_version_number NUMBER := 1.0;

Line: 319


l_api_name   VARCHAR2(240)  := 'DELETE_LINE_RELATIONSHIP';

Line: 323


      SAVEPOINT DELETE_LINE_RELATIONSHIP_PUB;

Line: 363


    ASO_LINE_RLTSHIP_PVT.Delete_line_rltship(
    P_Api_Version_Number  => 1.0,
    P_Init_Msg_List       => FND_API.G_FALSE,
    p_control_rec         => p_control_rec,
    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: 431


End Delete_line_relationship;

Line: 586


PROCEDURE Update_Header_Relationship(
    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_Header_Rltship_Rec      IN   ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.
G_MISS_header_rltship_REC,
    X_header_relationship_id       OUT NOCOPY /* file.sql.39 change */    NUMBER,
    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_version_number NUMBER := 1.0;

Line: 599


l_api_name   VARCHAR2(240)  := 'UPDATE_HEADER_RELATIONSHIP';

Line: 603


      SAVEPOINT UPDATE_HEADER_RELATIONSHIP_PUB;

Line: 645


    ASO_HEADER_RLTSHIP_PVT.Update_header_rltship(
    P_Api_Version_Number       => 1.0,
    P_Init_Msg_List            => FND_API.G_FALSE ,
    P_HEADER_RLTSHIP_Rec         => P_HEADER_RLTSHIP_Rec ,
    X_Return_Status            => X_Return_Status ,
    X_Msg_Count                => X_Msg_Count,
    X_Msg_Data                 => X_Msg_Data
    );

Line: 711


End Update_header_relationship;

Line: 729


PROCEDURE Delete_Header_Relationship(
    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_Header_Rltship_Rec      IN   ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.
G_MISS_header_rltship_REC,
    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_version_number NUMBER := 1.0;

Line: 741


l_api_name   VARCHAR2(240)  := 'DELETE_HEADER_RELATIONSHIP';

Line: 746


      SAVEPOINT DELETE_HEADER_RELATIONSHIP_PUB;

Line: 790


   ASO_HEADER_RLTSHIP_PVT.Delete_header_rltship(
    P_Api_Version_Number       => 1.0,
    P_Init_Msg_List            => FND_API.G_FALSE ,
    P_HEADER_RLTSHIP_id         => P_HEADER_RLTSHIP_Rec.header_relationship_id ,
    X_Return_Status            => X_Return_Status ,
    X_Msg_Count                => X_Msg_Count,
    X_Msg_Data                 => X_Msg_Data
    );

Line: 847


End Delete_header_relationship;

Line: 991


PROCEDURE Update_Party_Relationship(
    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_Party_Rltship_Rec      IN   ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
    X_party_relationship_id       OUT NOCOPY /* file.sql.39 change */   NUMBER,
    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_version_number NUMBER := 1.0;

Line: 1003


l_api_name   VARCHAR2(240)  := 'UPDATE_PARTY_RELATIONSHIP';

Line: 1007


      SAVEPOINT UPDATE_PARTY_RELATIONSHIP_PUB;

Line: 1038


         ASO_PARTY_RLTSHIP_PVT.Update_party_rltship(
    P_Api_Version_Number       => 1.0,
    P_Init_Msg_List            => FND_API.G_FALSE ,
    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: 1099


End update_party_relationship;

Line: 1118


PROCEDURE Delete_Party_Relationship(
    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_Party_Rltship_Rec      IN   ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
    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_version_number NUMBER := 1.0;

Line: 1129


l_api_name   VARCHAR2(240)  := 'DELETE_PARTY_RELATIONSHIP';

Line: 1133


      SAVEPOINT DELETE_PARTY_RELATIONSHIP_PUB;

Line: 1171


 ASO_PARTY_RLTSHIP_PVT.Delete_party_rltship(
    P_Api_Version_Number       => 1.0,
    P_Init_Msg_List            => FND_API.G_FALSE ,
    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: 1231


End Delete_party_relationship;

Line: 1395


PROCEDURE Update_Object_Relationship(
    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_RELATED_OBJ_Rec     IN    ASO_QUOTE_PUB.RELATED_OBJ_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_version_number NUMBER := 1.0;

Line: 1407


l_api_name   VARCHAR2(240)  := 'UPDATE_OBJECT_RELATIONSHIP';

Line: 1412


      SAVEPOINT UPDATE_OBJECT_RELATIONSHIP_PUB;

Line: 1455


   ASO_RELATED_OBJ_PVT.Update_related_obj(
    P_Api_Version_Number      => 1.0,
    P_Init_Msg_List           => FND_API.G_FALSE ,
    P_commit		      => P_commit,
    p_validation_level       => p_validation_level,
    P_RELATED_OBJ_Rec         =>   P_RELATED_OBJ_Rec,
    X_Return_Status           => X_Return_Status ,
    X_Msg_Count                => X_Msg_Count,
    X_Msg_Data                 => X_Msg_Data
    );

Line: 1522


End Update_object_relationship;

Line: 1544


PROCEDURE DELETE_OBJECT_RELATIONSHIP(
    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_RELATED_OBJ_Rec     IN ASO_QUOTE_PUB.RELATED_OBJ_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_version_number NUMBER := 1.0;

Line: 1556


l_api_name   VARCHAR2(240)  := 'DELETE_OBJECT_RELATIONSHIP';

Line: 1560


      SAVEPOINT DELETE_OBJECT_RELATIONSHIP_PUB;

Line: 1602


        ASO_RELATED_OBJ_PVT.Delete_related_obj(
    P_Api_Version_Number       => 1.0,
    P_Init_Msg_List            => FND_API.G_FALSE ,
    P_commit                   => P_commit,
    p_validation_level         => p_validation_level,
    P_RELATED_OBJ_Rec          => P_RELATED_OBJ_Rec ,
    X_Return_Status            => X_Return_Status ,
    X_Msg_Count                => X_Msg_Count,
    X_Msg_Data                 => X_Msg_Data
    );

Line: 1668


End DELETE_OBJECT_RELATIONSHIP;

Line: 1821


    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_Price_Adj_Rltship_Rec      IN   ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
    X_adj_relationship_id        OUT NOCOPY /* file.sql.39 change */   NUMBER,
    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_version_number NUMBER := 1.0;

Line: 1833


l_api_name   VARCHAR2(240)  := 'UPDATE_Price_Adj_RELATIONSHIP';

Line: 1836


      SAVEPOINT UPdate_PRICE_ADJ_RLTSHIP_PUB;

Line: 1877


    ASO_PRICE_ADJ_RLTSHIP_PVT.Update_price_adj_rltship(
    P_Api_Version_Number       => 1.0,
    P_Init_Msg_List            => FND_API.G_FALSE ,
    p_commit                   => p_commit,
    P_PRICE_ADJ_RLTSHIP_Rec    => P_PRICE_ADJ_RLTSHIP_Rec ,
    X_Return_Status            => X_Return_Status ,
    X_Msg_Count                => X_Msg_Count,
    X_Msg_Data                 => X_Msg_Data
    );

Line: 1955


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_Price_Adj_Rltship_Rec      IN   ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
    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_version_number NUMBER := 1.0;

Line: 1967


l_api_name   VARCHAR2(240)  := 'DELETE_Price_Adj_RELATIONSHIP';

Line: 1970


      SAVEPOINT DELETE_PRICE_ADJ_RLTSHIP_PUB;

Line: 2010


    ASO_PRICE_ADJ_RLTSHIP_PVT.Delete_price_adj_rltship(
    P_Api_Version_Number       => 1.0,
    P_Init_Msg_List            => FND_API.G_FALSE ,
    p_commit                   => p_commit,
    P_PRICE_ADJ_RLTSHIP_Rec    => P_PRICE_ADJ_RLTSHIP_Rec ,
    X_Return_Status            => X_Return_Status ,
    X_Msg_Count                => X_Msg_Count,
    X_Msg_Data                 => X_Msg_Data
    );