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_SHA_BUS dependencies on STANDARD

Line 220: -- |----------------------< chk_standard_holiday_id >-------------------------|

216: --
217: end chk_person_id;
218: --
219: -- ----------------------------------------------------------------------------
220: -- |----------------------< chk_standard_holiday_id >-------------------------|
221: -- ----------------------------------------------------------------------------
222: --
223: -- Descriiption :
224: -- STANDARD_HOLIDAY_ID is mandatory and must exist in

Line 224: -- STANDARD_HOLIDAY_ID is mandatory and must exist in

220: -- |----------------------< chk_standard_holiday_id >-------------------------|
221: -- ----------------------------------------------------------------------------
222: --
223: -- Descriiption :
224: -- STANDARD_HOLIDAY_ID is mandatory and must exist in
225: -- PER_STANDARD_HOLIDAYS
226: --
227: -- Pre-conditions :
228: -- None

Line 225: -- PER_STANDARD_HOLIDAYS

221: -- ----------------------------------------------------------------------------
222: --
223: -- Descriiption :
224: -- STANDARD_HOLIDAY_ID is mandatory and must exist in
225: -- PER_STANDARD_HOLIDAYS
226: --
227: -- Pre-conditions :
228: -- None
229: --

Line 232: -- p_standard_holiday_id

228: -- None
229: --
230: -- In Arguments :
231: -- p_std_holiday_absences_id
232: -- p_standard_holiday_id
233: -- p_actual_date_taken
234: -- p_expired
235: -- p_object_version_number
236: --

Line 250: procedure chk_standard_holiday_id

246: --
247: -- {End of Comments}
248: --
249: -- ---------------------------------------------------------------------------
250: procedure chk_standard_holiday_id
251: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
253: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
254: ,p_expired in per_std_holiday_absences.expired%TYPE

Line 252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE

248: --
249: -- ---------------------------------------------------------------------------
250: procedure chk_standard_holiday_id
251: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
253: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
254: ,p_expired in per_std_holiday_absences.expired%TYPE
255: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
256: ) is

Line 258: l_proc varchar2(72) := g_package||'chk_standard_holiday_id';

254: ,p_expired in per_std_holiday_absences.expired%TYPE
255: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'chk_standard_holiday_id';
259: l_dummy number;
260: l_api_updating boolean;
261: --
262: CURSOR csr_valid_std_hol_id IS

Line 263: SELECT sth.standard_holiday_id

259: l_dummy number;
260: l_api_updating boolean;
261: --
262: CURSOR csr_valid_std_hol_id IS
263: SELECT sth.standard_holiday_id
264: FROM per_standard_holidays sth
265: WHERE sth.standard_holiday_id = p_standard_holiday_id;
266: begin
267: hr_utility.set_location('Entering:'||l_proc, 10);

Line 264: FROM per_standard_holidays sth

260: l_api_updating boolean;
261: --
262: CURSOR csr_valid_std_hol_id IS
263: SELECT sth.standard_holiday_id
264: FROM per_standard_holidays sth
265: WHERE sth.standard_holiday_id = p_standard_holiday_id;
266: begin
267: hr_utility.set_location('Entering:'||l_proc, 10);
268: --

Line 265: WHERE sth.standard_holiday_id = p_standard_holiday_id;

261: --
262: CURSOR csr_valid_std_hol_id IS
263: SELECT sth.standard_holiday_id
264: FROM per_standard_holidays sth
265: WHERE sth.standard_holiday_id = p_standard_holiday_id;
266: begin
267: hr_utility.set_location('Entering:'||l_proc, 10);
268: --
269: -- Check mandatory parameters have been set

Line 273: ,p_argument => 'standard_holiday_id'

269: -- Check mandatory parameters have been set
270: --
271: hr_api.mandatory_arg_error
272: (p_api_name => l_proc
273: ,p_argument => 'standard_holiday_id'
274: ,p_argument_value => p_standard_holiday_id
275: );
276: --
277: -- Check that the STANDARD_HOLIDAY_ID exists in PER_STANDARD_HOLIDAYS

Line 274: ,p_argument_value => p_standard_holiday_id

270: --
271: hr_api.mandatory_arg_error
272: (p_api_name => l_proc
273: ,p_argument => 'standard_holiday_id'
274: ,p_argument_value => p_standard_holiday_id
275: );
276: --
277: -- Check that the STANDARD_HOLIDAY_ID exists in PER_STANDARD_HOLIDAYS
278: --

Line 277: -- Check that the STANDARD_HOLIDAY_ID exists in PER_STANDARD_HOLIDAYS

273: ,p_argument => 'standard_holiday_id'
274: ,p_argument_value => p_standard_holiday_id
275: );
276: --
277: -- Check that the STANDARD_HOLIDAY_ID exists in PER_STANDARD_HOLIDAYS
278: --
279: open csr_valid_std_hol_id;
280: fetch csr_valid_std_hol_id into l_dummy;
281: if (csr_valid_std_hol_id%NOTFOUND) then

Line 295: per_sha_shd.g_old_rec.standard_holiday_id <> p_standard_holiday_id) then

291: (p_std_holiday_absences_id => p_std_holiday_absences_id,
292: p_object_version_number => p_object_version_number);
293: --
294: if (l_api_updating AND
295: per_sha_shd.g_old_rec.standard_holiday_id <> p_standard_holiday_id) then
296: if (p_actual_date_taken is not NULL) then
297: hr_utility.set_message(800,'PER_50028_SHA_HOL_UPDATE_ID');
298: hr_utility.raise_error;
299: elsif (p_expired = 'Y') then

Line 307: end chk_standard_holiday_id;

303: end if;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 3);
306: --
307: end chk_standard_holiday_id;
308: --
309: -- ----------------------------------------------------------------------------
310: -- |-----------------------< chk_actual_date_taken >--------------------------|
311: -- ----------------------------------------------------------------------------

Line 315: -- a) the ACTUAL_DATE_TAKEN does not overlap with the Standard Holidays

311: -- ----------------------------------------------------------------------------
312: --
313: -- Descriiption :
314: -- This check procedure ensures that
315: -- a) the ACTUAL_DATE_TAKEN does not overlap with the Standard Holidays
316: -- defined for the Legislation/Sub-Legislation.
317: -- b) the ACTUAL_DATE_TAKEN cannot be updated if the expired flag is set.
318: --
319: -- Pre-conditions :

Line 355: SELECT NVL(sth.standard_holiday_id,99)

351: l_dummy number(15);
352: l_api_updating boolean;
353: --
354: CURSOR csr_valid_actual_date_taken IS
355: SELECT NVL(sth.standard_holiday_id,99)
356: FROM per_standard_holidays sth,
357: per_people_f per,
358: per_business_groups bus
359: WHERE per.person_id = p_person_id

Line 356: FROM per_standard_holidays sth,

352: l_api_updating boolean;
353: --
354: CURSOR csr_valid_actual_date_taken IS
355: SELECT NVL(sth.standard_holiday_id,99)
356: FROM per_standard_holidays sth,
357: per_people_f per,
358: per_business_groups bus
359: WHERE per.person_id = p_person_id
360: AND p_actual_date_taken BETWEEN per.effective_start_date

Line 390: -- Standard Holidays

386: hr_utility.raise_error;
387: end if;
388: --
389: -- Check that the ACTUAL_DATE_TAKEN does not overlap with any of the
390: -- Standard Holidays
391: --
392: open csr_valid_actual_date_taken;
393: fetch csr_valid_actual_date_taken into l_dummy;
394: if (csr_valid_actual_date_taken%FOUND) then

Line 628: -- Validate Standard Holiday Dates not taken

624: hr_api.set_security_group_id(p_security_group_id => 0);
625: --
626: hr_utility.set_location('Entering:'||l_proc, 7);
627: --
628: -- Validate Standard Holiday Dates not taken
629: --
630: chk_date_not_taken
631: (p_rec.std_holiday_absences_id,
632: p_rec.date_not_taken,

Line 644: -- Validate Standard Holiday Id

640: (p_rec.std_holiday_absences_id,
641: p_rec.person_id,
642: p_rec.date_not_taken);
643: --
644: -- Validate Standard Holiday Id
645: --
646: chk_standard_holiday_id
647: (p_rec.std_holiday_absences_id,
648: p_rec.standard_holiday_id,

Line 646: chk_standard_holiday_id

642: p_rec.date_not_taken);
643: --
644: -- Validate Standard Holiday Id
645: --
646: chk_standard_holiday_id
647: (p_rec.std_holiday_absences_id,
648: p_rec.standard_holiday_id,
649: p_rec.actual_date_taken,
650: p_rec.expired,

Line 648: p_rec.standard_holiday_id,

644: -- Validate Standard Holiday Id
645: --
646: chk_standard_holiday_id
647: (p_rec.std_holiday_absences_id,
648: p_rec.standard_holiday_id,
649: p_rec.actual_date_taken,
650: p_rec.expired,
651: p_rec.object_version_number);
652: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 701: -- Validate Standard Holiday Dates not taken

697: -- Check no non-updateable arguments have been updated
698: --
699: chk_non_updateable_args (p_rec => p_rec);
700: --
701: -- Validate Standard Holiday Dates not taken
702: --
703: chk_date_not_taken
704: (p_rec.std_holiday_absences_id,
705: p_rec.date_not_taken,

Line 710: -- Validate Standard Holiday Id

706: p_rec.actual_date_taken,
707: p_rec.expired,
708: p_rec.object_version_number);
709: --
710: -- Validate Standard Holiday Id
711: --
712: chk_standard_holiday_id
713: (p_rec.std_holiday_absences_id,
714: p_rec.standard_holiday_id,

Line 712: chk_standard_holiday_id

708: p_rec.object_version_number);
709: --
710: -- Validate Standard Holiday Id
711: --
712: chk_standard_holiday_id
713: (p_rec.std_holiday_absences_id,
714: p_rec.standard_holiday_id,
715: p_rec.actual_date_taken,
716: p_rec.expired,

Line 714: p_rec.standard_holiday_id,

710: -- Validate Standard Holiday Id
711: --
712: chk_standard_holiday_id
713: (p_rec.std_holiday_absences_id,
714: p_rec.standard_holiday_id,
715: p_rec.actual_date_taken,
716: p_rec.expired,
717: p_rec.object_version_number);
718: hr_utility.set_location(' Leaving:'||l_proc, 10);