1 PACKAGE AMS_EventHeader_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspevhs.pls 115.3 2002/11/16 00:42:55 dbiswas ship $ */
3
4
5 ---------------------------------------------------------------------
6 -- PROCEDURE
7 -- create_EventHeader
8 --
9 -- PURPOSE
10 -- Create a new EventHeader.
11 --
12 -- PARAMETERS
13 -- p_evh_rec: the new record to be inserted
14 -- x_evh_id: return the EventHeader_id of the new EventHeader
15 --
16 -- NOTES
17 -- 1. object_version_number will be set to 1.
18 -- 2. If EventHeader_id is passed in, the uniqueness will be checked.
19 -- Raise exception in case of duplicates.
20 -- 3. If EventHeader_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_EventHeader(
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_evh_rec IN AMS_EventHeader_PVT.evh_rec_type,
38 x_evh_id OUT NOCOPY NUMBER
39 );
40
41
42 --------------------------------------------------------------------
43 -- PROCEDURE
44 -- delete_EventHeader
45 --
46 -- PURPOSE
47 -- Delete a EventHeader.
48 --
49 -- PARAMETERS
50 -- p_evh_id: the EventHeader_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 EventHeader to be inactive, instead of remove it
56 -- from database.
57 --------------------------------------------------------------------
58 PROCEDURE delete_EventHeader(
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_evh_id IN NUMBER,
68 p_object_version IN NUMBER
69 );
70
71
72 -------------------------------------------------------------------
73 -- PROCEDURE
74 -- lock_EventHeader
75 --
76 -- PURPOSE
77 -- Lock a EventHeader.
78 --
79 -- PARAMETERS
80 -- p_evh_id: the EventHeader_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_EventHeader(
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_evh_id IN NUMBER,
95 p_object_version IN NUMBER
96 );
97
98
99 ---------------------------------------------------------------------
100 -- PROCEDURE
101 -- update_EventHeader
102 --
103 -- PURPOSE
104 -- Update a EventHeader.
105 --
106 -- PARAMETERS
107 -- p_evh_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_EventHeader(
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_evh_rec IN AMS_EventHeader_PVT.evh_rec_type
125 );
126
127
128 ---------------------------------------------------------------------
129 -- PROCEDURE
130 -- validate_EventHeader
131 --
132 -- PURPOSE
133 -- Validate a EventHeader record.
134 --
135 -- PARAMETERS
136 -- p_evh_rec: the EventHeader record to be validated
137 --
138 -- NOTES
139 -- 1. p_evh_rec should be the complete EventHeader record. There
140 -- should not be any FND_API.g_miss_char/num/date in it.
141 ----------------------------------------------------------------------
142 PROCEDURE validate_EventHeader(
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_evh_rec IN AMS_EventHeader_PVT.evh_rec_type
152 );
153
154
155 END AMS_EventHeader_PUB;