DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 50: p_id_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

46:
47: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
48: PROCEDURE get_alt_pers_id
49: (p_person_id IN igs_pe_person.person_id%TYPE,
50: p_id_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
51: p_api_id OUT NOCOPY VARCHAR2,
52: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
53: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
54:

Line 139: p_ucasnum IN igs_pe_alt_pers_id.api_person_id%TYPE,

135: PROCEDURE get_yr_left_last_inst
136: (p_person_id IN igs_pe_person.person_id%TYPE,
137: p_com_dt IN DATE,
138: p_hesa_gen_qaim IN VARCHAR2,
139: p_ucasnum IN igs_pe_alt_pers_id.api_person_id%TYPE,
140: p_year OUT NOCOPY VARCHAR2);
141:
142: PROCEDURE get_new_ent_to_he
143: (p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

Line 649: p_ucasnum OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,

645:
646: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
647: PROCEDURE get_ucasnum
648: (p_person_id IN igs_pe_person.person_id%TYPE,
649: p_ucasnum OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
650: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
651: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
652:
653: PROCEDURE get_marital_status