eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_EBIZAD dependencies on ASO_QUOTE_EBIZAD

Line 1: PACKAGE BODY ASO_QUOTE_EBIZAD AS

1: PACKAGE BODY ASO_QUOTE_EBIZAD AS
2: /* $Header: asopebzb.pls 120.1 2010/08/20 21:31:50 cazhou noship $ */
3: /*
4: * @rep:scope public
5: * @rep:product ASO

Line 14: -- Package name : ASO_QUOTE_EBIZAD

10: */
11:
12:
13: /*-- Start of Comments
14: -- Package name : ASO_QUOTE_EBIZAD
15: -- Purpose :
16: -- These public APIs wrapper for the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE. The wrapper exposes this service to be invoked from the Oracle Apps Adapter by using the SQL
17: -- Object types for the parameter instead of the PL SQL Record types. This is done by defining the Functions to convert from SQL Object type to and from PL SQL Object
18: -- type and in the CREATE_QUOTE_SERVICE procedure invokes the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE after doing the required convertion from the SQL object type to

Line 2978: P_CONTROL_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL0(P_CONTROL_REC);

2974: X_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2975: x_msg_data_temp VARCHAR2(2000);
2976: lx_msg_index_out NUMBER;
2977: BEGIN
2978: P_CONTROL_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL0(P_CONTROL_REC);
2979: P_QTE_HEADER_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL1(P_QTE_HEADER_REC);
2980: P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);
2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);

Line 2979: P_QTE_HEADER_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL1(P_QTE_HEADER_REC);

2975: x_msg_data_temp VARCHAR2(2000);
2976: lx_msg_index_out NUMBER;
2977: BEGIN
2978: P_CONTROL_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL0(P_CONTROL_REC);
2979: P_QTE_HEADER_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL1(P_QTE_HEADER_REC);
2980: P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);
2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);

Line 2980: P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);

2976: lx_msg_index_out NUMBER;
2977: BEGIN
2978: P_CONTROL_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL0(P_CONTROL_REC);
2979: P_QTE_HEADER_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL1(P_QTE_HEADER_REC);
2980: P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);
2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);

Line 2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);

2977: BEGIN
2978: P_CONTROL_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL0(P_CONTROL_REC);
2979: P_QTE_HEADER_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL1(P_QTE_HEADER_REC);
2980: P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);
2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);

Line 2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);

2978: P_CONTROL_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL0(P_CONTROL_REC);
2979: P_QTE_HEADER_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL1(P_QTE_HEADER_REC);
2980: P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);
2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);

Line 2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);

2979: P_QTE_HEADER_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL1(P_QTE_HEADER_REC);
2980: P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);
2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);

Line 2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);

2980: P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);
2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);

Line 2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);

2981: P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);

Line 2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);

2982: P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);

Line 2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);

2983: P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);

Line 2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);

2984: P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);

Line 2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);

2985: P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);

Line 2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);

2986: P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);

Line 2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);

2987: P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);

Line 2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);

2988: P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);

Line 2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);

2989: P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);

Line 2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);

2990: P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);

Line 2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);

2991: P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);

Line 2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);

2992: P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);

Line 2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);

2993: P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);

Line 2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);

2994: P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);
3002: P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);

Line 2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);

2995: P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);
3002: P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);
3003: P_TEMPLATE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL18(P_TEMPLATE_TBL);

Line 3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);

2996: P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);
3002: P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);
3003: P_TEMPLATE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL18(P_TEMPLATE_TBL);
3004: P_RELATED_OBJ_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL19(P_RELATED_OBJ_TBL);

Line 3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);

2997: P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);
3002: P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);
3003: P_TEMPLATE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL18(P_TEMPLATE_TBL);
3004: P_RELATED_OBJ_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL19(P_RELATED_OBJ_TBL);
3005:

Line 3002: P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);

2998: P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);
3002: P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);
3003: P_TEMPLATE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL18(P_TEMPLATE_TBL);
3004: P_RELATED_OBJ_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL19(P_RELATED_OBJ_TBL);
3005:
3006: po_moac_utils_pvt.set_org_context(P_QTE_HEADER_REC_.ORG_ID);

Line 3003: P_TEMPLATE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL18(P_TEMPLATE_TBL);

2999: P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);
3002: P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);
3003: P_TEMPLATE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL18(P_TEMPLATE_TBL);
3004: P_RELATED_OBJ_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL19(P_RELATED_OBJ_TBL);
3005:
3006: po_moac_utils_pvt.set_org_context(P_QTE_HEADER_REC_.ORG_ID);
3007:

Line 3004: P_RELATED_OBJ_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL19(P_RELATED_OBJ_TBL);

3000: P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001: P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);
3002: P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);
3003: P_TEMPLATE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL18(P_TEMPLATE_TBL);
3004: P_RELATED_OBJ_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL19(P_RELATED_OBJ_TBL);
3005:
3006: po_moac_utils_pvt.set_org_context(P_QTE_HEADER_REC_.ORG_ID);
3007:
3008: APPS.ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE(1.0,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,P_CONTROL_REC_,P_QTE_HEADER_REC_,P_HD_PRICE_ATTRIBUTES_TBL_,P_HD_PAYMENT_TBL_,

Line 3017: X_QTE_HEADER_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL0(X_QTE_HEADER_REC_);

3013: X_HD_ATTR_EXT_TBL_,X_HD_SALES_CREDIT_TBL_,X_HD_QUOTE_PARTY_TBL_,X_LINE_ATTR_EXT_TBL_,X_LINE_RLTSHIP_TBL_,X_PRICE_ADJUSTMENT_TBL_,X_PRICE_ADJ_ATTR_TBL_,X_PRICE_ADJ_RLTSHIP_TBL_,
3014: X_LN_PRICE_ATTRIBUTES_TBL_,X_LN_PAYMENT_TBL_,X_LN_SHIPMENT_TBL_,X_LN_FREIGHT_CHARGE_TBL_,X_LN_TAX_DETAIL_TBL_,X_LN_SALES_CREDIT_TBL_,X_LN_QUOTE_PARTY_TBL_,X_QTE_ACCESS_TBL_,
3015: X_TEMPLATE_TBL_,X_RELATED_OBJ_TBL_,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA);
3016:
3017: X_QTE_HEADER_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL0(X_QTE_HEADER_REC_);
3018: X_QTE_LINE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL1(X_QTE_LINE_TBL_);
3019: X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);
3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);

Line 3018: X_QTE_LINE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL1(X_QTE_LINE_TBL_);

3014: X_LN_PRICE_ATTRIBUTES_TBL_,X_LN_PAYMENT_TBL_,X_LN_SHIPMENT_TBL_,X_LN_FREIGHT_CHARGE_TBL_,X_LN_TAX_DETAIL_TBL_,X_LN_SALES_CREDIT_TBL_,X_LN_QUOTE_PARTY_TBL_,X_QTE_ACCESS_TBL_,
3015: X_TEMPLATE_TBL_,X_RELATED_OBJ_TBL_,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA);
3016:
3017: X_QTE_HEADER_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL0(X_QTE_HEADER_REC_);
3018: X_QTE_LINE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL1(X_QTE_LINE_TBL_);
3019: X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);
3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);

Line 3019: X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);

3015: X_TEMPLATE_TBL_,X_RELATED_OBJ_TBL_,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA);
3016:
3017: X_QTE_HEADER_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL0(X_QTE_HEADER_REC_);
3018: X_QTE_LINE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL1(X_QTE_LINE_TBL_);
3019: X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);
3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);

Line 3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);

3016:
3017: X_QTE_HEADER_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL0(X_QTE_HEADER_REC_);
3018: X_QTE_LINE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL1(X_QTE_LINE_TBL_);
3019: X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);
3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);

Line 3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);

3017: X_QTE_HEADER_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL0(X_QTE_HEADER_REC_);
3018: X_QTE_LINE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL1(X_QTE_LINE_TBL_);
3019: X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);
3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);

Line 3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);

3018: X_QTE_LINE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL1(X_QTE_LINE_TBL_);
3019: X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);
3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);

Line 3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);

3019: X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);
3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);

Line 3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);

3020: X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);

Line 3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);

3021: X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);

Line 3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);

3022: X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);

Line 3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);

3023: X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);

Line 3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);

3024: X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);

Line 3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);

3025: X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);

Line 3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);

3026: X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);

Line 3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);

3027: X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);

Line 3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);

3028: X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);

Line 3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);

3029: X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);

Line 3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);

3030: X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);

Line 3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);

3031: X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);

Line 3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);

3032: X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);
3040: X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);

Line 3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);

3033: X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);
3040: X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);
3041: X_TEMPLATE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL17(X_TEMPLATE_TBL_);

Line 3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);

3034: X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);
3040: X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);
3041: X_TEMPLATE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL17(X_TEMPLATE_TBL_);
3042: X_RELATED_OBJ_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL18(X_RELATED_OBJ_TBL_);

Line 3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);

3035: X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);
3040: X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);
3041: X_TEMPLATE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL17(X_TEMPLATE_TBL_);
3042: X_RELATED_OBJ_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL18(X_RELATED_OBJ_TBL_);
3043:

Line 3040: X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);

3036: X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);
3040: X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);
3041: X_TEMPLATE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL17(X_TEMPLATE_TBL_);
3042: X_RELATED_OBJ_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL18(X_RELATED_OBJ_TBL_);
3043:
3044: IF X_MSG_COUNT > 0 THEN

Line 3041: X_TEMPLATE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL17(X_TEMPLATE_TBL_);

3037: X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);
3040: X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);
3041: X_TEMPLATE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL17(X_TEMPLATE_TBL_);
3042: X_RELATED_OBJ_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL18(X_RELATED_OBJ_TBL_);
3043:
3044: IF X_MSG_COUNT > 0 THEN
3045: FOR i IN 1..X_MSG_COUNT LOOP

Line 3042: X_RELATED_OBJ_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL18(X_RELATED_OBJ_TBL_);

3038: X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039: X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);
3040: X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);
3041: X_TEMPLATE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL17(X_TEMPLATE_TBL_);
3042: X_RELATED_OBJ_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL18(X_RELATED_OBJ_TBL_);
3043:
3044: IF X_MSG_COUNT > 0 THEN
3045: FOR i IN 1..X_MSG_COUNT LOOP
3046: fnd_msg_pub.get(p_msg_index =>i,

Line 3060: END ASO_QUOTE_EBIZAD;

3056: END IF;
3057:
3058: END CREATE_QUOTE_SERVICE;
3059:
3060: END ASO_QUOTE_EBIZAD;