1 PACKAGE pay_element_extract_pkg AS
2 /* $Header: pyelerep.pkh 120.0.12010000.1 2008/07/27 22:30:57 appldev ship $ */
3 --
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1996 Oracle Corporation. *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation, *
17 * 500 Oracle Parkway, Redwood City, CA, 94065. *
18 * *
19 ******************************************************************
20
21 Name : pay_element_extract_pkg
22
23 Description : Package for the Elements Reports. The package
24 generated the output file in the specified user
25 format. The current formats supported are
26 - HTML
27 - CSV
28
29 Change List
30 -----------
31 Date Name Vers Bug No Description
32 ---- ---- ------ ------- -----------
33 04-AUG-2000 ahanda 115.0 Created.
34 14-SEP-2000 ahanda 115.1 1407284 Corrected package name.
35 04-DEC-2002 dsaxby 115.3 2692195 Nocopy changes.
36 19-JUL-2004 schauhan 115.4 3731178 Added function get_element_type_id which returns
37 element_type_id from which Pay value is calculated.
38 19-JUL-2004 schauhan 115.5 3731178 Reverted back to version 115.3
39 10-MAR-2005 rajeesha 115.6 4214739 Status added in TYPE rec_element
40 */
41
42 PROCEDURE element_extract
43 (errbuf out nocopy varchar2
44 ,retcode out nocopy number
45 ,p_business_group_id in number
46 ,p_start_date in varchar2
47 ,p_end_date in varchar2
48 ,p_selection_criteria in varchar2
49 ,p_is_ele_set in varchar2
50 ,p_element_set_id in number
51 ,p_is_ele_class in varchar2
52 ,p_element_classification_id in number
53 ,p_is_ele in varchar2
54 ,p_element_type_id in number
55 ,p_payroll_id in number
56 ,p_consolidation_set_id in number
57 ,p_tax_unit_id in number
58 ,p_organization_id in number
59 ,p_location_id in number
60 ,p_person_id in number
61 ,p_assignment_set_id in number
62 ,p_output_file_type in varchar2
63 );
64
65
66 /**************************************************************
67 ** PL/SQL table of records to store element name and value
68 ***************************************************************/
69 TYPE rec_element IS RECORD (element_name varchar(100),
70 value number,
71 Status varchar2(2));
72 TYPE tab_element IS TABLE OF rec_element INDEX BY BINARY_INTEGER;
73
74 end pay_element_extract_pkg;