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 31: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type

27: P_Api_Version_Number IN NUMBER,
28: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
29: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
32: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
33: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
34: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
35: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 32: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,

28: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
29: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
32: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
33: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
34: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
35: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
36: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 33: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

29: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
32: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
33: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
34: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
35: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
36: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
37: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

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

30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
32: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
33: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
34: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
35: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
36: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
37: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
38:

Line 91: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

87: l_instance_id NUMBER;
88: l_api_name CONSTANT VARCHAR2(30) := 'Submit_Quote';
89: l_api_version_number CONSTANT NUMBER := 1.0;
90: l_return_status VARCHAR2(1);
91: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
92: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
93: lx_out_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 92: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

88: l_api_name CONSTANT VARCHAR2(30) := 'Submit_Quote';
89: l_api_version_number CONSTANT NUMBER := 1.0;
90: l_return_status VARCHAR2(1);
91: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
92: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
93: lx_out_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 93: lx_out_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

89: l_api_version_number CONSTANT NUMBER := 1.0;
90: l_return_status VARCHAR2(1);
91: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
92: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
93: lx_out_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

90: l_return_status VARCHAR2(1);
91: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
92: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
93: lx_out_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

91: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
92: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
93: lx_out_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

92: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
93: lx_out_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

93: lx_out_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

94: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

95: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

96: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

97: l_hd_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
105: -- l_hd_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;

Line 102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

98: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
105: -- l_hd_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

99: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
105: -- l_hd_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

100: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
101: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
105: -- l_hd_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

102: l_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
105: -- l_hd_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

103: l_hd_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
105: -- l_hd_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

104: l_hd_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
105: -- l_hd_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

105: -- l_hd_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

106: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

107: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

108: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
116: -- l_LN_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;

Line 113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

109: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
116: -- l_LN_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

110: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
116: -- l_LN_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

111: l_ln_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
112: l_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
116: -- l_LN_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

113: l_ln_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
116: -- l_LN_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

114: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
116: -- l_LN_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
122: l_tmp_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

115: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
116: -- l_LN_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
122: l_tmp_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
123: l_tmp_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

116: -- l_LN_sales_credit_tbl ASO_ORDER_INT.Sales_credit_tbl_type;
117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
122: l_tmp_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
123: l_tmp_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
124: l_tmp_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

117: l_tmp_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
122: l_tmp_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
123: l_tmp_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
124: l_tmp_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
125:

Line 122: l_tmp_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

118: l_tmp_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
122: l_tmp_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
123: l_tmp_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
124: l_tmp_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
125:
126: l_order_control_rec ASO_ORDER_INT.CONTROL_REC_TYPE;

Line 123: l_tmp_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

119: l_tmp_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
122: l_tmp_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
123: l_tmp_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
124: l_tmp_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
125:
126: l_order_control_rec ASO_ORDER_INT.CONTROL_REC_TYPE;
127: lx_order_header_rec ASO_ORDER_INT.Order_Header_Rec_Type;

Line 124: l_tmp_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

120: l_tmp_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
121: l_tmp_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
122: l_tmp_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
123: l_tmp_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
124: l_tmp_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
125:
126: l_order_control_rec ASO_ORDER_INT.CONTROL_REC_TYPE;
127: lx_order_header_rec ASO_ORDER_INT.Order_Header_Rec_Type;
128: lx_order_line_tbl ASO_ORDER_INT.Order_Line_Tbl_Type;

Line 130: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

126: l_order_control_rec ASO_ORDER_INT.CONTROL_REC_TYPE;
127: lx_order_header_rec ASO_ORDER_INT.Order_Header_Rec_Type;
128: lx_order_line_tbl ASO_ORDER_INT.Order_Line_Tbl_Type;
129:
130: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
131: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
132: l_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;

Line 131: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

127: lx_order_header_rec ASO_ORDER_INT.Order_Header_Rec_Type;
128: lx_order_line_tbl ASO_ORDER_INT.Order_Line_Tbl_Type;
129:
130: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
131: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
132: l_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;

Line 132: l_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;

