13:
14:
15: PROCEDURE Map_Quote_to_order(
16: P_Operation IN VARCHAR2,
17: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
18: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
19: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
14:
15: PROCEDURE Map_Quote_to_order(
16: P_Operation IN VARCHAR2,
17: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
18: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
19: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
15: PROCEDURE Map_Quote_to_order(
16: P_Operation IN VARCHAR2,
17: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
18: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
19: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
16: P_Operation IN VARCHAR2,
17: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
18: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
19: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
17: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
18: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
19: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
18: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
19: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
19: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
21: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
23: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
24: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
25: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
26: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
27: P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
28: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
29: P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
31: P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
32: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
33: P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
34: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
35: P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
36: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
37: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
38: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
39: P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
40: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
41: P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
42: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
43: P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
44: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
45: P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
46: := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
47: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
48: := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
49: P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
50: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
51: P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
52: := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
60: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
53: P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
60: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
61: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
54: := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
60: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
61: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
62: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
55: P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
60: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
61: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
62: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
63: P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
56: := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
60: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
61: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
62: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
63: P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
57: P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
60: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
61: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
62: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
63: P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
58: := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59: P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
60: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
61: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
62: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
63: P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
111: x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ number
112: );
113:
114: PROCEDURE Get_Cust_Accnt_Id(
115: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
116: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
117: p_Party_Id IN NUMBER,
118: p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
119: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
112: );
113:
114: PROCEDURE Get_Cust_Accnt_Id(
115: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
116: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
117: p_Party_Id IN NUMBER,
118: p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
119: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
120: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
129: );
130:
131:
132: PROCEDURE map_header_price_attr(
133: p_header_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
134: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
135: p_operation IN VARCHAR2,
136: x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
137: );
130:
131:
132: PROCEDURE map_header_price_attr(
133: p_header_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
134: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
135: p_operation IN VARCHAR2,
136: x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
137: );
138:
136: x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
137: );
138:
139: PROCEDURE map_header_price_adj(
140: p_header_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
141: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
142: p_operation IN VARCHAR2 ,
143: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
144: );
137: );
138:
139: PROCEDURE map_header_price_adj(
140: p_header_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
141: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
142: p_operation IN VARCHAR2 ,
143: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
144: );
145:
143: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
144: );
145:
146: PROCEDURE map_header_price_adj_attr(
147: p_header_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
148: p_operation IN VARCHAR2,
149: x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
150: );
151:
149: x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
150: );
151:
152: PROCEDURE map_header_price_adj_rltn(
153: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
154: P_operation IN VARCHAR2,
155: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
156: );
157:
155: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
156: );
157:
158: PROCEDURE map_header_sales_credits(
159: P_header_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type ,
160: p_operation IN VARCHAR2,
161: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
162: p_header_operation IN VARCHAR2,
163: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
157:
158: PROCEDURE map_header_sales_credits(
159: P_header_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type ,
160: p_operation IN VARCHAR2,
161: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
162: p_header_operation IN VARCHAR2,
163: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
164: );
165:
163: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
164: );
165:
166: PROCEDURE map_line_price_att(
167: p_line_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
168: p_line_index IN NUMBER,
169: p_qte_line_index IN NUMBER,
170: p_operation IN VARCHAR2,
171: x_line_price_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
171: x_line_price_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
172: );
173:
174: PROCEDURE map_line_price_adj(
175: p_line_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
176: p_line_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
177: p_line_index IN NUMBER,
178: p_qte_line_index IN NUMBER,
179: p_operation IN VARCHAR2,
172: );
173:
174: PROCEDURE map_line_price_adj(
175: p_line_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
176: p_line_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
177: p_line_index IN NUMBER,
178: p_qte_line_index IN NUMBER,
179: p_operation IN VARCHAR2,
180: x_line_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
178: p_qte_line_index IN NUMBER,
179: p_operation IN VARCHAR2,
180: x_line_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
181: x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
182: lx_Line_Price_Adj_rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
183: );
184:
185:
186: PROCEDURE map_line_price_adj_rltn(
183: );
184:
185:
186: PROCEDURE map_line_price_adj_rltn(
187: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
188: p_line_index IN NUMBER,
189: p_qte_line_index IN NUMBER,
190: p_operation IN VARCHAR2,
191: x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
191: x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
192: );
193:
194: PROCEDURE map_line_sales_credit(
195: P_line_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type,
196: p_line_index IN NUMBER,
197: p_qte_line_index IN NUMBER,
198: p_line_operation IN VARCHAR2,
199: p_operation IN VARCHAR2,
200: x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
201: );
202:
203: PROCEDURE map_lot_serial(
204: P_lot_serial_tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type,
205: p_operation IN VARCHAR2,
206: p_line_index IN NUMBER,
207: p_qte_line_index IN NUMBER,
208: x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
210:
211:
212: -- Line Payments Change
213: PROCEDURE map_line_payments(
214: P_line_payment_Tbl IN ASO_QUOTE_PUB.payment_tbl_type,
215: p_line_index IN NUMBER,
216: p_qte_line_index IN NUMBER,
217: p_line_operation IN VARCHAR2,
218: p_operation IN VARCHAR2,