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_JBI_INS dependencies on IRC_JBI_SHD

Line 76: (p_rec in out nocopy irc_jbi_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy irc_jbi_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 85: irc_jbi_shd.g_api_dml := true; -- Set the api dml status

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: irc_jbi_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: irc_job_basket_items
88: --
89: insert into irc_job_basket_items(job_basket_item_id

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

99: ,p_rec.recruitment_activity_id
100: ,p_rec.object_version_number
101: );
102: --
103: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: Exception
107: When hr_api.check_integrity_violated Then

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

105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
110: --
111: irc_jbi_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then

Line 111: irc_jbi_shd.constraint_error

107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
110: --
111: irc_jbi_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status

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

111: irc_jbi_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
116: --
117: irc_jbi_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then

Line 117: irc_jbi_shd.constraint_error

113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
116: --
117: irc_jbi_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status

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

117: irc_jbi_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
122: --
123: irc_jbi_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then

Line 123: irc_jbi_shd.constraint_error

119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
122: --
123: irc_jbi_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
127: --

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

122: --
123: irc_jbi_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
127: --
128: Raise;
129: End insert_dml;
130: --

Line 169: (p_rec in out nocopy irc_jbi_shd.g_rec_type

165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: Procedure pre_insert
169: (p_rec in out nocopy irc_jbi_shd.g_rec_type
170: ) is
171: --
172: cursor c1 is select irc_job_basket_items_s.nextval from sys.dual;
173: cursor c2 is

Line 244: ,p_rec in irc_jbi_shd.g_rec_type

240: -- {End Of Comments}
241: -- ----------------------------------------------------------------------------
242: Procedure post_insert
243: (p_effective_date in date
244: ,p_rec in irc_jbi_shd.g_rec_type
245: ) is
246: --
247: l_proc varchar2(72) := g_package||'post_insert';
248: --

Line 283: ,p_rec in out nocopy irc_jbi_shd.g_rec_type

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

Line 327: l_rec irc_jbi_shd.g_rec_type;

323: ,p_job_basket_item_id out nocopy number
324: ,p_object_version_number out nocopy number
325: ) is
326: --
327: l_rec irc_jbi_shd.g_rec_type;
328: l_proc varchar2(72) := g_package||'ins';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);

Line 337: irc_jbi_shd.convert_args

333: -- Call conversion function to turn arguments into the
334: -- p_rec structure.
335: --
336: l_rec :=
337: irc_jbi_shd.convert_args
338: (null
339: ,null
340: ,p_person_id
341: ,p_recruitment_activity_id