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

761: ,p_budget_version_id
762: ,tmp.resource_assignment_id
763: ,tmp.txn_currency_code
764: ,'Y'
765: FROM pa_fp_spread_calc_tmp tmp
766: ,pa_resource_asgn_curr rtx
767: WHERE tmp.budget_version_id = p_budget_version_id
768: AND tmp.resource_assignment_id = rtx.resource_assignment_id
769: AND tmp.txn_currency_code = rtx.txn_currency_code

Line 788: from pa_fp_spread_calc_tmp tmp

784: ,rtx.TXN_BURDEN_COST_RATE_OVERRIDE = null
785: ,rtx.TXN_BILL_RATE_OVERRIDE = null
786: WHERE rtx.budget_version_id = p_budget_version_id
787: AND EXISTS ( select null
788: from pa_fp_spread_calc_tmp tmp
789: where tmp.resource_assignment_id = rtx.resource_assignment_id
790: and tmp.txn_currency_code = rtx.txn_currency_code
791: )
792: AND NOT EXISTS ( select null

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

822: ,TXN_BURDEN_COST_RATE_OVERRIDE
823: ,TXN_BILL_RATE_OVERRIDE
824: ,DELETE_FLAG
825: )
826: SELECT /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ pa_resource_asgn_curr_s.nextval
827: ,p_budget_version_id
828: ,tmp.resource_assignment_id
829: ,NVL(tmp.txn_curr_code_override,tmp.txn_currency_code)
830: ,decode(p_refresh_rate_flag, 'N', tmp.cost_rate_override, NULL)

Line 834: FROM pa_fp_spread_calc_tmp tmp

830: ,decode(p_refresh_rate_flag, 'N', tmp.cost_rate_override, NULL)
831: ,decode(p_refresh_rate_flag, 'N', tmp.burden_cost_rate_override, NULL)
832: ,decode(p_refresh_rate_flag, 'N', tmp.bill_rate_override, NULL)
833: ,p_delete_raTxn_flag
834: FROM pa_fp_spread_calc_tmp tmp
835: WHERE tmp.budget_version_id = p_budget_version_id
836: AND NVL(tmp.RA_RATES_ONLY_CHANGE_FLAG,'N') = 'Y'
837: OR (NVL(tmp.cost_rate_changed_flag,'N') = 'Y'
838: OR NVL(tmp.burden_rate_changed_flag,'N') = 'Y'

Line 862: ,pa_fp_spread_calc_tmp tmp1

858: ,NVL(tmp1.burden_cost_rate_override,rtx.TXN_BURDEN_COST_RATE_OVERRIDE))
859: ,decode(tmp1.bill_rate_g_miss_num_flag,'Y',NULL
860: ,NVL(tmp1.bill_rate_override,rtx.TXN_BILL_RATE_OVERRIDE))
861: FROM pa_resource_asgn_curr rtx
862: ,pa_fp_spread_calc_tmp tmp1
863: WHERE rtx.resource_assignment_id = tmp.resource_assignment_id
864: AND rtx.txn_currency_code = tmp.txn_currency_code
865: AND tmp1.resource_assignment_id = tmp.resource_assignment_id
866: AND NVL(tmp1.txn_curr_code_override,tmp1.txn_currency_code) = tmp.txn_currency_code

Line 870: ,pa_fp_spread_calc_tmp tmp2

866: AND NVL(tmp1.txn_curr_code_override,tmp1.txn_currency_code) = tmp.txn_currency_code
867: )
868: WHERE tmp.budget_version_id = p_budget_version_id
869: AND EXISTS (select null from pa_resource_asgn_curr rtx2
870: ,pa_fp_spread_calc_tmp tmp2
871: where rtx2.resource_assignment_id = tmp.resource_assignment_id
872: and rtx2.txn_currency_code = tmp.txn_currency_code
873: AND tmp2.resource_assignment_id = tmp.resource_assignment_id
874: AND NVL(tmp2.txn_curr_code_override,tmp2.txn_currency_code) = tmp.txn_currency_code

Line 961: FROM pa_fp_spread_calc_tmp tmp

957: SELECT 1 ra_txn_id
958: ,p_budget_version_id
959: ,tmp.resource_assignment_id
960: ,tmp.txn_currency_code
961: FROM pa_fp_spread_calc_tmp tmp
962: WHERE tmp.budget_version_id = p_budget_version_id
963: AND tmp.resource_assignment_id = NVL(p_resource_assignment_id,tmp.resource_assignment_id)
964: AND tmp.txn_currency_code = NVL(p_txn_currency_code,tmp.txn_currency_code)
965: AND NVL(tmp.start_date,trunc(sysdate)) = NVL(p_start_date,nvl(tmp.start_date,trunc(sysdate)))

Line 1045: ,pa_fp_spread_calc_tmp tmp1) LOOP

1041: ,tmp1.cost_rate_override tmpCostRt
1042: ,tmp1.burden_cost_rate_override tmpBurdRt
1043: ,tmp1.bill_rate_override tmpBillRt
1044: from pa_resource_asgn_curr_tmp tmp
1045: ,pa_fp_spread_calc_tmp tmp1) LOOP
1046: print_msg('Rates in Tmp Table CostRt['|| c.costRt||']BurdRt['||c.burdRt||']BillRt['||c.billRt||']');
1047: print_msg('Rates in SpCalcTmp Table tmpCostRt['|| c.tmpcostRt||']tmpBurdRt['||c.tmpburdRt||']tmpBillRt['||c.tmpbillRt||']');
1048: end loop;
1049: */

Line 1066: FROM pa_fp_spread_calc_tmp tmp

1062: ,p_budget_version_id
1063: ,tmp.resource_assignment_id
1064: ,tmp.txn_currency_code
1065: ,'Y'
1066: FROM pa_fp_spread_calc_tmp tmp
1067: WHERE tmp.budget_version_id = p_budget_version_id
1068: AND tmp.txn_curr_code_override is NOT NULL
1069: AND tmp.txn_curr_code_override <> tmp.txn_currency_code;
1070: l_rowCount1 := sql%Rowcount;

Line 1173: ,pa_fp_spread_calc_tmp tmp1

1169: ,0,NULL,nvl(tmp.bill_rate_override,rax.txn_bill_rate_override))
1170: ,nvl(tmp.bill_rate_override,rax.txn_bill_rate_override))
1171: ,nvl(tmp.bill_rate_override,rax.txn_bill_rate_override)))))))
1172: FROM pa_resource_asgn_curr rax
1173: ,pa_fp_spread_calc_tmp tmp1
1174: WHERE rax.resource_assignment_id = tmp.resource_assignment_id
1175: AND rax.txn_currency_code = tmp.txn_currency_code
1176: AND tmp1.resource_assignment_id = rax.resource_assignment_id
1177: AND tmp1.txn_currency_code = rax.txn_currency_code

Line 1187: ,pa_fp_spread_calc_tmp tmp2

1183: )
1184: WHERE tmp.budget_version_id = p_budget_version_id
1185: AND EXISTS (select /*+ INDEX(RAX1 PA_RESOURCE_ASGN_CURR_U2) */ null
1186: from pa_resource_asgn_curr rax1
1187: ,pa_fp_spread_calc_tmp tmp2
1188: where rax1.resource_assignment_id = tmp.resource_assignment_id
1189: and rax1.txn_currency_code = tmp.txn_currency_code
1190: and tmp2.resource_assignment_id = rax1.resource_assignment_id
1191: and tmp2.txn_currency_code = rax1.txn_currency_code

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

1518:
1519: --INITIALIZATION--
1520: DELETE FROM pa_fp_res_assignments_tmp;
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

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

1549: END IF;
1550: null;
1551: END IF;
1552:
1553: DELETE FROM pa_fp_spread_calc_tmp2;
1554: g_sprd_raId_tab.delete;
1555: g_sprd_txn_cur_tab.delete;
1556: g_sprd_sdate_tab.delete;
1557: g_sprd_edate_tab.delete;

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

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
2028: WHERE tmp.resource_assignment_id = tmp1.resource_assignment_id
2029: AND ROWNUM = 1
2030: )
2031: WHERE tmp1.budget_version_id = p_budget_version_id

Line 2033: FROM pa_fp_spread_calc_tmp otmp

2029: AND ROWNUM = 1
2030: )
2031: WHERE tmp1.budget_version_id = p_budget_version_id
2032: AND EXISTS (select null
2033: FROM pa_fp_spread_calc_tmp otmp
2034: WHERE otmp.resource_assignment_id = tmp1.resource_assignment_id
2035: );
2036: If P_PA_DEBUG_MODE = 'Y' Then
2037: print_msg('Number of rows updated for ratebasedFlag for Pjirollup['||sql%rowcount||']');

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

3330: ,decode(sign(nvl(ra.sp_fixed_date,p_etc_start_date) - p_etc_start_date),-1,p_etc_start_date,ra.planning_end_date)
3331: ,decode(sign(ra.planning_end_date-p_etc_start_date),-1,p_etc_start_date,ra.planning_end_date))
3332: WHERE ra.budget_version_id = p_budget_version_id
3333: AND EXISTS (SELECT null
3334: FROM pa_fp_spread_calc_tmp tmp
3335: WHERE tmp.budget_version_id = ra.budget_version_id
3336: AND tmp.resource_assignment_id = ra.resource_assignment_id);
3337: print_msg('Reset Ra sp curve, spfixeddate, and planEnddate: NumofRowsUpd['||sql%rowcount||']');
3338:

Line 3349: ,pa_fp_spread_calc_tmp tmp

3345: Where ra.resource_assignment_id = bl.resource_assignment_id)
3346: WHERE bl.budget_version_id = p_budget_version_id
3347: AND EXISTS ( SELECT 'Y'
3348: FROM pa_resource_assignments pra
3349: ,pa_fp_spread_calc_tmp tmp
3350: WHERE pra.resource_assignment_id = bl.resource_assignment_id
3351: AND pra.budget_version_id = bl.budget_version_id
3352: AND tmp.budget_version_id = pra.budget_version_id
3353: AND tmp.resource_assignment_id = pra.resource_assignment_id

Line 3386: FROM pa_fp_spread_calc_tmp tmp

3382: ) IS
3383:
3384: CURSOR cur_spbl_chk IS
3385: SELECT tmp.resource_assignment_id
3386: FROM pa_fp_spread_calc_tmp tmp
3387: ,pa_resource_assignments ra
3388: WHERE tmp.budget_version_id = p_budget_version_id
3389: AND tmp.resource_assignment_id = ra.resource_assignment_id
3390: AND NVL(tmp.sp_curve_change_flag,'N') = 'N'

Line 3455: ,pa_fp_spread_calc_tmp tmp

3451: ,bl.init_raw_cost
3452: ,bl.init_burdened_cost
3453: ,bl.init_revenue
3454: FROM pa_budget_lines bl
3455: ,pa_fp_spread_calc_tmp tmp
3456: WHERE tmp.budget_version_id = p_budget_version_id
3457: AND bl.budget_version_id = tmp.budget_version_id
3458: AND bl.resource_assignment_id = tmp.resource_assignment_id
3459: AND bl.txn_currency_code = tmp.txn_currency_code

Line 3781: ,pa_fp_spread_calc_tmp tmp

3777: ,bl.burden_rejection_code
3778: ,bl.pfc_cur_conv_rejection_code
3779: ,bl.pc_cur_conv_rejection_code
3780: FROM pa_budget_lines bl
3781: ,pa_fp_spread_calc_tmp tmp
3782: WHERE tmp.budget_version_id = p_budget_version_id
3783: AND bl.resource_assignment_id = tmp.resource_assignment_id
3784: AND bl.txn_currency_code = tmp.txn_currency_code
3785: AND bl.start_date < p_etc_start_date

Line 3828: ,pa_fp_spread_calc_tmp tmp

3824: ,bl.burden_rejection_code
3825: ,bl.pfc_cur_conv_rejection_code
3826: ,bl.pc_cur_conv_rejection_code
3827: FROM pa_budget_lines bl
3828: ,pa_fp_spread_calc_tmp tmp
3829: WHERE tmp.budget_version_id = p_budget_version_id
3830: AND bl.resource_assignment_id = tmp.resource_assignment_id
3831: AND bl.txn_currency_code = tmp.txn_currency_code
3832: AND bl.start_date < p_etc_start_date

Line 3877: ,pa_fp_spread_calc_tmp tmp

3873: ,bl.pfc_cur_conv_rejection_code
3874: ,bl.pc_cur_conv_rejection_code
3875: FROM pa_budget_lines bl
3876: ,pa_resource_assignments ra
3877: ,pa_fp_spread_calc_tmp tmp
3878: WHERE tmp.budget_version_id = p_budget_version_id
3879: AND bl.resource_assignment_id = tmp.resource_assignment_id
3880: AND bl.txn_currency_code = tmp.txn_currency_code
3881: AND ra.resource_assignment_id = tmp.resource_assignment_id

Line 4427: ,pa_fp_spread_calc_tmp tmp

4423: ,l_upd_burden_rejection_tab
4424: ,l_upd_pfc_cur_conv_rej_tab
4425: ,l_upd_pc_cur_conv_rej_tab
4426: FROM pa_budget_lines bl
4427: ,pa_fp_spread_calc_tmp tmp
4428: WHERE bl.budget_version_id = p_budget_version_id
4429: AND tmp.budget_version_id = bl.budget_version_id
4430: AND bl.resource_assignment_id = tmp.resource_assignment_id
4431: AND bl.txn_currency_code = tmp.txn_currency_code

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

4561: If P_PA_DEBUG_MODE = 'Y' Then
4562: print_msg('Number Of rowsUpdated['||g_plan_raId_tab.COUNT||']');
4563: End If;
4564: FORALL i IN g_plan_raId_tab.FIRST .. g_plan_raId_tab.LAST
4565: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ PA_FP_SPREAD_CALC_TMP tmp -- bug 4873834
4566: SET tmp.skip_record_flag = NVL(g_skip_record_tab(i),'N')
4567: ,tmp.processed_flag = NVL(g_process_skip_CstRevrec_tab(i),'N')
4568: ,tmp.REFRESH_RATES_FLAG = NVL(g_refresh_rates_tab(i),'N')
4569: ,tmp.REFRESH_CONV_RATES_FLAG = NVL(g_refresh_conv_rates_tab(i),'N')

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

4585: IF g_mfc_cost_refrsh_Raid_tab.COUNT > 0 THEN
4586: g_stage := 'Upd_spread_calc_tmp:101';
4587: --print_msg(g_stage);
4588: FORALL i IN g_mfc_cost_refrsh_Raid_tab.FIRST .. g_mfc_cost_refrsh_Raid_tab.LAST
4589: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ PA_FP_SPREAD_CALC_TMP tmp
4590: SET tmp.mfc_cost_refresh_flag = 'Y'
4591: ,tmp.REFRESH_RATES_FLAG = 'Y'
4592: WHERE tmp.budget_version_id = p_budget_version_id
4593: AND tmp.resource_assignment_id = g_mfc_cost_refrsh_Raid_tab(i)

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

4598: If g_sprd_raId_tab.COUNT > 0 Then
4599: g_stage := 'Upd_spread_calc_tmp:102';
4600: --print_msg(g_stage);
4601: FORALL i IN g_sprd_raId_tab.FIRST .. g_sprd_raId_tab.LAST
4602: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ PA_FP_SPREAD_CALC_TMP tmp
4603: SET tmp.cost_rate_override = decode(tmp.COST_RATE_G_MISS_NUM_FLAG,'Y',NULL
4604: ,NVL(g_sprd_costRt_Ovr_tab(i),tmp.cost_rate_override))
4605: ,tmp.burden_cost_rate_override = decode(tmp.burden_rate_g_miss_num_flag,'Y',NULL
4606: ,NVL(g_sprd_burdRt_Ovr_tab(i),tmp.burden_cost_rate_override))

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

4627: If P_PA_DEBUG_MODE = 'Y' Then
4628: print_msg('Updating spread calc tmp with rate overrides');
4629: End If;
4630: FORALL i IN g_rtChanged_RaId_tab.FIRST .. g_rtChanged_RaId_tab.LAST
4631: UPDATE /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP_N1) */ pa_fp_spread_calc_tmp tmp
4632: SET tmp.cost_rate_override = decode(NVL(g_rtChanged_cstMisNumFlg_tab(i),'N'),'Y',NULL
4633: ,NVL(g_rtChanged_CostRt_Tab(i),tmp.cost_rate_override))
4634: ,tmp.burden_cost_rate_override = decode(NVL(g_rtChanged_bdMisNumFlag_tab(i),'N'),'Y',NULL
4635: ,NVL(g_rtChanged_BurdRt_tab(i),tmp.burden_cost_rate_override))

