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 1222: from pa_fp_spread_calc_tmp1 tmp1

1218: SELECT 'Y'
1219: INTO l_exists_flag
1220: FROM DUAL
1221: WHERE EXISTS (select null
1222: from pa_fp_spread_calc_tmp1 tmp1
1223: where tmp1.budget_version_id = p_budget_version_id
1224: );
1225: RETURN NVL(l_exists_flag,'N');
1226: EXCEPTION

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

1506:
1507: END Init_MRC_plsqlTabs;
1508:
1509:
1510: /*Bug: 4309290.Added the parameter to identify if PA_FP_SPREAD_CALC_TMP1
1511: is to be deleted or not. Frm AMG flow we will pass N and for
1512: other calls to calculate api it would be yes*/
1513: PROCEDURE Init_SpreadCalc_Tbls(p_del_spread_calc_tmp1_flg IN VARCHAR2 := 'Y')
1514: IS

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

1521: DELETE FROM pa_fp_rollup_tmp;
1522: DELETE FROM pa_fp_spread_calc_tmp;
1523: DELETE FROM pa_resource_asgn_curr_tmp;
1524:
1525: --Bug 4309290.using the new introuced parameter p_del_spread_calc_tmp1_flg to determine delete on pa_fp_spread_calc_tmp1
1526: IF (p_del_spread_calc_tmp1_flg = 'Y') then
1527:
1528: DELETE FROM pa_fp_spread_calc_tmp1;
1529: ELSE

Line 1528: DELETE FROM pa_fp_spread_calc_tmp1;

1524:
1525: --Bug 4309290.using the new introuced parameter p_del_spread_calc_tmp1_flg to determine delete on pa_fp_spread_calc_tmp1
1526: IF (p_del_spread_calc_tmp1_flg = 'Y') then
1527:
1528: DELETE FROM pa_fp_spread_calc_tmp1;
1529: ELSE
1530: /* Bug fix:4272944: The following new api call is added to insert zero qty budget lines for Funding baseline */
1531: IF (NVL(G_baseline_funding_flag,'N') = 'Y'
1532: AND NVL(g_bv_approved_rev_flag,'N') = 'Y') THEN

Line 1548: DELETE FROM pa_fp_spread_calc_tmp1;

1544: );
1545: If NVL(l_return_status,'S') <> 'S' Then
1546: RAISE l_unexpected_exception;
1547: End If;
1548: DELETE FROM pa_fp_spread_calc_tmp1;
1549: END IF;
1550: null;
1551: END IF;
1552:

Line 1968: Delete pa_fp_spread_calc_tmp1;

1964:
1965: BEGIN
1966: x_return_status := 'S';
1967: IF g_rep_res_assignment_id_tab.COUNT > 0 Then
1968: Delete pa_fp_spread_calc_tmp1;
1969: FORALL i IN g_rep_res_assignment_id_tab.FIRST .. g_rep_res_assignment_id_tab.LAST
1970: INSERT INTO pa_fp_spread_calc_tmp1
1971: (budget_line_id
1972: ,resource_assignment_id

Line 1970: INSERT INTO pa_fp_spread_calc_tmp1

1966: x_return_status := 'S';
1967: IF g_rep_res_assignment_id_tab.COUNT > 0 Then
1968: Delete pa_fp_spread_calc_tmp1;
1969: FORALL i IN g_rep_res_assignment_id_tab.FIRST .. g_rep_res_assignment_id_tab.LAST
1970: INSERT INTO pa_fp_spread_calc_tmp1
1971: (budget_line_id
1972: ,resource_assignment_id
1973: ,start_date
1974: ,end_date

Line 2023: UPDATE pa_fp_spread_calc_tmp1 tmp1

2019: * on view pages
2020: * Note: tmp.system_reference_var3 - indicates that Change of Non-rate base to Rate base
2021: * tmp1.system_reference_var1 - indicates that reversal or positive entry of budget line passing to pji
2022: */
2023: UPDATE pa_fp_spread_calc_tmp1 tmp1
2024: SET tmp1.rate_based_flag =
2025: (SELECT decode(nvl(tmp.system_reference_var3,'N'),'Y'
2026: ,decode(nvl(tmp1.system_reference_var1,'XXX'),'REVERSAL','N',NULL),NULL)
2027: FROM pa_fp_spread_calc_tmp tmp

Line 2082: FROM pa_fp_spread_calc_tmp1 tmp1

2078: ,g_rep_projfunc_burden_cost_tab
2079: ,g_rep_projfunc_revenue_tab
2080: ,g_rep_line_mode_tab
2081: ,g_rep_rate_base_flag_tab
2082: FROM pa_fp_spread_calc_tmp1 tmp1
2083: ORDER BY tmp1.resource_assignment_id
2084: ,tmp1.txn_currency_code;
2085:
2086: END IF;

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

7811: ,p_plan_end_date_new_tab IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.pa_date_tbl_type()
7812: ,p_re_spread_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7813: ,p_rlm_id_change_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
7814: ,p_del_spread_calc_tmp1_flg IN VARCHAR2 := 'Y' /* Bug: 4309290.Added the parameter to identify if
7815: PA_FP_SPREAD_CALC_TMP1 is to be deleted or not. Frm AMG flow
7816: we will pass N and for other calls to calculate api it would
7817: be yes */
7818: ,p_fp_task_billable_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type() /* default 'D' */
7819: ,p_clientExtn_api_call_flag IN VARCHAR2 DEFAULT 'Y'

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

8353: END IF;
8354: END IF;
8355:
8356: /* Initialize the spreadCalc global plsql tables */
8357: /*Bug: 4309290. Added the parameter to identify if PA_FP_SPREAD_CALC_TMP1
8358: is to be deleted or not. Frm AMG flow we will pass N and for
8359: other calls to calculate api it would be yes*/
8360: Init_SpreadCalc_Tbls(p_del_spread_calc_tmp1_flg => p_del_spread_calc_tmp1_flg);
8361: