APPS.OTA_TSR_DEL dependencies on OTA_TSR_SHD

Line 51: Procedure delete_dml(p_rec in ota_tsr_shd.g_rec_type) is

47: -- Internal Development Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ota_tsr_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ota_tsr_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ota_tsr_shd.g_api_dml := true; -- Set the api dml status
59:
60: -- Bug. no. 3242410
61: ota_srt_del.del_tl (p_supplied_resource_id => p_rec.supplied_resource_id);
62:

Line 69: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

65:
66: delete from ota_suppliable_resources
67: where supplied_resource_id = p_rec.supplied_resource_id;
68: --
69: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 10);
72: --
73: Exception

Line 76: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

72: --
73: Exception
74: When hr_api.child_integrity_violated then
75: -- Child integrity has been violated
76: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
77: ota_tsr_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When Others Then
80: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

Line 77: ota_tsr_shd.constraint_error

73: Exception
74: When hr_api.child_integrity_violated then
75: -- Child integrity has been violated
76: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
77: ota_tsr_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When Others Then
80: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
81: Raise;

Line 80: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

76: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
77: ota_tsr_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When Others Then
80: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
81: Raise;
82: End delete_dml;
83: --
84: -- ----------------------------------------------------------------------------

Line 116: Procedure pre_delete(p_rec in ota_tsr_shd.g_rec_type) is

112: -- Internal Development Use Only.
113: --
114: -- {End Of Comments}
115: -- ----------------------------------------------------------------------------
116: Procedure pre_delete(p_rec in ota_tsr_shd.g_rec_type) is
117: --
118: l_proc varchar2(72) := g_package||'pre_delete';
119: --
120: Begin

Line 158: Procedure post_delete(p_rec in ota_tsr_shd.g_rec_type) is

154: -- Internal Development Use Only.
155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure post_delete(p_rec in ota_tsr_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'post_delete';
161: --
162: Begin

Line 173: p_rec in ota_tsr_shd.g_rec_type,

169: -- |---------------------------------< del >----------------------------------|
170: -- ----------------------------------------------------------------------------
171: Procedure del
172: (
173: p_rec in ota_tsr_shd.g_rec_type,
174: p_validate in boolean
175: ) is
176: --
177: l_proc varchar2(72) := g_package||'del';

Line 193: ota_tsr_shd.lck

189: End If;
190: --
191: -- We must lock the row which we need to delete.
192: --
193: ota_tsr_shd.lck
194: (
195: p_rec.supplied_resource_id,
196: p_rec.object_version_number
197: );

Line 241: l_rec ota_tsr_shd.g_rec_type;

237: p_object_version_number in number,
238: p_validate in boolean
239: ) is
240: --
241: l_rec ota_tsr_shd.g_rec_type;
242: l_proc varchar2(72) := g_package||'del';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);