eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ADI_LOB_UPD dependencies on HR_ADI_LOB_SHD

Line 55: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type

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

Line 87: hr_adi_lob_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: hr_adi_lob_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --

Line 92: hr_adi_lob_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: hr_adi_lob_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --

Line 97: hr_adi_lob_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: hr_adi_lob_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;

Line 137: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type

133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update
137: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type
138: ) is
139: --
140: l_proc varchar2(72) := g_package||'pre_update';
141: --

Line 193: ,p_rec in hr_adi_lob_shd.g_rec_type

189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure post_update
192: (p_effective_date in date
193: ,p_rec in hr_adi_lob_shd.g_rec_type
194: ) is
195: --
196: l_proc varchar2(72) := g_package||'post_update';
197: --

Line 219: => hr_adi_lob_shd.g_old_rec.file_name

215: => p_rec.program_tag
216: ,p_file_format
217: => p_rec.file_format
218: ,p_file_name_o
219: => hr_adi_lob_shd.g_old_rec.file_name
220: ,p_file_content_type_o
221: => hr_adi_lob_shd.g_old_rec.file_content_type
222: ,p_upload_date_o
223: => hr_adi_lob_shd.g_old_rec.upload_date

Line 221: => hr_adi_lob_shd.g_old_rec.file_content_type

217: => p_rec.file_format
218: ,p_file_name_o
219: => hr_adi_lob_shd.g_old_rec.file_name
220: ,p_file_content_type_o
221: => hr_adi_lob_shd.g_old_rec.file_content_type
222: ,p_upload_date_o
223: => hr_adi_lob_shd.g_old_rec.upload_date
224: ,p_program_name_o
225: => hr_adi_lob_shd.g_old_rec.program_name

Line 223: => hr_adi_lob_shd.g_old_rec.upload_date

219: => hr_adi_lob_shd.g_old_rec.file_name
220: ,p_file_content_type_o
221: => hr_adi_lob_shd.g_old_rec.file_content_type
222: ,p_upload_date_o
223: => hr_adi_lob_shd.g_old_rec.upload_date
224: ,p_program_name_o
225: => hr_adi_lob_shd.g_old_rec.program_name
226: ,p_program_tag_o
227: => hr_adi_lob_shd.g_old_rec.program_tag

Line 225: => hr_adi_lob_shd.g_old_rec.program_name

221: => hr_adi_lob_shd.g_old_rec.file_content_type
222: ,p_upload_date_o
223: => hr_adi_lob_shd.g_old_rec.upload_date
224: ,p_program_name_o
225: => hr_adi_lob_shd.g_old_rec.program_name
226: ,p_program_tag_o
227: => hr_adi_lob_shd.g_old_rec.program_tag
228: ,p_file_format_o
229: => hr_adi_lob_shd.g_old_rec.file_format

Line 227: => hr_adi_lob_shd.g_old_rec.program_tag

223: => hr_adi_lob_shd.g_old_rec.upload_date
224: ,p_program_name_o
225: => hr_adi_lob_shd.g_old_rec.program_name
226: ,p_program_tag_o
227: => hr_adi_lob_shd.g_old_rec.program_tag
228: ,p_file_format_o
229: => hr_adi_lob_shd.g_old_rec.file_format
230: );
231: --

Line 229: => hr_adi_lob_shd.g_old_rec.file_format

225: => hr_adi_lob_shd.g_old_rec.program_name
226: ,p_program_tag_o
227: => hr_adi_lob_shd.g_old_rec.program_tag
228: ,p_file_format_o
229: => hr_adi_lob_shd.g_old_rec.file_format
230: );
231: --
232: exception
233: --

Line 289: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type

285: --
286: -- {End Of Comments}
287: -- ----------------------------------------------------------------------------
288: Procedure convert_defs
289: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type
290: ) is
291: --
292: Begin
293: --

Line 301: hr_adi_lob_shd.g_old_rec.file_name;

