[Home] [Help]
PACKAGE: APPS.PA_FORECAST_GLOBAL
Source
1 PACKAGE PA_FORECAST_GLOBAL AUTHID CURRENT_USER AS
2 /* $Header: PARFGGBS.pls 120.1 2005/08/19 16:51:34 mwasowic noship $ */
3 TYPE G_implementation_details_rec
4 IS RECORD (
5 G_org_id pa_implementations.org_id%TYPE
6 ,G_org_structure_version_id pa_implementations.org_structure_version_id%TYPE
7 ,G_start_organization_id pa_implementations.start_organization_id%TYPE
8 ,G_pa_period_type pa_implementations.pa_period_type%TYPE
9 ,G_gl_period_type gl_sets_of_books.accounted_period_type%TYPE
10 ,G_period_set_name gl_sets_of_books.period_set_name%TYPE
11 ,G_fcst_period_type pa_implementations.pa_period_type%TYPE
12 ,G_fcst_def_bem pa_budget_versions.BUDGET_ENTRY_METHOD_CODE%TYPE
13 ,G_fcst_res_list pa_resource_lists.RESOURCE_LIST_ID%TYPE
14 ,G_fcst_cost_rate_sch_id pa_forecasting_options.JOB_COST_RATE_SCHEDULE_ID%TYPE
15 );
16
17 TYPE G_util_option_details_rec
18 IS RECORD (
19 G_gl_period_flag pa_utilization_options.gl_period_flag%TYPE
20 ,G_pa_period_flag pa_utilization_options.pa_period_flag%TYPE
21 ,G_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE
22 ,G_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE
23 ,G_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE
24 ,G_util_calc_method VARCHAR2(30)
25 );
26 TYPE G_who_columns_rec
27 IS RECORD (
28 G_last_updated_by NUMBER(15)
29 ,G_created_by NUMBER(15)
30 ,G_creation_date DATE
31 ,G_last_update_date DATE
32 ,G_last_update_login NUMBER(15)
33 ,G_program_application_id NUMBER(15)
34 ,G_request_id NUMBER(15)
35 ,G_program_id NUMBER(15)
36 );
37 /*
38 * Variable definitions for the Global Record types.
39 */
40 G_who_columns G_who_columns_rec;
41 G_implementation_details G_implementation_details_rec;
42
43 G_fcst_global_flag VARCHAR2(1);
44 G_fcst_proceed_flag VARCHAR2(1):= 'Y';
45
46 PROCEDURE Initialize_Global(
47 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
48 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
49 x_ret_status IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
50 END PA_FORECAST_GLOBAL;