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

Line 22: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

18: PROCEDURE Calculate_Tax(
19: P_Api_Version_Number IN NUMBER,
20: P_Tax_Control_Rec IN Tax_Control_Rec_Type
21: := G_Miss_Tax_Control_Rec,
22: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
23: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
24: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

Line 23: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

19: P_Api_Version_Number IN NUMBER,
20: P_Tax_Control_Rec IN Tax_Control_Rec_Type
21: := G_Miss_Tax_Control_Rec,
22: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
23: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
24: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,

Line 24: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type

20: P_Tax_Control_Rec IN Tax_Control_Rec_Type
21: := G_Miss_Tax_Control_Rec,
22: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
23: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
24: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
28: p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type

Line 25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,

21: := G_Miss_Tax_Control_Rec,
22: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
23: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
24: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
28: p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type
29: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,

Line 26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

22: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
23: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
24: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
28: p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type
29: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
30: x_tax_amount OUT NOCOPY NUMBER,

Line 27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,

23: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
24: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
28: p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type
29: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
30: x_tax_amount OUT NOCOPY NUMBER,
31: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

Line 28: p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type

24: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
28: p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type
29: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
30: x_tax_amount OUT NOCOPY NUMBER,
31: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
32: X_Return_Status OUT NOCOPY VARCHAR2,

Line 29: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,

25: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
26: P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
28: p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type
29: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
30: x_tax_amount OUT NOCOPY NUMBER,
31: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
32: X_Return_Status OUT NOCOPY VARCHAR2,
33: X_Msg_Count OUT NOCOPY NUMBER,

Line 31: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

27: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
28: p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type
29: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
30: x_tax_amount OUT NOCOPY NUMBER,
31: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
32: X_Return_Status OUT NOCOPY VARCHAR2,
33: X_Msg_Count OUT NOCOPY NUMBER,
34: X_Msg_Data OUT NOCOPY VARCHAR2)
35: IS

Line 42: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

38: l_trx_line_id NUMBER := NULL;
39: l_charge_line_id NUMBER := NULL;
40: l_arp_tax_tbl ARP_TAX.tax_rec_tbl_type;
41:
42: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
43:
44: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
45: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
46: CURSOR C_Tax_Code (c_tax_id NUMBER) IS

Line 210: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

206: p_qte_line_id IN NUMBER :=NULL,
207: P_Tax_Control_Rec IN Tax_Control_Rec_Type
208: := G_Miss_Tax_Control_Rec,
209: x_tax_amount OUT NOCOPY NUMBER,
210: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
211: X_Return_Status OUT NOCOPY VARCHAR2,
212: X_Msg_Count OUT NOCOPY NUMBER,
213: X_Msg_Data OUT NOCOPY VARCHAR2)
214: IS

Line 222: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

218: where quote_header_id = l_quote_header_id;
219:
220:
221: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Tax';
222: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
223: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
224: lx_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
225: l_count NUMBER;
226:

Line 223: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

219:
220:
221: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Tax';
222: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
223: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
224: lx_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
225: l_count NUMBER;
226:
227: c_header_id NUMBER;

Line 224: lx_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

220:
221: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Tax';
222: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
223: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
224: lx_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
225: l_count NUMBER;
226:
227: c_header_id NUMBER;
228: c_line_id NUMBER;

Line 589: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,

585: p_qte_header_id IN NUMBER,
586: p_tax_control_rec IN Tax_Control_Rec_Type := G_Miss_Tax_Control_Rec,
587: p_qte_line_id IN NUMBER := NULL,
588: x_tax_value OUT NOCOPY NUMBER,
589: x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
590: x_return_status OUT NOCOPY VARCHAR2
591: ) is
592:
593: -- Declare local variables

Line 596: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

592:
593: -- Declare local variables
594: x_tax_out_tbl ARP_TAX.om_tax_out_tab_type;
595:
596: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
598: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;

Line 597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;

593: -- Declare local variables
594: x_tax_out_tbl ARP_TAX.om_tax_out_tab_type;
595:
596: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
598: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
601: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

Line 598: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;

594: x_tax_out_tbl ARP_TAX.om_tax_out_tab_type;
595:
596: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
598: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
601: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
602: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

Line 599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;

595:
596: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
598: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
601: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
602: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
603: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

Line 600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;

596: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
598: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
601: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
602: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
603: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
604:

Line 601: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;

597: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
598: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
601: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
602: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
603: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
604:
605: l_qte_header_id NUMBER;

Line 602: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

598: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
601: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
602: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
603: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
604:
605: l_qte_header_id NUMBER;
606: l_tax_method VARCHAR2(15) := NULL;

Line 603: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

599: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
600: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
601: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
602: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
603: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
604:
605: l_qte_header_id NUMBER;
606: l_tax_method VARCHAR2(15) := NULL;
607: l_vendor_installed VARCHAR2(1) := NULL;

Line 2159: x_tax_detail_Tbl := aso_quote_pub.g_miss_tax_detail_tbl;

2155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2156: aso_debug_pub.add('ASO_TAX_LINE: After call to initialize_tax_info_rec.', 1, 'Y');
2157: END IF;
2158:
2159: x_tax_detail_Tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2160: l_tax_detail_tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2161: l_hdr_tax_detail_tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2162:
2163: END IF; --arp_tax.tax_info_rec.trx_type_id

Line 2160: l_tax_detail_tbl := aso_quote_pub.g_miss_tax_detail_tbl;

2156: aso_debug_pub.add('ASO_TAX_LINE: After call to initialize_tax_info_rec.', 1, 'Y');
2157: END IF;
2158:
2159: x_tax_detail_Tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2160: l_tax_detail_tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2161: l_hdr_tax_detail_tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2162:
2163: END IF; --arp_tax.tax_info_rec.trx_type_id
2164:

Line 2161: l_hdr_tax_detail_tbl := aso_quote_pub.g_miss_tax_detail_tbl;

2157: END IF;
2158:
2159: x_tax_detail_Tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2160: l_tax_detail_tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2161: l_hdr_tax_detail_tbl := aso_quote_pub.g_miss_tax_detail_tbl;
2162:
2163: END IF; --arp_tax.tax_info_rec.trx_type_id
2164:
2165: End Loop; --quote line loop

Line 2201: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

2197: )
2198: is
2199: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_TAX_INT';
2200: L_API_NAME CONSTANT VARCHAR2(50):='CALCULATE_TAX_WITH_GTT';
2201: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
2202: l_currency_code VARCHAR2(15);
2203: l_minimum_accountable_unit NUMBER;
2204: l_precision NUMBER;
2205: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;

Line 2205: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;

2201: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
2202: l_currency_code VARCHAR2(15);
2203: l_minimum_accountable_unit NUMBER;
2204: l_precision NUMBER;
2205: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
2206: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
2207: l_set_of_books_id NUMBER;
2208: l_site_use_id_ship_header NUMBER;
2209: l_site_use_id_bill_header NUMBER;

Line 2206: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;

2202: l_currency_code VARCHAR2(15);
2203: l_minimum_accountable_unit NUMBER;
2204: l_precision NUMBER;
2205: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_tbl_Type;
2206: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
2207: l_set_of_books_id NUMBER;
2208: l_site_use_id_ship_header NUMBER;
2209: l_site_use_id_bill_header NUMBER;
2210: l_site_use_id_ship_lines NUMBER;

Line 2222: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;

2218: l_acct_site_id_ship_lines NUMBER;
2219: l_ship_cust_account_id_header NUMBER;
2220: l_ship_cust_acct_id_lines NUMBER;
2221: l_bill_cust_acct_id_lines NUMBER;
2222: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2223: l_Shipment_header_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2224: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2225: l_Shipment_header_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2226: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

Line 2223: l_Shipment_header_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;

2219: l_ship_cust_account_id_header NUMBER;
2220: l_ship_cust_acct_id_lines NUMBER;
2221: l_bill_cust_acct_id_lines NUMBER;
2222: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2223: l_Shipment_header_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2224: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2225: l_Shipment_header_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2226: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2227: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

Line 2224: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;

2220: l_ship_cust_acct_id_lines NUMBER;
2221: l_bill_cust_acct_id_lines NUMBER;
2222: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2223: l_Shipment_header_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2224: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2225: l_Shipment_header_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2226: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2227: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2228: l_hdr_tax_exempt_flag VARCHAR2(1);

Line 2225: l_Shipment_header_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

2221: l_bill_cust_acct_id_lines NUMBER;
2222: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2223: l_Shipment_header_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2224: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2225: l_Shipment_header_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2226: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2227: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2228: l_hdr_tax_exempt_flag VARCHAR2(1);
2229: l_hdr_tax_exempt_number VARCHAR2(80);

Line 2226: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

2222: l_Shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2223: l_Shipment_header_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2224: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2225: l_Shipment_header_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2226: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2227: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2228: l_hdr_tax_exempt_flag VARCHAR2(1);
2229: l_hdr_tax_exempt_number VARCHAR2(80);
2230: l_hdr_tax_exempt_reason_code VARCHAR2(30);

Line 2227: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;

2223: l_Shipment_header_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
2224: l_Shipment_Rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2225: l_Shipment_header_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2226: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2227: l_hdr_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_tbl_Type;
2228: l_hdr_tax_exempt_flag VARCHAR2(1);
2229: l_hdr_tax_exempt_number VARCHAR2(80);
2230: l_hdr_tax_exempt_reason_code VARCHAR2(30);
2231: l_product_type VARCHAR2(15);

Line 3377: FUNCTION GET_ra_trx_type_ID (p_order_type_id NUMBER,p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type) RETURN NUMBER

3373: BEGIN
3374: return NVL(p_ln_invoice_id, p_hd_invoice_id);
3375: END Get_Tax_Invoice_To;
3376:
3377: FUNCTION GET_ra_trx_type_ID (p_order_type_id NUMBER,p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type) RETURN NUMBER
3378: IS
3379: CURSOR C_OE_trns(l_order_type_Id NUMBER) IS
3380: SELECT default_inbound_line_type_id, default_outbound_line_type_id, cust_trx_type_id
3381: FROM OE_TRANSACTION_TYPES_VL