[Home] [Help]
PACKAGE: APPS.PAY_GB_RTI_FPS_VALIDATE_13
Source
1 PACKAGE PAY_GB_RTI_FPS_VALIDATE_13 AUTHID CURRENT_USER as
2 /* $Header: pygbrtifpsval13.pkh 120.0.12020000.1 2013/01/08 07:24:25 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_13
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 19-Dec-2012 rajganga 115.0 15890022 Created.
16
17 =============================================================================*/
18 --
19 --
20 PROCEDURE header_validations(p_payroll_action_id IN NUMBER,flag OUT nocopy VARCHAR2);
21
22
23 PROCEDURE person_address_validations( p_assactid IN NUMBER,
24 p_effective_date IN DATE,
25 p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
26 edi_validation_fail out nocopy varchar2);
27
28 PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,
29 p_effective_date IN DATE,
30 p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
31 p_tab_rec_det1 IN pay_gb_rti_fps_archive.act_info_rec,
32 p_tab_rec_det2 IN pay_gb_rti_fps_archive.act_info_rec,
33 edi_validation_fail out nocopy varchar2);
34
35 PROCEDURE assignment_validations(p_assactid IN NUMBER,
36 p_effective_date IN DATE,
37 p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
38 edi_validation_fail out nocopy varchar2);
39
40 PROCEDURE assignment_validations_aggr(p_assactid IN NUMBER,
41 p_effective_date IN DATE,
42 p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
43 p_tab_rec_det1 IN pay_gb_rti_fps_archive.act_info_rec,
44 p_tab_rec_det2 IN pay_gb_rti_fps_archive.act_info_rec,
45 edi_validation_fail out nocopy varchar2);
46
47 PROCEDURE ni_validations( p_assactid IN NUMBER,
48 p_effective_date IN DATE,
49 p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
50 p_index IN NUMBER,
51 edi_validation_fail out nocopy varchar2);
52
53
54 PROCEDURE footer_validations( econ IN VARCHAR2,
55 final_submission IN VARCHAR2,flag OUT nocopy VARCHAR2);
56
57 function econ_validate(econ varchar2)
58 return number;
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 END PAY_GB_RTI_FPS_VALIDATE_13;