DBA Data[Home] [Help]

APPS.ASO_QUOTE_EBIZAD dependencies on ASO_QUOTE_PUB_QTE_HEADER_REC_

Line 24: -- ASO_QUOTE_PUB_QTE_HEADER_REC_

20: --
21: -- SQL Object and Tables:
22:
23: -- ASO_QUOTE_PUB_CONTROL_REC_TYP
24: -- ASO_QUOTE_PUB_QTE_HEADER_REC_
25: -- ASO_QUOTE_PUB_PRICE_ATTRIBU34
26: -- ASO_QUOTE_PUB_PRICE_ATTRIBUTE AS TABLE OF ASO_QUOTE_PUB_PRICE_ATTRIBU34;
27: -- ASO_QUOTE_PUB_PAYMENT_REC_TYP
28: -- ASO_QUOTE_PUB_PAYMENT_TBL_TYP AS TABLE OF ASO_QUOTE_PUB_PAYMENT_REC_TYP;

Line 71: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE

67: FUNCTION PL_TO_SQL19(aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE)
68: RETURN ASO_QUOTE_PUB_CONTROL_REC_TYP;
69: FUNCTION SQL_TO_PL0(aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP)
70: RETURN ASO_QUOTE_PUB.CONTROL_REC_TYPE;
71: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE
72: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
73:
74: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_;
75: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)

Line 72: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)

68: RETURN ASO_QUOTE_PUB_CONTROL_REC_TYP;
69: FUNCTION SQL_TO_PL0(aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP)
70: RETURN ASO_QUOTE_PUB.CONTROL_REC_TYPE;
71: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE
72: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
73:
74: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_;
75: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
76: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;

Line 74: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_;

70: RETURN ASO_QUOTE_PUB.CONTROL_REC_TYPE;
71: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE
72: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
73:
74: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_;
75: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
76: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
77: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE
78: FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)

Line 75: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)

71: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE
72: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
73:
74: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_;
75: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
76: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
77: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE
78: FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)
79: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34;

Line 76: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;

72: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
73:
74: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_;
75: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
76: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
77: -- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE
78: FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)
79: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34;
80: FUNCTION SQL_TO_PL20(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34)

Line 254: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,

250: P_INIT_MSG_LIST IN VARCHAR2,
251: P_COMMIT IN VARCHAR2,
252: P_VALIDATION_LEVEL IN NUMBER,
253: P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
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_,

Line 280: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,

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,
284: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,