Line 4745: ,pa_fp_spread_calc_tmp caltmp

4741: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4742: FROM pa_fp_rollup_tmp tmp
4743: ,pa_fp_gen_rate_tmp fptmp
4744: ,pa_resource_assignments ra
4745: ,pa_fp_spread_calc_tmp caltmp
4746: WHERE caltmp.budget_version_id = p_budget_version_id
4747: AND caltmp.resource_assignment_id = ra.resource_assignment_id
4748: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
4749: AND tmp.resource_assignment_id = ra.resource_assignment_id

Line 4781: ,pa_fp_spread_calc_tmp caltmp

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

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

5735: print_msg(to_char(l_stage)||'Entered PA_FP_CALC_PLAN_PKG.populate_rollup_tmp');
5736: End If;
5737: /*
5738: If P_PA_DEBUG_MODE = 'Y' Then
5739: for i in (select * from pa_fp_spread_calc_tmp ) LOOP
5740: print_msg('IN params ResId['||i.resource_assignment_id||']TxnCur['||i.txn_currency_code||']RefrFlag['||i.refresh_rates_flag||']');
5741: print_msg('RefrConvFlag['||i.refresh_conv_rates_flag||']gSprdFromDt['||g_spread_from_date||']gLnSD['||i.start_date||']');
5742: print_msg('gLineEnDate['||i.end_date||']massAdflag['||i.mass_adjust_flag||']mfcCstFlag['||i.mfc_cost_refresh_flag||']skipFlag['||i.skip_record_flag||']');
5743: end loop;

Line 6092: ,pa_fp_spread_calc_tmp tmp

6088: ,decode(nvl(ra.rate_based_flag,'N'),'Y','N'
6089: ,'N',decode(bl.txn_cost_rate_override,0,'Y','N'))))
6090: FROM pa_budget_lines bl
6091: ,pa_resource_assignments ra
6092: ,pa_fp_spread_calc_tmp tmp
6093: WHERE tmp.budget_version_id = p_budget_version_id
6094: AND (NVL(tmp.refresh_rates_flag,'N') in ('Y','R','C')
6095: OR NVL(tmp.refresh_conv_rates_flag,'N') = 'Y'
6096: OR NVL(tmp.mass_adjust_flag,'N') = 'Y'

Line 6137: FROM pa_fp_spread_calc_tmp caltmp

6133: ,decode(caltmp.txn_curr_code_override,NULL,decode(caltmp.mfc_cost_change_flag,'Y',caltmp.burden_cost_rate_override
6134: ,tmp.burden_cost_rate_override),caltmp.burden_cost_rate_override)
6135: ,decode(caltmp.txn_curr_code_override,NULL,decode(caltmp.mfc_cost_change_flag,'Y',caltmp.bill_rate_override
6136: ,tmp.bill_rate_override),caltmp.bill_rate_override)
6137: FROM pa_fp_spread_calc_tmp caltmp
6138: WHERE caltmp.budget_version_id = tmp.budget_version_id
6139: AND caltmp.resource_assignment_id = tmp.resource_assignment_id
6140: AND caltmp.txn_currency_code = tmp.txn_currency_code
6141: AND NVL(caltmp.skip_record_flag,'N') <> 'Y'

Line 6149: FROM pa_fp_spread_calc_tmp caltmp

6145: AND NVL(caltmp.mfc_cost_refresh_flag,'N') = 'Y'
6146: ))
6147: WHERE tmp.budget_version_id = p_budget_version_id
6148: AND EXISTS ( select null
6149: FROM pa_fp_spread_calc_tmp caltmp
6150: WHERE caltmp.budget_version_id = tmp.budget_version_id
6151: AND caltmp.resource_assignment_id = tmp.resource_assignment_id
6152: AND caltmp.txn_currency_code = tmp.txn_currency_code
6153: AND NVL(caltmp.skip_record_flag,'N') <> 'Y'

Line 6191: FROM pa_fp_spread_calc_tmp caltmp

6187: ,NVL(g_rtChanged_BurdRt_tab(i),tmp.burden_cost_rate_override)))
6188: ,NVL(g_rtChanged_BurdRt_tab(i),tmp.burden_cost_rate_override))))
6189: ,decode(NVL(g_rtChanged_blMisNumFlag_tab(i),'N'),'Y',NULL
6190: ,NVL(g_rtChanged_billRt_tab(i),tmp.bill_rate_override))
6191: FROM pa_fp_spread_calc_tmp caltmp
6192: WHERE caltmp.resource_assignment_id = tmp.resource_assignment_id
6193: AND caltmp.txn_currency_code = tmp.txn_currency_code
6194: AND ((g_source_context <> 'BUDGET_LINE')
6195: OR

Line 6322: ,pa_fp_spread_calc_tmp caltmp

6318: ,decode(NVL(tmp.rate_based_flag,'N'),'Y',0
6319: ,(sum(nvl(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))))) RndRevenue
6320: ,to_number(null) RevenueDiff
6321: FROM pa_fp_rollup_tmp tmp
6322: ,pa_fp_spread_calc_tmp caltmp
6323: WHERE caltmp.budget_version_id = p_budget_version_id
6324: AND caltmp.resource_assignment_id = tmp.resource_assignment_id
6325: AND tmp.txn_currency_code = caltmp.txn_currency_code
6326: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'

Line 6384: from pa_fp_spread_calc_tmp caltmp

6380: * ((l_burdened_rate_adj_pct + 100)/100))
6381: )
6382: WHERE tmp.budget_version_id = p_budget_version_id
6383: AND EXISTS ( select null
6384: from pa_fp_spread_calc_tmp caltmp
6385: WHERE caltmp.resource_assignment_id = tmp.resource_assignment_id
6386: AND caltmp.txn_currency_code = tmp.txn_currency_code
6387: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
6388: AND nvl(caltmp.mass_adjust_flag,'N') = 'Y'

Line 6449: from pa_fp_spread_calc_tmp caltmp

6445: ,(nvl(tmp.bill_rate_override,tmp.bill_rate) * ((l_bill_rate_adj_pct + 100)/100))))
6446: ))
6447: WHERE tmp.budget_version_id = p_budget_version_id
6448: AND EXISTS ( select null
6449: from pa_fp_spread_calc_tmp caltmp
6450: WHERE caltmp.resource_assignment_id = tmp.resource_assignment_id
6451: AND caltmp.txn_currency_code = tmp.txn_currency_code
6452: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
6453: AND nvl(caltmp.mass_adjust_flag,'N') = 'Y'

Line 6534: from pa_fp_spread_calc_tmp caltmp

6530: ,(NVL(tmp.rw_cost_rate_override,tmp.cost_rate)
6531: * ((l_raw_cost_adj_pct + 100)/100))))))
6532: WHERE tmp.budget_version_id = p_budget_version_id
6533: AND EXISTS ( select null
6534: from pa_fp_spread_calc_tmp caltmp
6535: WHERE caltmp.resource_assignment_id = tmp.resource_assignment_id
6536: AND caltmp.txn_currency_code = tmp.txn_currency_code
6537: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'
6538: AND nvl(caltmp.mass_adjust_flag,'N') = 'Y' );

Line 6752: FROM pa_fp_spread_calc_tmp tmp

6748: ,DECODE(sum(pbl.project_init_revenue),0,NULL,sum(pbl.project_init_revenue)) project_init_revenue
6749: FROM pa_budget_lines pbl
6750: WHERE pbl.budget_version_id = p_budget_version_id
6751: AND EXISTS (SELECT NULL
6752: FROM pa_fp_spread_calc_tmp tmp
6753: WHERE tmp.budget_version_id = p_budget_version_id
6754: AND tmp.resource_assignment_id = pbl.resource_assignment_id
6755: )
6756: GROUP BY pbl.resource_assignment_id;

Line 6794: FROM pa_fp_spread_calc_tmp tmp

6790: ,ra.last_updated_by = l_user_id
6791: ,ra.last_update_date = sysdate
6792: ,ra.last_update_login = l_login_id
6793: WHERE EXISTS (SELECT NULL
6794: FROM pa_fp_spread_calc_tmp tmp
6795: WHERE tmp.budget_version_id = p_budget_version_id
6796: AND tmp.resource_assignment_id = ra.resource_assignment_id
6797: /* Bug fix: 4322568 AND NVL(tmp.skip_record_flag,'N') = 'Y' */
6798: );

Line 7562: from pa_fp_spread_calc_tmp tmp1

7558: */
7559: cursor cur_nullBls is
7560: select tmp1.resource_assignment_id
7561: ,tmp1.txn_currency_code
7562: from pa_fp_spread_calc_tmp tmp1
7563: ,pa_resource_assignments ra
7564: where tmp1.budget_version_id = p_budget_version_id
7565: and ra.resource_assignment_id = tmp1.resource_assignment_id
7566: and NVL(ra.rate_based_flag,'N') = 'N'

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:

Line 9603: ,pa_fp_spread_calc_tmp tmp

9599: ,l_curr_bill_rate
9600: ,l_curr_markup_percentage
9601: ,l_curr_cost_rate
9602: FROM pa_resource_asgn_curr rtx
9603: ,pa_fp_spread_calc_tmp tmp
9604: WHERE tmp.resource_assignment_id = l_resource_assignment_id
9605: AND tmp.txn_currency_code = l_txn_currency_code
9606: AND rtx.resource_assignment_id = tmp.resource_assignment_id
9607: AND rtx.txn_currency_code = tmp.txn_currency_code;

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

11570: p_project_id Number;
11571: p_task_id Number;
11572:
11573: CURSOR cur_calcTmp IS
11574: SELECT /*+ INDEX(CALTMP PA_FP_SPREAD_CALC_TMP_N1) */ caltmp.resource_assignment_id
11575: ,caltmp.txn_currency_code
11576: ,caltmp.start_date
11577: ,caltmp.end_date
11578: ,caltmp.txn_curr_code_override

Line 11587: FROM pa_fp_spread_calc_tmp caltmp

11583: ,NVL(ra.rate_based_flag,'N') rate_based_flag
11584: ,caltmp.task_name
11585: ,caltmp.resource_name
11586: ,caltmp.billable_flag
11587: FROM pa_fp_spread_calc_tmp caltmp
11588: ,pa_resource_assignments ra
11589: WHERE caltmp.budget_version_id = p_budget_version_id
11590: AND caltmp.resource_assignment_id = ra.resource_assignment_id
11591: AND ( NVL(caltmp.skip_record_flag,'N') <> 'Y'

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

15575: pa_debug.init_err_stack('PA_FP_CALC_PLAN_PKG.Process_skipped_records');
15576: End If;
15577: /***
15578: If P_PA_DEBUG_MODE = 'Y' Then
15579: for i in (select * from pa_fp_spread_calc_tmp ) LOOP
15580: print_msg('IN params ResId['||i.resource_assignment_id||']TxnCur['||i.txn_currency_code||']RefrFlag['||i.refresh_rates_flag||']');
15581: print_msg('RefrConvFlag['||i.refresh_conv_rates_flag||']gSprdFromDt['||g_spread_from_date||']gLnSD['||i.start_date||']');
15582: print_msg('gLineEnDate['||i.end_date||']massAdflag['||i.mass_adjust_flag||']mfcCstFlag['||i.mfc_cost_refresh_flag||']skipFlag['||i.skip_record_flag||']');
15583: end loop;

Line 15709: ,pa_fp_spread_calc_tmp tmp

15705: ,bl.project_init_revenue
15706: ,tmp.billable_flag
15707: FROM pa_budget_lines bl
15708: ,pa_resource_assignments ra
15709: ,pa_fp_spread_calc_tmp tmp
15710: ,pa_fp_rollup_tmp rlp --Bug 5203868
15711: WHERE tmp.budget_version_id = p_budget_version_id
15712: AND tmp.resource_assignment_id = ra.resource_assignment_id
15713: AND bl.resource_assignment_id = tmp.resource_assignment_id