1 PACKAGE HR_RO_CONTACT_REL_VAL AUTHID CURRENT_USER AS
2 /* $Header: perocnrl.pkh 120.0.12020000.3 2013/05/10 08:44:23 kbajaj noship $ */
3 PROCEDURE create_ro_contact_person
4 (p_last_name IN varchar2
5 ,p_first_name IN varchar2
6 ,p_date_of_birth IN date
7 ,p_national_identifier IN varchar2
8 ,p_business_group_id IN number
9 ,p_sex IN varchar2
10 ,p_person_type_id IN number
11 ,p_country_of_birth IN varchar2
12 ,p_region_of_birth IN varchar2
13 ,p_per_information1 IN varchar2
14 ,p_per_information2 IN varchar2);
15
16 PROCEDURE create_ro_contact_rel
17 (p_first_name IN varchar2
18 ,p_date_of_birth IN date
19 ,p_national_identifier IN varchar2
20 ,p_business_group_id IN number
21 ,p_sex IN varchar2
22 ,p_date_start IN date
23 ,p_date_end IN date
24 ,p_contact_person_id IN number
25 ,p_person_id IN number
26 ,p_contact_type IN varchar2
27 ,p_person_type_id NUMBER);
28
29
30 PROCEDURE update_ro_contact_rel
31 (p_contact_relationship_id IN number
32 ,p_date_start IN date
33 ,p_date_end IN date
34 ,p_contact_type IN varchar2);
35
36 END HR_RO_CONTACT_REL_VAL;