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