1721: || Added all the missing validations and replaced E008 with proper error codes
1722: || asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row changed
1723: */
1724:
1725: CURSOR source_type_cur(cp_source_type igs_pe_src_types_all.source_type%TYPE) Is
1726: SELECT source_type_id
1727: FROM igs_pe_src_types_all
1728: WHERE source_type = cp_source_type;
1729:
1723: */
1724:
1725: CURSOR source_type_cur(cp_source_type igs_pe_src_types_all.source_type%TYPE) Is
1726: SELECT source_type_id
1727: FROM igs_pe_src_types_all
1728: WHERE source_type = cp_source_type;
1729:
1730: l_rowid VARCHAR2(25);
1731: lnDupExist NUMBER;