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_RAV_UPD dependencies on IRC_RAV_SHD

Line 55: (p_rec in out nocopy irc_rav_shd.g_rec_type

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

Line 66: irc_rav_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_rav_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the irc_vac_rec_area_values Row
69: --
70: update irc_vac_rec_area_values

Line 79: irc_rav_shd.g_api_dml := false; -- Unset the api dml status

75: ,hierarchy_name = p_rec.hierarchy_name
76: ,object_version_number = p_rec.object_version_number
77: where vac_rec_area_id = p_rec.vac_rec_area_id;
78: --
79: irc_rav_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception

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

82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: irc_rav_shd.g_api_dml := false; -- Unset the api dml status
87: irc_rav_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

Line 87: irc_rav_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: irc_rav_shd.g_api_dml := false; -- Unset the api dml status
87: irc_rav_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_rav_shd.g_api_dml := false; -- Unset the api dml status

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

87: irc_rav_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_rav_shd.g_api_dml := false; -- Unset the api dml status
92: irc_rav_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated

Line 92: irc_rav_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_rav_shd.g_api_dml := false; -- Unset the api dml status
92: irc_rav_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: irc_rav_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 97: irc_rav_shd.constraint_error

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

Line 100: irc_rav_shd.g_api_dml := false; -- Unset the api dml status

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

Line 137: (p_rec in irc_rav_shd.g_rec_type

133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update
137: (p_rec in irc_rav_shd.g_rec_type
138: ) is
139: --
140: l_proc varchar2(72) := g_package||'pre_update';
141: --

Line 182: ,p_rec in irc_rav_shd.g_rec_type

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

Line 204: => irc_rav_shd.g_old_rec.vacancy_id

200: => p_rec.hierarchy_name
201: ,p_object_version_number
202: => p_rec.object_version_number
203: ,p_vacancy_id_o
204: => irc_rav_shd.g_old_rec.vacancy_id
205: ,p_hierarchy_version_id_o
206: => irc_rav_shd.g_old_rec.hierarchy_version_id
207: ,p_hierarchy_name_o
208: => irc_rav_shd.g_old_rec.hierarchy_name

Line 206: => irc_rav_shd.g_old_rec.hierarchy_version_id

202: => p_rec.object_version_number
203: ,p_vacancy_id_o
204: => irc_rav_shd.g_old_rec.vacancy_id
205: ,p_hierarchy_version_id_o
206: => irc_rav_shd.g_old_rec.hierarchy_version_id
207: ,p_hierarchy_name_o
208: => irc_rav_shd.g_old_rec.hierarchy_name
209: ,p_object_version_number_o
210: => irc_rav_shd.g_old_rec.object_version_number

Line 208: => irc_rav_shd.g_old_rec.hierarchy_name

204: => irc_rav_shd.g_old_rec.vacancy_id
205: ,p_hierarchy_version_id_o
206: => irc_rav_shd.g_old_rec.hierarchy_version_id
207: ,p_hierarchy_name_o
208: => irc_rav_shd.g_old_rec.hierarchy_name
209: ,p_object_version_number_o
210: => irc_rav_shd.g_old_rec.object_version_number
211: );
212: --

Line 210: => irc_rav_shd.g_old_rec.object_version_number

206: => irc_rav_shd.g_old_rec.hierarchy_version_id
207: ,p_hierarchy_name_o
208: => irc_rav_shd.g_old_rec.hierarchy_name
209: ,p_object_version_number_o
210: => irc_rav_shd.g_old_rec.object_version_number
211: );
212: --
213: exception
214: --

Line 270: (p_rec in out nocopy irc_rav_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs
270: (p_rec in out nocopy irc_rav_shd.g_rec_type
271: ) is
272: --
273: Begin
274: --

Line 282: irc_rav_shd.g_old_rec.vacancy_id;

278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.vacancy_id = hr_api.g_number) then
281: p_rec.vacancy_id :=
282: irc_rav_shd.g_old_rec.vacancy_id;
283: End If;
284: If (p_rec.hierarchy_version_id = hr_api.g_number) then
285: p_rec.hierarchy_version_id :=
286: irc_rav_shd.g_old_rec.hierarchy_version_id;

Line 286: irc_rav_shd.g_old_rec.hierarchy_version_id;

282: irc_rav_shd.g_old_rec.vacancy_id;
283: End If;
284: If (p_rec.hierarchy_version_id = hr_api.g_number) then
285: p_rec.hierarchy_version_id :=
286: irc_rav_shd.g_old_rec.hierarchy_version_id;
287: End If;
288: If (p_rec.hierarchy_name = hr_api.g_varchar2) then
289: p_rec.hierarchy_name :=
290: irc_rav_shd.g_old_rec.hierarchy_name;

Line 290: irc_rav_shd.g_old_rec.hierarchy_name;

286: irc_rav_shd.g_old_rec.hierarchy_version_id;
287: End If;
288: If (p_rec.hierarchy_name = hr_api.g_varchar2) then
289: p_rec.hierarchy_name :=
290: irc_rav_shd.g_old_rec.hierarchy_name;
291: End If;
292: --
293: End convert_defs;
294: --

Line 300: ,p_rec in out nocopy irc_rav_shd.g_rec_type

296: -- |---------------------------------< upd >----------------------------------|
297: -- ----------------------------------------------------------------------------
298: Procedure upd
299: (p_effective_date in date
300: ,p_rec in out nocopy irc_rav_shd.g_rec_type
301: ) is
302: --
303: l_proc varchar2(72) := g_package||'upd';
304: --

Line 310: irc_rav_shd.lck

306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: -- We must lock the row which we need to update.
309: --
310: irc_rav_shd.lck
311: (p_rec.vac_rec_area_id
312: ,p_rec.object_version_number
313: );
314: --

Line 361: l_rec irc_rav_shd.g_rec_type;

357: ,p_hierarchy_version_id in number default hr_api.g_number
358: ,p_hierarchy_name in varchar2 default hr_api.g_varchar2
359: ) is
360: --
361: l_rec irc_rav_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'upd';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);

Line 371: irc_rav_shd.convert_args

367: -- Call conversion function to turn arguments into the
368: -- l_rec structure.
369: --
370: l_rec :=
371: irc_rav_shd.convert_args
372: (p_vac_rec_area_id
373: ,p_vacancy_id
374: ,p_hierarchy_version_id
375: ,p_hierarchy_name