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_IAS_INS dependencies on IRC_IAS_SHD

Line 76: (p_rec in out nocopy irc_ias_shd.g_rec_type

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

Line 85: irc_ias_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_ias_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: irc_assignment_statuses
88: --
89: insert into irc_assignment_statuses

Line 110: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

106: ,p_rec.status_change_comments
107: ,p_rec.status_change_by
108: );
109: --
110: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: Exception
114: When hr_api.check_integrity_violated Then

Line 116: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
117: --
118: irc_ias_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then

Line 118: irc_ias_shd.constraint_error

114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
117: --
118: irc_ias_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

Line 122: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

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

Line 124: irc_ias_shd.constraint_error

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

Line 128: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

124: irc_ias_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: irc_ias_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then

Line 130: irc_ias_shd.constraint_error

126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: irc_ias_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

Line 134: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

130: irc_ias_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: Raise;
137: End insert_dml;
138: --

Line 177: (p_rec in out nocopy irc_ias_shd.g_rec_type

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_insert
177: (p_rec in out nocopy irc_ias_shd.g_rec_type
178: ) is
179: --
180: Cursor C_Sel1 is select irc_assignment_statuses_s.nextval from sys.dual;
181: --

Line 264: (p_rec in irc_ias_shd.g_rec_type

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

Line 310: ( p_rec in out nocopy irc_ias_shd.g_rec_type

306: -- ----------------------------------------------------------------------------
307: -- |---------------------------------< ins >----------------------------------|
308: -- ----------------------------------------------------------------------------
309: Procedure ins
310: ( p_rec in out nocopy irc_ias_shd.g_rec_type
311: ) is
312: --
313: l_proc varchar2(72) := g_package||'ins';
314: --

Line 356: l_rec irc_ias_shd.g_rec_type;

352: ,p_assignment_status_id out nocopy number
353: ,p_object_version_number out nocopy number
354: ) is
355: --
356: l_rec irc_ias_shd.g_rec_type;
357: l_proc varchar2(72) := g_package||'ins';
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);

Line 366: irc_ias_shd.convert_args

362: -- Call conversion function to turn arguments into the
363: -- p_rec structure.
364: --
365: l_rec :=
366: irc_ias_shd.convert_args
367: (null
368: ,p_assignment_id
369: ,p_status_change_reason
370: ,null