DBA Data[Home] [Help]

APPS.PQH_TJR_INS dependencies on PQH_TJR_SHD

Line 54: (p_rec in out nocopy pqh_tjr_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy pqh_tjr_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 151: pqh_tjr_shd.constraint_error

147: Exception
148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: --
151: pqh_tjr_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: --

Line 156: pqh_tjr_shd.constraint_error

152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: --
156: pqh_tjr_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: --

Line 161: pqh_tjr_shd.constraint_error

157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: --
161: pqh_tjr_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: --
165: Raise;

Line 206: (p_rec in out nocopy pqh_tjr_shd.g_rec_type

202: --
203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: Procedure pre_insert
206: (p_rec in out nocopy pqh_tjr_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'pre_insert';
210: --

Line 259: (p_rec in pqh_tjr_shd.g_rec_type

255: --
256: -- {End Of Comments}
257: -- ----------------------------------------------------------------------------
258: Procedure post_insert
259: (p_rec in pqh_tjr_shd.g_rec_type
260: ) is
261: --
262: l_proc varchar2(72) := g_package||'post_insert';
263: --

Line 360: (p_rec in out nocopy pqh_tjr_shd.g_rec_type

356: -- ----------------------------------------------------------------------------
357: -- |---------------------------------< ins >----------------------------------|
358: -- ----------------------------------------------------------------------------
359: Procedure ins
360: (p_rec in out nocopy pqh_tjr_shd.g_rec_type
361: ) is
362: --
363: l_proc varchar2(72) := g_package||'ins';
364: --

Line 433: l_rec pqh_tjr_shd.g_rec_type;

429: ,p_txn_job_requirement_id out nocopy number
430: ,p_object_version_number out nocopy number
431: ) is
432: --
433: l_rec pqh_tjr_shd.g_rec_type;
434: l_proc varchar2(72) := g_package||'ins';
435: --
436: Begin
437: hr_utility.set_location('Entering:'||l_proc, 5);

Line 443: pqh_tjr_shd.convert_args

439: -- Call conversion function to turn arguments into the
440: -- p_rec structure.
441: --
442: l_rec :=
443: pqh_tjr_shd.convert_args
444: (null
445: ,p_position_transaction_id
446: ,p_job_requirement_id
447: ,p_business_group_id