DBA Data[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