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 |
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:
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,
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:
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,
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,
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,
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:
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,
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,
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:
69: p_mode VARCHAR2,
70: p_validate_date DATE)
71: RETURN NUMBER;
72:
73: END PAY_GB_RTI_FPS_VALIDATE;