[Home] [Help]
PACKAGE: APPS.PAY_GB_RTI_FPS_VALIDATE
Source
1 PACKAGE PAY_GB_RTI_FPS_VALIDATE AUTHID CURRENT_USER as
2 /* $Header: pygbrtifpsval.pkh 120.1.12020000.1 2013/02/09 17:52:17 appldev noship $ */
3 /*===========================================================================+
4 | Copyright (c) 2012 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +============================================================================
8 Name:
9 PAY_GB_RTI_FPS_VALIDATE
10 Purpose:
11 It fetches the archived data for RTI FPS Processes, and validates it.
12 This is a UK Specific payroll package.
13
14 History:
15 05-Apr-2012 rajganga 115.0 13918120 Created.
16 8-May-2012 rajganga 115.1 13918120 Modified footer validations.
17 30-Jul-2012 rajganga 115.2 13918120 Modified to return value for Header validations.
18 05-Aug-2012 krreddy 115.3 14393796 Added two new procedures person_addr_validations_aggr
19 and assignment_validations_aggr for Aggregated scenarios.
20
21 =============================================================================*/
22 --
23 --
24 PROCEDURE header_validations(p_payroll_action_id IN NUMBER,flag OUT nocopy VARCHAR2);
25
26
27 PROCEDURE person_address_validations( p_assactid IN NUMBER,
28 p_effective_date IN DATE,
29 p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
30 edi_validation_fail out nocopy varchar2);
31
32 PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,
33 p_effective_date IN DATE,
34 p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
35 p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,
36 p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,
37 edi_validation_fail out nocopy varchar2);
38
39 PROCEDURE assignment_validations(p_assactid IN NUMBER,
40 p_effective_date IN DATE,
41 p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
42 edi_validation_fail out nocopy varchar2);
43
44 PROCEDURE assignment_validations_aggr(p_assactid IN NUMBER,
45 p_effective_date IN DATE,
46 p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
47 p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,
48 p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,
49 edi_validation_fail out nocopy varchar2);
50
51 PROCEDURE ni_validations( p_assactid IN NUMBER,
52 p_effective_date IN DATE,
53 p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
54 p_index IN NUMBER,
55 edi_validation_fail out nocopy varchar2);
56
57
58 PROCEDURE footer_validations( econ IN VARCHAR2,
59 final_submission IN VARCHAR2,flag OUT nocopy VARCHAR2);
60
61 function econ_validate(econ varchar2)
62 return number;
63
64 function validate_input(p_input_value varchar2,
65 p_validate_mode varchar2)
66 return number;
67
68 FUNCTION date_validate (c_assignment_action_id NUMBER,
69 p_mode VARCHAR2,
70 p_validate_date DATE)
71 RETURN NUMBER;
72
73 END PAY_GB_RTI_FPS_VALIDATE;