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 7817: -- Shift the pa_periods by l_periods

7813: populate_cpy_periods_tmp(p_budget_version_id => p_source_plan_version_id,
7814: p_period_type => l_target_time_phased_code,
7815: p_shift_periods => l_periods);
7816:
7817: -- Shift the pa_periods by l_periods
7818: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7819: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7820: -- pa_fp_cpy_periods_tmp
7821:

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

7814: p_period_type => l_target_time_phased_code,
7815: p_shift_periods => l_periods);
7816:
7817: -- Shift the pa_periods by l_periods
7818: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7819: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7820: -- pa_fp_cpy_periods_tmp
7821:
7822: INSERT INTO PA_BUDGET_LINES(

Line 8310: l_plan_start_date pa_periods.start_date%TYPE;

8306: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
8307: l_pa_period_type pa_implementations.pa_period_type%TYPE;
8308:
8309: l_number_of_periods NUMBER;
8310: l_plan_start_date pa_periods.start_date%TYPE;
8311: l_plan_end_date pa_periods.end_date%TYPE;
8312:
8313: l_start_period pa_periods.period_name%TYPE;
8314: l_start_period_start_date pa_periods.start_date%TYPE;

Line 8311: l_plan_end_date pa_periods.end_date%TYPE;

8307: l_pa_period_type pa_implementations.pa_period_type%TYPE;
8308:
8309: l_number_of_periods NUMBER;
8310: l_plan_start_date pa_periods.start_date%TYPE;
8311: l_plan_end_date pa_periods.end_date%TYPE;
8312:
8313: l_start_period pa_periods.period_name%TYPE;
8314: l_start_period_start_date pa_periods.start_date%TYPE;
8315: l_start_period_end_date pa_periods.end_date%TYPE;

Line 8313: l_start_period pa_periods.period_name%TYPE;

8309: l_number_of_periods NUMBER;
8310: l_plan_start_date pa_periods.start_date%TYPE;
8311: l_plan_end_date pa_periods.end_date%TYPE;
8312:
8313: l_start_period pa_periods.period_name%TYPE;
8314: l_start_period_start_date pa_periods.start_date%TYPE;
8315: l_start_period_end_date pa_periods.end_date%TYPE;
8316:
8317: l_end_period pa_periods.period_name%TYPE;

Line 8314: l_start_period_start_date pa_periods.start_date%TYPE;

8310: l_plan_start_date pa_periods.start_date%TYPE;
8311: l_plan_end_date pa_periods.end_date%TYPE;
8312:
8313: l_start_period pa_periods.period_name%TYPE;
8314: l_start_period_start_date pa_periods.start_date%TYPE;
8315: l_start_period_end_date pa_periods.end_date%TYPE;
8316:
8317: l_end_period pa_periods.period_name%TYPE;
8318: l_end_period_start_date pa_periods.start_date%TYPE;

Line 8315: l_start_period_end_date pa_periods.end_date%TYPE;

8311: l_plan_end_date pa_periods.end_date%TYPE;
8312:
8313: l_start_period pa_periods.period_name%TYPE;
8314: l_start_period_start_date pa_periods.start_date%TYPE;
8315: l_start_period_end_date pa_periods.end_date%TYPE;
8316:
8317: l_end_period pa_periods.period_name%TYPE;
8318: l_end_period_start_date pa_periods.start_date%TYPE;
8319: l_end_period_end_date pa_periods.end_date%TYPE;

Line 8317: l_end_period pa_periods.period_name%TYPE;

8313: l_start_period pa_periods.period_name%TYPE;
8314: l_start_period_start_date pa_periods.start_date%TYPE;
8315: l_start_period_end_date pa_periods.end_date%TYPE;
8316:
8317: l_end_period pa_periods.period_name%TYPE;
8318: l_end_period_start_date pa_periods.start_date%TYPE;
8319: l_end_period_end_date pa_periods.end_date%TYPE;
8320:
8321: l_target_proj_gl_start_period gl_periods.period_name%TYPE;

Line 8318: l_end_period_start_date pa_periods.start_date%TYPE;

8314: l_start_period_start_date pa_periods.start_date%TYPE;
8315: l_start_period_end_date pa_periods.end_date%TYPE;
8316:
8317: l_end_period pa_periods.period_name%TYPE;
8318: l_end_period_start_date pa_periods.start_date%TYPE;
8319: l_end_period_end_date pa_periods.end_date%TYPE;
8320:
8321: l_target_proj_gl_start_period gl_periods.period_name%TYPE;
8322: l_target_proj_gl_end_period gl_periods.period_name%TYPE;

Line 8319: l_end_period_end_date pa_periods.end_date%TYPE;

8315: l_start_period_end_date pa_periods.end_date%TYPE;
8316:
8317: l_end_period pa_periods.period_name%TYPE;
8318: l_end_period_start_date pa_periods.start_date%TYPE;
8319: l_end_period_end_date pa_periods.end_date%TYPE;
8320:
8321: l_target_proj_gl_start_period gl_periods.period_name%TYPE;
8322: l_target_proj_gl_end_period gl_periods.period_name%TYPE;
8323: l_target_proj_pa_start_period pa_periods.period_name%TYPE;

Line 8323: l_target_proj_pa_start_period pa_periods.period_name%TYPE;

8319: l_end_period_end_date pa_periods.end_date%TYPE;
8320:
8321: l_target_proj_gl_start_period gl_periods.period_name%TYPE;
8322: l_target_proj_gl_end_period gl_periods.period_name%TYPE;
8323: l_target_proj_pa_start_period pa_periods.period_name%TYPE;
8324: l_target_proj_pa_end_period pa_periods.period_name%TYPE;
8325:
8326: l_target_proj_start_period pa_periods.period_name%TYPE;
8327: l_target_proj_end_period pa_periods.period_name%TYPE;

Line 8324: l_target_proj_pa_end_period pa_periods.period_name%TYPE;

8320:
8321: l_target_proj_gl_start_period gl_periods.period_name%TYPE;
8322: l_target_proj_gl_end_period gl_periods.period_name%TYPE;
8323: l_target_proj_pa_start_period pa_periods.period_name%TYPE;
8324: l_target_proj_pa_end_period pa_periods.period_name%TYPE;
8325:
8326: l_target_proj_start_period pa_periods.period_name%TYPE;
8327: l_target_proj_end_period pa_periods.period_name%TYPE;
8328:

Line 8326: l_target_proj_start_period pa_periods.period_name%TYPE;

8322: l_target_proj_gl_end_period gl_periods.period_name%TYPE;
8323: l_target_proj_pa_start_period pa_periods.period_name%TYPE;
8324: l_target_proj_pa_end_period pa_periods.period_name%TYPE;
8325:
8326: l_target_proj_start_period pa_periods.period_name%TYPE;
8327: l_target_proj_end_period pa_periods.period_name%TYPE;
8328:
8329: l_dummy_flag VARCHAR2(1);
8330: l_dummy1 VARCHAR2(30);

Line 8327: l_target_proj_end_period pa_periods.period_name%TYPE;

8323: l_target_proj_pa_start_period pa_periods.period_name%TYPE;
8324: l_target_proj_pa_end_period pa_periods.period_name%TYPE;
8325:
8326: l_target_proj_start_period pa_periods.period_name%TYPE;
8327: l_target_proj_end_period pa_periods.period_name%TYPE;
8328:
8329: l_dummy_flag VARCHAR2(1);
8330: l_dummy1 VARCHAR2(30);
8331: l_dummy2 VARCHAR2(30);

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

8447: END;
8448:
8449:
8450: -- Fetch the target project start and completion dates
8451: -- Fetch the GL/PA periods into which the target project start and completion dates fall.
8452: IF p_pa_debug_mode = 'Y' THEN
8453: pa_debug.g_err_stage:= 'Calling Pa_Prj_Period_Profile_Utils.Get_Prj_Defaults';
8454: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
8455: END IF;

Line 8497: FROM pa_periods

8493: SELECT period_name
8494: ,start_date
8495: INTO l_start_period
8496: ,l_start_period_start_date
8497: FROM pa_periods
8498: WHERE TRUNC(source_profile_info_rec.period1_start_date + p_shift_days) BETWEEN start_date AND end_date;
8499:
8500: ELSIF source_profile_info_rec.plan_period_type = 'GL' THEN
8501: