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.

APPS.PA_FP_CALC_UTILS dependencies on STANDARD

Line 610: /* Bug fix:4232221 x_raw_cost_rate := NVL(blrec.etc_cost_rate,blrec.txn_standard_cost_rate); */

606: x_raw_cost_rate := NULL;
607: Elsif x_raw_cost_rate is NULL Then
608: If p_txn_currency_override is NULL Then
609: IF g_calling_module <> 'FORECAST_GENERATION' Then /* Bug fix:4211776 */
610: /* Bug fix:4232221 x_raw_cost_rate := NVL(blrec.etc_cost_rate,blrec.txn_standard_cost_rate); */
611: x_raw_cost_rate := p_bl_etc_cost_rate;
612: End If;
613: Elsif (p_txn_currency_override is NOT NULL ) Then
614: --print_msg('Cost rate is passed but override cur exists so null out this and keep override cost rate');

Line 672: /* Bug fix:4232221 x_bill_rate := NVL(blrec.etc_bill_rate,blrec.txn_standard_bill_rate);*/

668:
669: Elsif x_bill_rate is NULL Then
670: If p_txn_currency_override is NULL Then
671: IF g_calling_module <> 'FORECAST_GENERATION' Then /* Bug fix:4211776 */
672: /* Bug fix:4232221 x_bill_rate := NVL(blrec.etc_bill_rate,blrec.txn_standard_bill_rate);*/
673: x_bill_rate := p_bl_etc_bill_rate;
674: End If;
675: Elsif (p_txn_currency_override is NOT NULL ) Then
676: print_msg('Bill rate is passed but override cur exists so null out this rate');

Line 1443: ,AVG(NVL(blavgrt.txn_cost_rate_override,blavgrt.txn_standard_cost_rate))

1439: ,AVG(DECODE((nvl(blavgrt.quantity,0) - nvl(blavgrt.init_quantity,0)),0
1440: ,NULL,blavgrt.burden_cost_rate_override)) avg_burden_cost_rate_override
1441: ,AVG(DECODE((nvl(blavgrt.quantity,0) - nvl(blavgrt.init_quantity,0)),0
1442: ,NULL,blavgrt.txn_bill_rate_override)) avg_txn_bill_rate_override
1443: ,AVG(NVL(blavgrt.txn_cost_rate_override,blavgrt.txn_standard_cost_rate))
1444: ,AVG(NVL(blavgrt.burden_cost_rate_override,blavgrt.burden_cost_rate))
1445: ,AVG(NVL(blavgrt.txn_bill_rate_override,blavgrt.txn_standard_bill_rate))
1446: ,AVG(blavgrt.txn_markup_percent)
1447: FROM pa_budget_lines blavgrt

Line 1445: ,AVG(NVL(blavgrt.txn_bill_rate_override,blavgrt.txn_standard_bill_rate))

1441: ,AVG(DECODE((nvl(blavgrt.quantity,0) - nvl(blavgrt.init_quantity,0)),0
1442: ,NULL,blavgrt.txn_bill_rate_override)) avg_txn_bill_rate_override
1443: ,AVG(NVL(blavgrt.txn_cost_rate_override,blavgrt.txn_standard_cost_rate))
1444: ,AVG(NVL(blavgrt.burden_cost_rate_override,blavgrt.burden_cost_rate))
1445: ,AVG(NVL(blavgrt.txn_bill_rate_override,blavgrt.txn_standard_bill_rate))
1446: ,AVG(blavgrt.txn_markup_percent)
1447: FROM pa_budget_lines blavgrt
1448: WHERE blavgrt.budget_version_id = p_budget_version_id
1449: AND blavgrt.resource_assignment_id = tmp.resource_assignment_id

Line 1496: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

1492: ,decode(sum(bl.txn_init_raw_cost),0,NULL,sum(bl.txn_init_raw_cost)) --init_raw_cost
1493: ,decode(sum(bl.txn_init_burdened_cost),0,NULL,sum(bl.txn_init_burdened_cost)) --init_burdened_cost
1494: ,decode(sum(bl.txn_init_revenue),0,NULL,sum(bl.txn_init_revenue)) --init_revenue
1495: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1496: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1497: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1498: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1499: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1500: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))

