1 PACKAGE IEM_EML_CLASSIFICATIONS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvecls.pls 115.8 2003/07/31 01:20:50 sboorela shipped $*/
3
4 TYPE EMCLASS_rec_typ IS RECORD (
5 CLASSIFICATION_ID NUMBER(15,0) ,
6 CLASSIFICATION VARCHAR2(50) ,
7 SCORE NUMBER);
8
9 TYPE EMCLASS_tbl_type IS TABLE OF EMCLASS_rec_typ INDEX BY BINARY_INTEGER;
10
11 -- Start of Comments
12 -- API name : create_item
13 -- Type : Private
14 -- Function : This procedure create a record in the table IEM_EMAIL_CLASSIFICATIONS
15 -- Pre-reqs : None.
16 -- Parameters :
17 -- IN
18 -- p_api_version_number IN NUMBER Required
19 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
20 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
21 -- p_email_account_id IN NUMBER,
22 -- p_classification_id IN NUMBER,
23 -- p_score IN NUMBER,
24 -- p_message_id IN NUMBER,
25 --
26 -- OUT
27 -- x_return_status OUT VARCHAR2
28 -- x_msg_count OUT NUMBER
29 -- x_msg_data OUT VARCHAR2
30 --
31 -- Version : 1.0
32 -- Notes :
33 --
34 -- End of comments
35 -- **********************************************************
36
37 PROCEDURE create_item (p_api_version_number IN NUMBER,
38 p_init_msg_list IN VARCHAR2 ,
39 p_commit IN VARCHAR2 ,
40 p_email_account_id IN NUMBER,
41 p_classification_id IN NUMBER,
42 p_score IN NUMBER,
43 p_message_id IN NUMBER,
44 p_CREATED_BY NUMBER,
45 p_CREATION_DATE DATE,
46 p_LAST_UPDATED_BY NUMBER,
47 p_LAST_UPDATE_DATE DATE,
48 p_LAST_UPDATE_LOGIN NUMBER ,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 -- Start of Comments
55 -- API name : delete_item
56 -- Type : Private
57 -- Function : This procedure delete a record in the table IEM_EMAIL_CLASSIFICATIONS
58 -- Pre-reqs : None.
59 -- Parameters :
60 -- IN
61 -- p_api_version_number IN NUMBER Required
62 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
63 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64 -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM ,
65 -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
66 -- p_message_id IN NUMBER:=FND_API.G_MISS_NUM,
67
68 -- OUT
69 -- x_return_status OUT VARCHAR2
70 -- x_msg_count OUT NUMBER
71 -- x_msg_data OUT VARCHAR2
72 --
73 -- Version : 1.0
74 -- Notes :
75 --
76 -- End of comments
77 -- **********************************************************
78
79 PROCEDURE delete_item (p_api_version_number IN NUMBER,
80 p_init_msg_list IN VARCHAR2 ,
81 p_commit IN VARCHAR2 ,
82 p_email_account_id IN NUMBER,
83 p_classification_id IN NUMBER,
84 p_message_id IN NUMBER,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90 -- Start of Comments
91 -- API name : getclassification
92 -- Type : Private
93 -- Function : This procedure delete a record in the table IEM_EMAIL_CLASSIFICATIONS
94 -- Pre-reqs : None.
95 -- Parameters :
96 -- IN
97 -- p_api_version_number IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
99 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100 -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM ,
101 -- p_message_id IN NUMBER:=FND_API.G_MISS_NUM,
102
103 -- OUT
104 -- x_Email_Classn_tbl OUT EMCLASS_tbl_type
105 -- x_return_status OUT VARCHAR2
106 -- x_msg_count OUT NUMBER
107 -- x_msg_data OUT VARCHAR2
108 --
109 -- Version : 1.0
110 -- Notes :
111 --
112 -- End of comments
113 -- **********************************************************
114
115 PROCEDURE getClassification (p_api_version_number IN NUMBER,
116 p_init_msg_list IN VARCHAR2 ,
117 p_commit IN VARCHAR2 ,
118 p_email_account_id IN NUMBER,
119 p_message_id IN NUMBER,
120 x_Email_Classn_tbl OUT NOCOPY EMCLASS_tbl_type,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2
124 );
125 -- This is the new api for 11.5.10 /MP-R. This Api will return the category id in case MES category based
126 -- mapping
127 PROCEDURE getClassification (p_api_version_number IN NUMBER,
128 p_init_msg_list IN VARCHAR2 ,
129 p_commit IN VARCHAR2 ,
130 p_email_account_id IN NUMBER,
131 p_message_id IN NUMBER,
132 x_category_id OUT NOCOPY NUMBER,
133 x_Email_Classn_tbl OUT NOCOPY EMCLASS_tbl_type,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138 -- Start of Comments
139 -- API name : create_item
140 -- Type : Private
141 -- Function : This procedure create a record in the table IEM_EMAIL_CLASSIFICATIONS
142 -- Pre-reqs : None.
143 -- Parameters :
144 -- IN
145 -- p_api_version_number IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
147 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_email_account_id IN NUMBER,
149 -- p_classification_id IN NUMBER,
150 -- p_score IN NUMBER,
151 -- p_message_id IN NUMBER,
152 -- p_class_string IN varchar2,
153 --
154 -- OUT
155 -- x_return_status OUT VARCHAR2
156 -- x_msg_count OUT NUMBER
157 -- x_msg_data OUT VARCHAR2
158 --
159 -- Version : 1.0
160 -- Notes :
161 --
162 -- End of comments
163 -- **********************************************************
164
165 PROCEDURE create_item (p_api_version_number IN NUMBER,
166 p_init_msg_list IN VARCHAR2 ,
167 p_commit IN VARCHAR2 ,
168 p_email_account_id IN NUMBER,
169 p_classification_id IN NUMBER,
170 p_score IN NUMBER,
171 p_message_id IN NUMBER,
172 p_class_string IN varchar2,
173 p_CREATED_BY NUMBER,
174 p_CREATION_DATE DATE,
175 p_LAST_UPDATED_BY NUMBER ,
176 p_LAST_UPDATE_DATE DATE,
177 p_LAST_UPDATE_LOGIN NUMBER ,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2);
181 END IEM_EML_CLASSIFICATIONS_PVT;