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_LINE_RLTSHIP_PVT dependencies on ASO_QUOTE_PUB

Line 21: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC,

17: P_Api_Version_Number IN NUMBER,
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC,
22: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
23: X_LINE_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
25: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 245: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,

241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
242: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: -- P_Identity_Salesforce_Id IN NUMBER := NULL,
245: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
246: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
247: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
248: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
249: )

Line 281: l_ref_LINE_RLTSHIP_rec ASO_QUOTE_PUB.LINE_RLTSHIP_Rec_Type;

277: l_api_name CONSTANT VARCHAR2(30) := 'Update_line_rltship';
278: l_api_version_number CONSTANT NUMBER := 1.0;
279: -- Local Variables
280: --l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
281: l_ref_LINE_RLTSHIP_rec ASO_QUOTE_PUB.LINE_RLTSHIP_Rec_Type;
282: l_tar_LINE_RLTSHIP_rec ASO_QUOTE_PUB.LINE_RLTSHIP_Rec_Type := P_LINE_RLTSHIP_Rec;
283: l_rowid ROWID;
284: BEGIN
285: -- Standard Start of API savepoint

Line 282: l_tar_LINE_RLTSHIP_rec ASO_QUOTE_PUB.LINE_RLTSHIP_Rec_Type := P_LINE_RLTSHIP_Rec;

278: l_api_version_number CONSTANT NUMBER := 1.0;
279: -- Local Variables
280: --l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
281: l_ref_LINE_RLTSHIP_rec ASO_QUOTE_PUB.LINE_RLTSHIP_Rec_Type;
282: l_tar_LINE_RLTSHIP_rec ASO_QUOTE_PUB.LINE_RLTSHIP_Rec_Type := P_LINE_RLTSHIP_Rec;
283: l_rowid ROWID;
284: BEGIN
285: -- Standard Start of API savepoint
286: SAVEPOINT UPDATE_LINE_RLTSHIP_PVT;

Line 526: p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,

522: P_Api_Version_Number IN NUMBER,
523: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
524: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526: p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
527: -- P_identity_salesforce_id IN NUMBER := NULL,
528: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
529: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
530: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 528: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,

524: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526: p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
527: -- P_identity_salesforce_id IN NUMBER := NULL,
528: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
529: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
530: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
531: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
532: )

Line 559: l_line_rltship_rec ASO_quote_PUB.Line_Rltship_Rec_Type;

555: l_api_name CONSTANT VARCHAR2(30) := 'Delete_line_rltship';
556: l_api_version_number CONSTANT NUMBER := 1.0;
557: --identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
558:
559: l_line_rltship_rec ASO_quote_PUB.Line_Rltship_Rec_Type;
560: l_relationship_id NUMBER;
561: l_qte_line_rec ASO_QUOTE_PUB.qte_line_Rec_Type;
562:
563: BEGIN

Line 561: l_qte_line_rec ASO_QUOTE_PUB.qte_line_Rec_Type;

557: --identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
558:
559: l_line_rltship_rec ASO_quote_PUB.Line_Rltship_Rec_Type;
560: l_relationship_id NUMBER;
561: l_qte_line_rec ASO_QUOTE_PUB.qte_line_Rec_Type;
562:
563: BEGIN
564: -- Standard Start of API savepoint
565: SAVEPOINT DELETE_LINE_RLTSHIP_PVT;

Line 804: P_LINE_RLTSHIP_Rec IN ASO_QUOTE_PUB.LINE_RLTSHIP_Rec_Type,

800:
801:
802: -- This procudure defines the columns for the Dynamic SQL.
803: PROCEDURE Define_Columns(
804: P_LINE_RLTSHIP_Rec IN ASO_QUOTE_PUB.LINE_RLTSHIP_Rec_Type,
805: p_cur_get_LINE_RLTSHIP IN NUMBER
806: )
807: IS
808: BEGIN

Line 879: X_LINE_RLTSHIP_Rec OUT NOCOPY /* file.sql.39 change */ ASO_quote_PUB.LINE_RLTSHIP_Rec_Type

875:
876: -- This procudure gets column values by the Dynamic SQL.
877: PROCEDURE Get_Column_Values(
878: p_cur_get_LINE_RLTSHIP IN NUMBER,
879: X_LINE_RLTSHIP_Rec OUT NOCOPY /* file.sql.39 change */ ASO_quote_PUB.LINE_RLTSHIP_Rec_Type
880: )
881: IS
882: BEGIN
883: null;

Line 888: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,

884: END Get_Column_Values;
885:
886: -- This procedure bind the variables for the Dynamic SQL
887: PROCEDURE Bind(
888: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
889: -- Hint: Add more binding variables here
890: p_cur_get_LINE_RLTSHIP IN NUMBER
891: )
892: IS

Line 919: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,

915: null;
916: END Gen_Select;
917:
918: PROCEDURE Gen_LINE_RLTSHIP_Where(
919: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
920: x_LINE_RLTSHIP_where OUT NOCOPY /* file.sql.39 change */ VARCHAR2
921: )
922: IS
923: -- cursors to check if wildcard values '%' and '_' have been passed

Line 1549: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,

1545: -- stored in database table.
1546: PROCEDURE Validate_LINE_RLTSHIP_rec(
1547: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1548: P_Validation_mode IN VARCHAR2,
1549: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
1550: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1551: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1552: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1553: )

Line 1587: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,

1583: PROCEDURE Validate_line_rltship(
1584: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1585: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1586: P_Validation_mode IN VARCHAR2,
1587: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
1588: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1589: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1590: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1591: )