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.

APPS.PJI_REP_UTIL dependencies on PA_BUDGET_VERSIONS

Line 765: FROM pa_budget_versions

761:
762:
763: /* SELECT fin_plan_type_id
764: INTO l_fin_plan_type_id
765: FROM pa_budget_versions
766: WHERE budget_version_id = p_plan_version_id;
767: */
768: Derive_VP_Calendar_Info(
769: p_project_id

Line 947: l_version_type pa_budget_versions.version_type%TYPE;

943: p_project_id NUMBER
944: , p_fin_plan_type_id NUMBER
945: , p_version_type VARCHAR2
946: ) RETURN VARCHAR2 IS
947: l_version_type pa_budget_versions.version_type%TYPE;
948: BEGIN
949:
950: IF g_debug_mode = 'Y' THEN
951: Pji_Utils.WRITE2LOG( 'get_version_type: beginning', TRUE , g_proc);

Line 1002: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;

998: , x_prior_revfcst_version_id OUT NOCOPY NUMBER
999: , x_return_status IN OUT NOCOPY VARCHAR2
1000: , x_msg_count IN OUT NOCOPY NUMBER
1001: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1002: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1003: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1004: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1005: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1006: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 1003: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;

999: , x_return_status IN OUT NOCOPY VARCHAR2
1000: , x_msg_count IN OUT NOCOPY NUMBER
1001: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1002: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1003: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1004: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1005: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1006: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1007: l_temp_holder1 NUMBER;

Line 1004: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;

1000: , x_msg_count IN OUT NOCOPY NUMBER
1001: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1002: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1003: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1004: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1005: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1006: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1007: l_temp_holder1 NUMBER;
1008: l_temp_holder2 NUMBER;

Line 1005: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;

1001: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
1002: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1003: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1004: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1005: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1006: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1007: l_temp_holder1 NUMBER;
1008: l_temp_holder2 NUMBER;
1009: BEGIN

Line 2078: FROM pa_budget_versions

2074: END IF;
2075:
2076: SELECT version_number, version_name, record_version_number,budget_status_code
2077: INTO x_version_no, x_version_name, x_version_record_no , x_budget_status_code
2078: FROM pa_budget_versions
2079: WHERE budget_version_id = p_version_id;
2080:
2081: IF g_debug_mode = 'Y' THEN
2082: Pji_Utils.WRITE2LOG( 'derive_version_parameters: finishing', TRUE , g_proc);

Line 4329: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;

4325: , x_return_status IN OUT NOCOPY VARCHAR2
4326: , x_msg_count IN OUT NOCOPY NUMBER
4327: , x_msg_data IN OUT NOCOPY VARCHAR2)
4328: IS
4329: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4330: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4331: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4332: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4333: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;

Line 4330: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;

4326: , x_msg_count IN OUT NOCOPY NUMBER
4327: , x_msg_data IN OUT NOCOPY VARCHAR2)
4328: IS
4329: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4330: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4331: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4332: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4333: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4334: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;

Line 4331: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;

4327: , x_msg_data IN OUT NOCOPY VARCHAR2)
4328: IS
4329: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4330: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4331: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4332: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4333: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4334: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4335: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 4332: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;

4328: IS
4329: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4330: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4331: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4332: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4333: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4334: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4335: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4336: l_temp_holder1 NUMBER;

Line 4333: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;

4329: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
4330: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4331: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4332: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4333: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4334: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4335: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4336: l_temp_holder1 NUMBER;
4337: l_temp_holder2 NUMBER;

Line 4334: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;

4330: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
4331: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4332: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4333: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4334: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4335: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4336: l_temp_holder1 NUMBER;
4337: l_temp_holder2 NUMBER;
4338: l_temp_cstforecast_version_id NUMBER;