1 Package AMS_LISTACTION_PUB AUTHID CURRENT_USER AS
2 /* $Header: amsplsas.pls 115.11 2002/11/22 08:54:09 jieli ship $ */
3 ---------------------------------------------------------------------
4 -- PROCEDURE
5 -- Create_ListAction
6 --
7 -- PURPOSE
8 -- Create a new List Select Action.
9 --
10 -- PARAMETERS
11 -- p_action_rec: the new record to be inserted
12 -- x_action_id: return the campaign_id of the new campaign
13 --
14 -- NOTES
15 -- 1. object_version_number will be set to 1.
16 -- 2. If action_id is passed in, the uniqueness will be checked.
17 -- Raise exception in case of duplicates.
18 -- 3. If action_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_ListAction
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
30 := FND_API.G_VALID_LEVEL_FULL,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34
35 p_action_rec IN AMS_LISTACTION_PVT.action_rec_type,
36 x_action_id OUT NOCOPY NUMBER
37 ) ;
38
39 -- Start of Comments
40 ---------------------------------------------------------------------
41 -- PROCEDURE
42 -- Update_ListAction
43 --
44 -- PURPOSE
45 -- Update a List Action.
46 --
47 -- PARAMETERS
48 -- p_action_rec: the record with new items
49 --
50 -- NOTES
51 -- 1. Raise exception if the object_version_number doesn't match.
52 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
53 -- that column won't be updated.
54 ----------------------------------------------------------------------
55 -- End Of Comments
56 PROCEDURE Update_ListAction
57 ( p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE,
60 p_validation_level IN NUMBER
61 := FND_API.G_VALID_LEVEL_FULL,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65
66 p_action_rec IN AMS_LISTACTION_PVT.action_rec_type
67 );
68
69 -- Start of Comments
70 --------------------------------------------------------------------
71 -- PROCEDURE
72 -- Delete_ListAction
73 --
74 -- PURPOSE
75 -- Delete a List Action.
76 --
77 -- PARAMETERS
78 -- p_action_id: the action_id
79 -- p_object_version: the object_version_number
80 --
81 -- NOTES
82 -- 1. Raise exception if the object_version_number doesn't match.
83 --------------------------------------------------------------------
84 -- End Of Comments
85 PROCEDURE Delete_ListAction
86 ( p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_commit IN VARCHAR2 := FND_API.G_FALSE,
89 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94
95 p_action_id IN NUMBER
96 );
97
98 -- Start of Comments
99 -------------------------------------------------------------------
100 -- PROCEDURE
101 -- Lock_ListAction
102 --
103 -- PURPOSE
104 -- Lock a List Action.
105 --
106 -- PARAMETERS
107 -- p_action_id: the action_id
108 -- p_object_version: the object_version_number
109 --
110 -- NOTES
111 -- 1. Raise exception if the object_version_number doesn't match.
112 --------------------------------------------------------------------
113 -- End Of Comments
114 PROCEDURE Lock_ListAction
115 ( p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122
123 p_action_id IN NUMBER,
124 p_object_version IN NUMBER
125 );
126
127
128 -- Start of Comments
129 ---------------------------------------------------------------------
130 -- PROCEDURE
131 -- Validate_ListAction
132 --
133 -- PURPOSE
134 -- Validate a List Action.
135 --
136 -- PARAMETERS
137 -- p_action_rec: the list action record to be validated
138 --
139 -- NOTES
140 -- 1. p_action_rec should be the complete list action record. There
141 -- should not be any FND_API.g_miss_char/num/date in it.
142 ----------------------------------------------------------------------
143 -- End Of Comments
144 PROCEDURE Validate_ListAction
145 ( p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147 p_validation_level IN NUMBER
148 := FND_API.G_VALID_LEVEL_FULL,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152
153 p_action_rec IN AMS_LISTACTION_PVT.action_rec_type
154 );
155
156
157 END AMS_LISTACTION_PUB; -- Package spec