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_TMP

Line 538: ,PA_FP_SPREAD_CALC_TMP tmp

534: ,sum(bl.txn_revenue)
535: ,decode(p_source_context,'BUDGET_LINE',tmp.start_date,NULL) start_date
536: ,decode(p_source_context,'BUDGET_LINE',tmp.end_date,NULL) end_date
537: FROM PA_BUDGET_LINES bl
538: ,PA_FP_SPREAD_CALC_TMP tmp
539: WHERE tmp.budget_version_id = p_budget_version_id
540: AND bl.resource_assignment_id = tmp.resource_assignment_id
541: AND bl.txn_currency_code = tmp.txn_currency_code
542: AND ((p_source_context = 'BUDGET_LINE'

Line 683: FROM pa_fp_spread_calc_tmp tmp

679: ,tmp.txn_burdened_cost
680: ,tmp.burden_cost_rate_override
681: ,tmp.txn_revenue
682: ,tmp.bill_rate_override
683: FROM pa_fp_spread_calc_tmp tmp
684: ORDER BY tmp.resource_assignment_id
685: ,tmp.txn_currency_code;
686:
687: l_msg Varchar2(2000);

Line 777: FROM pa_fp_spread_calc_tmp tmp

773: ,p_budget_version_id
774: ,tmp.resource_assignment_id
775: ,tmp.txn_currency_code
776: ,'Y'
777: FROM pa_fp_spread_calc_tmp tmp
778: ,pa_resource_asgn_curr rtx
779: WHERE tmp.budget_version_id = p_budget_version_id
780: AND tmp.resource_assignment_id = rtx.resource_assignment_id
781: AND tmp.txn_currency_code = rtx.txn_currency_code

Line 800: from pa_fp_spread_calc_tmp tmp

796: ,rtx.TXN_BURDEN_COST_RATE_OVERRIDE = null
797: ,rtx.TXN_BILL_RATE_OVERRIDE = null
798: WHERE rtx.budget_version_id = p_budget_version_id
799: AND EXISTS ( select null
800: from pa_fp_spread_calc_tmp tmp
801: where tmp.resource_assignment_id = rtx.resource_assignment_id
802: and tmp.txn_currency_code = rtx.txn_currency_code
803: )
804: AND NOT EXISTS ( select null

Line 838: SELECT /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) / pa_resource_asgn_curr_s.nextval

834: ,TXN_BURDEN_COST_RATE_OVERRIDE
835: ,TXN_BILL_RATE_OVERRIDE
836: ,DELETE_FLAG
837: )
838: SELECT /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ pa_resource_asgn_curr_s.nextval
839: ,p_budget_version_id
840: ,tmp.resource_assignment_id
841: ,NVL(tmp.txn_curr_code_override,tmp.txn_currency_code)
842: ,decode(p_refresh_rate_flag, 'N', tmp.cost_rate_override, NULL)

Line 846: FROM pa_fp_spread_calc_tmp tmp

842: ,decode(p_refresh_rate_flag, 'N', tmp.cost_rate_override, NULL)
843: ,decode(p_refresh_rate_flag, 'N', tmp.burden_cost_rate_override, NULL)
844: ,decode(p_refresh_rate_flag, 'N', tmp.bill_rate_override, NULL)
845: ,p_delete_raTxn_flag
846: FROM pa_fp_spread_calc_tmp tmp
847: WHERE tmp.budget_version_id = p_budget_version_id
848: AND NVL(tmp.RA_RATES_ONLY_CHANGE_FLAG,'N') = 'Y'
849: OR (NVL(tmp.cost_rate_changed_flag,'N') = 'Y'
850: OR NVL(tmp.burden_rate_changed_flag,'N') = 'Y'

Line 874: ,pa_fp_spread_calc_tmp tmp1

870: ,NVL(tmp1.burden_cost_rate_override,rtx.TXN_BURDEN_COST_RATE_OVERRIDE))
871: ,decode(tmp1.bill_rate_g_miss_num_flag,'Y',NULL
872: ,NVL(tmp1.bill_rate_override,rtx.TXN_BILL_RATE_OVERRIDE))
873: FROM pa_resource_asgn_curr rtx
874: ,pa_fp_spread_calc_tmp tmp1
875: WHERE rtx.resource_assignment_id = tmp.resource_assignment_id
876: AND rtx.txn_currency_code = tmp.txn_currency_code
877: AND tmp1.resource_assignment_id = tmp.resource_assignment_id
878: AND NVL(tmp1.txn_curr_code_override,tmp1.txn_currency_code) = tmp.txn_currency_code

Line 882: ,pa_fp_spread_calc_tmp tmp2

878: AND NVL(tmp1.txn_curr_code_override,tmp1.txn_currency_code) = tmp.txn_currency_code
879: )
880: WHERE tmp.budget_version_id = p_budget_version_id
881: AND EXISTS (select null from pa_resource_asgn_curr rtx2
882: ,pa_fp_spread_calc_tmp tmp2
883: where rtx2.resource_assignment_id = tmp.resource_assignment_id
884: and rtx2.txn_currency_code = tmp.txn_currency_code
885: AND tmp2.resource_assignment_id = tmp.resource_assignment_id
886: AND NVL(tmp2.txn_curr_code_override,tmp2.txn_currency_code) = tmp.txn_currency_code

Line 973: FROM pa_fp_spread_calc_tmp tmp

969: SELECT 1 ra_txn_id
970: ,p_budget_version_id
971: ,tmp.resource_assignment_id
972: ,tmp.txn_currency_code
973: FROM pa_fp_spread_calc_tmp tmp
974: WHERE tmp.budget_version_id = p_budget_version_id
975: AND tmp.resource_assignment_id = NVL(p_resource_assignment_id,tmp.resource_assignment_id)
976: AND tmp.txn_currency_code = NVL(p_txn_currency_code,tmp.txn_currency_code)
977: AND NVL(tmp.start_date,trunc(sysdate)) = NVL(p_start_date,nvl(tmp.start_date,trunc(sysdate)))

Line 1057: ,pa_fp_spread_calc_tmp tmp1) LOOP

