DBA Data[Home] [Help]

APPS.HR_ABM_INS dependencies on HR_ABM_SHD

Line 53: Procedure insert_dml(p_rec in out hr_abm_shd.g_rec_type) is

49: -- Internal Table Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out hr_abm_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: hr_abm_shd.g_api_dml := true; -- Set the api dml status

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: hr_abm_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_batch_message_lines
64: --
65: insert into hr_api_batch_message_lines

Line 86: hr_abm_shd.g_api_dml := false; -- Unset the api dml status

82: p_rec.extended_error_message,
83: p_rec.source_row_information
84: );
85: --
86: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then

Line 92: hr_abm_shd.g_api_dml := false; -- Unset the api dml status

88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
93: hr_abm_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated

Line 93: hr_abm_shd.constraint_error

89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
93: hr_abm_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: hr_abm_shd.g_api_dml := false; -- Unset the api dml status

Line 97: hr_abm_shd.g_api_dml := false; -- Unset the api dml status

93: hr_abm_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
98: hr_abm_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated

Line 98: hr_abm_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
98: hr_abm_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: hr_abm_shd.g_api_dml := false; -- Unset the api dml status

Line 102: hr_abm_shd.g_api_dml := false; -- Unset the api dml status

98: hr_abm_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
103: hr_abm_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: hr_abm_shd.g_api_dml := false; -- Unset the api dml status

Line 103: hr_abm_shd.constraint_error

99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
103: hr_abm_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;

Line 106: hr_abm_shd.g_api_dml := false; -- Unset the api dml status

102: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
103: hr_abm_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: End insert_dml;
109: --
110: -- ----------------------------------------------------------------------------

Line 147: Procedure pre_insert(p_rec in out hr_abm_shd.g_rec_type) is

143: -- Internal Table Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_insert(p_rec in out hr_abm_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_insert';
150: --
151: Cursor C_Sel1 is select hr_api_batch_message_lines_s.nextval from sys.dual;

Line 171: p_rec in out hr_abm_shd.g_rec_type,

167: -- |---------------------------------< ins >----------------------------------|
168: -- ----------------------------------------------------------------------------
169: Procedure ins
170: (
171: p_rec in out hr_abm_shd.g_rec_type,
172: p_validate in boolean default false
173: ) is
174: --
175: l_proc varchar2(72) := g_package||'ins';

Line 233: l_rec hr_abm_shd.g_rec_type;

229: p_source_row_information in varchar2 default null,
230: p_validate in boolean default false
231: ) is
232: --
233: l_rec hr_abm_shd.g_rec_type;
234: l_proc varchar2(72) := g_package||'ins';
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);

Line 243: hr_abm_shd.convert_args

239: -- Call conversion function to turn arguments into the
240: -- p_rec structure.
241: --
242: l_rec :=
243: hr_abm_shd.convert_args
244: (
245: null,
246: p_batch_run_number,
247: p_api_name,