DBA Data[Home] [Help]

APPS.HR_ADI_LOB_INS dependencies on HR_ADI_LOB_SHD

Line 76: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 117: hr_adi_lob_shd.constraint_error

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

Line 122: hr_adi_lob_shd.constraint_error

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

Line 127: hr_adi_lob_shd.constraint_error

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

Line 172: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type

168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure pre_insert
172: (p_rec in out nocopy hr_adi_lob_shd.g_rec_type
173: ) is
174: --
175: Cursor C_Sel1 is select fnd_lobs_s.nextval from sys.dual;
176: --

Line 273: ,p_rec in hr_adi_lob_shd.g_rec_type

269: -- {End Of Comments}
270: -- ----------------------------------------------------------------------------
271: Procedure post_insert
272: (p_effective_date in date
273: ,p_rec in hr_adi_lob_shd.g_rec_type
274: ) is
275: --
276: l_proc varchar2(72) := g_package||'post_insert';
277: --

Line 318: ,p_rec in out nocopy hr_adi_lob_shd.g_rec_type

314: -- |---------------------------------< ins >----------------------------------|
315: -- ----------------------------------------------------------------------------
316: Procedure ins
317: (p_effective_date in date
318: ,p_rec in out nocopy hr_adi_lob_shd.g_rec_type
319: ) is
320: --
321: l_proc varchar2(72) := g_package||'ins';
322: --

Line 368: l_rec hr_adi_lob_shd.g_rec_type;

364: ,p_file_type in varchar2
365: ,p_file_id out nocopy number
366: ) is
367: --
368: l_rec hr_adi_lob_shd.g_rec_type;
369: l_proc varchar2(72) := g_package||'ins';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);

Line 378: hr_adi_lob_shd.convert_args

374: -- Call conversion function to turn arguments into the
375: -- p_rec structure.
376: --
377: l_rec :=
378: hr_adi_lob_shd.convert_args
379: (null
380: ,p_file_name
381: ,p_file_content_type
382: ,SYSDATE