1053: ,tmp1.cost_rate_override tmpCostRt
1054: ,tmp1.burden_cost_rate_override tmpBurdRt
1055: ,tmp1.bill_rate_override tmpBillRt
1056: from pa_resource_asgn_curr_tmp tmp
1057: ,pa_fp_spread_calc_tmp tmp1) LOOP
1058: print_msg('Rates in Tmp Table CostRt['|| c.costRt||']BurdRt['||c.burdRt||']BillRt['||c.billRt||']');
1059: print_msg('Rates in SpCalcTmp Table tmpCostRt['|| c.tmpcostRt||']tmpBurdRt['||c.tmpburdRt||']tmpBillRt['||c.tmpbillRt||']');
1060: end loop;
1061: */

Line 1078: FROM pa_fp_spread_calc_tmp tmp

1074: ,p_budget_version_id
1075: ,tmp.resource_assignment_id
1076: ,tmp.txn_currency_code
1077: ,'Y'
1078: FROM pa_fp_spread_calc_tmp tmp
1079: WHERE tmp.budget_version_id = p_budget_version_id
1080: AND tmp.txn_curr_code_override is NOT NULL
1081: AND tmp.txn_curr_code_override <> tmp.txn_currency_code;
1082: l_rowCount1 := sql%Rowcount;

Line 1203: ,pa_fp_spread_calc_tmp tmp1

1199: ,0,NULL,nvl(tmp.bill_rate_override,rax.txn_bill_rate_override))
1200: ,nvl(tmp.bill_rate_override,rax.txn_bill_rate_override))
1201: ,nvl(tmp.bill_rate_override,rax.txn_bill_rate_override)))))))
1202: FROM pa_resource_asgn_curr rax
1203: ,pa_fp_spread_calc_tmp tmp1
1204: WHERE rax.resource_assignment_id = tmp.resource_assignment_id
1205: AND rax.txn_currency_code = tmp.txn_currency_code
1206: AND tmp1.resource_assignment_id = rax.resource_assignment_id
1207: AND tmp1.txn_currency_code = rax.txn_currency_code

