eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_PE_PERSON

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

54: RETURN l_message_text;
55:
56: END getmessagetext;
57:
58: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
59: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
60: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
61: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
62: p_message OUT NOCOPY VARCHAR2

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

55:
56: END getmessagetext;
57:
58: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
59: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
60: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
61: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
62: p_message OUT NOCOPY VARCHAR2
63: ) IS

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

56: END getmessagetext;
57:
58: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
59: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
60: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
61: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
62: p_message OUT NOCOPY VARCHAR2
63: ) IS
64: ------------------------------------------------------------------

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

57:
58: PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
59: p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
60: p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
61: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
62: p_message OUT NOCOPY VARCHAR2
63: ) IS
64: ------------------------------------------------------------------
65: --Created by : Sanil Madathil, Oracle IDC

Line 78: CURSOR c_igs_pe_person(cp_person_id igs_pe_person.person_id%TYPE) IS

74: --
75: --Change History:
76: --Who When What
77: -------------------------------------------------------------------
78: CURSOR c_igs_pe_person(cp_person_id igs_pe_person.person_id%TYPE) IS
79: SELECT person_number , full_name , email_addr
80: FROM igs_pe_person
81: WHERE person_id = cp_person_id ;
82:

Line 80: FROM igs_pe_person

76: --Who When What
77: -------------------------------------------------------------------
78: CURSOR c_igs_pe_person(cp_person_id igs_pe_person.person_id%TYPE) IS
79: SELECT person_number , full_name , email_addr
80: FROM igs_pe_person
81: WHERE person_id = cp_person_id ;
82:
83: l_c_igs_pe_person c_igs_pe_person%ROWTYPE ;
84: l_message VARCHAR2(1000) DEFAULT NULL ;

Line 83: l_c_igs_pe_person c_igs_pe_person%ROWTYPE ;

79: SELECT person_number , full_name , email_addr
80: FROM igs_pe_person
81: WHERE person_id = cp_person_id ;
82:
83: l_c_igs_pe_person c_igs_pe_person%ROWTYPE ;
84: l_message VARCHAR2(1000) DEFAULT NULL ;
85: BEGIN
86: OPEN c_igs_pe_person(cp_person_id => p_person_id );
87: FETCH c_igs_pe_person INTO l_c_igs_pe_person ;

Line 86: OPEN c_igs_pe_person(cp_person_id => p_person_id );

82:
83: l_c_igs_pe_person c_igs_pe_person%ROWTYPE ;
84: l_message VARCHAR2(1000) DEFAULT NULL ;
85: BEGIN
86: OPEN c_igs_pe_person(cp_person_id => p_person_id );
87: FETCH c_igs_pe_person INTO l_c_igs_pe_person ;
88: IF c_igs_pe_person%NOTFOUND THEN
89: CLOSE c_igs_pe_person ;
90: l_message := 'IGS_PE_PERS_NOT_EXIST' ;

Line 87: FETCH c_igs_pe_person INTO l_c_igs_pe_person ;

83: l_c_igs_pe_person c_igs_pe_person%ROWTYPE ;
84: l_message VARCHAR2(1000) DEFAULT NULL ;
85: BEGIN
86: OPEN c_igs_pe_person(cp_person_id => p_person_id );
87: FETCH c_igs_pe_person INTO l_c_igs_pe_person ;
88: IF c_igs_pe_person%NOTFOUND THEN
89: CLOSE c_igs_pe_person ;
90: l_message := 'IGS_PE_PERS_NOT_EXIST' ;
91: p_person_number := NULL ;

Line 88: IF c_igs_pe_person%NOTFOUND THEN

84: l_message VARCHAR2(1000) DEFAULT NULL ;
85: BEGIN
86: OPEN c_igs_pe_person(cp_person_id => p_person_id );
87: FETCH c_igs_pe_person INTO l_c_igs_pe_person ;
88: IF c_igs_pe_person%NOTFOUND THEN
89: CLOSE c_igs_pe_person ;
90: l_message := 'IGS_PE_PERS_NOT_EXIST' ;
91: p_person_number := NULL ;
92: p_full_name := NULL ;

Line 89: CLOSE c_igs_pe_person ;

85: BEGIN
86: OPEN c_igs_pe_person(cp_person_id => p_person_id );
87: FETCH c_igs_pe_person INTO l_c_igs_pe_person ;
88: IF c_igs_pe_person%NOTFOUND THEN
89: CLOSE c_igs_pe_person ;
90: l_message := 'IGS_PE_PERS_NOT_EXIST' ;
91: p_person_number := NULL ;
92: p_full_name := NULL ;
93: p_email_addr := NULL ;

Line 97: p_person_number := l_c_igs_pe_person.person_number ;

93: p_email_addr := NULL ;
94: p_message := l_message ;
95: RETURN ;
96: END IF;
97: p_person_number := l_c_igs_pe_person.person_number ;
98: p_full_name := l_c_igs_pe_person.full_name ;
99: p_email_addr := l_c_igs_pe_person.email_addr ;
100: p_message := NULL ;
101: CLOSE c_igs_pe_person ;

Line 98: p_full_name := l_c_igs_pe_person.full_name ;

94: p_message := l_message ;
95: RETURN ;
96: END IF;
97: p_person_number := l_c_igs_pe_person.person_number ;
98: p_full_name := l_c_igs_pe_person.full_name ;
99: p_email_addr := l_c_igs_pe_person.email_addr ;
100: p_message := NULL ;
101: CLOSE c_igs_pe_person ;
102:

Line 99: p_email_addr := l_c_igs_pe_person.email_addr ;

95: RETURN ;
96: END IF;
97: p_person_number := l_c_igs_pe_person.person_number ;
98: p_full_name := l_c_igs_pe_person.full_name ;
99: p_email_addr := l_c_igs_pe_person.email_addr ;
100: p_message := NULL ;
101: CLOSE c_igs_pe_person ;
102:
103: END getpersondetail ;

Line 101: CLOSE c_igs_pe_person ;

97: p_person_number := l_c_igs_pe_person.person_number ;
98: p_full_name := l_c_igs_pe_person.full_name ;
99: p_email_addr := l_c_igs_pe_person.email_addr ;
100: p_message := NULL ;
101: CLOSE c_igs_pe_person ;
102:
103: END getpersondetail ;
104:
105: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

Line 234: PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_id%TYPE ,

230: END wf_inform_stud ;
231:
232:
233:
234: PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_id%TYPE ,
235: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
236: p_org_id IN NUMBER
237: )
238: ------------------------------------------------------------------