[Home] [Help]
PACKAGE: APPS.FEM_SOURCE_DATA_LOADER_PKG
Source
1 PACKAGE FEM_SOURCE_DATA_LOADER_PKG AS
2 /* $Header: fem_srcdata_ldr.pls 120.1 2006/08/18 11:01:55 hkaniven noship $ */
3
4
5 PROCEDURE Main (
6 errbuf OUT NOCOPY VARCHAR2,
7 retcode OUT NOCOPY VARCHAR2,
8 p_obj_def_id IN VARCHAR2,
9 p_exec_mode IN VARCHAR2,
10 p_ledger_id IN VARCHAR2,
11 p_cal_period_id IN VARCHAR2,
12 p_dataset_code IN VARCHAR2,
13 p_source_system_code IN VARCHAR2
14 );
15
16 PROCEDURE Validate_Loader_Parameters (
17 p_obj_def_id IN NUMBER,
18 p_exec_mode IN VARCHAR2,
19 p_ledger_id IN NUMBER,
20 p_cal_period_id IN NUMBER,
21 p_dataset_code IN NUMBER,
22 p_source_system_code IN NUMBER,
23 x_object_id OUT NOCOPY NUMBER,
24 x_table_name OUT NOCOPY VARCHAR2,
25 x_calp_dim_grp_dc OUT NOCOPY VARCHAR2,
26 x_cal_per_end_date OUT NOCOPY DATE,
27 x_cal_per_number OUT NOCOPY NUMBER,
28 x_dataset_dc OUT NOCOPY VARCHAR2,
29 x_source_system_dc OUT NOCOPY VARCHAR2,
30 x_ledger_dc OUT NOCOPY VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE Register_Process_Execution (
35 p_object_id IN NUMBER,
36 p_obj_def_id IN NUMBER,
37 p_table_name IN VARCHAR2,
38 p_exec_mode IN VARCHAR2,
39 p_ledger_id IN NUMBER,
40 p_cal_period_id IN NUMBER,
41 p_dataset_code IN NUMBER,
42 p_source_system_code IN NUMBER,
43 p_request_id IN NUMBER,
44 p_user_id IN NUMBER,
45 p_login_id IN NUMBER,
46 p_program_id IN NUMBER,
47 p_program_application_id IN NUMBER,
48 x_prev_req_id OUT NOCOPY NUMBER,
49 x_exec_state OUT NOCOPY VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE Populate_xDim_Info_Tbl(
54 p_table_name IN VARCHAR2,
55 p_ledger_id IN NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE Set_MP_Condition (
60 p_exec_mode IN VARCHAR2,
61 p_calp_dim_grp_dc IN VARCHAR2,
62 p_cal_per_end_date IN DATE,
63 p_cal_per_number IN NUMBER,
64 p_dataset_dc IN VARCHAR2,
65 p_source_system_dc IN VARCHAR2,
66 p_ledger_dc IN VARCHAR2,
67 x_condition OUT NOCOPY VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2
69 );
70
71 -- Added p_exec_mode as a parameter for Replacement mode Support
72 PROCEDURE Prepare_Dynamic_Sql (
73 p_object_id IN NUMBER,
74 p_exec_mode IN VARCHAR2,
75 p_request_id IN NUMBER,
76 p_ledger_id IN NUMBER,
77 p_cal_period_id IN NUMBER,
78 p_dataset_code IN NUMBER,
79 p_source_system_code IN NUMBER,
80 p_interface_table_name IN VARCHAR2,
81 p_target_table_name IN VARCHAR2,
82 p_condition IN VARCHAR2,
83 x_insert_interim_sql OUT NOCOPY VARCHAR2,
84 x_update_interim_error_sql OUT NOCOPY VARCHAR2,
85 x_insert_target_sql OUT NOCOPY VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE Process_Data (
90 p_eng_sql IN VARCHAR2,
91 p_data_slice_predicate IN VARCHAR2,
92 p_process_number IN NUMBER,
93 p_partition_code IN NUMBER,
94 p_fetch_limit IN NUMBER,
95 p_request_id IN VARCHAR2,
96 p_exec_mode IN VARCHAR2,
97 p_target_table_name IN VARCHAR2,
98 p_interface_table_name IN VARCHAR2,
99 p_object_id IN NUMBER,
100 p_ledger_id IN VARCHAR2,
101 p_cal_period_id IN NUMBER,
102 p_dataset_code IN NUMBER,
103 p_source_system_code IN NUMBER,
104 p_schema_name IN VARCHAR2,
105 p_condition IN VARCHAR2
106 );
107
108 PROCEDURE Post_Process (
109 p_object_id IN NUMBER,
110 p_obj_def_id IN NUMBER,
111 p_table_name IN VARCHAR2,
112 p_exec_mode IN VARCHAR2,
113 p_ledger_id IN NUMBER,
114 p_cal_period_id IN NUMBER,
115 p_dataset_code IN NUMBER,
116 p_source_system_code IN NUMBER,
117 p_exec_status IN VARCHAR2,
118 p_request_id IN NUMBER,
119 p_user_id IN NUMBER,
120 p_login_id IN NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2
122 );
123
124 PROCEDURE Get_Put_Messages (
125 p_msg_count IN NUMBER,
126 p_msg_data IN VARCHAR2
127 );
128
129 PROCEDURE Validate_Obj_Def (
130 p_api_version IN NUMBER,
131 p_object_type IN VARCHAR2,
132 p_obj_def_id IN NUMBER,
133 x_object_id OUT NOCOPY NUMBER,
134 x_table_name OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2
138 );
139
140 PROCEDURE Validate_Table (
141 p_api_version IN NUMBER,
142 p_object_type IN VARCHAR2,
143 p_table_name IN VARCHAR2,
144 p_table_classification IN VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 x_return_status OUT NOCOPY VARCHAR2
148 );
149
150 PROCEDURE Validate_Exec_Mode (
151 p_api_version IN NUMBER,
152 p_object_type IN VARCHAR2,
153 p_exec_mode IN VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 x_return_status OUT NOCOPY VARCHAR2
157 );
158
159 PROCEDURE Validate_Ledger (
160 p_api_version IN NUMBER,
161 p_object_type IN VARCHAR2,
162 p_ledger_id IN NUMBER,
163 x_ledger_dc OUT NOCOPY VARCHAR2,
164 x_ledger_calendar_id OUT NOCOPY NUMBER,
165 x_ledger_per_hier_obj_def_id OUT NOCOPY NUMBER,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 x_return_status OUT NOCOPY VARCHAR2
169 );
170
171 PROCEDURE Validate_Cal_Period (
172 p_api_version IN NUMBER,
173 p_object_type IN VARCHAR2,
174 p_cal_period_id IN NUMBER,
175 p_ledger_id IN NUMBER,
176 p_ledger_calendar_id IN NUMBER,
177 p_ledger_per_hier_obj_def_id IN NUMBER,
178 x_calp_dim_grp_dc OUT NOCOPY VARCHAR2,
179 x_cal_per_end_date OUT NOCOPY DATE,
180 x_cal_per_number OUT NOCOPY NUMBER,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 x_return_status OUT NOCOPY VARCHAR2
184 );
185
186 PROCEDURE Validate_Dataset (
187 p_api_version IN NUMBER,
188 p_object_type IN VARCHAR2,
189 p_dataset_code IN NUMBER,
190 x_dataset_dc OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 x_return_status OUT NOCOPY VARCHAR2
194 );
195
196 PROCEDURE Validate_Source_System (
197 p_api_version IN NUMBER,
198 p_object_type IN VARCHAR2,
199 p_source_system_code IN NUMBER,
200 x_source_system_dc OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 x_return_status OUT NOCOPY VARCHAR2
204 );
205
206 END FEM_SOURCE_DATA_LOADER_PKG;