APPS.PQH_VLP_INS dependencies on PQH_VLP_SHD

Line 76: (p_rec in out nocopy pqh_vlp_shd.g_rec_type

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

Line 129: pqh_vlp_shd.constraint_error

125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: --
129: pqh_vlp_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --

Line 134: pqh_vlp_shd.constraint_error

130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
134: pqh_vlp_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --

Line 139: pqh_vlp_shd.constraint_error

135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
139: pqh_vlp_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: --
143: Raise;

Line 184: (p_rec in out nocopy pqh_vlp_shd.g_rec_type

180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure pre_insert
184: (p_rec in out nocopy pqh_vlp_shd.g_rec_type
185: ) is
186: --
187: Cursor C_Sel1 is select pqh_fr_validation_periods_s.nextval from sys.dual;
188: --

Line 272: ,p_rec in pqh_vlp_shd.g_rec_type

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

Line 331: ,p_rec in out nocopy pqh_vlp_shd.g_rec_type

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

Line 391: l_rec pqh_vlp_shd.g_rec_type;

387: ,p_validation_period_id out nocopy number
388: ,p_object_version_number out nocopy number
389: ) is
390: --
391: l_rec pqh_vlp_shd.g_rec_type;
392: l_proc varchar2(72) := g_package||'ins';
393: --
394: Begin
395: hr_utility.set_location('Entering:'||l_proc, 5);

Line 401: pqh_vlp_shd.convert_args

397: -- Call conversion function to turn arguments into the
398: -- p_rec structure.
399: --
400: l_rec :=
401: pqh_vlp_shd.convert_args
402: (null
403: ,p_validation_id
404: ,p_start_date
405: ,p_end_date