6: -- * ------------------------------------------------------------------+
7:
8: TYPE IMP_HEADERS_REC_TYPE IS RECORD
9: (
10: IMP_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
11: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
13: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
7:
8: TYPE IMP_HEADERS_REC_TYPE IS RECORD
9: (
10: IMP_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
11: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
13: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
8: TYPE IMP_HEADERS_REC_TYPE IS RECORD
9: (
10: IMP_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
11: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
13: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
9: (
10: IMP_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
11: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
13: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
10: IMP_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
11: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
13: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
13: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
13: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: IMPORT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
14: OPERATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
15: SERVER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
16: USER_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: DATA_FILENAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
18: TERMINATED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
19: ENCLOSED_BY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
20: HEADINGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: STAGED_ROW NUMBER := FND_API.G_MISS_NUM,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: PROCESSED_ROW NUMBER := FND_API.G_MISS_NUM,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: FAILED_ROW NUMBER := FND_API.G_MISS_NUM,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: SOURCE_COLUMN_NUM NUMBER := FND_API.G_MISS_NUM,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
49: );
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
49: );
50:
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
49: );
50:
51: G_MISS_IMP_HEADERS_REC IMP_HEADERS_REC_TYPE;
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
49: );
50:
51: G_MISS_IMP_HEADERS_REC IMP_HEADERS_REC_TYPE;
52:
57: -- Pre-reqs : None.
58: -- Parameters :
59: -- IN : p_api_version IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
59: -- IN : p_api_version IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- p_imp_header IN imp_header_rec_type
67: -- OUT : x_return_status OUT VARCHAR2(1)
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- p_imp_header IN imp_header_rec_type
67: -- OUT : x_return_status OUT VARCHAR2(1)
68: -- x_msg_count OUT NUMBER
69: -- x_msg_data OUT VARCHAR2(2000)
77: -- End of comments
78:
79: PROCEDURE Create_Imp_header
80: ( p_api_version IN NUMBER ,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84: x_return_status OUT NOCOPY VARCHAR2 ,
85: x_msg_count OUT NOCOPY NUMBER ,
78:
79: PROCEDURE Create_Imp_header
80: ( p_api_version IN NUMBER ,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84: x_return_status OUT NOCOPY VARCHAR2 ,
85: x_msg_count OUT NOCOPY NUMBER ,
86: x_msg_data OUT NOCOPY VARCHAR2 ,
79: PROCEDURE Create_Imp_header
80: ( p_api_version IN NUMBER ,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
83: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
84: x_return_status OUT NOCOPY VARCHAR2 ,
85: x_msg_count OUT NOCOPY NUMBER ,
86: x_msg_data OUT NOCOPY VARCHAR2 ,
87: p_imp_header IN imp_headers_rec_type,
95: -- Pre-reqs : None.
96: -- Parameters :
97: -- IN : p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
97: -- IN : p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_imp_header IN imp_header_rec_type
105: -- OUT : x_return_status OUT VARCHAR2(1)
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_imp_header IN imp_header_rec_type
105: -- OUT : x_return_status OUT VARCHAR2(1)
106: -- x_msg_count OUT NUMBER
107: -- x_msg_data OUT VARCHAR2(2000)
114: -- End of comments
115:
116: PROCEDURE Update_Imp_header
117: ( p_api_version IN NUMBER ,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: x_return_status OUT NOCOPY VARCHAR2 ,
122: x_msg_count OUT NOCOPY NUMBER ,
115:
116: PROCEDURE Update_Imp_header
117: ( p_api_version IN NUMBER ,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: x_return_status OUT NOCOPY VARCHAR2 ,
122: x_msg_count OUT NOCOPY NUMBER ,
123: x_msg_data OUT NOCOPY VARCHAR2 ,
116: PROCEDURE Update_Imp_header
117: ( p_api_version IN NUMBER ,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: x_return_status OUT NOCOPY VARCHAR2 ,
122: x_msg_count OUT NOCOPY NUMBER ,
123: x_msg_data OUT NOCOPY VARCHAR2 ,
124: p_imp_header IN imp_headers_rec_type
131: -- Pre-reqs : None.
132: -- Parameters :
133: -- IN : p_api_version IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional
135: -- Default = FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Optional
137: -- Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional
139: -- Default = FND_API.G_VALID_LEVEL_FULL
133: -- IN : p_api_version IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional
135: -- Default = FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Optional
137: -- Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional
139: -- Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_imp_header IN imp_header_rec_type
141: -- p_map_obj_num IN NUMBER,
135: -- Default = FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Optional
137: -- Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional
139: -- Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_imp_header IN imp_header_rec_type
141: -- p_map_obj_num IN NUMBER,
142: -- OUT : x_return_status OUT VARCHAR2(1)
143: -- x_msg_count OUT NUMBER
151: -- End of comments
152:
153: PROCEDURE Delete_Imp_header
154: ( p_api_version IN NUMBER ,
155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
156: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: x_return_status OUT NOCOPY VARCHAR2 ,
159: x_msg_count OUT NOCOPY NUMBER ,
152:
153: PROCEDURE Delete_Imp_header
154: ( p_api_version IN NUMBER ,
155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
156: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: x_return_status OUT NOCOPY VARCHAR2 ,
159: x_msg_count OUT NOCOPY NUMBER ,
160: x_msg_data OUT NOCOPY VARCHAR2 ,
153: PROCEDURE Delete_Imp_header
154: ( p_api_version IN NUMBER ,
155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
156: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: x_return_status OUT NOCOPY VARCHAR2 ,
159: x_msg_count OUT NOCOPY NUMBER ,
160: x_msg_data OUT NOCOPY VARCHAR2 ,
161: p_map_obj_num IN NUMBER,
177: --
178: -- End of comments
179:
180: PROCEDURE Get_Oerr_Msg
181: ( p_errcode IN VARCHAR2 := FND_API.G_FALSE ,
182: x_errmsg OUT NOCOPY VARCHAR2
183: );
184:
185: END CN_IMP_HEADERS_PVT;