eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_EQT_BUS dependencies on PER_QUALIFICATION_TYPES

Line 36: per_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');

32: not l_api_updating then
33: --
34: -- raise error as PK not null
35: --
36: per_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');
37: --
38: end if;
39: --
40: -- check if qualification_type_id has been updated

Line 48: per_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');

44: and l_api_updating then
45: --
46: -- raise error as update is not allowed
47: --
48: per_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');
49: --
50: end if;
51: --
52: end if;

Line 214: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

210: -- Internal Table Handler Use Only.
211: --
212: --
213: procedure chk_qual_framework_id
214: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
215: ,p_qual_framework_id in per_qualification_types.qual_framework_id%TYPE
216: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
217: )
218: is

Line 215: ,p_qual_framework_id in per_qualification_types.qual_framework_id%TYPE

211: --
212: --
213: procedure chk_qual_framework_id
214: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
215: ,p_qual_framework_id in per_qualification_types.qual_framework_id%TYPE
216: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
217: )
218: is
219: --

Line 216: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

212: --
213: procedure chk_qual_framework_id
214: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
215: ,p_qual_framework_id in per_qualification_types.qual_framework_id%TYPE
216: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
217: )
218: is
219: --
220: --

Line 224: select 1 from per_qualification_types

220: --
221: -- declare cursor
222: --
223: cursor csr_qual_framework_id is
224: select 1 from per_qualification_types
225: where qual_framework_id = p_qual_framework_id;
226:
227: --
228: l_proc varchar2(72) := g_package||'chk_qual_framework_id';

Line 301: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

297: -- Internal Table Handler Use Only.
298: --
299: --
300: procedure chk_qualification_type
301: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
302: ,p_qualification_type in per_qualification_types.qualification_type%TYPE
303: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
304: ,p_effective_date in date
305: )

Line 302: ,p_qualification_type in per_qualification_types.qualification_type%TYPE

298: --
299: --
300: procedure chk_qualification_type
301: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
302: ,p_qualification_type in per_qualification_types.qualification_type%TYPE
303: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
304: ,p_effective_date in date
305: )
306: is

Line 303: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

299: --
300: procedure chk_qualification_type
301: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
302: ,p_qualification_type in per_qualification_types.qualification_type%TYPE
303: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
304: ,p_effective_date in date
305: )
306: is
307: --

Line 381: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

377: -- Internal Table Handler Use Only.
378: --
379: --
380: procedure chk_credit_type
381: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
382: ,p_credit_type in per_qualification_types.credit_type%TYPE
383: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
384: ,p_effective_date in date
385: )

Line 382: ,p_credit_type in per_qualification_types.credit_type%TYPE

378: --
379: --
380: procedure chk_credit_type
381: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
382: ,p_credit_type in per_qualification_types.credit_type%TYPE
383: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
384: ,p_effective_date in date
385: )
386: is

Line 383: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

379: --
380: procedure chk_credit_type
381: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
382: ,p_credit_type in per_qualification_types.credit_type%TYPE
383: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
384: ,p_effective_date in date
385: )
386: is
387: --

Line 462: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

458: -- Internal Table Handler Use Only.
459: --
460: --
461: procedure chk_level_type
462: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
463: ,p_level_type in per_qualification_types.level_type%TYPE
464: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
465: ,p_effective_date in date
466: )

Line 463: ,p_level_type in per_qualification_types.level_type%TYPE

459: --
460: --
461: procedure chk_level_type
462: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
463: ,p_level_type in per_qualification_types.level_type%TYPE
464: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
465: ,p_effective_date in date
466: )
467: is

Line 464: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

460: --
461: procedure chk_level_type
462: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
463: ,p_level_type in per_qualification_types.level_type%TYPE
464: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
465: ,p_effective_date in date
466: )
467: is
468: --

Line 543: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

539: -- Internal Table Handler Use Only.
540: --
541: --
542: procedure chk_level_number
543: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
544: ,p_level_number in per_qualification_types.level_number%TYPE
545: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
546: ,p_effective_date in date
547: )

Line 544: ,p_level_number in per_qualification_types.level_number%TYPE

