1 PACKAGE PVX_timeout_setup_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvtmos.pls 115.11 2002/12/11 11:13:03 anubhavk ship $ */
3
4 TYPE timeout_setup_rec_type IS RECORD
5 (
6 TIMEOUT_ID NUMBER,
7 LAST_UPDATE_DATE DATE,
8 LAST_UPDATED_BY NUMBER,
9 CREATION_DATE DATE,
10 CREATED_BY NUMBER,
11 LAST_UPDATE_LOGIN NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 TIMEOUT_PERIOD NUMBER,
14 TIMEOUT_TYPE VARCHAR2(30),
15 COUNTRY_CODE VARCHAR2(15)
16 );
17
18 ---------------------------------------------------------------------
19 -- PROCEDURE
20 -- Create_timeout_setup
21 --
22 -- PURPOSE
23 -- Create a new timeout in admin setup
24 --
25 -- PARAMETERS
26 -- p_timeout_setup_rec: the new record to be inserted
27 -- x_timeout_setup_id: return the timeout_id of the new record.
28 --
29 -- NOTES
30 -- 1. object_version_number will be set to 1.
31 -- 2. If timeout_id is not passed in, generate a unique one from
32 -- the sequence.
33 -- 3. Please don't pass in any FND_API.g_mess_char/num/date.
34 ---------------------------------------------------------------------
35 PROCEDURE Create_timeout_setup(
36 p_api_version IN NUMBER
37 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
38 ,p_commit IN VARCHAR2 := FND_API.g_false
39 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
40
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2
44
45 ,p_timeout_setup_rec IN timeout_setup_rec_type
46 ,x_timeout_setup_id OUT NOCOPY NUMBER
47 );
48
49
50 --------------------------------------------------------------------
51 -- PROCEDURE
52 -- Delete_timeout_setup
53 --
54 -- PURPOSE
55 -- Delete a timeout_setup.
56 --
57 -- PARAMETERS
58 -- p_timeout_id: the timeout_id indicating the row to be deleted
59 -- p_object_version: the object_version_number
60 --
61 -- NOTES
62 -- 1. Raise exception if the object_version_number doesn't match.
63 --------------------------------------------------------------------
64 PROCEDURE Delete_timeout_setup(
65 p_api_version IN NUMBER
66 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
67 ,p_commit IN VARCHAR2 := FND_API.g_false
68
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72
73 ,p_timeout_id IN NUMBER
74 ,p_object_version IN NUMBER
75
76 );
77
78
79 ---------------------------------------------------------------------
80 -- PROCEDURE
81 -- Update_timeout_setup
82 --
83 -- PURPOSE
84 -- Update a timeout_setup.
85 --
86 -- PARAMETERS
87 -- p_timeout_setup_rec: the record with new items.
88 --
89 -- NOTES
90 -- 1. Raise exception if the object_version_number doesn't match.
91 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
92 -- that column won't be updated.
93 ----------------------------------------------------------------------
94 PROCEDURE Update_timeout_setup(
95 p_api_version IN NUMBER
96 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
97 ,p_commit IN VARCHAR2 := FND_API.g_false
98 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
99
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 ,p_timeout_setup_rec IN timeout_setup_rec_type
104 );
105
106
107 ---------------------------------------------------------------------
108 -- PROCEDURE
109 -- Validate_timeout_setup
110 --
111 -- PURPOSE
112 -- Validate a timeout_setup record.
113 --
114 -- PARAMETERS
115 -- p_timeout_setup_rec: the record to be validated
116 --
117 -- NOTES
118 -- 1. p_timeout_setup_rec should be the complete record. There
119 -- should not be any FND_API.g_miss_char/num/date in it.
120 ----------------------------------------------------------------------
121 PROCEDURE Validate_timeout_setup(
122 p_api_version IN NUMBER
123 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
124 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
125
126 ,x_return_status OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 ,x_msg_data OUT NOCOPY VARCHAR2
129
130 ,p_timeout_setup_rec IN timeout_setup_rec_type
131 );
132
133 ---------------------------------------------------------------------
134 -- PROCEDURE
135 -- Check_timeout_items
136 --
137 -- PURPOSE
138 -- Perform the item level checking including unique keys,
139 -- required columns, foreign keys, domain constraints.
140 --
141 -- PARAMETERS
142 -- p_timeout_setup_rec: the record to be validated
143 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
144 ---------------------------------------------------------------------
145 PROCEDURE Check_timeout_items(
146 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
147 ,x_return_status OUT NOCOPY VARCHAR2
148 ,p_timeout_setup_rec IN timeout_setup_rec_type
149 );
150
151 ---------------------------------------------------------------------
152 -- PROCEDURE
153 -- Check_timeout_rec
154 --
155 -- PURPOSE
156 -- Check the record level business rules.
157 --
158 -- PARAMETERS
159 -- p_timeout_setup_rec: the record to be validated; may contain attributes
160 -- as FND_API.g_miss_char/num/date
161 -- p_complete_rec: the complete record after all "g_miss" items
162 -- have been replaced by current database values
163 ---------------------------------------------------------------------
164 PROCEDURE Check_timeout_rec(
165 p_timeout_setup_rec IN timeout_setup_rec_type
166 ,p_complete_rec IN timeout_setup_rec_type := NULL
167 ,p_mode IN VARCHAR2 := 'INSERT'
168 ,x_return_status OUT NOCOPY VARCHAR2
169 );
170
171 ---------------------------------------------------------------------
172 -- PROCEDURE
173 -- Init_timeout_rec
174 --
175 -- PURPOSE
176 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
177 ---------------------------------------------------------------------
178 PROCEDURE Init_timeout_rec(
179 x_timeout_setup_rec OUT NOCOPY timeout_setup_rec_type
180 );
181
182
183 ---------------------------------------------------------------------
184 -- PROCEDURE
185 -- Complete_timeout_rec
186 --
187 -- PURPOSE
188 -- For update, some attributes may be passed in as
189 -- FND_API.g_miss_char/num/date if the user doesn't want to
190 -- update those attributes. This procedure will replace the
191 -- "g_miss" attributes with current database values.
192 --
193 -- PARAMETERS
194 -- p_timeout_setup_rec: the record which may contain attributes as
195 -- FND_API.g_miss_char/num/date
196 -- x_complete_rec: the complete record after all "g_miss" items
197 -- have been replaced by current database values
198 ---------------------------------------------------------------------
199 PROCEDURE Complete_timeout_rec(
200 p_timeout_setup_rec IN timeout_setup_rec_type
201 ,x_complete_rec OUT NOCOPY timeout_setup_rec_type
202 );
203
204
205 END PVX_timeout_setup_PVT;