[Home] [Help]
PACKAGE: APPS.EGO_ICC_BULKLOAD_PVT
Source
1 PACKAGE EGO_ICC_BULKLOAD_PVT AUTHID CURRENT_USER AS
2 /* $Header: EGOVICCS.pls 120.4 2011/07/26 09:46:16 vijoshi noship $ */
3
4 ---
5 --- global variables for error handling and processing
6 ---
7 ---
8 G_BO_IDENTIFIER_ICC CONSTANT VARCHAR2(30) := 'ICC';
9
10 --- Flow Type decides if the calling program
11 --- is a concurrent program or the API being invoked directly
12 ---
13 G_EGO_MD_INTF CONSTANT NUMBER := 1;
14 G_EGO_MD_API CONSTANT NUMBER := 2;
15 G_FLOW_TYPE NUMBER(1) := G_EGO_MD_API;
16
17 G_ENTITY_ICC_HEADER CONSTANT VARCHAR2(30) := 'ICC_HEADER';
18 G_ENTITY_ICC_VERSION CONSTANT VARCHAR2(30) := 'ICC_VERSIONS';
19 G_ENTITY_ICC_AG_ASSOC CONSTANT VARCHAR2(30) := 'AG_ASSOCS';
20 G_ENTITY_ICC_FN_ASSOC CONSTANT VARCHAR2(30) := 'ICC_FUNCTIONS';
21 G_ENTITY_ICC_FN_PARAM_MAP CONSTANT VARCHAR2(30) := 'FN_PARAM_MAPS';
22 G_ENTITY_ICC_LOCK CONSTANT VARCHAR2(30) := 'EGO_ITEM_CATALOG_CATEGORY';
23
24 G_ENTITY_ICC_HEADER_TAB CONSTANT VARCHAR2(30) := 'MTL_ITEM_CAT_GRPS_INTERFACE';
25 G_ENTITY_ICC_VERS_TAB CONSTANT VARCHAR2(30) := 'EGO_ICC_VERS_INTERFACE';
26 G_ENTITY_ICC_AG_ASSOC_TAB CONSTANT VARCHAR2(30) := 'EGO_ATTR_GRPS_ASSOC_INTERFACE';
27 G_ENTITY_FUNC_PARAM_MAP_TAB CONSTANT VARCHAR2(30) := 'EGO_FUNC_PARAMS_MAP_INTERFACE';
28
29
30 --- Default values used for processing
31 ---
32 G_DEFAULT_USER_NAME VARCHAR2(10) := 'MFG';
33 G_ITEM_CAT_KFF_APPL VARCHAR2(5) := 'INV';
34 G_STRUCTURE_NUMBER NUMBER := 101;
35 G_ICC_KFF_NAME VARCHAR2(4) := 'MICG';
36 G_INV_SCHEMA VARCHAR2(3) := 'INV';
37
38 G_ITEM_OBJ_NAME VARCHAR2(10) := 'EGO_ITEM';
39 G_SEEDED_AG_TYPE VARCHAR2(17) := 'EGO_MASTER_ITEMS';
40 G_APPL_NAME VARCHAR2(3) := 'EGO';
41 G_EGO_APPL_ID NUMBER := NULL; --- assigned at run time
42
43 G_NUM_GEN_FUNCTION VARCHAR2(20) := 'NUMBER_GENERATION' ;
44 G_DESC_GEN_FUNCTION VARCHAR2(20) := 'DESC_GENERATION' ;
45 G_P4TP_PROFILE_ENABLED BOOLEAN := FALSE;
46
47 ---
48 --- global variables for use across the entity validations
49 ---
50 G_TTYPE_CREATE CONSTANT VARCHAR2(10) := 'CREATE';
51 G_TTYPE_UPDATE CONSTANT VARCHAR2(10) := 'UPDATE';
52 G_TTYPE_SYNC CONSTANT VARCHAR2(10) := 'SYNC';
53 G_TTYPE_DELETE CONSTANT VARCHAR2(10) := 'DELETE';
54
55
56 ----
57 ---- Process codes for API, which will be updated to the interface table
58 ----
59 G_PROCESS_STATUS_INITIAL CONSTANT NUMBER(1) := 1; -- Initial and post validation phase
60 G_PROCESS_STATUS_SUCCESS CONSTANT NUMBER(1) := 7; -- Successfuly processed
61 G_PROCESS_STATUS_ERROR CONSTANT NUMBER(1) := 3; -- Error
62
63
64 G_TYPE_ERROR CONSTANT VARCHAR2(1):= 'E';
65 G_TYPE_WARNING CONSTANT VARCHAR2(1):= 'W';
66
67 G_PROCESS_STATUS_WARNING CONSTANT NUMBER(1) := 5; -- Check
68
69 G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_ICC_BULKLOAD_PVT';
70
71
72 /* API return status
73
74 G_RET_STS_SUCCESS means that the API was successful in performing
75 all the operation requested by its caller.
76
77 G_RET_STS_ERROR means that the API failed to perform one or more
78 of the operations requested by its caller.
79
80 G_RET_STS_UNEXP_ERROR means that the API was not able to perform
81 any of the operations requested by its callers because of an
82 unexpected error.
83
84 */
85
86 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
87 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
88 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
89
90 --- WHO columns
91 ---
92 G_CONC_REQUEST_ID CONSTANT FND_CONCURRENT_REQUESTS.REQUEST_ID%TYPE := FND_GLOBAL.CONC_REQUEST_ID;
93 G_USER_ID CONSTANT FND_USER.USER_ID%type := FND_GLOBAL.USER_ID;
94 G_LOGIN_ID CONSTANT FND_USER.last_update_login%type := FND_GLOBAL.LOGIN_ID;
95 G_PROG_APPL_ID CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
96 G_PROGRAM_ID CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
97
98
99
100 --- Processing related columns
101 ---
102 G_SET_PROCESS_ID NUMBER(15) := NULL;
103
104 G_PARTY_ID EGO_USER_V.party_id%TYPE;
105 G_MISS_NUM CONSTANT NUMBER := FND_API.G_NULL_NUM;
106 G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_NULL_CHAR;
107 G_MISS_DATE CONSTANT DATE := FND_API.G_NULL_DATE;
108 G_MAX_FETCH_SIZE CONSTANT NUMBER := 2000;
109
110 --- Record and table datatypes used for the entity processing
111 ---
112
113 -- Record Types
114 SUBTYPE ego_icc_rec_type is EGO_METADATA_PUB.ego_icc_rec_type;
115
116 SUBTYPE ego_ag_assoc_rec_type is EGO_METADATA_PUB.ego_ag_assoc_rec_type;
117
118 SUBTYPE ego_func_param_map_rec_type is EGO_METADATA_PUB.ego_func_param_map_rec_type;
119
120 SUBTYPE ego_icc_vers_rec_type is EGO_METADATA_PUB.ego_icc_vers_rec_type;
121
122 --- Table types
123 SUBTYPE ego_icc_tbl_type is EGO_METADATA_PUB.ego_icc_tbl_type;
124
125 SUBTYPE ego_ag_assoc_tbl_type is EGO_METADATA_PUB.ego_ag_assoc_tbl_type ;
126
127 SUBTYPE ego_func_param_map_tbl_type is EGO_METADATA_PUB.ego_func_param_map_tbl_type ;
128
129 SUBTYPE ego_icc_vers_tbl_type is EGO_METADATA_PUB.ego_icc_vers_tbl_type ;
130
131
132
133
134
135
136
137 --- package level NULL varaibles used for defaulting
138 ---
139 g_null_icc_rec ego_icc_rec_type;
140 g_null_ag_assoc_rec ego_ag_assoc_rec_type;
141 g_null_func_params_rec ego_func_param_map_rec_type;
142 g_null_icc_vers_rec ego_icc_vers_rec_type;
143
144
145
146
147 g_null_icc_tbl ego_icc_tbl_type;
148 g_null_ag_assoc_tbl ego_ag_assoc_tbl_type;
149 g_null_func_param_map_tbl ego_func_param_map_tbl_type;
150 g_null_icc_vers_tbl ego_icc_vers_tbl_type;
151
152
153
154 /*
155 * This procedure reads the records from the ICC related
156 * interface tables, validate and then process the records
157 */
158
159
160 PROCEDURE Import_ICC_Intf
161 (
162 p_set_process_id IN NUMBER
163 , x_return_status OUT NOCOPY VARCHAR2
164 , x_return_msg OUT NOCOPY VARCHAR2
165 );
166
167
168 /*
169 * This function takes the Concatenated ICC name and returns the ICC ID
170 * if the operation is FIND_COMBINATION
171 * For operation CHECK_SEGMENTS , returns 1 if combination exists else returns 0
172 */
173
174
175 FUNCTION Get_Catalog_Group_Id ( p_catalog_group_name IN VARCHAR2
176 , p_operation IN VARCHAR2
177 )
178 RETURN NUMBER;
179
180
181 /*
182 * This procedure deletes the successfully processed records from the interface tables
183 *
184 */
185
186 PROCEDURE Delete_Processed_ICC ( p_set_process_id IN NUMBER
187 , x_return_status OUT NOCOPY VARCHAR2
188 , x_return_msg OUT NOCOPY VARCHAR2
189 );
190
191 /* Exposed for dependency in package body
192 * not for public use
193 */
194 PROCEDURE Construct_Colltn_And_Validate ( p_entity IN VARCHAR2
195 ,p_icc_name IN VARCHAR2 DEFAULT NULL --- Used by version processing
196 ,p_icc_id IN NUMBER DEFAULT NULL --- Used by version processing
197 ,p_icc_trans_type IN VARCHAR2 DEFAULT NULL -- added bug 12695479
198 ,x_return_status OUT NOCOPY VARCHAR2
199 ,x_return_msg OUT NOCOPY VARCHAR2
200 );
201
202
203
204
205 END EGO_ICC_BULKLOAD_PVT;