231:
232: -- Person Address validations
233: PROCEDURE person_address_validations( p_assactid IN NUMBER,
234: p_effective_date IN DATE,
235: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
236: edi_validation_fail out nocopy varchar2) IS
237:
238: l_proc CONSTANT VARCHAR2(70):= g_package||'person_address_validations';
239:
501: --
502: -- Person Address validations
503: PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,
504: p_effective_date IN DATE,
505: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
506: p_tab_rec_det1 IN pay_gb_rti_fps_archive.act_info_rec,
507: p_tab_rec_det2 IN pay_gb_rti_fps_archive.act_info_rec,
508: edi_validation_fail out nocopy varchar2) IS
509:
502: -- Person Address validations
503: PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,
504: p_effective_date IN DATE,
505: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
506: p_tab_rec_det1 IN pay_gb_rti_fps_archive.act_info_rec,
507: p_tab_rec_det2 IN pay_gb_rti_fps_archive.act_info_rec,
508: edi_validation_fail out nocopy varchar2) IS
509:
510: l_proc CONSTANT VARCHAR2(70):= g_package||'person_addr_validations_aggr';
503: PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,
504: p_effective_date IN DATE,
505: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
506: p_tab_rec_det1 IN pay_gb_rti_fps_archive.act_info_rec,
507: p_tab_rec_det2 IN pay_gb_rti_fps_archive.act_info_rec,
508: edi_validation_fail out nocopy varchar2) IS
509:
510: l_proc CONSTANT VARCHAR2(70):= g_package||'person_addr_validations_aggr';
511:
786: --------------------------------------------------------------------------*/
787:
788: PROCEDURE assignment_validations(p_assactid IN NUMBER,
789: p_effective_date IN DATE,
790: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
791: edi_validation_fail out nocopy varchar2) IS
792:
793: -- To fetch Effective date
794: CURSOR get_effective_date IS
1314: --------------------------------------------------------------------------*/
1315:
1316: PROCEDURE assignment_validations_aggr(p_assactid IN NUMBER,
1317: p_effective_date IN DATE,
1318: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
1319: p_tab_rec_det1 IN pay_gb_rti_fps_archive.act_info_rec,
1320: p_tab_rec_det2 IN pay_gb_rti_fps_archive.act_info_rec,
1321: edi_validation_fail out nocopy varchar2) IS
1322:
1315:
1316: PROCEDURE assignment_validations_aggr(p_assactid IN NUMBER,
1317: p_effective_date IN DATE,
1318: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
1319: p_tab_rec_det1 IN pay_gb_rti_fps_archive.act_info_rec,
1320: p_tab_rec_det2 IN pay_gb_rti_fps_archive.act_info_rec,
1321: edi_validation_fail out nocopy varchar2) IS
1322:
1323: -- To fetch Effective date
1316: PROCEDURE assignment_validations_aggr(p_assactid IN NUMBER,
1317: p_effective_date IN DATE,
1318: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
1319: p_tab_rec_det1 IN pay_gb_rti_fps_archive.act_info_rec,
1320: p_tab_rec_det2 IN pay_gb_rti_fps_archive.act_info_rec,
1321: edi_validation_fail out nocopy varchar2) IS
1322:
1323: -- To fetch Effective date
1324: CURSOR get_effective_date IS
1849: Notes :
1850: --------------------------------------------------------------------------*/
1851: PROCEDURE ni_validations( p_assactid IN NUMBER,
1852: p_effective_date IN DATE,
1853: p_tab_rec_data IN pay_gb_rti_fps_archive.action_info_table,
1854: p_index IN NUMBER,
1855: edi_validation_fail out nocopy varchar2) IS
1856:
1857: