[Home] [Help]
27: -- ASO_QUOTE_PUB_PAYMENT_REC_TYP
28: -- ASO_QUOTE_PUB_PAYMENT_TBL_TYP AS TABLE OF ASO_QUOTE_PUB_PAYMENT_REC_TYP;
29: -- ASO_QUOTE_PUB_SHIPMENT_REC_TY
30: -- ASO_QUOTE_PUB_FREIGHT_CHARG35
31: -- ASO_QUOTE_PUB_FREIGHT_CHARGE_ AS TABLE OF ASO_QUOTE_PUB_FREIGHT_CHARG35;
32: -- ASO_QUOTE_PUB_TAX_DETAIL_REC_
33: -- ASO_QUOTE_PUB_TAX_DETAIL_TBL_ AS TABLE OF ASO_QUOTE_PUB_TAX_DETAIL_REC_;
34: -- ASO_QUOTE_PUB_LINE_ATTRIBS_36
35: -- ASO_QUOTE_PUB_LINE_ATTRIBS_EX AS TABLE OF ASO_QUOTE_PUB_LINE_ATTRIBS_36;
98: FUNCTION PL_TO_SQL5(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE)
99: RETURN ASO_QUOTE_PUB_SHIPMENT_REC_TY;
100: FUNCTION SQL_TO_PL4(aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY)
101: RETURN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
102: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE
103: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
104: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35;
105: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
106: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
99: RETURN ASO_QUOTE_PUB_SHIPMENT_REC_TY;
100: FUNCTION SQL_TO_PL4(aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY)
101: RETURN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
102: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE
103: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
104: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35;
105: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
106: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
107: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE
102: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE
103: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
104: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35;
105: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
106: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
107: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE
108: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
109: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_;
110: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
103: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
104: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35;
105: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
106: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
107: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE
108: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
109: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_;
110: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
111: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
104: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35;
105: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
106: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
107: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE
108: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
109: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_;
110: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
111: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
112: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
105: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
106: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
107: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE
108: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
109: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_;
110: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
111: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
112: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
113: FUNCTION PL_TO_SQL23(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
106: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
107: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE
108: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
109: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_;
110: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
111: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
112: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
113: FUNCTION PL_TO_SQL23(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
114: RETURN ASO_QUOTE_PUB_TAX_DETAIL_REC_;
107: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE
108: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
109: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_;
110: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
111: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
112: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
113: FUNCTION PL_TO_SQL23(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
114: RETURN ASO_QUOTE_PUB_TAX_DETAIL_REC_;
115: FUNCTION SQL_TO_PL23(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_)
254: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
255: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
256: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
257: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
258: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
259: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
260: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
261: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
262: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
269: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
270: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
271: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
272: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
273: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
274: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
275: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
276: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
277: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
282: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
283: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
284: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
285: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
286: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
287: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
288: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
289: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
290: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
295: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
296: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
297: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
298: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
299: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
300: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
301: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
302: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
303: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,