PACKAGE: APPS.HR_NI_CHK_PKG

Source

1 PACKAGE hr_ni_chk_pkg AUTHID CURRENT_USER AS
2 /* $Header: penichk.pkh 120.0.12000000.2 2007/03/29 12:50:08 ghshanka ship $ */
3 /*
4  Name        : hr_ni_chk_pkg  (HEADER)
5 */
6 -- ------------------- validate_national_identifier -----------------------
7 --
8 -- Pass in national identifier and validate both construct (dependent on
9 -- the legislation of the business group) and uniqueness within business
10 -- group
11 --
12 FUNCTION validate_national_identifier
13 ( p_national_identifier    VARCHAR2,
14   p_birth_date             DATE,
15   p_gender                 VARCHAR2,
16   p_business_group_id      NUMBER,
17   p_session_date           DATE
18      ) RETURN VARCHAR2;
19 --
20 FUNCTION validate_national_identifier
21 ( p_national_identifier     VARCHAR2,
22   p_birth_date              DATE,
23   p_gender                  VARCHAR2,
24   p_event                   VARCHAR2 default 'WHEN-VALIDATE-RECORD',
25   p_person_id               NUMBER,
26   p_business_group_id       NUMBER,
27   p_legislation_code        VARCHAR2,
28   p_session_date            DATE,
29   p_warning             OUT NOCOPY VARCHAR2,
30   p_person_type_id          NUMBER default NULL,
31   p_region_of_birth         VARCHAR2 default NULL,
32   p_country_of_birth        VARCHAR2 default NULL
33       ) RETURN VARCHAR2;
34 --
35 --
36 -- added a new parameter p_nationality
37 FUNCTION validate_national_identifier
38 ( p_national_identifier     VARCHAR2,
39   p_birth_date              DATE,
40   p_gender                  VARCHAR2,
41   p_event                   VARCHAR2 default 'WHEN-VALIDATE-RECORD',
42   p_person_id               NUMBER,
43   p_business_group_id       NUMBER,
44   p_legislation_code        VARCHAR2,
45   p_session_date            DATE,
46   p_warning             OUT NOCOPY VARCHAR2,
47   p_person_type_id          NUMBER default NULL,
48   p_region_of_birth         VARCHAR2 default NULL,
49   p_country_of_birth        VARCHAR2 default NULL,
50   p_nationality            VARCHAR2  -- added for the bug 5961277
51       ) RETURN VARCHAR2 ;
52 
53 FUNCTION chk_nat_id_format
54 ( p_national_identifier VARCHAR2,
55   p_format_string       VARCHAR2) RETURN VARCHAR2;
56 --
57 procedure check_ni_unique
58 ( p_national_identifier       VARCHAR2,
59   p_person_id                 NUMBER,
60   p_business_group_id         NUMBER,
61   p_raise_error_or_warning    VARCHAR2);
62 --
63 end hr_ni_chk_pkg;