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: l_resDefId ota_resource_definitions.resource_definition_id%type;
55: --

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

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

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

79: where resource_definition_id = l_resDefId;
80:
81: Exception
82: When Others Then
83: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
84: Raise;
85: End;
86: --
87: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

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

83: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
84: Raise;
85: End;
86: --
87: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception

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

90: --
91: Exception
92: When hr_api.child_integrity_violated then
93: -- Child integrity has been violated
94: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
95: ota_tsr_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

Line 95: ota_tsr_shd.constraint_error

91: Exception
92: When hr_api.child_integrity_violated then
93: -- Child integrity has been violated
94: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
95: ota_tsr_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;

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

94: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
95: ota_tsr_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
99: Raise;
100: End delete_dml;
101: --
102: -- ----------------------------------------------------------------------------

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

130: -- Internal Development Use Only.
131: --
132: -- {End Of Comments}
133: -- ----------------------------------------------------------------------------
134: Procedure pre_delete(p_rec in ota_tsr_shd.g_rec_type) is
135: --
136: l_proc varchar2(72) := g_package||'pre_delete';
137: --
138: Begin

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

172: -- Internal Development Use Only.
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure post_delete(p_rec in ota_tsr_shd.g_rec_type) is
177: --
178: l_proc varchar2(72) := g_package||'post_delete';
179: --
180: Begin

Line 191: p_rec in ota_tsr_shd.g_rec_type,

187: -- |---------------------------------< del >----------------------------------|
188: -- ----------------------------------------------------------------------------
189: Procedure del
190: (
191: p_rec in ota_tsr_shd.g_rec_type,
192: p_validate in boolean
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'del';

Line 211: ota_tsr_shd.lck

207: End If;
208: --
209: -- We must lock the row which we need to delete.
210: --
211: ota_tsr_shd.lck
212: (
213: p_rec.supplied_resource_id,
214: p_rec.object_version_number
215: );

Line 259: l_rec ota_tsr_shd.g_rec_type;

255: p_object_version_number in number,
256: p_validate in boolean
257: ) is
258: --
259: l_rec ota_tsr_shd.g_rec_type;
260: l_proc varchar2(72) := g_package||'del';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);