DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_FIN_PLAN_UTILS

Line 1037: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(

1033: /*
1034: ** Get approved cost and revenue plan types for the
1035: ** project.
1036: */
1037: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(
1038: p_project_id=>p_project_id
1039: ,x_plan_type_id =>g_cost_bgt_plan_type_id
1040: ,x_return_status=>x_return_status
1041: ,x_msg_count=>x_msg_count

Line 1043: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(

1039: ,x_plan_type_id =>g_cost_bgt_plan_type_id
1040: ,x_return_status=>x_return_status
1041: ,x_msg_count=>x_msg_count
1042: ,x_msg_data=>x_msg_data);
1043: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(
1044: p_project_id=>p_project_id
1045: ,x_plan_type_id=>g_rev_bgt_plan_type_id
1046: ,x_return_status=>x_return_status
1047: ,x_msg_count=>x_msg_count

Line 1053: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(

1049: /*
1050: ** Get primary cost and revenue plan types for the
1051: ** project.
1052: */
1053: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(
1054: p_project_id=>p_project_id
1055: ,x_plan_type_id=>g_cost_fcst_plan_type_id
1056: ,x_return_status=>x_return_status
1057: ,x_msg_count=>x_msg_count

Line 1059: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(

1055: ,x_plan_type_id=>g_cost_fcst_plan_type_id
1056: ,x_return_status=>x_return_status
1057: ,x_msg_count=>x_msg_count
1058: ,x_msg_data=>x_msg_data);
1059: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(
1060: p_project_id=>p_project_id
1061: ,x_plan_type_id=>g_rev_fcst_plan_type_id
1062: ,x_return_status=>x_return_status
1063: ,x_msg_count=>x_msg_count

Line 1070: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

1066: ** Get current and original baselined plan versions
1067: ** for approved/primary cost and revenue plan types.
1068: */
1069: IF g_cost_bgt_plan_type_id IS NOT NULL THEN
1070: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
1071: p_project_id=>p_project_id
1072: ,p_fin_plan_Type_id=>g_cost_bgt_plan_type_id
1073: ,p_budget_type_code=>NULL
1074: ,x_budget_version_id=>g_cstbudget_version_id

Line 1083: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

1079: l_cst_budget_version_type:=Get_Version_Type(p_project_id
1080: ,g_cost_bgt_plan_type_id
1081: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
1082:
1083: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
1084: p_project_id=>p_project_id
1085: ,p_fin_plan_Type_id=>g_cost_bgt_plan_type_id
1086: ,p_version_type=>l_cst_budget_version_type
1087: ,x_fp_options_id=>l_fp_options_id

Line 1095: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

1091: ,x_msg_data=>x_msg_data);
1092: END IF;
1093:
1094: IF g_rev_bgt_plan_type_id IS NOT NULL THEN
1095: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
1096: p_project_id=>p_project_id
1097: ,p_fin_plan_Type_id=>g_rev_bgt_plan_type_id
1098: ,p_budget_type_code=>NULL
1099: ,x_budget_version_id=>g_revbudget_version_id

Line 1108: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

1104: l_rev_budget_version_type:=Get_Version_Type(p_project_id
1105: ,g_rev_bgt_plan_type_id
1106: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
1107:
1108: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
1109: p_project_id=>p_project_id
1110: ,p_fin_plan_Type_id=>g_rev_bgt_plan_type_id
1111: ,p_version_type=>l_rev_budget_version_type
1112: ,x_fp_options_id=>l_fp_options_id

Line 1120: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

1116: ,x_msg_data=>x_msg_data);
1117: END IF;
1118:
1119: IF g_cost_fcst_plan_type_id IS NOT NULL THEN
1120: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
1121: p_project_id=>p_project_id
1122: ,p_fin_plan_Type_id=>g_cost_fcst_plan_type_id
1123: ,p_budget_type_code=>NULL
1124: ,x_budget_version_id=>g_cstforecast_version_id

Line 1133: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

1129: l_cst_forecast_version_type:=Get_Version_Type(p_project_id
1130: ,g_cost_fcst_plan_type_id
1131: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
1132:
1133: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
1134: p_project_id=>p_project_id
1135: ,p_fin_plan_Type_id=>g_cost_fcst_plan_type_id
1136: ,p_version_type=>l_cst_forecast_version_type
1137: ,x_fp_options_id=>l_fp_options_id

Line 1160: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

1156:
1157: END IF;
1158:
1159: IF g_rev_fcst_plan_type_id IS NOT NULL THEN
1160: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
1161: p_project_id=>p_project_id
1162: ,p_fin_plan_Type_id=>g_rev_fcst_plan_type_id
1163: ,p_budget_type_code=>NULL
1164: ,x_budget_version_id=>g_revforecast_version_id

Line 1173: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

1169: l_rev_forecast_version_type:=Get_Version_Type(p_project_id
1170: ,g_rev_fcst_plan_type_id
1171: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
1172:
1173: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
1174: p_project_id=>p_project_id
1175: ,p_fin_plan_Type_id=>g_rev_fcst_plan_type_id
1176: ,p_version_type=>l_rev_forecast_version_type
1177: ,x_fp_options_id=>l_fp_options_id

Line 2764: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(

2760:
2761: IF (p_page_type = 'VB') THEN
2762:
2763:
2764: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(
2765: p_project_id => p_project_id
2766: ,x_plan_type_id => l_cost_plan_type_id
2767: ,x_return_status => x_return_status
2768: ,x_msg_count => x_msg_count

Line 2772: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(

2768: ,x_msg_count => x_msg_count
2769: ,x_msg_data => x_msg_data);
2770:
2771:
2772: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(
2773: p_project_id => p_project_id
2774: ,x_plan_type_id => l_rev_plan_type_id
2775: ,x_return_status => x_return_status
2776: ,x_msg_count => x_msg_count

Line 2796: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(

2792: l_cost_version_type :=Get_Version_Type(p_project_id,
2793: l_cost_plan_type_id,
2794: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
2795:
2796: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(
2797: p_project_id => p_project_id,
2798: p_fin_plan_type_id => l_cost_plan_type_id,
2799: p_version_type => l_cost_version_type,
2800: x_fp_options_id => l_fp_options_id,

Line 2827: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(

2823: l_rev_plan_type_id,
2824: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
2825:
2826:
2827: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(
2828: p_project_id => p_project_id,
2829: p_fin_plan_type_id => l_rev_plan_type_id,
2830: p_version_type => l_rev_version_type,
2831: x_fp_options_id => l_fp_options_id,

Line 2871: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(

2867: IF (p_page_type = 'VF') THEN
2868:
2869:
2870:
2871: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(
2872: p_project_id => p_project_id
2873: ,x_plan_type_id => l_cost_plan_type_id
2874: ,x_return_status => x_return_status
2875: ,x_msg_count => x_msg_count

Line 2878: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(

2874: ,x_return_status => x_return_status
2875: ,x_msg_count => x_msg_count
2876: ,x_msg_data => x_msg_data);
2877:
2878: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(
2879: p_project_id => p_project_id
2880: ,x_plan_type_id => l_rev_plan_type_id
2881: ,x_return_status => x_return_status
2882: ,x_msg_count => x_msg_count

Line 2902: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(

2898: l_cost_plan_type_id,
2899: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
2900:
2901:
2902: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(
2903: p_project_id => p_project_id,
2904: p_fin_plan_type_id => l_cost_plan_type_id,
2905: p_version_type => l_cost_version_type,
2906: x_fp_options_id => l_fp_options_id,

Line 2932: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(

2928: l_rev_plan_type_id,
2929: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
2930:
2931:
2932: Pa_Fin_Plan_Utils.Get_Curr_Working_Version_Info(
2933: p_project_id => p_project_id,
2934: p_fin_plan_type_id => l_rev_plan_type_id,
2935: p_version_type => l_rev_version_type,
2936: x_fp_options_id => l_fp_options_id,

Line 4251: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(

4247: /*
4248: ** Get approved cost and revenue plan types for the
4249: ** project.
4250: */
4251: Pa_Fin_Plan_Utils.Get_Appr_Cost_Plan_Type_Info(
4252: p_project_id=>p_project_id
4253: ,x_plan_type_id =>l_cost_bgt_plan_type_id
4254: ,x_return_status=>x_return_status
4255: ,x_msg_count=>x_msg_count

Line 4257: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(

4253: ,x_plan_type_id =>l_cost_bgt_plan_type_id
4254: ,x_return_status=>x_return_status
4255: ,x_msg_count=>x_msg_count
4256: ,x_msg_data=>x_msg_data);
4257: Pa_Fin_Plan_Utils.Get_Appr_Rev_Plan_Type_Info(
4258: p_project_id=>p_project_id
4259: ,x_plan_type_id=>l_rev_bgt_plan_type_id
4260: ,x_return_status=>x_return_status
4261: ,x_msg_count=>x_msg_count

Line 4276: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(

4272: /*
4273: ** Get primary cost and revenue plan types for the
4274: ** project.
4275: */
4276: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Cost_PT_Attached(
4277: p_project_id=>p_project_id
4278: ,x_plan_type_id=>x_cost_fcst_plan_type_id
4279: ,x_return_status=>x_return_status
4280: ,x_msg_count=>x_msg_count

Line 4282: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(

4278: ,x_plan_type_id=>x_cost_fcst_plan_type_id
4279: ,x_return_status=>x_return_status
4280: ,x_msg_count=>x_msg_count
4281: ,x_msg_data=>x_msg_data);
4282: Pa_Fin_Plan_Utils.Is_Pri_Fcst_Rev_PT_Attached(
4283: p_project_id=>p_project_id
4284: ,x_plan_type_id=>x_rev_fcst_plan_type_id
4285: ,x_return_status=>x_return_status
4286: ,x_msg_count=>x_msg_count

Line 4373: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

4369: ** for approved/primary cost and revenue plan types.
4370: */
4371: IF p_cost_bgt_plan_type_id IS NOT NULL THEN
4372: BEGIN
4373: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
4374: p_project_id =>p_project_id
4375: ,p_fin_plan_Type_id =>p_cost_bgt_plan_type_id
4376: ,p_budget_type_code =>NULL
4377: ,x_budget_version_id =>x_cstbudget_version_id

Line 4391: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4387: l_cst_budget_version_type:=Get_Version_Type(p_project_id
4388: ,p_cost_bgt_plan_type_id
4389: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
4390:
4391: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4392: p_project_id =>p_project_id
4393: ,p_fin_plan_Type_id =>p_cost_bgt_plan_type_id
4394: ,p_version_type =>l_cst_budget_version_type
4395: ,x_fp_options_id =>l_fp_options_id

Line 4413: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

4409:
4410: IF p_rev_bgt_plan_type_id IS NOT NULL THEN
4411:
4412: BEGIN
4413: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
4414: p_project_id =>p_project_id
4415: ,p_fin_plan_Type_id =>p_rev_bgt_plan_type_id
4416: ,p_budget_type_code =>NULL
4417: ,x_budget_version_id =>x_revbudget_version_id

Line 4431: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4427: l_rev_budget_version_type:=Get_Version_Type(p_project_id
4428: ,p_rev_bgt_plan_type_id
4429: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
4430:
4431: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4432: p_project_id =>p_project_id
4433: ,p_fin_plan_Type_id =>p_rev_bgt_plan_type_id
4434: ,p_version_type =>l_rev_budget_version_type
4435: ,x_fp_options_id =>l_fp_options_id

Line 4457: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

4453: */
4454: IF p_cost_bgt2_plan_type_id IS NOT NULL THEN
4455:
4456: BEGIN
4457: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
4458: p_project_id =>p_project_id
4459: ,p_fin_plan_Type_id =>p_cost_bgt2_plan_type_id
4460: ,p_budget_type_code =>NULL
4461: ,x_budget_version_id =>x_cstbudget2_version_id

Line 4475: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4471: l_cst_budget2_version_type:=Get_Version_Type(p_project_id
4472: ,p_cost_bgt2_plan_type_id
4473: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
4474:
4475: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4476: p_project_id =>p_project_id
4477: ,p_fin_plan_Type_id =>p_cost_bgt2_plan_type_id
4478: ,p_version_type =>l_cst_budget2_version_type
4479: ,x_fp_options_id =>l_fp_options_id

Line 4497: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

4493:
4494: IF p_rev_bgt2_plan_type_id IS NOT NULL THEN
4495:
4496: BEGIN
4497: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
4498: p_project_id =>p_project_id
4499: ,p_fin_plan_Type_id =>p_rev_bgt2_plan_type_id
4500: ,p_budget_type_code =>NULL
4501: ,x_budget_version_id =>x_revbudget2_version_id

Line 4515: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4511: l_rev_budget2_version_type:=Get_Version_Type(p_project_id
4512: ,p_rev_bgt2_plan_type_id
4513: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
4514:
4515: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4516: p_project_id =>p_project_id
4517: ,p_fin_plan_Type_id =>p_rev_bgt2_plan_type_id
4518: ,p_version_type =>l_rev_budget2_version_type
4519: ,x_fp_options_id =>l_fp_options_id

Line 4540: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(

4536: */
4537: IF p_cost_fcst_plan_type_id IS NOT NULL THEN
4538:
4539: BEGIN
4540: Pa_Fin_Plan_Utils.Get_Cost_Base_Version_Info(
4541: p_project_id =>p_project_id
4542: ,p_fin_plan_Type_id =>p_cost_fcst_plan_type_id
4543: ,p_budget_type_code =>NULL
4544: ,x_budget_version_id =>l_temp_cstforecast_version_id

Line 4558: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4554: l_cst_forecast_version_type:=Get_Version_Type(p_project_id
4555: ,p_cost_fcst_plan_type_id
4556: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);
4557:
4558: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4559: p_project_id =>p_project_id
4560: ,p_fin_plan_Type_id =>p_cost_fcst_plan_type_id
4561: ,p_version_type =>l_cst_forecast_version_type
4562: ,x_fp_options_id =>l_fp_options_id

Line 4604: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(

4600:
4601: IF p_rev_fcst_plan_type_id IS NOT NULL THEN
4602:
4603: BEGIN
4604: Pa_Fin_Plan_Utils.Get_Rev_Base_Version_Info(
4605: p_project_id =>p_project_id
4606: ,p_fin_plan_Type_id =>p_rev_fcst_plan_type_id
4607: ,p_budget_type_code =>NULL
4608: ,x_budget_version_id =>l_temp_revforecast_version_id

Line 4622: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(

4618: l_rev_forecast_version_type:=Get_Version_Type(p_project_id
4619: ,p_rev_fcst_plan_type_id
4620: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);
4621:
4622: Pa_Fin_Plan_Utils.Get_Curr_Original_Version_Info(
4623: p_project_id =>p_project_id
4624: ,p_fin_plan_Type_id =>p_rev_fcst_plan_type_id
4625: ,p_version_type =>l_rev_forecast_version_type
4626: ,x_fp_options_id =>l_fp_options_id