[Home] [Help]
52: -- ASO_QUOTE_PUB_SHIPMENT_TBL_TY AS TABLE OF ASO_QUOTE_PUB_SHIPMENT_REC_TY;
53: -- ASO_QUOTE_PUB_QTE_ACCESS_REC_
54: -- ASO_QUOTE_PUB_QTE_ACCESS_TBL_ AS TABLE OF ASO_QUOTE_PUB_QTE_ACCESS_REC_;
55: -- ASO_QUOTE_PUB_TEMPLATE_REC_TY
56: -- ASO_QUOTE_PUB_TEMPLATE_TBL_TY AS TABLE OF ASO_QUOTE_PUB_TEMPLATE_REC_TY;
57: -- ASO_QUOTE_PUB_RELATED_OBJ_REC
58: -- ASO_QUOTE_PUB_RELATED_OBJ_TBL AS TABLE OF ASO_QUOTE_PUB_RELATED_OBJ_REC;
59:
60: - History :
228: FUNCTION PL_TO_SQL34(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE)
229: RETURN ASO_QUOTE_PUB_TEMPLATE_REC_TY;
230: FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
231: RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
232: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE
233: FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
234: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
235: FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
236: RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
229: RETURN ASO_QUOTE_PUB_TEMPLATE_REC_TY;
230: FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
231: RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
232: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE
233: FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
234: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
235: FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
236: RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
237: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE
230: FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
231: RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
232: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE
233: FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
234: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
235: FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
236: RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
237: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE
238: FUNCTION PL_TO_SQL35(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE)
231: RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
232: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE
233: FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
234: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
235: FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
236: RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
237: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE
238: FUNCTION PL_TO_SQL35(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE)
239: RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC;
232: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE
233: FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
234: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
235: FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
236: RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
237: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE
238: FUNCTION PL_TO_SQL35(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE)
239: RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC;
240: FUNCTION SQL_TO_PL35(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC)
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_,
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,
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_,
304: X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
305: X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
306: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
307: X_MSG_COUNT OUT NOCOPY NUMBER,
308: X_MSG_DATA OUT NOCOPY VARCHAR2