[Home] [Help]
39: -- ASO_QUOTE_PUB_QUOTE_PARTY_TBL AS TABLE OF ASO_QUOTE_PUB_QUOTE_PARTY_REC;
40: -- ASO_QUOTE_PUB_QTE_LINE_REC_TY
41: -- ASO_QUOTE_PUB_QTE_LINE_TBL_TY AS TABLE OF ASO_QUOTE_PUB_QTE_LINE_REC_TY;
42: -- ASO_QUOTE_PUB_QTE_LINE_DTL_RE
43: -- ASO_QUOTE_PUB_QTE_LINE_DTL_TB AS TABLE OF ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
44: -- ASO_QUOTE_PUB_LINE_RLTSHIP_RE
45: -- ASO_QUOTE_PUB_LINE_RLTSHIP_TB AS TABLE OF ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
46: -- ASO_QUOTE_PUB_PRICE_ADJ_REC_T
47: -- ASO_QUOTE_PUB_PRICE_ADJ_TBL_T AS TABLE OF ASO_QUOTE_PUB_PRICE_ADJ_REC_T;
163: FUNCTION PL_TO_SQL28(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE)
164: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
165: FUNCTION SQL_TO_PL28(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE)
166: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
167: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE
168: FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
169: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
170: FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
171: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
164: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
165: FUNCTION SQL_TO_PL28(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE)
166: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
167: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE
168: FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
169: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
170: FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
171: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
172: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE
165: FUNCTION SQL_TO_PL28(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE)
166: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
167: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE
168: FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
169: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
170: FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
171: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
172: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE
173: FUNCTION PL_TO_SQL29(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE)
166: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
167: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE
168: FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
169: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
170: FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
171: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
172: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE
173: FUNCTION PL_TO_SQL29(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE)
174: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
167: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE
168: FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
169: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
170: FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
171: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
172: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE
173: FUNCTION PL_TO_SQL29(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE)
174: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
175: FUNCTION SQL_TO_PL29(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE)
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,
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_,
278: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
279: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
280: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
281: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
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_,