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.PA_FP_COPY_FROM_PKG dependencies on PA_PERIODS

Line 1064: l_pa_start_period pa_periods_all.period_name%TYPE;

1060:
1061: l_gl_start_period gl_periods.period_name%TYPE;
1062: l_gl_end_period gl_periods.period_name%TYPE;
1063: l_gl_start_Date VARCHAR2(100);
1064: l_pa_start_period pa_periods_all.period_name%TYPE;
1065: l_pa_end_period pa_periods_all.period_name%TYPE;
1066: l_pa_start_date VARCHAR2(100);
1067: l_plan_version_exists_flag VARCHAR2(1);
1068: l_prj_start_date VARCHAR2(100);

Line 1065: l_pa_end_period pa_periods_all.period_name%TYPE;

1061: l_gl_start_period gl_periods.period_name%TYPE;
1062: l_gl_end_period gl_periods.period_name%TYPE;
1063: l_gl_start_Date VARCHAR2(100);
1064: l_pa_start_period pa_periods_all.period_name%TYPE;
1065: l_pa_end_period pa_periods_all.period_name%TYPE;
1066: l_pa_start_date VARCHAR2(100);
1067: l_plan_version_exists_flag VARCHAR2(1);
1068: l_prj_start_date VARCHAR2(100);
1069: l_prj_end_date VARCHAR2(100);

Line 7844: -- Shift the pa_periods by l_periods

7840: populate_cpy_periods_tmp(p_budget_version_id => p_source_plan_version_id,
7841: p_period_type => l_target_time_phased_code,
7842: p_shift_periods => l_periods);
7843:
7844: -- Shift the pa_periods by l_periods
7845: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7846: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7847: -- pa_fp_cpy_periods_tmp
7848:

Line 7845: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based