Line 1217: ,pa_fp_spread_calc_tmp tmp2

1213: )
1214: WHERE tmp.budget_version_id = p_budget_version_id
1215: AND EXISTS (select /*+ INDEX(RAX1 PA_RESOURCE_ASGN_CURR_U2) */ null
1216: from pa_resource_asgn_curr rax1
1217: ,pa_fp_spread_calc_tmp tmp2
1218: where rax1.resource_assignment_id = tmp.resource_assignment_id
1219: and rax1.txn_currency_code = tmp.txn_currency_code
1220: and tmp2.resource_assignment_id = rax1.resource_assignment_id
1221: and tmp2.txn_currency_code = rax1.txn_currency_code

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 1552: DELETE FROM pa_fp_spread_calc_tmp;

1548:
1549: --INITIALIZATION--
1550: DELETE FROM pa_fp_res_assignments_tmp;
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

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 1583: DELETE FROM pa_fp_spread_calc_tmp2;

1579: END IF;
1580: null;
1581: END IF;
1582:
1583: DELETE FROM pa_fp_spread_calc_tmp2;
1584: g_sprd_raId_tab.delete;
1585: g_sprd_txn_cur_tab.delete;
1586: g_sprd_sdate_tab.delete;
1587: g_sprd_edate_tab.delete;

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 2057: FROM pa_fp_spread_calc_tmp tmp

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
2058: WHERE tmp.resource_assignment_id = tmp1.resource_assignment_id
2059: AND ROWNUM = 1
2060: )
2061: WHERE tmp1.budget_version_id = p_budget_version_id

Line 2063: FROM pa_fp_spread_calc_tmp otmp

2059: AND ROWNUM = 1
2060: )
2061: WHERE tmp1.budget_version_id = p_budget_version_id
2062: AND EXISTS (select null
2063: FROM pa_fp_spread_calc_tmp otmp
2064: WHERE otmp.resource_assignment_id = tmp1.resource_assignment_id
2065: );
2066: If P_PA_DEBUG_MODE = 'Y' Then
2067: print_msg('Number of rows updated for ratebasedFlag for Pjirollup['||sql%rowcount||']');

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 3364: FROM pa_fp_spread_calc_tmp tmp

3360: ,decode(sign(nvl(ra.sp_fixed_date,p_etc_start_date) - p_etc_start_date),-1,p_etc_start_date,ra.planning_end_date)
3361: ,decode(sign(ra.planning_end_date-p_etc_start_date),-1,p_etc_start_date,ra.planning_end_date))
3362: WHERE ra.budget_version_id = p_budget_version_id
3363: AND EXISTS (SELECT null
3364: FROM pa_fp_spread_calc_tmp tmp
3365: WHERE tmp.budget_version_id = ra.budget_version_id
3366: AND tmp.resource_assignment_id = ra.resource_assignment_id);
3367: print_msg('Reset Ra sp curve, spfixeddate, and planEnddate: NumofRowsUpd['||sql%rowcount||']');
3368:

Line 3381: ,pa_fp_spread_calc_tmp tmp

3377: Where ra.resource_assignment_id = bl.resource_assignment_id)
3378: WHERE bl.budget_version_id = p_budget_version_id
3379: AND EXISTS ( SELECT 'Y'
3380: FROM pa_resource_assignments pra
3381: ,pa_fp_spread_calc_tmp tmp
3382: WHERE pra.resource_assignment_id = bl.resource_assignment_id
3383: AND pra.budget_version_id = bl.budget_version_id
3384: AND tmp.budget_version_id = pra.budget_version_id
3385: AND tmp.resource_assignment_id = pra.resource_assignment_id

Line 3418: FROM pa_fp_spread_calc_tmp tmp

3414: ) IS
3415:
3416: CURSOR cur_spbl_chk IS
3417: SELECT tmp.resource_assignment_id
3418: FROM pa_fp_spread_calc_tmp tmp
3419: ,pa_resource_assignments ra
3420: WHERE tmp.budget_version_id = p_budget_version_id
3421: AND tmp.resource_assignment_id = ra.resource_assignment_id
3422: AND NVL(tmp.sp_curve_change_flag,'N') = 'N'

