DBA Data[Home] [Help]

APPS.IRC_IDO_INS dependencies on IRC_IDO_SHD

Line 76: (p_rec in out nocopy irc_ido_shd.g_rec_type

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

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

Line 123: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

119: ,p_rec.object_version_number
120: ,p_rec.end_date
121: );
122: --
123: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
124: --
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: Exception

Line 130: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
131: --
132: irc_ido_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then

Line 132: irc_ido_shd.constraint_error

128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
131: --
132: irc_ido_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

Line 136: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

132: irc_ido_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
137: --
138: irc_ido_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then

Line 138: irc_ido_shd.constraint_error

134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
137: --
138: irc_ido_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

Line 142: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

138: irc_ido_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
143: --
144: irc_ido_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then

Line 144: irc_ido_shd.constraint_error

140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
143: --
144: irc_ido_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: --
148: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

Line 148: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

144: irc_ido_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: --
148: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
149: Raise;
150: End insert_dml;
151: --
152: -- ----------------------------------------------------------------------------

Line 190: (p_rec in out nocopy irc_ido_shd.g_rec_type

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure pre_insert
190: (p_rec in out nocopy irc_ido_shd.g_rec_type
191: ) is
192: --
193: Cursor C_Sel1 is select irc_documents_s.nextval from sys.dual;
194: --

Line 287: ,p_rec in irc_ido_shd.g_rec_type

283: -- {End Of Comments}
284: -- ----------------------------------------------------------------------------
285: Procedure post_insert
286: (p_effective_date in date
287: ,p_rec in irc_ido_shd.g_rec_type
288: ) is
289: --
290: l_proc varchar2(72) := g_package||'post_insert';
291: --

Line 339: ,p_rec in out nocopy irc_ido_shd.g_rec_type

335: -- |---------------------------------< ins >----------------------------------|
336: -- ----------------------------------------------------------------------------
337: Procedure ins
338: (p_effective_date in date
339: ,p_rec in out nocopy irc_ido_shd.g_rec_type
340: ) is
341: --
342: l_proc varchar2(72) := g_package||'ins';
343: --

Line 390: l_rec irc_ido_shd.g_rec_type;

386: ,p_document_id out nocopy number
387: ,p_object_version_number out nocopy number
388: ) is
389: --
390: l_rec irc_ido_shd.g_rec_type;
391: l_proc varchar2(72) := g_package||'ins';
392: --
393: Begin
394: hr_utility.set_location('Entering:'||l_proc, 5);

Line 400: irc_ido_shd.convert_args

396: -- Call conversion function to turn arguments into the
397: -- p_rec structure.
398: --
399: l_rec :=
400: irc_ido_shd.convert_args
401: (null
402: ,null
403: ,p_person_id
404: ,p_assignment_id