[Home] [Help]
Skip to content
PACKAGE: APPS.HR_RO_PERSON_VALIDATE
Source
1 package hr_ro_person_validate AUTHID CURRENT_USER as
2 /* $Header: perropval.pkh 120.0.12020000.3 2013/04/18 13:23:10 ssanjays noship $ */
3
4 -- For create
5 PROCEDURE validate_ro_employee_create(
6 -- p_person_id Number,
7 p_business_group_id NUMBER,
8 p_first_name VARCHAR2,
9 p_hire_date DATE,
10 p_date_of_birth DATE,
11 p_sex VARCHAR2, -- gender
12 p_national_identifier VARCHAR2,
13 p_country_of_birth VARCHAR2,
14 p_region_of_birth VARCHAR2,
15 p_town_of_birth VARCHAR2,
16 p_per_information1 VARCHAR2, -- residence
17 p_per_information2 VARCHAR2, -- citizenship
18 p_per_information4 VARCHAR2 -- previous npc/frn
19 );
20 --For Update
21 PROCEDURE validate_ro_employee_update(
22 p_person_id NUMBER,
23 --p_business_group_id Number,
24 p_first_name VARCHAR2,
25 --p_hire_date DATE,
26 p_date_of_birth DATE,
27 p_sex VARCHAR2, -- gender
28 p_national_identifier VARCHAR2,
29 p_country_of_birth VARCHAR2,
30 p_region_of_birth VARCHAR2,
31 p_town_of_birth VARCHAR2,
32 p_per_information1 VARCHAR2, -- residence
33 p_per_information2 VARCHAR2, -- citizenship
34 p_per_information4 VARCHAR2, -- previous npc/frn
35 p_effective_date DATE );
36 end hr_ro_person_validate;
37