APPS.IGS_AD_LOCVENUE_ADDR_PKG dependencies on IGS_AD_LOCVENUE_ADDR_S

Line 278: cp_source_type igs_ad_locvenue_addr.source_type%TYPE) IS

274: || (reverse chronological order - newest change first)
275: */
276:
277: CURSOR c_address(cp_location_venue_cd igs_ad_locvenue_addr.location_venue_cd%TYPE,
278: cp_source_type igs_ad_locvenue_addr.source_type%TYPE) IS
279: SELECT rowid
280: FROM igs_ad_locvenue_addr
281: WHERE location_venue_cd = cp_location_venue_cd
282: AND source_type = cp_source_type

Line 450: IGS_AD_LOCVENUE_ADDR_S.NEXTVAL,

446: program_id,
447: program_application_id,
448: program_update_date
449: ) VALUES (
450: IGS_AD_LOCVENUE_ADDR_S.NEXTVAL,
451: new_references.location_id,
452: new_references.location_venue_cd,
453: new_references.source_type,
454: new_references.identifying_address_flag,