APPS.PER_GRD_BUS dependencies on PER_GRADES

Line 30: , per_grades grd

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_grades grd
31: where grd.grade_id = p_grade_id
32: and pbg.business_group_id = grd.business_group_id;
33: --
34: -- Declare local variables

Line 94: , per_grades grd

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_grades grd
95: where grd.grade_id = p_grade_id
96: and pbg.business_group_id = grd.business_group_id;
97: --
98: -- Declare local variables

Line 456: per_grd_shd.constraint_error('PER_GRADES_PK');

452: <> per_grd_shd.g_old_rec.grade_id) then
453: --
454: -- raise error as PK has changed
455: --
456: per_grd_shd.constraint_error('PER_GRADES_PK');
457: --
458: elsif not l_api_updating then
459: --
460: -- check if PK is null

Line 466: per_grd_shd.constraint_error('PER_GRADES_PK');

462: if p_grade_id is not null then
463: --
464: -- raise error as PK is not null
465: --
466: per_grd_shd.constraint_error('PER_GRADES_PK');
467: --
468: end if;
469: --
470: end if;

Line 516: from per_grades

512: --
513: --
514: cursor csr_unique_short_name is
515: select 'x'
516: from per_grades
517: where p_short_name is not null
518: and upper(short_name) = upper(p_short_name)
519: and business_group_id + 0 = p_business_group_id;
520:

Line 523: from per_grades grd

519: and business_group_id + 0 = p_business_group_id;
520:
521: cursor csr_update_short_name is
522: select 'x'
523: from per_grades grd
524: where p_short_name is not null
525: and grd.grade_id = p_grade_id
526: and exists
527: (select *

Line 528: from per_grades

524: where p_short_name is not null
525: and grd.grade_id = p_grade_id
526: and exists
527: (select *
528: from per_grades
529: where business_group_id = grd.business_group_id
530: and upper(short_name) = upper(p_short_name));
531:
532: --

Line 634: from per_grades

630: where grade_definition_id = p_grade_definition_id;
631: --
632: cursor csr_unique_grade_def is
633: select 'x'
634: from per_grades
635: where grade_definition_id = p_grade_definition_id
636: and business_group_id + 0 = p_business_group_id;
637: --
638: begin

Line 667: per_grd_shd.constraint_error(p_constraint_name => 'PER_GRADES_FK2');

663: open csr_grade_def;
664: fetch csr_grade_def into l_exists;
665: if csr_grade_def%notfound then
666: close csr_grade_def;
667: per_grd_shd.constraint_error(p_constraint_name => 'PER_GRADES_FK2');
668: end if;
669: close csr_grade_def;
670: --
671: hr_utility.set_location(l_proc, 5);

Line 811: FROM per_grades grd

807: l_exists VARCHAR2(2);
808:
809: cursor c_all_seq IS
810: SELECT 'x'
811: FROM per_grades grd
812: WHERE grd.business_group_id = p_business_group_id
813: AND grd.sequence = p_sequence
814: ;
815: --

Line 1075: ,p_descflex_name => 'PER_GRADES'

1071: -- b) During insert.
1072: --
1073: hr_dflex_utility.ins_or_upd_descflex_attribs
1074: (p_appl_short_name => 'PER'
1075: ,p_descflex_name => 'PER_GRADES'
1076: ,p_attribute_category => p_rec.attribute_category
1077: ,p_attribute1_name => 'ATTRIBUTE1'
1078: ,p_attribute1_value => p_rec.attribute1
1079: ,p_attribute2_name => 'ATTRIBUTE2'