eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ASO_QUOTE_EBIZAD dependencies on ASO_QUOTE_PUB_PRICE_ATTRIBUTE

Line 380: FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)

376: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
377: aPlsqlItem.HEADER_PAYNOW_CHARGES := aSqlItem.HEADER_PAYNOW_CHARGES;
378: RETURN aPlsqlItem;
379: END SQL_TO_PL1;
380: FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)
381: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34 IS
382: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34;
383: BEGIN
384: -- initialize the object

Line 531: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE IS

527: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
528: RETURN aSqlItem;
529: END PL_TO_SQL20;
530: FUNCTION SQL_TO_PL20(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34)
531: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE IS
532: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE;
533: BEGIN
534: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
535: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;

Line 532: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE;

528: RETURN aSqlItem;
529: END PL_TO_SQL20;
530: FUNCTION SQL_TO_PL20(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34)
531: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE IS
532: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE;
533: BEGIN
534: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
535: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
536: aPlsqlItem.PRICE_ATTRIBUTE_ID := aSqlItem.PRICE_ATTRIBUTE_ID;

Line 675: FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)

671: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
672: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
673: RETURN aPlsqlItem;
674: END SQL_TO_PL20;
675: FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)
676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678: BEGIN
679: -- initialize the table

Line 676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS

672: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
673: RETURN aPlsqlItem;
674: END SQL_TO_PL20;
675: FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)
676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678: BEGIN
679: -- initialize the table
680: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBUTE();

Line 677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;

673: RETURN aPlsqlItem;
674: END SQL_TO_PL20;
675: FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)
676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678: BEGIN
679: -- initialize the table
680: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBUTE();
681: IF aPlsqlItem.COUNT > 0 THEN

Line 680: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBUTE();

676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678: BEGIN
679: -- initialize the table
680: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBUTE();
681: IF aPlsqlItem.COUNT > 0 THEN
682: aSqlItem.EXTEND(aPlsqlItem.COUNT);
683: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
684: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL20(aPlsqlItem(I));

Line 689: FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)

685: END LOOP;
686: END IF;
687: RETURN aSqlItem;
688: END PL_TO_SQL3;
689: FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)
690: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE IS
691: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
692: BEGIN
693: -- Added to take care of 'reference to uninitialized collection' error.

Line 690: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE IS

686: END IF;
687: RETURN aSqlItem;
688: END PL_TO_SQL3;
689: FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)
690: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE IS
691: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
692: BEGIN
693: -- Added to take care of 'reference to uninitialized collection' error.
694: begin

Line 691: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;

687: RETURN aSqlItem;
688: END PL_TO_SQL3;
689: FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)
690: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE IS
691: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
692: BEGIN
693: -- Added to take care of 'reference to uninitialized collection' error.
694: begin
695: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,

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_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,

Line 2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,

2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,

Line 2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,

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,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,

Line 2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,

2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,

Line 2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;

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;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;

Line 2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;

2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;

Line 2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_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;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;

Line 2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;

2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;