6: -- * ------------------------------------------------------------------+
7:
8: TYPE IMPORT_TYPES_REC_TYPE IS RECORD
9: (
10: IMPORT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
11: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: CONC_PROGRAM VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
7:
8: TYPE IMPORT_TYPES_REC_TYPE IS RECORD
9: (
10: IMPORT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
11: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: CONC_PROGRAM VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
8: TYPE IMPORT_TYPES_REC_TYPE IS RECORD
9: (
10: IMPORT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
11: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: CONC_PROGRAM VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: (
10: IMPORT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
11: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: CONC_PROGRAM VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
10: IMPORT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
11: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: CONC_PROGRAM VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: CONC_PROGRAM VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: CONC_PROGRAM VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: CONC_PROGRAM VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: TABLE_ID NUMBER := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
25: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
27: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
29: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
37: );
30: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
37: );
38:
31: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
37: );
38:
39: G_MISS_IMPORT_TYPES_REC IMPORT_TYPES_REC_TYPE;
32: CREATION_DATE DATE := FND_API.G_MISS_DATE,
33: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
34: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
35: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
36: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
37: );
38:
39: G_MISS_IMPORT_TYPES_REC IMPORT_TYPES_REC_TYPE;
40: