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

Line 26: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE

22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
27: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
29: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
30: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 27: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,

23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
27: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
29: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
30: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
27: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
29: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
30: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
32: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 29: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,

25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
27: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
29: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
30: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
32: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
33:

Line 40: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type

36: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
37: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
38: P_Shipment_Tbl_Cnt IN NUMBER,
39: P_Line_Index IN NUMBER,
40: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
41: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
42:
43:
44: FUNCTION Query_Shipment_Rows (

Line 41: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

37: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
38: P_Shipment_Tbl_Cnt IN NUMBER,
39: P_Line_Index IN NUMBER,
40: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
41: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
42:
43:
44: FUNCTION Query_Shipment_Rows (
45: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 48: lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type

44: FUNCTION Query_Shipment_Rows (
45: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
46: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
47: P_Line_Index IN NUMBER,
48: lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type
49: ) RETURN VARCHAR2;
50:
51:
52: FUNCTION Query_Freight_Charge_Rows (

Line 53: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

49: ) RETURN VARCHAR2;
50:
51:
52: FUNCTION Query_Freight_Charge_Rows (
53: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
54: P_Line_Index IN NUMBER,
55: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
56: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
57:

Line 55: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type

51:
52: FUNCTION Query_Freight_Charge_Rows (
53: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
54: P_Line_Index IN NUMBER,
55: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
56: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
57:
58:
59: FUNCTION Query_Sales_Credit_Row (

Line 56: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

52: FUNCTION Query_Freight_Charge_Rows (
53: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
54: P_Line_Index IN NUMBER,
55: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
56: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
57:
58:
59: FUNCTION Query_Sales_Credit_Row (
60: P_qte_header_Id IN NUMBER,

Line 63: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type

59: FUNCTION Query_Sales_Credit_Row (
60: P_qte_header_Id IN NUMBER,
61: P_qte_line_id IN NUMBER,
62: P_Line_Index IN NUMBER,
63: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
64: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
65:
66:
67: FUNCTION Query_Quote_Party_Row (

Line 64: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type;

60: P_qte_header_Id IN NUMBER,
61: P_qte_line_id IN NUMBER,
62: P_Line_Index IN NUMBER,
63: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
64: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
65:
66:
67: FUNCTION Query_Quote_Party_Row (
68: P_Qte_header_Id IN NUMBER,

Line 71: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type

67: FUNCTION Query_Quote_Party_Row (
68: P_Qte_header_Id IN NUMBER,
69: P_Qte_line_Id IN NUMBER,
70: P_Line_Index IN NUMBER,
71: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
72: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
73:
74:
75: FUNCTION Query_Line_Dtl_Rows (

Line 72: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;

68: P_Qte_header_Id IN NUMBER,
69: P_Qte_line_Id IN NUMBER,
70: P_Line_Index IN NUMBER,
71: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
72: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
73:
74:
75: FUNCTION Query_Line_Dtl_Rows (
76: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 78: lx_Line_Dtl_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

74:
75: FUNCTION Query_Line_Dtl_Rows (
76: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
77: P_Line_Index IN NUMBER,
78: lx_Line_Dtl_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
79: ) RETURN VARCHAR2;
80:
81:
82: FUNCTION Query_Line_Attribs_Ext_Rows(

Line 85: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type

81:
82: FUNCTION Query_Line_Attribs_Ext_Rows(
83: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
84: P_Line_Index IN NUMBER,
85: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
86: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
87:
88:
89: FUNCTION Query_Price_Attr_Rows (

Line 86: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

82: FUNCTION Query_Line_Attribs_Ext_Rows(
83: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
84: P_Line_Index IN NUMBER,
85: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
86: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
87:
88:
89: FUNCTION Query_Price_Attr_Rows (
90: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 93: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

89: FUNCTION Query_Price_Attr_Rows (
90: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
91: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
92: P_Line_Index IN NUMBER,
93: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
94: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
95:
96:
97: FUNCTION Query_Price_Adj_Rltship_Rows (

Line 94: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

90: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
91: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
92: P_Line_Index IN NUMBER,
93: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
94: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
95:
96:
97: FUNCTION Query_Price_Adj_Rltship_Rows (
98: P_Price_Adjustment_Id IN NUMBER,

Line 100: lx_price_adj_rltd_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

96:
97: FUNCTION Query_Price_Adj_Rltship_Rows (
98: P_Price_Adjustment_Id IN NUMBER,
99: P_Line_Index IN NUMBER,
100: lx_price_adj_rltd_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
101: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
102:
103:
104: FUNCTION Query_Price_Adj_Rows (

Line 101: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

97: FUNCTION Query_Price_Adj_Rltship_Rows (
98: P_Price_Adjustment_Id IN NUMBER,
99: P_Line_Index IN NUMBER,
100: lx_price_adj_rltd_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
101: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
102:
103:
104: FUNCTION Query_Price_Adj_Rows (
105: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 106: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

102:
103:
104: FUNCTION Query_Price_Adj_Rows (
105: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
106: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
107: P_Line_Index IN NUMBER,
108: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
109: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
110: ) RETURN VARCHAR2;

Line 108: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

104: FUNCTION Query_Price_Adj_Rows (
105: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
106: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
107: P_Line_Index IN NUMBER,
108: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
109: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
110: ) RETURN VARCHAR2;
111:
112:

Line 109: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type

105: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
106: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
107: P_Line_Index IN NUMBER,
108: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
109: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
110: ) RETURN VARCHAR2;
111:
112:
113: FUNCTION Query_Price_Adj_Hdr_Rows (

Line 116: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

112:
113: FUNCTION Query_Price_Adj_Hdr_Rows (
114: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
115: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
116: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
117:
118:
119: PROCEDURE Raise_Quote_Event(
120: P_Quote_Header_id IN NUMBER,

Line 121: P_Control_Rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type

117:
118:
119: PROCEDURE Raise_Quote_Event(
120: P_Quote_Header_id IN NUMBER,
121: P_Control_Rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
122: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
123: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
124:
125:

Line 122: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,

118:
119: PROCEDURE Raise_Quote_Event(
120: P_Quote_Header_id IN NUMBER,
121: P_Control_Rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
122: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
123: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
124:
125:
126: PROCEDURE Quote_Order_High_Availability(