DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_VALIDATE dependencies on PAY_GB_RTI_FPS

Line 1: PACKAGE BODY PAY_GB_RTI_FPS_VALIDATE as

1: PACKAGE BODY PAY_GB_RTI_FPS_VALIDATE as
2: /* $Header: pygbrtifpsval.pkb 120.6.12020000.3 2013/03/20 11:10:49 rajganga noship $ */
3: /*===========================================================================+
4: | Copyright (c) 2012 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 9: PAY_GB_RTI_FPS_VALIDATE

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:

Line 37: g_package CONSTANT VARCHAR2(50):= 'pay_gb_rti_fps_validations.';

33: 09-FEB-2012 ssarap 115.15 16276411 NHS Issues.
34: ========================================================================================*/
35: --
36: -- Global variables
37: g_package CONSTANT VARCHAR2(50):= 'pay_gb_rti_fps_validations.';
38: g_econ_ni_check varchar2(1);
39:
40: ---
41: PROCEDURE populate_run_msg(

Line 222: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,

218:
219: -- Person Address validations
220: PROCEDURE person_address_validations( p_assactid IN NUMBER,
221: p_effective_date IN DATE,
222: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
223: edi_validation_fail out nocopy varchar2) IS
224:
225: l_proc CONSTANT VARCHAR2(70):= g_package||'person_address_validations';
226:

Line 492: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,

488: --
489: -- Person Address validations
490: PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,
491: p_effective_date IN DATE,
492: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
493: p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,
494: p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,
495: edi_validation_fail out nocopy varchar2) IS
496:

Line 493: p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,

489: -- Person Address validations
490: PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,
491: p_effective_date IN DATE,
492: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
493: p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,
494: p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,
495: edi_validation_fail out nocopy varchar2) IS
496:
497: l_proc CONSTANT VARCHAR2(70):= g_package||'person_addr_validations_aggr';

Line 494: p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,

490: PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,
491: p_effective_date IN DATE,
492: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
493: p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,
494: p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,
495: edi_validation_fail out nocopy varchar2) IS
496:
497: l_proc CONSTANT VARCHAR2(70):= g_package||'person_addr_validations_aggr';
498:

Line 777: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,

773: --------------------------------------------------------------------------*/
774:
775: PROCEDURE assignment_validations(p_assactid IN NUMBER,
776: p_effective_date IN DATE,
777: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
778: edi_validation_fail out nocopy varchar2) IS
779:
780: -- To fetch Effective date
781: CURSOR get_effective_date IS

Line 1305: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,

1301: --------------------------------------------------------------------------*/
1302:
1303: PROCEDURE assignment_validations_aggr(p_assactid IN NUMBER,
1304: p_effective_date IN DATE,
1305: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
1306: p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,
1307: p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,
1308: edi_validation_fail out nocopy varchar2) IS
1309:

Line 1306: p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,

1302:
1303: PROCEDURE assignment_validations_aggr(p_assactid IN NUMBER,
1304: p_effective_date IN DATE,
1305: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
1306: p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,
1307: p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,
1308: edi_validation_fail out nocopy varchar2) IS
1309:
1310: -- To fetch Effective date

Line 1307: p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,

1303: PROCEDURE assignment_validations_aggr(p_assactid IN NUMBER,
1304: p_effective_date IN DATE,
1305: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
1306: p_tab_rec_det1 IN pay_gb_rti_fps.act_info_rec,
1307: p_tab_rec_det2 IN pay_gb_rti_fps.act_info_rec,
1308: edi_validation_fail out nocopy varchar2) IS
1309:
1310: -- To fetch Effective date
1311: CURSOR get_effective_date IS

Line 1840: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,

1836: Notes :
1837: --------------------------------------------------------------------------*/
1838: PROCEDURE ni_validations( p_assactid IN NUMBER,
1839: p_effective_date IN DATE,
1840: p_tab_rec_data IN pay_gb_rti_fps.action_info_table,
1841: p_index IN NUMBER,
1842: edi_validation_fail out nocopy varchar2) IS
1843:
1844:

Line 2419: end PAY_GB_RTI_FPS_VALIDATE;

2415:
2416: RETURN l_return_valid;
2417: END date_validate;
2418:
2419: end PAY_GB_RTI_FPS_VALIDATE;