259: );
260:
261: /* Get Concatenated Enabled SS Lookup Code Descriptions for a given lookup type with given delimiter */
262:
263: PROCEDURE get_ss_lookup_desc(p_application_type IN igs_ad_ss_lookups.admission_application_type%type,
264: p_lookup_type IN igs_ad_ss_lookups.ss_lookup_type%TYPE,
265: p_delimiter IN VARCHAR2,
266: x_message_name OUT NOCOPY VARCHAR2,
267: x_return_status OUT NOCOPY VARCHAR2,
260:
261: /* Get Concatenated Enabled SS Lookup Code Descriptions for a given lookup type with given delimiter */
262:
263: PROCEDURE get_ss_lookup_desc(p_application_type IN igs_ad_ss_lookups.admission_application_type%type,
264: p_lookup_type IN igs_ad_ss_lookups.ss_lookup_type%TYPE,
265: p_delimiter IN VARCHAR2,
266: x_message_name OUT NOCOPY VARCHAR2,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_concat_desc OUT NOCOPY VARCHAR2);