DBA Data[Home] [Help]

APPS.HR_SNP_INS dependencies on HR_SNP_SHD

Line 77: (p_rec in out nocopy hr_snp_shd.g_rec_type

73: -- ----------------------------------------------------------------------------
74: --
75: -- ----------------------------------------------------------------------------
76: Procedure insert_dml
77: (p_rec in out nocopy hr_snp_shd.g_rec_type
78: ) is
79: --
80: l_proc varchar2(72) := g_package||'insert_dml';
81: --

Line 113: hr_snp_shd.constraint_error

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

Line 118: hr_snp_shd.constraint_error

114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: hr_snp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --

Line 123: hr_snp_shd.constraint_error

119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: hr_snp_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;

Line 166: (p_rec in out nocopy hr_snp_shd.g_rec_type

162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure pre_insert
166: (p_rec in out nocopy hr_snp_shd.g_rec_type
167: ) is
168: --
169: Cursor C_Sel1 is select hr_transaction_snapshot_s.nextval from sys.dual;
170: --

Line 253: (p_rec in hr_snp_shd.g_rec_type

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure post_insert
253: (p_rec in hr_snp_shd.g_rec_type
254: ) is
255: --
256: l_proc varchar2(72) := g_package||'post_insert';
257: --

Line 294: (p_rec in out nocopy hr_snp_shd.g_rec_type

290: -- ----------------------------------------------------------------------------
291: --
292: -- ----------------------------------------------------------------------------
293: Procedure ins
294: (p_rec in out nocopy hr_snp_shd.g_rec_type
295: ) is
296: --
297: l_proc varchar2(72) := g_package||'ins';
298: --

Line 341: l_rec hr_snp_shd.g_rec_type;

337: ,p_object_identifier in varchar2
338:
339: ) is
340: --
341: l_rec hr_snp_shd.g_rec_type;
342: l_proc varchar2(72) := g_package||'ins';
343: --
344: Begin
345: hr_utility.set_location('Entering:'||l_proc, 5);

Line 351: hr_snp_shd.convert_args

347: -- Call conversion function to turn arguments into the
348: -- p_rec structure.
349: --
350: l_rec :=
351: hr_snp_shd.convert_args
352: (null
353: ,null
354: ,p_document
355: ,p_object_name