81: END orgp_get_local_inst;
82:
83:
84: FUNCTION orgp_get_s_loc_type(
85: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE )
86: RETURN VARCHAR2 IS
87: gv_other_detail VARCHAR2(255);
88: BEGIN -- orgp_get_s_loc_type
89: -- This module fetches the value for s_location_type for a IGS_AD_LOCATION
118: END orgp_get_s_loc_type;
119:
120:
121: FUNCTION orgp_get_s_loc_type2(
122: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE )
123: RETURN VARCHAR2 IS
124: gv_other_detail VARCHAR2(255);
125: BEGIN -- orgp_get_s_loc_type2
126: -- This module fetches the value for s_location_type for a