[Home] [Help]
PACKAGE: APPS.IEM_EMAIL_SERVER_TYPES_PVT
Source
1 PACKAGE IEM_EMAIL_SERVER_TYPES_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvsvts.pls 115.4 2002/12/04 00:41:54 sboorela shipped $ */
3 -- Start of Comments
4 -- API name : create_item
5 -- Type : Private
6 -- Function : This procedure create a record in the table IEM_EMAIL_SERVER_TYPES
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN
10 -- p_api_version_number IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
12 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_server_type IN VARCHAR2:=FND_API.G_MISS_CHAR,
14 -- p_is_secure IN VARCHAR2:=FND_API.G_MISS_CHAR,
15 -- p_type_desc IN VARCHAR2:=FND_API.G_MISS_CHAR,
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_server_type IN VARCHAR2,
32 p_is_secure IN VARCHAR2,
33 p_type_desc IN VARCHAR2,
34 p_CREATED_BY NUMBER,
35 p_CREATION_DATE DATE,
36 p_LAST_UPDATED_BY NUMBER,
37 p_LAST_UPDATE_DATE DATE,
38 p_LAST_UPDATE_LOGIN NUMBER,
39 p_ATTRIBUTE1 VARCHAR2,
40 p_ATTRIBUTE2 VARCHAR2,
41 p_ATTRIBUTE3 VARCHAR2,
42 p_ATTRIBUTE4 VARCHAR2,
43 p_ATTRIBUTE5 VARCHAR2,
44 p_ATTRIBUTE6 VARCHAR2,
45 p_ATTRIBUTE7 VARCHAR2,
46 p_ATTRIBUTE8 VARCHAR2,
47 p_ATTRIBUTE9 VARCHAR2,
48 p_ATTRIBUTE10 VARCHAR2,
49 p_ATTRIBUTE11 VARCHAR2,
50 p_ATTRIBUTE12 VARCHAR2,
51 p_ATTRIBUTE13 VARCHAR2,
52 p_ATTRIBUTE14 VARCHAR2,
53 p_ATTRIBUTE15 VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 -- Start of Comments
60 -- API name : delete_item
61 -- Type : Private
62 -- Function : This procedure delete a record in the table IEM_EMAIL_SERVER_TYPES
63 -- Pre-reqs : None.
64 -- Parameters :
65 -- IN
66 -- p_api_version_number IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
68 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
69 -- p_server_type_id IN NUMBER:=FND_API.G_MISS_NUM,
70 -- p_server_type IN VARCHAR2:=FND_API.G_MISS_CHAR,
71 --
72 -- OUT
73 -- x_return_status OUT VARCHAR2
74 -- x_msg_count OUT NUMBER
75 -- x_msg_data OUT VARCHAR2
76 --
77 -- Version : 1.0
78 -- Notes :
79 --
80 -- End of comments
81 -- **********************************************************
82
83 PROCEDURE delete_item (p_api_version_number IN NUMBER,
84 p_init_msg_list IN VARCHAR2 ,
85 p_commit IN VARCHAR2 ,
86 p_server_type_id IN NUMBER,
87 p_server_type IN VARCHAR2,
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_SERVER_TY--PES
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_server_type_id IN NUMBER:=NULL,
103 -- p_server_type IN VARCHAR2:=NULL,
104 -- p_is_secure IN VARCHAR2:=NULL,
105 -- p_type_desc IN VARCHAR2:=NULL,
106 --
107 -- OUT
108 -- x_return_status OUT VARCHAR2
109 -- x_msg_count OUT NUMBER
110 -- x_msg_data OUT VARCHAR2
111 --
112 -- Version : 1.0
113 -- Notes :
114 --
115 -- End of comments
116 -- **********************************************************
117
118 PROCEDURE update_item (p_api_version_number IN NUMBER,
119 p_init_msg_list IN VARCHAR2 ,
120 p_commit IN VARCHAR2 ,
121 p_server_type_id IN NUMBER,
122 p_server_type IN VARCHAR2,
123 p_is_secure IN VARCHAR2,
124 p_type_desc IN VARCHAR2,
125 p_LAST_UPDATED_BY NUMBER,
126 p_LAST_UPDATE_DATE DATE,
127 p_LAST_UPDATE_LOGIN NUMBER,
128 p_ATTRIBUTE1 VARCHAR2,
129 p_ATTRIBUTE2 VARCHAR2,
130 p_ATTRIBUTE3 VARCHAR2,
131 p_ATTRIBUTE4 VARCHAR2,
132 p_ATTRIBUTE5 VARCHAR2,
133 p_ATTRIBUTE6 VARCHAR2,
134 p_ATTRIBUTE7 VARCHAR2,
135 p_ATTRIBUTE8 VARCHAR2,
136 p_ATTRIBUTE9 VARCHAR2,
137 p_ATTRIBUTE10 VARCHAR2,
138 p_ATTRIBUTE11 VARCHAR2,
139 p_ATTRIBUTE12 VARCHAR2,
140 p_ATTRIBUTE13 VARCHAR2,
141 p_ATTRIBUTE14 VARCHAR2,
142 p_ATTRIBUTE15 VARCHAR2,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2
146 );
147
148 END IEM_EMAIL_SERVER_TYPES_PVT;