APPS.IGS_AD_OFFRESP_STATUS_WF dependencies on IGS_PE_PERSON_BASE_V

Line 115: l_person_number igs_pe_person_base_v.person_number%TYPE;

111: -------------------------------------------------------------------
112: IS
113: l_event_name VARCHAR2(200);
114: l_event_message WF_EVENT_T;
115: l_person_number igs_pe_person_base_v.person_number%TYPE;
116: l_full_name igs_pe_person_base_v.full_name%TYPE;
117: l_person_id igs_pe_person_base_v.person_id%TYPE;
118:
119: CURSOR get_person_attr IS

Line 116: l_full_name igs_pe_person_base_v.full_name%TYPE;

112: IS
113: l_event_name VARCHAR2(200);
114: l_event_message WF_EVENT_T;
115: l_person_number igs_pe_person_base_v.person_number%TYPE;
116: l_full_name igs_pe_person_base_v.full_name%TYPE;
117: l_person_id igs_pe_person_base_v.person_id%TYPE;
118:
119: CURSOR get_person_attr IS
120: SELECT person_number, full_name

Line 117: l_person_id igs_pe_person_base_v.person_id%TYPE;

113: l_event_name VARCHAR2(200);
114: l_event_message WF_EVENT_T;
115: l_person_number igs_pe_person_base_v.person_number%TYPE;
116: l_full_name igs_pe_person_base_v.full_name%TYPE;
117: l_person_id igs_pe_person_base_v.person_id%TYPE;
118:
119: CURSOR get_person_attr IS
120: SELECT person_number, full_name
121: FROM igs_pe_person_base_v

Line 121: FROM igs_pe_person_base_v

117: l_person_id igs_pe_person_base_v.person_id%TYPE;
118:
119: CURSOR get_person_attr IS
120: SELECT person_number, full_name
121: FROM igs_pe_person_base_v
122: WHERE person_id = l_person_id;
123:
124: CURSOR cur_user_name IS
125: SELECT user_name

Line 175: CURSOR get_person_attr (p_person_id igs_pe_person_base_v.person_id%TYPE) IS

171: --Change History:
172: --Who When What
173: -------------------------------------------------------------------
174:
175: CURSOR get_person_attr (p_person_id igs_pe_person_base_v.person_id%TYPE) IS
176: SELECT person_number, full_name
177: FROM igs_pe_person_base_v
178: WHERE person_id = p_person_id;
179:

Line 177: FROM igs_pe_person_base_v

173: -------------------------------------------------------------------
174:
175: CURSOR get_person_attr (p_person_id igs_pe_person_base_v.person_id%TYPE) IS
176: SELECT person_number, full_name
177: FROM igs_pe_person_base_v
178: WHERE person_id = p_person_id;
179:
180: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
181: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS

Line 211: l_person_number igs_pe_person_base_v.person_number%TYPE;

207: WHERE user_id = fnd_global.user_id;
208:
209: l_wf_role fnd_user.user_name%TYPE;
210: l_event_message WF_EVENT_T;
211: l_person_number igs_pe_person_base_v.person_number%TYPE;
212: l_full_name igs_pe_person_base_v.full_name%TYPE;
213:
214: l_person_id igs_pe_person_base_v.person_id%TYPE;
215: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;

Line 212: l_full_name igs_pe_person_base_v.full_name%TYPE;

208:
209: l_wf_role fnd_user.user_name%TYPE;
210: l_event_message WF_EVENT_T;
211: l_person_number igs_pe_person_base_v.person_number%TYPE;
212: l_full_name igs_pe_person_base_v.full_name%TYPE;
213:
214: l_person_id igs_pe_person_base_v.person_id%TYPE;
215: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
216: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;

Line 214: l_person_id igs_pe_person_base_v.person_id%TYPE;

210: l_event_message WF_EVENT_T;
211: l_person_number igs_pe_person_base_v.person_number%TYPE;
212: l_full_name igs_pe_person_base_v.full_name%TYPE;
213:
214: l_person_id igs_pe_person_base_v.person_id%TYPE;
215: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
216: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
217: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
218: