DBA Data[Home] [Help]

APPS.IRC_IRT_UPD dependencies on IRC_IRT_SHD

Line 57: (p_rec in out nocopy irc_irt_shd.g_rec_type

53: --
54: -- {End Of Comments}
55: -- ----------------------------------------------------------------------------
56: Procedure update_dml
57: (p_rec in out nocopy irc_irt_shd.g_rec_type
58: ) is
59: --
60: l_proc varchar2(72) := g_package||'update_dml';
61: l_redirection_url clob;

Line 116: irc_irt_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: irc_irt_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --

Line 121: irc_irt_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: irc_irt_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --

Line 126: irc_irt_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: irc_irt_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;

Line 166: (p_rec in irc_irt_shd.g_rec_type

162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure pre_update
166: (p_rec in irc_irt_shd.g_rec_type
167: ) is
168: --
169: l_proc varchar2(72) := g_package||'pre_update';
170: --

Line 210: (p_rec in irc_irt_shd.g_rec_type

206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update
210: (p_rec in irc_irt_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'post_update';
214: --

Line 233: => irc_irt_shd.g_old_rec.source_lang

229: => p_rec.redirection_url
230: ,p_posting_url
231: => p_rec.posting_url
232: ,p_source_lang_o
233: => irc_irt_shd.g_old_rec.source_lang
234: ,p_site_name_o
235: => irc_irt_shd.g_old_rec.site_name
236: ,p_redirection_url_o
237: => irc_irt_shd.g_old_rec.redirection_url

Line 235: => irc_irt_shd.g_old_rec.site_name

231: => p_rec.posting_url
232: ,p_source_lang_o
233: => irc_irt_shd.g_old_rec.source_lang
234: ,p_site_name_o
235: => irc_irt_shd.g_old_rec.site_name
236: ,p_redirection_url_o
237: => irc_irt_shd.g_old_rec.redirection_url
238: ,p_posting_url_o
239: => irc_irt_shd.g_old_rec.posting_url

Line 237: => irc_irt_shd.g_old_rec.redirection_url

233: => irc_irt_shd.g_old_rec.source_lang
234: ,p_site_name_o
235: => irc_irt_shd.g_old_rec.site_name
236: ,p_redirection_url_o
237: => irc_irt_shd.g_old_rec.redirection_url
238: ,p_posting_url_o
239: => irc_irt_shd.g_old_rec.posting_url
240: );
241: --

Line 239: => irc_irt_shd.g_old_rec.posting_url

235: => irc_irt_shd.g_old_rec.site_name
236: ,p_redirection_url_o
237: => irc_irt_shd.g_old_rec.redirection_url
238: ,p_posting_url_o
239: => irc_irt_shd.g_old_rec.posting_url
240: );
241: --
242: exception
243: --

Line 299: (p_rec in out nocopy irc_irt_shd.g_rec_type

295: --
296: -- {End Of Comments}
297: -- ----------------------------------------------------------------------------
298: Procedure convert_defs
299: (p_rec in out nocopy irc_irt_shd.g_rec_type
300: ) is
301: --
302: Begin
303: --

Line 311: irc_irt_shd.g_old_rec.source_lang;

307: -- is being used then we must set to the 'current' argument value.
308: --
309: If (p_rec.source_lang = hr_api.g_varchar2) then
310: p_rec.source_lang :=
311: irc_irt_shd.g_old_rec.source_lang;
312: End If;
313: If (p_rec.site_name = hr_api.g_varchar2) then
314: p_rec.site_name :=
315: irc_irt_shd.g_old_rec.site_name;

Line 315: irc_irt_shd.g_old_rec.site_name;

311: irc_irt_shd.g_old_rec.source_lang;
312: End If;
313: If (p_rec.site_name = hr_api.g_varchar2) then
314: p_rec.site_name :=
315: irc_irt_shd.g_old_rec.site_name;
316: End If;
317: If (p_rec.redirection_url = hr_api.g_varchar2) then
318: p_rec.redirection_url :=
319: irc_irt_shd.g_old_rec.redirection_url;

Line 319: irc_irt_shd.g_old_rec.redirection_url;

315: irc_irt_shd.g_old_rec.site_name;
316: End If;
317: If (p_rec.redirection_url = hr_api.g_varchar2) then
318: p_rec.redirection_url :=
319: irc_irt_shd.g_old_rec.redirection_url;
320: g_redirection_url := false;
321: Else
322: g_redirection_url := true;
323: End If;

Line 326: irc_irt_shd.g_old_rec.posting_url;

322: g_redirection_url := true;
323: End If;
324: If (p_rec.posting_url = hr_api.g_varchar2) then
325: p_rec.posting_url :=
326: irc_irt_shd.g_old_rec.posting_url;
327: g_posting_url := false;
328: Else
329: g_posting_url := true;
330: End If;

Line 338: (p_rec in out nocopy irc_irt_shd.g_rec_type

334: -- ----------------------------------------------------------------------------
335: -- |---------------------------------< upd >----------------------------------|
336: -- ----------------------------------------------------------------------------
337: Procedure upd
338: (p_rec in out nocopy irc_irt_shd.g_rec_type
339: ) is
340: --
341: l_proc varchar2(72) := g_package||'upd';
342: --

Line 348: irc_irt_shd.lck

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
349: (p_rec.recruiting_site_id
350: ,p_rec.language
351: );
352: --

Line 397: l_rec irc_irt_shd.g_rec_type;

393: ,p_redirection_url in varchar2 default hr_api.g_varchar2
394: ,p_posting_url in varchar2 default hr_api.g_varchar2
395: ) is
396: --
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);

Line 407: irc_irt_shd.convert_args

403: -- Call conversion function to turn arguments into the
404: -- l_rec structure.
405: --
406: l_rec :=
407: irc_irt_shd.convert_args
408: (p_recruiting_site_id
409: ,p_language
410: ,p_source_lang
411: ,p_site_name