[Home] [Help]
PACKAGE: APPS.IEM_CLASSIFICATIONS_PVT
Source
1 PACKAGE IEM_CLASSIFICATIONS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvclas.pls 115.12 2002/12/06 19:17:11 sboorela shipped $*/
3 /***************************************************************/
4 -- Start of Comments
5 -- API name : create_item
6 -- Type : Private
7 -- Function : This procedure create a record in the table IEM_CLASSIFICATIONS
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN
11 -- p_api_version_number IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14 -- p_email_account_id IN NUMBER,
15 -- p_classification IN VARCHAR2,
16 --
17 -- OUT
18 -- x_return_status OUT VARCHAR2
19 -- x_msg_count OUT NUMBER
20 -- x_msg_data OUT VARCHAR2
21 --
22 -- Version : 1.0
23 -- Notes :
24 --
25 -- End of comments
26 -- **********************************************************
27
28 PROCEDURE create_item (p_api_version_number IN NUMBER,
29 p_init_msg_list IN VARCHAR2 ,
30 p_commit IN VARCHAR2 ,
31 p_email_account_id IN NUMBER,
32 p_classification IN VARCHAR2,
33 p_CREATED_BY NUMBER,
34 p_CREATION_DATE DATE,
35 p_LAST_UPDATED_BY NUMBER,
36 p_LAST_UPDATE_DATE DATE,
37 p_LAST_UPDATE_LOGIN NUMBER,
38 p_ATTRIBUTE1 VARCHAR2,
39 p_ATTRIBUTE2 VARCHAR2,
40 p_ATTRIBUTE3 VARCHAR2,
41 p_ATTRIBUTE4 VARCHAR2,
42 p_ATTRIBUTE5 VARCHAR2,
43 p_ATTRIBUTE6 VARCHAR2,
44 p_ATTRIBUTE7 VARCHAR2,
45 p_ATTRIBUTE8 VARCHAR2,
46 p_ATTRIBUTE9 VARCHAR2,
47 p_ATTRIBUTE10 VARCHAR2,
48 p_ATTRIBUTE11 VARCHAR2,
49 p_ATTRIBUTE12 VARCHAR2,
50 p_ATTRIBUTE13 VARCHAR2,
51 p_ATTRIBUTE14 VARCHAR2,
52 p_ATTRIBUTE15 VARCHAR2,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE create_item_wrap (p_api_version_number IN NUMBER,
59 p_init_msg_list IN VARCHAR2 ,
60 p_commit IN VARCHAR2 ,
61 p_email_account_id IN NUMBER,
62 p_classification IN VARCHAR2,
63 p_CREATED_BY NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE create_item_wrap_sss (p_api_version_number IN NUMBER,
70 p_init_msg_list IN VARCHAR2 ,
71 p_commit IN VARCHAR2 ,
72 p_email_account_id IN NUMBER,
73 p_classification IN VARCHAR2,
74 p_CREATED_BY NUMBER,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2
78 );
79
80 -- Start of Comments
81 -- API name : delete_item
82 -- Type : Private
83 -- Function : This procedure delete a record in the table IEM_CLASSIFICATIONS
84 -- Pre-reqs : None.
85 -- Parameters :
86 -- IN
87 -- p_api_version_number IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
89 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90 -- p_email_account_id in number:=FND_API.G_MISS_NUM,
91 -- p_classification IN VARCHAR2 :=FND_API.G_MISS_CHAR,
92 -- p_classification_id in number:=FND_API.G_MISS_NUM,
93
94 -- OUT
95 -- x_return_status OUT VARCHAR2
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2
98 --
99 -- Version : 1.0
100 -- Notes :
101 --
102 -- End of comments
103 -- **********************************************************
104
105 PROCEDURE delete_item (p_api_version_number IN NUMBER,
106 p_init_msg_list IN VARCHAR2 ,
107 p_commit IN VARCHAR2 ,
108 p_email_account_id in number,
109 p_classification IN VARCHAR2 ,
110 p_classification_id in number,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2
114 );
115 -- Start of Comments
116 -- API name : update_item
117 -- Type : Private
118 -- Function : This procedure update a record in the table IEM_CLASSIFICATIONS
119 -- Pre-reqs : None.
120 -- Parameters :
121 -- IN
122 -- p_api_version_number IN NUMBER Required
123 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
124 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125 -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
126 -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM,
127 -- p_classification IN VARCHAR2:=FND_API.G_MISS_CHAR,
128 --
129 -- OUT
130 -- x_return_status OUT VARCHAR2
131 -- x_msg_count OUT NUMBER
132 -- x_msg_data OUT VARCHAR2
133 --
134 -- Version : 1.0
135 -- Notes :
136 --
137 -- End of comments
138 -- **********************************************************
139
140 PROCEDURE update_item (p_api_version_number IN NUMBER,
141 p_init_msg_list IN VARCHAR2 ,
142 p_commit IN VARCHAR2 ,
143 p_classification_id IN NUMBER,
144 p_email_account_id IN NUMBER,
145 p_classification IN VARCHAR2,
146 p_ATTRIBUTE1 VARCHAR2,
147 p_ATTRIBUTE2 VARCHAR2,
148 p_ATTRIBUTE3 VARCHAR2,
149 p_ATTRIBUTE4 VARCHAR2,
150 p_ATTRIBUTE5 VARCHAR2,
151 p_ATTRIBUTE6 VARCHAR2,
152 p_ATTRIBUTE7 VARCHAR2,
153 p_ATTRIBUTE8 VARCHAR2,
154 p_ATTRIBUTE9 VARCHAR2,
155 p_ATTRIBUTE10 VARCHAR2,
156 p_ATTRIBUTE11 VARCHAR2,
157 p_ATTRIBUTE12 VARCHAR2,
158 p_ATTRIBUTE13 VARCHAR2,
159 p_ATTRIBUTE14 VARCHAR2,
160 p_ATTRIBUTE15 VARCHAR2,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166 PROCEDURE delete_item_wrap
167 (p_api_version_number IN NUMBER,
168 P_init_msg_list IN VARCHAR2 ,
169 p_commit IN VARCHAR2 ,
170 p_clas_ids_tbl IN jtf_varchar2_Table_100,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2);
174
175 PROCEDURE delete_item_wrap_sss
176 (p_api_version_number IN NUMBER,
177 P_init_msg_list IN VARCHAR2 ,
178 p_commit IN VARCHAR2 ,
179 p_clas_ids_tbl IN jtf_varchar2_Table_100,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2);
183
184 PROCEDURE update_item_wrap (p_api_version_number IN NUMBER,
185 p_init_msg_list IN VARCHAR2 ,
186 p_commit IN VARCHAR2 ,
187 p_classification_id IN NUMBER,
188 p_email_account_id IN NUMBER,
189 p_classification IN VARCHAR2,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2
193 );
194 PROCEDURE update_item_wrap_sss (p_api_version_number IN NUMBER,
195 p_init_msg_list IN VARCHAR2 ,
196 p_commit IN VARCHAR2 ,
197 p_classification_id IN NUMBER,
198 p_email_account_id IN NUMBER,
199 p_classification IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2
203 );
204 -- This API is only called by the POSTMEN Process to insert data
205 -- into IEM_CLASSIFICATIONS
206 PROCEDURE create_item_pm (p_api_version_number IN NUMBER,
207 p_email_account_id IN NUMBER,
208 p_classification IN VARCHAR2,
209 p_query_response IN VARCHAR2,
210 x_doc_seq_num OUT NOCOPY NUMBER,
211 p_CREATED_BY NUMBER,
212 p_CREATION_DATE DATE,
213 p_LAST_UPDATED_BY NUMBER ,
214 p_LAST_UPDATE_DATE DATE,
215 p_LAST_UPDATE_LOGIN NUMBER,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2);
219
220 /********************************************************************/
221 END IEM_CLASSIFICATIONS_PVT;