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_PLAN_PKG dependencies on PA_FP_SPREAD_CALC_TMP1

Line 1252: from pa_fp_spread_calc_tmp1 tmp1

1248: SELECT 'Y'
1249: INTO l_exists_flag
1250: FROM DUAL
1251: WHERE EXISTS (select null
1252: from pa_fp_spread_calc_tmp1 tmp1
1253: where tmp1.budget_version_id = p_budget_version_id
1254: );
1255: RETURN NVL(l_exists_flag,'N');
1256: EXCEPTION

Line 1540: /*Bug: 4309290.Added the parameter to identify if PA_FP_SPREAD_CALC_TMP1

1536:
1537: END Init_MRC_plsqlTabs;
1538:
1539:
1540: /*Bug: 4309290.Added the parameter to identify if PA_FP_SPREAD_CALC_TMP1
1541: is to be deleted or not. Frm AMG flow we will pass N and for
1542: other calls to calculate api it would be yes*/
1543: PROCEDURE Init_SpreadCalc_Tbls(p_del_spread_calc_tmp1_flg IN VARCHAR2 := 'Y')
1544: IS

Line 1555: --Bug 4309290.using the new introuced parameter p_del_spread_calc_tmp1_flg to determine delete on pa_fp_spread_calc_tmp1

1551: DELETE FROM pa_fp_rollup_tmp;
1552: DELETE FROM pa_fp_spread_calc_tmp;
1553: DELETE FROM pa_resource_asgn_curr_tmp;
1554:
1555: --Bug 4309290.using the new introuced parameter p_del_spread_calc_tmp1_flg to determine delete on pa_fp_spread_calc_tmp1
1556: IF (p_del_spread_calc_tmp1_flg = 'Y') then
1557:
1558: DELETE FROM pa_fp_spread_calc_tmp1;
1559: ELSE

Line 1558: DELETE FROM pa_fp_spread_calc_tmp1;

1554:
1555: --Bug 4309290.using the new introuced parameter p_del_spread_calc_tmp1_flg to determine delete on pa_fp_spread_calc_tmp1
1556: IF (p_del_spread_calc_tmp1_flg = 'Y') then
1557:
1558: DELETE FROM pa_fp_spread_calc_tmp1;
1559: ELSE
1560: /* Bug fix:4272944: The following new api call is added to insert zero qty budget lines for Funding baseline */
1561: IF (NVL(G_baseline_funding_flag,'N') = 'Y'
1562: AND NVL(g_bv_approved_rev_flag,'N') = 'Y') THEN

Line 1578: DELETE FROM pa_fp_spread_calc_tmp1;

1574: );
1575: If NVL(l_return_status,'S') <> 'S' Then
1576: RAISE l_unexpected_exception;
1577: End If;
1578: DELETE FROM pa_fp_spread_calc_tmp1;
1579: END IF;
1580: null;
1581: END IF;
1582:

Line 1998: Delete pa_fp_spread_calc_tmp1;

1994:
1995: BEGIN
1996: x_return_status := 'S';
1997: IF g_rep_res_assignment_id_tab.COUNT > 0 Then
1998: Delete pa_fp_spread_calc_tmp1;
1999: FORALL i IN g_rep_res_assignment_id_tab.FIRST .. g_rep_res_assignment_id_tab.LAST
2000: INSERT INTO pa_fp_spread_calc_tmp1
2001: (budget_line_id
2002: ,resource_assignment_id

Line 2000: INSERT INTO pa_fp_spread_calc_tmp1

1996: x_return_status := 'S';
1997: IF g_rep_res_assignment_id_tab.COUNT > 0 Then
1998: Delete pa_fp_spread_calc_tmp1;
1999: FORALL i IN g_rep_res_assignment_id_tab.FIRST .. g_rep_res_assignment_id_tab.LAST
2000: INSERT INTO pa_fp_spread_calc_tmp1
2001: (budget_line_id
2002: ,resource_assignment_id
2003: ,start_date
2004: ,end_date

Line 2053: UPDATE pa_fp_spread_calc_tmp1 tmp1

2049: * on view pages
2050: * Note: tmp.system_reference_var3 - indicates that Change of Non-rate base to Rate base
2051: * tmp1.system_reference_var1 - indicates that reversal or positive entry of budget line passing to pji
2052: */
2053: UPDATE pa_fp_spread_calc_tmp1 tmp1
2054: SET tmp1.rate_based_flag =
2055: (SELECT decode(nvl(tmp.system_reference_var3,'N'),'Y'
2056: ,decode(nvl(tmp1.system_reference_var1,'XXX'),'REVERSAL','N',NULL),NULL)
2057: FROM pa_fp_spread_calc_tmp tmp

Line 2112: FROM pa_fp_spread_calc_tmp1 tmp1

2108: ,g_rep_projfunc_burden_cost_tab
2109: ,g_rep_projfunc_revenue_tab
2110: ,g_rep_line_mode_tab
2111: ,g_rep_rate_base_flag_tab
2112: FROM pa_fp_spread_calc_tmp1 tmp1
2113: ORDER BY tmp1.resource_assignment_id
2114: ,tmp1.txn_currency_code;
2115:
2116: END IF;

Line 7905: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow

7901: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7902: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7903: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7904: ,p_del_spread_calc_tmp1_flg IN VARCHAR2 := 'Y' /* Bug: 4309290.Added the parameter to identify if
7905: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow
7906: we will pass N and for other calls to calculate api it would
7907: be yes */
7908: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type() /* default 'D' */
7909: ,p_clientExtn_api_call_flag IN VARCHAR2 DEFAULT 'Y'

Line 8464: /*Bug: 4309290. Added the parameter to identify if PA_FP_SPREAD_CALC_TMP1

8460: END IF;
8461: END IF;
8462:
8463: /* Initialize the spreadCalc global plsql tables */
8464: /*Bug: 4309290. Added the parameter to identify if PA_FP_SPREAD_CALC_TMP1
8465: is to be deleted or not. Frm AMG flow we will pass N and for
8466: other calls to calculate api it would be yes*/
8467: Init_SpreadCalc_Tbls(p_del_spread_calc_tmp1_flg => p_del_spread_calc_tmp1_flg);
8468: