APPS.IGS_GE_GEN_002 dependencies on IGS_OR_INSTITUTION

Line 662: -- Purpose: Function for returning formatted IGS_OR_INSTITUTION names and addresses

658: App_Exception.Raise_Exception ;
659: END genp_get_loc_addr;
660: -------------------------------------------------------------------------------
661: -- Module: genp_get_inst_addr
662: -- Purpose: Function for returning formatted IGS_OR_INSTITUTION names and addresses
663: -- based on variations of the parameters passed
664: -- Notes:
665: -- p_phone_no is used to toggle the display of the phone number
666: -- Y populates the p_phone_line parameter with the phone number

Line 670: -- 'IGS_OR_INSTITUTION not found'

666: -- Y populates the p_phone_line parameter with the phone number
667: -- N populates the p_phone_line parameter with a null value
668: -- Exception Handlers
669: -- e_name_error: returns false and populates the p_name variable with
670: -- 'IGS_OR_INSTITUTION not found'
671: -- e_addr_error: returns false and populates p_line_1 with
672: -- 'No address record found'
673: --
674: -- Module History

Line 695: -- cursor for selection of the IGS_OR_INSTITUTION name

691: p_line_5 OUT NOCOPY VARCHAR2,
692: p_phone_line OUT NOCOPY VARCHAR2)
693: RETURN BOOLEAN
694: AS
695: -- cursor for selection of the IGS_OR_INSTITUTION name
696: CURSOR c_inst_name (
697: cp_institution_cd VARCHAR2)IS
698: SELECT inst.name inst_name
699: FROM IGS_OR_INSTITUTION inst

Line 699: FROM IGS_OR_INSTITUTION inst

695: -- cursor for selection of the IGS_OR_INSTITUTION name
696: CURSOR c_inst_name (
697: cp_institution_cd VARCHAR2)IS
698: SELECT inst.name inst_name
699: FROM IGS_OR_INSTITUTION inst
700: WHERE inst.institution_cd = cp_institution_cd;
701: -- cursor for selection of the IGS_OR_INSTITUTION address when
702: -- only the loc_unit_cd is supplied
703: CURSOR c_ins(

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

697: cp_institution_cd VARCHAR2)IS
698: SELECT inst.name inst_name
699: FROM IGS_OR_INSTITUTION inst
700: WHERE inst.institution_cd = cp_institution_cd;
701: -- cursor for selection of the IGS_OR_INSTITUTION address when
702: -- only the loc_unit_cd is supplied
703: CURSOR c_ins(
704: cp_institution_cd VARCHAR2)IS
705: SELECT iadv.institution_cd iadv_institution_cd,

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

712: FROM IGS_OR_INST_ADDR iadv
713: WHERE iadv.institution_cd = cp_institution_cd AND
714: iadv.correspondence_ind = 'Y';
715:
716: -- cursor for selection of the IGS_OR_INSTITUTION address when
717: -- only the institution_cd and IGS_CO_ADDR_TYPE is supplied
718: CURSOR c_inst(
719: cp_institution_cd VARCHAR2,
720: cp_addr_type VARCHAR2)IS

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

733: v_name VARCHAR2(256) := NULL;
734: v_line_1 VARCHAR2(256) := NULL;
735: -- Local IGS_GE_EXCEPTIONS
736: e_name_error EXCEPTION; -- institutiont name exception handler
737: e_addr_error EXCEPTION; -- IGS_OR_INSTITUTION address exception handler
738: BEGIN
739: -- test for open cursor, then loop and select the persons name
740: IF c_inst_name%ISOPEN THEN
741: CLOSE c_inst_name;