1 Package AMS_LISTENTRY_PUB AUTHID CURRENT_USER AS
2 /* $Header: amsplses.pls 115.10 2003/01/28 00:01:23 jieli ship $ */
3 ---------------------------------------------------------------------
4 -- PROCEDURE
5 -- create_listentry
6 --
7 -- PURPOSE
8 -- Create a new list entry.
9 --
10 -- PARAMETERS
11 -- p_entry_rec: the new record to be inserted
12 -- x_entry_id: return the list_entry_id of the new campaign
13 --
14 -- NOTES
15 -- 1. object_version_number will be set to 1.
16 -- 2. If list_entry_id is passed in, the uniqueness will be checked.
17 -- Raise exception in case of duplicates.
18 -- 3. If list_entry_id is not passed in, generate a unique one from
19 -- the sequence.
20 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
21 -- Raise exception for invalid flag.
22 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
23 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
24 ---------------------------------------------------------------------
25 PROCEDURE create_listentry(
26 p_api_version IN NUMBER,
27 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
28 p_commit IN VARCHAR2 := FND_API.g_false,
29 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
30
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34
35 p_entry_rec IN AMS_LISTENTRY_PVT.entry_rec_type,
36 x_entry_id OUT NOCOPY NUMBER
37 );
38 ---------------------------------------------------------------------
39 -- PROCEDURE
40 -- update_listentry
41 --
42 -- PURPOSE
43 -- Update a listentry.
44 --
45 -- PARAMETERS
46 -- p_entry_rec: the record with new items
47 --
48 -- NOTES
49 -- 1. Raise exception if the object_version_number doesn't match.
50 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
51 -- that column won't be updated.
52 ----------------------------------------------------------------------
53 PROCEDURE update_listentry(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
56 p_commit IN VARCHAR2 := FND_API.g_false,
57 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
58
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62
63 p_entry_rec IN AMS_LISTENTRY_PVT.entry_rec_type
64 );
65
66 --------------------------------------------------------------------
67 -- PROCEDURE
68 -- delete_listentry
69 --
70 -- PURPOSE
71 -- Delete a listentry.
72 --
73 -- PARAMETERS
74 -- p_entry_id: the listentry_id
75 -- p_object_version: the object_version_number
76 --
77 -- NOTES
78 -- 1. Raise exception if the object_version_number doesn't match.
79 --------------------------------------------------------------------
80 PROCEDURE delete_listentry(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83 p_commit IN VARCHAR2 := FND_API.g_false,
84 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89
90 p_entry_id IN NUMBER,
91 p_object_version_number IN NUMBER
92 );
93
94 -------------------------------------------------------------------
95 -- PROCEDURE
96 -- lock_listentry
97 --
98 -- PURPOSE
99 -- Lock a List Entry.
100 --
101 -- PARAMETERS
102 -- p_entry_id: the list_entry_id
103 -- p_object_version: the object_version_number
104 --
105 -- NOTES
106 -- 1. Raise exception if the object_version_number doesn't match.
107 --------------------------------------------------------------------
108 PROCEDURE lock_listentry(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
111 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
112
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116
117 p_entry_id IN NUMBER,
118 p_object_version IN NUMBER
119 );
120
121 ---------------------------------------------------------------------
122 -- PROCEDURE
123 -- validate_listentry
124 --
125 -- PURPOSE
126 -- Validate a listentry record.
127 --
128 -- PARAMETERS
129 -- p_camp_rec: the listentry record to be validated
130 --
131 -- NOTES
132 -- 1. p_entry_rec should be the complete campaign record. There
133 -- should not be any FND_API.g_miss_char/num/date in it.
134 ----------------------------------------------------------------------
135 PROCEDURE validate_listentry(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
138 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
139
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143
144 p_entry_rec IN AMS_LISTENTRY_PVT.entry_rec_type
145 );
146
147
148
149 ---------------------------------------------------------------------
150 -- PROCEDURE
151 -- init_entry_rec
152 --
153 -- PURPOSE
154 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
155 ---------------------------------------------------------------------
156 PROCEDURE init_entry_rec(
157 x_entry_rec OUT NOCOPY AMS_LISTENTRY_PVT.entry_rec_type
158 );
159
160
161 END; -- Package spec