APPS.PER_PSS_INS dependencies on PER_PSS_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_pss_shd.g_rec_type) is

49: -- Internal Row Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy per_pss_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 131: per_pss_shd.constraint_error

127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_pss_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_pss_shd.constraint_error

Line 135: per_pss_shd.constraint_error

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

Line 139: per_pss_shd.constraint_error

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

Line 182: Procedure pre_insert(p_rec in out nocopy per_pss_shd.g_rec_type) is

178: -- Internal Row Handler Use Only.
179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure pre_insert(p_rec in out nocopy per_pss_shd.g_rec_type) is
183: --
184: l_proc varchar2(72) := g_package||'pre_insert';
185: --
186: Cursor C_Sel1 is select per_salary_surveys_s.nextval from sys.dual;

Line 233: Procedure post_insert(p_rec in per_pss_shd.g_rec_type,

229: -- Internal Row Handler Use Only.
230: --
231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: Procedure post_insert(p_rec in per_pss_shd.g_rec_type,
234: p_effective_date in date) is
235: --
236: l_proc varchar2(72) := g_package||'post_insert';
237: --

Line 322: p_rec in out nocopy per_pss_shd.g_rec_type,

318: -- |---------------------------------< ins >----------------------------------|
319: -- ----------------------------------------------------------------------------
320: Procedure ins
321: (
322: p_rec in out nocopy per_pss_shd.g_rec_type,
323: p_effective_date in date
324: ) is
325: --
326: l_proc varchar2(72) := g_package||'ins';

Line 385: l_rec per_pss_shd.g_rec_type;

381: p_attribute20 in varchar2 default null,
382: p_effective_date in date default null
383: ) is
384: --
385: l_rec per_pss_shd.g_rec_type;
386: l_proc varchar2(72) := g_package||'ins';
387: --
388: Begin
389: hr_utility.set_location('Entering:'||l_proc, 5);

Line 395: per_pss_shd.convert_args

391: -- Call conversion function to turn arguments into the
392: -- p_rec structure.
393: --
394: l_rec :=
395: per_pss_shd.convert_args
396: (
397: null,
398: null,
399: p_survey_name,