1 package pay_ca_rl1_reg as
2 /* $Header: pycarrrg.pkh 120.0 2005/05/29 03:44:26 appldev noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation UK Ltd, *
18 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19 * England. *
20 * *
21 ******************************************************************
22
23 Change List
24 -----------
25 Date Name Vers Bug No Description
26 ----------- ---------- ----- ------- -----------------------------------
27 06-JAn-2000 mmukherj 110.0 Created.
28 26-Dec-2001 vpandya 115.1 Added function get_rl1_message and
29 dbdrv lines.
30 08-Jan-2002 vpandya 115.2 Added one more parameter p_hire_dt
31 in the function get_rl1_message.
32 16-Aug-2002 vpandya 115.3 Added parameter p_termination_dt
33 in the function get_rl1_message.
34 06-Nov-2002 vpandya 115.4 Added function get_primary_address
35 and Record type PrimaryAddress.
36 06-Nov-2002 vpandya 115.5 Added address_line_5 in the
37 PrimaryAddress record type to get
38 country.
39 08-Nov-2002 vpandya 115.6 Added address_line_6 which returns
40 Country Name where as line 5 returns
41 Country Code.
42 02-DEC-2002 vpandya 115.7 Added nocopy with out parameter
43 as per GSCC.
44 03-DEC-2002 vpandya 115.8 Modified structure PrimaryAddress
45 added city, province and postal code
46 03-SEP-2004 vpandya 115.9 Added get_label function to fix
47 NLS bug#3810959.
48 --
49 */
50 procedure range_cursor ( pactid in number,
51 sqlstr out nocopy varchar2
52 );
53 procedure action_creation ( pactid in number,
54 stperson in number,
55 endperson in number,
56 chunk in number
57 );
58 procedure sort_action ( payactid in varchar2,
59 sqlstr in out nocopy varchar2,
60 len out nocopy number
61 );
62 function get_parameter(name in varchar2,
63 parameter_list varchar2) return varchar2;
64 pragma restrict_references(get_parameter, WNDS, WNPS);
65 --
66 function get_rl1_message(p_tax_year in varchar2,
67 p_emp_dob in varchar2,
68 p_hire_dt in varchar2,
69 p_termination_dt in varchar2) return varchar2;
70 --
71 /* Get Primary Address */
72 /* Address lines 1,2,3 are normal address lines */
73 /* Address Line 4 = City + Province Code + Postal Code */
74 /* Address Line 5 = Country Code */
75 /* Address Line 6 = Country Name */
76 /* Address Line 7 = Town or City */
77 /* Address Line 8 = Province Code */
78 /* Address Line 9 = Postal Code */
79
80 TYPE PrimaryAddress IS RECORD (
81 addr_line_1 varchar2(240) := NULL,
82 addr_line_2 varchar2(240) := NULL,
83 addr_line_3 varchar2(240) := NULL,
84 addr_line_4 varchar2(240) := NULL,
85 addr_line_5 varchar2(240) := NULL,
86 addr_line_6 varchar2(240) := NULL,
87 city varchar2(240) := NULL,
88 province varchar2(240) := NULL,
89 postal_code varchar2(240) := NULL);
90
91 function get_primary_address(p_person_id in Number,
92 p_effective_date in date
93 ) return PrimaryAddress;
94
95 function get_label(p_lookup_type in varchar2,
96 p_lookup_code in varchar2) return varchar2;
97
98 function get_label(p_lookup_type in varchar2,
99 p_lookup_code in varchar2,
100 p_person_language in varchar2 ) return varchar2;
101
102 end pay_ca_rl1_reg;