PACKAGE: APPS.PERFRPHR

Source

1 PACKAGE PERFRPHR AUTHID CURRENT_USER AS
2 /* $Header: perfrphr.pkh 120.0.12000000.1 2007/01/22 03:14:22 appldev noship $ */
3 
4 FUNCTION get_emp_total (p_effective_date    IN DATE,
5                         p_est_id            IN NUMBER   DEFAULT NULL,
6                         p_ent_id            IN NUMBER   DEFAULT NULL,
7                         p_sex               IN VARCHAR2 DEFAULT NULL,
8                         p_udt_column        IN VARCHAR2,
9                         p_include_suspended IN VARCHAR2 DEFAULT 'N') RETURN NUMBER;
10 
11 PROCEDURE run_pre_hire (errbuf              OUT NOCOPY VARCHAR2,
12                         retcode             OUT NOCOPY NUMBER,
13                         p_business_group_id IN NUMBER DEFAULT NULL,
14                         p_establishment_id  IN NUMBER DEFAULT NULL,
15                         p_person_id         IN NUMBER DEFAULT NULL,
16                         p_contact_name      IN VARCHAR2 DEFAULT NULL,
17                         p_contact_telephone IN VARCHAR2 DEFAULT NULL,
18                         p_fax               IN VARCHAR2 DEFAULT NULL,
19                         p_email_address     IN VARCHAR2 DEFAULT NULL,
20                         p_dads              IN VARCHAR2 DEFAULT NULL,
21                         p_pmf5              IN VARCHAR2 DEFAULT NULL,
22                      -- p_prem              IN VARCHAR2 DEFAULT NULL,
23                         p_date              IN VARCHAR2 DEFAULT NULL,
24                         p_batch             IN VARCHAR2 DEFAULT NULL,
25                         p_acknowledgement   IN VARCHAR2 DEFAULT NULL);
26 
27 /* Bug 4106045 */
28 FUNCTION convert_uppercase(p_input_string  varchar2)
29                            return varchar2;
30 /* Bug 4106045 */
31 
32 end PERFRPHR;