DBA Data[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;