APPS.PQH_PTX_INS dependencies on PQH_PTX_SHD

Line 47: Procedure insert_dml(p_rec in out nocopy pqh_ptx_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_ptx_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin

Line 352: pqh_ptx_shd.constraint_error

348: hr_utility.set_location(' Leaving:'||l_proc, 10);
349: Exception
350: When hr_api.check_integrity_violated Then
351: -- A check constraint has been violated
352: pqh_ptx_shd.constraint_error
353: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
354: When hr_api.parent_integrity_violated Then
355: -- Parent integrity has been violated
356: pqh_ptx_shd.constraint_error

Line 356: pqh_ptx_shd.constraint_error

352: pqh_ptx_shd.constraint_error
353: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
354: When hr_api.parent_integrity_violated Then
355: -- Parent integrity has been violated
356: pqh_ptx_shd.constraint_error
357: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
358: When hr_api.unique_integrity_violated Then
359: -- Unique integrity has been violated
360: pqh_ptx_shd.constraint_error

Line 360: pqh_ptx_shd.constraint_error

356: pqh_ptx_shd.constraint_error
357: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
358: When hr_api.unique_integrity_violated Then
359: -- Unique integrity has been violated
360: pqh_ptx_shd.constraint_error
361: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
362: When Others Then
363: Raise;
364: End insert_dml;

Line 403: Procedure pre_insert(p_rec in out nocopy pqh_ptx_shd.g_rec_type) is

399: -- Internal Row Handler Use Only.
400: --
401: -- {End Of Comments}
402: -- ----------------------------------------------------------------------------
403: Procedure pre_insert(p_rec in out nocopy pqh_ptx_shd.g_rec_type) is
404: --
405: l_proc varchar2(72) := g_package||'pre_insert';
406: --
407: Cursor C_Sel1 is select pqh_position_transactions_s.nextval from sys.dual;

Line 455: p_effective_date in date,p_rec in pqh_ptx_shd.g_rec_type) is

451: --
452: -- {End Of Comments}
453: -- ----------------------------------------------------------------------------
454: Procedure post_insert(
455: p_effective_date in date,p_rec in pqh_ptx_shd.g_rec_type) is
456: --
457: l_proc varchar2(72) := g_package||'post_insert';
458: l_effective_start_date date;
459: l_effective_end_date date;

Line 488: -- and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then

484: fetch c_review_flag into l_review_flag;
485: close c_review_flag;
486: --
487: -- if (nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'Y'
488: -- and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then
489:
490: if ( nvl(l_review_flag,'N') = 'Y')then
491: hr_utility.set_message(8302, 'PQH_POSITION_UNDER_REVIEW');
492: hr_utility.raise_error;

Line 691: p_rec in out nocopy pqh_ptx_shd.g_rec_type

687: -- ----------------------------------------------------------------------------
688: Procedure ins
689: (
690: p_effective_date in date,
691: p_rec in out nocopy pqh_ptx_shd.g_rec_type
692: ) is
693: --
694: l_proc varchar2(72) := g_package||'ins';
695: --

Line 868: l_rec pqh_ptx_shd.g_rec_type;

864: p_supervisor_id in number default null,
865: p_wf_transaction_category_id in number default null
866: ) is
867: --
868: l_rec pqh_ptx_shd.g_rec_type;
869: l_proc varchar2(72) := g_package||'ins';
870: --
871: Begin
872: hr_utility.set_location('Entering:'||l_proc, 5);

Line 878: pqh_ptx_shd.convert_args

874: -- Call conversion function to turn arguments into the
875: -- p_rec structure.
876: --
877: l_rec :=
878: pqh_ptx_shd.convert_args
879: (
880: null,
881: p_action_date,
882: p_position_id,