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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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;
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:
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:
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;
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:
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
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,
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 ,
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 ,
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 ,
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,
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
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
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
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 ,
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 ,
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 ,
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
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)
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)
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 ,
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 ,
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,
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
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)
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)
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 ,
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 ,
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