1 package pay_gb_p11d_mileage_extract AUTHID CURRENT_USER as
2 /* $Header: pygbmxpl.pkh 120.2 2011/01/25 06:27:33 krreddy ship $
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 Bug Description
35 ------- ----- -------- ----------- ----------------
36
37 115.0 14/4/03 GBUTLER Created
38 115.1 23/1/11 KRREDDY 9536332 Implemented the P11D Mileage Extract process
39 115.2 25/1/11 KRREDDY 9536332 Added nocopy hint for out parameters
40
41 */
42
43 FUNCTION check_person_inclusion (p_assignment_id IN NUMBER) RETURN VARCHAR2;
44
45 FUNCTION post_process_rule(p_ext_rslt_id IN NUMBER) RETURN VARCHAR2;
46
47 FUNCTION ben_start_date (p_assignment_id IN NUMBER) RETURN VARCHAR2;
48
49 FUNCTION ben_end_date (p_assignment_id IN NUMBER) RETURN VARCHAR2;
50
51 FUNCTION mileage_balance (p_assignment_id IN NUMBER) RETURN VARCHAR2;
52
53 function get_data_element_value (p_assignment_id in number
54 ,p_rule_parameter in varchar2) RETURN VARCHAR2;
55
56
57
58 FUNCTION add_pass_balance (p_assignment_id IN NUMBER) RETURN VARCHAR2;
59
60 FUNCTION asg_start_date (p_assignment_id IN NUMBER) RETURN VARCHAR2;
61
62 FUNCTION asg_end_date (p_assignment_id IN NUMBER) RETURN VARCHAR2;
63
64 function get_mil_claim_values (p_assignment_id in number
65 ,p_vehicle_type in varchar2
66 ,p_mileage_allowance_payments out nocopy varchar2
67 ,p_tax_deducted_payments out nocopy varchar2
68 ,p_business_miles out nocopy varchar2
69 ,p_taxable_payments out nocopy varchar2
70 ,p_passenger_payments out nocopy varchar2
71 ,p_passenger_business_miles out nocopy varchar2
72 ,p_taxable_passenger_payments out nocopy varchar2
73 )
74 return varchar2;
75 function get_bal_value (p_bal_string in varchar2
76 ,p_asg_act_id_ext in number
77 ,p_asg_act_id_tye in number)
78 return varchar2;
79
80 end pay_gb_p11d_mileage_extract;