1 package pay_gb_p11d_mileage_extract AUTHID CURRENT_USER as
2 /* $Header: pygbmxpl.pkh 115.0 2003/04/30 08:31:57 gbutler noship $
3 ******************************************************************
4 * *
5 * Copyright (C) 2003 Oracle Corporation UK Ltd., *
6 * Reading, England. *
7 * *
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 UK Ltd, *
17 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
18 * England. *
19 * *
20 ******************************************************************
21
22 Name : pay_gb_p11d_mileage_extract
23
24 Description : This package contains functions and procedures to
25 create the extract file for P11d Mileage Claims
26
27 Uses :
28
29 Used By : P11d 2003 Mileage Claims Extract Process
30
31
32 Change List :
33
34 Version Date Author Description
35 ------- ----- -------- ----------------
36
37 115.0 14/4/03 GBUTLER Created
38
39 */
40
41 FUNCTION check_person_inclusion (p_assignment_id IN NUMBER) RETURN VARCHAR2;
42
43 FUNCTION post_process_rule(p_ext_rslt_id IN NUMBER) RETURN VARCHAR2;
44
45 FUNCTION ben_start_date (p_assignment_id IN NUMBER) RETURN VARCHAR2;
46
47 FUNCTION ben_end_date (p_assignment_id IN NUMBER) RETURN VARCHAR2;
48
49 FUNCTION mileage_balance (p_assignment_id IN NUMBER) RETURN VARCHAR2;
50
51 FUNCTION add_pass_balance (p_assignment_id IN NUMBER) RETURN VARCHAR2;
52
53 FUNCTION asg_start_date (p_assignment_id IN NUMBER) RETURN VARCHAR2;
54
55 FUNCTION asg_end_date (p_assignment_id IN NUMBER) RETURN VARCHAR2;
56
57
58
59 end pay_gb_p11d_mileage_extract;