DBA Data[Home] [Help]

PACKAGE: APPS.PAY_GB_P11D_MILEAGE_EXTRACT

Source


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;