5: -- Assign the glboal variables to the local variable
6: -- This aviods repeated calls to the global package
7:
8: -- Balance Type
9: l_balance_type VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_FORECAST_C;
10:
11: -- Input Parameters.
12: l_fc_start_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
13: l_fc_end_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
8: -- Balance Type
9: l_balance_type VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_FORECAST_C;
10:
11: -- Input Parameters.
12: l_fc_start_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
13: l_fc_end_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
14:
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
9: l_balance_type VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_FORECAST_C;
10:
11: -- Input Parameters.
12: l_fc_start_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
13: l_fc_end_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
14:
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
12: l_fc_start_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
13: l_fc_end_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
14:
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:
13: l_fc_end_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
14:
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:
21: -- Implementation options
14:
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:
21: -- Implementation options
22: l_org_id pa_implementations.org_id%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:
21: -- Implementation options
22: l_org_id pa_implementations.org_id%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;
23:
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:
21: -- Implementation options
22: l_org_id pa_implementations.org_id%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;
23:
24: -- Profile Options
25: l_global_week_start_day PLS_INTEGER := PA_REP_UTIL_GLOB.G_global_week_start_day;
26: l_fetch_size PLS_INTEGER := PA_REP_UTIL_GLOB.G_util_fetch_size;
21: -- Implementation options
22: l_org_id pa_implementations.org_id%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;
23:
24: -- Profile Options
25: l_global_week_start_day PLS_INTEGER := PA_REP_UTIL_GLOB.G_global_week_start_day;
26: l_fetch_size PLS_INTEGER := PA_REP_UTIL_GLOB.G_util_fetch_size;
27:
28: -- Period Information
29: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
22: l_org_id pa_implementations.org_id%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;
23:
24: -- Profile Options
25: l_global_week_start_day PLS_INTEGER := PA_REP_UTIL_GLOB.G_global_week_start_day;
26: l_fetch_size PLS_INTEGER := PA_REP_UTIL_GLOB.G_util_fetch_size;
27:
28: -- Period Information
29: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
30: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
25: l_global_week_start_day PLS_INTEGER := PA_REP_UTIL_GLOB.G_global_week_start_day;
26: l_fetch_size PLS_INTEGER := PA_REP_UTIL_GLOB.G_util_fetch_size;
27:
28: -- Period Information
29: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
30: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
31: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019
32: l_pa_period_type pa_implementations.pa_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_type;
33: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_type;
26: l_fetch_size PLS_INTEGER := PA_REP_UTIL_GLOB.G_util_fetch_size;
27:
28: -- Period Information
29: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
30: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
31: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019
32: l_pa_period_type pa_implementations.pa_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_type;
33: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_type;
34:
27:
28: -- Period Information
29: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
30: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
31: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019
32: l_pa_period_type pa_implementations.pa_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_type;
33: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_type;
34:
35: -- Who Columns
28: -- Period Information
29: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
30: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
31: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019
32: l_pa_period_type pa_implementations.pa_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_type;
33: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_type;
34:
35: -- Who Columns
36: l_created_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
29: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
30: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
31: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019
32: l_pa_period_type pa_implementations.pa_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_type;
33: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_type;
34:
35: -- Who Columns
36: l_created_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
37: l_last_updated_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
32: l_pa_period_type pa_implementations.pa_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_type;
33: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_type;
34:
35: -- Who Columns
36: l_created_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
37: l_last_updated_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
38: l_request_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
39: l_program_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
40: l_program_application_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
33: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_type;
34:
35: -- Who Columns
36: l_created_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
37: l_last_updated_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
38: l_request_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
39: l_program_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
40: l_program_application_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
41: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
34:
35: -- Who Columns
36: l_created_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
37: l_last_updated_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
38: l_request_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
39: l_program_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
40: l_program_application_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
41: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
42: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
35: -- Who Columns
36: l_created_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
37: l_last_updated_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
38: l_request_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
39: l_program_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
40: l_program_application_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
41: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
42: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
43: l_program_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
36: l_created_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
37: l_last_updated_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
38: l_request_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
39: l_program_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
40: l_program_application_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
41: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
42: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
43: l_program_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
44:
37: l_last_updated_by NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
38: l_request_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
39: l_program_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
40: l_program_application_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
41: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
42: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
43: l_program_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
44:
45: l_debug_mode VARCHAR2(2) := PA_REP_UTIL_GLOB.G_input_parameters.G_debug_mode;
38: l_request_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
39: l_program_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
40: l_program_application_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
41: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
42: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
43: l_program_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
44:
45: l_debug_mode VARCHAR2(2) := PA_REP_UTIL_GLOB.G_input_parameters.G_debug_mode;
46: l_quantity_id pa_amount_types_b.amount_type_id%TYPE := PA_REP_UTIL_GLOB. G_amt_type_details.G_quantity_id;
39: l_program_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
40: l_program_application_id NUMBER(15) := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
41: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
42: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
43: l_program_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
44:
45: l_debug_mode VARCHAR2(2) := PA_REP_UTIL_GLOB.G_input_parameters.G_debug_mode;
46: l_quantity_id pa_amount_types_b.amount_type_id%TYPE := PA_REP_UTIL_GLOB. G_amt_type_details.G_quantity_id;
47: l_org_rollup_method VARCHAR2(1) := PA_REP_UTIL_GLOB.G_input_parameters.G_org_rollup_method;
41: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
42: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
43: l_program_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
44:
45: l_debug_mode VARCHAR2(2) := PA_REP_UTIL_GLOB.G_input_parameters.G_debug_mode;
46: l_quantity_id pa_amount_types_b.amount_type_id%TYPE := PA_REP_UTIL_GLOB. G_amt_type_details.G_quantity_id;
47: l_org_rollup_method VARCHAR2(1) := PA_REP_UTIL_GLOB.G_input_parameters.G_org_rollup_method;
48:
49: -------------------------------------------------------
42: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
43: l_program_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
44:
45: l_debug_mode VARCHAR2(2) := PA_REP_UTIL_GLOB.G_input_parameters.G_debug_mode;
46: l_quantity_id pa_amount_types_b.amount_type_id%TYPE := PA_REP_UTIL_GLOB. G_amt_type_details.G_quantity_id;
47: l_org_rollup_method VARCHAR2(1) := PA_REP_UTIL_GLOB.G_input_parameters.G_org_rollup_method;
48:
49: -------------------------------------------------------
50: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
43: l_program_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
44:
45: l_debug_mode VARCHAR2(2) := PA_REP_UTIL_GLOB.G_input_parameters.G_debug_mode;
46: l_quantity_id pa_amount_types_b.amount_type_id%TYPE := PA_REP_UTIL_GLOB. G_amt_type_details.G_quantity_id;
47: l_org_rollup_method VARCHAR2(1) := PA_REP_UTIL_GLOB.G_input_parameters.G_org_rollup_method;
48:
49: -------------------------------------------------------
50: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
51: