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 483: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl);

479:
480: l_hd_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(
481: p_qte_header_id => p_qte_header_rec.quote_header_id,
482: p_qte_line_id => NULL,
483: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl);
484:
485: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(
486: p_qte_header_id => p_qte_header_rec.quote_header_id,
487: p_qte_line_id => NULL);

Line 758: ASO_QUOTE_PUB.Allocate_Sales_Credits

754: IF (l_sales_cred_prof = 'FULL') THEN
755:
756: l_Sales_Alloc_Control_Rec.Submit_Quote_Flag := 'Y';
757:
758: ASO_QUOTE_PUB.Allocate_Sales_Credits
759: (
760: P_Api_Version_Number => 1.0,
761: P_Init_Msg_List => FND_API.G_FALSE,
762: P_Commit => FND_API.G_FALSE,

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

1219: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1220: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1221: P_Shipment_Tbl_Cnt IN NUMBER,
1222: P_Line_Index IN NUMBER,
1223: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1224: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1225: IS
1226: CURSOR c_tax1 IS
1227: SELECT

Line 1224: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type

1220: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1221: P_Shipment_Tbl_Cnt IN NUMBER,
1222: P_Line_Index IN NUMBER,
1223: lx_tax_detail_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1224: ) RETURN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
1225: IS
1226: CURSOR c_tax1 IS
1227: SELECT
1228: TAX_DETAIL_ID,

Line 1315: -- l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

1311: TAX_RATE_ID
1312: FROM ASO_TAX_DETAILS
1313: WHERE quote_line_id = p_qte_line_id;
1314:
1315: -- l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
1316: l_tax_det_count NUMBER;
1317:
1318: BEGIN
1319: --Fix for bug 5714535. Setting the output table structure directly instead of

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

1431: FUNCTION Query_Shipment_Rows (
1432: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
1433: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1434: P_Line_Index IN NUMBER,
1435: lx_shipment_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type
1436: ) RETURN VARCHAR2
1437: IS
1438: CURSOR c_shipment IS
1439: SELECT

Line 1561: -- l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1557: FREIGHT_TERMS_CODE_FROM
1558: FROM ASO_SHIPMENTS
1559: WHERE quote_line_id = p_qte_line_id;
1560:
1561: -- l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1562: l_ship_count NUMBER;
1563: l_status VARCHAR2(1) := 'S';
1564:
1565: BEGIN

Line 1709: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,

1705: END Query_Shipment_Rows;
1706:
1707:
1708: FUNCTION Query_Freight_Charge_Rows (
1709: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
1710: P_Line_Index IN NUMBER,
1711: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1712: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1713: IS

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

1707:
1708: FUNCTION Query_Freight_Charge_Rows (
1709: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
1710: P_Line_Index IN NUMBER,
1711: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1712: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1713: IS
1714: CURSOR c_freight_charge (c_shipment_id NUMBER) IS
1715: SELECT

Line 1712: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type

1708: FUNCTION Query_Freight_Charge_Rows (
1709: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
1710: P_Line_Index IN NUMBER,
1711: lx_freight_charge_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1712: ) RETURN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
1713: IS
1714: CURSOR c_freight_charge (c_shipment_id NUMBER) IS
1715: SELECT
1716: FREIGHT_CHARGE_ID,

Line 1748: -- l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;

1744: ATTRIBUTE15
1745: FROM ASO_FREIGHT_CHARGES
1746: WHERE quote_shipment_id = c_shipment_id;
1747:
1748: -- l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;
1749: l_frt_chrg_count NUMBER;
1750:
1751: BEGIN
1752: --Fix for bug 5714535. Setting the output table structure directly instead of

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

1800: FUNCTION Query_Sales_Credit_Row (
1801: P_qte_header_Id IN NUMBER,
1802: P_qte_line_id IN NUMBER,
1803: P_Line_Index IN NUMBER,
1804: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1805: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1806: IS
1807:
1808: -- l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 1805: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type

1801: P_qte_header_Id IN NUMBER,
1802: P_qte_line_id IN NUMBER,
1803: P_Line_Index IN NUMBER,
1804: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1805: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1806: IS
1807:
1808: -- l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1809: l_sls_crdt_count NUMBER;

Line 1808: -- l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

1804: lx_sales_credit_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1805: ) RETURN ASO_QUOTE_PUB.Sales_Credit_tbl_Type
1806: IS
1807:
1808: -- l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1809: l_sls_crdt_count NUMBER;
1810:
1811: CURSOR C1 IS
1812: SELECT

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

1898: FUNCTION Query_Quote_Party_Row (
1899: P_Qte_header_Id IN NUMBER,
1900: P_Qte_line_Id IN NUMBER,
1901: P_Line_Index IN NUMBER,
1902: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
1903: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
1904: IS
1905:
1906: -- l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;

Line 1903: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type

1899: P_Qte_header_Id IN NUMBER,
1900: P_Qte_line_Id IN NUMBER,
1901: P_Line_Index IN NUMBER,
1902: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
1903: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
1904: IS
1905:
1906: -- l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
1907: l_quote_party_count NUMBER;

Line 1906: -- l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;

1902: lx_quote_party_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
1903: ) RETURN ASO_QUOTE_PUB.QUOTE_PARTY_tbl_Type
1904: IS
1905:
1906: -- l_quote_party_rec ASO_QUOTE_PUB.QUOTE_PARTY_rec_Type;
1907: l_quote_party_count NUMBER;
1908:
1909: CURSOR C1 is
1910: SELECT QUOTE_PARTY_ID,

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

1993:
1994: FUNCTION Query_Line_Dtl_Rows (
1995: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
1996: P_Line_Index IN NUMBER,
1997: lx_Line_Dtl_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
1998: ) RETURN VARCHAR2
1999: IS
2000: CURSOR c_Line_Dtl IS
2001: SELECT

Line 2075: -- l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

2071: BOM_SORT_ORDER
2072: FROM ASO_Quote_Line_Details
2073: WHERE quote_line_id = p_qte_line_id;
2074:
2075: -- l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
2076: l_line_dtl_count NUMBER;
2077: l_status VARCHAR2(1) := 'S';
2078:
2079: BEGIN

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

2167:
2168: FUNCTION Query_Line_Attribs_Ext_Rows(
2169: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2170: P_Line_Index IN NUMBER,
2171: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2172: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2173: IS
2174: CURSOR c_Line_Attr_Ext IS
2175: SELECT

Line 2172: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type

2168: FUNCTION Query_Line_Attribs_Ext_Rows(
2169: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2170: P_Line_Index IN NUMBER,
2171: lx_Line_Attr_Ext_Tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2172: ) RETURN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
2173: IS
2174: CURSOR c_Line_Attr_Ext IS
2175: SELECT
2176: LINE_ATTRIBUTE_ID,

Line 2200: -- l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;

2196: QUOTE_SHIPMENT_ID
2197: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
2198: WHERE quote_line_id = p_qte_line_id;
2199:
2200: -- l_Line_Attr_Ext_Rec ASO_QUOTE_PUB.Line_Attribs_Ext_Rec_Type;
2201:
2202: l_line_attr_ext_count NUMBER;
2203:
2204: BEGIN

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

2241: FUNCTION Query_Price_Attr_Rows (
2242: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2243: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2244: P_Line_Index IN NUMBER,
2245: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2246: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2247: IS
2248: CURSOR c_price_attr IS
2249: SELECT

Line 2246: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

2242: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2243: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
2244: P_Line_Index IN NUMBER,
2245: lx_price_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2246: ) RETURN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
2247: IS
2248: CURSOR c_price_attr IS
2249: SELECT
2250: PRICE_ATTRIBUTE_ID,

Line 2385: -- l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;

2381: WHERE quote_header_id = p_qte_header_id AND
2382: (quote_line_id = p_qte_line_id OR
2383: (quote_line_id IS NULL AND p_qte_line_id IS NULL));
2384:
2385: -- l_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
2386: l_price_attr_count NUMBER;
2387:
2388: BEGIN
2389: --Fix for bug 5714535. Setting the output table structure directly instead of

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

2534:
2535: FUNCTION Query_Price_Adj_Rltship_Rows (
2536: P_Price_Adjustment_Id IN NUMBER,
2537: P_Line_Index IN NUMBER,
2538: lx_price_adj_rltd_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2539: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2540: IS
2541: CURSOR C_Price_Adj_Rltd IS
2542: SELECT

Line 2539: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

2535: FUNCTION Query_Price_Adj_Rltship_Rows (
2536: P_Price_Adjustment_Id IN NUMBER,
2537: P_Line_Index IN NUMBER,
2538: lx_price_adj_rltd_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2539: ) RETURN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
2540: IS
2541: CURSOR C_Price_Adj_Rltd IS
2542: SELECT
2543: ADJ_RELATIONSHIP_ID

Line 2562: -- l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

2558: ,OBJECT_VERSION_NUMBER
2559: FROM aso_price_adj_relationships
2560: WHERE price_adjustment_id = P_Price_Adjustment_Id;
2561:
2562: -- l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
2563: l_price_adj_rltd_count NUMBER;
2564:
2565: BEGIN
2566: --Fix for bug 5714535. Setting the output table structure directly instead of

Line 2598: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

2594:
2595:
2596: FUNCTION Query_Price_Adj_Rows (
2597: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2598: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2599: P_Line_Index IN NUMBER,
2600: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
2601: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2602: ) RETURN VARCHAR2

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

2596: FUNCTION Query_Price_Adj_Rows (
2597: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2598: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2599: P_Line_Index IN NUMBER,
2600: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
2601: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2602: ) RETURN VARCHAR2
2603: IS
2604: --Begin fix for bug 5575844.

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

2597: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
2598: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2599: P_Line_Index IN NUMBER,
2600: Lx_price_adj_rltship_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
2601: Lx_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type
2602: ) RETURN VARCHAR2
2603: IS
2604: --Begin fix for bug 5575844.
2605: --Original cursor has been split into separate cursors for

Line 3223: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

3219:
3220: FUNCTION Query_Price_Adj_Hdr_Rows (
3221: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
3222: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
3223: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3224: IS
3225: CURSOR c_price_adj IS
3226: SELECT
3227: PRICE_ADJUSTMENT_ID,

Line 3317: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

3313: WHERE quote_header_id = p_qte_header_id AND
3314: (quote_line_id = p_qte_line_id OR
3315: (quote_line_id IS NULL AND p_qte_line_id IS NULL)) AND
3316: (applied_flag IS NOT NULL AND applied_flag = 'Y');
3317: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3318: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3319: BEGIN
3320: FOR price_adj_rec IN c_price_adj LOOP
3321: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;

Line 3318: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

3314: (quote_line_id = p_qte_line_id OR
3315: (quote_line_id IS NULL AND p_qte_line_id IS NULL)) AND
3316: (applied_flag IS NOT NULL AND applied_flag = 'Y');
3317: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3318: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3319: BEGIN
3320: FOR price_adj_rec IN c_price_adj LOOP
3321: l_price_adj_rec.PRICE_ADJUSTMENT_ID := price_adj_rec.PRICE_ADJUSTMENT_ID;
3322: l_price_adj_rec.CREATION_DATE := price_adj_rec.CREATION_DATE;

Line 3417: P_Control_Rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type,

3413:
3414:
3415: PROCEDURE Raise_Quote_Event(
3416: P_Quote_Header_id IN NUMBER,
3417: P_Control_Rec IN ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type,
3418: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
3419: IS
3420:
3421: l_Event wf_event_t;

Line 3487: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type

3483: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3484: )
3485: IS
3486:
3487: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
3488: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;
3489: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;
3490: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3491:

Line 3488: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;

3484: )
3485: IS
3486:
3487: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
3488: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;
3489: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;
3490: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3491:
3492: BEGIN

Line 3489: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;

3485: IS
3486:
3487: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
3488: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;
3489: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;
3490: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3491:
3492: BEGIN
3493:

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

3486:
3487: l_Control_Rec ASO_QUOTE_PUB.SUBMIT_Control_Rec_Type
3488: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC;
3489: lx_Order_Header_Rec ASO_QUOTE_PUB.Order_Header_Rec_Type;
3490: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3491:
3492: BEGIN
3493:
3494: IF aso_debug_pub.g_debug_flag = 'Y' THEN