DBA Data[Home] [Help]

APPS.OKS_OC_INT_KTO_PVT dependencies on ASO_QUOTE_PUB

Line 877: (px_qte_hdr_rec IN OUT NOCOPY aso_quote_pub.qte_header_rec_type

873: -- In/Out Parameters: px_qte_hdr_rec - the record to pass to ASO
874: ------------------------------------------------------------------------------
875:
876: PROCEDURE build_order_hdr
877: (px_qte_hdr_rec IN OUT NOCOPY aso_quote_pub.qte_header_rec_type
878: ,p_contract_id IN NUMBER
879: ,px_hd_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
880: ,x_return_status OUT NOCOPY VARCHAR2
881: ) IS

Line 879: ,px_hd_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type

875:
876: PROCEDURE build_order_hdr
877: (px_qte_hdr_rec IN OUT NOCOPY aso_quote_pub.qte_header_rec_type
878: ,p_contract_id IN NUMBER
879: ,px_hd_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
880: ,x_return_status OUT NOCOPY VARCHAR2
881: ) IS
882:
883: e_exit exception; -- used to exit processing

Line 1030: px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type

1026:
1027:
1028: PROCEDURE build_order_line
1029: (
1030: px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
1031: ,px_qte_hdr_rec IN aso_quote_pub.qte_header_rec_type
1032: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
1033: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
1034: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type

Line 1031: ,px_qte_hdr_rec IN aso_quote_pub.qte_header_rec_type

1027:
1028: PROCEDURE build_order_line
1029: (
1030: px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
1031: ,px_qte_hdr_rec IN aso_quote_pub.qte_header_rec_type
1032: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
1033: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
1034: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type
1035: ,x_return_status OUT NOCOPY VARCHAR2

Line 1032: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type

1028: PROCEDURE build_order_line
1029: (
1030: px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
1031: ,px_qte_hdr_rec IN aso_quote_pub.qte_header_rec_type
1032: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
1033: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
1034: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type
1035: ,x_return_status OUT NOCOPY VARCHAR2
1036: ) IS

Line 1033: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type

1029: (
1030: px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
1031: ,px_qte_hdr_rec IN aso_quote_pub.qte_header_rec_type
1032: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
1033: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
1034: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type
1035: ,x_return_status OUT NOCOPY VARCHAR2
1036: ) IS
1037:

Line 1300: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1296: -- Bug 4915691 --
1297: l_k2q_line_rel_tab okc_oc_int_config_pvt.line_rel_tab_type; -- keeps track of k line to q line relation
1298:
1299: -- Variables for calling create_order
1300: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1301: l_Header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1302: l_quote_hd_Price_Adj_Tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 1301: l_Header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

1297: l_k2q_line_rel_tab okc_oc_int_config_pvt.line_rel_tab_type; -- keeps track of k line to q line relation
1298:
1299: -- Variables for calling create_order
1300: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1301: l_Header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1302: l_quote_hd_Price_Adj_Tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1302: l_quote_hd_Price_Adj_Tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1298:
1299: -- Variables for calling create_order
1300: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1301: l_Header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1302: l_quote_hd_Price_Adj_Tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;

Line 1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1299: -- Variables for calling create_order
1300: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1301: l_Header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1302: l_quote_hd_Price_Adj_Tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

1300: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1301: l_Header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1302: l_quote_hd_Price_Adj_Tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;

Line 1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1301: l_Header_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1302: l_quote_hd_Price_Adj_Tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;

Line 1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;

1302: l_quote_hd_Price_Adj_Tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1303: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;

1304: l_qte_hd_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;

1305: l_quote_hd_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1306: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1307: l_Header_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

1308: l_Header_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1309: l_Header_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1310: l_quote_line_tab ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;
1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;

Line 1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

1311: l_qte_line_dtl_tab ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;
1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;

Line 1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1312: l_Line_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;
1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;

1313: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;
1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1321: l_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;

1314: l_quote_Ln_Price_Attr_Tab ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;
1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1321: l_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1322: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;

Line 1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;

1315: l_qte_ln_price_adj_rltship_tab ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;
1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1321: l_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1322: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1323: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;

Line 1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1316: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;
1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1321: l_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1322: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1323: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1324: --

Line 1321: l_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

1317: l_quote_ln_Shipment_Tab ASO_QUOTE_PUB.Shipment_Tbl_Type;
1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1321: l_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1322: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1323: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1324: --
1325: l_Control_Rec ASO_ORDER_INT.Control_Rec_Type ;

Line 1322: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;

1318: l_Line_TAX_DETAIL_Tbl ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type;
1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1321: l_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1322: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1323: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1324: --
1325: l_Control_Rec ASO_ORDER_INT.Control_Rec_Type ;
1326: l_Line_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;

Line 1323: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;

1319: l_Line_FREIGHT_CHARGE_Tbl ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type;
1320: l_Line_ATTRIBS_EXT_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1321: l_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1322: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1323: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1324: --
1325: l_Control_Rec ASO_ORDER_INT.Control_Rec_Type ;
1326: l_Line_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;
1327: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type;

Line 1327: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type;

1323: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
1324: --
1325: l_Control_Rec ASO_ORDER_INT.Control_Rec_Type ;
1326: l_Line_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;
1327: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type;
1328: l_header_attribs_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
1329: l_header_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
1330: l_line_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
1331: lx_order_header_rec ASO_ORDER_INT.Order_Header_Rec_Type;

Line 1328: l_header_attribs_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

1324: --
1325: l_Control_Rec ASO_ORDER_INT.Control_Rec_Type ;
1326: l_Line_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;
1327: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type;
1328: l_header_attribs_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
1329: l_header_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
1330: l_line_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
1331: lx_order_header_rec ASO_ORDER_INT.Order_Header_Rec_Type;
1332: lx_order_line_tbl ASO_ORDER_INT.Order_Line_Tbl_type;

Line 1329: l_header_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

1325: l_Control_Rec ASO_ORDER_INT.Control_Rec_Type ;
1326: l_Line_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;
1327: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type;
1328: l_header_attribs_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
1329: l_header_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
1330: l_line_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
1331: lx_order_header_rec ASO_ORDER_INT.Order_Header_Rec_Type;
1332: lx_order_line_tbl ASO_ORDER_INT.Order_Line_Tbl_type;
1333: l_header_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;

Line 1330: l_line_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

1326: l_Line_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;
1327: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type;
1328: l_header_attribs_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
1329: l_header_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
1330: l_line_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
1331: lx_order_header_rec ASO_ORDER_INT.Order_Header_Rec_Type;
1332: lx_order_line_tbl ASO_ORDER_INT.Order_Line_Tbl_type;
1333: l_header_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;
1334: lx_clev_tbl okc_cle_pvt.clev_tbl_type;

Line 1336: l_order_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

1332: lx_order_line_tbl ASO_ORDER_INT.Order_Line_Tbl_type;
1333: l_header_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;
1334: lx_clev_tbl okc_cle_pvt.clev_tbl_type;
1335:
1336: l_order_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
1337: l_order_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
1338:
1339: --
1340: l_ord_creation_date oe_order_headers_all.creation_date%TYPE;

Line 1337: l_order_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

1333: l_header_sales_credit_TBL ASO_ORDER_INT.Sales_credit_tbl_type;
1334: lx_clev_tbl okc_cle_pvt.clev_tbl_type;
1335:
1336: l_order_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
1337: l_order_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
1338:
1339: --
1340: l_ord_creation_date oe_order_headers_all.creation_date%TYPE;
1341: l_ord_num oe_order_headers_all.order_number%TYPE;