DBA Data[Home] [Help]

APPS.PQH_TEM_BUS dependencies on PQH_ROLE_TEMPLATES

Line 808: From pqh_role_templates

804: l_proc varchar2(72) := g_package||'disable_role_templates';
805: --
806: Cursor csr_role_templates is
807: Select role_template_id,object_version_number
808: From pqh_role_templates
809: Where template_id = p_template_id;
810: --
811: l_object_version_number pqh_role_templates.object_version_number%type;
812: --

Line 811: l_object_version_number pqh_role_templates.object_version_number%type;

807: Select role_template_id,object_version_number
808: From pqh_role_templates
809: Where template_id = p_template_id;
810: --
811: l_object_version_number pqh_role_templates.object_version_number%type;
812: --
813: Begin
814: --
815: hr_utility.set_location('Entering:'||l_proc, 5);

Line 821: pqh_role_templates_api.update_role_template(

817: For rec in csr_role_templates loop
818: --
819: l_object_version_number := rec.object_version_number;
820: --
821: pqh_role_templates_api.update_role_template(
822: p_validate => false
823: ,p_role_template_id => rec.role_template_id
824: ,p_enable_flag => 'N'
825: ,p_object_version_number => l_object_version_number