APPS.PER_VGR_BUS dependencies on PER_GRADES

Line 22: -- Validates that a grade id exists in the table per_grades

18: -- |---------------------------< chk_grade_id >----------------------------|
19: -- ----------------------------------------------------------------------------
20: --
21: -- Description :
22: -- Validates that a grade id exists in the table per_grades
23: --
24: -- Validates that the business group id for the grade id is the same
25: -- as that for the valid grade.
26: -- Pre-conditions:

Line 33: -- If a row does exist in per_grades for the given grade id then

29: -- In Arguments :
30: -- p_grade_id
31: --
32: -- Post Success :
33: -- If a row does exist in per_grades for the given grade id then
34: -- processing continues
35: --
36: -- Post Failure :
37: -- If a row does not exist in per_grades for the given grade id then

Line 37: -- If a row does not exist in per_grades for the given grade id then

33: -- If a row does exist in per_grades for the given grade id then
34: -- processing continues
35: --
36: -- Post Failure :
37: -- If a row does not exist in per_grades for the given grade id then
38: -- an application error will be raised and processing is terminated
39: --
40: -- Access Status :
41: -- Internal Table Handler Use only.

Line 55: from per_grades gra

51: l_business_group_id number(15);
52: --
53: cursor csr_valid_gra is
54: select gra.business_group_id
55: from per_grades gra
56: where gra.grade_id = p_grade_id;
57: --
58: begin
59: hr_utility.set_location('Entering: '|| l_proc, 1);

Line 76: -- Check that the grade ID is linked to a valid grade on per_grades

72: p_argument_value => p_business_group_id
73: );
74: hr_utility.set_location(l_proc, 2);
75: --
76: -- Check that the grade ID is linked to a valid grade on per_grades
77: --
78: open csr_valid_gra;
79: fetch csr_valid_gra into l_business_group_id;
80: if csr_valid_gra%notfound then

Line 104: -- and date_to on per_grades for the grade_id.

100: -- Description :
101: -- Validates that date_from is less than or equal to date to (may be null)
102: --
103: -- Validates that date from must be within the range specified by date_from
104: -- and date_to on per_grades for the grade_id.
105: --
106: -- Validates that date from is equal to or later than the effective_date of
107: -- hr_positions_f for the position_id if it is not null.
108: --

Line 153: from per_grades gra

149: l_api_updating boolean;
150: --
151: cursor csr_chk_gra_dates is
152: select null
153: from per_grades gra
154: where gra.grade_id = p_grade_id
155: and p_date_from between gra.date_from
156: and nvl(gra.date_to, hr_api.g_eot);
157: --

Line 213: -- on per_grades for p_grade_id

209: end if;
210: hr_utility.set_location(l_proc, 3);
211: --
212: -- Check that date_from is within the range of the date_from and date_to
213: -- on per_grades for p_grade_id
214: --
215: open csr_chk_gra_dates;
216: fetch csr_chk_gra_dates into l_exists;
217: if csr_chk_gra_dates%notfound then

Line 554: -- and date_to on per_grades for the grade_id.

550: -- Description :
551: -- Validates that date_to is greater than or equal to date from
552: --
553: -- Validates that date to must be within the range specified by date_from
554: -- and date_to on per_grades for the grade_id.
555: --
556: -- Validates that date to is equal to or earlier than the effective_date of
557: -- hr_positions_f for the position_id if it is not null.
558: --

Line 602: from per_grades gra

598: l_api_updating boolean;
599: --
600: cursor csr_chk_gra_dates is
601: select null
602: from per_grades gra
603: where gra.grade_id = p_grade_id
604: and nvl(p_date_to, hr_api.g_eot) between gra.date_from
605: and nvl(gra.date_to, hr_api.g_eot);
606: --

Line 664: -- on per_grades for p_grade_id

660: end if;
661: hr_utility.set_location(l_proc, 3);
662: --
663: -- Check that date_to is within the range of the date_from and date_to
664: -- on per_grades for p_grade_id
665: --
666: open csr_chk_gra_dates;
667: fetch csr_chk_gra_dates into l_exists;
668: if csr_chk_gra_dates%notfound then