DBA Data[Home] [Help]

APPS.ASO_PRICE_ADJ_RLTSHIP_PVT dependencies on ASO_QUOTE_PUB

Line 45: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type

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,

Line 46: := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_RLTSHIP_REC,

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,

Line 261: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,

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

Line 292: l_ref_PRICE_ADJ_RLTSHIP_rec ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type;

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

Line 293: l_tar_PRICE_ADJ_RLTSHIP_rec ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type := P_PRICE_ADJ_RLTSHIP_Rec;

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;

Line 541: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,

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

Line 909: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,

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

Line 934: P_PRICE_ADJ_RLTSHIP_Rec IN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_Rec_Type,

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