APPS.IGS_EN_GEN_016 dependencies on IGS_PE_PERSON

Line 54: FROM igs_pe_person_base_v pe

50: -- cursor to fetch person_id
51: --
52: CURSOR get_person_number (p_person_number IN VARCHAR2 ) IS
53: SELECT pe.person_id
54: FROM igs_pe_person_base_v pe
55: WHERE pe.person_number = p_person_number;
56:
57: -- cursor to validate course_cd
58: --

Line 149: l_person_id igs_pe_person.person_id%TYPE;

145: --Declare all local variables .
146: --
147: l_course_cd_chk VARCHAR2(1);
148: l_reg_update_int_rec igs_en_reg_upd_int%ROWTYPE;
149: l_person_id igs_pe_person.person_id%TYPE;
150: l_cnt NUMBER ;
151: l_message_name VARCHAR2(2000) := NULL;
152:
153: l_message_text VARCHAR2(2000) := NULL ;

Line 202: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;

198:
199: l_commencement_type VARCHAR2(20) DEFAULT NULL;
200: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
201: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
202: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
203: l_sua_rec get_sua%ROWTYPE;
204:
205:
206:

Line 882: FROM igs_pe_person_id_typ

878: --
879: -- cursor to fetch the prefered person ID type
880: CURSOR cur_pref_per_type IS
881: SELECT person_id_type
882: FROM igs_pe_person_id_typ
883: WHERE preferred_ind = 'Y';
884:
885: --
886: -- get the person details

Line 889: FROM igs_pe_person_base_v

885: --
886: -- get the person details
887: CURSOR cur_person_dtl(p_person_number VARCHAR2) IS
888: SELECT person_id,full_name
889: FROM igs_pe_person_base_v
890: WHERE person_number = p_person_number;
891:
892: --
893: -- cursor to fetch value for prefered person id type.

Line 916: l_pref_per_type igs_pe_person_id_typ.person_id_type%TYPE;

912: FROM igs_en_reg_upd_int int
913: WHERE int.batch_id = p_batch_id ;
914:
915: l_batch_desc igs_en_reg_btch_int.batch_description%TYPE;
916: l_pref_per_type igs_pe_person_id_typ.person_id_type%TYPE;
917: l_person_id igs_pe_person_base_v.person_id%TYPE;
918: l_full_name igs_pe_person_base_v.full_name%TYPE;
919: l_alt_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;
920: l_batch_id_label VARCHAR2(200);

Line 917: l_person_id igs_pe_person_base_v.person_id%TYPE;

913: WHERE int.batch_id = p_batch_id ;
914:
915: l_batch_desc igs_en_reg_btch_int.batch_description%TYPE;
916: l_pref_per_type igs_pe_person_id_typ.person_id_type%TYPE;
917: l_person_id igs_pe_person_base_v.person_id%TYPE;
918: l_full_name igs_pe_person_base_v.full_name%TYPE;
919: l_alt_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;
920: l_batch_id_label VARCHAR2(200);
921: l_batch_desc_label VARCHAR2(200);

Line 918: l_full_name igs_pe_person_base_v.full_name%TYPE;

914:
915: l_batch_desc igs_en_reg_btch_int.batch_description%TYPE;
916: l_pref_per_type igs_pe_person_id_typ.person_id_type%TYPE;
917: l_person_id igs_pe_person_base_v.person_id%TYPE;
918: l_full_name igs_pe_person_base_v.full_name%TYPE;
919: l_alt_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;
920: l_batch_id_label VARCHAR2(200);
921: l_batch_desc_label VARCHAR2(200);
922: l_error_rec VARCHAR2(1):= 'N' ;