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 603: /* Bug fix:4232221 x_raw_cost_rate := NVL(blrec.etc_cost_rate,blrec.txn_standard_cost_rate); */

599: x_raw_cost_rate := NULL;
600: Elsif x_raw_cost_rate is NULL Then
601: If p_txn_currency_override is NULL Then
602: IF g_calling_module <> 'FORECAST_GENERATION' Then /* Bug fix:4211776 */
603: /* Bug fix:4232221 x_raw_cost_rate := NVL(blrec.etc_cost_rate,blrec.txn_standard_cost_rate); */
604: x_raw_cost_rate := p_bl_etc_cost_rate;
605: End If;
606: Elsif (p_txn_currency_override is NOT NULL ) Then
607: --print_msg('Cost rate is passed but override cur exists so null out this and keep override cost rate');

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

661:
662: Elsif x_bill_rate is NULL Then
663: If p_txn_currency_override is NULL Then
664: IF g_calling_module <> 'FORECAST_GENERATION' Then /* Bug fix:4211776 */
665: /* Bug fix:4232221 x_bill_rate := NVL(blrec.etc_bill_rate,blrec.txn_standard_bill_rate);*/
666: x_bill_rate := p_bl_etc_bill_rate;
667: End If;
668: Elsif (p_txn_currency_override is NOT NULL ) Then
669: print_msg('Bill rate is passed but override cur exists so null out this rate');

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

1432: ,AVG(DECODE((nvl(blavgrt.quantity,0) - nvl(blavgrt.init_quantity,0)),0
1433: ,NULL,blavgrt.burden_cost_rate_override)) avg_burden_cost_rate_override
1434: ,AVG(DECODE((nvl(blavgrt.quantity,0) - nvl(blavgrt.init_quantity,0)),0
1435: ,NULL,blavgrt.txn_bill_rate_override)) avg_txn_bill_rate_override
1436: ,AVG(NVL(blavgrt.txn_cost_rate_override,blavgrt.txn_standard_cost_rate))
1437: ,AVG(NVL(blavgrt.burden_cost_rate_override,blavgrt.burden_cost_rate))
1438: ,AVG(NVL(blavgrt.txn_bill_rate_override,blavgrt.txn_standard_bill_rate))
1439: ,AVG(blavgrt.txn_markup_percent)
1440: FROM pa_budget_lines blavgrt

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

1434: ,AVG(DECODE((nvl(blavgrt.quantity,0) - nvl(blavgrt.init_quantity,0)),0
1435: ,NULL,blavgrt.txn_bill_rate_override)) avg_txn_bill_rate_override
1436: ,AVG(NVL(blavgrt.txn_cost_rate_override,blavgrt.txn_standard_cost_rate))
1437: ,AVG(NVL(blavgrt.burden_cost_rate_override,blavgrt.burden_cost_rate))
1438: ,AVG(NVL(blavgrt.txn_bill_rate_override,blavgrt.txn_standard_bill_rate))
1439: ,AVG(blavgrt.txn_markup_percent)
1440: FROM pa_budget_lines blavgrt
1441: WHERE blavgrt.budget_version_id = p_budget_version_id
1442: AND blavgrt.resource_assignment_id = tmp.resource_assignment_id

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

1485: ,decode(sum(bl.txn_init_raw_cost),0,NULL,sum(bl.txn_init_raw_cost)) --init_raw_cost
1486: ,decode(sum(bl.txn_init_burdened_cost),0,NULL,sum(bl.txn_init_burdened_cost)) --init_burdened_cost
1487: ,decode(sum(bl.txn_init_revenue),0,NULL,sum(bl.txn_init_revenue)) --init_revenue
1488: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1489: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1490: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1491: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1492: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1493: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))

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

