DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_FP_CONSTANTS_PKG

Line 856: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;

852: INTO l_all_cal_type, l_cost_cal_type, l_revenue_cal_type
853: FROM pa_proj_fp_options
854: WHERE project_id = p_project_id
855: AND fin_plan_version_id = l_working_version_id
856: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;
857:
858: IF l_preference_code = 'SEP' THEN
859: SELECT revenue_time_phased_code
860: INTO l_revenue_cal_type

Line 864: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;

860: INTO l_revenue_cal_type
861: FROM pa_proj_fp_options
862: WHERE project_id = p_project_id
863: AND fin_plan_version_id = p_rev_version_id
864: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;
865: END IF ;
866:
867: IF l_preference_code = 'REVENUE' THEN
868: x_calendar_type := l_revenue_cal_type;

Line 919: IF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_P THEN

915: x_time_phase_valid_flag := 'Y';
916: END IF;
917:
918:
919: IF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_P THEN
920: x_calendar_id := l_pa_calendar_id;
921: ELSIF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_G THEN
922: x_calendar_id := l_gl_calendar_id;
923: END IF;

Line 921: ELSIF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_G THEN

917:
918:
919: IF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_P THEN
920: x_calendar_id := l_pa_calendar_id;
921: ELSIF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_G THEN
922: x_calendar_id := l_gl_calendar_id;
923: END IF;
924:
925: IF g_debug_mode = 'Y' THEN

Line 959: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;

955: INTO l_version_type
956: FROM pa_proj_fp_options
957: WHERE project_id = p_project_id
958: AND fin_plan_type_id = p_fin_plan_type_id
959: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;
960:
961: IF l_version_type = Pa_Fp_Constants_Pkg.G_PREF_COST_AND_REV_SAME THEN
962: l_version_type := Pa_Fp_Constants_Pkg.G_VERSION_TYPE_ALL;
963: ELSE

Line 961: IF l_version_type = Pa_Fp_Constants_Pkg.G_PREF_COST_AND_REV_SAME THEN

957: WHERE project_id = p_project_id
958: AND fin_plan_type_id = p_fin_plan_type_id
959: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;
960:
961: IF l_version_type = Pa_Fp_Constants_Pkg.G_PREF_COST_AND_REV_SAME THEN
962: l_version_type := Pa_Fp_Constants_Pkg.G_VERSION_TYPE_ALL;
963: ELSE
964: l_version_type := p_version_type;
965: END IF;

Line 962: l_version_type := Pa_Fp_Constants_Pkg.G_VERSION_TYPE_ALL;

958: AND fin_plan_type_id = p_fin_plan_type_id
959: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;
960:
961: IF l_version_type = Pa_Fp_Constants_Pkg.G_PREF_COST_AND_REV_SAME THEN
962: l_version_type := Pa_Fp_Constants_Pkg.G_VERSION_TYPE_ALL;
963: ELSE
964: l_version_type := p_version_type;
965: END IF;
966:

Line 1081: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

1077: ,x_msg_data=>x_msg_data);
1078:
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

Line 1106: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

1102: ,x_msg_data=>x_msg_data);
1103:
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

Line 1131: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

1127: ,x_msg_data=>x_msg_data);
1128:
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

Line 1171: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

1167: ,x_msg_data=>x_msg_data);
1168:
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

Line 2794: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

2790:
2791: l_plan_type_id := l_cost_plan_type_id;
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,

Line 2824: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

2820: l_plan_type_id := l_rev_plan_type_id;
2821:
2822: l_rev_version_type :=Get_Version_Type( p_project_id,
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,

Line 2899: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

2895: l_plan_type_id := l_cost_plan_type_id;
2896:
2897: l_cost_version_type :=Get_Version_Type(p_project_id,
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,

Line 2929: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

2925: l_plan_type_id := l_rev_plan_type_id;
2926:
2927: l_rev_version_type :=Get_Version_Type( p_project_id,
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,

Line 4389: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

4385:
4386: BEGIN
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

Line 4429: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

4425:
4426: BEGIN
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

Line 4473: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

4469:
4470: BEGIN
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

Line 4513: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

4509:
4510: BEGIN
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

Line 4556: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

4552:
4553: BEGIN
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

Line 4620: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

4616:
4617: BEGIN
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