DBA Data[Home] [Help]

APPS.PA_REVENUE dependencies on PA_CURRENCY

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

1434:
1435: BEGIN
1436:
1437: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1438: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1439: j.rate_currency_code,
1440: decode(j.discount_percentage,NULL,'O','T'),
1441: j.discount_percentage
1442: INTO l_bill_rate,l_raw_revenue,

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

1481: and l_discount_percentage is null and p_called_process = 'PA') THEN
1482:
1483: BEGIN
1484: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1485: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1486: j.rate_currency_code,
1487: decode(j.discount_percentage,NULL,'O','T'),
1488: j.discount_percentage
1489: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,

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

1525: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL
1526: and l_discount_percentage is null and p_called_process = 'PA') THEN
1527: BEGIN
1528: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1529: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1530: j.rate_currency_code,
1531: decode(j.discount_percentage,NULL,'O','P'),
1532: j.discount_percentage
1533: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,

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

1570: and l_discount_percentage is null ) THEN
1571:
1572: BEGIN
1573: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1574: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),
1575: j.rate_currency_code,
1576: decode(j.discount_percentage,NULL,'O','P'),
1577: j.discount_percentage
1578: INTO l_bill_rate,l_raw_revenue,

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

1618: and l_discount_percentage is null and (p_called_process = 'PA'/* or p_called_process='TASK_LEVEL_PLANNING'*/)) THEN
1619:
1620: BEGIN
1621: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1622: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),
1623: j.rate_currency_code,
1624: decode(j.discount_percentage,NULL,'O','J'),
1625: j.discount_percentage
1626: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,

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

1662: and l_discount_percentage is null and (/*p_called_process = 'PA' */ p_called_process='TASK_LEVEL_PLANNING')) THEN
1663:
1664: BEGIN
1665: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1666: PA_CURRENCY.ROUND_CURRENCY_AMT((j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity)),
1667: j.rate_currency_code,
1668: decode(j.discount_percentage,NULL,'O','J'),
1669: j.discount_percentage
1670: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,

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

1703: and l_discount_percentage is null and l_called_process = 0) THEN
1704:
1705: BEGIN
1706: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1707: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1708: j.rate_currency_code,
1709: decode(j.discount_percentage,NULL,'O','J'),
1710: j.discount_percentage
1711: INTO l_bill_rate,l_raw_revenue,

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

1741: and l_discount_percentage is null and l_called_process = 1) THEN /*Bug3737994 2 to 1*/
1742: /*Bug3737994 commented the code reference to per_assignments_f and added p_resource_job_id*/
1743: BEGIN
1744: SELECT j.rate * NVL(p_bill_rate_multiplier,1),
1745: PA_CURRENCY.ROUND_CURRENCY_AMT(j.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1746: j.rate_currency_code,
1747: decode(j.discount_percentage,NULL,'O','J'),
1748: j.discount_percentage
1749: INTO l_bill_rate,l_raw_revenue,

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

1990:
1991:
1992: BEGIN
1993: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_bill_rate_multiplier,1)),
1994: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1995: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1996: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) *
1997: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
1998: DECODE( nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,

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

1992: BEGIN
1993: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_bill_rate_multiplier,1)),
1994: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) * p_quantity),
1995: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1996: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) *
1997: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
1998: DECODE( nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1999: PA_CURRENCY.ROUND_CURRENCY_AMT((b.rate * p_quantity)
2000: * NVL(p_bill_rate_multiplier,1)

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

1995: DECODE(nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1996: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1) *
1997: (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) /100)),
1998: DECODE( nvl(l_discount_percentage,l_labor_schdl_discnt), NULL, NULL,
1999: PA_CURRENCY.ROUND_CURRENCY_AMT((b.rate * p_quantity)
2000: * NVL(p_bill_rate_multiplier,1)
2001: * (100 - nvl(l_discount_percentage,l_labor_schdl_discnt)) / 100)),
2002: DECODE(l_discount_percentage,NULL,'B','O'),
2003: nvl(l_discount_percentage,l_labor_schdl_discnt),

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

2044: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL AND (nvl(l_amount_calculation_code,'O') IN ('P','O')))
2045: THEN
2046: BEGIN
2047: SELECT DECODE(b.rate, NULL, NULL,b.rate * NVL(p_bill_rate_multiplier,1)),
2048: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)*
2049: p_quantity * (100 - (nvl(l_discount_percentage,nvl(l_labor_schdl_discnt,0))))/100),
2050: b.rate_currency_code,
2051: DECODE(l_discount_percentage,NULL,'B','O'),
2052: nvl(l_discount_percentage,l_labor_schdl_discnt)

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

2091: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL AND p_called_process is NULL ) THEN
2092: BEGIN
2093: SELECT DECODE(b.rate, NULL, NULL,
2094: b.rate * NVL(p_bill_rate_multiplier,1)),
2095: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
2096: * p_quantity * (100 - (nvl(l_discount_percentage,nvl(l_labor_schdl_discnt,0))))/100),
2097: b.rate_currency_code,
2098: DECODE(l_discount_percentage,NULL,'B','O'),
2099: nvl(l_discount_percentage,l_labor_schdl_discnt)

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

2134: (nvl(l_amount_calculation_code,'O') IN ('J','O')) ) THEN
2135: BEGIN
2136: SELECT DECODE(b.rate, NULL, NULL,
2137: b.rate * NVL(p_bill_rate_multiplier,1)),
2138: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
2139: * p_quantity * (100 - (nvl(l_discount_percentage,nvl(l_labor_schdl_discnt,0))))/100),
2140: b.rate_currency_code,
2141: DECODE(l_discount_percentage,NULL,'B','O'),
2142: nvl(l_discount_percentage,l_labor_schdl_discnt)

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

2175: (nvl(l_amount_calculation_code,'O') IN ('J','O')) ) THEN
2176: BEGIN
2177: SELECT DECODE(b.rate, NULL, NULL,
2178: b.rate * NVL(p_bill_rate_multiplier,1)),
2179: PA_CURRENCY.ROUND_CURRENCY_AMT(b.rate * NVL(p_bill_rate_multiplier,1)
2180: * p_quantity * (100 - (nvl(l_discount_percentage,nvl(l_labor_schdl_discnt,0))))/100),
2181: b.rate_currency_code,
2182: DECODE(l_discount_percentage,NULL,'B','O'),
2183: nvl(l_discount_percentage,l_labor_schdl_discnt)