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
243: l_ln_inv_cust_acct_site NUMBER;
244: l_ln_shp_cust_acct_site NUMBER;
245: l_ln_end_cust_acct_site NUMBER;
246:
247: l_Line_Price_Adj_rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
248:
249: l_Header_Payment_Tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
250:
251: pay_count NUMBER := 1;
2901: x_cust_account_role_id := l_cust_account_role_id;
2902: END get_cust_acct_roles;
2903:
2904: PROCEDURE Get_Cust_Accnt_Id(
2905: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2906: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2907: p_Party_Id IN NUMBER,
2908: p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
2909: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2902: END get_cust_acct_roles;
2903:
2904: PROCEDURE Get_Cust_Accnt_Id(
2905: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2906: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
2907: p_Party_Id IN NUMBER,
2908: p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
2909: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2910: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3120: END get_org_contact_role;
3121:
3122:
3123: PROCEDURE map_header_price_attr(
3124: p_header_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
3125: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3126: p_operation IN VARCHAR2,
3127: x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
3128: )
3121:
3122:
3123: PROCEDURE map_header_price_attr(
3124: p_header_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
3125: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3126: p_operation IN VARCHAR2,
3127: x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
3128: )
3129: IS
3391: x_header_price_att_tbl := l_header_price_att_tbl;
3392: END map_header_price_attr;
3393:
3394: PROCEDURE map_header_price_adj(
3395: p_header_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3396: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3397: p_operation IN VARCHAR2 ,
3398: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
3399: )
3392: END map_header_price_attr;
3393:
3394: PROCEDURE map_header_price_adj(
3395: p_header_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3396: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3397: p_operation IN VARCHAR2 ,
3398: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
3399: )
3400: IS
3557: END map_header_price_adj;
3558:
3559:
3560: PROCEDURE map_header_price_adj_attr(
3561: p_header_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
3562: p_operation IN VARCHAR2,
3563: x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
3564: )
3565: IS
3612: END map_header_price_adj_attr;
3613:
3614:
3615: PROCEDURE map_header_price_adj_rltn(
3616: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
3617: P_operation IN VARCHAR2,
3618: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
3619: )
3620: IS
3651:
3652: END map_header_price_adj_rltn;
3653:
3654: PROCEDURE map_header_sales_credits(
3655: P_header_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type,
3656: p_operation IN VARCHAR2,
3657: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3658: p_header_operation IN VARCHAR2,
3659: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
3653:
3654: PROCEDURE map_header_sales_credits(
3655: P_header_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type,
3656: p_operation IN VARCHAR2,
3657: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3658: p_header_operation IN VARCHAR2,
3659: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
3660: )
3661: IS
3751: END map_header_sales_credits;
3752:
3753:
3754: PROCEDURE map_line_price_att(
3755: p_line_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
3756: p_line_index IN NUMBER,
3757: p_qte_line_index IN NUMBER,
3758: p_operation IN VARCHAR2,
3759: x_line_price_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
4041: END map_line_price_att;
4042:
4043:
4044: PROCEDURE map_line_price_adj(
4045: p_line_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
4046: p_line_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
4047: p_line_index IN NUMBER,
4048: p_qte_line_index IN NUMBER,
4049: p_operation IN VARCHAR2,
4042:
4043:
4044: PROCEDURE map_line_price_adj(
4045: p_line_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
4046: p_line_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
4047: p_line_index IN NUMBER,
4048: p_qte_line_index IN NUMBER,
4049: p_operation IN VARCHAR2,
4050: x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
4048: p_qte_line_index IN NUMBER,
4049: p_operation IN VARCHAR2,
4050: x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
4051: x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
4052: lx_Line_Price_Adj_rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
4053: )
4054: IS
4055:
4056: pad_count NUMBER;
4223: END map_line_price_adj;
4224:
4225:
4226: PROCEDURE map_line_price_adj_rltn(
4227: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
4228: p_line_index IN NUMBER,
4229: p_qte_line_index IN NUMBER,
4230: p_operation IN VARCHAR2,
4231: x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
4278: END map_line_price_adj_rltn;
4279:
4280:
4281: PROCEDURE map_line_sales_credit(
4282: P_line_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type,
4283: p_line_index IN NUMBER,
4284: p_qte_line_index IN NUMBER,
4285: p_line_operation IN VARCHAR2,
4286: p_operation IN VARCHAR2,
4388:
4389: --Line Payments change
4390:
4391: PROCEDURE map_line_payments(
4392: P_line_payment_Tbl IN ASO_QUOTE_PUB.payment_tbl_type,
4393: p_line_index IN NUMBER,
4394: p_qte_line_index IN NUMBER,
4395: p_line_operation IN VARCHAR2,
4396: p_operation IN VARCHAR2,
4497:
4498: end map_line_payments;
4499:
4500: PROCEDURE map_lot_serial(
4501: P_lot_serial_tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type,
4502: p_operation IN VARCHAR2,
4503: p_line_index IN NUMBER,
4504: p_qte_line_index IN NUMBER,
4505: x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type