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 800: --print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records for refresh rates');

796: );
797: --print_msg('Number of records updated directly with null['||sql%rowcount||']');
798:
799: If l_rowCount1 > 0 Then
800: --print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records for refresh rates');
801: pa_res_asg_currency_pub.MAINTAIN_DATA
802: (P_FP_COLS_REC => G_FP_COLS_REC
803: ,P_CALLING_MODULE => 'CALCULATE_API'
804: ,P_DELETE_FLAG => 'Y'

Line 801: pa_res_asg_currency_pub.MAINTAIN_DATA

797: --print_msg('Number of records updated directly with null['||sql%rowcount||']');
798:
799: If l_rowCount1 > 0 Then
800: --print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records for refresh rates');
801: pa_res_asg_currency_pub.MAINTAIN_DATA
802: (P_FP_COLS_REC => G_FP_COLS_REC
803: ,P_CALLING_MODULE => 'CALCULATE_API'
804: ,P_DELETE_FLAG => 'Y'
805: ,P_ROLLUP_FLAG => 'N'

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

1071: --print_msg('Number of records inserted ['||l_rowCount1||']');
1072:
1073: If l_rowCount1 > 0 Then
1074: If P_PA_DEBUG_MODE = 'Y' Then
1075: print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records');
1076: End If;
1077: pa_res_asg_currency_pub.MAINTAIN_DATA
1078: (P_FP_COLS_REC => G_FP_COLS_REC
1079: ,P_CALLING_MODULE => 'CALCULATE_API'

Line 1077: pa_res_asg_currency_pub.MAINTAIN_DATA

1073: If l_rowCount1 > 0 Then
1074: If P_PA_DEBUG_MODE = 'Y' Then
1075: print_msg('Calling pa_res_asg_currency_pub.maintain_data for deleting records');
1076: End If;
1077: pa_res_asg_currency_pub.MAINTAIN_DATA
1078: (P_FP_COLS_REC => G_FP_COLS_REC
1079: ,P_CALLING_MODULE => 'CALCULATE_API'
1080: ,P_DELETE_FLAG => 'Y'
1081: ,P_ROLLUP_FLAG => 'N'

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

1093:
1094: IF p_call_raTxn_rollup_flag = 'Y' AND l_rowCount > 0 Then
1095: -- Call new entity rollup api
1096: If P_PA_DEBUG_MODE = 'Y' Then
1097: print_msg('Calling pa_res_asg_currency_pub.maintain_data');
1098: End If;
1099: pa_res_asg_currency_pub.MAINTAIN_DATA
1100: (P_FP_COLS_REC => G_FP_COLS_REC
1101: ,P_CALLING_MODULE => 'CALCULATE_API'

Line 1099: pa_res_asg_currency_pub.MAINTAIN_DATA

1095: -- Call new entity rollup api
1096: If P_PA_DEBUG_MODE = 'Y' Then
1097: print_msg('Calling pa_res_asg_currency_pub.maintain_data');
1098: End If;
1099: pa_res_asg_currency_pub.MAINTAIN_DATA
1100: (P_FP_COLS_REC => G_FP_COLS_REC
1101: ,P_CALLING_MODULE => 'CALCULATE_API'
1102: ,P_DELETE_FLAG => 'N'
1103: ,P_ROLLUP_FLAG => 'Y' --p_rollup_flag

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

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