APPS.IRC_IDO_DEL dependencies on IRC_IDO_SHD

Line 52: (p_rec in irc_ido_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in irc_ido_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: irc_ido_shd.g_api_dml := true; -- Set the dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: irc_ido_shd.g_api_dml := true; -- Set the dml status
61: --
62: --
63: -- Delete the irc_documents row.
64: --

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

64: --
65: delete from irc_documents
66: where document_id = p_rec.document_id;
67: --
68: irc_ido_shd.g_api_dml := false; -- Unset the dml status
69: --
70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 10);
72: --

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

72: --
73: Exception
74: When hr_api.child_integrity_violated then
75: -- Child integrity has been violatend
76: irc_ido_shd.g_api_dml := false; -- Unset the dml status
77: --
78: irc_ido_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When Others Then

Line 78: irc_ido_shd.constraint_error

74: When hr_api.child_integrity_violated then
75: -- Child integrity has been violatend
76: irc_ido_shd.g_api_dml := false; -- Unset the dml status
77: --
78: irc_ido_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When Others Then
81: irc_ido_shd.g_api_dml := false; -- Unset the dml status
82: --

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

77: --
78: irc_ido_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When Others Then
81: irc_ido_shd.g_api_dml := false; -- Unset the dml status
82: --
83: Raise;
84: End delete_dml;
85: --

Line 118: Procedure pre_delete(p_rec in irc_ido_shd.g_rec_type) is

114: -- Internal Row Handler Use Only.
115: --
116: -- {End Of Comments}
117: -- ----------------------------------------------------------------------------
118: Procedure pre_delete(p_rec in irc_ido_shd.g_rec_type) is
119: --
120: l_proc varchar2(72) := g_package||'pre_delete';
121: --
122: Begin

Line 160: Procedure post_delete(p_rec in irc_ido_shd.g_rec_type) is

156: -- Internal Row Handler Use Only.
157: --
158: -- {End Of Comments}
159: -- -----------------------------------------------------------------------------
160: Procedure post_delete(p_rec in irc_ido_shd.g_rec_type) is
161: --
162: l_proc varchar2(72) := g_package||'post_delete';
163: --
164: Begin

Line 172: => irc_ido_shd.g_old_rec.party_id

168: irc_ido_rkd.after_delete
169: (p_document_id
170: => p_rec.document_id
171: ,p_party_id_o
172: => irc_ido_shd.g_old_rec.party_id
173: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id
174: ,p_assignment_id_o
175: => irc_ido_shd.g_old_rec.assignment_id
176: ,p_file_name_o

Line 173: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id

169: (p_document_id
170: => p_rec.document_id
171: ,p_party_id_o
172: => irc_ido_shd.g_old_rec.party_id
173: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id
174: ,p_assignment_id_o
175: => irc_ido_shd.g_old_rec.assignment_id
176: ,p_file_name_o
177: => irc_ido_shd.g_old_rec.file_name

Line 175: => irc_ido_shd.g_old_rec.assignment_id

171: ,p_party_id_o
172: => irc_ido_shd.g_old_rec.party_id
173: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id
174: ,p_assignment_id_o
175: => irc_ido_shd.g_old_rec.assignment_id
176: ,p_file_name_o
177: => irc_ido_shd.g_old_rec.file_name
178: ,p_file_format_o
179: => irc_ido_shd.g_old_rec.file_format

Line 177: => irc_ido_shd.g_old_rec.file_name

173: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id
174: ,p_assignment_id_o
175: => irc_ido_shd.g_old_rec.assignment_id
176: ,p_file_name_o
177: => irc_ido_shd.g_old_rec.file_name
178: ,p_file_format_o
179: => irc_ido_shd.g_old_rec.file_format
180: ,p_mime_type_o
181: => irc_ido_shd.g_old_rec.mime_type

Line 179: => irc_ido_shd.g_old_rec.file_format

175: => irc_ido_shd.g_old_rec.assignment_id
176: ,p_file_name_o
177: => irc_ido_shd.g_old_rec.file_name
178: ,p_file_format_o
179: => irc_ido_shd.g_old_rec.file_format
180: ,p_mime_type_o
181: => irc_ido_shd.g_old_rec.mime_type
182: ,p_description_o
183: => irc_ido_shd.g_old_rec.description

Line 181: => irc_ido_shd.g_old_rec.mime_type

177: => irc_ido_shd.g_old_rec.file_name
178: ,p_file_format_o
179: => irc_ido_shd.g_old_rec.file_format
180: ,p_mime_type_o
181: => irc_ido_shd.g_old_rec.mime_type
182: ,p_description_o
183: => irc_ido_shd.g_old_rec.description
184: ,p_type_o
185: => irc_ido_shd.g_old_rec.type

Line 183: => irc_ido_shd.g_old_rec.description

179: => irc_ido_shd.g_old_rec.file_format
180: ,p_mime_type_o
181: => irc_ido_shd.g_old_rec.mime_type
182: ,p_description_o
183: => irc_ido_shd.g_old_rec.description
184: ,p_type_o
185: => irc_ido_shd.g_old_rec.type
186: ,p_object_version_number_o
187: => irc_ido_shd.g_old_rec.object_version_number

Line 185: => irc_ido_shd.g_old_rec.type

181: => irc_ido_shd.g_old_rec.mime_type
182: ,p_description_o
183: => irc_ido_shd.g_old_rec.description
184: ,p_type_o
185: => irc_ido_shd.g_old_rec.type
186: ,p_object_version_number_o
187: => irc_ido_shd.g_old_rec.object_version_number
188: ,p_end_date_o
189: => irc_ido_shd.g_old_rec.end_date

Line 187: => irc_ido_shd.g_old_rec.object_version_number

183: => irc_ido_shd.g_old_rec.description
184: ,p_type_o
185: => irc_ido_shd.g_old_rec.type
186: ,p_object_version_number_o
187: => irc_ido_shd.g_old_rec.object_version_number
188: ,p_end_date_o
189: => irc_ido_shd.g_old_rec.end_date
190: );
191: --

Line 189: => irc_ido_shd.g_old_rec.end_date

185: => irc_ido_shd.g_old_rec.type
186: ,p_object_version_number_o
187: => irc_ido_shd.g_old_rec.object_version_number
188: ,p_end_date_o
189: => irc_ido_shd.g_old_rec.end_date
190: );
191: --
192: exception
193: --

Line 209: (p_rec in irc_ido_shd.g_rec_type

205: -- ----------------------------------------------------------------------------
206: -- |---------------------------------< del >----------------------------------|
207: -- ----------------------------------------------------------------------------
208: Procedure del
209: (p_rec in irc_ido_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) := g_package||'del';
213: --

Line 219: irc_ido_shd.lck

215: hr_utility.set_location('Entering:'||l_proc, 5);
216: --
217: -- We must lock the row which we need to delete.
218: --
219: irc_ido_shd.lck
220: (p_rec.document_id
221: ,p_rec.object_version_number
222: );
223: --

Line 250: l_rec irc_ido_shd.g_rec_type;

246: (p_document_id in number
247: ,p_object_version_number in number
248: ) is
249: --
250: l_rec irc_ido_shd.g_rec_type;
251: l_proc varchar2(72) := g_package||'del';
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);