1486: ,decode(sum(bl.txn_init_burdened_cost),0,NULL,sum(bl.txn_init_burdened_cost)) --init_burdened_cost
1487: ,decode(sum(bl.txn_init_revenue),0,NULL,sum(bl.txn_init_revenue)) --init_revenue
1488: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1489: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1490: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1491: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1492: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1493: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1494: ,0,NULL,

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

1488: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1489: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1490: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))))))
1491: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1492: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1493: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1494: ,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

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

1492: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1493: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1494: ,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))))))
1498: )
1499: ) --etc_cost_rate
1500: ,(sum(decode(tmp.avg_cost_rate_override,NULL,NULL

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

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

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

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

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

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

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

1507: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1508: ,0,NULL,
1509: (sum(decode(tmp.avg_cost_rate_override,NULL,NULL
1510: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1511: ,decode(nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)),0,null
1512: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1513: )
1514: ) --etc_cost_rate_override
1515: ,(sum(( decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null

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

1539: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1540: )
1541: ) --etc_burden_rate_override
1542: ,(sum((decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1543: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1544: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1545: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1546: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1547: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))

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

1540: )
1541: ) --etc_burden_rate_override
1542: ,(sum((decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1543: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1544: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1545: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1546: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1547: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1548: ,0,NULL,

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

1542: ,(sum((decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1543: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1544: ,((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)) * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))))))
1545: / DECODE((sum(decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,null
1546: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1547: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1548: ,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

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

1546: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1547: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0))))))
1548: ,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))))))
1552: )
1553: ) --etc_bill_rate
1554: ,(sum(decode(tmp.avg_bill_rate_override,NULL,NULL

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

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

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

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

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

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

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

1561: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1562: ,0,NULL,
1563: (sum(decode(tmp.avg_bill_rate_override,NULL,NULL
1564: ,decode((nvl(bl.quantity,0)- nvl(bl.init_quantity,0)),0,NULL
1565: ,decode(nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)),0,null
1566: ,(nvl(bl.quantity,0)- nvl(bl.init_quantity,0)))))))
1567: )
1568: ) --etc_bill_rate_override
1569: /* Bug fix:4693839 Currently all the UI page shows null instead of zeros, and when they pass to param value

Line 4353: ,bl.txn_standard_cost_rate

4349: ,bl.end_date
4350: ,bl.period_name
4351: ,bl.budget_version_id
4352: ,bl.quantity bl_quantity
4353: ,bl.txn_standard_cost_rate
4354: ,bl.txn_cost_rate_override
4355: ,bl.txn_raw_cost
4356: ,bl.burden_cost_rate
4357: ,bl.burden_cost_rate_override

Line 4359: ,bl.txn_standard_bill_rate

4355: ,bl.txn_raw_cost
4356: ,bl.burden_cost_rate
4357: ,bl.burden_cost_rate_override
4358: ,bl.txn_burdened_cost
4359: ,bl.txn_standard_bill_rate
4360: ,bl.txn_bill_rate_override
4361: ,bl.txn_revenue
4362: ,bl.project_currency_code
4363: ,bl.project_raw_cost

Line 4668: ,bl.txn_standard_cost_rate

4664: ,bl.end_date
4665: ,bl.period_name
4666: ,bl.budget_version_id
4667: ,bl.quantity bl_quantity
4668: ,bl.txn_standard_cost_rate
4669: ,bl.txn_cost_rate_override
4670: ,bl.txn_raw_cost
4671: ,bl.burden_cost_rate
4672: ,bl.burden_cost_rate_override

Line 4674: ,bl.txn_standard_bill_rate

4670: ,bl.txn_raw_cost
4671: ,bl.burden_cost_rate
4672: ,bl.burden_cost_rate_override
4673: ,bl.txn_burdened_cost
4674: ,bl.txn_standard_bill_rate
4675: ,bl.txn_bill_rate_override
4676: ,bl.txn_revenue
4677: ,bl.project_currency_code
4678: ,bl.project_raw_cost

Line 4862: ,bl.txn_standard_cost_rate

4858: ,bl.end_date
4859: ,bl.period_name
4860: ,bl.budget_version_id
4861: ,bl.quantity bl_quantity
4862: ,bl.txn_standard_cost_rate
4863: ,bl.txn_cost_rate_override
4864: ,bl.txn_raw_cost
4865: ,bl.burden_cost_rate
4866: ,bl.burden_cost_rate_override

Line 4868: ,bl.txn_standard_bill_rate

4864: ,bl.txn_raw_cost
4865: ,bl.burden_cost_rate
4866: ,bl.burden_cost_rate_override
4867: ,bl.txn_burdened_cost
4868: ,bl.txn_standard_bill_rate
4869: ,bl.txn_bill_rate_override
4870: ,bl.txn_revenue
4871: ,bl.project_currency_code
4872: ,bl.project_raw_cost

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

4969: l_period_name_tab(l_rwCounter) := i.period_name;
4970: l_quantity_tab(l_rwCounter) := nvl(i.fp_quantity,0);
4971: IF p_budget_version_type in ('ALL','COST') Then
4972: 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))*
4973: nvl(i.txn_cost_rate_override,i.txn_standard_cost_rate)) +nvl(i.txn_init_raw_cost,0)),i.txn_currency_code);
4974: 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))*
4975: nvl(i.burden_cost_rate_override,i.burden_cost_rate)) + nvl(i.txn_init_burdened_cost,0)),i.txn_currency_code);
4976: ELSE
4977: l_txn_raw_cost_tab(l_rwCounter) := NULL;

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

4978: l_txn_burden_cost_tab(l_rwCounter) := NULL;
4979: END IF;
4980: IF p_budget_version_type in ('ALL','REVENUE') Then
4981: 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))*
4982: nvl(i.txn_bill_rate_override,i.txn_standard_bill_rate)) +nvl(i.txn_init_revenue,0)),i.txn_currency_code);
4983: Else
4984: l_txn_revenue_tab(l_rwCounter) := NULL;
4985: End If;
4986:

Line 7166: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate

7162: ,bl.QUANTITY --total_qty
7163: ,bl.TXN_RAW_COST --total_raw_cost
7164: ,bl.TXN_BURDENED_COST --total_burdened_cost
7165: ,bl.TXN_REVENUE --total_revenue
7166: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate
7167: ,bl.TXN_COST_RATE_OVERRIDE --rw_cost_rate_override
7168: ,bl.BURDEN_COST_RATE --b_cost_rate
7169: ,bl.BURDEN_COST_RATE_OVERRIDE --b_cost_rate_override
7170: ,bl.TXN_STANDARD_BILL_RATE --bill_rate

Line 7170: ,bl.TXN_STANDARD_BILL_RATE --bill_rate

7166: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate
7167: ,bl.TXN_COST_RATE_OVERRIDE --rw_cost_rate_override
7168: ,bl.BURDEN_COST_RATE --b_cost_rate
7169: ,bl.BURDEN_COST_RATE_OVERRIDE --b_cost_rate_override
7170: ,bl.TXN_STANDARD_BILL_RATE --bill_rate
7171: ,bl.TXN_BILL_RATE_OVERRIDE --bill_rate_override
7172: ,bl.START_DATE --line_start_date
7173: ,bl.END_DATE --line_end_date
7174: ,bl.PERIOD_NAME

Line 8888: ,bl.txn_standard_cost_rate

8884: ,bl.resource_assignment_id
8885: ,bl.txn_currency_code
8886: ,bl.start_date
8887: ,bl.quantity
8888: ,bl.txn_standard_cost_rate
8889: ,bl.txn_cost_rate_override
8890: ,bl.burden_cost_rate
8891: ,bl.burden_cost_rate_override
8892: ,bl.cost_ind_compiled_set_id

Line 8893: ,bl.txn_standard_bill_rate

8889: ,bl.txn_cost_rate_override
8890: ,bl.burden_cost_rate
8891: ,bl.burden_cost_rate_override
8892: ,bl.cost_ind_compiled_set_id
8893: ,bl.txn_standard_bill_rate
8894: ,bl.txn_bill_rate_override
8895: ,bl.txn_markup_percent
8896: ,bl.cost_rejection_code
8897: ,bl.revenue_rejection_code

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

9158: ,bl.txn_raw_cost = l_bl_txn_raw_cost_tab(i)
9159: ,bl.txn_burdened_cost = l_bl_txn_burdened_cost_tab(i)
9160: ,bl.txn_revenue = l_bl_txn_revenue_tab(i)
9161: ,bl.txn_markup_percent = l_bl_markup_percentage_tab(i)
9162: ,bl.txn_standard_bill_rate = l_bl_bill_rate_tab(i)
9163: ,bl.txn_standard_cost_rate = l_bl_cost_rate_tab(i)
9164: ,bl.txn_cost_rate_override = l_bl_cost_rate_override_tab(i)
9165: ,bl.burden_cost_rate = l_bl_burden_cost_rate_tab(i)
9166: ,bl.txn_bill_rate_override = l_bl_bill_rate_override_tab(i)

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

9159: ,bl.txn_burdened_cost = l_bl_txn_burdened_cost_tab(i)
9160: ,bl.txn_revenue = l_bl_txn_revenue_tab(i)
9161: ,bl.txn_markup_percent = l_bl_markup_percentage_tab(i)
9162: ,bl.txn_standard_bill_rate = l_bl_bill_rate_tab(i)
9163: ,bl.txn_standard_cost_rate = l_bl_cost_rate_tab(i)
9164: ,bl.txn_cost_rate_override = l_bl_cost_rate_override_tab(i)
9165: ,bl.burden_cost_rate = l_bl_burden_cost_rate_tab(i)
9166: ,bl.txn_bill_rate_override = l_bl_bill_rate_override_tab(i)
9167: ,bl.burden_cost_rate_override = l_bl_burden_rate_override_tab(i)

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

9602: ,bl.burden_rejection_code = l_tmp2_burden_rejection_tab(i)
9603: ,bl.pfc_cur_conv_rejection_code = l_tmp2_pfc_cur_rejection_tab(i)
9604: ,bl.pc_cur_conv_rejection_code = l_tmp2_pc_cur_rejection_tab(i)
9605: ,bl.txn_markup_percent = l_tmp2_markup_percent_tab(i)
9606: ,bl.txn_standard_bill_rate = l_tmp2_bill_rate_tab(i)
9607: ,bl.txn_standard_cost_rate = l_tmp2_cost_rate_tab(i)
9608: ,bl.burden_cost_rate = l_tmp2_burden_rate_tab(i)
9609: ,bl.txn_bill_rate_override = l_tmp2_bill_rate_ovr_tab(i)
9610: ,bl.txn_cost_rate_override = l_tmp2_cost_rate_ovr_tab(i)

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

9603: ,bl.pfc_cur_conv_rejection_code = l_tmp2_pfc_cur_rejection_tab(i)
9604: ,bl.pc_cur_conv_rejection_code = l_tmp2_pc_cur_rejection_tab(i)
9605: ,bl.txn_markup_percent = l_tmp2_markup_percent_tab(i)
9606: ,bl.txn_standard_bill_rate = l_tmp2_bill_rate_tab(i)
9607: ,bl.txn_standard_cost_rate = l_tmp2_cost_rate_tab(i)
9608: ,bl.burden_cost_rate = l_tmp2_burden_rate_tab(i)
9609: ,bl.txn_bill_rate_override = l_tmp2_bill_rate_ovr_tab(i)
9610: ,bl.txn_cost_rate_override = l_tmp2_cost_rate_ovr_tab(i)
9611: ,bl.burden_cost_rate_override = l_tmp2_burden_rate_ovr_tab(i)

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

9619: FORALL i IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST
9620: UPDATE pa_budget_lines bl
9621: SET bl.txn_raw_cost = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9622: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9623: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9624: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9625: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9626: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9627: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(

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

9622: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9623: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9624: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9625: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9626: (nvl(bl.txn_cost_rate_override,nvl(txn_standard_cost_rate,0))),bl.txn_currency_code)))
9627: ,bl.txn_burdened_cost = decode((nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(
9628: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9629: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)),0,NULL,
9630: (nvl(bl.txn_init_burdened_cost,0) + pa_currency.round_trans_currency_amt1(

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

9631: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9632: (nvl(bl.burden_cost_rate_override,nvl(burden_cost_rate,0))),bl.txn_currency_code)))
9633: ,bl.txn_revenue = decode((nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9634: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9635: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,
9636: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9637: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9638: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)))
9639: WHERE bl.budget_line_id = l_tmp2_budget_line_id_tab(i);

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

9634: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9635: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)),0,NULL,
9636: (nvl(bl.txn_init_raw_cost,0) + pa_currency.round_trans_currency_amt1(
9637: (nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) *
9638: (nvl(bl.txn_bill_rate_override,nvl(txn_standard_bill_rate,0))),bl.txn_currency_code)))
9639: WHERE bl.budget_line_id = l_tmp2_budget_line_id_tab(i);
9640:
9641: /* Call the pc and pfc conv attributes for this budget line */
9642: FOR exBlId IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST LOOP

