APPS.IRC_VCE_INS dependencies on IRC_VCE_SHD

Line 60: (p_rec in out nocopy irc_vce_shd.g_rec_type

56: --
57: -- {End Of Comments}
58: -- ----------------------------------------------------------------------------
59: Procedure insert_dml
60: (p_rec in out nocopy irc_vce_shd.g_rec_type
61: ) is
62: --
63: l_proc varchar2(72) := g_package||'insert_dml';
64: --

Line 69: irc_vce_shd.g_api_dml := true; -- Set the api dml status

65: Begin
66: hr_utility.set_location('Entering:'||l_proc, 5);
67: p_rec.object_version_number := 1; -- Initialise the object version
68: --
69: irc_vce_shd.g_api_dml := true; -- Set the api dml status
70: --
71: -- Insert the row into: irc_variable_comp_elements
72: --
73: insert into irc_variable_comp_elements

Line 84: irc_vce_shd.g_api_dml := false; -- Unset the api dml status

80: ,p_rec.variable_comp_lookup
81: ,p_rec.object_version_number
82: );
83: --
84: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: Exception
88: When hr_api.check_integrity_violated Then

Line 90: irc_vce_shd.g_api_dml := false; -- Unset the api dml status

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

Line 92: irc_vce_shd.constraint_error

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

Line 96: irc_vce_shd.g_api_dml := false; -- Unset the api dml status

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

Line 98: irc_vce_shd.constraint_error

94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
97: --
98: irc_vce_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: irc_vce_shd.g_api_dml := false; -- Unset the api dml status

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

98: irc_vce_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: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
103: --
104: irc_vce_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then

Line 104: irc_vce_shd.constraint_error

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

Line 108: irc_vce_shd.g_api_dml := false; -- Unset the api dml status

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

Line 150: (p_rec in out nocopy irc_vce_shd.g_rec_type

146: --
147: -- {End Of Comments}
148: -- ----------------------------------------------------------------------------
149: Procedure pre_insert
150: (p_rec in out nocopy irc_vce_shd.g_rec_type
151: ) is
152: --
153: l_proc varchar2(72) := g_package||'pre_insert';
154: l_exists varchar2(1);

Line 212: ,p_rec in irc_vce_shd.g_rec_type

208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure post_insert
211: (p_effective_date in date
212: ,p_rec in irc_vce_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'post_insert';
216: --

Line 249: ,p_rec in out nocopy irc_vce_shd.g_rec_type

245: -- |---------------------------------< ins >----------------------------------|
246: -- ----------------------------------------------------------------------------
247: Procedure ins
248: (p_effective_date in date
249: ,p_rec in out nocopy irc_vce_shd.g_rec_type
250: ) is
251: --
252: l_proc varchar2(72) := g_package||'ins';
253: --

Line 298: l_rec irc_vce_shd.g_rec_type;

294: ,p_variable_comp_lookup in varchar2
295: ,p_object_version_number out nocopy number
296: ) is
297: --
298: l_rec irc_vce_shd.g_rec_type;
299: l_proc varchar2(72) := g_package||'ins';
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);

Line 308: irc_vce_shd.convert_args

304: -- Call conversion function to turn arguments into the
305: -- p_rec structure.
306: --
307: l_rec :=
308: irc_vce_shd.convert_args
309: (p_object_version_number => p_object_version_number
310: ,p_vacancy_id => p_vacancy_id
311: ,p_variable_comp_lookup => p_variable_comp_lookup
312: );