APPS.GHR_PRH_INS dependencies on GHR_PRH_SHD

Line 47: Procedure insert_dml(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is

43: -- Internal Table Handler Use Only.
44: --
45: -- {End Of Comments}
46: -- ----------------------------------------------------------------------------
47: Procedure insert_dml(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) ;
50: l_rec ghr_prh_shd.g_rec_type;
51: --

Line 50: l_rec ghr_prh_shd.g_rec_type;

46: -- ----------------------------------------------------------------------------
47: Procedure insert_dml(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) ;
50: l_rec ghr_prh_shd.g_rec_type;
51: --
52: Begin
53: l_proc := g_package||'insert_dml';
54: hr_utility.set_location('Entering:'||l_proc, 5);

Line 124: ghr_prh_shd.constraint_error

120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: p_rec := l_rec;
124: ghr_prh_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: p_rec := l_rec;

Line 129: ghr_prh_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: p_rec := l_rec;
129: ghr_prh_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: p_rec := l_rec;

Line 134: ghr_prh_shd.constraint_error

130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: p_rec := l_rec;
134: ghr_prh_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: p_rec := l_rec;
138: Raise;

Line 179: (p_rec in out NOCOPY ghr_prh_shd.g_rec_type)is

175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure pre_insert
179: (p_rec in out NOCOPY ghr_prh_shd.g_rec_type)is
180: --
181: l_proc varchar2(72);
182: l_rec ghr_prh_shd.g_rec_type;
183: --

Line 182: l_rec ghr_prh_shd.g_rec_type;

178: Procedure pre_insert
179: (p_rec in out NOCOPY ghr_prh_shd.g_rec_type)is
180: --
181: l_proc varchar2(72);
182: l_rec ghr_prh_shd.g_rec_type;
183: --
184: Cursor C_Sel1 is select ghr_pa_routing_history_s.nextval from sys.dual;
185: --
186: Begin

Line 239: Procedure post_insert(p_rec in ghr_prh_shd.g_rec_type) is

235: -- Internal Table Handler Use Only.
236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure post_insert(p_rec in ghr_prh_shd.g_rec_type) is
240: --
241: l_proc varchar2(72) ;
242: --
243: Begin

Line 296: p_rec in out NOCOPY ghr_prh_shd.g_rec_type,

292: -- |---------------------------------< ins >----------------------------------|
293: -- ----------------------------------------------------------------------------
294: Procedure ins
295: (
296: p_rec in out NOCOPY ghr_prh_shd.g_rec_type,
297: p_validate in boolean default false
298: ) is
299: --
300: l_proc varchar2(72);

Line 301: l_rec ghr_prh_shd.g_rec_type;

297: p_validate in boolean default false
298: ) is
299: --
300: l_proc varchar2(72);
301: l_rec ghr_prh_shd.g_rec_type;
302: --
303: Begin
304: l_proc := g_package||'ins';
305: hr_utility.set_location('Entering:'||l_proc, 5);

Line 388: l_rec ghr_prh_shd.g_rec_type;

384: p_object_version_number out NOCOPY number,
385: p_validate in boolean default false
386: ) is
387: --
388: l_rec ghr_prh_shd.g_rec_type;
389: l_proc varchar2(72) ;
390: --
391: Begin
392: l_proc := g_package||'ins';

Line 399: ghr_prh_shd.convert_args

395: -- Call conversion function to turn arguments into the
396: -- p_rec structure.
397: --
398: l_rec :=
399: ghr_prh_shd.convert_args
400: (
401: null,
402: p_pa_request_id,
403: p_attachment_modified_flag,