41: P_Api_Version_Number IN NUMBER,
42: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
43: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type
46: := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_RLTSHIP_REC,
47: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
48: X_ADJ_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
49: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
42: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
43: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
44: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type
46: := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_RLTSHIP_REC,
47: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
48: X_ADJ_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
49: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
50: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
257: P_Api_Version_Number IN NUMBER,
258: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
259: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
262: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
263: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
264: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
265: )
288: --For Update NOWAIT;
289:
290: l_api_name CONSTANT VARCHAR2(30) := 'Update_price_adj_rltship';
291: l_api_version_number CONSTANT NUMBER := 1.0;
292: l_ref_PRICE_ADJ_RLTSHIP_rec ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type;
293: l_tar_PRICE_ADJ_RLTSHIP_rec ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type := P_PRICE_ADJ_RLTSHIP_Rec;
294: l_rowid ROWID;
295: BEGIN
296: -- Standard Start of API savepoint
289:
290: l_api_name CONSTANT VARCHAR2(30) := 'Update_price_adj_rltship';
291: l_api_version_number CONSTANT NUMBER := 1.0;
292: l_ref_PRICE_ADJ_RLTSHIP_rec ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type;
293: l_tar_PRICE_ADJ_RLTSHIP_rec ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type := P_PRICE_ADJ_RLTSHIP_Rec;
294: l_rowid ROWID;
295: BEGIN
296: -- Standard Start of API savepoint
297: SAVEPOINT UPDATE_PRICE_ADJ_RLTSHIP_PVT;
537: P_Api_Version_Number IN NUMBER,
538: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
539: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
541: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
542: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
543: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
544: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
545: )
905:
906: PROCEDURE Validate_PRICE_ADJ_RLTSHIP_rec(
907: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
908: P_Validation_mode IN VARCHAR2,
909: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
910: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
911: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
912: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
913: )
930: PROCEDURE Validate_price_adj_rltship(
931: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
932: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
933: P_Validation_mode IN VARCHAR2,
934: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,
935: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
936: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
937: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
938: )