APPS.IGR_IMP_001 dependencies on IGS_PE_CITIZEN_INT

Line 38: into IGS_AD_INTERFACE_ALL,IGS_AD_STAT_INT,IGS_PE_CITIZEN_INT and

34: SELECT igs_ad_interface_s.nextval FROM dual;
35:
36: /* This Main Cursor retrieves all the Person and Inquiry Details,
37: with Status 'I' or 'U' which are then inserted
38: into IGS_AD_INTERFACE_ALL,IGS_AD_STAT_INT,IGS_PE_CITIZEN_INT and
39: IGS_AD_INQ_APPL_INT after all the validations are successfull
40: */
41:
42: CURSOR inq_per_cur IS

Line 748: INSERT INTO igs_pe_citizen_int

744:
745: /* If atleast one of citizenship1_id and citizenship2_id is not null then Insert */
746: IF inq_rec.citizenship1_id IS NOT NULL THEN
747: BEGIN
748: INSERT INTO igs_pe_citizen_int
749: (
750: interface_citizenship_id,
751: interface_id ,
752: country_code ,

Line 797: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);

793: fnd_global.conc_request_id
794: );
795: EXCEPTION WHEN OTHERS THEN
796: l_status:=0;
797: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);
798: RAISE;
799: END;
800:
801:

Line 806: INSERT INTO igs_pe_citizen_int

802: END IF;
803:
804: IF inq_rec.citizenship2_id IS NOT NULL THEN
805: BEGIN
806: INSERT INTO igs_pe_citizen_int
807: (
808: interface_citizenship_id ,
809: interface_id ,
810: country_code ,

Line 855: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);

851: fnd_global.conc_request_id
852: );
853: EXCEPTION WHEN OTHERS THEN
854: l_status:=0;
855: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_CITIZEN_INT failed '||SQLERRM);
856: RAISE;
857: END;
858:
859: