[Home] [Help]
75: aPlsqlItem.DEFAULTING_FWK_FLAG := aSqlItem.DEFAULTING_FWK_FLAG;
76: aPlsqlItem.APPLICATION_TYPE_CODE := aSqlItem.APPLICATION_TYPE_CODE;
77: RETURN aPlsqlItem;
78: END SQL_TO_PL0;
79: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
80: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81: aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82: BEGIN
83: -- initialize the object
76: aPlsqlItem.APPLICATION_TYPE_CODE := aSqlItem.APPLICATION_TYPE_CODE;
77: RETURN aPlsqlItem;
78: END SQL_TO_PL0;
79: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
80: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81: aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82: BEGIN
83: -- initialize the object
84: aSqlItem := ASO_QUOTE_PUB_QTE_HEADER_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
77: RETURN aPlsqlItem;
78: END SQL_TO_PL0;
79: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
80: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81: aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82: BEGIN
83: -- initialize the object
84: aSqlItem := ASO_QUOTE_PUB_QTE_HEADER_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
85: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
80: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81: aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82: BEGIN
83: -- initialize the object
84: aSqlItem := ASO_QUOTE_PUB_QTE_HEADER_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
85: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
86: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
87: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
88: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
229: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
230: aSqlItem.HEADER_PAYNOW_CHARGES := aPlsqlItem.HEADER_PAYNOW_CHARGES;
231: RETURN aSqlItem;
232: END PL_TO_SQL0;
233: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
234: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE IS
235: aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
236: BEGIN
237: aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
230: aSqlItem.HEADER_PAYNOW_CHARGES := aPlsqlItem.HEADER_PAYNOW_CHARGES;
231: RETURN aSqlItem;
232: END PL_TO_SQL0;
233: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
234: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE IS
235: aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
236: BEGIN
237: aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
238: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
231: RETURN aSqlItem;
232: END PL_TO_SQL0;
233: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
234: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE IS
235: aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
236: BEGIN
237: aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
238: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
239: aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
2859: P_INIT_MSG_LIST IN VARCHAR2,
2860: P_COMMIT IN VARCHAR2,
2861: P_VALIDATION_LEVEL IN NUMBER,
2862: P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
2863: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2919:
2920: IS
2921: P_CONTROL_REC_ APPS.ASO_QUOTE_PUB.CONTROL_REC_TYPE;
2922:
2923: P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;