DBA Data[Home] [Help]

APPS.IRC_JBI_UPD dependencies on IRC_JBI_SHD

Line 55: (p_rec in out nocopy irc_jbi_shd.g_rec_type

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

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

Line 77: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status

73: ,recruitment_activity_id = p_rec.recruitment_activity_id
74: ,object_version_number = p_rec.object_version_number
75: where job_basket_item_id = p_rec.job_basket_item_id;
76: --
77: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception

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

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

Line 86: irc_jbi_shd.constraint_error

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

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

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

Line 92: irc_jbi_shd.constraint_error

88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: irc_jbi_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_jbi_shd.g_api_dml := false; -- Unset the api dml status

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

92: irc_jbi_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_jbi_shd.g_api_dml := false; -- Unset the api dml status
97: --
98: irc_jbi_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then

Line 98: irc_jbi_shd.constraint_error

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

Line 101: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 139: (p_rec in irc_jbi_shd.g_rec_type

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

Line 184: ,p_rec in irc_jbi_shd.g_rec_type

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

Line 204: => irc_jbi_shd.g_old_rec.object_version_number

200: => p_rec.job_basket_item_id
201: ,p_object_version_number
202: => p_rec.object_version_number
203: ,p_object_version_number_o
204: => irc_jbi_shd.g_old_rec.object_version_number
205: );
206: --
207: exception
208: --

Line 264: (p_rec in out nocopy irc_jbi_shd.g_rec_type

260: --
261: -- {End Of Comments}
262: -- ----------------------------------------------------------------------------
263: Procedure convert_defs
264: (p_rec in out nocopy irc_jbi_shd.g_rec_type
265: ) is
266: --
267: l_proc varchar2(72) := g_package||'convert_defs';
268: Begin

Line 284: ,p_rec in out nocopy irc_jbi_shd.g_rec_type

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

Line 294: irc_jbi_shd.lck

290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- We must lock the row which we need to update.
293: --
294: irc_jbi_shd.lck
295: (p_rec.job_basket_item_id
296: ,p_rec.object_version_number
297: );
298: --

Line 338: l_rec irc_jbi_shd.g_rec_type;

334: ,p_job_basket_item_id in number
335: ,p_object_version_number in out nocopy number
336: ) is
337: --
338: l_rec irc_jbi_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);

Line 348: irc_jbi_shd.convert_args(p_job_basket_item_id

344: -- Call conversion function to turn arguments into the
345: -- l_rec structure.
346: --
347: l_rec :=
348: irc_jbi_shd.convert_args(p_job_basket_item_id
349: ,p_party_id
350: ,null
351: ,p_recruitment_activity_id
352: ,p_object_version_number