[Home] [Help]
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;
36: -- ASO_QUOTE_PUB_SALES_CREDIT_RE
37: -- ASO_QUOTE_PUB_SALES_CREDIT_TB AS TABLE OF ASO_QUOTE_PUB_SALES_CREDIT_RE;
38: -- ASO_QUOTE_PUB_QUOTE_PARTY_REC
39: -- ASO_QUOTE_PUB_QUOTE_PARTY_TBL AS TABLE OF ASO_QUOTE_PUB_QUOTE_PARTY_REC;
118: FUNCTION PL_TO_SQL7(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE)
119: RETURN ASO_QUOTE_PUB_TAX_DETAIL_TBL_;
120: FUNCTION SQL_TO_PL6(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_)
121: RETURN ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
122: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE
123: FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
124: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36;
125: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
126: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
119: RETURN ASO_QUOTE_PUB_TAX_DETAIL_TBL_;
120: FUNCTION SQL_TO_PL6(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_)
121: RETURN ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
122: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE
123: FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
124: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36;
125: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
126: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
127: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE
122: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE
123: FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
124: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36;
125: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
126: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
127: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE
128: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
129: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
130: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
123: FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
124: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36;
125: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
126: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
127: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE
128: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
129: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
130: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
131: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
124: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36;
125: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
126: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
127: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE
128: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
129: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
130: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
131: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
132: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE
125: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
126: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
127: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE
128: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
129: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
130: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
131: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
132: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE
133: FUNCTION PL_TO_SQL25(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE)
126: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
127: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE
128: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
129: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
130: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
131: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
132: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE
133: FUNCTION PL_TO_SQL25(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE)
134: RETURN ASO_QUOTE_PUB_SALES_CREDIT_RE;
127: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE
128: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
129: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
130: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
131: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
132: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE
133: FUNCTION PL_TO_SQL25(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE)
134: RETURN ASO_QUOTE_PUB_SALES_CREDIT_RE;
135: FUNCTION SQL_TO_PL25(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE)
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,
263: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
264: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
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,
263: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
264: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
265: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
266: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
267: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
268: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
269: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
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,
291: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
292: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
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,
291: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
292: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
293: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
294: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
295: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,