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_REV_GEN_PUB dependencies on PA_FP_ROLLUP_TMP

Line 548: -- line (quantity and cost) data is being stored in PA_FP_ROLLUP_TMP.

544: IF l_pc_project_value <= 0 OR
545: l_pfc_project_value <= 0 THEN
546:
547: -- Bug 4549862: If the source is Staffing Plan, then all the budget
548: -- line (quantity and cost) data is being stored in PA_FP_ROLLUP_TMP.
549: -- Before returning from this API, call PUSH_RES_SCH_DATA_TO_BL to
550: -- Insert/Update data from the temp table to the budget lines.
551:
552: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN

Line 591: -- records for processing from PA_FP_ROLLUP_TMP, only selecting records

587: l_pfc_revenue := 0;
588:
589: -- Bug 4549862: When the target version is ALL, accrual method is COST,
590: -- and source is Staffing Plan, fetch burdened cost sums and individual
591: -- records for processing from PA_FP_ROLLUP_TMP, only selecting records
592: -- with BILLABLE_FLAG = 'Y'.
593: -- Note that checking l_gen_src_code determines this scenario, since
594: -- accrual method is COST for the entire API and generation of Revenue-
595: -- only versions from Staffing Plan is not supported.

Line 609: FROM pa_fp_rollup_tmp bl,

605: SELECT nvl(sum(nvl(bl.projfunc_burdened_cost,0)),0),
606: nvl(sum(nvl(bl.project_burdened_cost,0)),0)
607: INTO l_pfc_burdened_cost,
608: l_pc_burdened_cost
609: FROM pa_fp_rollup_tmp bl,
610: pa_resource_assignments ra
611: WHERE ra.budget_version_id = p_budget_version_id
612: AND ra.resource_assignment_id = bl.resource_assignment_id
613: AND bl.cost_rejection_code is null

Line 646: FROM pa_fp_rollup_tmp bl,

642: l_pfc_raw_cost_tab,
643: l_res_asg_id_tab,
644: l_start_date_tab,
645: l_txn_currency_code_tab
646: FROM pa_fp_rollup_tmp bl,
647: pa_resource_assignments ra
648: WHERE ra.budget_version_id = p_budget_version_id
649: AND ra.resource_assignment_id = bl.resource_assignment_id
650: AND bl.cost_rejection_code is null

Line 670: -- In regards to the PA_FP_ROLLUP_TMP table, we are not maintaining

666: ||l_budget_line_id_tab.count);*/
667:
668: ELSIF l_plan_class_code = 'FORECAST' THEN
669:
670: -- In regards to the PA_FP_ROLLUP_TMP table, we are not maintaining
671: -- the None-timephase invariant that plan amount columns store Total
672: -- Amounts (planned plus actual amounts). Thus, there is no need to
673: -- subtract out actual amounts in the Select statement. Furthermore,
674: -- the temp table stores only ETC amounts, so checking bl.start_date

Line 701: FROM pa_fp_rollup_tmp bl,

697: l_pfc_raw_cost_tab,
698: l_res_asg_id_tab,
699: l_start_date_tab,
700: l_txn_currency_code_tab
701: FROM pa_fp_rollup_tmp bl,
702: pa_resource_assignments ra
703: WHERE ra.budget_version_id = p_budget_version_id
704: AND ra.resource_assignment_id = bl.resource_assignment_id
705: AND bl.start_date >= p_etc_start_date

Line 727: FROM pa_fp_rollup_tmp bl,

723: SELECT nvl(sum(nvl(bl.projfunc_burdened_cost,0)),0),
724: nvl(sum(nvl(bl.project_burdened_cost,0)),0)
725: INTO l_pfc_burdened_cost,
726: l_pc_burdened_cost
727: FROM pa_fp_rollup_tmp bl,
728: pa_resource_assignments ra
729: WHERE ra.budget_version_id = p_budget_version_id
730: AND ra.resource_assignment_id = bl.resource_assignment_id
731: AND bl.start_date >= p_etc_start_date

Line 1088: -- line (quantity and cost) data is being stored in PA_FP_ROLLUP_TMP.

1084: ( l_cost_or_rev_code = 'COST' AND l_pfc_burdened_cost = 0 ) OR
1085: ( l_cost_or_rev_code = 'REVENUE' AND l_pfc_revenue = 0 ) THEN
1086:
1087: -- Bug 4549862: If the source is Staffing Plan, then all the budget
1088: -- line (quantity and cost) data is being stored in PA_FP_ROLLUP_TMP.
1089: -- Before returning from this API, call PUSH_RES_SCH_DATA_TO_BL to
1090: -- Insert/Update data from the temp table to the budget lines.
1091:
1092: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN

Line 1296: UPDATE pa_fp_rollup_tmp

