eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_VCE_UPD dependencies on IRC_VCE_SHD

Line 55: (p_rec in out nocopy irc_vce_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy irc_vce_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

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

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: irc_vce_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the irc_variable_comp_elements Row
69: --
70: update irc_variable_comp_elements

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

74: ,object_version_number = p_rec.object_version_number
75: where vacancy_id = p_rec.vacancy_id
76: and variable_comp_lookup = p_rec.variable_comp_lookup;
77: --
78: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception

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

81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
86: --
87: irc_vce_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then

Line 87: irc_vce_shd.constraint_error

83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
86: --
87: irc_vce_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: irc_vce_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 93: irc_vce_shd.constraint_error

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

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

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

Line 99: irc_vce_shd.constraint_error

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

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

99: irc_vce_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
104: Raise;
105: End update_dml;
106: --
107: -- ----------------------------------------------------------------------------

Line 140: (p_rec in irc_vce_shd.g_rec_type

136: --
137: -- {End Of Comments}
138: -- ----------------------------------------------------------------------------
139: Procedure pre_update
140: (p_rec in irc_vce_shd.g_rec_type
141: ) is
142: --
143: l_proc varchar2(72) := g_package||'pre_update';
144: --

Line 185: ,p_rec in irc_vce_shd.g_rec_type

181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure post_update
184: (p_effective_date in date
185: ,p_rec in irc_vce_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --

Line 203: => irc_vce_shd.g_old_rec.object_version_number

199: => p_rec.variable_comp_lookup
200: ,p_object_version_number
201: => p_rec.object_version_number
202: ,p_object_version_number_o
203: => irc_vce_shd.g_old_rec.object_version_number
204: );
205: --
206: exception
207: --

Line 263: (p_rec in out nocopy irc_vce_shd.g_rec_type

259: --
260: -- {End Of Comments}
261: -- ----------------------------------------------------------------------------
262: Procedure convert_defs
263: (p_rec in out nocopy irc_vce_shd.g_rec_type
264: ) is
265: --
266: Begin
267: --

Line 282: ,p_rec in out nocopy irc_vce_shd.g_rec_type

278: -- |---------------------------------< upd >----------------------------------|
279: -- ----------------------------------------------------------------------------
280: Procedure upd
281: (p_effective_date in date
282: ,p_rec in out nocopy irc_vce_shd.g_rec_type
283: ) is
284: --
285: l_proc varchar2(72) := g_package||'upd';
286: --

Line 292: irc_vce_shd.lck

288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- We must lock the row which we need to update.
291: --
292: irc_vce_shd.lck
293: (p_rec.vacancy_id
294: ,p_rec.variable_comp_lookup
295: ,p_rec.object_version_number
296: );

Line 341: l_rec irc_vce_shd.g_rec_type;

337: ,p_variable_comp_lookup in varchar2
338: ,p_object_version_number in out nocopy number
339: ) is
340: --
341: l_rec irc_vce_shd.g_rec_type;
342: l_proc varchar2(72) := g_package||'upd';
343: --
344: Begin
345: hr_utility.set_location('Entering:'||l_proc, 5);

Line 351: irc_vce_shd.convert_args

347: -- Call conversion function to turn arguments into the
348: -- l_rec structure.
349: --
350: l_rec :=
351: irc_vce_shd.convert_args
352: (p_vacancy_id
353: ,p_variable_comp_lookup
354: ,p_object_version_number
355: );