[Home] [Help]
61: l_redirection_url clob;
62: l_posting_url clob;
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: --
67: --
68: --
69: --
84: if (g_redirection_url
85: and dbms_lob.getlength(l_redirection_url)<=32767
86: and dbms_lob.instr(l_redirection_url,p_rec.redirection_url)<>1)
87: then
88: hr_utility.set_location(l_proc, 10);
89: dbms_lob.trim(l_redirection_url,0);
90: dbms_lob.write(l_redirection_url
91: ,length(p_rec.redirection_url)
92: ,1
92: ,1
93: ,p_rec.redirection_url);
94: end if;
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 20);
97: --
98: if (g_posting_url
99: and dbms_lob.getlength(l_posting_url)<=32767
100: and dbms_lob.instr(l_posting_url,p_rec.posting_url)<>1)
98: if (g_posting_url
99: and dbms_lob.getlength(l_posting_url)<=32767
100: and dbms_lob.instr(l_posting_url,p_rec.posting_url)<>1)
101: then
102: hr_utility.set_location(l_proc, 30);
103: dbms_lob.trim(l_posting_url,0);
104: dbms_lob.write(l_posting_url
105: ,length(p_rec.posting_url)
106: ,1
106: ,1
107: ,p_rec.posting_url);
108: end if;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 40);
111: --
112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
168: --
169: l_proc varchar2(72) := g_package||'pre_update';
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: End pre_update;
176: --
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: End pre_update;
176: --
177: -- ----------------------------------------------------------------------------
178: -- |-----------------------------< post_update >------------------------------|
212: --
213: l_proc varchar2(72) := g_package||'post_update';
214: --
215: Begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: begin
218: --
219: irc_irt_rku.after_update
220: (p_recruiting_site_id
248: ,p_hook_type => 'AU');
249: --
250: end;
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: End post_update;
254: --
255: -- ----------------------------------------------------------------------------
256: -- |-----------------------------< convert_defs >-----------------------------|
340: --
341: l_proc varchar2(72) := g_package||'upd';
342: --
343: Begin
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: -- We must lock the row which we need to update.
347: --
348: irc_irt_shd.lck
397: l_rec irc_irt_shd.g_rec_type;
398: l_proc varchar2(72) := g_package||'upd';
399: --
400: Begin
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: -- Call conversion function to turn arguments into the
404: -- l_rec structure.
405: --
421: (l_rec
422: );
423: --
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 10);
426: End upd;
427: --
428: -- ----------------------------------------------------------------------------
429: -- |------------------------------< upd_tl >----------------------------------|
448: --
449: l_proc varchar2(72) := g_package||'upd_tl';
450: --
451: Begin
452: hr_utility.set_location('Entering:'||l_proc,10);
453: --
454: -- Update the translated values for every matching row
455: -- setting SOURCE_LANG to the specified language.
456: --
464: ,p_posting_url => p_posting_url
465: );
466: end loop;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc,20);
469: End upd_tl;
470: --
471: end irc_irt_upd;