[Home] [Help]
PACKAGE: APPS.FEM_GL_POST_PROCESS_PKG
Source
1 PACKAGE FEM_GL_POST_PROCESS_PKG AS
2 /* $Header: fem_gl_post_proc.pls 120.3 2006/04/26 17:24:48 ghall ship $ */
3
4 ----------------------------
5 -- Public Package Variables
6 ----------------------------
7
8 pv_sqlerrm VARCHAR2(512);
9 pv_callstack VARCHAR2(2000);
10
11 -- Populated from engine parameters by Validate_XGL_Eng_Parameters
12 -- or by Validate_OGL_Eng_Parameters
13
14 pv_ledger_id fem_ledgers_b.ledger_id%TYPE;
15 pv_cal_period_id fem_cal_periods_b.cal_period_id%TYPE;
16 pv_dataset_code fem_datasets_b.dataset_code%TYPE;
17 pv_rule_obj_def_id fem_object_definition_b.object_definition_id%TYPE;
18 pv_exec_mode VARCHAR2(30);
19 pv_qtd_ytd_code VARCHAR2(30);
20 pv_budget_id fem_budgets_b.budget_id%TYPE;
21 pv_enc_type_id fem_encumbrance_types_b.encumbrance_type_id%TYPE;
22
23 -- Populated by Get_Dim_IDs (called from Validate_Engine_Parameters)
24
25 pv_cal_per_dim_id fem_dimensions_b.dimension_id%TYPE;
26 pv_ledger_dim_id fem_dimensions_b.dimension_id%TYPE;
27 pv_dataset_dim_id fem_dimensions_b.dimension_id%TYPE;
28 pv_budget_dim_id fem_dimensions_b.dimension_id%TYPE;
29 pv_enc_type_dim_id fem_dimensions_b.dimension_id%TYPE;
30
31 -- Added for FEM-OGL Integration Project
32 pv_ext_acct_type_dim_id fem_dimensions_b.dimension_id%TYPE;
33 pv_nat_acct_dim_id fem_dimensions_b.dimension_id%TYPE;
34
35 -- Populated by Validate_Engine_Parameters
36
37 pv_req_id NUMBER;
38 pv_user_id NUMBER(15);
39 pv_login_id NUMBER(15);
40 pv_pgm_id NUMBER(15);
41 pv_pgm_app_id NUMBER(15);
42
43 pv_rule_obj_id fem_object_definition_b.object_id%TYPE;
44
45 pv_cal_per_dim_grp_dsp_cd fem_dimension_grps_b.dimension_group_display_code%TYPE;
46 pv_cal_per_end_date fem_cal_periods_attr.date_assign_value%TYPE;
47 pv_gl_per_number fem_cal_periods_attr.number_assign_value%TYPE;
48
49 pv_ledger_dsp_cd fem_ledgers_b.ledger_display_code%TYPE;
50 pv_ledger_per_hier_obj_id fem_object_catalog_b.object_id%TYPE;
51 pv_ledger_per_hier_obj_def_id fem_ledgers_attr.number_assign_value%TYPE;
52
53 pv_ds_balance_type_cd fem_datasets_attr.dim_attribute_varchar_member%TYPE;
54 pv_budget_dsp_cd fem_budgets_b.budget_display_code%TYPE;
55 pv_enc_type_dsp_cd fem_encumbrance_types_b.encumbrance_type_code%TYPE;
56 pv_entered_crncy_flag fem_flags_vl.flag_code%TYPE;
57
58 -- Populated by Validate_OGL_Eng_Parameters (Added for FEM-OGL Integration Project)
59 -- pv_signage_method VARCHAR2(30);
60 pv_adv_li_fe_mappings_flag VARCHAR2(1);
61 pv_global_vs_combo_id FEM_GLOBAL_VS_COMBOS_B.GLOBAL_VS_COMBO_ID%TYPE;
62 pv_max_delta_run_id NUMBER(15);
63 pv_gl_source_system_code FEM_SOURCE_SYSTEMS_B.SOURCE_SYSTEM_CODE%TYPE;
64
65 pv_rule_obj_def_name FEM_OBJECT_DEFINITION_TL.DISPLAY_NAME%TYPE;
66 pv_ledger_name GL_SETS_OF_BOOKS.NAME%TYPE;
67 pv_coa_id FEM_INTG_BAL_RULES.CHART_OF_ACCOUNTS_ID%TYPE;
68 pv_coa_name FND_ID_FLEX_STRUCTURES_TL.ID_FLEX_STRUCTURE_NAME%TYPE;
69 pv_include_avg_bal FEM_INTG_BAL_RULES.INCLUDE_AVG_BAL_FLAG%TYPE;
70 pv_bsv_app_col_name FEM_INTG_BAL_RULES.BAL_SEG_COLUMN_NAME%TYPE;
71 pv_maintain_qtd_flag FEM_INTG_BAL_RULES.MAINTAIN_QTD_FLAG%TYPE;
72
73 pv_bsv_option FEM_INTG_BAL_RULE_DEFS.BAL_SEG_VALUE_OPTION_CODE%TYPE;
74 pv_curr_option FEM_INTG_BAL_RULE_DEFS.CURRENCY_OPTION_CODE%TYPE;
75 pv_xlated_bal_option FEM_INTG_BAL_RULE_DEFS.XLATED_BAL_OPTION_CODE%TYPE;
76
77 pv_rule_eff_start_date FEM_OBJECT_DEFINITION_B.EFFECTIVE_START_DATE%TYPE;
78 pv_rule_eff_end_date FEM_OBJECT_DEFINITION_B.EFFECTIVE_START_DATE%TYPE;
79
80 pv_from_date DATE;
81 pv_to_date DATE;
82 pv_from_period_eff_num NUMBER(15);
83 pv_to_period_eff_num NUMBER(15);
84 pv_min_valid_period_eff_num NUMBER(15);
85 pv_max_valid_period_eff_num NUMBER(15);
86
87
88 -- Bug 4394404 hkaniven start - package variables to store the no of rows and the no
89 -- of valid rows, in the FEM_INTG_EXEC_PARAMS_GT
90 pv_num_rows NUMBER;
91 pv_num_rows_valid NUMBER;
92 -- Bug 4394404 hkaniven end - package variables to store the no of rows and the no
93 -- of valid rows, in the FEM_INTG_EXEC_PARAMS_GT
94
95 -- Populated by Get_Proc_Key_Info (called from Validate_Engine_Parameters)
96
97 TYPE xdim_info IS RECORD
98 (dimension_id NUMBER,
99 dim_vs_id NUMBER,
100 dim_vsr_flag VARCHAR2(1),
101 dim_col_name VARCHAR2(30),
102 dim_member_b_table_name VARCHAR2(30),
103 dim_member_col VARCHAR2(30),
104 dim_member_disp_code_col VARCHAR2(30),
105 dim_int_disp_code_col VARCHAR2(30),
106 dim_attr_table_name VARCHAR2(30));
107
108 TYPE proc_key_list IS VARRAY(50) OF xdim_info;
109
110 pv_proc_keys proc_key_list := proc_key_list();
111
112 pv_proc_key_dim_num NUMBER;
113
114 -- Populated by Main for Get_SSC
115
116 pv_ssc_where VARCHAR2(1100);
117
118 -- Populated by Get_SSC
119
120 TYPE src_sys_dsp_cd_rec IS RECORD
121 (display_code fem_source_systems_b.source_system_display_code%TYPE,
122 row_count NUMBER);
123
124 TYPE src_sys_dsp_cd_list IS TABLE OF src_sys_dsp_cd_rec
125 INDEX BY PLS_INTEGER;
126
127 pv_ssc_tbp src_sys_dsp_cd_list;
128 pv_ssc_np src_sys_dsp_cd_list;
129
130 -- Populated by Register_Process_Execution
131
132 pv_exec_state VARCHAR2(30); -- NORMAL, RESTART, RERUN
133 pv_prev_req_id NUMBER;
134
135 -- Added for FEM-OGL Integration Project
136 pv_stmt_type FEM_PL_TABLES.STATEMENT_TYPE%TYPE;
137 pv_from_gl_bal_flag VARCHAR2(1);
138 pv_from_gl_delta_flag VARCHAR2(1);
139 pv_func_ccy_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
140
141 ---------------------
142 -- Public Procedures
143 ---------------------
144
145 PROCEDURE Get_Proc_Key_Info
146 (p_process_slice IN VARCHAR2,
147 x_completion_code OUT NOCOPY NUMBER);
148
149 PROCEDURE Get_SSC
150 (p_dest_code IN VARCHAR2);
151
152 PROCEDURE Final_Process_Logging
153 (p_exec_status IN VARCHAR2,
154 p_num_data_errors IN NUMBER,
155 p_num_data_errors_reproc IN NUMBER,
156 p_num_output_rows IN NUMBER,
157 p_final_message_name IN VARCHAR2);
158
159 PROCEDURE Register_Process_Execution
160 (x_completion_code OUT NOCOPY NUMBER);
161
162
163 PROCEDURE Validate_XGL_Eng_Parameters
164 (p_ledger_id IN NUMBER,
165 p_cal_period_id IN NUMBER,
166 p_dataset_code IN NUMBER,
167 p_xgl_obj_def_id IN NUMBER,
168 p_exec_mode IN VARCHAR2,
169 -- Updated by L Poon to fix the GSCC warning - File.Sql.35
170 p_qtd_ytd_code IN VARCHAR2 DEFAULT NULL,
171 p_budget_id IN NUMBER DEFAULT NULL,
172 p_enc_type_id IN NUMBER DEFAULT NULL,
173 x_completion_code OUT NOCOPY NUMBER);
174
175 PROCEDURE Undo_XGL_Interface_Error_Rows
176 (p_request_id IN NUMBER,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER);
180
181 -- Added for FEM-OGL Integration Project
182 PROCEDURE Validate_OGL_Eng_Parameters
183 (p_bal_rule_obj_def_id IN NUMBER,
184 p_from_period IN VARCHAR2,
185 p_to_period IN VARCHAR2,
186 p_effective_date IN OUT NOCOPY DATE,
187 p_bsv_range_low IN VARCHAR2,
188 p_bsv_range_high IN VARCHAR2,
189 x_generate_report_flag OUT NOCOPY VARCHAR2,
190 x_completion_code OUT NOCOPY NUMBER);
191
192 -- Added for FEM-OGL Integration Project
193 PROCEDURE Register_OGL_Process_Execution
194 (x_completion_code OUT NOCOPY NUMBER);
195
196 -- Added for FEM-OGL Integration Project
197 PROCEDURE Final_OGL_Process_Logging
198 (p_exec_status IN VARCHAR2,
199 p_final_message_name IN VARCHAR2);
200
201 END FEM_GL_POST_PROCESS_PKG;