1 PACKAGE AMS_List_Entries_PUB AUTHID CURRENT_USER AS
2 /* $Header: amsplies.pls 115.4 2002/11/22 08:54:03 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_List_Entries_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 -- ==============================================================================
19 -- Start of Comments
20 -- ==============================================================================
21 -- API Name
22 -- Create_List_Entries
23 -- Type
24 -- Public
25 -- Pre-Req
26 --
27 -- Parameters
28 --
29 -- IN
30 -- p_api_version_number IN NUMBER Required
31 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33 -- p_list_entries_rec IN list_entries_rec_type Required
34 --
35 -- OUT
36 -- x_return_status OUT VARCHAR2
37 -- x_msg_count OUT NUMBER
38 -- x_msg_data OUT VARCHAR2
39 -- Version : Current version 1.0
40 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
41 -- and basic operation, developer must manually add parameters and business logic as necessary.
42 --
43 -- End of Comments
44 -- ==============================================================================
45 --
46
47 PROCEDURE Create_List_Entries(
48 p_api_version_number IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE,
51
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55
56 p_list_entries_rec IN AMS_List_Entries_PVT.list_entries_rec_type ,
57 x_list_entry_id OUT NOCOPY NUMBER
58 );
59
60 -- ==============================================================================
61 -- Start of Comments
62 -- ==============================================================================
63 -- API Name
64 -- Update_List_Entries
65 -- Type
66 -- Public
67 -- Pre-Req
68 --
69 -- Parameters
70 --
71 -- IN
72 -- p_api_version_number IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
74 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
75 -- p_list_entries_rec IN list_entries_rec_type Required
76 --
77 -- OUT
78 -- x_return_status OUT VARCHAR2
79 -- x_msg_count OUT NUMBER
80 -- x_msg_data OUT VARCHAR2
81 -- Version : Current version 1.0
82 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
83 -- and basic operation, developer must manually add parameters and business logic as necessary.
84 --
85 -- End of Comments
86 -- ==============================================================================
87 --
88
89 PROCEDURE Update_List_Entries(
90 p_api_version_number IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92 p_commit IN VARCHAR2 := FND_API.G_FALSE,
93
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97
98 p_list_entries_rec IN AMS_List_Entries_PVT.list_entries_rec_type,
99 x_object_version_number OUT NOCOPY NUMBER
100 );
101
102 -- ==============================================================================
103 -- Start of Comments
104 -- ==============================================================================
105 -- API Name
106 -- Delete_List_Entries
107 -- Type
108 -- Public
109 -- Pre-Req
110 --
111 -- Parameters
112 --
113 -- IN
114 -- p_api_version_number IN NUMBER Required
115 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117 -- p_LIST_ENTRY_ID IN NUMBER
118 -- p_object_version_number IN NUMBER Optional Default = NULL
119 --
120 -- OUT
121 -- x_return_status OUT VARCHAR2
122 -- x_msg_count OUT NUMBER
123 -- x_msg_data OUT VARCHAR2
124 -- Version : Current version 1.0
125 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
126 -- and basic operation, developer must manually add parameters and business logic as necessary.
127 --
128 -- End of Comments
129 -- ==============================================================================
130 --
131
132 PROCEDURE Delete_List_Entries(
133 p_api_version_number IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135 p_commit IN VARCHAR2 := FND_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_list_entry_id IN NUMBER,
140 p_object_version_number IN NUMBER
141 );
142
143 -- ==============================================================================
144 -- Start of Comments
145 -- ==============================================================================
146 -- API Name
147 -- Lock_List_Entries
148 -- Type
149 -- Public
150 -- Pre-Req
151 --
152 -- Parameters
153 --
154 -- IN
155 -- p_api_version_number IN NUMBER Required
156 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
157 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158 -- p_list_entries_rec IN list_entries_rec_type Required
159 --
160 -- OUT
161 -- x_return_status OUT VARCHAR2
162 -- x_msg_count OUT NUMBER
163 -- x_msg_data OUT VARCHAR2
164 -- Version : Current version 1.0
165 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
166 -- and basic operation, developer must manually add parameters and business logic as necessary.
167 --
168 -- End of Comments
169 -- ==============================================================================
170 --
171
172 PROCEDURE Lock_List_Entries(
173 p_api_version_number IN NUMBER,
174 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178
179 p_list_entry_id IN NUMBER,
180 p_object_version IN NUMBER
181 );
182
183 END AMS_List_Entries_PUB;