250: p_parameterlist => l_parameter_list_t);
251:
252: -- Set this role to the workflow
253: wf_event.addparametertolist( p_name => 'IA_REC_ADHOCROLE',
254: p_value => fnd_global.user_name,
255: p_parameterlist => l_parameter_list_t);
256:
257: G_ITEM_TYPE := l_seq_val;
258:
327: AND exemption_institution_cd = cp_exemption_institution_cd
328: AND unit_details_id IS NOT NULL) rslt;
329: rec_chk_adv cur_chk_adv%ROWTYPE;
330:
331: nbsp VARCHAR2(10) := fnd_global.local_chr(38) || 'nbsp;';
332: --Cursor to find if there is any new Unit attached to the New Transcript which was not attached to the old transcript.
333: CURSOR cur_chk_new_tran(cp_new_tid NUMBER, cp_old_transcript_id NUMBER) IS
334: SELECT '