DBA Data[Home] [Help]

APPS.SSP_ERN_DEL dependencies on SSP_ERN_SHD

Line 49: Procedure delete_dml(p_rec in ssp_ern_shd.g_rec_type) is

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

Line 56: ssp_ern_shd.g_api_dml := true; -- Set the api dml status

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

Line 63: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

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

Line 70: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

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

Line 71: ssp_ern_shd.constraint_error

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;

Line 74: ssp_ern_shd.g_api_dml := false; -- Unset the api dml status

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: -- ----------------------------------------------------------------------------

Line 108: Procedure pre_delete(p_rec in ssp_ern_shd.g_rec_type) is

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

Line 148: Procedure post_delete(p_rec in ssp_ern_shd.g_rec_type) is

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

Line 163: p_rec in ssp_ern_shd.g_rec_type,

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';

Line 183: ssp_ern_shd.lck (p_rec.earnings_calculations_id,p_rec.object_version_number);

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);

Line 226: l_rec ssp_ern_shd.g_rec_type;

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);