6: -- * ------------------------------------------------------------------+
7:
8: TYPE IMP_MAP_FIELDS_REC_TYPE IS RECORD
9: (
10: IMP_MAP_FIELD_ID NUMBER := FND_API.G_MISS_NUM,
11: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
12: SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
7:
8: TYPE IMP_MAP_FIELDS_REC_TYPE IS RECORD
9: (
10: IMP_MAP_FIELD_ID NUMBER := FND_API.G_MISS_NUM,
11: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
12: SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
8: TYPE IMP_MAP_FIELDS_REC_TYPE IS RECORD
9: (
10: IMP_MAP_FIELD_ID NUMBER := FND_API.G_MISS_NUM,
11: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
12: SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
9: (
10: IMP_MAP_FIELD_ID NUMBER := FND_API.G_MISS_NUM,
11: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
12: SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
10: IMP_MAP_FIELD_ID NUMBER := FND_API.G_MISS_NUM,
11: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
12: SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
11: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
12: SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
28: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
37: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
37: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
38: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
37: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
38: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
32: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
37: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
38: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40: );
33: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
37: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
38: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40: );
41:
34: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
37: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
38: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40: );
41:
42: G_MISS_IMP_MAP_FIELDS_REC IMP_MAP_FIELDS_REC_TYPE;
35: CREATION_DATE DATE := FND_API.G_MISS_DATE,
36: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
37: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
38: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
39: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40: );
41:
42: G_MISS_IMP_MAP_FIELDS_REC IMP_MAP_FIELDS_REC_TYPE;
43: