48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in irc_ipt_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: irc_ipt_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;
111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in irc_ipt_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin
153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_rec in irc_ipt_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin
167: => p_rec.posting_content_id
168: ,p_language
169: => p_rec.language
170: ,p_source_language_o
171: => irc_ipt_shd.g_old_rec.source_language
172: ,p_name_o
173: => irc_ipt_shd.g_old_rec.name
174: ,p_org_name_o
175: => irc_ipt_shd.g_old_rec.org_name
169: => p_rec.language
170: ,p_source_language_o
171: => irc_ipt_shd.g_old_rec.source_language
172: ,p_name_o
173: => irc_ipt_shd.g_old_rec.name
174: ,p_org_name_o
175: => irc_ipt_shd.g_old_rec.org_name
176: ,p_org_description_o
177: => irc_ipt_shd.g_old_rec.org_description
171: => irc_ipt_shd.g_old_rec.source_language
172: ,p_name_o
173: => irc_ipt_shd.g_old_rec.name
174: ,p_org_name_o
175: => irc_ipt_shd.g_old_rec.org_name
176: ,p_org_description_o
177: => irc_ipt_shd.g_old_rec.org_description
178: ,p_job_title_o
179: => irc_ipt_shd.g_old_rec.job_title
173: => irc_ipt_shd.g_old_rec.name
174: ,p_org_name_o
175: => irc_ipt_shd.g_old_rec.org_name
176: ,p_org_description_o
177: => irc_ipt_shd.g_old_rec.org_description
178: ,p_job_title_o
179: => irc_ipt_shd.g_old_rec.job_title
180: ,p_brief_description_o
181: => irc_ipt_shd.g_old_rec.brief_description
175: => irc_ipt_shd.g_old_rec.org_name
176: ,p_org_description_o
177: => irc_ipt_shd.g_old_rec.org_description
178: ,p_job_title_o
179: => irc_ipt_shd.g_old_rec.job_title
180: ,p_brief_description_o
181: => irc_ipt_shd.g_old_rec.brief_description
182: ,p_detailed_description_o
183: => irc_ipt_shd.g_old_rec.detailed_description
177: => irc_ipt_shd.g_old_rec.org_description
178: ,p_job_title_o
179: => irc_ipt_shd.g_old_rec.job_title
180: ,p_brief_description_o
181: => irc_ipt_shd.g_old_rec.brief_description
182: ,p_detailed_description_o
183: => irc_ipt_shd.g_old_rec.detailed_description
184: ,p_job_requirements_o
185: => irc_ipt_shd.g_old_rec.job_requirements
179: => irc_ipt_shd.g_old_rec.job_title
180: ,p_brief_description_o
181: => irc_ipt_shd.g_old_rec.brief_description
182: ,p_detailed_description_o
183: => irc_ipt_shd.g_old_rec.detailed_description
184: ,p_job_requirements_o
185: => irc_ipt_shd.g_old_rec.job_requirements
186: ,p_additional_details_o
187: => irc_ipt_shd.g_old_rec.additional_details
181: => irc_ipt_shd.g_old_rec.brief_description
182: ,p_detailed_description_o
183: => irc_ipt_shd.g_old_rec.detailed_description
184: ,p_job_requirements_o
185: => irc_ipt_shd.g_old_rec.job_requirements
186: ,p_additional_details_o
187: => irc_ipt_shd.g_old_rec.additional_details
188: ,p_how_to_apply_o
189: => irc_ipt_shd.g_old_rec.how_to_apply
183: => irc_ipt_shd.g_old_rec.detailed_description
184: ,p_job_requirements_o
185: => irc_ipt_shd.g_old_rec.job_requirements
186: ,p_additional_details_o
187: => irc_ipt_shd.g_old_rec.additional_details
188: ,p_how_to_apply_o
189: => irc_ipt_shd.g_old_rec.how_to_apply
190: ,p_benefit_info_o
191: => irc_ipt_shd.g_old_rec.benefit_info
185: => irc_ipt_shd.g_old_rec.job_requirements
186: ,p_additional_details_o
187: => irc_ipt_shd.g_old_rec.additional_details
188: ,p_how_to_apply_o
189: => irc_ipt_shd.g_old_rec.how_to_apply
190: ,p_benefit_info_o
191: => irc_ipt_shd.g_old_rec.benefit_info
192: ,p_image_url_o
193: => irc_ipt_shd.g_old_rec.image_url
187: => irc_ipt_shd.g_old_rec.additional_details
188: ,p_how_to_apply_o
189: => irc_ipt_shd.g_old_rec.how_to_apply
190: ,p_benefit_info_o
191: => irc_ipt_shd.g_old_rec.benefit_info
192: ,p_image_url_o
193: => irc_ipt_shd.g_old_rec.image_url
194: ,p_image_url_alt_o
195: => irc_ipt_shd.g_old_rec.image_url_alt
189: => irc_ipt_shd.g_old_rec.how_to_apply
190: ,p_benefit_info_o
191: => irc_ipt_shd.g_old_rec.benefit_info
192: ,p_image_url_o
193: => irc_ipt_shd.g_old_rec.image_url
194: ,p_image_url_alt_o
195: => irc_ipt_shd.g_old_rec.image_url_alt
196: );
197: --
191: => irc_ipt_shd.g_old_rec.benefit_info
192: ,p_image_url_o
193: => irc_ipt_shd.g_old_rec.image_url
194: ,p_image_url_alt_o
195: => irc_ipt_shd.g_old_rec.image_url_alt
196: );
197: --
198: exception
199: --
211: -- ----------------------------------------------------------------------------
212: -- |---------------------------------< del >----------------------------------|
213: -- ----------------------------------------------------------------------------
214: Procedure del
215: (p_rec in irc_ipt_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'del';
219: --
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: -- We must lock the row which we need to delete.
224: --
225: irc_ipt_shd.lck
226: (p_rec.posting_content_id
227: ,p_rec.language
228: );
229: --
254: (p_posting_content_id in number
255: ,p_language in varchar2
256: ) is
257: --
258: l_rec irc_ipt_shd.g_rec_type;
259: l_proc varchar2(72) := g_package||'del';
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);