[Home] [Help]
53: --
54: l_proc varchar2(72) := g_package||'insert_dml';
55: --
56: Begin
57: hr_utility.set_location('Entering:'||l_proc, 1);
58: p_rec.object_version_number := 1; -- Initialise the object version
59: --
60: ssp_ern_shd.g_api_dml := true; -- Set the api dml status
61: --
81: );
82: --
83: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 100);
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
145: --
146: Cursor C_Sel1 is select ssp_earnings_calculations_s.nextval from sys.dual;
147: --
148: Begin
149: hr_utility.set_location('Entering:'||l_proc, 1);
150: --
151: -- Select the next sequence number
152: --
153: Open C_Sel1;
153: Open C_Sel1;
154: Fetch C_Sel1 Into p_rec.earnings_calculations_id;
155: Close C_Sel1;
156: --
157: hr_utility.set_location('Leaving :'||l_proc, 100);
158: End pre_insert;
159: --
160: -- ----------------------------------------------------------------------------
161: -- |-----------------------------< post_insert >------------------------------|
191: --
192: l_proc varchar2(72) := g_package||'post_insert';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 1);
196: --
197: hr_utility.set_location('Leaving :'||l_proc, 100);
198: End post_insert;
199: --
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 1);
196: --
197: hr_utility.set_location('Leaving :'||l_proc, 100);
198: End post_insert;
199: --
200: -- ----------------------------------------------------------------------------
201: -- |---------------------------------< ins >----------------------------------|
208: --
209: l_proc varchar2(72) := g_package||'ins';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 1);
213: --
214: -- Determine if the business process is to be validated.
215: --
216: If p_validate
251: If p_validate then
252: Raise HR_Api.Validate_Enabled;
253: End If;
254: --
255: hr_utility.set_location('Leaving :'||l_proc, 100);
256: Exception
257: When HR_Api.Validate_Enabled Then
258: --
259: -- As the Validate_Enabled exception has been raised
282: l_rec ssp_ern_shd.g_rec_type;
283: l_proc varchar2(72) := g_package||'ins (old)';
284: --
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 1);
287: --
288: g_payment_period_func_status := 'OLD';
289: --
290: -- Call conversion function to turn arguments into the p_rec structure.
309: p_earnings_calculations_id := l_rec.earnings_calculations_id;
310: p_object_version_number := l_rec.object_version_number;
311: p_average_earnings_amount := l_rec.average_earnings_amount;
312: --
313: hr_utility.set_location('Leaving :'||l_proc, 100);
314: End ins;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |---------------------------------< ins >----------------------------------|
336: l_rec ssp_ern_shd.g_rec_type;
337: l_proc varchar2(72) := g_package||'ins';
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 1);
341: --
342: g_payment_period_func_status := 'NEW';
343: --
344: -- Call conversion function to turn arguments into the p_rec structure.
366: p_user_entered := l_rec.user_entered;
367: p_absence_category := l_rec.absence_category; --DFoster 1304683
368: p_payment_periods := l_rec.payment_periods;
369: --
370: hr_utility.set_location('Leaving :'||l_proc, 100);
371: End ins;
372: --
373: end ssp_ern_ins;