5: p_template_id in number,
6: x_status OUT NOCOPY varchar2) IS
7: l_file_id number;
8: cursor c1 is select lookup_code,meaning 9: from fnd_lookups 10: where enabled_flag = 'Y'
11: AND NVL(start_date_active, SYSDATE) <= SYSDATE
12: AND NVL(end_date_active,SYSDATE) >= SYSDATE
13: AND lookup_type ='IEM_MERGE_FIELDS'