1292:
1293: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
1294:
1295: FORALL j in 1..l_budget_line_id_tab.count
1296: UPDATE pa_fp_rollup_tmp
1297: SET txn_revenue = l_txn_rev_tab(j),
1298: projfunc_revenue = l_txn_rev_tab(j),
1299: project_revenue = l_pc_rev_tab(j),
1300: projfunc_rev_rate_type = 'User',

Line 1433: UPDATE pa_fp_rollup_tmp

1429:
1430: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
1431:
1432: FORALL k in 1..l_budget_line_id_tab.count
1433: UPDATE pa_fp_rollup_tmp
1434: SET txn_revenue = l_txn_rev_tab(k),
1435: projfunc_revenue = l_pfc_rev_tab(k),
1436: project_revenue = l_pc_rev_tab(k),
1437: projfunc_rev_rate_type = 'User',

Line 1514: -- is stored in PA_FP_ROLLUP_TMP. Before returning from this API,

1510:
1511:
1512: -- Bug 4549862: At this point, revenue amounts have been computed.
1513: -- If the source is Staffing Plan, then all the budget line data
1514: -- is stored in PA_FP_ROLLUP_TMP. Before returning from this API,
1515: -- we need to call PUSH_RES_SCH_DATA_TO_BL to Insert/Update data
1516: -- from the temp table to the budget lines.
1517:
1518: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN

Line 1608: * This procedure propagates generation data stored in PA_FP_ROLLUP_TMP

1604: * This private procedure is meant to be used by GEN_COST_BASED_REVENUE
1605: * when generating a Cost and Revenue together version with source of
1606: * Staffing Plan and revenue accrual method of COST.
1607: *
1608: * This procedure propagates generation data stored in PA_FP_ROLLUP_TMP
1609: * and Inserts/Updates it into PA_BUDGET_LINES. This includes txn/pc/pfc
1610: * amounts, rate overrides, pc/pfc exchange rates, cost/revenue rate types,
1611: * and rejection codes.
1612: *

Line 1659: FROM pa_fp_rollup_tmp

1655: PROJECT_COST_RATE_TYPE,
1656: PROJFUNC_COST_RATE_TYPE,
1657: PROJECT_REV_RATE_TYPE,
1658: PROJFUNC_REV_RATE_TYPE
1659: FROM pa_fp_rollup_tmp
1660: GROUP BY resource_assignment_id,
1661: txn_currency_code,
1662: start_date,
1663: end_date,

Line 1703: FROM pa_fp_rollup_tmp

1699: PROJECT_COST_RATE_TYPE,
1700: PROJFUNC_COST_RATE_TYPE,
1701: PROJECT_REV_RATE_TYPE,
1702: PROJFUNC_REV_RATE_TYPE
1703: FROM pa_fp_rollup_tmp
1704: GROUP BY resource_assignment_id,
1705: txn_currency_code,
1706: period_name,
1707: COST_REJECTION_CODE,

Line 1748: FROM pa_fp_rollup_tmp tmp

1744: PROJECT_COST_RATE_TYPE,
1745: PROJFUNC_COST_RATE_TYPE,
1746: PROJECT_REV_RATE_TYPE,
1747: PROJFUNC_REV_RATE_TYPE
1748: FROM pa_fp_rollup_tmp tmp
1749: GROUP BY resource_assignment_id,
1750: txn_currency_code,
1751: period_name,
1752: COST_REJECTION_CODE,

Line 1797: FROM pa_fp_rollup_tmp tmp

1793: PROJECT_COST_RATE_TYPE,
1794: PROJFUNC_COST_RATE_TYPE,
1795: PROJECT_REV_RATE_TYPE,
1796: PROJFUNC_REV_RATE_TYPE
1797: FROM pa_fp_rollup_tmp tmp
1798: GROUP BY resource_assignment_id,
1799: txn_currency_code,
1800: period_name,
1801: COST_REJECTION_CODE,

Line 1903: -- Bug 4549862: Update pc/pfc rate types to 'User' in PA_FP_ROLLUP_TMP:

1899: ( p_function => 'PUSH_RES_SCH_DATA_TO_BL',
1900: p_debug_mode => p_pa_debug_mode );
1901: END IF;
1902:
1903: -- Bug 4549862: Update pc/pfc rate types to 'User' in PA_FP_ROLLUP_TMP:
1904: -- 1. Revenue rate types will always be 'User', so no update needed.
1905: -- 2. Cost rate types for records of a given (resource assignment, txn
1906: -- currency, period) combination need to be updated if any record for
1907: -- that combination has cost rate type as 'User'. This will be the

Line 1910: -- Bug 4619257: Update pc/pfc rate types to 'User' in PA_FP_ROLLUP_TMP:

