APPS.ONT_OEXOECOD_XMLP_PKG dependencies on DUAL

Line 227: DUAL;

223: SELECT
224: C_GL_CONV_RATE * OE_OE_TOTALS_SUMMARY.PRT_ORDER_TOTAL(HEADER_ID)
225: INTO FC_ORDER_VALUE
226: FROM
227: DUAL;
228: /*SRW.MESSAGE(1
229: ,'Order Value' || FC_ORDER_VALUE)*/NULL;
230: IF (RP_CURR_PROFILE = 'EXTENDED') THEN
231: FC_ORDER_VALUE := ROUND(FC_ORDER_VALUE

Line 264: DUAL;

260: SELECT
261: C_GL_CONV_RATE * HDR_PA_AMOUNT
262: INTO FC_PA_AMOUNT
263: FROM
264: DUAL;
265: RETURN (FC_PA_AMOUNT);
266: ELSE
267: RETURN (HDR_PA_AMOUNT);
268: END IF;

Line 285: DUAL;

281: SELECT
282: C_GL_CONV_RATE * LIST_PRICE
283: INTO FC_LIST_PRICE
284: FROM
285: DUAL;
286: IF (RP_CURR_PROFILE = 'EXTENDED') THEN
287: FC_LIST_PRICE := ROUND(FC_LIST_PRICE
288: ,CP_EXT_PRECISION);
289: ELSE

Line 321: DUAL;

317: SELECT
318: C_GL_CONV_RATE * SELLING_PRICE
319: INTO FC_SELLING_PRICE
320: FROM
321: DUAL;
322: IF (RP_CURR_PROFILE = 'EXTENDED') THEN
323: FC_SELLING_PRICE := ROUND(FC_SELLING_PRICE
324: ,CP_EXT_PRECISION);
325: ELSE

Line 357: DUAL;

353: SELECT
354: C_GL_CONV_RATE * EXTENDED_PRICE
355: INTO FC_EXTENDED_PRICE
356: FROM
357: DUAL;
358: IF (RP_CURR_PROFILE = 'EXTENDED') THEN
359: FC_EXTENDED_PRICE := ROUND(FC_EXTENDED_PRICE
360: ,CP_EXT_PRECISION);
361: ELSE

Line 392: DUAL;

388: SELECT
389: C_GL_CONV_RATE * L_PA_AMOUNT
390: INTO FC_PA_AMOUNT
391: FROM
392: DUAL;
393: RETURN (FC_PA_AMOUNT);
394: ELSE
395: RETURN (L_PA_AMOUNT);
396: END IF;

Line 710: DUAL;

706: C_GL_CONV_RATE * NVL(TAX_ON_LINE
707: ,0)
708: INTO FC_TAX
709: FROM
710: DUAL;
711: RETURN (FC_TAX);
712: ELSE
713: RETURN (TAX_ON_LINE);
714: END IF;

Line 731: DUAL;

727: C_GL_CONV_RATE * ROUND(LINE_CHARGE
728: ,2)
729: INTO FC_LINE_CHARGE
730: FROM
731: DUAL;
732: RETURN (FC_LINE_CHARGE);
733: ELSE
734: FC_LINE_CHARGE := ROUND(LINE_CHARGE
735: ,2);

Line 862: DUAL;

858: SELECT
859: C_GL_CONV_RATE * SVC_EXTENDED_PRICE
860: INTO FC_SVC_EXTENDED_PRICE
861: FROM
862: DUAL;
863: RETURN (FC_SVC_EXTENDED_PRICE);
864: ELSE
865: RETURN (SVC_EXTENDED_PRICE);
866: END IF;

Line 882: DUAL;

878: SELECT
879: C_GL_CONV_RATE * SVC_SELLING_PRICE
880: INTO FC_SVC_SELLING_PRICE
881: FROM
882: DUAL;
883: RETURN (FC_SVC_SELLING_PRICE);
884: ELSE
885: RETURN (SVC_SELLING_PRICE);
886: END IF;

Line 951: DUAL;

947: SELECT
948: C_GL_CONV_RATE * AMOUNT
949: INTO FC_AMOUNT
950: FROM
951: DUAL;
952: IF C_GL_CONV_RATE <> 1 THEN
953: FND_CURRENCY.GET_INFO(C_USE_CURRENCY
954: ,L_STD_PRECISION
955: ,L_EXT_PRECISION

Line 1352: DUAL;

1348: ,NULL
1349: ,L_END_CUSTOMER_COUNTRY)
1350: INTO L_END_CUSTOMER_ADDRESS5
1351: FROM
1352: DUAL;
1353: RETURN (L_END_CUSTOMER_ADDRESS5);
1354: ELSE
1355: RETURN NULL;
1356: END IF;

Line 1530: DUAL;

1526: ,NULL
1527: ,L_COUNTRY)
1528: INTO L_ADDRESS5
1529: FROM
1530: DUAL;
1531: RETURN (L_ADDRESS5);
1532: ELSIF IB_CURRENT_LOCATION = 'SOLD_TO' THEN
1533: SELECT
1534: LOC.CITY,

Line 1569: DUAL;

1565: ,NULL
1566: ,L_COUNTRY)
1567: INTO L_ADDRESS5
1568: FROM
1569: DUAL;
1570: RETURN (L_ADDRESS5);
1571: ELSIF IB_CURRENT_LOCATION = 'END_CUSTOMER' THEN
1572: SELECT
1573: LOC.CITY,

Line 1603: DUAL;

1599: ,NULL
1600: ,L_COUNTRY)
1601: INTO L_ADDRESS5
1602: FROM
1603: DUAL;
1604: RETURN (L_ADDRESS5);
1605: ELSE
1606: RETURN NULL;
1607: END IF;

Line 1716: DUAL;

1712: ,NULL
1713: ,L_COUNTRY)
1714: INTO L_ADDRESS5
1715: FROM
1716: DUAL;
1717: RETURN (L_ADDRESS5);
1718: ELSIF IB_INSTALLED_AT_LOCATION = 'SOLD_TO' THEN
1719: SELECT
1720: LOC.CITY,

Line 1755: DUAL;

1751: ,NULL
1752: ,L_COUNTRY)
1753: INTO L_ADDRESS5
1754: FROM
1755: DUAL;
1756: RETURN (L_ADDRESS5);
1757: ELSIF IB_INSTALLED_AT_LOCATION = 'END_CUSTOMER' THEN
1758: SELECT
1759: LOC.CITY,

Line 1789: DUAL;

1785: ,NULL
1786: ,L_COUNTRY)
1787: INTO L_ADDRESS5
1788: FROM
1789: DUAL;
1790: RETURN (L_ADDRESS5);
1791: ELSE
1792: RETURN NULL;
1793: END IF;