47: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
48: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
49: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
50: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
51: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
52: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,
53: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,
54: p_message OUT NOCOPY VARCHAR2
55: ) ;
60: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
61: p_org_id IN NUMBER,
62: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
63: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
64: p_load_cal_type IN igs_ca_inst.cal_type%TYPE DEFAULT NULL,
65: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE DEFAULT NULL
66: );
67:
68: PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_id%TYPE ,
61: p_org_id IN NUMBER,
62: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
63: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
64: p_load_cal_type IN igs_ca_inst.cal_type%TYPE DEFAULT NULL,
65: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE DEFAULT NULL
66: );
67:
68: PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_id%TYPE ,
69: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,