1906: -- currency, period) combination need to be updated if any record for
1907: -- that combination has cost rate type as 'User'. This will be the
1908: -- case if a commitment exists for the given combination.
1909:
1910: -- Bug 4619257: Update pc/pfc rate types to 'User' in PA_FP_ROLLUP_TMP:
1911: -- 1. The assumption that Revenue rate types will always be 'User' is
1912: -- incorrect when some of the assignments mapping to a resource are
1913: -- billable and other are non-billable.
1914: -- Revenue rate types for records of a given (resource assignment,

Line 1920: UPDATE pa_fp_rollup_tmp tmp

1916: -- record for that combination has revenue rate type as 'User'.
1917:
1918: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1919: -- Update Project Functional currency cost rate type
1920: UPDATE pa_fp_rollup_tmp tmp
1921: SET projfunc_cost_rate_type = 'User'
1922: WHERE projfunc_cost_rate_type <> 'User'
1923: AND EXISTS ( SELECT null
1924: FROM pa_fp_rollup_tmp tmp2

Line 1924: FROM pa_fp_rollup_tmp tmp2

1920: UPDATE pa_fp_rollup_tmp tmp
1921: SET projfunc_cost_rate_type = 'User'
1922: WHERE projfunc_cost_rate_type <> 'User'
1923: AND EXISTS ( SELECT null
1924: FROM pa_fp_rollup_tmp tmp2
1925: WHERE tmp2.resource_assignment_id = tmp.resource_assignment_id
1926: AND tmp2.txn_currency_code = tmp.txn_currency_code
1927: AND tmp2.start_date = tmp.start_date
1928: AND tmp2.projfunc_cost_rate_type = 'User' );

Line 1931: UPDATE pa_fp_rollup_tmp tmp

1927: AND tmp2.start_date = tmp.start_date
1928: AND tmp2.projfunc_cost_rate_type = 'User' );
1929:
1930: -- Update Project currency cost rate type
1931: UPDATE pa_fp_rollup_tmp tmp
1932: SET project_cost_rate_type = 'User'
1933: WHERE project_cost_rate_type <> 'User'
1934: AND EXISTS ( SELECT null
1935: FROM pa_fp_rollup_tmp tmp2

Line 1935: FROM pa_fp_rollup_tmp tmp2

1931: UPDATE pa_fp_rollup_tmp tmp
1932: SET project_cost_rate_type = 'User'
1933: WHERE project_cost_rate_type <> 'User'
1934: AND EXISTS ( SELECT null
1935: FROM pa_fp_rollup_tmp tmp2
1936: WHERE tmp2.resource_assignment_id = tmp.resource_assignment_id
1937: AND tmp2.txn_currency_code = tmp.txn_currency_code
1938: AND tmp2.start_date = tmp.start_date
1939: AND tmp2.project_cost_rate_type = 'User' );

Line 1942: UPDATE pa_fp_rollup_tmp tmp

1938: AND tmp2.start_date = tmp.start_date
1939: AND tmp2.project_cost_rate_type = 'User' );
1940:
1941: -- Bug 4619257: Update Project Functional currency revenue rate type
1942: UPDATE pa_fp_rollup_tmp tmp
1943: SET projfunc_rev_rate_type = 'User'
1944: WHERE projfunc_rev_rate_type <> 'User'
1945: AND EXISTS ( SELECT null
1946: FROM pa_fp_rollup_tmp tmp2

Line 1946: FROM pa_fp_rollup_tmp tmp2

1942: UPDATE pa_fp_rollup_tmp tmp
1943: SET projfunc_rev_rate_type = 'User'
1944: WHERE projfunc_rev_rate_type <> 'User'
1945: AND EXISTS ( SELECT null
1946: FROM pa_fp_rollup_tmp tmp2
1947: WHERE tmp2.resource_assignment_id = tmp.resource_assignment_id
1948: AND tmp2.txn_currency_code = tmp.txn_currency_code
1949: AND tmp2.start_date = tmp.start_date
1950: AND tmp2.projfunc_rev_rate_type = 'User' );

Line 1953: UPDATE pa_fp_rollup_tmp tmp

1949: AND tmp2.start_date = tmp.start_date
1950: AND tmp2.projfunc_rev_rate_type = 'User' );
1951:
1952: -- Bug 4619257: Update Project currency revenue rate type
1953: UPDATE pa_fp_rollup_tmp tmp
1954: SET project_rev_rate_type = 'User'
1955: WHERE project_rev_rate_type <> 'User'
1956: AND EXISTS ( SELECT null
1957: FROM pa_fp_rollup_tmp tmp2

Line 1957: FROM pa_fp_rollup_tmp tmp2

1953: UPDATE pa_fp_rollup_tmp tmp
1954: SET project_rev_rate_type = 'User'
1955: WHERE project_rev_rate_type <> 'User'
1956: AND EXISTS ( SELECT null
1957: FROM pa_fp_rollup_tmp tmp2
1958: WHERE tmp2.resource_assignment_id = tmp.resource_assignment_id
1959: AND tmp2.txn_currency_code = tmp.txn_currency_code
1960: AND tmp2.start_date = tmp.start_date
1961: AND tmp2.project_rev_rate_type = 'User' );

Line 1965: UPDATE pa_fp_rollup_tmp tmp

1961: AND tmp2.project_rev_rate_type = 'User' );
1962:
1963: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1964: -- Update Project Functional currency cost rate type
1965: UPDATE pa_fp_rollup_tmp tmp
1966: SET projfunc_cost_rate_type = 'User'
1967: WHERE projfunc_cost_rate_type <> 'User'
1968: AND EXISTS ( SELECT null
1969: FROM pa_fp_rollup_tmp tmp2

Line 1969: FROM pa_fp_rollup_tmp tmp2

1965: UPDATE pa_fp_rollup_tmp tmp
1966: SET projfunc_cost_rate_type = 'User'
1967: WHERE projfunc_cost_rate_type <> 'User'
1968: AND EXISTS ( SELECT null
1969: FROM pa_fp_rollup_tmp tmp2
1970: WHERE tmp2.resource_assignment_id = tmp.resource_assignment_id
1971: AND tmp2.txn_currency_code = tmp.txn_currency_code
1972: AND tmp2.projfunc_cost_rate_type = 'User' );
1973:

Line 1975: UPDATE pa_fp_rollup_tmp tmp

1971: AND tmp2.txn_currency_code = tmp.txn_currency_code
1972: AND tmp2.projfunc_cost_rate_type = 'User' );
1973:
1974: -- Update Project currency cost rate type
1975: UPDATE pa_fp_rollup_tmp tmp
1976: SET project_cost_rate_type = 'User'
1977: WHERE project_cost_rate_type <> 'User'
1978: AND EXISTS ( SELECT null
1979: FROM pa_fp_rollup_tmp tmp2

Line 1979: FROM pa_fp_rollup_tmp tmp2

1975: UPDATE pa_fp_rollup_tmp tmp
1976: SET project_cost_rate_type = 'User'
1977: WHERE project_cost_rate_type <> 'User'
1978: AND EXISTS ( SELECT null
1979: FROM pa_fp_rollup_tmp tmp2
1980: WHERE tmp2.resource_assignment_id = tmp.resource_assignment_id
1981: AND tmp2.txn_currency_code = tmp.txn_currency_code
1982: AND tmp2.project_cost_rate_type = 'User' );
1983:

Line 1985: UPDATE pa_fp_rollup_tmp tmp

1981: AND tmp2.txn_currency_code = tmp.txn_currency_code
1982: AND tmp2.project_cost_rate_type = 'User' );
1983:
1984: -- Bug 4619257: Update Project Functional currency revenue rate type
1985: UPDATE pa_fp_rollup_tmp tmp
1986: SET projfunc_rev_rate_type = 'User'
1987: WHERE projfunc_rev_rate_type <> 'User'
1988: AND EXISTS ( SELECT null
1989: FROM pa_fp_rollup_tmp tmp2

Line 1989: FROM pa_fp_rollup_tmp tmp2

1985: UPDATE pa_fp_rollup_tmp tmp
1986: SET projfunc_rev_rate_type = 'User'
1987: WHERE projfunc_rev_rate_type <> 'User'
1988: AND EXISTS ( SELECT null
1989: FROM pa_fp_rollup_tmp tmp2
1990: WHERE tmp2.resource_assignment_id = tmp.resource_assignment_id
1991: AND tmp2.txn_currency_code = tmp.txn_currency_code
1992: AND tmp2.projfunc_rev_rate_type = 'User' );
1993:

Line 1995: UPDATE pa_fp_rollup_tmp tmp

1991: AND tmp2.txn_currency_code = tmp.txn_currency_code
1992: AND tmp2.projfunc_rev_rate_type = 'User' );
1993:
1994: -- Bug 4619257: Update Project currency revenue rate type
1995: UPDATE pa_fp_rollup_tmp tmp
1996: SET project_rev_rate_type = 'User'
1997: WHERE project_rev_rate_type <> 'User'
1998: AND EXISTS ( SELECT null
1999: FROM pa_fp_rollup_tmp tmp2

Line 1999: FROM pa_fp_rollup_tmp tmp2

1995: UPDATE pa_fp_rollup_tmp tmp
1996: SET project_rev_rate_type = 'User'
1997: WHERE project_rev_rate_type <> 'User'
1998: AND EXISTS ( SELECT null
1999: FROM pa_fp_rollup_tmp tmp2
2000: WHERE tmp2.resource_assignment_id = tmp.resource_assignment_id
2001: AND tmp2.txn_currency_code = tmp.txn_currency_code
2002: AND tmp2.project_rev_rate_type = 'User' );
2003: END IF;