[Home] [Help]
PACKAGE: APPS.ECE_RULES_PKG
Source
1 package ECE_RULES_PKG AS
2 -- $Header: ECERULES.pls 120.3.12010000.2 2008/11/24 18:21:49 akemiset ship $
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'ECE_RULES_PKG';
5 g_file_name CONSTANT VARCHAR2(12) := 'ECERULEB.pls';
6
7 -- Global constants representing the type of different rules and actions.
8
9 g_p_trading_partner CONSTANT VARCHAR2(80) := 'INVALID_TRADING_PARTNER';
10 g_p_test_prod CONSTANT VARCHAR2(80) := 'TEST_PROD_DISCREPANCY';
11 g_p_invalid_addr CONSTANT VARCHAR2(80) := 'INVALID_ADDRESS';
12 g_c_value_required CONSTANT VARCHAR2(80) := 'VALUE_REQUIRED';
13 g_c_simple_lookup CONSTANT VARCHAR2(80) := 'SIMPLE_LOOKUP';
14 g_c_valueset CONSTANT VARCHAR2(80) := 'VALUESET';
15 g_c_null_dependency CONSTANT VARCHAR2(80) := 'NULL_DEPENDENCY';
16 g_c_predefined_list CONSTANT VARCHAR2(80) := 'PREDEFINED_LIST';
17 g_c_null_default CONSTANT VARCHAR2(80) := 'NULL_DEFAULT';
18 g_c_datatype_checking CONSTANT VARCHAR2(80) := 'DATATYPE_CHECKING';
19
20 g_disabled CONSTANT VARCHAR2(20) := 'DISABLED';
21 g_insert CONSTANT VARCHAR2(20) := 'INSERT';
22 g_skip_doc CONSTANT VARCHAR2(20) := 'SKIP_DOCUMENT';
23 g_abort CONSTANT VARCHAR2(20) := 'ABORT';
24 g_log_only CONSTANT VARCHAR2(20) := 'LOG_ONLY';
25 g_new CONSTANT VARCHAR2(20) := 'NEW';
26 g_reprocess CONSTANT VARCHAR2(20) := 'RE_PROCESS';
27
28 g_process_rule CONSTANT VARCHAR2(20) := 'PROCESS';
29 g_column_rule CONSTANT VARCHAR2(20) := 'COLUMN';
30
31 g_bank CONSTANT VARCHAR2(15) := 'BANK';
32 g_customer CONSTANT VARCHAR2(15) := 'CUSTOMER';
33 g_supplier CONSTANT VARCHAR2(15) := 'SUPPLIER';
34 g_hr_location CONSTANT VARCHAR2(15) := 'HR_LOCATION';
35
36 TYPE rule_violation_record_type is RECORD (
37 violation_id ece_rule_violations.violation_id%TYPE,
38 document_id ece_rule_violations.document_id%TYPE,
39 stage_id ece_rule_violations.stage_id%TYPE,
40 interface_column_id ece_rule_violations.interface_column_id%TYPE,
41 rule_id ece_rule_violations.rule_id%TYPE,
42 transaction_type ece_rule_violations.transaction_type%TYPE,
43 document_number ece_rule_violations.document_number%TYPE,
44 violation_level ece_rule_violations.violation_level%TYPE,
45 ignore_flag ece_rule_violations.ignore_flag%TYPE,
46 message_text ece_rule_violations.message_text%TYPE);
47
48 TYPE Rule_Violation_Table is TABLE of rule_violation_record_type index by BINARY_INTEGER;
49 g_party_name varchar2(32767);
50 g_party_number varchar2(32767);
51 g_rule_violation_tbl Rule_Violation_Table;
52
53 -- Bug 2617428
54 Type address_rec is Record
55 (
56 address_type pls_integer,
57 org_id pls_integer,
58 address_id pls_integer,
59 parent_id pls_integer,
60 tp_location_code VARCHAR2(3200),
61 tp_location_name VARCHAR2(3200),
62 tp_translator_code VARCHAR2(3200),
63 address_code VARCHAR2(3200),
64 address_line1 VARCHAR2(3200),
65 address_line2 VARCHAR2(3200),
66 address_line3 VARCHAR2(3200),
67 address_line4 VARCHAR2(3200),
68 address_line_alt VARCHAR2(3200),
69 city VARCHAR2(3200),
70 county VARCHAR2(3200),
71 state VARCHAR2(3200),
72 zip VARCHAR2(3200),
73 province VARCHAR2(3200),
74 country VARCHAR2(3200),
75 region_1 VARCHAR2(3200),
76 region_2 VARCHAR2(3200),
77 region_3 VARCHAR2(3200)
78 );
79
80 Type address_tbl is table of address_rec index by BINARY_INTEGER;
81
82 g_address_tbl address_tbl;
83
84 PROCEDURE Update_Status (
85 p_transaction_type IN VARCHAR2,
86 p_level IN NUMBER,
87 p_valid_rule IN VARCHAR2,
88 p_action IN VARCHAR2,
89 p_interface_column_id IN NUMBER DEFAULT NULL,
90 p_rule_id IN NUMBER,
91 p_stage_id IN NUMBER,
92 p_document_id IN NUMBER,
93 p_violation_level IN VARCHAR2,
94 p_document_number IN VARCHAR2,
95 p_msg_text IN VARCHAR2);
96
97 /*Bug 1854866
98 Assigned default values to the parameters
99 p_init_msg_list,
100 p_simulate
101 p_commit
102 p_validation_level
103 of the procedure Validate_Process_Rules
104 since the default values are assigned to these parameters
105 in the package body
106 */
107
108 /* Bug 2340691
109 p_staging_tbl was modified to IN OUT NOCOPY
110 */
111 PROCEDURE Validate_Process_Rules(
112 p_api_version_number IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_transaction_type IN VARCHAR2,
121 p_address_type IN VARCHAR2,
122 p_stage_id IN NUMBER,
123 p_document_id IN NUMBER,
124 p_document_number IN VARCHAR2,
125 p_level IN NUMBER,
126 p_map_id IN NUMBER,
127 p_staging_tbl IN OUT NOCOPY ec_utils.mapping_tbl);
128
129
130 PROCEDURE Validate_Trading_Partner(
131 p_transaction_type IN VARCHAR2,
132 p_address_type IN VARCHAR2,
133 p_level IN NUMBER,
134 p_map_id IN NUMBER,
135 p_staging_tbl IN ec_utils.mapping_tbl,
136 x_tp_detail_id OUT NOCOPY NUMBER,
137 x_msg_text OUT NOCOPY VARCHAR2,
138 x_valid_rule OUT NOCOPY VARCHAR2);
139
140
141 PROCEDURE Validate_Test_Prod(
142 p_tp_detail_id IN NUMBER,
143 p_level IN NUMBER,
144 p_staging_tbl IN ec_utils.mapping_tbl,
145 x_msg_text OUT NOCOPY VARCHAR2,
146 x_valid_rule OUT NOCOPY VARCHAR2);
147
148 /*Bug 1854866
149 Assigned default values to the parameters
150 p_init_msg_list,
151 p_simulate
152 p_commit
153 p_validation_level
154 of the procedure Validate_Column_Rules
155 since the default values are assigned to these parameters
156 in the package body
157 */
158
159 /* Bug 1853627
160 p_staging_tbl was modified to IN OUT NOCOPY
161 */
162 PROCEDURE Validate_Column_Rules(
163 p_api_version_number IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE,
167 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_transaction_type IN VARCHAR2,
172 p_stage_id IN NUMBER,
173 p_document_id IN NUMBER,
174 p_document_number IN VARCHAR2,
175 p_level IN NUMBER,
176 p_staging_tbl IN OUT NOCOPY ec_utils.mapping_tbl);
177
178
179 PROCEDURE Value_Required_Rule (
180 p_column_name IN VARCHAR2,
181 p_column_value IN VARCHAR2,
182 x_valid_rule OUT NOCOPY VARCHAR2,
183 x_msg_text OUT NOCOPY VARCHAR2);
184
185
186 PROCEDURE Simple_Lookup_Rule (
187 p_column_name IN VARCHAR2,
188 p_column_value IN VARCHAR2,
189 p_rule_id IN NUMBER,
190 x_valid_rule OUT NOCOPY VARCHAR2,
191 x_msg_text OUT NOCOPY VARCHAR2);
192
193
194 PROCEDURE Valueset_Rule (
195 p_column_name IN VARCHAR2,
196 p_column_value IN VARCHAR2,
197 p_rule_id IN NUMBER,
198 x_valid_rule OUT NOCOPY VARCHAR2,
199 x_msg_text OUT NOCOPY VARCHAR2);
200
201
202 PROCEDURE Null_Dependency_Rule (
203 p_column_name IN VARCHAR2,
204 p_column_value IN VARCHAR2,
205 p_rule_id IN NUMBER,
206 p_staging_tbl IN ec_utils.mapping_tbl,
207 p_level IN NUMBER,
208 x_valid_rule OUT NOCOPY VARCHAR2,
209 x_msg_text OUT NOCOPY VARCHAR2);
210
211
212 PROCEDURE Predefined_List_Rule (
213 p_column_name IN VARCHAR2,
214 p_column_value IN VARCHAR2,
215 p_rule_id IN NUMBER,
216 x_valid_rule OUT NOCOPY VARCHAR2,
217 x_msg_text OUT NOCOPY VARCHAR2);
218
219
220 PROCEDURE Null_Default_Rule (
221 p_column_name IN VARCHAR2,
222 p_column_value IN VARCHAR2,
223 p_rule_id IN NUMBER,
224 p_level IN NUMBER,
225 p_staging_tbl IN OUT NOCOPY ec_utils.mapping_tbl,
226 x_valid_rule OUT NOCOPY VARCHAR2,
227 x_msg_text OUT NOCOPY VARCHAR2);
228
229
230 PROCEDURE Datatype_Checking_Rule (
231 p_column_datatype IN VARCHAR2,
232 p_column_name IN VARCHAR2,
233 p_column_value IN VARCHAR2,
234 x_valid_rule OUT NOCOPY VARCHAR2,
235 x_msg_text OUT NOCOPY VARCHAR2);
236
237
238 PROCEDURE Validate_Get_Address_Info (
239 p_entity_id_pos IN NUMBER,
240 p_org_id_pos IN NUMBER,
241 p_addr_id_pos IN NUMBER,
242 p_tp_location_code_pos IN NUMBER,
243 p_tp_translator_code_pos IN NUMBER,
244 p_tp_location_name_pos IN NUMBER,
245 p_addr1_pos IN NUMBER,
246 p_addr2_pos IN NUMBER,
247 p_addr3_pos IN NUMBER,
248 p_addr4_pos IN NUMBER,
249 p_addr_alt_pos IN NUMBER,
250 p_city_pos IN NUMBER,
251 p_county_pos IN NUMBER,
252 p_state_pos IN NUMBER,
253 p_zip_pos IN NUMBER,
254 p_province_pos IN NUMBER,
255 p_country_pos IN NUMBER,
256 p_region1_pos IN NUMBER DEFAULT NULL,
257 p_region2_pos IN NUMBER DEFAULT NULL,
258 p_region3_pos IN NUMBER DEFAULT NULL,
259 p_address IN VARCHAR2);
260
261
262 PROCEDURE Validate_Ship_To_Address;
263
264 PROCEDURE Validate_Bill_To_Address;
265
266 PROCEDURE Validate_Sold_To_Address;
267
268 PROCEDURE Validate_Ship_From_Address;
269
270 PROCEDURE Validate_Bill_From_Address;
271
272 PROCEDURE Validate_Ship_To_Int_Address;
273
274 PROCEDURE Validate_Ship_To_Intrmd_Add;
275
276 PROCEDURE Validate_Bill_To_Int_Address;
277
278 PROCEDURE Validate_Ship_From_Int_Address;
279
280 PROCEDURE Validate_Bill_From_Int_Address;
281
282
283 PROCEDURE Validate_Form_Simple_Lookup (
284 p_column_name IN VARCHAR2,
285 p_table_name IN VARCHAR2,
286 p_where_clause IN VARCHAR2,
287 x_valid OUT NOCOPY BOOLEAN);
288
289
290 PROCEDURE Get_Action_Ignore_Flag (
291 x_action_code OUT NOCOPY VARCHAR2,
292 x_ignore_flag OUT NOCOPY VARCHAR2);
293
294
295 END ECE_RULES_PKG;