DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_FP_CONSTANTS_PKG

Line 1192: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;

1188: INTO l_all_cal_type, l_cost_cal_type, l_revenue_cal_type
1189: FROM pa_proj_fp_options
1190: WHERE project_id = p_project_id
1191: AND fin_plan_version_id = l_working_version_id
1192: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;
1193:
1194: IF l_preference_code = 'SEP' THEN
1195: SELECT revenue_time_phased_code
1196: INTO l_revenue_cal_type

Line 1200: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;

1196: INTO l_revenue_cal_type
1197: FROM pa_proj_fp_options
1198: WHERE project_id = p_project_id
1199: AND fin_plan_version_id = p_rev_version_id
1200: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;
1201: END IF ;
1202:
1203: IF l_preference_code = 'REVENUE' THEN
1204: x_calendar_type := l_revenue_cal_type;

Line 1255: IF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_P THEN

1251: x_time_phase_valid_flag := 'Y';
1252: END IF;
1253:
1254:
1255: IF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_P THEN
1256: x_calendar_id := l_pa_calendar_id;
1257: ELSIF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_G THEN
1258: x_calendar_id := l_gl_calendar_id;
1259: END IF;

Line 1257: ELSIF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_G THEN

1253:
1254:
1255: IF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_P THEN
1256: x_calendar_id := l_pa_calendar_id;
1257: ELSIF x_calendar_type = Pa_Fp_Constants_Pkg.G_TIME_PHASED_CODE_G THEN
1258: x_calendar_id := l_gl_calendar_id;
1259: END IF;
1260:
1261: IF g_debug_mode = 'Y' THEN

Line 1295: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;

1291: INTO l_version_type
1292: FROM pa_proj_fp_options
1293: WHERE project_id = p_project_id
1294: AND fin_plan_type_id = p_fin_plan_type_id
1295: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;
1296:
1297: IF l_version_type = Pa_Fp_Constants_Pkg.G_PREF_COST_AND_REV_SAME THEN
1298: l_version_type := Pa_Fp_Constants_Pkg.G_VERSION_TYPE_ALL;
1299: ELSE

Line 1297: IF l_version_type = Pa_Fp_Constants_Pkg.G_PREF_COST_AND_REV_SAME THEN

1293: WHERE project_id = p_project_id
1294: AND fin_plan_type_id = p_fin_plan_type_id
1295: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;
1296:
1297: IF l_version_type = Pa_Fp_Constants_Pkg.G_PREF_COST_AND_REV_SAME THEN
1298: l_version_type := Pa_Fp_Constants_Pkg.G_VERSION_TYPE_ALL;
1299: ELSE
1300: l_version_type := p_version_type;
1301: END IF;

Line 1298: l_version_type := Pa_Fp_Constants_Pkg.G_VERSION_TYPE_ALL;

1294: AND fin_plan_type_id = p_fin_plan_type_id
1295: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;
1296:
1297: IF l_version_type = Pa_Fp_Constants_Pkg.G_PREF_COST_AND_REV_SAME THEN
1298: l_version_type := Pa_Fp_Constants_Pkg.G_VERSION_TYPE_ALL;
1299: ELSE
1300: l_version_type := p_version_type;
1301: END IF;
1302:

Line 1417: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

1413: ,x_msg_data=>x_msg_data);
1414:
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

Line 1442: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

1438: ,x_msg_data=>x_msg_data);
1439:
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

Line 1467: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

1463: ,x_msg_data=>x_msg_data);
1464:
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

Line 1507: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

1503: ,x_msg_data=>x_msg_data);
1504:
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

Line 3238: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

3234:
3235: l_plan_type_id := l_cost_plan_type_id;
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,

Line 3268: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

3264: l_plan_type_id := l_rev_plan_type_id;
3265:
3266: l_rev_version_type :=Get_Version_Type( p_project_id,
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,

Line 3343: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

3339: l_plan_type_id := l_cost_plan_type_id;
3340:
3341: l_cost_version_type :=Get_Version_Type(p_project_id,
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,

Line 3373: Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

3369: l_plan_type_id := l_rev_plan_type_id;
3370:
3371: l_rev_version_type :=Get_Version_Type( p_project_id,
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,

Line 4833: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

4829:
4830: BEGIN
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

Line 4873: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

4869:
4870: BEGIN
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

Line 4917: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

4913:
4914: BEGIN
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

Line 4957: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

4953:
4954: BEGIN
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

Line 5000: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_COST);

4996:
4997: BEGIN
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

Line 5064: ,Pa_Fp_Constants_Pkg.G_VERSION_TYPE_REVENUE);

5060:
5061: BEGIN
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