APPS.PQH_CRD_INS dependencies on PQH_CRD_SHD

Line 124: (p_rec in out nocopy pqh_crd_shd.g_rec_type

120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure insert_dml
124: (p_rec in out nocopy pqh_crd_shd.g_rec_type
125: ) is
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --

Line 247: pqh_crd_shd.constraint_error

243: Exception
244: When hr_api.check_integrity_violated Then
245: -- A check constraint has been violated
246: --
247: pqh_crd_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.parent_integrity_violated Then
250: -- Parent integrity has been violated
251: --

Line 252: pqh_crd_shd.constraint_error

248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.parent_integrity_violated Then
250: -- Parent integrity has been violated
251: --
252: pqh_crd_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When hr_api.unique_integrity_violated Then
255: -- Unique integrity has been violated
256: --

Line 257: pqh_crd_shd.constraint_error

253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When hr_api.unique_integrity_violated Then
255: -- Unique integrity has been violated
256: --
257: pqh_crd_shd.constraint_error
258: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
259: When Others Then
260: --
261: Raise;

Line 302: (p_rec in out nocopy pqh_crd_shd.g_rec_type

298: --
299: -- {End Of Comments}
300: -- ----------------------------------------------------------------------------
301: Procedure pre_insert
302: (p_rec in out nocopy pqh_crd_shd.g_rec_type
303: ) is
304: --
305: Cursor C_Sel1 is select pqh_criteria_rate_defn_s.nextval from sys.dual;
306: --

Line 390: ,p_rec in pqh_crd_shd.g_rec_type

386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: Procedure post_insert
389: (p_effective_date in date
390: ,p_rec in pqh_crd_shd.g_rec_type
391: ) is
392: --
393: l_proc varchar2(72) := g_package||'post_insert';
394: --

Line 525: ,p_rec in out nocopy pqh_crd_shd.g_rec_type

521: -- |---------------------------------< ins >----------------------------------|
522: -- ----------------------------------------------------------------------------
523: Procedure ins
524: (p_effective_date in date
525: ,p_rec in out nocopy pqh_crd_shd.g_rec_type
526: ) is
527: --
528: l_proc varchar2(72) := g_package||'ins';
529: --

Line 620: l_rec pqh_crd_shd.g_rec_type;

616: ,p_criteria_rate_defn_id out nocopy number
617: ,p_object_version_number out nocopy number
618: ) is
619: --
620: l_rec pqh_crd_shd.g_rec_type;
621: l_proc varchar2(72) := g_package||'ins';
622: --
623: Begin
624: hr_utility.set_location('Entering:'||l_proc, 5);

Line 630: pqh_crd_shd.convert_args

626: -- Call conversion function to turn arguments into the
627: -- p_rec structure.
628: --
629: l_rec :=
630: pqh_crd_shd.convert_args
631: (null
632: ,p_short_name
633: ,p_uom
634: ,p_currency_code