APPS.IGR_IMP_001 dependencies on IGS_AD_STAT_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 641: INSERT INTO igs_ad_stat_int

637: RAISE;
638: END;
639:
640: BEGIN
641: INSERT INTO igs_ad_stat_int
642: (
643: org_id ,
644: interface_stat_id ,
645: interface_id ,

Line 688: igs_ad_stat_int_s.nextval,

684: attribute20
685: )VALUES
686: (
687: inq_rec.org_id ,
688: igs_ad_stat_int_s.nextval,
689: l_interface_id ,
690: null ,
691: null ,
692: null ,

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

728: null
729: );
730: EXCEPTION WHEN OTHERS THEN
731: l_status:=0;
732: fnd_file.put_line(fnd_file.log,'Insert on igs_ad_stat_int failed '||SQLERRM);
733: RAISE;
734: END;
735:
736: ELSE /* l_status = 0 ie Validation failed*/