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_VIEW_PLANS_TXN_PUB dependencies on PA_FP_TXN_LINES_TMP

Line 1877: -- flush out any existing data in PA_FP_TXN_LINES_TMP

1873: END IF;
1874: x_return_status := FND_API.G_RET_STS_SUCCESS;
1875: x_msg_count := 0;
1876: SAVEPOINT PA_FIN_PLAN_VIEWPLANS_TXN;
1877: -- flush out any existing data in PA_FP_TXN_LINES_TMP
1878: delete from PA_FP_TXN_LINES_TMP where project_id is not null;
1879:
1880: -- SINGLE BUDGET VERSION: both cost and revenue
1881: if p_get_display_from = 'ANY' then

Line 1878: delete from PA_FP_TXN_LINES_TMP where project_id is not null;

1874: x_return_status := FND_API.G_RET_STS_SUCCESS;
1875: x_msg_count := 0;
1876: SAVEPOINT PA_FIN_PLAN_VIEWPLANS_TXN;
1877: -- flush out any existing data in PA_FP_TXN_LINES_TMP
1878: delete from PA_FP_TXN_LINES_TMP where project_id is not null;
1879:
1880: -- SINGLE BUDGET VERSION: both cost and revenue
1881: if p_get_display_from = 'ANY' then
1882: --hr_utility.trace('p_get_display_from = ANY');

Line 1926: insert into PA_FP_TXN_LINES_TMP

1922: l_c_margin_pct_tab;
1923: close all_ra_csr;
1924: end if; -- multi_curr_flag for ANY
1925: forall c in nvl(l_c_project_id_tab.first,0)..nvl(l_c_project_id_tab.last,-1)
1926: insert into PA_FP_TXN_LINES_TMP
1927: (project_id,
1928: task_id,
1929: resource_list_member_id,
1930: cost_resource_assignment_id,

Line 2006: insert into PA_FP_TXN_LINES_TMP

2002: l_c_margin_pct_tab;
2003: close cost_ra_csr;
2004: end if; -- multicurrency test for COST
2005: forall c in nvl(l_c_project_id_tab.first,0)..nvl(l_c_project_id_tab.last,-1)
2006: insert into PA_FP_TXN_LINES_TMP
2007: (project_id,
2008: task_id,
2009: resource_list_member_id,
2010: cost_resource_assignment_id,

Line 2076: insert into PA_FP_TXN_LINES_TMP

2072: l_r_revenue_tab;
2073: close revenue_ra_csr;
2074: end if; -- multicurrency test for REVENUE
2075: forall r in nvl(l_r_project_id_tab.first,0)..nvl(l_r_project_id_tab.last,-1)
2076: insert into PA_FP_TXN_LINES_TMP
2077: (project_id,
2078: task_id,
2079: resource_list_member_id,
2080: cost_resource_assignment_id,

Line 2303: insert into PA_FP_TXN_LINES_TMP

2299: end loop; -- revenue table loop
2300: --hr_utility.trace('finished 2nd pass');
2301: -- FINALLY populate the global temporary table
2302: forall c in nvl(l_c_project_id_tab.first,0)..nvl(l_c_project_id_tab.last,-1)
2303: insert into PA_FP_TXN_LINES_TMP
2304: (project_id,
2305: task_id,
2306: resource_list_member_id,
2307: cost_resource_assignment_id,