APPS.IGS_EN_SPA_TERMS_API dependencies on IGS_PE_PERSON

Line 4: CURSOR c_term_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,

1: PACKAGE BODY IGS_EN_SPA_TERMS_API AS
2: /* $Header: IGSENB1B.pls 120.14 2005/11/28 02:26:46 appldev noship $ */
3:
4: CURSOR c_term_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,
5: cp_program_cd IGS_PS_VER.course_cd%TYPE,
6: cp_program_version IGS_PS_VER.version_number%TYPE,
7: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
8: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

Line 91: FUNCTION find_key_effective_for(p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,

87:
88: END validate_term_rec;
89:
90:
91: FUNCTION find_key_effective_for(p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
92: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
93: p_term_sequence_number IN igs_ca_inst.sequence_number%TYPE) RETURN VARCHAR2
94: AS
95: -- Check if key term record exists for the passed in term calendar

Line 399: CURSOR c_term_rec_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,

395: Who When What
396: ----------------------------------------------------------------------*/
397:
398: vc_career_model_enabled VARCHAR2(1);
399: CURSOR c_term_rec_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,
400: cp_program_cd IGS_PS_VER.course_cd%TYPE,
401: cp_program_version IGS_PS_VER.version_number%TYPE,
402: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
403: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS