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_ADJ_ATTR_

Line 2407: FUNCTION PL_TO_SQL31(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE)

2403: null;
2404: end;
2405: RETURN aPlsqlItem;
2406: END SQL_TO_PL13;
2407: FUNCTION PL_TO_SQL31(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE)
2408: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATT37 IS
2409: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37;
2410: BEGIN
2411: -- initialize the object

Line 2438: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE IS

2434: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2435: RETURN aSqlItem;
2436: END PL_TO_SQL31;
2437: FUNCTION SQL_TO_PL31(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37)
2438: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE IS
2439: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
2440: BEGIN
2441: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2442: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;

Line 2439: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;

2435: RETURN aSqlItem;
2436: END PL_TO_SQL31;
2437: FUNCTION SQL_TO_PL31(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37)
2438: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE IS
2439: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
2440: BEGIN
2441: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2442: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2443: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;

Line 2465: FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)

2461: aPlsqlItem.FLEX_TITLE := aSqlItem.FLEX_TITLE;
2462: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2463: RETURN aPlsqlItem;
2464: END SQL_TO_PL31;
2465: FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)
2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468: BEGIN
2469: -- initialize the table

Line 2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS

2462: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2463: RETURN aPlsqlItem;
2464: END SQL_TO_PL31;
2465: FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)
2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468: BEGIN
2469: -- initialize the table
2470: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATTR_();

Line 2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;

2463: RETURN aPlsqlItem;
2464: END SQL_TO_PL31;
2465: FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)
2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468: BEGIN
2469: -- initialize the table
2470: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATTR_();
2471: IF aPlsqlItem.COUNT > 0 THEN

Line 2470: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATTR_();

2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468: BEGIN
2469: -- initialize the table
2470: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATTR_();
2471: IF aPlsqlItem.COUNT > 0 THEN
2472: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2473: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2474: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL31(aPlsqlItem(I));

Line 2479: FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)

2475: END LOOP;
2476: END IF;
2477: RETURN aSqlItem;
2478: END PL_TO_SQL13;
2479: FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)
2480: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE IS
2481: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2482: BEGIN
2483: BEGIN

Line 2480: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE IS

2476: END IF;
2477: RETURN aSqlItem;
2478: END PL_TO_SQL13;
2479: FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)
2480: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE IS
2481: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2482: BEGIN
2483: BEGIN
2484: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2481: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;

2477: RETURN aSqlItem;
2478: END PL_TO_SQL13;
2479: FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)
2480: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE IS
2481: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2482: BEGIN
2483: BEGIN
2484: FOR I IN 1..aSqlItem.COUNT LOOP
2485: aPlsqlItem(I) := SQL_TO_PL31(aSqlItem(I));

Line 2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,

2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
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,

Line 2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,

2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
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,

Line 2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;

2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_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;

Line 2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;

2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_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;