540: --
541: --
542: procedure chk_level_number
543: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
544: ,p_level_number in per_qualification_types.level_number%TYPE
545: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
546: ,p_effective_date in date
547: )
548: is

Line 545: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

541: --
542: procedure chk_level_number
543: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
544: ,p_level_number in per_qualification_types.level_number%TYPE
545: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
546: ,p_effective_date in date
547: )
548: is
549: --

Line 624: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

620: -- Internal Table Handler Use Only.
621: --
622: --
623: procedure chk_field
624: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
625: ,p_field in per_qualification_types.field%TYPE
626: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
627: ,p_effective_date in date
628: )

Line 625: ,p_field in per_qualification_types.field%TYPE

621: --
622: --
623: procedure chk_field
624: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
625: ,p_field in per_qualification_types.field%TYPE
626: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
627: ,p_effective_date in date
628: )
629: is

Line 626: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

622: --
623: procedure chk_field
624: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
625: ,p_field in per_qualification_types.field%TYPE
626: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
627: ,p_effective_date in date
628: )
629: is
630: --

Line 705: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

701: -- Internal Table Handler Use Only.
702: --
703: --
704: procedure chk_sub_field
705: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
706: ,p_sub_field in per_qualification_types.sub_field%TYPE
707: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
708: ,p_effective_date in date
709: )

Line 706: ,p_sub_field in per_qualification_types.sub_field%TYPE

702: --
703: --
704: procedure chk_sub_field
705: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
706: ,p_sub_field in per_qualification_types.sub_field%TYPE
707: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
708: ,p_effective_date in date
709: )
710: is

Line 707: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

703: --
704: procedure chk_sub_field
705: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
706: ,p_sub_field in per_qualification_types.sub_field%TYPE
707: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
708: ,p_effective_date in date
709: )
710: is
711: --

Line 786: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

782: -- Internal Table Handler Use Only.
783: --
784: --
785: procedure chk_provider
786: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
787: ,p_provider in per_qualification_types.provider%TYPE
788: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
789: ,p_effective_date in date
790: )

Line 787: ,p_provider in per_qualification_types.provider%TYPE

783: --
784: --
785: procedure chk_provider
786: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
787: ,p_provider in per_qualification_types.provider%TYPE
788: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
789: ,p_effective_date in date
790: )
791: is

Line 788: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

784: --
785: procedure chk_provider
786: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
787: ,p_provider in per_qualification_types.provider%TYPE
788: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
789: ,p_effective_date in date
790: )
791: is
792: --

Line 867: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE

863: -- Internal Table Handler Use Only.
864: --
865: --
866: procedure chk_qa_organization
867: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
868: ,p_qa_organization in per_qualification_types.qa_organization%TYPE
869: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
870: ,p_effective_date in date
871: )

Line 868: ,p_qa_organization in per_qualification_types.qa_organization%TYPE

864: --
865: --
866: procedure chk_qa_organization
867: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
868: ,p_qa_organization in per_qualification_types.qa_organization%TYPE
869: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
870: ,p_effective_date in date
871: )
872: is

Line 869: ,p_object_version_number in per_qualification_types.object_version_number%TYPE

865: --
866: procedure chk_qa_organization
867: (p_qualification_type_id in per_qualification_types.qualification_type_id%TYPE
868: ,p_qa_organization in per_qualification_types.qa_organization%TYPE
869: ,p_object_version_number in per_qualification_types.object_version_number%TYPE
870: ,p_effective_date in date
871: )
872: is
873: --

Line 1006: ,p_descflex_name => 'PER_QUALIFICATION_TYPES'

1002: -- b) During insert.
1003: --
1004: hr_dflex_utility.ins_or_upd_descflex_attribs
1005: (p_appl_short_name => 'PER'
1006: ,p_descflex_name => 'PER_QUALIFICATION_TYPES'
1007: ,p_attribute_category => p_rec.attribute_category
1008: ,p_attribute1_name => 'ATTRIBUTE1'
1009: ,p_attribute1_value => p_rec.attribute1
1010: ,p_attribute2_name => 'ATTRIBUTE2'