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 3265: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

3261: p_msg_name => 'PA_ALL_WARN_NO_EMPL_REC');
3262: end if;
3263: /* check to see if the budget version we're setting to be current baselined has */
3264: /* been updated by someone else already */
3265: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
3266: (p_unique_index => p_budget_version_id,
3267: p_record_version_number => p_record_version_number,
3268: x_valid_flag => l_valid1_flag,
3269: x_return_status => l_return_status,

Line 3277: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

3273: /* if p_orig_budget_version_id = null then there is currently not a baselined version */
3274: /* in this case, ignore this check
3275: if p_orig_budget_version_id <> null then */
3276: if p_orig_budget_version_id is not null then
3277: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
3278: (p_unique_index => p_orig_budget_version_id,
3279: p_record_version_number => p_orig_record_version_number,
3280: x_valid_flag => l_valid2_flag,
3281: x_return_status => l_return_status,

Line 4144: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

4140: end if;
4141:
4142: /* check to see if the budget version we're regenerating has */
4143: /* been updated by someone else already */
4144: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
4145: (p_unique_index => p_budget_version_id,
4146: p_record_version_number => p_record_version_number,
4147: x_valid_flag => l_valid_flag,
4148: x_return_status => l_return_status,

Line 4361: PA_FIN_PLAN_UTILS.Check_Record_Version_Number

4357: p_msg_name => 'PA_FP_NO_PLAN_VERSION');
4358: end if;
4359: /* check to see if the budget version we're updating to be current working has */
4360: /* been updated by someone else already */
4361: PA_FIN_PLAN_UTILS.Check_Record_Version_Number
4362: (p_unique_index => p_budget_version_id,
4363: p_record_version_number => p_record_version_number,
4364: x_valid_flag => l_valid_flag,
4365: x_return_status => l_return_status,

Line 5570: pa_fin_plan_utils. Get_Curr_Working_Version_Info(

5566:
5567: l_curr_work_ver_exists_flag :='Y';
5568:
5569: ELSE
5570: pa_fin_plan_utils. Get_Curr_Working_Version_Info(
5571: p_project_id => p_project_id
5572: ,p_fin_plan_type_id => p_fin_plan_type_id
5573: ,p_version_type => p_element_type
5574: ,x_fp_options_id => l_fp_options_id

Line 5896: PA_FIN_PLAN_UTILS.Get_Max_Budget_Version_Number

5892: pa_debug.g_err_stage:='Fetching max working version number for this plan type';
5893: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
5894: END IF;
5895:
5896: PA_FIN_PLAN_UTILS.Get_Max_Budget_Version_Number
5897: (p_project_id => p_project_id
5898: ,p_fin_plan_type_id => p_fin_plan_type_id
5899: ,p_version_type => new_version_info_rec.version_type
5900: ,p_copy_mode => PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING

Line 6457: PA_FIN_PLAN_UTILS.get_converted_amounts

6453: is created.
6454: */
6455: IF p_ci_id IS NOT NULL THEN
6456:
6457: PA_FIN_PLAN_UTILS.get_converted_amounts
6458: ( p_budget_version_id => l_new_budget_version_id
6459: ,p_txn_raw_cost => p_est_proj_raw_cost
6460: ,p_txn_burdened_cost => p_est_proj_bd_cost
6461: ,p_txn_revenue => p_est_proj_revenue

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

7183: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra
7184: ,pa_budget_lines pbl
7185: WHERE pbv.project_id = p_project_id
7186: AND pbl.budget_version_id = pbv.budget_version_id
7187: AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(pbv.budget_version_id)
7188: = DECODE(p_period_type,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,
7189: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P) ;
7190:
7191:

Line 8180: 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);

8176: WHERE pa_budget_versions.budget_version_id = p_budget_version_id;
8177:
8178: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8179: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8180: 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);
8181: 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);
8182:
8183: IF (l_budget_version_type = 'ALL') THEN
8184:

Line 8181: 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);

8177:
8178: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8179: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8180: 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);
8181: 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);
8182:
8183: IF (l_budget_version_type = 'ALL') THEN
8184:
8185: l_tbl_index := l_tbl_index + 1;

Line 8188: 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);

8184:
8185: l_tbl_index := l_tbl_index + 1;
8186: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8187: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST;
8188: 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);
8189: 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);
8190:
8191: l_tbl_index := l_tbl_index + 1;
8192: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;

Line 8189: 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);

8185: l_tbl_index := l_tbl_index + 1;
8186: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8187: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_RAW_COST;
8188: 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);
8189: 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);
8190:
8191: l_tbl_index := l_tbl_index + 1;
8192: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8193: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;

Line 8194: 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);

8190:
8191: l_tbl_index := l_tbl_index + 1;
8192: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8193: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
8194: 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);
8195: 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);
8196:
8197: l_tbl_index := l_tbl_index + 1;
8198: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;

Line 8195: 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);

8191: l_tbl_index := l_tbl_index + 1;
8192: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
8193: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
8194: 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);
8195: 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);
8196:
8197: l_tbl_index := l_tbl_index + 1;
8198: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8199: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;

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_REVENUE);

8196:
8197: l_tbl_index := l_tbl_index + 1;
8198: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8199: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
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_REVENUE);
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_REVENUE);
8202:
8203: ELSIF (l_budget_version_type = 'COST') 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_REVENUE);

8197: l_tbl_index := l_tbl_index + 1;
8198: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8199: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
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_REVENUE);
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_REVENUE);
8202:
8203: ELSIF (l_budget_version_type = 'COST') 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: ELSIF (l_budget_version_type = 'REVENUE') THEN
8218:

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: ELSIF (l_budget_version_type = 'REVENUE') THEN
8218:
8219: l_tbl_index := l_tbl_index + 1;

Line 8222: 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);

8218:
8219: l_tbl_index := l_tbl_index + 1;
8220: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8221: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8222: 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);
8223: 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);
8224:
8225: END IF;
8226:

Line 8223: 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);

8219: l_tbl_index := l_tbl_index + 1;
8220: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8221: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
8222: 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);
8223: 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);
8224:
8225: END IF;
8226:
8227: /* Calling the Maintain_Plan_Matrix API to recalculate profile period amounts as well