1 Package AMS_LISTHEADER_PUB AUTHID CURRENT_USER AS
2 /* $Header: amsplshs.pls 115.14 2002/11/22 08:54:18 jieli ship $ */
3 -- Start of Comments
4 ---------------------------------------------------------------------
5 -- PROCEDURE
6 -- Create_Listheader
7 --
8 -- PURPOSE
9 -- Creates a new List Hheader.
10 --
11 -- PARAMETERS
12 -- p_listheader_rec The New Record to be inserted.
13 -- x_listheader_id The Primary of The New Record.
14
15 -- End Of Comments
16 PROCEDURE Create_Listheader
17 ( p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19 p_commit IN VARCHAR2 := FND_API.G_FALSE,
20 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type,
25 x_listheader_id OUT NOCOPY NUMBER
26 );
27
28 -- Start of Comments
29 ------------------------------------------------------------------------------
30 -- PROCEDURE
31 -- Update_ListHeader
32 --
33 -- PURPOSE
34 -- Updates an existing List Header.
35 --
36 -- PARAMETERS
37 -- p_listheader_rec The Record to be Updated.
38
39 -- NOTES
40 -- 1. Raise exception if the object_version_number doesn't match.
41 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
42 -- that column won't be updated.
43
44 -- End Of Comments
45
46 PROCEDURE Update_ListHeader
47 ( p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type
55 );
56
57
58 --------------------------------------------------------------------
59 -- PROCEDURE
60 -- Delete_ListHeader
61 --
62 -- PURPOSE
63 -- Deletes a List Header.
64 --
65 -- PARAMETERS
66 -- p_listheader_id: the list header primary key.
67 -- p_object_version: the object_version_number
68 --
69 -- NOTES
70 -- 1. Raise exception if the object_version_number doesn't match.
71 --------------------------------------------------------------------
72
73 PROCEDURE Delete_ListHeader
74 ( p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_listheader_id IN NUMBER
82 );
83
84 -- Start Of Comments
85 -------------------------------------------------------------------
86 -- PROCEDURE
87 -- Lock_ListHeader
88 --
89 -- PURPOSE
90 -- Lock a List Header.
91 --
92 -- PARAMETERS
93 -- p_listheader: the list header primary key
94 -- p_object_version: the object_version_number
95 --
96 -- NOTES
97 -- 1. Raise exception if the object_version_number doesn't match.
98 --------------------------------------------------------------------
99 -- End Of Comments
100
101 PROCEDURE Lock_ListHeader
102 ( p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_listheader_id IN NUMBER,
109 p_object_version IN NUMBER
110 );
111
112
113 -- Start of Comments
114 ---------------------------------------------------------------------
115 -- PROCEDURE
116 -- Validate_ListHeader
117 --
118 -- PURPOSE
119 -- Validate a List Header Record.
120 --
121 -- PARAMETERS
122 -- p_listheader_rec: the list header record to be validated
123 --
124 -- NOTES
125 -- 1. p_listheader_rec_rec should be the complete list header record. There
126 -- should not be any FND_API.g_miss_char/num/date in it.
127 ----------------------------------------------------------------------
128 -- End Of Comments
129
130 PROCEDURE Validate_ListHeader
131 ( p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type
138 );
139
140 -- Start of Comments
141 ---------------------------------------------------------------------
142 -- PROCEDURE
143 -- Copy_List
144 --
145 -- PURPOSE
146 -- Take list header id of the list to copy from, list name, public
147 -- flag, purge flag, owner user id and description for the new list and generate
148 -- a new list header id.
149 -- last update date, last updated by, creation date and
150 -- created by are defaulted
151 -- copy the entries pertaining to a particular list in
152 -- AMS_LIST_SELECT_ACTIONS, AMS_LIST_QUERIES_ALL, AMS_LIST_ENTRIES into a new set
153 -- and associate them with a new list header.
154 --
155 -- PARAMETERS
156 -- p_listheader_rec The Record to be copied.
157 -- x_listheader_id The Primary of The New Record.
158 -- End Of Comments
159
160
161
162 PROCEDURE Copy_List
163 ( p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_source_listheader_id IN NUMBER,
171 p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type,
172 p_copy_select_actions IN VARCHAR2 := 'Y',
173 p_copy_list_queries IN VARCHAR2 := 'Y',
174 p_copy_list_entries IN VARCHAR2 := 'Y',
175
176 x_listheader_id OUT NOCOPY NUMBER
177 );
178
179
180
181
182 END AMS_LISTHEADER_PUB; -- Package spec