128: lx_order_line_tbl ASO_ORDER_INT.Order_Line_Tbl_Type;
129:
130: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
131: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
132: l_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;

Line 133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;

129:
130: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
131: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
132: l_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
137: l_tmp_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;

Line 134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;

130: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
131: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
132: l_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
137: l_tmp_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
138: l_Header_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;

131: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
132: l_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
137: l_tmp_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
138: l_Header_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
139: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type ;

Line 136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;

132: l_hd_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
137: l_tmp_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
138: l_Header_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
139: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type ;
140: l_qte_line_id NUMBER;

Line 137: l_tmp_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;

133: l_ln_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
137: l_tmp_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
138: l_Header_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
139: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type ;
140: l_qte_line_id NUMBER;
141: l_qte_status_id NUMBER;

Line 138: l_Header_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

134: l_tmp_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_tbl_Type;
135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
137: l_tmp_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
138: l_Header_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
139: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type ;
140: l_qte_line_id NUMBER;
141: l_qte_status_id NUMBER;
142: l_val VARCHAR2(1);

Line 139: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type ;

135: l_hd_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
136: l_ln_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
137: l_tmp_quote_party_tbl ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type;
138: l_Header_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
139: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type ;
140: l_qte_line_id NUMBER;
141: l_qte_status_id NUMBER;
142: l_val VARCHAR2(1);
143: l_enabled_flag VARCHAR2(1);

Line 148: l_related_obj_rec ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type;

144: l_index NUMBER;
145: l_quan_reserved NUMBER;
146: l_reservation_id NUMBER;
147: l_related_obj_id NUMBER;
148: l_related_obj_rec ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type;
149: count_rel NUMBER := 1;
150: l_payment_type_code VARCHAR2(30);
151: l_payment_amount NUMBER ;
152:

Line 161: l_Sales_Alloc_Control_Rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE

157: **/
158: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
159: l_sales_cred_prof VARCHAR2(50) := FND_PROFILE.value('ASO_AUTO_SALES_CREDIT');
160:
161: l_Sales_Alloc_Control_Rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
162: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;
163:
164: -- Change START
165: -- Release 12 MOAC Changes : Bug 4500739

Line 162: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;

158: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
159: l_sales_cred_prof VARCHAR2(50) := FND_PROFILE.value('ASO_AUTO_SALES_CREDIT');
160:
161: l_Sales_Alloc_Control_Rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
162: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;
163:
164: -- Change START
165: -- Release 12 MOAC Changes : Bug 4500739
166: -- Changes Done by : Girish

Line 181: l_tmp_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

177:
178: lx_status VARCHAR2(1); -- 2692785
179:
180: l_index_rlt NUMBER; -- pbh/prg
181: l_tmp_Price_Adj_Rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
182:
183: l_istore_source VARCHAR2(1) := 'N';
184: l_status VARCHAR2(1) := 'S';
185:

Line 189: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;

185:
186: -- ER 3177722
187: l_order_status_prof varchar2(10);
188: l_mdl_count number:=0;
189: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
190: l_Update_Allowed_Flg varchar2(1):='F';
191: l_ct_invalid number:=0;
192: l_ct_changed number:=0;
193: l_warning_config_exception EXCEPTION;

Line 492: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl);

488:
489: l_hd_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(
490: p_qte_header_id => p_qte_header_rec.quote_header_id,
491: p_qte_line_id => NULL,
492: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl);
493:
494: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(
495: p_qte_header_id => p_qte_header_rec.quote_header_id,
496: p_qte_line_id => NULL);

Line 554: ASO_QUOTE_PUB.validate_model_configuration

550: IF aso_debug_pub.g_debug_flag = 'Y' THEN
551: aso_debug_pub.add('Submit_Quote - l_Update_Allowed_Flg: '||l_Update_Allowed_Flg, 1, 'N');
552:
553: END IF;
554: ASO_QUOTE_PUB.validate_model_configuration
555: (
556: P_Api_Version_Number => 1.0,
557: P_Init_Msg_List => FND_API.G_FALSE,
558: P_Commit => FND_API.G_FALSE,

Line 570: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||X_Return_Status, 1, 'N');

