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_MAINTAIN_ACTUAL_PUB dependencies on STANDARD

Line 1179: -- so we populate the standard rate columns instead. Everything else about

1175: -- Bug 4398799: Split original INSERT statement into 2 separate INSERT
1176: -- statements based on p_calling_context. When p_calling_context is
1177: -- 'FP_GEN_FCST_COPY_ACTUAL', we continue populating the rate override
1178: -- columns. In the ELSE case, the context is 'WP_APPLY_PROGRESS_TO_WORKING'
1179: -- so we populate the standard rate columns instead. Everything else about
1180: -- the INSERT statements is unchanged.
1181:
1182: IF p_calling_context = 'FP_GEN_FCST_COPY_ACTUAL' THEN
1183: FORALL j in 1..l_period_name_tab.count

Line 1297: TXN_STANDARD_COST_RATE, /* Bug 4398799, 4071198 start */

1293: QUANTITY,
1294: INIT_QUANTITY,
1295: project_currency_code,
1296: projfunc_currency_code,
1297: TXN_STANDARD_COST_RATE, /* Bug 4398799, 4071198 start */
1298: BURDEN_COST_RATE, /* Bug 4398799, 4071198 start */
1299: TXN_STANDARD_BILL_RATE ) /* Bug 4398799, 4071198 start */
1300: VALUES(p_budget_version_id,
1301: p_resource_assignment_id,

Line 1299: TXN_STANDARD_BILL_RATE ) /* Bug 4398799, 4071198 start */

1295: project_currency_code,
1296: projfunc_currency_code,
1297: TXN_STANDARD_COST_RATE, /* Bug 4398799, 4071198 start */
1298: BURDEN_COST_RATE, /* Bug 4398799, 4071198 start */
1299: TXN_STANDARD_BILL_RATE ) /* Bug 4398799, 4071198 start */
1300: VALUES(p_budget_version_id,
1301: p_resource_assignment_id,
1302: l_period_name_tab(j),
1303: l_start_date_tab(j),

Line 1522: -- standard rate columns instead of rate override columns.

1518: p_extraction_type = 'FULL' AND
1519: p_calling_context = 'WP_APPLY_PROGRESS_TO_WORKING' THEN
1520:
1521: -- Bug 4398799: For Workplan flow, modified code to populate
1522: -- standard rate columns instead of rate override columns.
1523:
1524: SELECT budget_line_id,
1525: TXN_RAW_COST,
1526: TXN_BURDENED_COST,

Line 1535: TXN_STANDARD_COST_RATE, /* Bug 4398799 */

1531: RAW_COST,
1532: BURDENED_COST,
1533: REVENUE,
1534: QUANTITY,
1535: TXN_STANDARD_COST_RATE, /* Bug 4398799 */
1536: BURDEN_COST_RATE, /* Bug 4398799 */
1537: TXN_STANDARD_BILL_RATE /* Bug 4398799 */
1538: INTO l_bdgt_line_id,
1539: l_txn_raw_cost,

Line 1537: TXN_STANDARD_BILL_RATE /* Bug 4398799 */

1533: REVENUE,
1534: QUANTITY,
1535: TXN_STANDARD_COST_RATE, /* Bug 4398799 */
1536: BURDEN_COST_RATE, /* Bug 4398799 */
1537: TXN_STANDARD_BILL_RATE /* Bug 4398799 */
1538: INTO l_bdgt_line_id,
1539: l_txn_raw_cost,
1540: l_txn_burdened_cost,
1541: l_txn_revenue,

Line 1719: -- standard rate columns instead of rate override columns.

1715: INIT_QUANTITY = NVL(INIT_QUANTITY,0) + l_upd_qty_tab(m)
1716: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1717:
1718: -- Bug 4398799: For Workplan flow, modified code to populate
1719: -- standard rate columns instead of rate override columns.
1720:
1721: /* bug 4071198 start */
1722: /* bug 4398799 start */
1723: IF l_version_type = 'COST' THEN

Line 1727: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),

1723: IF l_version_type = 'COST' THEN
1724:
1725: FORALL m in 1..l_upd_period_name_tab.count
1726: UPDATE pa_budget_lines SET
1727: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),
1728: BURDEN_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_burdened_cost/quantity)
1729: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1730:
1731: ELSIF l_version_type = 'REVENUE' THEN

Line 1735: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)

1731: ELSIF l_version_type = 'REVENUE' THEN
1732:
1733: FORALL m in 1..l_upd_period_name_tab.count
1734: UPDATE pa_budget_lines SET
1735: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)
1736: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1737:
1738: ELSIF l_version_type = 'ALL' THEN
1739:

Line 1742: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),

1738: ELSIF l_version_type = 'ALL' THEN
1739:
1740: FORALL m in 1..l_upd_period_name_tab.count
1741: UPDATE pa_budget_lines SET
1742: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),
1743: BURDEN_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_burdened_cost/quantity),
1744: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)
1745: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1746:

Line 1744: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)

1740: FORALL m in 1..l_upd_period_name_tab.count
1741: UPDATE pa_budget_lines SET
1742: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),
1743: BURDEN_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_burdened_cost/quantity),
1744: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)
1745: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1746:
1747: END IF;
1748: /* bug 4398799 end */

Line 1786: TXN_STANDARD_COST_RATE = l_upd_cost_rate_override_tab(m), /* Bug 4398799, 4071198 start */

