DBA Data[Home] [Help]

APPS.OKC_OC_INT_KTQ_PVT dependencies on ASO_QUOTE_PUB

Line 114: -- - added aso_quote_pub.update_quote_from_k procedure

110: -- - added validate_k_eligibility
111: -- - added build_k_structures
112: -- - modified build_qte_hdr
113: -- - modified build_qte_line
114: -- - added aso_quote_pub.update_quote_from_k procedure
115: --
116: --
117: -- - Added the following new functions
118: --

Line 2504: PROCEDURE build_qte_hdr(px_qte_hdr_rec IN OUT NOCOPY ASO_QUOTE_PUB.qte_header_rec_type

2500: -- In Parameters:
2501: -- Out Parameters:
2502: -- In/Out Parameters: px_qte_hdr_rec - the record to pass to ASO
2503:
2504: PROCEDURE build_qte_hdr(px_qte_hdr_rec IN OUT NOCOPY ASO_QUOTE_PUB.qte_header_rec_type
2505: ,px_hd_shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.shipment_tbl_type
2506: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
2507: -- ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
2508: ,p_rel_code IN OKC_K_REL_OBJS.rty_code%TYPE

Line 2505: ,px_hd_shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.shipment_tbl_type

2501: -- Out Parameters:
2502: -- In/Out Parameters: px_qte_hdr_rec - the record to pass to ASO
2503:
2504: PROCEDURE build_qte_hdr(px_qte_hdr_rec IN OUT NOCOPY ASO_QUOTE_PUB.qte_header_rec_type
2505: ,px_hd_shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.shipment_tbl_type
2506: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
2507: -- ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
2508: ,p_rel_code IN OKC_K_REL_OBJS.rty_code%TYPE
2509: ,x_return_status OUT NOCOPY VARCHAR2

Line 2791: ,px_qte_hdr_rec IN ASO_QUOTE_PUB.qte_header_rec_type

2787: --
2788: --
2789: PROCEDURE build_qte_line (
2790: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
2791: ,px_qte_hdr_rec IN ASO_QUOTE_PUB.qte_header_rec_type
2792: ,px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
2793: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
2794: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
2795: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type

Line 2792: ,px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type

2788: --
2789: PROCEDURE build_qte_line (
2790: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
2791: ,px_qte_hdr_rec IN ASO_QUOTE_PUB.qte_header_rec_type
2792: ,px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
2793: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
2794: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
2795: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type
2796: -- ,x_total_price OUT NUMBER

Line 2793: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type

2789: PROCEDURE build_qte_line (
2790: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
2791: ,px_qte_hdr_rec IN ASO_QUOTE_PUB.qte_header_rec_type
2792: ,px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
2793: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
2794: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
2795: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type
2796: -- ,x_total_price OUT NUMBER
2797: ,x_line_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.line_rltship_tbl_type

Line 2794: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type

2790: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
2791: ,px_qte_hdr_rec IN ASO_QUOTE_PUB.qte_header_rec_type
2792: ,px_qte_line_tbl IN OUT NOCOPY aso_quote_pub.qte_line_tbl_type
2793: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
2794: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
2795: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type
2796: -- ,x_total_price OUT NUMBER
2797: ,x_line_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.line_rltship_tbl_type
2798: ,x_return_status OUT NOCOPY VARCHAR2

Line 2797: ,x_line_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.line_rltship_tbl_type

2793: ,px_qte_line_dtl_tbl IN OUT NOCOPY aso_quote_pub.qte_line_dtl_tbl_type
2794: ,px_qte_ln_shipment_tbl IN OUT NOCOPY aso_quote_pub.shipment_tbl_type
2795: ,px_k2q_line_tbl IN OUT NOCOPY okc_oc_int_config_pvt.line_rel_tab_type
2796: -- ,x_total_price OUT NUMBER
2797: ,x_line_rltship_tab OUT NOCOPY ASO_QUOTE_PUB.line_rltship_tbl_type
2798: ,x_return_status OUT NOCOPY VARCHAR2
2799: ) IS
2800:
2801: l_ql binary_integer; -- table index

Line 3928: -- Calls aso_quote_pub.CREATE_QUOTE to create the quote

3924: -- Procedure: update_quote_from_k
3925: -- Version: 1.0
3926: -- Purpose: Update a quote from a contract
3927: -- to a master contract
3928: -- Calls aso_quote_pub.CREATE_QUOTE to create the quote
3929: -- In Parameters: p_contract_id Contract for which to create quote
3930: -- p_quote_id Id of quote to be renewed
3931: --
3932: PROCEDURE update_quote_from_k( p_api_version IN NUMBER

Line 3969: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;

3965: l_k2q_line_rel_tab okc_oc_int_config_pvt.line_rel_tab_type; -- keeps track of k line to q line relation
3966: l_hdr_price NUMBER;
3967: x_total_price NUMBER;
3968:
3969: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3970:
3971: -- variables for calling create_quote
3972: l_control_rec ASO_QUOTE_PUB.control_rec_type;
3973: l_quote_header_rec ASO_QUOTE_PUB.qte_header_rec_type;

Line 3972: l_control_rec ASO_QUOTE_PUB.control_rec_type;

3968:
3969: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3970:
3971: -- variables for calling create_quote
3972: l_control_rec ASO_QUOTE_PUB.control_rec_type;
3973: l_quote_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
3974: l_quote_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;

Line 3973: l_quote_header_rec ASO_QUOTE_PUB.qte_header_rec_type;

3969: x_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3970:
3971: -- variables for calling create_quote
3972: l_control_rec ASO_QUOTE_PUB.control_rec_type;
3973: l_quote_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
3974: l_quote_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;

Line 3974: l_quote_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;

3970:
3971: -- variables for calling create_quote
3972: l_control_rec ASO_QUOTE_PUB.control_rec_type;
3973: l_quote_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
3974: l_quote_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;

Line 3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

3971: -- variables for calling create_quote
3972: l_control_rec ASO_QUOTE_PUB.control_rec_type;
3973: l_quote_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
3974: l_quote_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;

Line 3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;

3972: l_control_rec ASO_QUOTE_PUB.control_rec_type;
3973: l_quote_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
3974: l_quote_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
3980: l_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;

Line 3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;

3973: l_quote_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
3974: l_quote_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
3980: l_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
3981: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

Line 3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;

3974: l_quote_line_tab ASO_QUOTE_PUB.qte_line_tbl_type;
3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
3980: l_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
3981: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3982: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;

Line 3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;

3975: l_quote_line_dtl_tab ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
3980: l_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
3981: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3982: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3983:

Line 3980: l_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;

3976: l_quote_ln_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
3980: l_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
3981: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3982: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3983:
3984: --

Line 3981: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

3977: l_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
3980: l_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
3981: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3982: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3983:
3984: --
3985: l_quote_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;

Line 3982: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;

3978: l_quote_hd_shipment_tab ASO_QUOTE_PUB.shipment_tbl_type;
3979: l_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
3980: l_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
3981: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3982: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3983:
3984: --
3985: l_quote_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3986: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;

Line 3985: l_quote_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;

3981: l_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
3982: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3983:
3984: --
3985: l_quote_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3986: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3987:
3988: l_quote_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3989: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;

Line 3986: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;

3982: l_line_rltship_tab ASO_QUOTE_PUB.line_rltship_tbl_type;
3983:
3984: --
3985: l_quote_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3986: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3987:
3988: l_quote_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3989: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3990:

Line 3988: l_quote_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;

3984: --
3985: l_quote_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3986: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3987:
3988: l_quote_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3989: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3990:
3991: l_quote_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3992: l_qt_ln_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;

Line 3989: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;

3985: l_quote_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3986: l_quote_ln_price_adj_tab ASO_QUOTE_PUB.price_adj_tbl_type;
3987:
3988: l_quote_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3989: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3990:
3991: l_quote_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3992: l_qt_ln_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3993:

Line 3991: l_quote_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;

3987:
3988: l_quote_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3989: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3990:
3991: l_quote_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3992: l_qt_ln_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3993:
3994: l_quote_ln_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
3995: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;

Line 3992: l_qt_ln_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;

3988: l_quote_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3989: l_quote_ln_price_adj_attr_tab ASO_QUOTE_PUB.price_adj_attr_tbl_type;
3990:
3991: l_quote_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3992: l_qt_ln_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3993:
3994: l_quote_ln_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
3995: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
3996:

Line 3994: l_quote_ln_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;

3990:
3991: l_quote_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3992: l_qt_ln_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3993:
3994: l_quote_ln_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
3995: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
3996:
3997: --
3998:

Line 3995: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;

3991: l_quote_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3992: l_qt_ln_price_adj_rltship_tab ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
3993:
3994: l_quote_ln_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
3995: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
3996:
3997: --
3998:
3999: l_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;

Line 3999: l_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;

3995: l_quote_hd_price_attr_tab ASO_QUOTE_PUB.price_attributes_tbl_type;
3996:
3997: --
3998:
3999: l_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4000: l_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4001:
4002: l_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4003: l_quote_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

Line 4000: l_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;

3996:
3997: --
3998:
3999: l_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4000: l_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4001:
4002: l_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4003: l_quote_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4004: l_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

Line 4002: l_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

3998:
3999: l_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4000: l_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4001:
4002: l_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4003: l_quote_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4004: l_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4005: l_quote_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

Line 4003: l_quote_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

3999: l_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4000: l_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4001:
4002: l_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4003: l_quote_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4004: l_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4005: l_quote_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4007:

Line 4004: l_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

4000: l_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4001:
4002: l_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4003: l_quote_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4004: l_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4005: l_quote_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4007:
4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

Line 4005: l_quote_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

4001:
4002: l_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4003: l_quote_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4004: l_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4005: l_quote_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4007:
4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4009: lx_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

Line 4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

4002: l_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4003: l_quote_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4004: l_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4005: l_quote_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4007:
4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4009: lx_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4010: lx_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

Line 4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

4004: l_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4005: l_quote_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4007:
4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4009: lx_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4010: lx_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4011: lx_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

Line 4009: lx_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

4005: l_quote_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4007:
4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4009: lx_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4010: lx_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4011: lx_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4013:

Line 4010: lx_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

4006: l_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4007:
4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4009: lx_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4010: lx_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4011: lx_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4013:
4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;

Line 4011: lx_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

4007:
4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4009: lx_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4010: lx_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4011: lx_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4013:
4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

Line 4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;

4008: lx_hd_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4009: lx_hd_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4010: lx_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4011: lx_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4013:
4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

Line 4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;

4010: lx_hd_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4011: lx_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4013:
4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;

Line 4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;

4011: lx_ln_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4013:
4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;

Line 4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;

4012: lx_ln_quote_party_tbl ASO_QUOTE_PUB.quote_party_tbl_type;
4013:
4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;

Line 4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

4013:
4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;

Line 4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;

4014: lx_qte_header_rec ASO_QUOTE_PUB.qte_header_rec_type;
4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

Line 4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;

4015: lx_qte_line_tbl ASO_QUOTE_PUB.qte_line_tbl_type;
4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

Line 4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;

4016: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type;
4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

Line 4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;

4017: lx_hd_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;

Line 4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;

4018: lx_hd_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;
4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;

Line 4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;

4019: lx_hd_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;
4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

Line 4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;

4020: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;
4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;

Line 4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;

4021: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;
4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4029: lx_ln_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;

Line 4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;

4022: lx_line_attr_ext_tbl ASO_QUOTE_PUB.line_attribs_ext_tbl_type;
4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;
4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4029: lx_ln_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4030: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;

Line 4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;

4023: lx_line_rltship_tbl ASO_QUOTE_PUB.line_rltship_tbl_type;
4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;
4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4029: lx_ln_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4030: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4031: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;

Line 4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;

4024: lx_price_adjustment_tbl ASO_QUOTE_PUB.price_adj_tbl_type;
4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;
4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4029: lx_ln_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4030: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4031: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4032:

Line 4029: lx_ln_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;

4025: lx_price_adj_attr_tbl ASO_QUOTE_PUB.price_adj_attr_tbl_type;
4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4029: lx_ln_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4030: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4031: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4032:
4033:

Line 4030: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;

4026: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.price_adj_rltship_tbl_type;
4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4029: lx_ln_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4030: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4031: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4032:
4033:
4034:

Line 4031: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;

4027: lx_ln_price_attributes_tbl ASO_QUOTE_PUB.price_attributes_tbl_type;
4028: lx_ln_payment_tbl ASO_QUOTE_PUB.payment_tbl_type;
4029: lx_ln_shipment_tbl ASO_QUOTE_PUB.shipment_tbl_type;
4030: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.tax_detail_tbl_type;
4031: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.freight_charge_tbl_type;
4032:
4033:
4034:
4035: CALCULATE_TAX_FLAG VARCHAR2(1) := 'Y';

Line 4552: okc_util.print_trace(1, '>START - ******* aso_quote_pub.UPDATE_QUOTE -');

4548: END IF;
4549: l_control_rec.last_update_date := sysdate;
4550:
4551: IF (l_debug = 'Y') THEN
4552: okc_util.print_trace(1, '>START - ******* aso_quote_pub.UPDATE_QUOTE -');
4553: END IF;
4554:
4555: aso_quote_pub.update_quote(p_api_version_number => l_aso_api_version
4556: ,p_init_msg_list => FND_API.G_FALSE

Line 4555: aso_quote_pub.update_quote(p_api_version_number => l_aso_api_version

4551: IF (l_debug = 'Y') THEN
4552: okc_util.print_trace(1, '>START - ******* aso_quote_pub.UPDATE_QUOTE -');
4553: END IF;
4554:
4555: aso_quote_pub.update_quote(p_api_version_number => l_aso_api_version
4556: ,p_init_msg_list => FND_API.G_FALSE
4557: ,p_commit => FND_API.G_FALSE
4558: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
4559: ,p_control_rec => l_control_rec

Line 4658: okc_util.print_trace(1, '

4654: END IF;
4655:
4656: ------------------------------------------------------------------------------------------------
4657: IF (l_debug = 'Y') THEN
4658: okc_util.print_trace(1, ' 4659: okc_util.print_trace(1, '--------------------------------------------------------');
4660: okc_util.print_trace(1, ' ');
4661: okc_util.print_trace(1, 'OUTPUT RECORD - Completion status:');
4662: okc_util.print_trace(1, '==================================');