Line 1497: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))

1493: ,decode(sum(bl.txn_init_burdened_cost),0,NULL,sum(bl.txn_init_burdened_cost)) --init_burdened_cost
1494: ,decode(sum(bl.txn_init_revenue),0,NULL,sum(bl.txn_init_revenue)) --init_revenue
1495: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1496: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1497: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1498: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1499: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1500: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1501: ,0,NULL,

Line 1499: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

1495: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1496: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1497: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1498: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1499: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1500: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1501: ,0,NULL,
1502: (sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1503: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

Line 1503: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

1499: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1500: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1501: ,0,NULL,
1502: (sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1503: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1504: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1505: )
1506: ) --etc_cost_rate
1507: ,(sum(decode(tmp.avg_cost_rate_override,NULL,NULL

Line 1509: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,NULL

1505: )
1506: ) --etc_cost_rate
1507: ,(sum(decode(tmp.avg_cost_rate_override,NULL,NULL
1508: ,decode((nvl(bl.quantity,0) - nvl(bl.init_quantity,0)),0,NULL
1509: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,NULL
1510: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1511: / DECODE((sum(decode(tmp.avg_cost_rate_override,NULL,NULL
1512: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1513: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

Line 1510: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))

1506: ) --etc_cost_rate
1507: ,(sum(decode(tmp.avg_cost_rate_override,NULL,NULL
1508: ,decode((nvl(bl.quantity,0) - nvl(bl.init_quantity,0)),0,NULL
1509: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,NULL
1510: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1511: / DECODE((sum(decode(tmp.avg_cost_rate_override,NULL,NULL
1512: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1513: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1514: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))

Line 1513: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

1509: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,NULL
1510: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1511: / DECODE((sum(decode(tmp.avg_cost_rate_override,NULL,NULL
1512: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1513: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1514: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1515: ,0,NULL,
1516: (sum(decode(tmp.avg_cost_rate_override,NULL,NULL
1517: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL

Line 1518: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null

1514: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1515: ,0,NULL,
1516: (sum(decode(tmp.avg_cost_rate_override,NULL,NULL
1517: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1518: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1519: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1520: )
1521: ) --etc_cost_rate_override
1522: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null

Line 1550: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

1546: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1547: )
1548: ) --etc_burden_rate_override
1549: ,(sum((decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1550: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1551: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1552: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1553: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1554: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))

Line 1551: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))

1547: )
1548: ) --etc_burden_rate_override
1549: ,(sum((decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1550: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1551: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1552: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1553: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1554: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1555: ,0,NULL,

Line 1553: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

1549: ,(sum((decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1550: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1551: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1552: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1553: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1554: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1555: ,0,NULL,
1556: (sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1557: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

Line 1557: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

1553: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1554: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1555: ,0,NULL,
1556: (sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1557: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1558: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1559: )
1560: ) --etc_bill_rate
1561: ,(sum(decode(tmp.avg_bill_rate_override,NULL,NULL

Line 1563: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,NULL

1559: )
1560: ) --etc_bill_rate
1561: ,(sum(decode(tmp.avg_bill_rate_override,NULL,NULL
1562: , decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1563: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,NULL
1564: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1565: / DECODE((sum(decode(tmp.avg_bill_rate_override,NULL,NULL
1566: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1567: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

Line 1564: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))

1560: ) --etc_bill_rate
1561: ,(sum(decode(tmp.avg_bill_rate_override,NULL,NULL
1562: , decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1563: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,NULL
1564: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1565: / DECODE((sum(decode(tmp.avg_bill_rate_override,NULL,NULL
1566: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1567: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1568: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))

Line 1567: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

1563: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,NULL
1564: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1565: / DECODE((sum(decode(tmp.avg_bill_rate_override,NULL,NULL
1566: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1567: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1568: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1569: ,0,NULL,
1570: (sum(decode(tmp.avg_bill_rate_override,NULL,NULL
1571: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL

Line 1572: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null

1568: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1569: ,0,NULL,
1570: (sum(decode(tmp.avg_bill_rate_override,NULL,NULL
1571: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1572: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1573: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1574: )
1575: ) --etc_bill_rate_override
1576: /* Bug fix:4693839 Currently all the UI page shows null instead of zeros, and when they pass to param value

Line 4382: ,bl.txn_standard_cost_rate

4378: ,bl.end_date
4379: ,bl.period_name
4380: ,bl.budget_version_id
4381: ,bl.quantity bl_quantity
4382: ,bl.txn_standard_cost_rate
4383: ,bl.txn_cost_rate_override
4384: ,bl.txn_raw_cost
4385: ,bl.burden_cost_rate
4386: ,bl.burden_cost_rate_override

Line 4388: ,bl.txn_standard_bill_rate

4384: ,bl.txn_raw_cost
4385: ,bl.burden_cost_rate
4386: ,bl.burden_cost_rate_override
4387: ,bl.txn_burdened_cost
4388: ,bl.txn_standard_bill_rate
4389: ,bl.txn_bill_rate_override
4390: ,bl.txn_revenue
4391: ,bl.project_currency_code
4392: ,bl.project_raw_cost

Line 4697: ,bl.txn_standard_cost_rate

4693: ,bl.end_date
4694: ,bl.period_name
4695: ,bl.budget_version_id
4696: ,bl.quantity bl_quantity
4697: ,bl.txn_standard_cost_rate
4698: ,bl.txn_cost_rate_override
4699: ,bl.txn_raw_cost
4700: ,bl.burden_cost_rate
4701: ,bl.burden_cost_rate_override

Line 4703: ,bl.txn_standard_bill_rate

4699: ,bl.txn_raw_cost
4700: ,bl.burden_cost_rate
4701: ,bl.burden_cost_rate_override
4702: ,bl.txn_burdened_cost
4703: ,bl.txn_standard_bill_rate
4704: ,bl.txn_bill_rate_override
4705: ,bl.txn_revenue
4706: ,bl.project_currency_code
4707: ,bl.project_raw_cost

Line 4891: ,bl.txn_standard_cost_rate

4887: ,bl.end_date
4888: ,bl.period_name
4889: ,bl.budget_version_id
4890: ,bl.quantity bl_quantity
4891: ,bl.txn_standard_cost_rate
4892: ,bl.txn_cost_rate_override
4893: ,bl.txn_raw_cost
4894: ,bl.burden_cost_rate
4895: ,bl.burden_cost_rate_override

Line 4897: ,bl.txn_standard_bill_rate

4893: ,bl.txn_raw_cost
4894: ,bl.burden_cost_rate
4895: ,bl.burden_cost_rate_override
4896: ,bl.txn_burdened_cost
4897: ,bl.txn_standard_bill_rate
4898: ,bl.txn_bill_rate_override
4899: ,bl.txn_revenue
4900: ,bl.project_currency_code
4901: ,bl.project_raw_cost

Line 5002: nvl(i.txn_cost_rate_override,i.txn_standard_cost_rate)) +nvl(i.txn_init_raw_cost,0)),i.txn_currency_code);

4998: l_period_name_tab(l_rwCounter) := i.period_name;
4999: l_quantity_tab(l_rwCounter) := nvl(i.fp_quantity,0);
5000: IF p_budget_version_type in ('ALL','COST') Then
5001: l_txn_raw_cost_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*
5002: nvl(i.txn_cost_rate_override,i.txn_standard_cost_rate)) +nvl(i.txn_init_raw_cost,0)),i.txn_currency_code);
5003: l_txn_burden_cost_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*
5004: nvl(i.burden_cost_rate_override,i.burden_cost_rate)) + nvl(i.txn_init_burdened_cost,0)),i.txn_currency_code);
5005: ELSE
5006: l_txn_raw_cost_tab(l_rwCounter) := NULL;

Line 5011: nvl(i.txn_bill_rate_override,i.txn_standard_bill_rate)) +nvl(i.txn_init_revenue,0)),i.txn_currency_code);

5007: l_txn_burden_cost_tab(l_rwCounter) := NULL;
5008: END IF;
5009: IF p_budget_version_type in ('ALL','REVENUE') Then
5010: l_txn_revenue_tab(l_rwCounter) := pa_currency.round_trans_currency_amt1((((nvl(i.bl_quantity,0)-nvl(i.bl_init_quantity,0) + nvl(i.fp_quantity,0))*
5011: nvl(i.txn_bill_rate_override,i.txn_standard_bill_rate)) +nvl(i.txn_init_revenue,0)),i.txn_currency_code);
5012: Else
5013: l_txn_revenue_tab(l_rwCounter) := NULL;
5014: End If;
5015:

Line 7197: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate

7193: ,bl.QUANTITY --total_qty
7194: ,bl.TXN_RAW_COST --total_raw_cost
7195: ,bl.TXN_BURDENED_COST --total_burdened_cost
7196: ,bl.TXN_REVENUE --total_revenue
7197: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate
7198: ,bl.TXN_COST_RATE_OVERRIDE --rw_cost_rate_override
7199: ,bl.BURDEN_COST_RATE --b_cost_rate
7200: ,bl.BURDEN_COST_RATE_OVERRIDE --b_cost_rate_override
7201: ,bl.TXN_STANDARD_BILL_RATE --bill_rate

Line 7201: ,bl.TXN_STANDARD_BILL_RATE --bill_rate

7197: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate
7198: ,bl.TXN_COST_RATE_OVERRIDE --rw_cost_rate_override
7199: ,bl.BURDEN_COST_RATE --b_cost_rate
7200: ,bl.BURDEN_COST_RATE_OVERRIDE --b_cost_rate_override
7201: ,bl.TXN_STANDARD_BILL_RATE --bill_rate
7202: ,bl.TXN_BILL_RATE_OVERRIDE --bill_rate_override
7203: ,bl.START_DATE --line_start_date
7204: ,bl.END_DATE --line_end_date
7205: ,bl.PERIOD_NAME

Line 8817: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))))),0,NULL,

8813: ,SUM(txn_revenue) rounded_txn_revenue
8814: ,SUM(txn_init_revenue)
8815: ,SUM(decode((nvl(bl.txn_init_raw_cost,0) + (
8816: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8817: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))))),0,NULL,
8818: (nvl(bl.txn_init_raw_cost,0) + (
8819: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8820: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))))) )) unrounded_txn_raw_cost
8821: ,SUM(decode((nvl(bl.txn_init_burdened_cost,0) + (

Line 8820: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))))) )) unrounded_txn_raw_cost

8816: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8817: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))))),0,NULL,
8818: (nvl(bl.txn_init_raw_cost,0) + (
8819: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8820: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))))) )) unrounded_txn_raw_cost
8821: ,SUM(decode((nvl(bl.txn_init_burdened_cost,0) + (
8822: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8823: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))))),0,NULL,
8824: (nvl(bl.txn_init_burdened_cost,0) + (

Line 8829: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))))),0,NULL,

8825: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8826: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))))))) unrounded_txn_burdened_cost
8827: ,SUM(decode((nvl(bl.txn_init_raw_cost,0) + (
8828: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8829: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))))),0,NULL,
8830: (nvl(bl.txn_init_raw_cost,0) + (
8831: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8832: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))))))) unrounded_txn_revenue
8833: ,to_number(NULL) diff_raw_cost

Line 8832: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))))))) unrounded_txn_revenue

8828: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8829: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))))),0,NULL,
8830: (nvl(bl.txn_init_raw_cost,0) + (
8831: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
8832: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))))))) unrounded_txn_revenue
8833: ,to_number(NULL) diff_raw_cost
8834: ,to_number(NULL) diff_burden_cost
8835: ,to_number(NULL) diff_revenue
8836: FROM pa_budget_lines bl

Line 9120: ,bl.txn_standard_cost_rate

9116: ,bl.resource_assignment_id
9117: ,bl.txn_currency_code
9118: ,bl.start_date
9119: ,bl.quantity
9120: ,bl.txn_standard_cost_rate
9121: ,bl.txn_cost_rate_override
9122: ,bl.burden_cost_rate
9123: ,bl.burden_cost_rate_override
9124: ,bl.cost_ind_compiled_set_id

Line 9125: ,bl.txn_standard_bill_rate

9121: ,bl.txn_cost_rate_override
9122: ,bl.burden_cost_rate
9123: ,bl.burden_cost_rate_override
9124: ,bl.cost_ind_compiled_set_id
9125: ,bl.txn_standard_bill_rate
9126: ,bl.txn_bill_rate_override
9127: ,bl.txn_markup_percent
9128: ,bl.cost_rejection_code
9129: ,bl.revenue_rejection_code

Line 9396: ,bl.txn_standard_bill_rate = l_bl_bill_rate_tab(i)

9392: ,bl.txn_raw_cost = l_bl_txn_raw_cost_tab(i)
9393: ,bl.txn_burdened_cost = l_bl_txn_burdened_cost_tab(i)
9394: ,bl.txn_revenue = l_bl_txn_revenue_tab(i)
9395: ,bl.txn_markup_percent = l_bl_markup_percentage_tab(i)
9396: ,bl.txn_standard_bill_rate = l_bl_bill_rate_tab(i)
9397: ,bl.txn_standard_cost_rate = l_bl_cost_rate_tab(i)
9398: ,bl.txn_cost_rate_override = l_bl_cost_rate_override_tab(i)
9399: ,bl.burden_cost_rate = l_bl_burden_cost_rate_tab(i)
9400: ,bl.txn_bill_rate_override = l_bl_bill_rate_override_tab(i)

Line 9397: ,bl.txn_standard_cost_rate = l_bl_cost_rate_tab(i)

9393: ,bl.txn_burdened_cost = l_bl_txn_burdened_cost_tab(i)
9394: ,bl.txn_revenue = l_bl_txn_revenue_tab(i)
9395: ,bl.txn_markup_percent = l_bl_markup_percentage_tab(i)
9396: ,bl.txn_standard_bill_rate = l_bl_bill_rate_tab(i)
9397: ,bl.txn_standard_cost_rate = l_bl_cost_rate_tab(i)
9398: ,bl.txn_cost_rate_override = l_bl_cost_rate_override_tab(i)
9399: ,bl.burden_cost_rate = l_bl_burden_cost_rate_tab(i)
9400: ,bl.txn_bill_rate_override = l_bl_bill_rate_override_tab(i)
9401: ,bl.burden_cost_rate_override = l_bl_burden_rate_override_tab(i)

Line 9840: ,bl.txn_standard_bill_rate = l_tmp2_bill_rate_tab(i)

9836: ,bl.burden_rejection_code = l_tmp2_burden_rejection_tab(i)
9837: ,bl.pfc_cur_conv_rejection_code = l_tmp2_pfc_cur_rejection_tab(i)
9838: ,bl.pc_cur_conv_rejection_code = l_tmp2_pc_cur_rejection_tab(i)
9839: ,bl.txn_markup_percent = l_tmp2_markup_percent_tab(i)
9840: ,bl.txn_standard_bill_rate = l_tmp2_bill_rate_tab(i)
9841: ,bl.txn_standard_cost_rate = l_tmp2_cost_rate_tab(i)
9842: ,bl.burden_cost_rate = l_tmp2_burden_rate_tab(i)
9843: ,bl.txn_bill_rate_override = l_tmp2_bill_rate_ovr_tab(i)
9844: ,bl.txn_cost_rate_override = l_tmp2_cost_rate_ovr_tab(i)

Line 9841: ,bl.txn_standard_cost_rate = l_tmp2_cost_rate_tab(i)

9837: ,bl.pfc_cur_conv_rejection_code = l_tmp2_pfc_cur_rejection_tab(i)
9838: ,bl.pc_cur_conv_rejection_code = l_tmp2_pc_cur_rejection_tab(i)
9839: ,bl.txn_markup_percent = l_tmp2_markup_percent_tab(i)
9840: ,bl.txn_standard_bill_rate = l_tmp2_bill_rate_tab(i)
9841: ,bl.txn_standard_cost_rate = l_tmp2_cost_rate_tab(i)
9842: ,bl.burden_cost_rate = l_tmp2_burden_rate_tab(i)
9843: ,bl.txn_bill_rate_override = l_tmp2_bill_rate_ovr_tab(i)
9844: ,bl.txn_cost_rate_override = l_tmp2_cost_rate_ovr_tab(i)
9845: ,bl.burden_cost_rate_override = l_tmp2_burden_rate_ovr_tab(i)

Line 9857: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,

9853: FORALL i IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST
9854: UPDATE pa_budget_lines bl
9855: SET bl.txn_raw_cost = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9856: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9857: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9858: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9859: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9860: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9861: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(

Line 9860: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))

9856: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9857: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9858: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9859: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9860: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9861: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9862: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9863: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9864: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(

Line 9869: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,

9865: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9866: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)))
9867: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9868: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9869: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,
9870: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9871: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9872: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)))
9873: WHERE bl.budget_line_id = l_tmp2_budget_line_id_tab(i);

Line 9872: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)))

9868: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9869: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,
9870: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9871: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9872: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)))
9873: WHERE bl.budget_line_id = l_tmp2_budget_line_id_tab(i);
9874:
9875: /* Call This API to round off the rounding difference for the last budget line in pa_budget_lines
9876: * when a new currency line is added to the already existing resource assignment.

Line 10185: ,bl.txn_standard_bill_rate

10181: ,bl.project_raw_cost
10182: ,bl.project_burdened_cost
10183: ,bl.project_revenue
10184: ,bl.txn_markup_percent
10185: ,bl.txn_standard_bill_rate
10186: ,bl.txn_standard_cost_rate
10187: ,bl.burden_cost_rate
10188: ,bl.cost_ind_compiled_set_id
10189: ,bl.init_raw_cost

Line 10186: ,bl.txn_standard_cost_rate

10182: ,bl.project_burdened_cost
10183: ,bl.project_revenue
10184: ,bl.txn_markup_percent
10185: ,bl.txn_standard_bill_rate
10186: ,bl.txn_standard_cost_rate
10187: ,bl.burden_cost_rate
10188: ,bl.cost_ind_compiled_set_id
10189: ,bl.init_raw_cost
10190: ,bl.init_burdened_cost

Line 10937: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate

10933: ,bl.QUANTITY --total_qty
10934: ,bl.TXN_RAW_COST --total_raw_cost
10935: ,bl.TXN_BURDENED_COST --total_burdened_cost
10936: ,bl.TXN_REVENUE --total_revenue
10937: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate
10938: ,bl.TXN_COST_RATE_OVERRIDE --rw_cost_rate_override
10939: ,bl.BURDEN_COST_RATE --b_cost_rate
10940: ,bl.BURDEN_COST_RATE_OVERRIDE --b_cost_rate_override
10941: ,bl.TXN_STANDARD_BILL_RATE --bill_rate

Line 10941: ,bl.TXN_STANDARD_BILL_RATE --bill_rate

10937: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate
10938: ,bl.TXN_COST_RATE_OVERRIDE --rw_cost_rate_override
10939: ,bl.BURDEN_COST_RATE --b_cost_rate
10940: ,bl.BURDEN_COST_RATE_OVERRIDE --b_cost_rate_override
10941: ,bl.TXN_STANDARD_BILL_RATE --bill_rate
10942: ,bl.TXN_BILL_RATE_OVERRIDE --bill_rate_override
10943: ,bl.START_DATE --line_start_date
10944: ,bl.END_DATE --line_end_date
10945: ,bl.PERIOD_NAME