DBA Data[Home] [Help]

APPS.HR_TRS_INS dependencies on HR_TRS_SHD

Line 75: Procedure insert_dml(p_rec in out nocopy hr_trs_shd.g_rec_type) is

71: -- Internal Table Handler Use Only.
72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml(p_rec in out nocopy hr_trs_shd.g_rec_type) is
76: --
77: l_proc varchar2(72) := g_package||'insert_dml';
78: --
79: Begin

Line 83: hr_trs_shd.g_api_dml := true; -- Set the api dml status

79: Begin
80: hr_utility.set_location('Entering:'||l_proc, 5);
81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: hr_trs_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: hr_api_transaction_steps
86: --
87: insert into hr_api_transaction_steps

Line 196: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

192: p_rec.information30
193:
194: );
195: --
196: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: Exception
200: When hr_api.check_integrity_violated Then

Line 202: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: Exception
200: When hr_api.check_integrity_violated Then
201: -- A check constraint has been violated
202: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
203: hr_trs_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated

Line 203: hr_trs_shd.constraint_error

199: Exception
200: When hr_api.check_integrity_violated Then
201: -- A check constraint has been violated
202: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
203: hr_trs_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated
207: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

Line 207: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

203: hr_trs_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated
207: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
208: hr_trs_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated

Line 208: hr_trs_shd.constraint_error

204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated
207: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
208: hr_trs_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

Line 212: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

208: hr_trs_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
213: hr_trs_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others Then
216: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

Line 213: hr_trs_shd.constraint_error

209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
213: hr_trs_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others Then
216: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
217: Raise;

Line 216: hr_trs_shd.g_api_dml := false; -- Unset the api dml status

212: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
213: hr_trs_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others Then
216: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
217: Raise;
218: End insert_dml;
219: --
220: -- ----------------------------------------------------------------------------

Line 257: Procedure pre_insert(p_rec in out nocopy hr_trs_shd.g_rec_type) is

253: -- Internal Table Handler Use Only.
254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure pre_insert(p_rec in out nocopy hr_trs_shd.g_rec_type) is
258: --
259: l_proc varchar2(72) := g_package||'pre_insert';
260: l_exists varchar2(1);
261: --

Line 345: Procedure post_insert(p_rec in hr_trs_shd.g_rec_type) is

341: -- Internal Table Handler Use Only.
342: --
343: -- {End Of Comments}
344: -- ----------------------------------------------------------------------------
345: Procedure post_insert(p_rec in hr_trs_shd.g_rec_type) is
346: --
347: l_proc varchar2(72) := g_package||'post_insert';
348: --
349: Begin

Line 360: p_rec in out nocopy hr_trs_shd.g_rec_type,

356: -- |---------------------------------< ins >----------------------------------|
357: -- ----------------------------------------------------------------------------
358: Procedure ins
359: (
360: p_rec in out nocopy hr_trs_shd.g_rec_type,
361: p_validate in boolean default false
362: ) is
363: --
364: l_proc varchar2(72) := g_package||'ins';

Line 471: l_rec hr_trs_shd.g_rec_type;

467:
468:
469: ) is
470: --
471: l_rec hr_trs_shd.g_rec_type;
472: l_proc varchar2(72) := g_package||'ins';
473: --
474: Begin
475: hr_utility.set_location('Entering:'||l_proc, 5);

Line 481: hr_trs_shd.convert_args

477: -- Call conversion function to turn arguments into the
478: -- p_rec structure.
479: --
480: l_rec :=
481: hr_trs_shd.convert_args
482: (
483: null,
484: p_transaction_id,
485: p_api_name,