DBA Data[Home] [Help]

APPS.PA_REVENUE dependencies on PA_CURRENCY

Line 1457: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),

1453:
1454: BEGIN
1455:
1456: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1457: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1458: j.rate_currency_code,
1459: decode(j.discount_percentage,NULL,'O','T'),
1460: j.discount_percentage
1461: INTO l_bill_rate,l_raw_revenue,

Line 1504: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),

1500: and l_discount_percentage is null and p_called_process = 'PA') THEN
1501:
1502: BEGIN
1503: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1504: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1505: j.rate_currency_code,
1506: decode(j.discount_percentage,NULL,'O','T'),
1507: j.discount_percentage
1508: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,

Line 1548: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),

1544: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL
1545: and l_discount_percentage is null and p_called_process = 'PA') THEN
1546: BEGIN
1547: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1548: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1549: j.rate_currency_code,
1550: decode(j.discount_percentage,NULL,'O','P'),
1551: j.discount_percentage
1552: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,

Line 1593: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),

1589: and l_discount_percentage is null ) THEN
1590:
1591: BEGIN
1592: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1593: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),
1594: j.rate_currency_code,
1595: decode(j.discount_percentage,NULL,'O','P'),
1596: j.discount_percentage
1597: INTO l_bill_rate,l_raw_revenue,

Line 1641: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),

1637: and l_discount_percentage is null and (p_called_process = 'PA'/* or p_called_process='TASK_LEVEL_PLANNING'*/)) THEN
1638:
1639: BEGIN
1640: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1641: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),
1642: j.rate_currency_code,
1643: decode(j.discount_percentage,NULL,'O','J'),
1644: j.discount_percentage
1645: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,

Line 1685: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),

1681: and l_discount_percentage is null and (/*p_called_process = 'PA' */ p_called_process='TASK_LEVEL_PLANNING')) THEN
1682:
1683: BEGIN
1684: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1685: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),
1686: j.rate_currency_code,
1687: decode(j.discount_percentage,NULL,'O','J'),
1688: j.discount_percentage
1689: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,

Line 1726: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),

1722: and l_discount_percentage is null and l_called_process = 0) THEN
1723:
1724: BEGIN
1725: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1726: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1727: j.rate_currency_code,
1728: decode(j.discount_percentage,NULL,'O','J'),
1729: j.discount_percentage
1730: INTO l_bill_rate,l_raw_revenue,

Line 1764: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),

1760: and l_discount_percentage is null and l_called_process = 1) THEN /*Bug3737994 2 to 1*/
1761: /*Bug3737994 commented the code reference to per_assignments_f and added p_resource_job_id*/
1762: BEGIN
1763: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1764: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1765: j.rate_currency_code,
1766: decode(j.discount_percentage,NULL,'O','J'),
1767: j.discount_percentage
1768: INTO l_bill_rate,l_raw_revenue,

Line 2013: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),

2009:
2010:
2011: BEGIN
2012: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_bill_rate_multiplier,1)),
2013: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
2014: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
2015: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) *
2016: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
2017: DECODE( nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,

Line 2015: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) *

2011: BEGIN
2012: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_bill_rate_multiplier,1)),
2013: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
2014: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
2015: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) *
2016: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
2017: DECODE( nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
2018: PA_CURRENCY.ROUND_CURRENCY_AMT((b.rate * p_quantity)
2019: * NVL(p_bill_rate_multiplier,1)

Line 2018: PA_CURRENCY.ROUND_CURRENCY_AMT((b.rate * p_quantity)

2014: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
2015: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) *
2016: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
2017: DECODE( nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
2018: PA_CURRENCY.ROUND_CURRENCY_AMT((b.rate * p_quantity)
2019: * NVL(p_bill_rate_multiplier,1)
2020: * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100)),
2021: DECODE(l_discount_percentage,NULL,'B','O'),
2022: nvl(l_discount_percentage,l_labor_schdl_discnt),

Line 2067: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)*

2063: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL AND (nvl(l_amount_calculation_code,'O') IN ('P','O')))
2064: THEN
2065: BEGIN
2066: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_bill_rate_multiplier,1)),
2067: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)*
2068: p_quantity * (100 - (nvl(l_discount_percentage,nvl(l_labor_schdl_discnt,0))))/100),
2069: b.rate_currency_code,
2070: DECODE(l_discount_percentage,NULL,'B','O'),
2071: nvl(l_discount_percentage,l_labor_schdl_discnt)

Line 2114: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

2110: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL AND p_called_process is NULL ) THEN
2111: BEGIN
2112: SELECT DECODE(b.rate, NULL, NULL,
2113: b.rate * NVL(p_bill_rate_multiplier,1)),
2114: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
2115: * p_quantity * (100 - (nvl(l_discount_percentage,nvl(l_labor_schdl_discnt,0))))/100),
2116: b.rate_currency_code,
2117: DECODE(l_discount_percentage,NULL,'B','O'),
2118: nvl(l_discount_percentage,l_labor_schdl_discnt)

Line 2157: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

2153: (nvl(l_amount_calculation_code,'O') IN ('J','O')) ) THEN
2154: BEGIN
2155: SELECT DECODE(b.rate, NULL, NULL,
2156: b.rate * NVL(p_bill_rate_multiplier,1)),
2157: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
2158: * p_quantity * (100 - (nvl(l_discount_percentage,nvl(l_labor_schdl_discnt,0))))/100),
2159: b.rate_currency_code,
2160: DECODE(l_discount_percentage,NULL,'B','O'),
2161: nvl(l_discount_percentage,l_labor_schdl_discnt)

Line 2199: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)

2195: (nvl(l_amount_calculation_code,'O') IN ('J','O')) ) THEN
2196: BEGIN
2197: SELECT DECODE(b.rate, NULL, NULL,
2198: b.rate * NVL(p_bill_rate_multiplier,1)),
2199: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
2200: * p_quantity * (100 - (nvl(l_discount_percentage,nvl(l_labor_schdl_discnt,0))))/100),
2201: b.rate_currency_code,
2202: DECODE(l_discount_percentage,NULL,'B','O'),
2203: nvl(l_discount_percentage,l_labor_schdl_discnt)