DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_FIN_PLAN_UTILS

Line 1373: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(

1369: /*
1370: ** Get approved cost and revenue plan types for the
1371: ** project.
1372: */
1373: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(
1374: p_project_id=>p_project_id
1375: ,x_plan_type_id =>g_cost_bgt_plan_type_id
1376: ,x_return_status=>x_return_status
1377: ,x_msg_count=>x_msg_count

Line 1379: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(

1375: ,x_plan_type_id =>g_cost_bgt_plan_type_id
1376: ,x_return_status=>x_return_status
1377: ,x_msg_count=>x_msg_count
1378: ,x_msg_data=>x_msg_data);
1379: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(
1380: p_project_id=>p_project_id
1381: ,x_plan_type_id=>g_rev_bgt_plan_type_id
1382: ,x_return_status=>x_return_status
1383: ,x_msg_count=>x_msg_count

Line 1389: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(

1385: /*
1386: ** Get primary cost and revenue plan types for the
1387: ** project.
1388: */
1389: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(
1390: p_project_id=>p_project_id
1391: ,x_plan_type_id=>g_cost_fcst_plan_type_id
1392: ,x_return_status=>x_return_status
1393: ,x_msg_count=>x_msg_count

Line 1395: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(

1391: ,x_plan_type_id=>g_cost_fcst_plan_type_id
1392: ,x_return_status=>x_return_status
1393: ,x_msg_count=>x_msg_count
1394: ,x_msg_data=>x_msg_data);
1395: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(
1396: p_project_id=>p_project_id
1397: ,x_plan_type_id=>g_rev_fcst_plan_type_id
1398: ,x_return_status=>x_return_status
1399: ,x_msg_count=>x_msg_count

Line 1406: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

1402: ** Get current and original baselined plan versions
1403: ** for approved/primary cost and revenue plan types.
1404: */
1405: IF g_cost_bgt_plan_type_id IS NOT NULL THEN
1406: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
1407: p_project_id=>p_project_id
1408: ,p_fin_plan_Type_id=>g_cost_bgt_plan_type_id
1409: ,p_budget_type_code=>NULL
1410: ,x_budget_version_id=>g_cstbudget_version_id

Line 1419: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

1415: l_cst_budget_version_type:=Get_Version_Type(p_project_id
1416: ,g_cost_bgt_plan_type_id
1417: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
1418:
1419: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
1420: p_project_id=>p_project_id
1421: ,p_fin_plan_Type_id=>g_cost_bgt_plan_type_id
1422: ,p_version_type=>l_cst_budget_version_type
1423: ,x_fp_options_id=>l_fp_options_id

Line 1431: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

1427: ,x_msg_data=>x_msg_data);
1428: END IF;
1429:
1430: IF g_rev_bgt_plan_type_id IS NOT NULL THEN
1431: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
1432: p_project_id=>p_project_id
1433: ,p_fin_plan_Type_id=>g_rev_bgt_plan_type_id
1434: ,p_budget_type_code=>NULL
1435: ,x_budget_version_id=>g_revbudget_version_id

Line 1444: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

1440: l_rev_budget_version_type:=Get_Version_Type(p_project_id
1441: ,g_rev_bgt_plan_type_id
1442: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
1443:
1444: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
1445: p_project_id=>p_project_id
1446: ,p_fin_plan_Type_id=>g_rev_bgt_plan_type_id
1447: ,p_version_type=>l_rev_budget_version_type
1448: ,x_fp_options_id=>l_fp_options_id

Line 1456: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

1452: ,x_msg_data=>x_msg_data);
1453: END IF;
1454:
1455: IF g_cost_fcst_plan_type_id IS NOT NULL THEN
1456: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
1457: p_project_id=>p_project_id
1458: ,p_fin_plan_Type_id=>g_cost_fcst_plan_type_id
1459: ,p_budget_type_code=>NULL
1460: ,x_budget_version_id=>g_cstforecast_version_id

Line 1469: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

1465: l_cst_forecast_version_type:=Get_Version_Type(p_project_id
1466: ,g_cost_fcst_plan_type_id
1467: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
1468:
1469: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
1470: p_project_id=>p_project_id
1471: ,p_fin_plan_Type_id=>g_cost_fcst_plan_type_id
1472: ,p_version_type=>l_cst_forecast_version_type
1473: ,x_fp_options_id=>l_fp_options_id

Line 1496: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

1492:
1493: END IF;
1494:
1495: IF g_rev_fcst_plan_type_id IS NOT NULL THEN
1496: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
1497: p_project_id=>p_project_id
1498: ,p_fin_plan_Type_id=>g_rev_fcst_plan_type_id
1499: ,p_budget_type_code=>NULL
1500: ,x_budget_version_id=>g_revforecast_version_id

Line 1509: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

1505: l_rev_forecast_version_type:=Get_Version_Type(p_project_id
1506: ,g_rev_fcst_plan_type_id
1507: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
1508:
1509: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
1510: p_project_id=>p_project_id
1511: ,p_fin_plan_Type_id=>g_rev_fcst_plan_type_id
1512: ,p_version_type=>l_rev_forecast_version_type
1513: ,x_fp_options_id=>l_fp_options_id

Line 3208: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(

3204:
3205: IF (p_page_type = 'VB') THEN
3206:
3207:
3208: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(
3209: p_project_id => p_project_id
3210: ,x_plan_type_id => l_cost_plan_type_id
3211: ,x_return_status => x_return_status
3212: ,x_msg_count => x_msg_count

Line 3216: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(

3212: ,x_msg_count => x_msg_count
3213: ,x_msg_data => x_msg_data);
3214:
3215:
3216: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(
3217: p_project_id => p_project_id
3218: ,x_plan_type_id => l_rev_plan_type_id
3219: ,x_return_status => x_return_status
3220: ,x_msg_count => x_msg_count

Line 3240: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(

3236: l_cost_version_type :=Get_Version_Type(p_project_id,
3237: l_cost_plan_type_id,
3238: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
3239:
3240: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(
3241: p_project_id => p_project_id,
3242: p_fin_plan_type_id => l_cost_plan_type_id,
3243: p_version_type => l_cost_version_type,
3244: x_fp_options_id => l_fp_options_id,

Line 3271: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(

3267: l_rev_plan_type_id,
3268: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
3269:
3270:
3271: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(
3272: p_project_id => p_project_id,
3273: p_fin_plan_type_id => l_rev_plan_type_id,
3274: p_version_type => l_rev_version_type,
3275: x_fp_options_id => l_fp_options_id,

Line 3315: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(

3311: IF (p_page_type = 'VF') THEN
3312:
3313:
3314:
3315: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(
3316: p_project_id => p_project_id
3317: ,x_plan_type_id => l_cost_plan_type_id
3318: ,x_return_status => x_return_status
3319: ,x_msg_count => x_msg_count

Line 3322: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(

3318: ,x_return_status => x_return_status
3319: ,x_msg_count => x_msg_count
3320: ,x_msg_data => x_msg_data);
3321:
3322: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(
3323: p_project_id => p_project_id
3324: ,x_plan_type_id => l_rev_plan_type_id
3325: ,x_return_status => x_return_status
3326: ,x_msg_count => x_msg_count

Line 3346: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(

3342: l_cost_plan_type_id,
3343: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
3344:
3345:
3346: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(
3347: p_project_id => p_project_id,
3348: p_fin_plan_type_id => l_cost_plan_type_id,
3349: p_version_type => l_cost_version_type,
3350: x_fp_options_id => l_fp_options_id,

Line 3376: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(

3372: l_rev_plan_type_id,
3373: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
3374:
3375:
3376: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(
3377: p_project_id => p_project_id,
3378: p_fin_plan_type_id => l_rev_plan_type_id,
3379: p_version_type => l_rev_version_type,
3380: x_fp_options_id => l_fp_options_id,

Line 4695: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(

4691: /*
4692: ** Get approved cost and revenue plan types for the
4693: ** project.
4694: */
4695: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(
4696: p_project_id=>p_project_id
4697: ,x_plan_type_id =>l_cost_bgt_plan_type_id
4698: ,x_return_status=>x_return_status
4699: ,x_msg_count=>x_msg_count

Line 4701: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(

4697: ,x_plan_type_id =>l_cost_bgt_plan_type_id
4698: ,x_return_status=>x_return_status
4699: ,x_msg_count=>x_msg_count
4700: ,x_msg_data=>x_msg_data);
4701: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(
4702: p_project_id=>p_project_id
4703: ,x_plan_type_id=>l_rev_bgt_plan_type_id
4704: ,x_return_status=>x_return_status
4705: ,x_msg_count=>x_msg_count

Line 4720: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(

4716: /*
4717: ** Get primary cost and revenue plan types for the
4718: ** project.
4719: */
4720: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(
4721: p_project_id=>p_project_id
4722: ,x_plan_type_id=>x_cost_fcst_plan_type_id
4723: ,x_return_status=>x_return_status
4724: ,x_msg_count=>x_msg_count

Line 4726: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(

4722: ,x_plan_type_id=>x_cost_fcst_plan_type_id
4723: ,x_return_status=>x_return_status
4724: ,x_msg_count=>x_msg_count
4725: ,x_msg_data=>x_msg_data);
4726: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(
4727: p_project_id=>p_project_id
4728: ,x_plan_type_id=>x_rev_fcst_plan_type_id
4729: ,x_return_status=>x_return_status
4730: ,x_msg_count=>x_msg_count

Line 4817: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

4813: ** for approved/primary cost and revenue plan types.
4814: */
4815: IF p_cost_bgt_plan_type_id IS NOT NULL THEN
4816: BEGIN
4817: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
4818: p_project_id =>p_project_id
4819: ,p_fin_plan_Type_id =>p_cost_bgt_plan_type_id
4820: ,p_budget_type_code =>NULL
4821: ,x_budget_version_id =>x_cstbudget_version_id

Line 4835: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4831: l_cst_budget_version_type:=Get_Version_Type(p_project_id
4832: ,p_cost_bgt_plan_type_id
4833: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
4834:
4835: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4836: p_project_id =>p_project_id
4837: ,p_fin_plan_Type_id =>p_cost_bgt_plan_type_id
4838: ,p_version_type =>l_cst_budget_version_type
4839: ,x_fp_options_id =>l_fp_options_id

Line 4857: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

4853:
4854: IF p_rev_bgt_plan_type_id IS NOT NULL THEN
4855:
4856: BEGIN
4857: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
4858: p_project_id =>p_project_id
4859: ,p_fin_plan_Type_id =>p_rev_bgt_plan_type_id
4860: ,p_budget_type_code =>NULL
4861: ,x_budget_version_id =>x_revbudget_version_id

Line 4875: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4871: l_rev_budget_version_type:=Get_Version_Type(p_project_id
4872: ,p_rev_bgt_plan_type_id
4873: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
4874:
4875: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4876: p_project_id =>p_project_id
4877: ,p_fin_plan_Type_id =>p_rev_bgt_plan_type_id
4878: ,p_version_type =>l_rev_budget_version_type
4879: ,x_fp_options_id =>l_fp_options_id

Line 4901: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

4897: */
4898: IF p_cost_bgt2_plan_type_id IS NOT NULL THEN
4899:
4900: BEGIN
4901: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
4902: p_project_id =>p_project_id
4903: ,p_fin_plan_Type_id =>p_cost_bgt2_plan_type_id
4904: ,p_budget_type_code =>NULL
4905: ,x_budget_version_id =>x_cstbudget2_version_id

Line 4919: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4915: l_cst_budget2_version_type:=Get_Version_Type(p_project_id
4916: ,p_cost_bgt2_plan_type_id
4917: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
4918:
4919: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4920: p_project_id =>p_project_id
4921: ,p_fin_plan_Type_id =>p_cost_bgt2_plan_type_id
4922: ,p_version_type =>l_cst_budget2_version_type
4923: ,x_fp_options_id =>l_fp_options_id

Line 4941: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

4937:
4938: IF p_rev_bgt2_plan_type_id IS NOT NULL THEN
4939:
4940: BEGIN
4941: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
4942: p_project_id =>p_project_id
4943: ,p_fin_plan_Type_id =>p_rev_bgt2_plan_type_id
4944: ,p_budget_type_code =>NULL
4945: ,x_budget_version_id =>x_revbudget2_version_id

Line 4959: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4955: l_rev_budget2_version_type:=Get_Version_Type(p_project_id
4956: ,p_rev_bgt2_plan_type_id
4957: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
4958:
4959: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4960: p_project_id =>p_project_id
4961: ,p_fin_plan_Type_id =>p_rev_bgt2_plan_type_id
4962: ,p_version_type =>l_rev_budget2_version_type
4963: ,x_fp_options_id =>l_fp_options_id

Line 4984: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

4980: */
4981: IF p_cost_fcst_plan_type_id IS NOT NULL THEN
4982:
4983: BEGIN
4984: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
4985: p_project_id =>p_project_id
4986: ,p_fin_plan_Type_id =>p_cost_fcst_plan_type_id
4987: ,p_budget_type_code =>NULL
4988: ,x_budget_version_id =>l_temp_cstforecast_version_id

Line 5002: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4998: l_cst_forecast_version_type:=Get_Version_Type(p_project_id
4999: ,p_cost_fcst_plan_type_id
5000: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
5001:
5002: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
5003: p_project_id =>p_project_id
5004: ,p_fin_plan_Type_id =>p_cost_fcst_plan_type_id
5005: ,p_version_type =>l_cst_forecast_version_type
5006: ,x_fp_options_id =>l_fp_options_id

Line 5048: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

5044:
5045: IF p_rev_fcst_plan_type_id IS NOT NULL THEN
5046:
5047: BEGIN
5048: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
5049: p_project_id =>p_project_id
5050: ,p_fin_plan_Type_id =>p_rev_fcst_plan_type_id
5051: ,p_budget_type_code =>NULL
5052: ,x_budget_version_id =>l_temp_revforecast_version_id

Line 5066: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

5062: l_rev_forecast_version_type:=Get_Version_Type(p_project_id
5063: ,p_rev_fcst_plan_type_id
5064: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
5065:
5066: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
5067: p_project_id =>p_project_id
5068: ,p_fin_plan_Type_id =>p_rev_fcst_plan_type_id
5069: ,p_version_type =>l_rev_forecast_version_type
5070: ,x_fp_options_id =>l_fp_options_id