DBA Data[Home] [Help]

APPS.HR_SE_VALIDATE_PKG dependencies on HR_API

Line 41: IF p_national_identifier IS NULL or p_national_identifier = hr_api.g_varchar2 THEN

37: END IF;
38:
39: END IF;
40:
41: IF p_national_identifier IS NULL or p_national_identifier = hr_api.g_varchar2 THEN
42:
43: l_field := hr_general.decode_lookup('SE_FORM_LABELS','PIN');
44:
45: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN

Line 1974: IF (p_scl_segment5 IS NOT NULL AND p_scl_segment5 <> hr_api.g_varchar2)

1970: --
1971: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1972: --
1973:
1974: IF (p_scl_segment5 IS NOT NULL AND p_scl_segment5 <> hr_api.g_varchar2)
1975: AND (p_scl_segment6 IS NOT NULL AND p_scl_segment6 <> hr_api.g_varchar2) THEN
1976: IF fnd_date.canonical_to_date(p_scl_segment5) >= fnd_date.canonical_to_date(p_scl_segment6) THEN
1977: RAISE VALID_NOTIFY_DATE ;
1978: END IF;

Line 1975: AND (p_scl_segment6 IS NOT NULL AND p_scl_segment6 <> hr_api.g_varchar2) THEN

1971: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1972: --
1973:
1974: IF (p_scl_segment5 IS NOT NULL AND p_scl_segment5 <> hr_api.g_varchar2)
1975: AND (p_scl_segment6 IS NOT NULL AND p_scl_segment6 <> hr_api.g_varchar2) THEN
1976: IF fnd_date.canonical_to_date(p_scl_segment5) >= fnd_date.canonical_to_date(p_scl_segment6) THEN
1977: RAISE VALID_NOTIFY_DATE ;
1978: END IF;
1979:

Line 2008: IF (p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2)

2004: --
2005: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
2006: --
2007:
2008: IF (p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2)
2009: AND (p_segment6 IS NOT NULL AND p_segment6 <> hr_api.g_varchar2) THEN
2010: IF fnd_date.canonical_to_date(p_segment5) >= fnd_date.canonical_to_date(p_segment6) THEN
2011: RAISE VALID_NOTIFY_DATE ;
2012: END IF;

Line 2009: AND (p_segment6 IS NOT NULL AND p_segment6 <> hr_api.g_varchar2) THEN

2005: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
2006: --
2007:
2008: IF (p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2)
2009: AND (p_segment6 IS NOT NULL AND p_segment6 <> hr_api.g_varchar2) THEN
2010: IF fnd_date.canonical_to_date(p_segment5) >= fnd_date.canonical_to_date(p_segment6) THEN
2011: RAISE VALID_NOTIFY_DATE ;
2012: END IF;
2013: