1 PACKAGE per_ca_emp_equity_pkg AS
2 /* $Header: perhrcaempequity.pkh 120.0 2006/05/25 06:37:33 ssmukher noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : per_ca_emp_equity_pkg
21
22 Description : This package is used for generating the employee.txt
23 promot.txt,term.txt and excep.txt tab delimited text
24 file for Employment Equity Report.
25
26 Change List
27 -----------
28 Date Name Vers Bug No Description
29 ----------- ---------- ------ ------- --------------------------
30 28-Apr-2005 ssmukher 115.0 Created.
31 01-Jul-2005 ssmukher 115.1 Modified the gscc error
32 ******************************************************************************/
33
34 l_counter number;
35
36 TYPE job_id_tab IS TABLE OF per_jobs.job_id%type
37 INDEX BY BINARY_INTEGER;
38
39 TYPE job_noc_tab IS TABLE OF per_jobs.job_information7%type
40 INDEX BY BINARY_INTEGER;
41
42 TYPE person_type_tab IS TABLE OF per_person_types.person_type_id%type
43 INDEX BY BINARY_INTEGER;
44
45 /* Procedure to generate the employee.txt file */
46 procedure employee_dtls (errbuf out nocopy varchar2,
47 retcode out nocopy number,
48 p_business_group_id in number,
49 p_year in varchar2,
50 p_naic_code in varchar2);
51 /* Procedure to generate the promot.txt file */
52 procedure emp_promotions (errbuf out nocopy varchar2,
53 retcode out nocopy number,
54 p_business_group_id in number,
55 p_year in varchar2,
56 p_naic_code in varchar2,
57 p_start_date in date,
58 p_end_date in date );
59
60 /* Procedure to print the list of terminated employee */
61 procedure count_term (errbuf out nocopy varchar2,
62 retcode out nocopy number,
63 p_business_group_id in number,
64 p_year in varchar2,
65 p_naic_code in varchar2);
66
67 /* Procedure to print the exception report for employee with incomplete details */
68 procedure excep_report (errbuf out nocopy varchar2,
69 retcode out nocopy number,
70 p_business_group_id in number,
71 p_year in varchar2,
72 p_naic_code in varchar2);
73
74 /* Function to check if the Job assigned to the employee exists or not */
75 function job_exists (p_job_id in number)
76 return varchar2 ;
77
78 /* Function to check if the Person type is a valid one */
79 function person_type_exists (p_person_type in number)
80 return varchar2;
81
82 end;