DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_FIN_PLAN_UTILS

Line 118: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

114: end if;
115:
116: /* check to see if the budget version we're updating to be current working has */
117: /* been updated by someone else already */
118: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
119: (p_unique_index => p_budget_version_id,
120: p_record_version_number => p_record_version_number,
121: x_valid_flag => l_valid_flag,
122: x_return_status => l_return_status,

Line 299: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

295: p_msg_name => 'PA_FP_NO_PLAN_VERSION');
296: end if;
297: /* check to see if the budget version we're setting to be current working has */
298: /* been updated by someone else already */
299: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
300: (p_unique_index => p_budget_version_id,
301: p_record_version_number => p_record_version_number,
302: x_valid_flag => l_valid1_flag,
303: x_return_status => l_return_status,

Line 312: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

308: /* check to see if the old current working budget version has been updated */
309: /* by someone else already */
310: /* BUT, need to check if there was an old current working version */
311: if p_orig_budget_version_id is not null then
312: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
313: (p_unique_index => p_orig_budget_version_id,
314: p_record_version_number => p_orig_record_version_number,
315: x_valid_flag => l_valid2_flag,
316: x_return_status => x_return_status,

Line 652: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

648: p_msg_name => 'PA_FP_REWORK_SUBMITTED');
649: end if;
650: /* check to see if the budget version we're updating to be current working has */
651: /* been updated by someone else already */
652: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
653: (p_unique_index => p_budget_version_id,
654: p_record_version_number => p_record_version_number,
655: x_valid_flag => l_valid_flag,
656: x_return_status => l_return_status,

Line 764: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

760: p_msg_name => 'PA_FP_NO_PLAN_VERSION');
761: end if;
762: /* check to see if the budget version we're setting to be original baselined has */
763: /* been updated by someone else already */
764: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
765: (p_unique_index => p_budget_version_id,
766: p_record_version_number => p_record_version_number,
767: x_valid_flag => l_valid1_flag,
768: x_return_status => l_return_status,

Line 775: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

771: /* by someone else already */
772:
773: /* Bug # 2639285 - Included the check for p_orig_budget_version_id is not null*/
774: IF p_orig_budget_version_id IS NOT NULL THEN
775: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
776: (p_unique_index => p_orig_budget_version_id,
777: p_record_version_number => p_orig_record_version_number,
778: x_valid_flag => l_valid2_flag,
779: x_return_status => x_return_status,

Line 1020: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

1016: ----------------------------------------------------------------------
1017: IF ((p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET) AND (p_budget_version_id IS NOT NULL)) THEN
1018: /* check to see if the budget version we're updating to be current working has */
1019: /* been updated by someone else already */
1020: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
1021: (p_unique_index => p_budget_version_id,
1022: p_record_version_number => p_record_version_number,
1023: x_valid_flag => l_valid_flag,
1024: x_return_status => l_return_status,

Line 3281: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

3277: p_msg_name => 'PA_ALL_WARN_NO_EMPL_REC');
3278: end if;
3279: /* check to see if the budget version we're setting to be current baselined has */
3280: /* been updated by someone else already */
3281: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
3282: (p_unique_index => p_budget_version_id,
3283: p_record_version_number => p_record_version_number,
3284: x_valid_flag => l_valid1_flag,
3285: x_return_status => l_return_status,

Line 3293: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

3289: /* if p_orig_budget_version_id = null then there is currently not a baselined version */
3290: /* in this case, ignore this check
3291: if p_orig_budget_version_id <> null then */
3292: if p_orig_budget_version_id is not null then
3293: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
3294: (p_unique_index => p_orig_budget_version_id,
3295: p_record_version_number => p_orig_record_version_number,
3296: x_valid_flag => l_valid2_flag,
3297: x_return_status => l_return_status,

Line 4160: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

4156: end if;
4157:
4158: /* check to see if the budget version we're regenerating has */
4159: /* been updated by someone else already */
4160: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
4161: (p_unique_index => p_budget_version_id,
4162: p_record_version_number => p_record_version_number,
4163: x_valid_flag => l_valid_flag,
4164: x_return_status => l_return_status,

Line 4377: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

4373: p_msg_name => 'PA_FP_NO_PLAN_VERSION');
4374: end if;
4375: /* check to see if the budget version we're updating to be current working has */
4376: /* been updated by someone else already */
4377: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
4378: (p_unique_index => p_budget_version_id,
4379: p_record_version_number => p_record_version_number,
4380: x_valid_flag => l_valid_flag,
4381: x_return_status => l_return_status,

Line 5587: pa_fin_plan_utils. Get_Curr_Working_Version_Info(

5583:
5584: l_curr_work_ver_exists_flag :='Y';
5585:
5586: ELSE
5587: pa_fin_plan_utils. Get_Curr_Working_Version_Info(
5588: p_project_id => p_project_id
5589: ,p_fin_plan_type_id => p_fin_plan_type_id
5590: ,p_version_type => p_element_type
5591: ,x_fp_options_id => l_fp_options_id

Line 5913: PA_FIN_PLAN_UTILS.Get_Max_Budget_Version_Number

5909: pa_debug.g_err_stage:='Fetching max working version number for this plan type';
5910: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
5911: END IF;
5912:
5913: PA_FIN_PLAN_UTILS.Get_Max_Budget_Version_Number
5914: (p_project_id => p_project_id
5915: ,p_fin_plan_type_id => p_fin_plan_type_id
5916: ,p_version_type => new_version_info_rec.version_type
5917: ,p_copy_mode => PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING

Line 6477: PA_FIN_PLAN_UTILS.get_converted_amounts

6473: is created.
6474: */
6475: IF p_ci_id IS NOT NULL THEN
6476:
6477: PA_FIN_PLAN_UTILS.get_converted_amounts
6478: ( p_budget_version_id => l_new_budget_version_id
6479: ,p_txn_raw_cost => p_est_proj_raw_cost
6480: ,p_txn_burdened_cost => p_est_proj_bd_cost
6481: ,p_txn_revenue => p_est_proj_revenue

Line 7207: AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(pbv.budget_version_id)

7203: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra
7204: ,pa_budget_lines pbl
7205: WHERE pbv.project_id = p_project_id
7206: AND pbl.budget_version_id = pbv.budget_version_id
7207: AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(pbv.budget_version_id)
7208: = DECODE(p_period_type,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,
7209: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P) ;
7210:
7211:

Line 8200: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY);

8196: WHERE pa_budget_versions.budget_version_id = p_budget_version_id;
8197:
8198: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8199: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8200: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY);
8201: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY);
8202:
8203: IF (l_budget_version_type = 'ALL') THEN
8204:

Line 8201: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY);

8197:
8198: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8199: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8200: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY);
8201: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY);
8202:
8203: IF (l_budget_version_type = 'ALL') THEN
8204:
8205: l_tbl_index := l_tbl_index + 1;

Line 8208: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);

8204:
8205: l_tbl_index := l_tbl_index + 1;
8206: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8207: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST;
8208: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);
8209: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST);
8210:
8211: l_tbl_index := l_tbl_index + 1;
8212: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;

Line 8209: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST);

