[Home] [Help]
PACKAGE: APPS.PAY_GB_RTI
Source
1 PACKAGE PAY_GB_RTI AUTHID CURRENT_USER as
2 /* $Header: pygbrtia.pkh 120.4.12020000.2 2013/03/15 07:43:36 ssarap noship $ */
3 /*===========================================================================+
4 | Copyright (c) 1993 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +============================================================================
8 Name:
9 PAY_GB_RTI
10 Purpose:
11 It fetches the live data and archives it for RTI Processes.
12 This is a UK Specific payroll package.
13
14 History:
15 21-Oct-2011 krreddy 115.0 13076448 Created.
16 28-Oct-2011 rajganga 115.1 13076448 Modified.
17 09-Feb-2012 rajganga 115.2 13076448 Modified.
18 30-May-2012 rajganga 115.3 14086055 Included functions for date logic.
19 =============================================================================*/
20 --
21 --
22 PROCEDURE range_cursor (pactid IN NUMBER,
23 sqlstr OUT NOCOPY VARCHAR2);
24
25 PROCEDURE rti_eas_action_creation (pactid in number,
26 stperson in number,
27 endperson in number,
28 chunk in number);
29
30
31
32 PROCEDURE rti_nino_action_creation (pactid in number,
33 stperson in number,
34 endperson in number,
35 chunk in number);
36
37 PROCEDURE archinit ( p_payroll_action_id IN NUMBER);
38
39 PROCEDURE archive_code (p_assactid IN NUMBER,
40 p_effective_date IN DATE);
41
42 PROCEDURE deinitialization_code(pactid IN NUMBER);
43
44 PROCEDURE internal_action_creation_eas(pactid in number,
45 stperson in number,
46 endperson in number,
47 chunk in number,
48 p_info_type in varchar2,
49 p_rep_type in varchar2);
50
51 PROCEDURE internal_action_creation_nino(pactid in number,
52 stperson in number,
53 endperson in number,
54 chunk in number,
55 p_info_type in varchar2,
56 p_rep_type in varchar2);
57
58 FUNCTION fetch_soy(l_effective_date date) return date;
59
60 FUNCTION validate_input(p_input_value varchar2,
61 p_validate_mode varchar2)
62 RETURN number;
63
64 FUNCTION date_validate (c_assignment_action_id NUMBER,
65 p_mode VARCHAR2,
66 p_validate_date DATE)
67 RETURN NUMBER;
68
69 function get_eff_start_date (asg_id number,eff_date date,l_tax_ref varchar2)
70 return date;
71
72 function get_eff_end_date (asg_id number,eff_date date,l_tax_ref varchar2)
73 return date;
74
75 END PAY_GB_RTI;