[Home] [Help]
PACKAGE: APPS.IEM_EMAIL_ICNTR_MAPS_PVT
Source
1 PACKAGE IEM_EMAIL_ICNTR_MAPS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvmaps.pls 115.4 2002/12/03 23:21:19 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_ICNTR_MAPS
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_email_account_id IN NUMBER ,
14 -- p_server_group_id IN NUMBER ,
15 --
16 -- OUT
17 -- x_return_status OUT VARCHAR2
18 -- x_msg_count OUT NUMBER
19 -- x_msg_data OUT VARCHAR2
20 --
21 -- Version : 1.0
22 -- Notes :
23 --
24 -- End of comments
25 -- **********************************************************
26
27 PROCEDURE create_item (p_api_version_number IN NUMBER,
28 p_init_msg_list IN VARCHAR2 ,
29 p_commit IN VARCHAR2 ,
30 p_email_account_id IN NUMBER ,
31 p_server_group_id IN NUMBER ,
32 p_CREATED_BY NUMBER,
33 p_CREATION_DATE DATE,
34 p_LAST_UPDATED_BY NUMBER,
35 p_LAST_UPDATE_DATE DATE,
36 p_LAST_UPDATE_LOGIN NUMBER,
37 p_ATTRIBUTE1 VARCHAR2,
38 p_ATTRIBUTE2 VARCHAR2,
39 p_ATTRIBUTE3 VARCHAR2,
40 p_ATTRIBUTE4 VARCHAR2,
41 p_ATTRIBUTE5 VARCHAR2,
42 p_ATTRIBUTE6 VARCHAR2,
43 p_ATTRIBUTE7 VARCHAR2,
44 p_ATTRIBUTE8 VARCHAR2,
45 p_ATTRIBUTE9 VARCHAR2,
46 p_ATTRIBUTE10 VARCHAR2,
47 p_ATTRIBUTE11 VARCHAR2,
48 p_ATTRIBUTE12 VARCHAR2,
49 p_ATTRIBUTE13 VARCHAR2,
50 p_ATTRIBUTE14 VARCHAR2,
51 p_ATTRIBUTE15 VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 -- Start of Comments
58 -- API name : delete_item
59 -- Type : Private
60 -- Function : This procedure delete a record in the table IEM_EMAIL_ICNTR_MAPS
61 -- Pre-reqs : None.
62 -- Parameters :
63 -- IN
64 -- p_api_version_number IN NUMBER Required
65 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
66 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
67 -- p_email_icntr_map_id IN NUMBER :=FND_API.G_MISS_NUM,
68 -- p_email_account_id 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_icntr_map_id IN NUMBER ,
85 p_email_account_id IN NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90 -- Start of Comments
91 -- API name : update_item
92 -- Type : Private
93 -- Function : This procedure update a record in the table IEM_EMAIL_ICNTR_MAPS
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_icntr_map_id IN NUMBER :=FND_API.G_MISS_NUM,
101 -- p_email_account_id IN VARCHAR2:=FND_API.G_MISS_NUM ,
102 -- p_server_group_id IN VARCHAR2:=FND_API.G_MISS_NUM,
103 --
104 -- OUT
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 update_item (p_api_version_number IN NUMBER,
116 p_init_msg_list IN VARCHAR2 ,
117 p_commit IN VARCHAR2 ,
118 p_email_icntr_map_id IN NUMBER ,
119 p_email_account_id IN VARCHAR2,
120 p_server_group_id IN VARCHAR2,
121 p_LAST_UPDATED_BY NUMBER,
122 p_LAST_UPDATE_DATE DATE,
123 p_LAST_UPDATE_LOGIN NUMBER,
124 p_ATTRIBUTE1 VARCHAR2,
125 p_ATTRIBUTE2 VARCHAR2,
126 p_ATTRIBUTE3 VARCHAR2,
127 p_ATTRIBUTE4 VARCHAR2,
128 p_ATTRIBUTE5 VARCHAR2,
129 p_ATTRIBUTE6 VARCHAR2,
130 p_ATTRIBUTE7 VARCHAR2,
131 p_ATTRIBUTE8 VARCHAR2,
132 p_ATTRIBUTE9 VARCHAR2,
133 p_ATTRIBUTE10 VARCHAR2,
134 p_ATTRIBUTE11 VARCHAR2,
135 p_ATTRIBUTE12 VARCHAR2,
136 p_ATTRIBUTE13 VARCHAR2,
137 p_ATTRIBUTE14 VARCHAR2,
138 p_ATTRIBUTE15 VARCHAR2,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144 END IEM_EMAIL_ICNTR_MAPS_PVT;