eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_BUDGET_VERSIONS

Line 90: pa_budget_versions bv,

86: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */
87: FROM
88: ( select p_project_id project_id from dual ) map,
89: -- pji_pjp_rbs_header rhd,
90: pa_budget_versions bv,
91: pa_proj_fp_options fpo,
92: -- pji_pa_proj_events_log pel,
93: pa_projects_all ppa,
94: pa_rbs_versions_b rvb --Added for bug#5728852

Line 1101: FROM pa_budget_versions

1097:
1098:
1099: /* SELECT fin_plan_type_id
1100: INTO l_fin_plan_type_id
1101: FROM pa_budget_versions
1102: WHERE budget_version_id = p_plan_version_id;
1103: */
1104: Derive_VP_Calendar_Info(
1105: p_project_id

Line 1283: l_version_type pa_budget_versions.version_type%TYPE;

1279: p_project_id NUMBER
1280: , p_fin_plan_type_id NUMBER
1281: , p_version_type VARCHAR2
1282: ) RETURN VARCHAR2 IS
1283: l_version_type pa_budget_versions.version_type%TYPE;
1284: BEGIN
1285:
1286: IF g_debug_mode = 'Y' THEN
1287: Pji_Utils.WRITE2LOG( 'get_version_type: beginning', TRUE , g_proc);

Line 1338: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;

1334: , x_prior_revfcst_version_id OUT NOCOPY NUMBER
1335: , x_return_status IN OUT NOCOPY VARCHAR2
1336: , x_msg_count IN OUT NOCOPY NUMBER
1337: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1338: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1339: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1340: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1341: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1342: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 1339: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;

1335: , x_return_status IN OUT NOCOPY VARCHAR2
1336: , x_msg_count IN OUT NOCOPY NUMBER
1337: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1338: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1339: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1340: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1341: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1342: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1343: l_temp_holder1 NUMBER;

Line 1340: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;

1336: , x_msg_count IN OUT NOCOPY NUMBER
1337: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1338: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1339: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1340: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1341: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1342: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1343: l_temp_holder1 NUMBER;
1344: l_temp_holder2 NUMBER;

Line 1341: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;

1337: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1338: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1339: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1340: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1341: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1342: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1343: l_temp_holder1 NUMBER;
1344: l_temp_holder2 NUMBER;
1345: BEGIN

Line 2090: pa_budget_versions b

2086: AND NVL(p.pjt_rollup_enabled_flag,0) = 'N'
2087: UNION ALL
2088: SELECT pa_project_structure_utils.GET_FIN_STRUC_VER_ID(p_project_id)
2089: FROM pa_projects_all p ,
2090: pa_budget_versions b
2091: WHERE p.project_id = p_project_id
2092: AND b.project_id = p.project_id
2093: AND b.budget_version_id = p_plan_version_id
2094: AND fin_plan_type_id <> 10

Line 2099: pa_budget_versions b

2095: AND NVL(p.pjt_rollup_enabled_flag,0) = 'Y'
2096: UNION ALL
2097: SELECT b.project_structure_version_id
2098: FROM pa_projects_all p ,
2099: pa_budget_versions b
2100: WHERE p.project_id = p_project_id
2101: AND b.project_id = p.project_id
2102: AND b.budget_version_id = p_plan_version_id
2103: AND fin_plan_type_id = 10

Line 2468: FROM pa_budget_versions

2464: END IF;
2465:
2466: SELECT version_number, version_name, record_version_number,budget_status_code
2467: INTO x_version_no, x_version_name, x_version_record_no , x_budget_status_code
2468: FROM pa_budget_versions
2469: WHERE budget_version_id = p_version_id;
2470:
2471: IF g_debug_mode = 'Y' THEN
2472: Pji_Utils.WRITE2LOG( 'derive_version_parameters: finishing', TRUE , g_proc);

Line 4773: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;

4769: , x_return_status IN OUT NOCOPY VARCHAR2
4770: , x_msg_count IN OUT NOCOPY NUMBER
4771: , x_msg_data IN OUT NOCOPY VARCHAR2)
4772: IS
4773: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4774: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4775: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4776: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4777: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;

Line 4774: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;

4770: , x_msg_count IN OUT NOCOPY NUMBER
4771: , x_msg_data IN OUT NOCOPY VARCHAR2)
4772: IS
4773: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4774: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4775: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4776: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4777: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4778: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;

Line 4775: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;

4771: , x_msg_data IN OUT NOCOPY VARCHAR2)
4772: IS
4773: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4774: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4775: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4776: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4777: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4778: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4779: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 4776: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;

4772: IS
4773: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4774: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4775: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4776: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4777: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4778: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4779: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4780: l_temp_holder1 NUMBER;

Line 4777: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;

4773: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4774: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4775: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4776: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4777: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4778: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4779: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4780: l_temp_holder1 NUMBER;
4781: l_temp_holder2 NUMBER;

Line 4778: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;

4774: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4775: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4776: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4777: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4778: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4779: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4780: l_temp_holder1 NUMBER;
4781: l_temp_holder2 NUMBER;
4782: l_temp_cstforecast_version_id NUMBER;