1 PACKAGE pay_au_retro_upgrade AUTHID CURRENT_USER AS
2 /* $Header: payauretroupg.pkh 120.2.12020000.1 2012/06/28 16:21:51 appldev ship $ */
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 Name : pay_au_retro_upgrade
24
25 Description : This procedure is used to upgrade elements for
26 Enhanced Retropay.
27
28 Change List
29 -----------
30 Date Name Vers Bug No Description
31 ----------- ---------- ------ -------- -----------------------------------
32 05-JAN-2006 ksingla 120.0 Intial Version
33
34 ================================================================================================
35 11i Versions - Package backported to 11i - Bug 5731490
36 ================================================================================================
37 22-Dec-2006 avenkatk 115.0 5731490 Added Function - set_retro_leg_rule
38 Procedure - create_enhanced_retro_defn
39 04-Jan-2007 avenkakt 115.1 5731490 Added Procedure - set_enh_retro_request_group
40 - enable_au_enhanced_retro
41 10-Mar-2010 pmatamsr 115.2 9299082 Added Procedure - enable_au_retro_overlap
42
43 */
44
45 PROCEDURE qualify_element(p_object_id in varchar2
46 ,p_qualified out nocopy varchar2);
47
48 PROCEDURE upgrade_element(p_element_type_id in number);
49
50 FUNCTION set_retro_leg_rule(p_calling_form in varchar2)
51 RETURN varchar2;
52
53 PROCEDURE create_enhanced_retro_defn;
54
55 PROCEDURE set_enh_retro_request_group;
56
57 PROCEDURE enable_au_enhanced_retro(
58 errbuf OUT NOCOPY VARCHAR2
59 ,retcode OUT NOCOPY NUMBER
60 );
61
62 PROCEDURE enable_au_retro_overlap(
63 errbuf OUT NOCOPY VARCHAR2
64 ,retcode OUT NOCOPY NUMBER
65 );
66 END pay_au_retro_upgrade;