Line 3487: ,pa_fp_spread_calc_tmp tmp

3483: ,bl.init_raw_cost
3484: ,bl.init_burdened_cost
3485: ,bl.init_revenue
3486: FROM pa_budget_lines bl
3487: ,pa_fp_spread_calc_tmp tmp
3488: WHERE tmp.budget_version_id = p_budget_version_id
3489: AND bl.budget_version_id = tmp.budget_version_id
3490: AND bl.resource_assignment_id = tmp.resource_assignment_id
3491: AND bl.txn_currency_code = tmp.txn_currency_code

Line 3813: ,pa_fp_spread_calc_tmp tmp

3809: ,bl.burden_rejection_code
3810: ,bl.pfc_cur_conv_rejection_code
3811: ,bl.pc_cur_conv_rejection_code
3812: FROM pa_budget_lines bl
3813: ,pa_fp_spread_calc_tmp tmp
3814: WHERE tmp.budget_version_id = p_budget_version_id
3815: AND bl.resource_assignment_id = tmp.resource_assignment_id
3816: AND bl.txn_currency_code = tmp.txn_currency_code
3817: AND bl.start_date < p_etc_start_date

Line 3860: ,pa_fp_spread_calc_tmp tmp

3856: ,bl.burden_rejection_code
3857: ,bl.pfc_cur_conv_rejection_code
3858: ,bl.pc_cur_conv_rejection_code
3859: FROM pa_budget_lines bl
3860: ,pa_fp_spread_calc_tmp tmp
3861: WHERE tmp.budget_version_id = p_budget_version_id
3862: AND bl.resource_assignment_id = tmp.resource_assignment_id
3863: AND bl.txn_currency_code = tmp.txn_currency_code
3864: AND bl.start_date < p_etc_start_date

Line 3909: ,pa_fp_spread_calc_tmp tmp

3905: ,bl.pfc_cur_conv_rejection_code
3906: ,bl.pc_cur_conv_rejection_code
3907: FROM pa_budget_lines bl
3908: ,pa_resource_assignments ra
3909: ,pa_fp_spread_calc_tmp tmp
3910: WHERE tmp.budget_version_id = p_budget_version_id
3911: AND bl.resource_assignment_id = tmp.resource_assignment_id
3912: AND bl.txn_currency_code = tmp.txn_currency_code
3913: AND ra.resource_assignment_id = tmp.resource_assignment_id

Line 4462: ,pa_fp_spread_calc_tmp tmp

4458: ,l_upd_burden_rejection_tab
4459: ,l_upd_pfc_cur_conv_rej_tab
4460: ,l_upd_pc_cur_conv_rej_tab
4461: FROM pa_budget_lines bl
4462: ,pa_fp_spread_calc_tmp tmp
4463: WHERE bl.budget_version_id = p_budget_version_id
4464: AND tmp.budget_version_id = bl.budget_version_id
4465: AND bl.resource_assignment_id = tmp.resource_assignment_id
4466: AND bl.txn_currency_code = tmp.txn_currency_code

Line 4600: UPDATE /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) / PA_FP_SPREAD_CALC_TMP tmp -- bug 4873834

4596: If P_PA_DEBUG_MODE = 'Y' Then
4597: print_msg('Number Of rowsUpdated['||g_plan_raId_tab.COUNT||']');
4598: End If;
4599: FORALL i IN g_plan_raId_tab.FIRST .. g_plan_raId_tab.LAST
4600: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ PA_FP_SPREAD_CALC_TMP tmp -- bug 4873834
4601: SET tmp.skip_record_flag = NVL(g_skip_record_tab(i),'N')
4602: ,tmp.processed_flag = NVL(g_process_skip_CstRevrec_tab(i),'N')
4603: ,tmp.REFRESH_RATES_FLAG = NVL(g_refresh_rates_tab(i),'N')
4604: ,tmp.REFRESH_CONV_RATES_FLAG = NVL(g_refresh_conv_rates_tab(i),'N')

Line 4624: UPDATE /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) / PA_FP_SPREAD_CALC_TMP tmp

4620: IF g_mfc_cost_refrsh_Raid_tab.COUNT > 0 THEN
4621: g_stage := 'Upd_spread_calc_tmp:101';
4622: --print_msg(g_stage);
4623: FORALL i IN g_mfc_cost_refrsh_Raid_tab.FIRST .. g_mfc_cost_refrsh_Raid_tab.LAST
4624: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ PA_FP_SPREAD_CALC_TMP tmp
4625: SET tmp.mfc_cost_refresh_flag = 'Y'
4626: ,tmp.REFRESH_RATES_FLAG = 'Y'
4627: WHERE tmp.budget_version_id = p_budget_version_id
4628: AND tmp.resource_assignment_id = g_mfc_cost_refrsh_Raid_tab(i)

Line 4637: UPDATE /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) / PA_FP_SPREAD_CALC_TMP tmp

4633: If g_sprd_raId_tab.COUNT > 0 Then
4634: g_stage := 'Upd_spread_calc_tmp:102';
4635: --print_msg(g_stage);
4636: FORALL i IN g_sprd_raId_tab.FIRST .. g_sprd_raId_tab.LAST
4637: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ PA_FP_SPREAD_CALC_TMP tmp
4638: SET tmp.cost_rate_override = decode(tmp.COST_RATE_G_MISS_NUM_FLAG,'Y',NULL
4639: ,NVL(g_sprd_costRt_Ovr_tab(i),tmp.cost_rate_override))
4640: ,tmp.burden_cost_rate_override = decode(tmp.burden_rate_g_miss_num_flag,'Y',NULL
4641: ,NVL(g_sprd_burdRt_Ovr_tab(i),tmp.burden_cost_rate_override))

Line 4666: UPDATE /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) / pa_fp_spread_calc_tmp tmp

4662: If P_PA_DEBUG_MODE = 'Y' Then
4663: print_msg('Updating spread calc tmp with rate overrides');
4664: End If;
4665: FORALL i IN g_rtChanged_RaId_tab.FIRST .. g_rtChanged_RaId_tab.LAST
4666: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ pa_fp_spread_calc_tmp tmp
4667: SET tmp.cost_rate_override = decode(NVL(g_rtChanged_cstMisNumFlg_tab(i),'N'),'Y',NULL
4668: ,NVL(g_rtChanged_CostRt_Tab(i),tmp.cost_rate_override))
4669: ,tmp.burden_cost_rate_override = decode(NVL(g_rtChanged_bdMisNumFlag_tab(i),'N'),'Y',NULL
4670: ,NVL(g_rtChanged_BurdRt_tab(i),tmp.burden_cost_rate_override))

Line 4780: ,pa_fp_spread_calc_tmp caltmp

4776: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4777: FROM pa_fp_rollup_tmp tmp
4778: ,pa_fp_gen_rate_tmp fptmp
4779: ,pa_resource_assignments ra
4780: ,pa_fp_spread_calc_tmp caltmp
4781: WHERE caltmp.budget_version_id = p_budget_version_id
4782: AND caltmp.resource_assignment_id = ra.resource_assignment_id
4783: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
4784: AND tmp.resource_assignment_id = ra.resource_assignment_id

Line 4816: ,pa_fp_spread_calc_tmp caltmp

4812: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4813: FROM pa_fp_rollup_tmp tmp
4814: ,pa_fp_gen_rate_tmp fptmp
4815: ,pa_resource_assignments ra
4816: ,pa_fp_spread_calc_tmp caltmp
4817: WHERE caltmp.budget_version_id = p_budget_version_id
4818: AND caltmp.resource_assignment_id = ra.resource_assignment_id
4819: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
4820: AND tmp.resource_assignment_id = ra.resource_assignment_id

Line 5774: for i in (select * from pa_fp_spread_calc_tmp ) LOOP

5770: print_msg(to_char(l_stage)||'Entered PA_FP_CALC_PLAN_PKG.populate_rollup_tmp');
5771: End If;
5772: /*
5773: If P_PA_DEBUG_MODE = 'Y' Then
5774: for i in (select * from pa_fp_spread_calc_tmp ) LOOP
5775: print_msg('IN params ResId['||i.resource_assignment_id||']TxnCur['||i.txn_currency_code||']RefrFlag['||i.refresh_rates_flag||']');
5776: print_msg('RefrConvFlag['||i.refresh_conv_rates_flag||']gSprdFromDt['||g_spread_from_date||']gLnSD['||i.start_date||']');
5777: print_msg('gLineEnDate['||i.end_date||']massAdflag['||i.mass_adjust_flag||']mfcCstFlag['||i.mfc_cost_refresh_flag||']skipFlag['||i.skip_record_flag||']');
5778: end loop;

Line 6127: ,pa_fp_spread_calc_tmp tmp

6123: ,decode(nvl(ra.rate_based_flag,'N'),'Y','N'
6124: ,'N',decode(bl.txn_cost_rate_override,0,'Y','N'))))
6125: FROM pa_budget_lines bl
6126: ,pa_resource_assignments ra
6127: ,pa_fp_spread_calc_tmp tmp
6128: WHERE tmp.budget_version_id = p_budget_version_id
6129: AND (NVL(tmp.refresh_rates_flag,'N') in ('Y','R','C')
6130: OR NVL(tmp.refresh_conv_rates_flag,'N') = 'Y'
6131: OR NVL(tmp.mass_adjust_flag,'N') = 'Y'

Line 6172: FROM pa_fp_spread_calc_tmp caltmp

6168: ,decode(caltmp.txn_curr_code_override,NULL,decode(caltmp.mfc_cost_change_flag,'Y',caltmp.burden_cost_rate_override
6169: ,tmp.burden_cost_rate_override),caltmp.burden_cost_rate_override)
6170: ,decode(caltmp.txn_curr_code_override,NULL,decode(caltmp.mfc_cost_change_flag,'Y',caltmp.bill_rate_override
6171: ,tmp.bill_rate_override),caltmp.bill_rate_override)
6172: FROM pa_fp_spread_calc_tmp caltmp
6173: WHERE caltmp.budget_version_id = tmp.budget_version_id
6174: AND caltmp.resource_assignment_id = tmp.resource_assignment_id
6175: AND caltmp.txn_currency_code = tmp.txn_currency_code
6176: AND NVL(caltmp.skip_record_flag,'N') <> 'Y'

Line 6184: FROM pa_fp_spread_calc_tmp caltmp

6180: AND NVL(caltmp.mfc_cost_refresh_flag,'N') = 'Y'
6181: ))
6182: WHERE tmp.budget_version_id = p_budget_version_id
6183: AND EXISTS ( select null
6184: FROM pa_fp_spread_calc_tmp caltmp
6185: WHERE caltmp.budget_version_id = tmp.budget_version_id
6186: AND caltmp.resource_assignment_id = tmp.resource_assignment_id
6187: AND caltmp.txn_currency_code = tmp.txn_currency_code
6188: AND NVL(caltmp.skip_record_flag,'N') <> 'Y'

Line 6226: FROM pa_fp_spread_calc_tmp caltmp

6222: ,NVL(g_rtChanged_BurdRt_tab(i),tmp.burden_cost_rate_override)))
6223: ,NVL(g_rtChanged_BurdRt_tab(i),tmp.burden_cost_rate_override))))
6224: ,decode(NVL(g_rtChanged_blMisNumFlag_tab(i),'N'),'Y',NULL
6225: ,NVL(g_rtChanged_billRt_tab(i),tmp.bill_rate_override))
6226: FROM pa_fp_spread_calc_tmp caltmp
6227: WHERE caltmp.resource_assignment_id = tmp.resource_assignment_id
6228: AND caltmp.txn_currency_code = tmp.txn_currency_code
6229: AND ((g_source_context <> 'BUDGET_LINE')
6230: OR

Line 6357: ,pa_fp_spread_calc_tmp caltmp

6353: ,decode(NVL(tmp.rate_based_flag,'N'),'Y',0
6354: ,(sum(nvl(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))))) RndRevenue
6355: ,to_number(null) RevenueDiff
6356: FROM pa_fp_rollup_tmp tmp
6357: ,pa_fp_spread_calc_tmp caltmp
6358: WHERE caltmp.budget_version_id = p_budget_version_id
6359: AND caltmp.resource_assignment_id = tmp.resource_assignment_id
6360: AND tmp.txn_currency_code = caltmp.txn_currency_code
6361: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'

Line 6419: from pa_fp_spread_calc_tmp caltmp

6415: * ((l_burdened_rate_adj_pct + 100)/100))
6416: )
6417: WHERE tmp.budget_version_id = p_budget_version_id
6418: AND EXISTS ( select null
6419: from pa_fp_spread_calc_tmp caltmp
6420: WHERE caltmp.resource_assignment_id = tmp.resource_assignment_id
6421: AND caltmp.txn_currency_code = tmp.txn_currency_code
6422: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
6423: AND nvl(caltmp.mass_adjust_flag,'N') = 'Y'

Line 6484: from pa_fp_spread_calc_tmp caltmp

6480: ,(nvl(tmp.bill_rate_override,tmp.bill_rate) * ((l_bill_rate_adj_pct + 100)/100))))
6481: ))
6482: WHERE tmp.budget_version_id = p_budget_version_id
6483: AND EXISTS ( select null
6484: from pa_fp_spread_calc_tmp caltmp
6485: WHERE caltmp.resource_assignment_id = tmp.resource_assignment_id
6486: AND caltmp.txn_currency_code = tmp.txn_currency_code
6487: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
6488: AND nvl(caltmp.mass_adjust_flag,'N') = 'Y'

Line 6569: from pa_fp_spread_calc_tmp caltmp

6565: ,(NVL(tmp.rw_cost_rate_override,tmp.cost_rate)
6566: * ((l_raw_cost_adj_pct + 100)/100))))))
6567: WHERE tmp.budget_version_id = p_budget_version_id
6568: AND EXISTS ( select null
6569: from pa_fp_spread_calc_tmp caltmp
6570: WHERE caltmp.resource_assignment_id = tmp.resource_assignment_id
6571: AND caltmp.txn_currency_code = tmp.txn_currency_code
6572: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
6573: AND nvl(caltmp.mass_adjust_flag,'N') = 'Y' );

Line 6791: FROM pa_fp_spread_calc_tmp tmp

6787: ,DECODE(sum(pbl.project_init_revenue),0,NULL,sum(pbl.project_init_revenue)) project_init_revenue
6788: FROM pa_budget_lines pbl
6789: WHERE pbl.budget_version_id = p_budget_version_id
6790: AND EXISTS (SELECT NULL
6791: FROM pa_fp_spread_calc_tmp tmp
6792: WHERE tmp.budget_version_id = p_budget_version_id
6793: AND tmp.resource_assignment_id = pbl.resource_assignment_id
6794: )
6795: GROUP BY pbl.resource_assignment_id;

Line 6800: -- we might not have data populated in pa_fp_spread_calc_tmp temp table

6796:
6797: -- gboomina AAI Requirement - Start
6798: -- Cursor to get rolled up amounts from budget lines without temp table
6799: -- This cursor is used for other flows other than calculate api where in
6800: -- we might not have data populated in pa_fp_spread_calc_tmp temp table
6801: CURSOR rollup_bl_generic_csr is
6802: SELECT
6803: pbl.resource_assignment_id
6804: ,DECODE(sum(pbl.quantity),0,NULL,sum(pbl.quantity)) pfc_quantity

Line 6861: FROM pa_fp_spread_calc_tmp tmp

6857: ,ra.last_updated_by = l_user_id
6858: ,ra.last_update_date = sysdate
6859: ,ra.last_update_login = l_login_id
6860: WHERE EXISTS (SELECT NULL
6861: FROM pa_fp_spread_calc_tmp tmp
6862: WHERE tmp.budget_version_id = p_budget_version_id
6863: AND tmp.resource_assignment_id = ra.resource_assignment_id
6864: /* Bug fix: 4322568 AND NVL(tmp.skip_record_flag,'N') = 'Y' */
6865: );

Line 7652: from pa_fp_spread_calc_tmp tmp1

7648: */
7649: cursor cur_nullBls is
7650: select tmp1.resource_assignment_id
7651: ,tmp1.txn_currency_code
7652: from pa_fp_spread_calc_tmp tmp1
7653: ,pa_resource_assignments ra
7654: where tmp1.budget_version_id = p_budget_version_id
7655: and ra.resource_assignment_id = tmp1.resource_assignment_id
7656: and NVL(ra.rate_based_flag,'N') = 'N'

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:

Line 9710: ,pa_fp_spread_calc_tmp tmp

9706: ,l_curr_bill_rate
9707: ,l_curr_markup_percentage
9708: ,l_curr_cost_rate
9709: FROM pa_resource_asgn_curr rtx
9710: ,pa_fp_spread_calc_tmp tmp
9711: WHERE tmp.resource_assignment_id = l_resource_assignment_id
9712: AND tmp.txn_currency_code = l_txn_currency_code
9713: AND rtx.resource_assignment_id = tmp.resource_assignment_id
9714: AND rtx.txn_currency_code = tmp.txn_currency_code;

Line 11754: SELECT /+ INDEX(CALTMP PA_FP_SPREAD_CALC_TMP_N1) / caltmp.resource_assignment_id

11750: p_project_id Number;
11751: p_task_id Number;
11752:
11753: CURSOR cur_calcTmp IS
11754: SELECT /*+ INDEX(CALTMP PA_FP_SPREAD_CALC_TMP_N1) */ caltmp.resource_assignment_id
11755: ,caltmp.txn_currency_code
11756: ,caltmp.start_date
11757: ,caltmp.end_date
11758: ,caltmp.txn_curr_code_override

Line 11767: FROM pa_fp_spread_calc_tmp caltmp

11763: ,NVL(ra.rate_based_flag,'N') rate_based_flag
11764: ,caltmp.task_name
11765: ,caltmp.resource_name
11766: ,caltmp.billable_flag
11767: FROM pa_fp_spread_calc_tmp caltmp
11768: ,pa_resource_assignments ra
11769: WHERE caltmp.budget_version_id = p_budget_version_id
11770: AND caltmp.resource_assignment_id = ra.resource_assignment_id
11771: AND ( NVL(caltmp.skip_record_flag,'N') <> 'Y'

Line 15791: for i in (select * from pa_fp_spread_calc_tmp ) LOOP

15787: pa_debug.init_err_stack('PA_FP_CALC_PLAN_PKG.Process_skipped_records');
15788: End If;
15789: /***
15790: If P_PA_DEBUG_MODE = 'Y' Then
15791: for i in (select * from pa_fp_spread_calc_tmp ) LOOP
15792: print_msg('IN params ResId['||i.resource_assignment_id||']TxnCur['||i.txn_currency_code||']RefrFlag['||i.refresh_rates_flag||']');
15793: print_msg('RefrConvFlag['||i.refresh_conv_rates_flag||']gSprdFromDt['||g_spread_from_date||']gLnSD['||i.start_date||']');
15794: print_msg('gLineEnDate['||i.end_date||']massAdflag['||i.mass_adjust_flag||']mfcCstFlag['||i.mfc_cost_refresh_flag||']skipFlag['||i.skip_record_flag||']');
15795: end loop;

Line 15921: ,pa_fp_spread_calc_tmp tmp

15917: ,bl.project_init_revenue
15918: ,tmp.billable_flag
15919: FROM pa_budget_lines bl
15920: ,pa_resource_assignments ra
15921: ,pa_fp_spread_calc_tmp tmp
15922: ,pa_fp_rollup_tmp rlp --Bug 5203868
15923: WHERE tmp.budget_version_id = p_budget_version_id
15924: AND tmp.resource_assignment_id = ra.resource_assignment_id
15925: AND bl.resource_assignment_id = tmp.resource_assignment_id