[Home] [Help]
58: l_posting_url clob;
59: l_redirection_url clob;
60: --
61: Begin
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: --
64: --
65: --
66: --
83: ,empty_clob()
84: )
85: returning redirection_url,posting_url into l_redirection_url,l_posting_url;
86: if (p_rec.redirection_url is not null) then
87: hr_utility.set_location(l_proc, 10);
88: dbms_lob.write(l_redirection_url
89: ,length(p_rec.redirection_url)
90: ,1
91: ,p_rec.redirection_url);
91: ,p_rec.redirection_url);
92: end if;
93: --
94: if (p_rec.posting_url is not null) then
95: hr_utility.set_location(l_proc, 10);
96: dbms_lob.write(l_posting_url
97: ,length(p_rec.posting_url)
98: ,1
99: ,p_rec.posting_url);
100: end if;
101: --
102: --
103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
167: --
168: l_proc varchar2(72) := g_package||'pre_insert';
169: --
170: Begin
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: p_rec.recruiting_site_id := p_recruiting_site_id;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: p_rec.recruiting_site_id := p_recruiting_site_id;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: End pre_insert;
177: --
178: -- ----------------------------------------------------------------------------
179: -- |-----------------------------< post_insert >------------------------------|
213: --
214: l_proc varchar2(72) := g_package||'post_insert';
215: --
216: Begin
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: begin
219: --
220: irc_irt_rki.after_insert
221: (p_recruiting_site_id
241: ,p_hook_type => 'AI');
242: --
243: end;
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: End post_insert;
247: --
248: -- ----------------------------------------------------------------------------
249: -- |---------------------------------< ins >----------------------------------|
255: --
256: l_proc varchar2(72) := g_package||'ins';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: -- Call the supporting insert validate operations
262: --
263: irc_irt_bus.insert_validate
287: --
288: -- Call to raise any errors on multi-message list
289: hr_multi_message.end_validation_set;
290: --
291: hr_utility.set_location('Leaving:'||l_proc, 20);
292: end ins;
293: --
294: -- ----------------------------------------------------------------------------
295: -- |---------------------------------< ins >----------------------------------|
306: l_rec irc_irt_shd.g_rec_type;
307: l_proc varchar2(72) := g_package||'ins';
308: --
309: Begin
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: -- Call conversion function to turn arguments into the
313: -- p_rec structure.
314: --
334: -- are specified as an OUT's we must set these values.
335: --
336: --
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 10);
339: End ins;
340: --
341: -- ----------------------------------------------------------------------------
342: -- |------------------------------< ins_tl >----------------------------------|
362: --
363: l_proc varchar2(72) := g_package || 'ins_tl';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc,10);
367: --
368: -- Insert a row for the base language and every installed language.
369: --
370: for l_lang in csr_ins_langs loop
377: ,p_posting_url => p_posting_url
378: );
379: end loop;
380: --
381: hr_utility.set_location('Leaving:'||l_proc,20);
382: End ins_tl;
383: --
384: end irc_irt_ins;