1 PACKAGE pay_element_extract_data_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyelerpd.pkh 120.0 2005/05/29 04:33:30 appldev noship $ */
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_data_pkg
22
23 Description : Package for the Elements Reports.
24 The package can be used by the users to add columns
25 which they want on the report.
26
27 The data is printed at the end of the report for
28 each assignment. The package is passed the following
29 paramaters to the report which can be used for
30 retreiving data.
31 - assignment_id
32 - person_id
33 - assignment_action_id
34 - effective_date from pay_payroll_actions
35
36
37 Change List
38 -----------
39 Date Name Vers Bug No Description
40 ---- ---- ------ ------- -----------
41 04-AUG-2000 ahanda 115.0 Created.
42
43 */
44
45 TYPE tab_char IS TABLE OF varchar(100)
46 INDEX BY BINARY_INTEGER;
47
48 TYPE tab_number IS TABLE OF number(12,2)
49 INDEX BY BINARY_INTEGER;
50
51
52 /***********************************************************
53 ** PL/SQL table used for printing data for Element Register
54 ** Report.
55 ***********************************************************/
56 ltt_element_extract_label tab_char;
57 ltt_element_extract_data tab_number;
58
59 /***********************************************************
60 ** Procedure called from the main Reports package:
61 ** pay_element_extract_pkg.
62 ** PL/SQL table LTT_ELEMENT_EXTRACT_LABEL is first read to
63 ** print all the labels and then the PL/SQL table
64 ** LTT_ELEMENT_EXTRACT_DATA is read to print the data.
65 ** The PL/SQL table should be refreshed for each employee
66 ** assignment record.
67 ***********************************************************/
68 PROCEDURE populate_table (p_assignment_id in number
69 ,p_person_id in number
70 ,p_assignment_action_id in number
71 ,p_effective_date in date
72 );
73
74 END pay_element_extract_data_pkg;