APPS.PQH_TEM_BUS dependencies on PQH_REF_TEMPLATES

Line 174: from pqh_ref_templates a

170: where a.template_id = p_template_id;
171: --
172: cursor c2 is
173: select null
174: from pqh_ref_templates a
175: where a.base_template_id = p_template_id;
176: --
177: Begin
178: --

Line 872: from pqh_ref_templates a

868: l_dummy varchar2(1);
869: --
870: Cursor c1 is
871: select null
872: from pqh_ref_templates a
873: where a.parent_template_id = p_template_id
874: and a.reference_type_cd = 'REFERENCE';
875: Begin
876: --

Line 919: hr_utility.set_message(8302,'PQH_REF_TEMPLATES_EXIST');

915: open c1;
916: fetch c1 into l_dummy;
917: if c1%found then
918: Close c1;
919: hr_utility.set_message(8302,'PQH_REF_TEMPLATES_EXIST');
920: hr_utility.raise_error;
921: End if;
922: close c1;
923: -- Raise error if reference records exist in pqh_ref_templates

Line 923: -- Raise error if reference records exist in pqh_ref_templates

919: hr_utility.set_message(8302,'PQH_REF_TEMPLATES_EXIST');
920: hr_utility.raise_error;
921: End if;
922: close c1;
923: -- Raise error if reference records exist in pqh_ref_templates
924: --
925: --
926: End if;
927: --

Line 1470: Select null from pqh_ref_templates

1466: edit_flag IS NOT NULL OR
1467: required_flag IS NOT NULL);
1468: --
1469: Cursor csr_copy_exist is
1470: Select null from pqh_ref_templates
1471: Where parent_template_id = p_template_id
1472: and reference_type_cd = 'COPY';
1473: --
1474: Cursor csr_ref_exist is

Line 1475: Select null from pqh_ref_templates

1471: Where parent_template_id = p_template_id
1472: and reference_type_cd = 'COPY';
1473: --
1474: Cursor csr_ref_exist is
1475: Select null from pqh_ref_templates
1476: Where parent_template_id = p_template_id
1477: and reference_type_cd = 'REFERENCE';
1478: --
1479: --