APPS.IGS_HE_IMPORT_DATA dependencies on IGS_AD_DISABLTY_INT

Line 669: INSERT INTO igs_ad_disablty_int(interface_disablty_id,

665: IF c_interface_rec.disability_type IS NOT NULL THEN
666: -- Firstly Close all the existing disability records for this person
667: FOR c_other_dis_rec IN c_other_dis LOOP
668: -- Close the disability record by end dating it
669: INSERT INTO igs_ad_disablty_int(interface_disablty_id,
670: interface_id,
671: status,
672: disability_type,
673: start_date,

Line 679: VALUES (igs_ad_disablty_int_s.NEXTVAL ,

675: created_by,
676: creation_date,
677: last_updated_by,
678: last_update_date)
679: VALUES (igs_ad_disablty_int_s.NEXTVAL ,
680: l_interface_id,
681: l_status,
682: c_other_dis_rec.disability_type,
683: NVL(c_other_dis_rec.start_date,TRUNC(SYSDATE)),

Line 702: INSERT INTO igs_ad_disablty_int(interface_disablty_id,

698: -- create a new disability record if already some other record did not start on sysdate
699: OPEN c_pe_dis_sysdate ;
700: FETCH c_pe_dis_sysdate INTO c_pe_dis_sysdate_rec;
701: IF c_pe_dis_sysdate%NOTFOUND THEN
702: INSERT INTO igs_ad_disablty_int(interface_disablty_id,
703: interface_id,
704: status,
705: disability_type,
706: start_date,

Line 712: VALUES (igs_ad_disablty_int_s.NEXTVAL ,

708: created_by,
709: creation_date,
710: last_updated_by,
711: last_update_date)
712: VALUES (igs_ad_disablty_int_s.NEXTVAL ,
713: l_interface_id,
714: l_status,
715: l_oss_disability,
716: TRUNC(SYSDATE),

Line 725: INSERT INTO igs_ad_disablty_int(interface_disablty_id,

721: SYSDATE) RETURNING interface_disablty_id INTO l_interface_disablty_id ;
722: ELSE
723: -- If already this disability record exists which started on sysdate and ended some date ,
724: -- we need to update that records end date to null so that it will be active
725: INSERT INTO igs_ad_disablty_int(interface_disablty_id,
726: interface_id,
727: status,
728: disability_type,
729: start_date,

Line 735: VALUES (igs_ad_disablty_int_s.NEXTVAL ,

731: created_by,
732: creation_date,
733: last_updated_by,
734: last_update_date)
735: VALUES (igs_ad_disablty_int_s.NEXTVAL ,
736: l_interface_id,
737: l_status,
738: c_pe_dis_sysdate_rec.disability_type,
739: NVL(c_pe_dis_sysdate_rec.start_date, Trunc(SYSDATE)),

Line 811: INSERT INTO igs_ad_disablty_int(interface_disablty_id,

807: -- so cannot create one more
808: CLOSE c_pe_dis_sysdate;
809: -- If already this disability record exists which started on sysdate and ended some date ,
810: -- we need to update that records end date to null so that it will be active
811: INSERT INTO igs_ad_disablty_int(interface_disablty_id,
812: interface_id,
813: status,
814: disability_type,
815: start_date,

Line 821: VALUES (igs_ad_disablty_int_s.NEXTVAL ,

817: created_by,
818: creation_date,
819: last_updated_by,
820: last_update_date)
821: VALUES (igs_ad_disablty_int_s.NEXTVAL ,
822: l_interface_id,
823: l_status,
824: c_pe_dis_sysdate_rec.disability_type,
825: c_pe_dis_sysdate_rec.start_date,