36:
37: FUNCTION getmessagetext (p_message_name IN VARCHAR2
38: )RETURN VARCHAR2;
39:
40: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
41: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
42: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
43: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
44: p_message OUT NOCOPY VARCHAR2
37: FUNCTION getmessagetext (p_message_name IN VARCHAR2
38: )RETURN VARCHAR2;
39:
40: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
41: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
42: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
43: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
44: p_message OUT NOCOPY VARCHAR2
45: ) ;
38: )RETURN VARCHAR2;
39:
40: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
41: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
42: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
43: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
44: p_message OUT NOCOPY VARCHAR2
45: ) ;
46:
39:
40: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
41: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
42: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
43: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
44: p_message OUT NOCOPY VARCHAR2
45: ) ;
46:
47: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
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 ,
70: p_org_id IN NUMBER
71: );
72: