[Home] [Help]
PACKAGE: APPS.CN_IMP_MAPS_PVT
Source
1 PACKAGE CN_IMP_MAPS_PVT AS
2 -- $Header: cnvimmps.pls 120.2 2005/08/07 23:03:40 vensrini noship $
3
4 -- * ------------------------------------------------------------------+
5 -- Record Type Definition
6 -- * ------------------------------------------------------------------+
7 TYPE v_Tbl_Type IS TABLE OF VARCHAR2(120) INDEX BY BINARY_INTEGER;
8
9 G_MISS_V_TBL v_Tbl_Type;
10
11 TYPE IMP_MAPS_REC_TYPE IS RECORD
12 (
13 IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
14 NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15 IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
16 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
17 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
18 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 CREATION_DATE DATE := FND_API.G_MISS_DATE,
34 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
35 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
37 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
38 );
39
40 G_MISS_IMP_MAPS_REC IMP_MAPS_REC_TYPE;
41
42 TYPE MAP_FIELD_REC_TYPE IS RECORD
43 (value VARCHAR2(120) := FND_API.G_MISS_CHAR,
44 text VARCHAR2(120) := FND_API.G_MISS_CHAR,
45 colname VARCHAR2(120) := FND_API.G_MISS_CHAR
46 );
47
48 G_MISS_MAP_FIELD_REC MAP_FIELD_REC_TYPE;
49
50 TYPE MAP_FIELD_TBL_TYPE IS TABLE OF MAP_FIELD_REC_TYPE INDEX BY BINARY_INTEGER ;
51
52 G_MISS_MAP_FIELD_TBL MAP_FIELD_TBL_TYPE;
53
54 -- Start of comments
55 -- API name : Create_Mapping
56 -- Type : Private.
57 -- Function :
58 -- Pre-reqs : None.
59 -- Parameters :
60 -- IN : p_api_version IN NUMBER Required
61 -- p_init_msg_list IN VARCHAR2 Optional
62 -- Default = FND_API.G_FALSE
63 -- p_commit IN VARCHAR2 Optional
64 -- Default = FND_API.G_FALSE
65 -- p_validation_level IN NUMBER Optional
66 -- Default = FND_API.G_VALID_LEVEL_FULL
67 -- p_imp_header_id IN NUMBER,
68 -- p_src_column_num IN NUMBER,
69 -- p_imp_map IN imp_maps_rec_type
70 -- p_source_fields IN v_Tbl_Type ,
71 -- p_target_fields IN v_Tbl_Type ,
72 -- OUT : x_return_status OUT VARCHAR2(1)
73 -- x_msg_count OUT NUMBER
74 -- x_msg_data OUT VARCHAR2(2000)
75 -- x_imp_map_id OUT NUMBER
76 -- Version : Current version 1.0
77 --
78 --
79 --
80 -- Notes : Note text
81 --
82 -- End of comments
83 PROCEDURE Create_Mapping
84 ( p_api_version IN NUMBER ,
85 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 x_return_status OUT NOCOPY VARCHAR2 ,
89 x_msg_count OUT NOCOPY NUMBER ,
90 x_msg_data OUT NOCOPY VARCHAR2 ,
91 p_imp_header_id IN NUMBER,
92 p_src_column_num IN NUMBER,
93 p_imp_map IN imp_maps_rec_type,
94 p_source_fields IN MAP_FIELD_TBL_TYPE ,
95 p_target_fields IN v_Tbl_Type ,
96 x_imp_map_id OUT NOCOPY NUMBER,
97 p_org_id IN NUMBER
98 );
99
100 -- Start of comments
101 -- API name : retrieve_Fields
102 -- Type : Private.
103 -- Function :
104 -- Pre-reqs : None.
105 -- Parameters :
106 -- IN : p_api_version IN NUMBER Required-- p_init_msg_list IN VARCHAR2 Optional
107 -- Default = FND_API.G_FALSE
108 -- p_commit IN VARCHAR2 Optional
109 -- Default = FND_API.G_FALSE
110 -- p_validation_level IN NUMBER Optional
111 -- Default = FND_API.G_VALID_LEVEL_FULL
112 -- p_imp_header_id IN NUMBER,
113 -- p_imp_map IN imp_maps_rec_type
114 -- p_source_fields IN MAP_FIELD_TBL_TYPE
115 -- p_target_fields IN MAP_FIELD_TBL_TYPE
116 -- p_mapped_fields IN MAP_FIELD_TBL_TYPE
117 -- OUT : x_return_status OUT VARCHAR2(1)
118 -- x_msg_count OUT NUMBER
119 -- x_msg_data OUT VARCHAR2(2000)
120 -- x_imp_map_id OUT NUMBER
121 -- x_map_obj_num OUT NUMBER
122 -- Version : Current version 1.0
123 --
124 --
125 -- Notes : Note text
126 --
127 -- End of comments
128 PROCEDURE retrieve_Fields
129 ( p_api_version IN NUMBER ,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
132 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133 x_return_status OUT NOCOPY VARCHAR2 ,
134 x_msg_count OUT NOCOPY NUMBER ,
135 x_msg_data OUT NOCOPY VARCHAR2 ,
136 p_imp_map_id IN NUMBER ,
137 p_import_type_code IN VARCHAR2 ,
138 x_source_fields OUT NOCOPY MAP_FIELD_TBL_TYPE,
139 x_target_fields OUT NOCOPY MAP_FIELD_TBL_TYPE,
140 x_mapped_fields OUT NOCOPY MAP_FIELD_TBL_TYPE,
141 x_map_obj_num OUT NOCOPY NUMBER,
142 p_org_id IN NUMBER
143 );
144
145
146 -- Start of comments
147 -- API name : Create_Imp_Map
148 -- Type : Private.
149 -- Function :
150 -- Pre-reqs : None.
151 -- Parameters :
152 -- IN : p_api_version IN NUMBER Required
153 -- p_init_msg_list IN VARCHAR2 Optional
154 -- Default = FND_API.G_FALSE
155 -- p_commit IN VARCHAR2 Optional
156 -- Default = FND_API.G_FALSE
157 -- p_validation_level IN NUMBER Optional
158 -- Default = FND_API.G_VALID_LEVEL_FULL
159 -- p_imp_map IN imp_maps_rec_type
160 -- OUT : x_return_status OUT VARCHAR2(1)
161 -- x_msg_count OUT NUMBER
162 -- x_msg_data OUT VARCHAR2(2000)
163 -- x_imp_map_id OUT NUMBER
164 -- Version : Current version 1.0
165 --
166 --
167 --
168 -- Notes : Note text
169 --
170 -- End of comments
171 PROCEDURE Create_Imp_Map
172 ( p_api_version IN NUMBER ,
173 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
174 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176 x_return_status OUT NOCOPY VARCHAR2 ,
177 x_msg_count OUT NOCOPY NUMBER ,
178 x_msg_data OUT NOCOPY VARCHAR2 ,
179 p_imp_map IN imp_maps_rec_type,
180 x_imp_map_id OUT NOCOPY NUMBER
181 );
182
183 -- Start of comments
184 -- API name : Delete_Imp_map
185 -- Type : Private.
186 -- Function :
187 -- Pre-reqs : None.
188 -- Parameters :
189 -- IN : p_api_version IN NUMBER Required
190 -- p_init_msg_list IN VARCHAR2 Optional
191 -- Default = FND_API.G_FALSE
192 -- p_commit IN VARCHAR2 Optional
193 -- Default = FND_API.G_FALSE
194 -- p_validation_level IN NUMBER Optional
195 -- Default = FND_API.G_VALID_LEVEL_FULL
196 -- p_imp_map IN imp_maps_rec_type
197 -- OUT : x_return_status OUT VARCHAR2(1)
198 -- x_msg_count OUT NUMBER
199 -- x_msg_data OUT VARCHAR2(2000)
200 -- Version : Current version 1.0
201 --
202 --
203 --
204 -- Notes : Note text
205 --
206 -- End of comments
207
208 PROCEDURE Delete_Imp_Map
209 ( p_api_version IN NUMBER ,
210 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
211 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
212 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213 x_return_status OUT NOCOPY VARCHAR2 ,
214 x_msg_count OUT NOCOPY NUMBER ,
215 x_msg_data OUT NOCOPY VARCHAR2 ,
216 p_imp_map IN imp_maps_rec_type
217 );
218
219 END CN_IMP_MAPS_PVT;