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_RESOURCE_ASGN_CURR_TMP

Line 649: DELETE FROM pa_resource_asgn_curr_tmp;

645: END clear_etc_rev_other_rejectns;
646:
647: PROCEDURE delete_raTxn_Tmp IS
648: BEGIN
649: DELETE FROM pa_resource_asgn_curr_tmp;
650: END delete_raTxn_Tmp;
651:
652: PROCEDURE print_rlTmp_Values IS
653:

Line 764: --print_msg('Inserting records into pa_resource_asgn_curr_tmp for Refresh rates action');

760: x_return_status := 'S';
761: IF NVL(p_delete_flag,'N') = 'N' Then
762: IF p_source_context = 'RESOURCE_ASSIGNMENT' Then
763: If NVL(p_refresh_rate_flag,'N') = 'Y' Then --{
764: --print_msg('Inserting records into pa_resource_asgn_curr_tmp for Refresh rates action');
765: INSERT INTO pa_resource_asgn_curr_tmp raTxn
766: (RA_TXN_ID
767: ,BUDGET_VERSION_ID
768: ,RESOURCE_ASSIGNMENT_ID

Line 765: INSERT INTO pa_resource_asgn_curr_tmp raTxn

761: IF NVL(p_delete_flag,'N') = 'N' Then
762: IF p_source_context = 'RESOURCE_ASSIGNMENT' Then
763: If NVL(p_refresh_rate_flag,'N') = 'Y' Then --{
764: --print_msg('Inserting records into pa_resource_asgn_curr_tmp for Refresh rates action');
765: INSERT INTO pa_resource_asgn_curr_tmp raTxn
766: (RA_TXN_ID
767: ,BUDGET_VERSION_ID
768: ,RESOURCE_ASSIGNMENT_ID
769: ,TXN_CURRENCY_CODE

Line 827: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from spcalctmp tabls');

823: --print_msg('Return Status of the api ['||x_return_status||']');
824: End If;
825:
826: Else
827: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from spcalctmp tabls');
828: INSERT INTO pa_resource_asgn_curr_tmp
829: (RA_TXN_ID
830: ,BUDGET_VERSION_ID
831: ,RESOURCE_ASSIGNMENT_ID

Line 828: INSERT INTO pa_resource_asgn_curr_tmp

824: End If;
825:
826: Else
827: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from spcalctmp tabls');
828: INSERT INTO pa_resource_asgn_curr_tmp
829: (RA_TXN_ID
830: ,BUDGET_VERSION_ID
831: ,RESOURCE_ASSIGNMENT_ID
832: ,TXN_CURRENCY_CODE

Line 862: --print_msg('Updating pa_resource_asgn_curr_tmp to set rate overrides derived during calculate');

858: --print_msg('Number of records inserted ['||l_rowCount||']');
859: If l_rowCount > 0 Then
860: /* The following update is required with current logic of the
861: * new maintain entity which always blows out the records and inserts new records */
862: --print_msg('Updating pa_resource_asgn_curr_tmp to set rate overrides derived during calculate');
863: UPDATE pa_resource_asgn_curr_tmp tmp
864: SET (tmp.TXN_RAW_COST_RATE_OVERRIDE
865: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE
866: ,tmp.TXN_BILL_RATE_OVERRIDE) =

Line 863: UPDATE pa_resource_asgn_curr_tmp tmp

859: If l_rowCount > 0 Then
860: /* The following update is required with current logic of the
861: * new maintain entity which always blows out the records and inserts new records */
862: --print_msg('Updating pa_resource_asgn_curr_tmp to set rate overrides derived during calculate');
863: UPDATE pa_resource_asgn_curr_tmp tmp
864: SET (tmp.TXN_RAW_COST_RATE_OVERRIDE
865: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE
866: ,tmp.TXN_BILL_RATE_OVERRIDE) =
867: (SELECT decode(tmp1.cost_rate_g_miss_num_flag,'Y',NULL

Line 894: g_stage := 'update pa_resource_asgn_curr_tmp with OvrRts';

890:
891: /* If only rates are changed then update the changed override rates on rollup tmp and avoid calling spread
892: * and call rate api */
893: IF g_rtChanged_RaId_tab.COUNT > 0 Then
894: g_stage := 'update pa_resource_asgn_curr_tmp with OvrRts';
895: --print_msg(g_stage);
896: FORALL i IN g_rtChanged_RaId_tab.FIRST .. g_rtChanged_RaId_tab.LAST
897: UPDATE pa_resource_asgn_curr_tmp tmp
898: SET tmp.TXN_RAW_COST_RATE_OVERRIDE = decode(NVL(g_rtChanged_cstMisNumFlg_tab(i),'N'),'Y',NULL

Line 897: UPDATE pa_resource_asgn_curr_tmp tmp

893: IF g_rtChanged_RaId_tab.COUNT > 0 Then
894: g_stage := 'update pa_resource_asgn_curr_tmp with OvrRts';
895: --print_msg(g_stage);
896: FORALL i IN g_rtChanged_RaId_tab.FIRST .. g_rtChanged_RaId_tab.LAST
897: UPDATE pa_resource_asgn_curr_tmp tmp
898: SET tmp.TXN_RAW_COST_RATE_OVERRIDE = decode(NVL(g_rtChanged_cstMisNumFlg_tab(i),'N'),'Y',NULL
899: ,NVL(g_rtChanged_CostRt_Tab(i),tmp.TXN_RAW_COST_RATE_OVERRIDE))
900: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE = decode(NVL(g_rtChanged_bdMisNumFlag_tab(i),'N'),'Y',NULL
901: ,NVL(g_rtChanged_BurdRt_tab(i),tmp.TXN_BURDEN_COST_RATE_OVERRIDE))

Line 925: FROM pa_resource_asgn_curr_tmp tmp

921: ,rtx.TXN_BILL_RATE_OVERRIDE) =
922: (SELECT tmp.TXN_RAW_COST_RATE_OVERRIDE
923: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE
924: ,tmp.TXN_BILL_RATE_OVERRIDE
925: FROM pa_resource_asgn_curr_tmp tmp
926: WHERE tmp.resource_assignment_id = rtx.resource_assignment_id
927: AND tmp.txn_currency_code = rtx.txn_currency_code
928: )
929: WHERE rtx.budget_version_id = p_budget_version_id

Line 931: from pa_resource_asgn_curr_tmp tmp1

927: AND tmp.txn_currency_code = rtx.txn_currency_code
928: )
929: WHERE rtx.budget_version_id = p_budget_version_id
930: AND EXISTS ( select null
931: from pa_resource_asgn_curr_tmp tmp1
932: where tmp1.resource_assignment_id = rtx.resource_assignment_id
933: and tmp1.txn_currency_code = rtx.txn_currency_code
934: );
935: End If;

Line 941: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup Tmp for BUDGET_LINE context');

937:
938: Else
939: --BUDGET_LINE CONTEXT
940: If NVL(p_calling_mode,'XXX') NOT IN ('CLEAR_CLOSED_PERIOD','RES_ATTRB_CHANGE','DELETE_BL') Then
941: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup Tmp for BUDGET_LINE context');
942: INSERT INTO pa_resource_asgn_curr_tmp raTxn
943: (RA_TXN_ID
944: ,BUDGET_VERSION_ID
945: ,RESOURCE_ASSIGNMENT_ID

Line 942: INSERT INTO pa_resource_asgn_curr_tmp raTxn

938: Else
939: --BUDGET_LINE CONTEXT
940: If NVL(p_calling_mode,'XXX') NOT IN ('CLEAR_CLOSED_PERIOD','RES_ATTRB_CHANGE','DELETE_BL') Then
941: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup Tmp for BUDGET_LINE context');
942: INSERT INTO pa_resource_asgn_curr_tmp raTxn
943: (RA_TXN_ID
944: ,BUDGET_VERSION_ID
945: ,RESOURCE_ASSIGNMENT_ID
946: ,TXN_CURRENCY_CODE

Line 962: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from sptmp for periodic deletion');

958: --print_msg('Number of records inserted ['||l_rowCount||']');
959: End If;
960:
961: IF NVL(p_calling_mode,'XXX') IN ('CLEAR_CLOSED_PERIOD','RES_ATTRB_CHANGE','DELETE_BL') and l_rowCount = 0 Then
962: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from sptmp for periodic deletion');
963: INSERT INTO pa_resource_asgn_curr_tmp raTxn
964: (RA_TXN_ID
965: ,BUDGET_VERSION_ID
966: ,RESOURCE_ASSIGNMENT_ID

Line 963: INSERT INTO pa_resource_asgn_curr_tmp raTxn

959: End If;
960:
961: IF NVL(p_calling_mode,'XXX') IN ('CLEAR_CLOSED_PERIOD','RES_ATTRB_CHANGE','DELETE_BL') and l_rowCount = 0 Then
962: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from sptmp for periodic deletion');
963: INSERT INTO pa_resource_asgn_curr_tmp raTxn
964: (RA_TXN_ID
965: ,BUDGET_VERSION_ID
966: ,RESOURCE_ASSIGNMENT_ID
967: ,TXN_CURRENCY_CODE

Line 995: UPDATE pa_resource_asgn_curr_tmp tmp

991:
992: If l_rowCount > 0 Then
993: /* The following update is required with current logic of the
994: * new maintain entity which always blows out the records and inserts new records */
995: UPDATE pa_resource_asgn_curr_tmp tmp
996: SET (tmp.TXN_RAW_COST_RATE_OVERRIDE
997: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE
998: ,tmp.TXN_BILL_RATE_OVERRIDE) =
999: (SELECT rtx.TXN_RAW_COST_RATE_OVERRIDE

Line 1030: UPDATE pa_resource_asgn_curr_tmp

1026: l_txn_currency_code
1027: FROM pa_fp_rollup_tmp
1028: WHERE rowid=gl_cl_roll_up_tmp_rowid_tab(zz);
1029:
1030: UPDATE pa_resource_asgn_curr_tmp
1031: SET txn_raw_cost_rate_override = NVL(l_rw_cost_rate_override,txn_raw_cost_rate_override),
1032: txn_burden_cost_rate_override = NVL(l_burden_cost_rate_override,txn_burden_cost_rate_override),
1033: txn_bill_rate_override = NVL(l_bill_rate_override,txn_bill_rate_override)
1034: WHERE resource_assignment_id = l_ra_id

Line 1046: DELETE FROM pa_resource_asgn_curr_tmp;

1042: --End for Bug 6781055.
1043: End If;
1044: ElsIf p_delete_flag = 'Y' Then
1045: /* when rollup is not required just delete from tmp table */
1046: DELETE FROM pa_resource_asgn_curr_tmp;
1047: END IF;
1048:
1049: /* only for debug purpose
1050: for c in (select tmp.TXN_RAW_COST_RATE_OVERRIDE costRt

Line 1056: from pa_resource_asgn_curr_tmp tmp

1052: ,tmp.TXN_BILL_RATE_OVERRIDE BillRt
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;

Line 1065: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup for Override currency code');

1061: */
1062:
1063: /* When override currency is passed, then delete the records from new entity for the old currency */
1064: If p_source_context = 'RESOURCE_ASSIGNMENT' and NVL(p_refresh_rate_flag,'N') = 'N' Then
1065: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup for Override currency code');
1066: INSERT INTO pa_resource_asgn_curr_tmp raTxn
1067: (RA_TXN_ID
1068: ,BUDGET_VERSION_ID
1069: ,RESOURCE_ASSIGNMENT_ID

Line 1066: INSERT INTO pa_resource_asgn_curr_tmp raTxn

1062:
1063: /* When override currency is passed, then delete the records from new entity for the old currency */
1064: If p_source_context = 'RESOURCE_ASSIGNMENT' and NVL(p_refresh_rate_flag,'N') = 'N' Then
1065: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup for Override currency code');
1066: INSERT INTO pa_resource_asgn_curr_tmp raTxn
1067: (RA_TXN_ID
1068: ,BUDGET_VERSION_ID
1069: ,RESOURCE_ASSIGNMENT_ID
1070: ,TXN_CURRENCY_CODE

Line 1553: DELETE FROM pa_resource_asgn_curr_tmp;

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
1557: