1 package pay_ca_rl2_reg as
2 /* $Header: pycarl2.pkh 120.0.12000000.1 2007/01/17 17:19:48 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 08-OCT-2002 ssouresr 115.0 Created.
28 30-DEC-2003 ssattini 115.1 3163968 Added get_label function
29 22-Jan-2004 ssattini 115.2 Added function get_primary_address
30 and Record type PrimaryAddress.
31 */
32
33 procedure range_cursor (pactid in number,
34 sqlstr out nocopy varchar2);
35
36 procedure action_creation (pactid in number,
37 stperson in number,
38 endperson in number,
39 chunk in number);
40
41 procedure sort_action (payactid in varchar2,
42 sqlstr in out nocopy varchar2,
43 len out nocopy number);
44
45 function get_parameter(name in varchar2,
46 parameter_list varchar2) return varchar2;
47
48 pragma restrict_references(get_parameter, WNDS, WNPS);
49
50 function get_label(p_lookup_type in varchar2,
51 p_lookup_code in varchar2) return varchar2;
52 --
53 /* Get Primary Address */
54 /* Address lines 1,2,3 are normal address lines */
55 /* Address Line 4 = City + Province Code + Postal Code */
56 /* Address Line 5 = Country Code */
57 /* Address Line 6 = Country Name */
58 /* Address Line 7 = Town or City */
59 /* Address Line 8 = Province Code */
60 /* Address Line 9 = Postal Code */
61
62 TYPE PrimaryAddress IS RECORD (
63 addr_line_1 varchar2(240) := NULL,
64 addr_line_2 varchar2(240) := NULL,
65 addr_line_3 varchar2(240) := NULL,
66 addr_line_4 varchar2(240) := NULL,
67 addr_line_5 varchar2(240) := NULL,
68 addr_line_6 varchar2(240) := NULL,
69 city varchar2(240) := NULL,
70 province varchar2(240) := NULL,
71 postal_code varchar2(240) := NULL);
72
73 function get_primary_address(p_person_id in Number,
74 p_effective_date in date
75 ) return PrimaryAddress;
76
77 end pay_ca_rl2_reg;