1 PACKAGE pay_ca_payreg_extract_data_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycaprpd.pkh 115.2 2001/12/20 00:57:47 pkm ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1996 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 : pay_ca_payreg_extract_data_pkg
21
22 Description : Package for the Payment Report.
23 The package can be used by the users to add columns
24 which they want on the report.
25
26 The data is printed at the end of the report for
27 each assignment. The package is passed the following
28 paramaters to the report which can be used for
29 retreiving data.
30 - assignment_id
31 - person_id
32 - assignment_action_id
33 - effective_date from pay_payroll_actions
34
35
36 Change List
37 -----------
38 Date Name Vers Bug No Description
39 ---- ---- ------ ------- -----------
40 10-OCT-2001 SSattini 115.0 Created.
41 20-NOV-2001 SSattini 115.1 Added dbdrv line.
42 20-DEC-2001 SSattini 115.2 Added checkfile line.
43
44 */
45
46 TYPE tab_char IS TABLE OF varchar(100)
47 INDEX BY BINARY_INTEGER;
48
49 TYPE tab_number IS TABLE OF number(12,2)
50 INDEX BY BINARY_INTEGER;
51
52
53 /***********************************************************
54 ** PL/SQL table used for printing data for Payment Register
55 ** Report.
56 ***********************************************************/
57 ltt_payment_extract_label tab_char;
58 ltt_payment_extract_data tab_number;
59
60 /***********************************************************
61 ** Procedure called from the main Reports package:
62 ** pay_ca_payreg_extract_pkg.
63 ** PL/SQL table LTT_PAYMENT_EXTRACT_LABEL is first read to
64 ** print all the labels and then the PL/SQL table
65 ** LTT_PAYMENT_EXTRACT_DATA is read to print the data.
66 ** The PL/SQL table should be refreshed for each employee
67 ** assignment record.
68 ***********************************************************/
69 PROCEDURE populate_table (p_assignment_id in number
70 ,p_person_id in number
71 ,p_assignment_action_id in number
72 ,p_effective_date in date
73 );
74
75 END pay_ca_payreg_extract_data_pkg;
[Home] [Help]