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_FIN_PLAN_PUB dependencies on GL_PERIODS

Line 3620: l_act_period_type gl_periods.period_type%TYPE;

3616: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
3617: l_org_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
3618: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
3619: l_period_set_name pa_implementations_all.period_set_name%TYPE;
3620: l_act_period_type gl_periods.period_type%TYPE;
3621: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
3622: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
3623: l_request_id pa_budget_versions.request_id%TYPE;
3624: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;

Line 5297: l_gl_start_period gl_periods.period_name%TYPE;

5293: /* End of variable definition for bug 2661237 */
5294:
5295: l_res_list_uncategorized_flag VARCHAR2(1);
5296: l_res_list_control_flag VARCHAR2(1);
5297: l_gl_start_period gl_periods.period_name%TYPE;
5298: l_gl_end_period gl_periods.period_name%TYPE;
5299: l_gl_start_Date VARCHAR2(100);
5300: l_pa_start_period pa_periods_all.period_name%TYPE;
5301: l_pa_end_period pa_periods_all.period_name%TYPE;

Line 5298: l_gl_end_period gl_periods.period_name%TYPE;

5294:
5295: l_res_list_uncategorized_flag VARCHAR2(1);
5296: l_res_list_control_flag VARCHAR2(1);
5297: l_gl_start_period gl_periods.period_name%TYPE;
5298: l_gl_end_period gl_periods.period_name%TYPE;
5299: l_gl_start_Date VARCHAR2(100);
5300: l_pa_start_period pa_periods_all.period_name%TYPE;
5301: l_pa_end_period pa_periods_all.period_name%TYPE;
5302: l_pa_start_date VARCHAR2(100);

Line 7108: l_start_date gl_periods.start_date%TYPE;

7104: l_msg_index_out NUMBER;
7105: l_debug_mode VARCHAR2(30);
7106:
7107:
7108: l_start_date gl_periods.start_date%TYPE;
7109: l_end_date gl_periods.end_date%TYPE;
7110: l_profile_start_date gl_periods.start_date%TYPE;
7111: l_profile_end_date gl_periods.end_date%TYPE;
7112:

Line 7109: l_end_date gl_periods.end_date%TYPE;

7105: l_debug_mode VARCHAR2(30);
7106:
7107:
7108: l_start_date gl_periods.start_date%TYPE;
7109: l_end_date gl_periods.end_date%TYPE;
7110: l_profile_start_date gl_periods.start_date%TYPE;
7111: l_profile_end_date gl_periods.end_date%TYPE;
7112:
7113: l_project_start_date gl_periods.start_date%TYPE;

Line 7110: l_profile_start_date gl_periods.start_date%TYPE;

7106:
7107:
7108: l_start_date gl_periods.start_date%TYPE;
7109: l_end_date gl_periods.end_date%TYPE;
7110: l_profile_start_date gl_periods.start_date%TYPE;
7111: l_profile_end_date gl_periods.end_date%TYPE;
7112:
7113: l_project_start_date gl_periods.start_date%TYPE;
7114: l_project_completion_date gl_periods.end_date%TYPE;

Line 7111: l_profile_end_date gl_periods.end_date%TYPE;

7107:
7108: l_start_date gl_periods.start_date%TYPE;
7109: l_end_date gl_periods.end_date%TYPE;
7110: l_profile_start_date gl_periods.start_date%TYPE;
7111: l_profile_end_date gl_periods.end_date%TYPE;
7112:
7113: l_project_start_date gl_periods.start_date%TYPE;
7114: l_project_completion_date gl_periods.end_date%TYPE;
7115:

Line 7113: l_project_start_date gl_periods.start_date%TYPE;

7109: l_end_date gl_periods.end_date%TYPE;
7110: l_profile_start_date gl_periods.start_date%TYPE;
7111: l_profile_end_date gl_periods.end_date%TYPE;
7112:
7113: l_project_start_date gl_periods.start_date%TYPE;
7114: l_project_completion_date gl_periods.end_date%TYPE;
7115:
7116: l_number_of_periods NUMBER;
7117: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

Line 7114: l_project_completion_date gl_periods.end_date%TYPE;

7110: l_profile_start_date gl_periods.start_date%TYPE;
7111: l_profile_end_date gl_periods.end_date%TYPE;
7112:
7113: l_project_start_date gl_periods.start_date%TYPE;
7114: l_project_completion_date gl_periods.end_date%TYPE;
7115:
7116: l_number_of_periods NUMBER;
7117: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
7118: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

Line 7121: l_plan_start_date gl_periods.start_date%TYPE;

7117: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
7118: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
7119: l_pa_period_type pa_implementations.pa_period_type%TYPE;
7120:
7121: l_plan_start_date gl_periods.start_date%TYPE;
7122: l_plan_end_date gl_periods.end_date%TYPE;
7123:
7124: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
7125:

Line 7122: l_plan_end_date gl_periods.end_date%TYPE;

7118: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
7119: l_pa_period_type pa_implementations.pa_period_type%TYPE;
7120:
7121: l_plan_start_date gl_periods.start_date%TYPE;
7122: l_plan_end_date gl_periods.end_date%TYPE;
7123:
7124: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
7125:
7126: BEGIN

Line 8182: Plan version is tim phased by PA or GL periods. */

8178:
8179:
8180: /* Call PA_PLAN_MATRIX.MAINTAIN_PLAN_MATRIX to populate the Denorm table
8181: 'PA_PROJ_PERIODS_DENORM' in order to report in a matrix format if the
8182: Plan version is tim phased by PA or GL periods. */
8183:
8184: /* First populate the amt_rec PL/SQL table with the Amount Type and the
8185: Amount Sub Type codes based on the Budget Version Type
8186: to pass to the Maintain Plan Matrix procedure. */