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_RLTSH

Line 2493: FUNCTION PL_TO_SQL32(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE)

2489: null;
2490: end;
2491: RETURN aPlsqlItem;
2492: END SQL_TO_PL14;
2493: FUNCTION PL_TO_SQL32(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE)
2494: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLT38 IS
2495: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38;
2496: BEGIN
2497: -- initialize the object

Line 2522: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE IS

2518: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2519: RETURN aSqlItem;
2520: END PL_TO_SQL32;
2521: FUNCTION SQL_TO_PL32(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38)
2522: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE IS
2523: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE;
2524: BEGIN
2525: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2526: aPlsqlItem.ADJ_RELATIONSHIP_ID := aSqlItem.ADJ_RELATIONSHIP_ID;

Line 2523: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE;

2519: RETURN aSqlItem;
2520: END PL_TO_SQL32;
2521: FUNCTION SQL_TO_PL32(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38)
2522: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE IS
2523: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE;
2524: BEGIN
2525: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2526: aPlsqlItem.ADJ_RELATIONSHIP_ID := aSqlItem.ADJ_RELATIONSHIP_ID;
2527: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;

Line 2547: FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)

2543: aPlsqlItem.RLTD_PRICE_ADJ_INDEX := aSqlItem.RLTD_PRICE_ADJ_INDEX;
2544: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2545: RETURN aPlsqlItem;
2546: END SQL_TO_PL32;
2547: FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)
2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550: BEGIN
2551: -- initialize the table

Line 2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS

2544: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2545: RETURN aPlsqlItem;
2546: END SQL_TO_PL32;
2547: FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)
2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550: BEGIN
2551: -- initialize the table
2552: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLTSH();

Line 2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;

2545: RETURN aPlsqlItem;
2546: END SQL_TO_PL32;
2547: FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)
2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550: BEGIN
2551: -- initialize the table
2552: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLTSH();
2553: IF aPlsqlItem.COUNT > 0 THEN

Line 2552: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLTSH();

2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550: BEGIN
2551: -- initialize the table
2552: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLTSH();
2553: IF aPlsqlItem.COUNT > 0 THEN
2554: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2555: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2556: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL32(aPlsqlItem(I));

Line 2561: FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)

2557: END LOOP;
2558: END IF ;
2559: RETURN aSqlItem;
2560: END PL_TO_SQL14;
2561: FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)
2562: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE IS
2563: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2564: BEGIN
2565: begin

Line 2562: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE IS

2558: END IF ;
2559: RETURN aSqlItem;
2560: END PL_TO_SQL14;
2561: FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)
2562: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE IS
2563: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2564: BEGIN
2565: begin
2566: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2563: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;

2559: RETURN aSqlItem;
2560: END PL_TO_SQL14;
2561: FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)
2562: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE IS
2563: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2564: BEGIN
2565: begin
2566: FOR I IN 1..aSqlItem.COUNT LOOP
2567: aPlsqlItem(I) := SQL_TO_PL32(aSqlItem(I));

Line 2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,

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,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,

Line 2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,

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,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,

Line 2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_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;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;

Line 2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_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;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;