APPS.IGS_GE_GEN_001 dependencies on IGS_OR_INSTITUTION

Line 815: FROM IGS_OR_INSTITUTION inst

811: -- cursor for selection of the institution name
812: CURSOR c_inst_name (
813: cp_institution_cd VARCHAR2)IS
814: SELECT inst.name inst_name
815: FROM IGS_OR_INSTITUTION inst
816: WHERE inst.institution_cd = cp_institution_cd;
817: -- cursor for selection of the IGS_OR_INSTITUTION address when
818: -- only the loc_unit_cd is supplied
819: CURSOR c_ins(

Line 817: -- cursor for selection of the IGS_OR_INSTITUTION address when

813: cp_institution_cd VARCHAR2)IS
814: SELECT inst.name inst_name
815: FROM IGS_OR_INSTITUTION inst
816: WHERE inst.institution_cd = cp_institution_cd;
817: -- cursor for selection of the IGS_OR_INSTITUTION address when
818: -- only the loc_unit_cd is supplied
819: CURSOR c_ins(
820: cp_institution_cd VARCHAR2)IS
821: SELECT iadv.institution_cd iadv_institution_cd,

Line 831: -- cursor for selection of the IGS_OR_INSTITUTION address when

827: iadv.city iadv_city
828: FROM IGS_OR_INST_ADDR iadv
829: WHERE iadv.institution_cd = cp_institution_cd AND
830: iadv.correspondence_ind = 'Y';
831: -- cursor for selection of the IGS_OR_INSTITUTION address when
832: -- only the institution_cd and IGS_CO_ADDR_TYPE is supplied
833: CURSOR c_inst(
834: cp_institution_cd VARCHAR2,
835: cp_addr_type VARCHAR2)IS

Line 851: e_addr_error EXCEPTION; -- IGS_OR_INSTITUTION address exception handler

847: v_name VARCHAR2(256) := NULL;
848: v_line_1 VARCHAR2(256) := NULL;
849: -- Local Exceptions
850: e_name_error EXCEPTION; -- institutiont name exception handler
851: e_addr_error EXCEPTION; -- IGS_OR_INSTITUTION address exception handler
852: BEGIN
853: -- test for open cursor, then loop and select the persons name
854: IF c_inst_name%ISOPEN THEN
855: CLOSE c_inst_name;