1782: CREATED_BY = l_last_updated_by,
1783: LAST_UPDATE_LOGIN = l_last_update_login,
1784: QUANTITY = l_upd_plan_qty_tab(m),
1785: INIT_QUANTITY = l_upd_qty_tab(m),
1786: TXN_STANDARD_COST_RATE = l_upd_cost_rate_override_tab(m), /* Bug 4398799, 4071198 start */
1787: BURDEN_COST_RATE = l_upd_bcost_rate_override_tab(m),
1788: TXN_STANDARD_BILL_RATE = l_upd_bill_rate_override_tab(m) /* Bug 4398799, 4071198 end */
1789: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1790: ELSE

Line 1788: TXN_STANDARD_BILL_RATE = l_upd_bill_rate_override_tab(m) /* Bug 4398799, 4071198 end */

1784: QUANTITY = l_upd_plan_qty_tab(m),
1785: INIT_QUANTITY = l_upd_qty_tab(m),
1786: TXN_STANDARD_COST_RATE = l_upd_cost_rate_override_tab(m), /* Bug 4398799, 4071198 start */
1787: BURDEN_COST_RATE = l_upd_bcost_rate_override_tab(m),
1788: TXN_STANDARD_BILL_RATE = l_upd_bill_rate_override_tab(m) /* Bug 4398799, 4071198 end */
1789: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1790: ELSE
1791: -- Bug 4232253 : Rev. forecast incorrect for NTP with retain Manually ordered line.
1792: If l_ret_manual_line_flag = 'Y' AND l_time_phased_code = 'N' then

Line 1916: -- so we populate the standard rate columns instead. Everything else about

1912: -- Bug 4398799: Split original UPDATE statement into 2 separate UPDATE
1913: -- statements based on p_calling_context. When p_calling_context is
1914: -- 'FP_GEN_FCST_COPY_ACTUAL', we continue populating the rate override
1915: -- columns. In the ELSE case, the context is 'WP_APPLY_PROGRESS_TO_WORKING'
1916: -- so we populate the standard rate columns instead. Everything else about
1917: -- the UPDATE statements is unchanged.
1918:
1919: IF p_calling_context = 'FP_GEN_FCST_COPY_ACTUAL' THEN
1920: FORALL m in 1..l_upd_period_name_tab.count

Line 1981: TXN_STANDARD_COST_RATE = l_upd_cost_rate_override_tab(m), /* Bug 4398799, 4071198 start */

1977: CREATED_BY = l_last_updated_by,
1978: LAST_UPDATE_LOGIN = l_last_update_login,
1979: QUANTITY = l_upd_qty_tab(m),
1980: INIT_QUANTITY = l_upd_qty_tab(m),
1981: TXN_STANDARD_COST_RATE = l_upd_cost_rate_override_tab(m), /* Bug 4398799, 4071198 start */
1982: BURDEN_COST_RATE = l_upd_bcost_rate_override_tab(m),
1983: TXN_STANDARD_BILL_RATE = l_upd_bill_rate_override_tab(m) /* Bug 4398799, 4071198 end */
1984: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1985: END IF; -- calling context check (End Bug 4398799)

Line 1983: TXN_STANDARD_BILL_RATE = l_upd_bill_rate_override_tab(m) /* Bug 4398799, 4071198 end */

1979: QUANTITY = l_upd_qty_tab(m),
1980: INIT_QUANTITY = l_upd_qty_tab(m),
1981: TXN_STANDARD_COST_RATE = l_upd_cost_rate_override_tab(m), /* Bug 4398799, 4071198 start */
1982: BURDEN_COST_RATE = l_upd_bcost_rate_override_tab(m),
1983: TXN_STANDARD_BILL_RATE = l_upd_bill_rate_override_tab(m) /* Bug 4398799, 4071198 end */
1984: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1985: END IF; -- calling context check (End Bug 4398799)
1986:
1987: End If; -- If l_time_phased_code = 'N'

Line 2153: -- so we populate the standard rate columns instead. Everything else about

2149: -- Bug 4398799: Split original INSERT statement into 2 separate INSERT
2150: -- statements based on p_calling_context. When p_calling_context is
2151: -- 'FP_GEN_FCST_COPY_ACTUAL', we continue populating the rate override
2152: -- columns. In the ELSE case, the context is 'WP_APPLY_PROGRESS_TO_WORKING'
2153: -- so we populate the standard rate columns instead. Everything else about
2154: -- the INSERT statements is unchanged.
2155:
2156: IF p_calling_context = 'FP_GEN_FCST_COPY_ACTUAL' THEN
2157: FORALL n in 1..l_ins_period_name_tab.count

Line 2272: TXN_STANDARD_COST_RATE, /* Bug 4398799, 4071198 */

2268: INIT_QUANTITY,
2269: project_currency_code,
2270: projfunc_currency_code,
2271: QUANTITY,
2272: TXN_STANDARD_COST_RATE, /* Bug 4398799, 4071198 */
2273: BURDEN_COST_RATE, /* Bug 4398799, 4071198 */
2274: TXN_STANDARD_BILL_RATE ) /* Bug 4398799, 4071198 */
2275: VALUES(p_budget_version_id,
2276: p_resource_assignment_id,

Line 2274: TXN_STANDARD_BILL_RATE ) /* Bug 4398799, 4071198 */

2270: projfunc_currency_code,
2271: QUANTITY,
2272: TXN_STANDARD_COST_RATE, /* Bug 4398799, 4071198 */
2273: BURDEN_COST_RATE, /* Bug 4398799, 4071198 */
2274: TXN_STANDARD_BILL_RATE ) /* Bug 4398799, 4071198 */
2275: VALUES(p_budget_version_id,
2276: p_resource_assignment_id,
2277: l_ins_period_name_tab(n),
2278: l_ins_start_date_tab(n),