APPS.PQH_CER_INS dependencies on PQH_CER_SHD

Line 47: Procedure insert_dml(p_rec in out nocopy pqh_cer_shd.g_rec_type) is

43: -- Internal Row Handler Use Only.
44: --
45: -- {End Of Comments}
46: -- ----------------------------------------------------------------------------
47: Procedure insert_dml(p_rec in out nocopy pqh_cer_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin

Line 472: pqh_cer_shd.constraint_error

468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: Exception
470: When hr_api.check_integrity_violated Then
471: -- A check constraint has been violated
472: pqh_cer_shd.constraint_error
473: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
474: When hr_api.parent_integrity_violated Then
475: -- Parent integrity has been violated
476: pqh_cer_shd.constraint_error

Line 476: pqh_cer_shd.constraint_error

472: pqh_cer_shd.constraint_error
473: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
474: When hr_api.parent_integrity_violated Then
475: -- Parent integrity has been violated
476: pqh_cer_shd.constraint_error
477: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
478: When hr_api.unique_integrity_violated Then
479: -- Unique integrity has been violated
480: pqh_cer_shd.constraint_error

Line 480: pqh_cer_shd.constraint_error

476: pqh_cer_shd.constraint_error
477: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
478: When hr_api.unique_integrity_violated Then
479: -- Unique integrity has been violated
480: pqh_cer_shd.constraint_error
481: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
482: When Others Then
483: Raise;
484: End insert_dml;

Line 523: Procedure pre_insert(p_rec in out nocopy pqh_cer_shd.g_rec_type) is

519: -- Internal Row Handler Use Only.
520: --
521: -- {End Of Comments}
522: -- ----------------------------------------------------------------------------
523: Procedure pre_insert(p_rec in out nocopy pqh_cer_shd.g_rec_type) is
524: --
525: l_proc varchar2(72) := g_package||'pre_insert';
526: --
527: Cursor C_Sel1 is select pqh_copy_entity_results_s.nextval from sys.dual;

Line 575: p_effective_date in date,p_rec in pqh_cer_shd.g_rec_type) is

571: --
572: -- {End Of Comments}
573: -- ----------------------------------------------------------------------------
574: Procedure post_insert(
575: p_effective_date in date,p_rec in pqh_cer_shd.g_rec_type) is
576: --
577: l_proc varchar2(72) := g_package||'post_insert';
578: --
579: Begin

Line 817: p_rec in out nocopy pqh_cer_shd.g_rec_type

813: -- ----------------------------------------------------------------------------
814: Procedure ins
815: (
816: p_effective_date in date,
817: p_rec in out nocopy pqh_cer_shd.g_rec_type
818: ) is
819: --
820: l_proc varchar2(72) := g_package||'ins';
821: --

Line 1055: l_rec pqh_cer_shd.g_rec_type;

1051: p_long_attribute1 in clob default null,
1052: p_object_version_number out nocopy number
1053: ) is
1054: --
1055: l_rec pqh_cer_shd.g_rec_type;
1056: l_proc varchar2(72) := g_package||'ins';
1057: --
1058: Begin
1059: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1065: pqh_cer_shd.convert_args

1061: -- Call conversion function to turn arguments into the
1062: -- p_rec structure.
1063: --
1064: l_rec :=
1065: pqh_cer_shd.convert_args
1066: (
1067: null,
1068: p_copy_entity_txn_id,
1069: p_result_type_cd,