APPS.IGS_AD_IMP_026 dependencies on IGS_PE_PASSPORT_PKG

Line 1110: IGS_PE_PASSPORT_PKG.INSERT_ROW(

1106:
1107: BEGIN
1108: --CALL TO PASSPORT INSERT RECORD
1109:
1110: IGS_PE_PASSPORT_PKG.INSERT_ROW(
1111: X_ROWID => l_rowid,
1112: X_PASSPORT_ID => l_pass_id ,
1113: X_PERSON_ID => pass_rec.person_id,
1114: X_PASSPORT_NUMBER => pass_rec.passport_number,

Line 1201: -- MAKE CALL TO THE TBH i.e IGS_PE_PASSPORT_PKG.UPDATE_ROW

1197: l_app VARCHAR2(50);
1198:
1199: BEGIN
1200:
1201: -- MAKE CALL TO THE TBH i.e IGS_PE_PASSPORT_PKG.UPDATE_ROW
1202: igs_pe_passport_pkg.update_row(
1203: X_ROWID => dup_pass_rec.rowid,
1204: X_PASSPORT_ID => dup_pass_rec.passport_id,
1205: X_PERSON_ID => NVL(pass_rec.person_id,dup_pass_rec.person_id),

Line 1202: igs_pe_passport_pkg.update_row(

1198:
1199: BEGIN
1200:
1201: -- MAKE CALL TO THE TBH i.e IGS_PE_PASSPORT_PKG.UPDATE_ROW
1202: igs_pe_passport_pkg.update_row(
1203: X_ROWID => dup_pass_rec.rowid,
1204: X_PASSPORT_ID => dup_pass_rec.passport_id,
1205: X_PERSON_ID => NVL(pass_rec.person_id,dup_pass_rec.person_id),
1206: X_PASSPORT_NUMBER => NVL(pass_rec.passport_number,dup_pass_rec.passport_number),