7841: p_period_type => l_target_time_phased_code,
7842: p_shift_periods => l_periods);
7843:
7844: -- Shift the pa_periods by l_periods
7845: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7846: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7847: -- pa_fp_cpy_periods_tmp
7848:
7849: INSERT INTO PA_BUDGET_LINES(

Line 8337: l_plan_start_date pa_periods.start_date%TYPE;

8333: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
8334: l_pa_period_type pa_implementations.pa_period_type%TYPE;
8335:
8336: l_number_of_periods NUMBER;
8337: l_plan_start_date pa_periods.start_date%TYPE;
8338: l_plan_end_date pa_periods.end_date%TYPE;
8339:
8340: l_start_period pa_periods.period_name%TYPE;
8341: l_start_period_start_date pa_periods.start_date%TYPE;

Line 8338: l_plan_end_date pa_periods.end_date%TYPE;

8334: l_pa_period_type pa_implementations.pa_period_type%TYPE;
8335:
8336: l_number_of_periods NUMBER;
8337: l_plan_start_date pa_periods.start_date%TYPE;
8338: l_plan_end_date pa_periods.end_date%TYPE;
8339:
8340: l_start_period pa_periods.period_name%TYPE;
8341: l_start_period_start_date pa_periods.start_date%TYPE;
8342: l_start_period_end_date pa_periods.end_date%TYPE;

Line 8340: l_start_period pa_periods.period_name%TYPE;

8336: l_number_of_periods NUMBER;
8337: l_plan_start_date pa_periods.start_date%TYPE;
8338: l_plan_end_date pa_periods.end_date%TYPE;
8339:
8340: l_start_period pa_periods.period_name%TYPE;
8341: l_start_period_start_date pa_periods.start_date%TYPE;
8342: l_start_period_end_date pa_periods.end_date%TYPE;
8343:
8344: l_end_period pa_periods.period_name%TYPE;

Line 8341: l_start_period_start_date pa_periods.start_date%TYPE;

8337: l_plan_start_date pa_periods.start_date%TYPE;
8338: l_plan_end_date pa_periods.end_date%TYPE;
8339:
8340: l_start_period pa_periods.period_name%TYPE;
8341: l_start_period_start_date pa_periods.start_date%TYPE;
8342: l_start_period_end_date pa_periods.end_date%TYPE;
8343:
8344: l_end_period pa_periods.period_name%TYPE;
8345: l_end_period_start_date pa_periods.start_date%TYPE;

Line 8342: l_start_period_end_date pa_periods.end_date%TYPE;

8338: l_plan_end_date pa_periods.end_date%TYPE;
8339:
8340: l_start_period pa_periods.period_name%TYPE;
8341: l_start_period_start_date pa_periods.start_date%TYPE;
8342: l_start_period_end_date pa_periods.end_date%TYPE;
8343:
8344: l_end_period pa_periods.period_name%TYPE;
8345: l_end_period_start_date pa_periods.start_date%TYPE;
8346: l_end_period_end_date pa_periods.end_date%TYPE;

Line 8344: l_end_period pa_periods.period_name%TYPE;

8340: l_start_period pa_periods.period_name%TYPE;
8341: l_start_period_start_date pa_periods.start_date%TYPE;
8342: l_start_period_end_date pa_periods.end_date%TYPE;
8343:
8344: l_end_period pa_periods.period_name%TYPE;
8345: l_end_period_start_date pa_periods.start_date%TYPE;
8346: l_end_period_end_date pa_periods.end_date%TYPE;
8347:
8348: l_target_proj_gl_start_period gl_periods.period_name%TYPE;

Line 8345: l_end_period_start_date pa_periods.start_date%TYPE;

8341: l_start_period_start_date pa_periods.start_date%TYPE;
8342: l_start_period_end_date pa_periods.end_date%TYPE;
8343:
8344: l_end_period pa_periods.period_name%TYPE;
8345: l_end_period_start_date pa_periods.start_date%TYPE;
8346: l_end_period_end_date pa_periods.end_date%TYPE;
8347:
8348: l_target_proj_gl_start_period gl_periods.period_name%TYPE;
8349: l_target_proj_gl_end_period gl_periods.period_name%TYPE;

Line 8346: l_end_period_end_date pa_periods.end_date%TYPE;

8342: l_start_period_end_date pa_periods.end_date%TYPE;
8343:
8344: l_end_period pa_periods.period_name%TYPE;
8345: l_end_period_start_date pa_periods.start_date%TYPE;
8346: l_end_period_end_date pa_periods.end_date%TYPE;
8347:
8348: l_target_proj_gl_start_period gl_periods.period_name%TYPE;
8349: l_target_proj_gl_end_period gl_periods.period_name%TYPE;
8350: l_target_proj_pa_start_period pa_periods.period_name%TYPE;

Line 8350: l_target_proj_pa_start_period pa_periods.period_name%TYPE;

8346: l_end_period_end_date pa_periods.end_date%TYPE;
8347:
8348: l_target_proj_gl_start_period gl_periods.period_name%TYPE;
8349: l_target_proj_gl_end_period gl_periods.period_name%TYPE;
8350: l_target_proj_pa_start_period pa_periods.period_name%TYPE;
8351: l_target_proj_pa_end_period pa_periods.period_name%TYPE;
8352:
8353: l_target_proj_start_period pa_periods.period_name%TYPE;
8354: l_target_proj_end_period pa_periods.period_name%TYPE;

Line 8351: l_target_proj_pa_end_period pa_periods.period_name%TYPE;

8347:
8348: l_target_proj_gl_start_period gl_periods.period_name%TYPE;
8349: l_target_proj_gl_end_period gl_periods.period_name%TYPE;
8350: l_target_proj_pa_start_period pa_periods.period_name%TYPE;
8351: l_target_proj_pa_end_period pa_periods.period_name%TYPE;
8352:
8353: l_target_proj_start_period pa_periods.period_name%TYPE;
8354: l_target_proj_end_period pa_periods.period_name%TYPE;
8355:

Line 8353: l_target_proj_start_period pa_periods.period_name%TYPE;

8349: l_target_proj_gl_end_period gl_periods.period_name%TYPE;
8350: l_target_proj_pa_start_period pa_periods.period_name%TYPE;
8351: l_target_proj_pa_end_period pa_periods.period_name%TYPE;
8352:
8353: l_target_proj_start_period pa_periods.period_name%TYPE;
8354: l_target_proj_end_period pa_periods.period_name%TYPE;
8355:
8356: l_dummy_flag VARCHAR2(1);
8357: l_dummy1 VARCHAR2(30);

Line 8354: l_target_proj_end_period pa_periods.period_name%TYPE;

8350: l_target_proj_pa_start_period pa_periods.period_name%TYPE;
8351: l_target_proj_pa_end_period pa_periods.period_name%TYPE;
8352:
8353: l_target_proj_start_period pa_periods.period_name%TYPE;
8354: l_target_proj_end_period pa_periods.period_name%TYPE;
8355:
8356: l_dummy_flag VARCHAR2(1);
8357: l_dummy1 VARCHAR2(30);
8358: l_dummy2 VARCHAR2(30);

Line 8478: -- Fetch the GL/PA periods into which the target project start and completion dates fall.

8474: END;
8475:
8476:
8477: -- Fetch the target project start and completion dates
8478: -- Fetch the GL/PA periods into which the target project start and completion dates fall.
8479: IF p_pa_debug_mode = 'Y' THEN
8480: pa_debug.g_err_stage:= 'Calling Pa_Prj_Period_Profile_Utils.Get_Prj_Defaults';
8481: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
8482: END IF;

Line 8524: FROM pa_periods

8520: SELECT period_name
8521: ,start_date
8522: INTO l_start_period
8523: ,l_start_period_start_date
8524: FROM pa_periods
8525: WHERE TRUNC(source_profile_info_rec.period1_start_date + p_shift_days) BETWEEN start_date AND end_date;
8526:
8527: ELSIF source_profile_info_rec.plan_period_type = 'GL' THEN
8528: