[Home] [Help]
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 :
61: -- NOTE :
62:
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)
241: RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
242: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE
243: FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
244: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL;
245: FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
246: RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
239: RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC;
240: FUNCTION SQL_TO_PL35(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC)
241: RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
242: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE
243: FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
244: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL;
245: FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
246: RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
247:
240: FUNCTION SQL_TO_PL35(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC)
241: RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
242: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE
243: FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
244: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL;
245: FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
246: RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
247:
248: PROCEDURE CREATE_QUOTE_SERVICE (
241: RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
242: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE
243: FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
244: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL;
245: FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
246: RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
247:
248: PROCEDURE CREATE_QUOTE_SERVICE (
249: P_API_VERSION_NUMBER IN NUMBER,
242: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE
243: FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
244: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL;
245: FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
246: RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
247:
248: PROCEDURE CREATE_QUOTE_SERVICE (
249: P_API_VERSION_NUMBER IN NUMBER,
250: P_INIT_MSG_LIST IN VARCHAR2,
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,
283: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
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
309: );