Line 9939: ,bl.txn_standard_bill_rate

9935: ,bl.project_raw_cost
9936: ,bl.project_burdened_cost
9937: ,bl.project_revenue
9938: ,bl.txn_markup_percent
9939: ,bl.txn_standard_bill_rate
9940: ,bl.txn_standard_cost_rate
9941: ,bl.burden_cost_rate
9942: ,bl.cost_ind_compiled_set_id
9943: ,bl.init_raw_cost

Line 9940: ,bl.txn_standard_cost_rate

9936: ,bl.project_burdened_cost
9937: ,bl.project_revenue
9938: ,bl.txn_markup_percent
9939: ,bl.txn_standard_bill_rate
9940: ,bl.txn_standard_cost_rate
9941: ,bl.burden_cost_rate
9942: ,bl.cost_ind_compiled_set_id
9943: ,bl.init_raw_cost
9944: ,bl.init_burdened_cost

Line 10691: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate

10687: ,bl.QUANTITY --total_qty
10688: ,bl.TXN_RAW_COST --total_raw_cost
10689: ,bl.TXN_BURDENED_COST --total_burdened_cost
10690: ,bl.TXN_REVENUE --total_revenue
10691: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate
10692: ,bl.TXN_COST_RATE_OVERRIDE --rw_cost_rate_override
10693: ,bl.BURDEN_COST_RATE --b_cost_rate
10694: ,bl.BURDEN_COST_RATE_OVERRIDE --b_cost_rate_override
10695: ,bl.TXN_STANDARD_BILL_RATE --bill_rate

Line 10695: ,bl.TXN_STANDARD_BILL_RATE --bill_rate

10691: ,bl.TXN_STANDARD_COST_RATE --raw_cost_rate
10692: ,bl.TXN_COST_RATE_OVERRIDE --rw_cost_rate_override
10693: ,bl.BURDEN_COST_RATE --b_cost_rate
10694: ,bl.BURDEN_COST_RATE_OVERRIDE --b_cost_rate_override
10695: ,bl.TXN_STANDARD_BILL_RATE --bill_rate
10696: ,bl.TXN_BILL_RATE_OVERRIDE --bill_rate_override
10697: ,bl.START_DATE --line_start_date
10698: ,bl.END_DATE --line_end_date
10699: ,bl.PERIOD_NAME