[Home] [Help]
PACKAGE: APPS.CN_IMP_HEADERS_PVT
Source
1 PACKAGE CN_IMP_HEADERS_PVT AUTHID CURRENT_USER AS
2 -- $Header: cnvimhrs.pls 115.8 2002/11/21 21:13:31 hlchen ship $
3
4 -- * ------------------------------------------------------------------+
5 -- Record Type Definition
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,
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,
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,
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,
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
51 G_MISS_IMP_HEADERS_REC IMP_HEADERS_REC_TYPE;
52
53 -- Start of comments
54 -- API name : Create_Imp_header
55 -- Type : Private.
56 -- Function :
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
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)
70 -- x_imp_header_id OUT NUMBER
71 -- Version : Current version 1.0
72 --
73 --
74 --
75 -- Notes : Note text
76 --
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 ,
86 x_msg_data OUT NOCOPY VARCHAR2 ,
87 p_imp_header IN imp_headers_rec_type,
88 x_imp_header_id OUT NOCOPY NUMBER
89 );
90
91 -- Start of comments
92 -- API name : Update_Imp_header
93 -- Type : Private.
94 -- Function :
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
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)
108 -- Version : Current version 1.0
109 --
110 --
111 --
112 -- Notes : Note text
113 --
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 ,
123 x_msg_data OUT NOCOPY VARCHAR2 ,
124 p_imp_header IN imp_headers_rec_type
125 );
126
127 -- Start of comments
128 -- API name : Delete_Imp_header
129 -- Type : Private.
130 -- Function :
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
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
144 -- x_msg_data OUT VARCHAR2(2000)
145 -- Version : Current version 1.0
146 --
147 --
148 --
149 -- Notes : Note text
150 --
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 ,
160 x_msg_data OUT NOCOPY VARCHAR2 ,
161 p_map_obj_num IN NUMBER,
162 p_imp_header IN imp_headers_rec_type
163 );
164
165 -- Start of comments
166 -- API name : Get_Oerr_Msg
167 -- Type : Private.
168 -- Function :
169 -- Pre-reqs : None.
170 -- Parameters :
171 -- IN :
172 -- p_errcode IN VARCHAR2
173 -- OUT :
174 -- x_errmsg OUT VARCHAR2(2000)
175 -- Version : Current version 1.0
176 -- Notes : Note text
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;