The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
l_api_name VARCHAR2(240) := 'UPDATE_LINE_RELATIONSHIP';
SAVEPOINT UPDATE_LINE_RELATIONSHIP_PUB;
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
);
End Update_line_relationship;
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;
l_api_name VARCHAR2(240) := 'DELETE_LINE_RELATIONSHIP';
SAVEPOINT DELETE_LINE_RELATIONSHIP_PUB;
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
);
End Delete_line_relationship;
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;
l_api_name VARCHAR2(240) := 'UPDATE_HEADER_RELATIONSHIP';
SAVEPOINT UPDATE_HEADER_RELATIONSHIP_PUB;
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
);
End Update_header_relationship;
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;
l_api_name VARCHAR2(240) := 'DELETE_HEADER_RELATIONSHIP';
SAVEPOINT DELETE_HEADER_RELATIONSHIP_PUB;
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
);
End Delete_header_relationship;
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;
l_api_name VARCHAR2(240) := 'UPDATE_PARTY_RELATIONSHIP';
SAVEPOINT UPDATE_PARTY_RELATIONSHIP_PUB;
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
);
End update_party_relationship;
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;
l_api_name VARCHAR2(240) := 'DELETE_PARTY_RELATIONSHIP';
SAVEPOINT DELETE_PARTY_RELATIONSHIP_PUB;
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
);
End Delete_party_relationship;
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;
l_api_name VARCHAR2(240) := 'UPDATE_OBJECT_RELATIONSHIP';
SAVEPOINT UPDATE_OBJECT_RELATIONSHIP_PUB;
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
);
End Update_object_relationship;
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;
l_api_name VARCHAR2(240) := 'DELETE_OBJECT_RELATIONSHIP';
SAVEPOINT DELETE_OBJECT_RELATIONSHIP_PUB;
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
);
End DELETE_OBJECT_RELATIONSHIP;
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;
l_api_name VARCHAR2(240) := 'UPDATE_Price_Adj_RELATIONSHIP';
SAVEPOINT UPdate_PRICE_ADJ_RLTSHIP_PUB;
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
);
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;
l_api_name VARCHAR2(240) := 'DELETE_Price_Adj_RELATIONSHIP';
SAVEPOINT DELETE_PRICE_ADJ_RLTSHIP_PUB;
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
);