DBA Data[Home] [Help]

APPS.CN_IMP_MAPS_PVT dependencies on FND_API

Line 13: IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 14: NAME 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,

Line 15: IMPORT_TYPE_CODE VARCHAR2(30) := 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,

Line 16: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

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,

Line 17: ATTRIBUTE_CATEGORY VARCHAR2(30) := 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,

Line 18: ATTRIBUTE1 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,

Line 19: ATTRIBUTE2 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,

Line 20: ATTRIBUTE3 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,

Line 21: ATTRIBUTE4 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,

Line 22: ATTRIBUTE5 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,

Line 23: ATTRIBUTE6 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,

Line 24: ATTRIBUTE7 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,

Line 25: ATTRIBUTE8 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,

Line 26: ATTRIBUTE9 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,

Line 27: ATTRIBUTE10 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,

Line 28: ATTRIBUTE11 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,

Line 29: ATTRIBUTE12 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,

Line 30: ATTRIBUTE13 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,

Line 31: ATTRIBUTE14 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,

Line 32: ATTRIBUTE15 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,

Line 33: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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

Line 34: CREATED_BY 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: );

Line 35: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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:

Line 36: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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;

Line 37: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

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:

Line 43: (value VARCHAR2(120) := FND_API.G_MISS_CHAR,

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:

Line 44: text VARCHAR2(120) := FND_API.G_MISS_CHAR,

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;

Line 45: colname VARCHAR2(120) := FND_API.G_MISS_CHAR

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:

Line 62: -- Default = FND_API.G_FALSE

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

Line 64: -- Default = FND_API.G_FALSE

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,

Line 66: -- Default = FND_API.G_VALID_LEVEL_FULL

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 ,

Line 85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 107: -- Default = FND_API.G_FALSE

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

Line 109: -- Default = FND_API.G_FALSE

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

Line 111: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 131: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 154: -- Default = FND_API.G_FALSE

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

Line 156: -- Default = FND_API.G_FALSE

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)

Line 158: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 191: -- Default = FND_API.G_FALSE

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

Line 193: -- Default = FND_API.G_FALSE

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)

Line 195: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 210: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 211: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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