DBA Data[Home] [Help]

APPS.PER_PCE_INS dependencies on PER_PCE_SHD

Line 54: (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type

50: --
51: -- {END Of Comments}
52: -- ----------------------------------------------------------------------------
53: PROCEDURE insert_dml
54: (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type
55: ) IS
56: --
57: l_proc VARCHAR2(72) := g_package||'insert_dml';
58: --

Line 101: per_pce_shd.constraint_error

97: EXCEPTION
98: WHEN hr_api.check_integrity_violated THEN
99: -- A check constraint has been violated
100: --
101: per_pce_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: WHEN hr_api.parent_integrity_violated THEN
104: -- Parent integrity has been violated
105: --

Line 106: per_pce_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: WHEN hr_api.parent_integrity_violated THEN
104: -- Parent integrity has been violated
105: --
106: per_pce_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: WHEN hr_api.unique_integrity_violated THEN
109: -- Unique integrity has been violated
110: --

Line 111: per_pce_shd.constraint_error

107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: WHEN hr_api.unique_integrity_violated THEN
109: -- Unique integrity has been violated
110: --
111: per_pce_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: WHEN Others THEN
114: --
115: RAISE;

Line 156: (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type

152: --
153: -- {END Of Comments}
154: -- ----------------------------------------------------------------------------
155: PROCEDURE pre_insert
156: (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type
157: ) IS
158: --
159: l_proc VARCHAR2(72) := g_package||'pre_insert';
160: --

Line 210: ,p_rec IN per_pce_shd.g_rec_type

206: -- {END Of Comments}
207: -- ----------------------------------------------------------------------------
208: PROCEDURE post_insert
209: (p_effective_date IN DATE
210: ,p_rec IN per_pce_shd.g_rec_type
211: ) IS
212: --
213: l_proc VARCHAR2(72) := g_package||'post_insert';
214: --

Line 252: ,p_rec IN OUT NOCOPY per_pce_shd.g_rec_type

248: -- |---------------------------------< ins >----------------------------------|
249: -- ----------------------------------------------------------------------------
250: PROCEDURE ins
251: (p_effective_date IN DATE
252: ,p_rec IN OUT NOCOPY per_pce_shd.g_rec_type
253: ) IS
254: --
255: l_proc VARCHAR2(72) := g_package||'ins';
256: --

Line 305: l_rec per_pce_shd.g_rec_type;

301: ,p_cagr_entitlement_id OUT NOCOPY NUMBER
302: ,p_object_version_number OUT NOCOPY NUMBER
303: ) IS
304: --
305: l_rec per_pce_shd.g_rec_type;
306: l_proc VARCHAR2(72) := g_package||'ins';
307: l_start_date DATE;
308: --
309: BEGIN

Line 319: per_pce_shd.convert_args

315: -- Call conversion function to turn arguments into the
316: -- p_rec structure.
317: --
318: l_rec :=
319: per_pce_shd.convert_args
320: (NULL
321: ,p_cagr_entitlement_item_id
322: ,p_collective_agreement_id
323: ,l_start_date