54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: hr_trv_shd.g_api_dml := true; -- Set the api dml status
62: --
88: );
89: --
90: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: hr_trv_shd.g_api_dml := false; -- Unset the api dml status
154: --
155: Cursor C_Sel1 is select hr_api_transaction_values_s.nextval from sys.dual;
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: --
161: -- Select the next sequence number
162: --
163: Open C_Sel1;
164: Fetch C_Sel1 Into p_rec.transaction_value_id;
165: Close C_Sel1;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End pre_insert;
169: --
170: -- ----------------------------------------------------------------------------
171: -- |-----------------------------< post_insert >------------------------------|
203: --
204: l_proc varchar2(72) := g_package||'post_insert';
205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: End post_insert;
211: --
205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: End post_insert;
211: --
212: -- ----------------------------------------------------------------------------
213: -- |---------------------------------< ins >----------------------------------|
220: --
221: l_proc varchar2(72) := g_package||'ins';
222: --
223: Begin
224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: -- Determine if the business process is to be validated.
227: --
228: If p_validate then
253: If p_validate then
254: Raise HR_Api.Validate_Enabled;
255: End If;
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: Exception
259: When HR_Api.Validate_Enabled Then
260: --
261: -- As the Validate_Enabled exception has been raised
285: l_rec hr_trv_shd.g_rec_type;
286: l_proc varchar2(72) := g_package||'ins';
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Call conversion function to turn arguments into the
292: -- p_rec structure.
293: --
316: --
317: p_transaction_value_id := l_rec.transaction_value_id;
318: --
319: --
320: hr_utility.set_location(' Leaving:'||l_proc, 10);
321: End ins;
322: --
323: end hr_trv_ins;