45: -- Access Status:
46: -- Internal Table Handler Use Only.
47: --
48: -- ----------------------------------------------------------------------------
49: Procedure delete_dml(p_rec in ssp_ern_shd.g_rec_type) is
50: --
51: l_proc varchar2(72) := g_package||'delete_dml';
52: --
53: Begin
52: --
53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 1);
55: --
56: ssp_ern_shd.g_api_dml := true; -- Set the api dml status
57: --
58: -- Delete the ssp_earnings_calculations row.
59: --
60: delete from ssp_earnings_calculations
59: --
60: delete from ssp_earnings_calculations
61: where earnings_calculations_id = p_rec.earnings_calculations_id;
62: --
63: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
64: --
65: hr_utility.set_location('Leaving :'||l_proc, 100);
66: --
67: Exception
66: --
67: Exception
68: When hr_api.child_integrity_violated then
69: -- Child integrity has been violated
70: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
71: ssp_ern_shd.constraint_error
72: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
73: When Others Then
74: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
67: Exception
68: When hr_api.child_integrity_violated then
69: -- Child integrity has been violated
70: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
71: ssp_ern_shd.constraint_error
72: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
73: When Others Then
74: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
75: Raise;
70: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
71: ssp_ern_shd.constraint_error
72: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
73: When Others Then
74: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status
75: Raise;
76: End delete_dml;
77: --
78: -- ----------------------------------------------------------------------------
104: -- Access Status:
105: -- Internal Table Handler Use Only.
106: --
107: -- ----------------------------------------------------------------------------
108: Procedure pre_delete(p_rec in ssp_ern_shd.g_rec_type) is
109: --
110: l_proc varchar2(72) := g_package||'pre_delete';
111: --
112: Begin
144: -- Access Status:
145: -- Internal table Handler Use Only.
146: --
147: -- ----------------------------------------------------------------------------
148: Procedure post_delete(p_rec in ssp_ern_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'post_delete';
151: --
152: Begin
159: -- |---------------------------------< del >----------------------------------|
160: -- ----------------------------------------------------------------------------
161: Procedure del
162: (
163: p_rec in ssp_ern_shd.g_rec_type,
164: p_validate in boolean default false
165: ) is
166: --
167: l_proc varchar2(72) := g_package||'del';
179: End If;
180: --
181: -- We must lock the row which we need to delete.
182: --
183: ssp_ern_shd.lck (p_rec.earnings_calculations_id,p_rec.object_version_number);
184: --
185: -- Call the supporting delete validate operation
186: --
187: ssp_ern_bus.delete_validate(p_rec);
222: p_object_version_number in number,
223: p_validate in boolean default false
224: ) is
225: --
226: l_rec ssp_ern_shd.g_rec_type;
227: l_proc varchar2(72) := g_package||'del';
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 1);