DBA Data[Home] [Help]

APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_PE_PERSON

Line 40: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,

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

Line 41: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,

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: ) ;

Line 42: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,

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:

Line 43: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,

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 ,

Line 68: PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_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: