DBA Data[Home] [Help]

APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_RES_ASG_CURRENCY_PUB

Line 710: * and calls pa_res_asg_currency_pub.MAINTAIN_DATA to rollup the amounts

706:
707: END print_rlTmp_Values;
708:
709: /* IPM Changes: This API populates records into new entity pa_resource_asgn_curr table
710: * and calls pa_res_asg_currency_pub.MAINTAIN_DATA to rollup the amounts
711: * and updates the rate overrides
712: * Logic: When Refresh rates flag = 'Y'
713: * -- Delete all records from the new entity
714: * When source context = BUDGET LINE

Line 812: --print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records for refresh rates');

808: );
809: --print_msg('Number of records updated directly with null['||sql%rowcount||']');
810:
811: If l_rowCount1 > 0 Then
812: --print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records for refresh rates');
813: pa_res_asg_currency_pub.MAINTAIN_DATA
814: (P_FP_COLS_REC => G_FP_COLS_REC
815: ,P_CALLING_MODULE => 'CALCULATE_API'
816: ,P_DELETE_FLAG => 'Y'

Line 813: pa_res_asg_currency_pub.MAINTAIN_DATA

809: --print_msg('Number of records updated directly with null['||sql%rowcount||']');
810:
811: If l_rowCount1 > 0 Then
812: --print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records for refresh rates');
813: pa_res_asg_currency_pub.MAINTAIN_DATA
814: (P_FP_COLS_REC => G_FP_COLS_REC
815: ,P_CALLING_MODULE => 'CALCULATE_API'
816: ,P_DELETE_FLAG => 'Y'
817: ,P_ROLLUP_FLAG => 'N'

Line 1105: print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records');

1101: -- gboomina added for AAI requirement Bug 8318932 - end
1102:
1103: If l_rowCount1 > 0 Then
1104: If P_PA_DEBUG_MODE = 'Y' Then
1105: print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records');
1106: End If;
1107: pa_res_asg_currency_pub.MAINTAIN_DATA
1108: (P_FP_COLS_REC => G_FP_COLS_REC
1109: ,P_CALLING_MODULE => 'CALCULATE_API'

Line 1107: pa_res_asg_currency_pub.MAINTAIN_DATA

1103: If l_rowCount1 > 0 Then
1104: If P_PA_DEBUG_MODE = 'Y' Then
1105: print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records');
1106: End If;
1107: pa_res_asg_currency_pub.MAINTAIN_DATA
1108: (P_FP_COLS_REC => G_FP_COLS_REC
1109: ,P_CALLING_MODULE => 'CALCULATE_API'
1110: ,P_DELETE_FLAG => 'Y'
1111: ,P_ROLLUP_FLAG => 'N'

Line 1127: print_msg('Calling pa_res_asg_currency_pub.maintain_data');

1123:
1124: IF p_call_raTxn_rollup_flag = 'Y' AND l_rowCount > 0 Then
1125: -- Call new entity rollup api
1126: If P_PA_DEBUG_MODE = 'Y' Then
1127: print_msg('Calling pa_res_asg_currency_pub.maintain_data');
1128: End If;
1129: pa_res_asg_currency_pub.MAINTAIN_DATA
1130: (P_FP_COLS_REC => G_FP_COLS_REC
1131: ,P_CALLING_MODULE => 'CALCULATE_API'

Line 1129: pa_res_asg_currency_pub.MAINTAIN_DATA

1125: -- Call new entity rollup api
1126: If P_PA_DEBUG_MODE = 'Y' Then
1127: print_msg('Calling pa_res_asg_currency_pub.maintain_data');
1128: End If;
1129: pa_res_asg_currency_pub.MAINTAIN_DATA
1130: (P_FP_COLS_REC => G_FP_COLS_REC
1131: ,P_CALLING_MODULE => 'CALCULATE_API'
1132: ,P_DELETE_FLAG => 'N'
1133: ,P_ROLLUP_FLAG => 'Y' --p_rollup_flag

Line 7779: /* Bug fix:5920547: Ideally, this fix should have been put in pa_res_asg_currency_pub.maintain_data().

7775: END IF;
7776: --print_msg('Number of rows updated for setting null rates['||sql%rowcount||']');
7777: End If;
7778:
7779: /* Bug fix:5920547: Ideally, this fix should have been put in pa_res_asg_currency_pub.maintain_data().
7780: * When a calculate API is called, it derives the transaction currency based on the rate schedule setup,
7781: * and it updates the passed in the txn currency with the rate scheduel currency.
7782: * while rollup the amounts, the maintain data() api should update the existing RA+TXN currency,
7783: * instead of deleting the old records and creating the new records.