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 752: --print_msg('Inserting records into pa_resource_asgn_curr_tmp for Refresh rates action');

748: x_return_status := 'S';
749: IF NVL(p_delete_flag,'N') = 'N' Then
750: IF p_source_context = 'RESOURCE_ASSIGNMENT' Then
751: If NVL(p_refresh_rate_flag,'N') = 'Y' Then --{
752: --print_msg('Inserting records into pa_resource_asgn_curr_tmp for Refresh rates action');
753: INSERT INTO pa_resource_asgn_curr_tmp raTxn
754: (RA_TXN_ID
755: ,BUDGET_VERSION_ID
756: ,RESOURCE_ASSIGNMENT_ID

Line 753: INSERT INTO pa_resource_asgn_curr_tmp raTxn

749: IF NVL(p_delete_flag,'N') = 'N' Then
750: IF p_source_context = 'RESOURCE_ASSIGNMENT' Then
751: If NVL(p_refresh_rate_flag,'N') = 'Y' Then --{
752: --print_msg('Inserting records into pa_resource_asgn_curr_tmp for Refresh rates action');
753: INSERT INTO pa_resource_asgn_curr_tmp raTxn
754: (RA_TXN_ID
755: ,BUDGET_VERSION_ID
756: ,RESOURCE_ASSIGNMENT_ID
757: ,TXN_CURRENCY_CODE

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

811: --print_msg('Return Status of the api ['||x_return_status||']');
812: End If;
813:
814: Else
815: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from spcalctmp tabls');
816: INSERT INTO pa_resource_asgn_curr_tmp
817: (RA_TXN_ID
818: ,BUDGET_VERSION_ID
819: ,RESOURCE_ASSIGNMENT_ID

Line 816: INSERT INTO pa_resource_asgn_curr_tmp

812: End If;
813:
814: Else
815: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from spcalctmp tabls');
816: INSERT INTO pa_resource_asgn_curr_tmp
817: (RA_TXN_ID
818: ,BUDGET_VERSION_ID
819: ,RESOURCE_ASSIGNMENT_ID
820: ,TXN_CURRENCY_CODE

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

846: --print_msg('Number of records inserted ['||l_rowCount||']');
847: If l_rowCount > 0 Then
848: /* The following update is required with current logic of the
849: * new maintain entity which always blows out the records and inserts new records */
850: --print_msg('Updating pa_resource_asgn_curr_tmp to set rate overrides derived during calculate');
851: UPDATE pa_resource_asgn_curr_tmp tmp
852: SET (tmp.TXN_RAW_COST_RATE_OVERRIDE
853: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE
854: ,tmp.TXN_BILL_RATE_OVERRIDE) =

Line 851: UPDATE pa_resource_asgn_curr_tmp tmp

847: If l_rowCount > 0 Then
848: /* The following update is required with current logic of the
849: * new maintain entity which always blows out the records and inserts new records */
850: --print_msg('Updating pa_resource_asgn_curr_tmp to set rate overrides derived during calculate');
851: UPDATE pa_resource_asgn_curr_tmp tmp
852: SET (tmp.TXN_RAW_COST_RATE_OVERRIDE
853: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE
854: ,tmp.TXN_BILL_RATE_OVERRIDE) =
855: (SELECT decode(tmp1.cost_rate_g_miss_num_flag,'Y',NULL

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

878:
879: /* If only rates are changed then update the changed override rates on rollup tmp and avoid calling spread
880: * and call rate api */
881: IF g_rtChanged_RaId_tab.COUNT > 0 Then
882: g_stage := 'update pa_resource_asgn_curr_tmp with OvrRts';
883: --print_msg(g_stage);
884: FORALL i IN g_rtChanged_RaId_tab.FIRST .. g_rtChanged_RaId_tab.LAST
885: UPDATE pa_resource_asgn_curr_tmp tmp
886: SET tmp.TXN_RAW_COST_RATE_OVERRIDE = decode(NVL(g_rtChanged_cstMisNumFlg_tab(i),'N'),'Y',NULL

Line 885: UPDATE pa_resource_asgn_curr_tmp tmp

881: IF g_rtChanged_RaId_tab.COUNT > 0 Then
882: g_stage := 'update pa_resource_asgn_curr_tmp with OvrRts';
883: --print_msg(g_stage);
884: FORALL i IN g_rtChanged_RaId_tab.FIRST .. g_rtChanged_RaId_tab.LAST
885: UPDATE pa_resource_asgn_curr_tmp tmp
886: SET tmp.TXN_RAW_COST_RATE_OVERRIDE = decode(NVL(g_rtChanged_cstMisNumFlg_tab(i),'N'),'Y',NULL
887: ,NVL(g_rtChanged_CostRt_Tab(i),tmp.TXN_RAW_COST_RATE_OVERRIDE))
888: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE = decode(NVL(g_rtChanged_bdMisNumFlag_tab(i),'N'),'Y',NULL
889: ,NVL(g_rtChanged_BurdRt_tab(i),tmp.TXN_BURDEN_COST_RATE_OVERRIDE))

Line 913: FROM pa_resource_asgn_curr_tmp tmp

909: ,rtx.TXN_BILL_RATE_OVERRIDE) =
910: (SELECT tmp.TXN_RAW_COST_RATE_OVERRIDE
911: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE
912: ,tmp.TXN_BILL_RATE_OVERRIDE
913: FROM pa_resource_asgn_curr_tmp tmp
914: WHERE tmp.resource_assignment_id = rtx.resource_assignment_id
915: AND tmp.txn_currency_code = rtx.txn_currency_code
916: )
917: WHERE rtx.budget_version_id = p_budget_version_id

Line 919: from pa_resource_asgn_curr_tmp tmp1

915: AND tmp.txn_currency_code = rtx.txn_currency_code
916: )
917: WHERE rtx.budget_version_id = p_budget_version_id
918: AND EXISTS ( select null
919: from pa_resource_asgn_curr_tmp tmp1
920: where tmp1.resource_assignment_id = rtx.resource_assignment_id
921: and tmp1.txn_currency_code = rtx.txn_currency_code
922: );
923: End If;

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

925:
926: Else
927: --BUDGET_LINE CONTEXT
928: If NVL(p_calling_mode,'XXX') NOT IN ('CLEAR_CLOSED_PERIOD','RES_ATTRB_CHANGE','DELETE_BL') Then
929: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup Tmp for BUDGET_LINE context');
930: INSERT INTO pa_resource_asgn_curr_tmp raTxn
931: (RA_TXN_ID
932: ,BUDGET_VERSION_ID
933: ,RESOURCE_ASSIGNMENT_ID

Line 930: INSERT INTO pa_resource_asgn_curr_tmp raTxn

926: Else
927: --BUDGET_LINE CONTEXT
928: If NVL(p_calling_mode,'XXX') NOT IN ('CLEAR_CLOSED_PERIOD','RES_ATTRB_CHANGE','DELETE_BL') Then
929: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup Tmp for BUDGET_LINE context');
930: INSERT INTO pa_resource_asgn_curr_tmp raTxn
931: (RA_TXN_ID
932: ,BUDGET_VERSION_ID
933: ,RESOURCE_ASSIGNMENT_ID
934: ,TXN_CURRENCY_CODE

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

946: --print_msg('Number of records inserted ['||l_rowCount||']');
947: End If;
948:
949: IF NVL(p_calling_mode,'XXX') IN ('CLEAR_CLOSED_PERIOD','RES_ATTRB_CHANGE','DELETE_BL') and l_rowCount = 0 Then
950: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from sptmp for periodic deletion');
951: INSERT INTO pa_resource_asgn_curr_tmp raTxn
952: (RA_TXN_ID
953: ,BUDGET_VERSION_ID
954: ,RESOURCE_ASSIGNMENT_ID

Line 951: INSERT INTO pa_resource_asgn_curr_tmp raTxn

947: End If;
948:
949: IF NVL(p_calling_mode,'XXX') IN ('CLEAR_CLOSED_PERIOD','RES_ATTRB_CHANGE','DELETE_BL') and l_rowCount = 0 Then
950: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from sptmp for periodic deletion');
951: INSERT INTO pa_resource_asgn_curr_tmp raTxn
952: (RA_TXN_ID
953: ,BUDGET_VERSION_ID
954: ,RESOURCE_ASSIGNMENT_ID
955: ,TXN_CURRENCY_CODE

Line 983: UPDATE pa_resource_asgn_curr_tmp tmp

979:
980: If l_rowCount > 0 Then
981: /* The following update is required with current logic of the
982: * new maintain entity which always blows out the records and inserts new records */
983: UPDATE pa_resource_asgn_curr_tmp tmp
984: SET (tmp.TXN_RAW_COST_RATE_OVERRIDE
985: ,tmp.TXN_BURDEN_COST_RATE_OVERRIDE
986: ,tmp.TXN_BILL_RATE_OVERRIDE) =
987: (SELECT rtx.TXN_RAW_COST_RATE_OVERRIDE

Line 1018: UPDATE pa_resource_asgn_curr_tmp

1014: l_txn_currency_code
1015: FROM pa_fp_rollup_tmp
1016: WHERE rowid=gl_cl_roll_up_tmp_rowid_tab(zz);
1017:
1018: UPDATE pa_resource_asgn_curr_tmp
1019: SET txn_raw_cost_rate_override = NVL(l_rw_cost_rate_override,txn_raw_cost_rate_override),
1020: txn_burden_cost_rate_override = NVL(l_burden_cost_rate_override,txn_burden_cost_rate_override),
1021: txn_bill_rate_override = NVL(l_bill_rate_override,txn_bill_rate_override)
1022: WHERE resource_assignment_id = l_ra_id

Line 1034: DELETE FROM pa_resource_asgn_curr_tmp;

1030: --End for Bug 6781055.
1031: End If;
1032: ElsIf p_delete_flag = 'Y' Then
1033: /* when rollup is not required just delete from tmp table */
1034: DELETE FROM pa_resource_asgn_curr_tmp;
1035: END IF;
1036:
1037: /* only for debug purpose
1038: for c in (select tmp.TXN_RAW_COST_RATE_OVERRIDE costRt

Line 1044: from pa_resource_asgn_curr_tmp tmp

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

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

1049: */
1050:
1051: /* When override currency is passed, then delete the records from new entity for the old currency */
1052: If p_source_context = 'RESOURCE_ASSIGNMENT' and NVL(p_refresh_rate_flag,'N') = 'N' Then
1053: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup for Override currency code');
1054: INSERT INTO pa_resource_asgn_curr_tmp raTxn
1055: (RA_TXN_ID
1056: ,BUDGET_VERSION_ID
1057: ,RESOURCE_ASSIGNMENT_ID

Line 1054: INSERT INTO pa_resource_asgn_curr_tmp raTxn

1050:
1051: /* When override currency is passed, then delete the records from new entity for the old currency */
1052: If p_source_context = 'RESOURCE_ASSIGNMENT' and NVL(p_refresh_rate_flag,'N') = 'N' Then
1053: --print_msg('Inserting records in pa_resource_asgn_curr_tmp from rollup for Override currency code');
1054: INSERT INTO pa_resource_asgn_curr_tmp raTxn
1055: (RA_TXN_ID
1056: ,BUDGET_VERSION_ID
1057: ,RESOURCE_ASSIGNMENT_ID
1058: ,TXN_CURRENCY_CODE

Line 1523: DELETE FROM pa_resource_asgn_curr_tmp;

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