566: X_Msg_Data => x_msg_data
567: );
568:
569: IF aso_debug_pub.g_debug_flag = 'Y' THEN
570: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||X_Return_Status, 1, 'N');
571: END IF;
572:
573: if (X_Return_Status = FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
574:

Line 576: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess lx_config_tbl: '||lx_config_tbl.count, 1, 'N');

572:
573: if (X_Return_Status = FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
574:
575: IF aso_debug_pub.g_debug_flag = 'Y' THEN
576: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
577: END IF;
578: l_ct_invalid:=0;
579: l_ct_changed:=0;
580: for i in 1..lx_config_tbl.count loop

Line 597: aso_debug_pub.add('rassharm Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess user defined exception: ', 1, 'N');

593: FND_MESSAGE.Set_Name('ASO', 'ASO_CHANGED_MODEL_LINES_REVIEW');
594: FND_MSG_PUB.ADD;
595: END IF;
596: IF aso_debug_pub.g_debug_flag = 'Y' THEN
597: aso_debug_pub.add('rassharm Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess user defined exception: ', 1, 'N');
598: END IF;
599: RAISE l_warning_config_exception;
600:
601:

Line 887: ASO_QUOTE_PUB.Allocate_Sales_Credits

883: IF (l_sales_cred_prof = 'FULL') THEN
884:
885: l_Sales_Alloc_Control_Rec.Submit_Quote_Flag := 'Y';
886:
887: ASO_QUOTE_PUB.Allocate_Sales_Credits
888: (
889: P_Api_Version_Number => 1.0,
890: P_Init_Msg_List => FND_API.G_FALSE,
891: P_Commit => FND_API.G_FALSE,

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

1372: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1373: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1374: P_Shipment_Tbl_Cnt IN NUMBER,
1375: P_Line_Index IN NUMBER,
1376: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1377: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1378: IS
1379: CURSOR c_tax1 IS
1380: SELECT

Line 1377: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type

1373: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1374: P_Shipment_Tbl_Cnt IN NUMBER,
1375: P_Line_Index IN NUMBER,
1376: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1377: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1378: IS
1379: CURSOR c_tax1 IS
1380: SELECT
1381: TAX_DETAIL_ID,

Line 1468: -- l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

1464: TAX_RATE_ID
1465: FROM ASO_TAX_DETAILS
1466: WHERE quote_line_id = p_qte_line_id;
1467:
1468: -- l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1469: l_tax_det_count NUMBER;
1470:
1471: BEGIN
1472: --Fix for bug 5714535. Setting the output table structure directly instead of

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

1584: FUNCTION Query_Shipment_Rows (
1585: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1586: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1587: P_Line_Index IN NUMBER,
1588: lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type
1589: ) RETURN VARCHAR2
1590: IS
1591: CURSOR c_shipment IS
1592: SELECT

Line 1714: -- l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1710: FREIGHT_TERMS_CODE_FROM
1711: FROM ASO_SHIPMENTS
1712: WHERE quote_line_id = p_qte_line_id;
1713:
1714: -- l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1715: l_ship_count NUMBER;
1716: l_status VARCHAR2(1) := 'S';
1717:
1718: BEGIN

Line 1862: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

1858: END Query_Shipment_Rows;
1859:
1860:
1861: FUNCTION Query_Freight_Charge_Rows (
1862: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
1863: P_Line_Index IN NUMBER,
1864: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1865: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1866: IS

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

1860:
1861: FUNCTION Query_Freight_Charge_Rows (
1862: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
1863: P_Line_Index IN NUMBER,
1864: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1865: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1866: IS
1867: CURSOR c_freight_charge (c_shipment_id NUMBER) IS
1868: SELECT

Line 1865: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type

1861: FUNCTION Query_Freight_Charge_Rows (
1862: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
1863: P_Line_Index IN NUMBER,
1864: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1865: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1866: IS
1867: CURSOR c_freight_charge (c_shipment_id NUMBER) IS
1868: SELECT
1869: FREIGHT_CHARGE_ID,

Line 1901: -- l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;

1897: ATTRIBUTE15
1898: FROM ASO_FREIGHT_CHARGES
1899: WHERE quote_shipment_id = c_shipment_id;
1900:
1901: -- l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;
1902: l_frt_chrg_count NUMBER;
1903:
1904: BEGIN
1905: --Fix for bug 5714535. Setting the output table structure directly instead of

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

1953: FUNCTION Query_Sales_Credit_Row (
1954: P_qte_header_Id IN NUMBER,
1955: P_qte_line_id IN NUMBER,
1956: P_Line_Index IN NUMBER,
1957: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1958: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1959: IS
1960:
1961: -- l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 1958: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type

1954: P_qte_header_Id IN NUMBER,
1955: P_qte_line_id IN NUMBER,
1956: P_Line_Index IN NUMBER,
1957: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1958: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1959: IS
1960:
1961: -- l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1962: l_sls_crdt_count NUMBER;

Line 1961: -- l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

1957: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1958: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1959: IS
1960:
1961: -- l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1962: l_sls_crdt_count NUMBER;
1963:
1964: CURSOR C1 IS
1965: SELECT

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

2051: FUNCTION Query_Quote_Party_Row (
2052: P_Qte_header_Id IN NUMBER,
2053: P_Qte_line_Id IN NUMBER,
2054: P_Line_Index IN NUMBER,
2055: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
2056: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
2057: IS
2058:
2059: -- l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;

Line 2056: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type

2052: P_Qte_header_Id IN NUMBER,
2053: P_Qte_line_Id IN NUMBER,
2054: P_Line_Index IN NUMBER,
2055: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
2056: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
2057: IS
2058:
2059: -- l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
2060: l_quote_party_count NUMBER;

Line 2059: -- l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;

2055: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
2056: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
2057: IS
2058:
2059: -- l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
2060: l_quote_party_count NUMBER;
2061:
2062: CURSOR C1 is
2063: SELECT QUOTE_PARTY_ID,

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

2146:
2147: FUNCTION Query_Line_Dtl_Rows (
2148: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2149: P_Line_Index IN NUMBER,
2150: lx_Line_Dtl_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2151: ) RETURN VARCHAR2
2152: IS
2153: CURSOR c_Line_Dtl IS
2154: SELECT

Line 2228: -- l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

2224: BOM_SORT_ORDER
2225: FROM ASO_Quote_Line_Details
2226: WHERE quote_line_id = p_qte_line_id;
2227:
2228: -- l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2229: l_line_dtl_count NUMBER;
2230: l_status VARCHAR2(1) := 'S';
2231:
2232: BEGIN

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

2320:
2321: FUNCTION Query_Line_Attribs_Ext_Rows(
2322: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2323: P_Line_Index IN NUMBER,
2324: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2325: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2326: IS
2327: CURSOR c_Line_Attr_Ext IS
2328: SELECT

Line 2325: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type

2321: FUNCTION Query_Line_Attribs_Ext_Rows(
2322: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2323: P_Line_Index IN NUMBER,
2324: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2325: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2326: IS
2327: CURSOR c_Line_Attr_Ext IS
2328: SELECT
2329: LINE_ATTRIBUTE_ID,

Line 2353: -- l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;

2349: QUOTE_SHIPMENT_ID
2350: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
2351: WHERE quote_line_id = p_qte_line_id;
2352:
2353: -- l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
2354:
2355: l_line_attr_ext_count NUMBER;
2356:
2357: BEGIN

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

2394: FUNCTION Query_Price_Attr_Rows (
2395: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2396: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2397: P_Line_Index IN NUMBER,
2398: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2399: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2400: IS
2401: CURSOR c_price_attr IS
2402: SELECT

Line 2399: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

2395: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2396: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2397: P_Line_Index IN NUMBER,
2398: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2399: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2400: IS
2401: CURSOR c_price_attr IS
2402: SELECT
2403: PRICE_ATTRIBUTE_ID,

Line 2538: -- l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;

2534: WHERE quote_header_id = p_qte_header_id AND
2535: (quote_line_id = p_qte_line_id OR
2536: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
2537:
2538: -- l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
2539: l_price_attr_count NUMBER;
2540:
2541: BEGIN
2542: --Fix for bug 5714535. Setting the output table structure directly instead of

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

2687:
2688: FUNCTION Query_Price_Adj_Rltship_Rows (
2689: P_Price_Adjustment_Id IN NUMBER,
2690: P_Line_Index IN NUMBER,
2691: lx_price_adj_rltd_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2692: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2693: IS
2694: CURSOR C_Price_Adj_Rltd IS
2695: SELECT

Line 2692: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

2688: FUNCTION Query_Price_Adj_Rltship_Rows (
2689: P_Price_Adjustment_Id IN NUMBER,
2690: P_Line_Index IN NUMBER,
2691: lx_price_adj_rltd_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2692: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2693: IS
2694: CURSOR C_Price_Adj_Rltd IS
2695: SELECT
2696: ADJ_RELATIONSHIP_ID

Line 2715: -- l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

2711: ,OBJECT_VERSION_NUMBER
2712: FROM aso_price_adj_relationships
2713: WHERE price_adjustment_id = P_Price_Adjustment_Id;
2714:
2715: -- l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
2716: l_price_adj_rltd_count NUMBER;
2717:
2718: BEGIN
2719: --Fix for bug 5714535. Setting the output table structure directly instead of

Line 2751: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

2747:
2748:
2749: FUNCTION Query_Price_Adj_Rows (
2750: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2751: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2752: P_Line_Index IN NUMBER,
2753: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
2754: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2755: ) RETURN VARCHAR2

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

2749: FUNCTION Query_Price_Adj_Rows (
2750: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2751: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2752: P_Line_Index IN NUMBER,
2753: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
2754: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2755: ) RETURN VARCHAR2
2756: IS
2757: --Begin fix for bug 5575844.

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

2750: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2751: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2752: P_Line_Index IN NUMBER,
2753: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
2754: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2755: ) RETURN VARCHAR2
2756: IS
2757: --Begin fix for bug 5575844.
2758: --Original cursor has been split into separate cursors for

Line 3376: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

3372:
3373: FUNCTION Query_Price_Adj_Hdr_Rows (
3374: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
3375: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
3376: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3377: IS
3378: CURSOR c_price_adj IS
3379: SELECT
3380: PRICE_ADJUSTMENT_ID,

Line 3470: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

3466: WHERE quote_header_id = p_qte_header_id AND
3467: (quote_line_id = p_qte_line_id OR
3468: (quote_line_id IS NULL AND p_qte_line_id IS NULL)) AND
3469: (applied_flag IS NOT NULL AND applied_flag = 'Y');
3470: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3471: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3472: BEGIN
3473: FOR price_adj_rec IN c_price_adj LOOP
3474: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;

Line 3471: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

3467: (quote_line_id = p_qte_line_id OR
3468: (quote_line_id IS NULL AND p_qte_line_id IS NULL)) AND
3469: (applied_flag IS NOT NULL AND applied_flag = 'Y');
3470: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3471: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3472: BEGIN
3473: FOR price_adj_rec IN c_price_adj LOOP
3474: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
3475: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;

Line 3570: P_Control_Rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type,

3566:
3567:
3568: PROCEDURE Raise_Quote_Event(
3569: P_Quote_Header_id IN NUMBER,
3570: P_Control_Rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type,
3571: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
3572: IS
3573:
3574: l_Event wf_event_t;

Line 3640: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type

3636: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3637: )
3638: IS
3639:
3640: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
3641: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;
3642: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;
3643: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3644:

Line 3641: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;

3637: )
3638: IS
3639:
3640: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
3641: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;
3642: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;
3643: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3644:
3645: BEGIN

Line 3642: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;

3638: IS
3639:
3640: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
3641: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;
3642: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;
3643: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3644:
3645: BEGIN
3646:

Line 3643: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;

3639:
3640: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
3641: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;
3642: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;
3643: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3644:
3645: BEGIN
3646:
3647: IF aso_debug_pub.g_debug_flag = 'Y' THEN