APPS.ONT_OEXOECOD_XMLP_PKG dependencies on DUAL

Line 225: DUAL;

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

Line 262: DUAL;

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

Line 283: DUAL;

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

Line 319: DUAL;

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

Line 355: DUAL;

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

Line 390: DUAL;

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

Line 706: DUAL;

702: C_GL_CONV_RATE * NVL(TAX_ON_LINE
703: ,0)
704: INTO FC_TAX
705: FROM
706: DUAL;
707: RETURN (FC_TAX);
708: ELSE
709: RETURN (TAX_ON_LINE);
710: END IF;

Line 727: DUAL;

723: C_GL_CONV_RATE * ROUND(LINE_CHARGE
724: ,2)
725: INTO FC_LINE_CHARGE
726: FROM
727: DUAL;
728: RETURN (FC_LINE_CHARGE);
729: ELSE
730: FC_LINE_CHARGE := ROUND(LINE_CHARGE
731: ,2);

Line 858: DUAL;

854: SELECT
855: C_GL_CONV_RATE * SVC_EXTENDED_PRICE
856: INTO FC_SVC_EXTENDED_PRICE
857: FROM
858: DUAL;
859: RETURN (FC_SVC_EXTENDED_PRICE);
860: ELSE
861: RETURN (SVC_EXTENDED_PRICE);
862: END IF;

Line 878: DUAL;

874: SELECT
875: C_GL_CONV_RATE * SVC_SELLING_PRICE
876: INTO FC_SVC_SELLING_PRICE
877: FROM
878: DUAL;
879: RETURN (FC_SVC_SELLING_PRICE);
880: ELSE
881: RETURN (SVC_SELLING_PRICE);
882: END IF;

Line 947: DUAL;

943: SELECT
944: C_GL_CONV_RATE * AMOUNT
945: INTO FC_AMOUNT
946: FROM
947: DUAL;
948: IF C_GL_CONV_RATE <> 1 THEN
949: FND_CURRENCY.GET_INFO(C_USE_CURRENCY
950: ,L_STD_PRECISION
951: ,L_EXT_PRECISION

Line 1348: DUAL;

1344: ,NULL
1345: ,L_END_CUSTOMER_COUNTRY)
1346: INTO L_END_CUSTOMER_ADDRESS5
1347: FROM
1348: DUAL;
1349: RETURN (L_END_CUSTOMER_ADDRESS5);
1350: ELSE
1351: RETURN NULL;
1352: END IF;

Line 1526: DUAL;

1522: ,NULL
1523: ,L_COUNTRY)
1524: INTO L_ADDRESS5
1525: FROM
1526: DUAL;
1527: RETURN (L_ADDRESS5);
1528: ELSIF IB_CURRENT_LOCATION = 'SOLD_TO' THEN
1529: SELECT
1530: LOC.CITY,

Line 1565: DUAL;

1561: ,NULL
1562: ,L_COUNTRY)
1563: INTO L_ADDRESS5
1564: FROM
1565: DUAL;
1566: RETURN (L_ADDRESS5);
1567: ELSIF IB_CURRENT_LOCATION = 'END_CUSTOMER' THEN
1568: SELECT
1569: LOC.CITY,

Line 1599: DUAL;

1595: ,NULL
1596: ,L_COUNTRY)
1597: INTO L_ADDRESS5
1598: FROM
1599: DUAL;
1600: RETURN (L_ADDRESS5);
1601: ELSE
1602: RETURN NULL;
1603: END IF;

Line 1712: DUAL;

1708: ,NULL
1709: ,L_COUNTRY)
1710: INTO L_ADDRESS5
1711: FROM
1712: DUAL;
1713: RETURN (L_ADDRESS5);
1714: ELSIF IB_INSTALLED_AT_LOCATION = 'SOLD_TO' THEN
1715: SELECT
1716: LOC.CITY,

Line 1751: DUAL;

1747: ,NULL
1748: ,L_COUNTRY)
1749: INTO L_ADDRESS5
1750: FROM
1751: DUAL;
1752: RETURN (L_ADDRESS5);
1753: ELSIF IB_INSTALLED_AT_LOCATION = 'END_CUSTOMER' THEN
1754: SELECT
1755: LOC.CITY,

Line 1785: DUAL;

1781: ,NULL
1782: ,L_COUNTRY)
1783: INTO L_ADDRESS5
1784: FROM
1785: DUAL;
1786: RETURN (L_ADDRESS5);
1787: ELSE
1788: RETURN NULL;
1789: END IF;