222: p_detail_type IN VARCHAR2)
223: RETURN VARCHAR2;
224:
225: TYPE agreement_rec_type IS RECORD
226: (name so_agreements.name%type,
227: start_date_active so_agreements.start_date_active%type,
228: end_date_active so_agreements.end_date_active%type,
229: is_valid_date VARCHAR2(10));
230:
223: RETURN VARCHAR2;
224:
225: TYPE agreement_rec_type IS RECORD
226: (name so_agreements.name%type,
227: start_date_active so_agreements.start_date_active%type,
228: end_date_active so_agreements.end_date_active%type,
229: is_valid_date VARCHAR2(10));
230:
231: TYPE t_agreement_table IS TABLE OF agreement_rec_type
224:
225: TYPE agreement_rec_type IS RECORD
226: (name so_agreements.name%type,
227: start_date_active so_agreements.start_date_active%type,
228: end_date_active so_agreements.end_date_active%type,
229: is_valid_date VARCHAR2(10));
230:
231: TYPE t_agreement_table IS TABLE OF agreement_rec_type
232: INDEX BY BINARY_INTEGER;