[Home] [Help]
PACKAGE: APPS.IEM_EMC_SERVERS_PVT
Source
1 PACKAGE IEM_EMC_SERVERS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvemcs.pls 115.4 2002/12/09 21:31:35 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_EMC_SERVERS
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_group_id IN NUMBER,
14 -- p_emc_server_name IN VARCHAR2,
15 -- p_dns_name IN VARCHAR2,
16 -- p_ip_address IN NUMBER,
17 --
18 -- OUT
19 -- x_return_status OUT VARCHAR2
20 -- x_msg_count OUT NUMBER
21 -- x_msg_data OUT VARCHAR2
22 --
23 -- Version : 1.0
24 -- Notes :
25 --
26 -- End of comments
27 -- **********************************************************
28
29 PROCEDURE create_item (p_api_version_number IN NUMBER,
30 p_init_msg_list IN VARCHAR2 ,
31 p_commit IN VARCHAR2 ,
32 p_server_group_id IN NUMBER,
33 p_emc_server_name IN VARCHAR2,
34 p_dns_name IN VARCHAR2,
35 p_ip_address IN VARCHAR2,
36 p_CREATED_BY NUMBER,
37 p_CREATION_DATE DATE,
38 p_LAST_UPDATED_BY NUMBER,
39 p_LAST_UPDATE_DATE DATE,
40 p_LAST_UPDATE_LOGIN NUMBER,
41 p_ATTRIBUTE1 VARCHAR2,
42 p_ATTRIBUTE2 VARCHAR2,
43 p_ATTRIBUTE3 VARCHAR2,
44 p_ATTRIBUTE4 VARCHAR2,
45 p_ATTRIBUTE5 VARCHAR2,
46 p_ATTRIBUTE6 VARCHAR2,
47 p_ATTRIBUTE7 VARCHAR2,
48 p_ATTRIBUTE8 VARCHAR2,
49 p_ATTRIBUTE9 VARCHAR2,
50 p_ATTRIBUTE10 VARCHAR2,
51 p_ATTRIBUTE11 VARCHAR2,
52 p_ATTRIBUTE12 VARCHAR2,
53 p_ATTRIBUTE13 VARCHAR2,
54 p_ATTRIBUTE14 VARCHAR2,
55 p_ATTRIBUTE15 VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 -- Start of Comments
62 -- API name : delete_item
63 -- Type : Private
64 -- Function : This procedure delete a record in the table IEM_EMC_SERVERS
65 -- Pre-reqs : None.
66 -- Parameters :
67 -- IN
68 -- p_api_version_number IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
70 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71 -- p_emc_server_id in number:=null,
72 -- p_emc_server_name IN VARCHAR2 :=null,
73 -- p_server_group_id IN NUMBER:=null,
74
75 -- OUT
76 -- x_return_status OUT VARCHAR2
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2
79 --
80 -- Version : 1.0
81 -- Notes :
82 --
83 -- End of comments
84 -- **********************************************************
85
86 PROCEDURE delete_item (p_api_version_number IN NUMBER,
87 p_init_msg_list IN VARCHAR2 ,
88 p_commit IN VARCHAR2 ,
89 p_emc_server_id in number,
90 p_emc_server_name IN VARCHAR2 ,
91 p_server_group_id IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2
95 );
96 -- Start of Comments
97 -- API name : update_item
98 -- Type : Private
99 -- Function : This procedure update a record in the table IEM_EMC_SERVERS
100 -- Pre-reqs : None.
101 -- Parameters :
102 -- IN
103 -- p_api_version_number IN NUMBER Required
104 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
105 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106 -- p_emc_server_id IN NUMBER:=NULL,
107 -- p_emc_server_group_id IN NUMBER:=NULL,
108 -- p_emc_server_name IN VARCHAR2:=NULL,
109 -- p_dns_name IN VARCHAR2:=NULL,
110 -- p_ip_address IN VARCHAR2:=NULL,
111 --
112 -- OUT
113 -- x_return_status OUT VARCHAR2
114 -- x_msg_count OUT NUMBER
115 -- x_msg_data OUT VARCHAR2
116 --
117 -- Version : 1.0
118 -- Notes :
119 --
120 -- End of comments
121 -- **********************************************************
122
123 PROCEDURE update_item (p_api_version_number IN NUMBER,
124 p_init_msg_list IN VARCHAR2 ,
125 p_commit IN VARCHAR2 ,
126 p_emc_server_id IN NUMBER,
127 p_server_group_id IN NUMBER,
128 p_emc_server_name IN VARCHAR2,
129 p_dns_name IN VARCHAR2,
130 p_ip_address IN VARCHAR2,
131 p_CREATED_BY NUMBER,
132 p_CREATION_DATE DATE,
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 delete_item_batch
157 (p_api_version_number IN NUMBER,
158 P_init_msg_list IN VARCHAR2 ,
159 p_commit IN VARCHAR2 ,
160 p_group_tbl IN jtf_varchar2_Table_100,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2);
164
165 END IEM_EMC_SERVERS_PVT;