[Home] [Help]
PACKAGE: APPS.IEM_EMAIL_SERVERS_PVT
Source
1 PACKAGE IEM_EMAIL_SERVERS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvevrs.pls 115.7 2002/12/03 20:02:36 chtang shipped $ */
3
4 PROCEDURE create_item_sss (p_api_version_number IN NUMBER,
5 p_init_msg_list IN VARCHAR2,
6 p_commit IN VARCHAR2,
7 p_server_name IN VARCHAR2,
8 p_dns_name IN VARCHAR2,
9 p_ip_address IN VARCHAR2,
10 p_port IN NUMBER,
11 p_server_type_id IN NUMBER,
12 p_rt_availability IN VARCHAR2,
13 p_server_group_id IN NUMBER,
14 p_CREATED_BY NUMBER,
15 p_CREATION_DATE DATE,
16 p_LAST_UPDATED_BY NUMBER,
17 p_LAST_UPDATE_DATE DATE,
18 p_LAST_UPDATE_LOGIN NUMBER,
19 p_ATTRIBUTE1 VARCHAR2,
20 p_ATTRIBUTE2 VARCHAR2,
21 p_ATTRIBUTE3 VARCHAR2,
22 p_ATTRIBUTE4 VARCHAR2,
23 p_ATTRIBUTE5 VARCHAR2,
24 p_ATTRIBUTE6 VARCHAR2,
25 p_ATTRIBUTE7 VARCHAR2,
26 p_ATTRIBUTE8 VARCHAR2,
27 p_ATTRIBUTE9 VARCHAR2,
28 p_ATTRIBUTE10 VARCHAR2,
29 p_ATTRIBUTE11 VARCHAR2,
30 p_ATTRIBUTE12 VARCHAR2,
31 p_ATTRIBUTE13 VARCHAR2,
32 p_ATTRIBUTE14 VARCHAR2,
33 p_ATTRIBUTE15 VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39
40 PROCEDURE create_item_wrap_sss (p_api_version_number IN NUMBER,
41 p_init_msg_list IN VARCHAR2,
42 p_commit IN VARCHAR2,
43 p_server_name IN VARCHAR2,
44 p_dns_name IN VARCHAR2,
45 p_ip_address IN VARCHAR2,
46 p_port IN NUMBER,
47 p_server_type_id IN NUMBER,
48 p_rt_availability IN VARCHAR2,
49 p_server_group_id IN NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2
53 );
54
55 -- Start of Comments
56 -- API name : delete_item
57 -- Type : Private
58 -- Function : This procedure delete a record in the table IEM_EMAIL_SERVERS
59 -- Pre-reqs : None.
60 -- Parameters :
61 -- IN
62 -- p_api_version_number IN NUMBER Required
63 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
64 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
65 -- p_email_server_id IN NUMBER:=FND_API.G_MISS_NUM,
66 -- p_dns_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
67 -- p_ip_address IN VARCHAR2:=FND_API.G_MISS_CHAR,
68 -- p_port IN NUMBER:=FND_API.G_MISS_NUM,
69 --
70 -- OUT
71 -- x_return_status OUT VARCHAR2
72 -- x_msg_count OUT NUMBER
73 -- x_msg_data OUT VARCHAR2
74 --
75 -- Version : 1.0
76 -- Notes :
77 --
78 -- End of comments
79 -- **********************************************************
80
81 PROCEDURE delete_item (p_api_version_number IN NUMBER,
82 p_init_msg_list IN VARCHAR2,
83 p_commit IN VARCHAR2,
84 p_email_server_id IN NUMBER,
85 p_dns_name IN VARCHAR2,
86 p_ip_address IN VARCHAR2,
87 p_port IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92 -- Start of Comments
93 -- API name : update_item
94 -- Type : Private
95 -- Function : This procedure update a record in the table IEM_EMAIL_SERVERS
96 -- Pre-reqs : None.
97 -- Parameters :
98 -- IN
99 -- p_api_version_number IN NUMBER Required
100 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
101 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102 -- p_email_server_id IN NUMBER:=NULL,
103 -- p_server_name IN varchar2:=NULL,
104 -- p_dns_name IN VARCHAR2:=NULL,
105 -- p_ip_address IN VARCHAR2:=NULL,
106 -- p_port IN NUMBER:=NULL,
107 -- p_server_type_id IN number:=NULL,
108 -- p_rt_availability in varchar2:=NULL,
109 -- p_server_group_id in number:=NULL,
110 --
111 -- OUT
112 -- x_return_status OUT VARCHAR2
113 -- x_msg_count OUT NUMBER
114 -- x_msg_data OUT VARCHAR2
115 --
116 -- Version : 1.0
117 -- Notes :
118 --
119 -- End of comments
120 -- **********************************************************
121
122 PROCEDURE update_item_sss (p_api_version_number IN NUMBER,
123 p_init_msg_list IN VARCHAR2,
124 p_commit IN VARCHAR2,
125 p_email_server_id IN NUMBER,
126 p_server_name IN varchar2,
127 p_dns_name IN VARCHAR2,
128 p_ip_address IN VARCHAR2,
129 p_port IN NUMBER,
130 p_server_type_id IN number,
131 p_rt_availability in varchar2,
132 p_server_group_id in number,
133 p_LAST_UPDATED_BY NUMBER,
134 p_LAST_UPDATE_DATE DATE,
135 p_LAST_UPDATE_LOGIN NUMBER,
136 p_ATTRIBUTE1 VARCHAR2,
137 p_ATTRIBUTE2 VARCHAR2,
138 p_ATTRIBUTE3 VARCHAR2,
139 p_ATTRIBUTE4 VARCHAR2,
140 p_ATTRIBUTE5 VARCHAR2,
141 p_ATTRIBUTE6 VARCHAR2,
142 p_ATTRIBUTE7 VARCHAR2,
143 p_ATTRIBUTE8 VARCHAR2,
144 p_ATTRIBUTE9 VARCHAR2,
145 p_ATTRIBUTE10 VARCHAR2,
146 p_ATTRIBUTE11 VARCHAR2,
147 p_ATTRIBUTE12 VARCHAR2,
148 p_ATTRIBUTE13 VARCHAR2,
149 p_ATTRIBUTE14 VARCHAR2,
150 p_ATTRIBUTE15 VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2
154 );
155
156 PROCEDURE update_item_wrap_sss (p_api_version_number IN NUMBER,
157 p_init_msg_list IN VARCHAR2,
158 p_commit IN VARCHAR2,
159 p_email_server_id IN NUMBER,
160 p_server_name IN varchar2,
161 p_dns_name IN VARCHAR2,
162 p_ip_address IN VARCHAR2,
163 p_port IN NUMBER,
164 p_server_type_id IN number,
165 p_rt_availability in varchar2,
166 p_server_group_id in number,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2
170 );
171
172 PROCEDURE delete_item_batch
173 (p_api_version_number IN NUMBER,
174 P_init_msg_list IN VARCHAR2,
175 p_commit IN VARCHAR2,
176 p_group_tbl IN jtf_varchar2_Table_100,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2);
180
181 END IEM_EMAIL_SERVERS_PVT;