297: -- is being used then we must set to the 'current' argument value.
298: --
299: If (p_rec.file_name = hr_api.g_varchar2) then
300: p_rec.file_name :=
301: hr_adi_lob_shd.g_old_rec.file_name;
302: End If;
303: If (p_rec.file_content_type = hr_api.g_varchar2) then
304: p_rec.file_content_type :=
305: hr_adi_lob_shd.g_old_rec.file_content_type;

Line 305: hr_adi_lob_shd.g_old_rec.file_content_type;

301: hr_adi_lob_shd.g_old_rec.file_name;
302: End If;
303: If (p_rec.file_content_type = hr_api.g_varchar2) then
304: p_rec.file_content_type :=
305: hr_adi_lob_shd.g_old_rec.file_content_type;
306: End If;
307: If (p_rec.upload_date = hr_api.g_date) then
308: p_rec.upload_date :=
309: hr_adi_lob_shd.g_old_rec.upload_date;

Line 309: hr_adi_lob_shd.g_old_rec.upload_date;

305: hr_adi_lob_shd.g_old_rec.file_content_type;
306: End If;
307: If (p_rec.upload_date = hr_api.g_date) then
308: p_rec.upload_date :=
309: hr_adi_lob_shd.g_old_rec.upload_date;
310: End If;
311: If (p_rec.program_name = hr_api.g_varchar2) then
312: p_rec.program_name :=
313: hr_adi_lob_shd.g_old_rec.program_name;

Line 313: hr_adi_lob_shd.g_old_rec.program_name;

309: hr_adi_lob_shd.g_old_rec.upload_date;
310: End If;
311: If (p_rec.program_name = hr_api.g_varchar2) then
312: p_rec.program_name :=
313: hr_adi_lob_shd.g_old_rec.program_name;
314: End If;
315: If (p_rec.program_tag = hr_api.g_varchar2) then
316: p_rec.program_tag :=
317: hr_adi_lob_shd.g_old_rec.program_tag;

Line 317: hr_adi_lob_shd.g_old_rec.program_tag;

313: hr_adi_lob_shd.g_old_rec.program_name;
314: End If;
315: If (p_rec.program_tag = hr_api.g_varchar2) then
316: p_rec.program_tag :=
317: hr_adi_lob_shd.g_old_rec.program_tag;
318: End If;
319: If (p_rec.file_format = hr_api.g_varchar2) then
320: p_rec.file_format :=
321: hr_adi_lob_shd.g_old_rec.file_format;

Line 321: hr_adi_lob_shd.g_old_rec.file_format;

317: hr_adi_lob_shd.g_old_rec.program_tag;
318: End If;
319: If (p_rec.file_format = hr_api.g_varchar2) then
320: p_rec.file_format :=
321: hr_adi_lob_shd.g_old_rec.file_format;
322: End If;
323: --
324: End convert_defs;
325: --

Line 331: ,p_rec in out nocopy hr_adi_lob_shd.g_rec_type

327: -- |---------------------------------< upd >----------------------------------|
328: -- ----------------------------------------------------------------------------
329: Procedure upd
330: (p_effective_date in date
331: ,p_rec in out nocopy hr_adi_lob_shd.g_rec_type
332: ) is
333: --
334: l_proc varchar2(72) := g_package||'upd';
335: --

Line 341: hr_adi_lob_shd.lck

337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: -- We must lock the row which we need to update.
340: --
341: hr_adi_lob_shd.lck
342: (p_rec.file_id
343: );
344: --
345: -- 1. During an update system defaults are used to determine if

Line 389: l_rec hr_adi_lob_shd.g_rec_type;

385: ,p_file_content_type in varchar2
386: ,p_file_name in varchar2
387: ) is
388: --
389: l_rec hr_adi_lob_shd.g_rec_type;
390: l_proc varchar2(72) := g_package||'upd';
391: --
392: Begin
393: hr_utility.set_location('Entering:'||l_proc, 5);

Line 399: hr_adi_lob_shd.convert_args

395: -- Call conversion function to turn arguments into the
396: -- l_rec structure.
397: --
398: l_rec :=
399: hr_adi_lob_shd.convert_args
400: (p_file_id
401: ,p_file_name
402: ,p_file_content_type
403: ,SYSDATE