8205: l_tbl_index := l_tbl_index + 1;
8206: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8207: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST;
8208: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);
8209: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST);
8210:
8211: l_tbl_index := l_tbl_index + 1;
8212: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8213: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;

Line 8214: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);

8210:
8211: l_tbl_index := l_tbl_index + 1;
8212: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8213: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
8214: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);
8215: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST);
8216:
8217: l_tbl_index := l_tbl_index + 1;
8218: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;

Line 8215: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST);

8211: l_tbl_index := l_tbl_index + 1;
8212: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8213: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
8214: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);
8215: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST);
8216:
8217: l_tbl_index := l_tbl_index + 1;
8218: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8219: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;

Line 8220: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);

8216:
8217: l_tbl_index := l_tbl_index + 1;
8218: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8219: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8220: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);
8221: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);
8222:
8223: ELSIF (l_budget_version_type = 'COST') THEN
8224:

Line 8221: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);

8217: l_tbl_index := l_tbl_index + 1;
8218: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8219: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8220: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);
8221: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);
8222:
8223: ELSIF (l_budget_version_type = 'COST') THEN
8224:
8225: l_tbl_index := l_tbl_index + 1;

Line 8228: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);

8224:
8225: l_tbl_index := l_tbl_index + 1;
8226: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8227: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST;
8228: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);
8229: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST);
8230:
8231: l_tbl_index := l_tbl_index + 1;
8232: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;

Line 8229: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST);

8225: l_tbl_index := l_tbl_index + 1;
8226: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8227: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST;
8228: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);
8229: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST);
8230:
8231: l_tbl_index := l_tbl_index + 1;
8232: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8233: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;

Line 8234: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);

8230:
8231: l_tbl_index := l_tbl_index + 1;
8232: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8233: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
8234: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);
8235: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST);
8236:
8237: ELSIF (l_budget_version_type = 'REVENUE') THEN
8238:

Line 8235: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST);

8231: l_tbl_index := l_tbl_index + 1;
8232: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8233: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
8234: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST);
8235: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST);
8236:
8237: ELSIF (l_budget_version_type = 'REVENUE') THEN
8238:
8239: l_tbl_index := l_tbl_index + 1;

Line 8242: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);

8238:
8239: l_tbl_index := l_tbl_index + 1;
8240: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8241: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8242: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);
8243: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);
8244:
8245: END IF;
8246:

Line 8243: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);

8239: l_tbl_index := l_tbl_index + 1;
8240: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8241: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8242: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);
8243: amt_rec(l_tbl_index).amount_subtype_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE);
8244:
8245: END IF;
8246:
8247: /* Calling the Maintain_Plan_Matrix API to recalculate profile period amounts as well