DBA Data[Home] [Help]

APPS.HR_SE_VALIDATE_PKG dependencies on HR_API

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

41: /* 12628318 suppressed person number validation if employee is transferred via global deployement */
42: IF per_per_bus.g_global_transfer_in_process IS NULL
43: or per_per_bus.g_global_transfer_in_process = false THEN
44:
45: IF p_national_identifier IS NULL or p_national_identifier = hr_api.g_varchar2 THEN
46:
47: l_field := hr_general.decode_lookup('SE_FORM_LABELS','PIN');
48:
49: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') THEN

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

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

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

1976: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
1977: --
1978:
1979: IF (p_scl_segment5 IS NOT NULL AND p_scl_segment5 <> hr_api.g_varchar2)
1980: AND (p_scl_segment6 IS NOT NULL AND p_scl_segment6 <> hr_api.g_varchar2) THEN
1981: IF fnd_date.canonical_to_date(p_scl_segment5) >= fnd_date.canonical_to_date(p_scl_segment6) THEN
1982: RAISE VALID_NOTIFY_DATE ;
1983: END IF;
1984:

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

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

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

2010: IF hr_utility.chk_product_install('Oracle Human Resources', 'SE') THEN
2011: --
2012:
2013: IF (p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2)
2014: AND (p_segment6 IS NOT NULL AND p_segment6 <> hr_api.g_varchar2) THEN
2015: IF fnd_date.canonical_to_date(p_segment5) >= fnd_date.canonical_to_date(p_segment6) THEN
2016: RAISE VALID_NOTIFY_DATE ;
2017: END IF;
2018: