42: --
43: l_proc varchar2(72) := g_package||'val_info_type_y';
44: --
45: begin
46: hr_utility.set_location('Entering:'||l_proc, 1);
47: --
48: -- Enter procedure code here
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 2);
46: hr_utility.set_location('Entering:'||l_proc, 1);
47: --
48: -- Enter procedure code here
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 2);
51: end val_info_type_y;
52: -- ----------------------------------------------------------------------------
53: -- |--------------------------< val_info_type_x >------------------------------|
54: -- ----------------------------------------------------------------------------
84: --
85: l_proc varchar2(72) := g_package||'val_info_type_x';
86: --
87: begin
88: hr_utility.set_location('Entering:'||l_proc, 1);
89: --
90: -- Enter procedure code here
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 2);
88: hr_utility.set_location('Entering:'||l_proc, 1);
89: --
90: -- Enter procedure code here
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 2);
93: end val_info_type_x;
94: -- ----------------------------------------------------------------------------
95: -- |-------------------------------< ddf >-------------------------------------|
96: -- ----------------------------------------------------------------------------
175: and trunc(p_effective_date) between(effective_start_date) and
176: nvl(effective_end_date,p_effective_date);
177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: if ghr_utility.is_ghr = 'TRUE' then
182: /*
183: -- Check for value of reference field an then
177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: if ghr_utility.is_ghr = 'TRUE' then
182: /*
183: -- Check for value of reference field an then
184: -- call relevant validation procedure.
185: --
199: else
200: --
201: -- Reference field values is not supported
202: --
203: hr_utility.set_message(801, 'HR_7438_FLEX_INV_REF_FIELD_VAL');
204: hr_utility.raise_error;
205: end if;
206: else
207: --
200: --
201: -- Reference field values is not supported
202: --
203: hr_utility.set_message(801, 'HR_7438_FLEX_INV_REF_FIELD_VAL');
204: hr_utility.raise_error;
205: end if;
206: else
207: --
208: -- When the reference field is null, check
219: open c2(nvl(l_effective_date,sysdate));
220: fetch c2 into l_duty_station;
221: if c2%NOTFOUND then
222: close c2;
223: hr_utility.set_message(8301, 'GHR_38277_DUTY_STATION_NOT_FND');
224: hr_utility.raise_error;
225: else
226: close c2;
227: end if;
220: fetch c2 into l_duty_station;
221: if c2%NOTFOUND then
222: close c2;
223: hr_utility.set_message(8301, 'GHR_38277_DUTY_STATION_NOT_FND');
224: hr_utility.raise_error;
225: else
226: close c2;
227: end if;
228: elsif p_lei_information1 is not null then
289: --
290: /*
291: endif;
292: */
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294:
295: end if; -- ghr_utility.is_ghr
296: exception
297: when l_error then
291: endif;
292: */
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294:
295: end if; -- ghr_utility.is_ghr
296: exception
297: when l_error then
298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');
299: hr_utility.raise_error;
294:
295: end if; -- ghr_utility.is_ghr
296: exception
297: when l_error then
298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');
299: hr_utility.raise_error;
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301:
302: end ddf;
295: end if; -- ghr_utility.is_ghr
296: exception
297: when l_error then
298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');
299: hr_utility.raise_error;
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301:
302: end ddf;
303: --
296: exception
297: when l_error then
298: hr_utility.set_message(801, 'HR_7439_FLEX_INV_ATTRIBUTE_ARG');
299: hr_utility.raise_error;
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301:
302: end ddf;
303: --
304: end ghr_lei_flex_ddf;