APPS.IGS_DA_TRNS_IMP dependencies on IGS_EN_STDNT_PS_ATT

Line 1762: p_as_version_number IN OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE

1758: p_s_adv_stnd_type IN OUT NOCOPY igs_av_stnd_unit_all.s_adv_stnd_type%TYPE,
1759: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1760: p_seq_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1761: p_auth_pers_id IN OUT NOCOPY igs_pe_person.person_id%TYPE,
1762: p_as_version_number IN OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE
1763: )
1764: RETURN BOOLEAN
1765: IS
1766: /*===========================================================================+

Line 2126: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

2122: check the course_attempt_status
2123: */
2124: DECLARE
2125: CURSOR c_exists (
2126: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
2127: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
2128: )
2129: IS
2130: SELECT 'x'

Line 2127: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE

2123: */
2124: DECLARE
2125: CURSOR c_exists (
2126: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
2127: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
2128: )
2129: IS
2130: SELECT 'x'
2131: FROM igs_en_stdnt_ps_att

Line 2131: FROM igs_en_stdnt_ps_att

2127: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
2128: )
2129: IS
2130: SELECT 'x'
2131: FROM igs_en_stdnt_ps_att
2132: WHERE person_id = cp_person_id
2133: AND course_cd = cp_course_cd
2134: AND course_attempt_status IN
2135: ('ENROLLED',

Line 2190: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

2186: p_institution_cd IN igs_av_lgcy_unt_int.institution_cd%TYPE,
2187: p_person_id IN igs_pe_person.person_id%TYPE,
2188: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2189: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2190: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2191: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2192: )
2193: RETURN BOOLEAN
2194: IS

Line 2323: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

2319: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
2320: p_person_id IN igs_pe_person.person_id%TYPE,
2321: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2322: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2323: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2324: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2325: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2326: )
2327: RETURN BOOLEAN

Line 2447: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

2443: check the course_attempt_status
2444: */
2445: DECLARE
2446: CURSOR c_exists (
2447: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
2448: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
2449: )
2450: IS
2451: SELECT 'x'

Line 2448: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE

2444: */
2445: DECLARE
2446: CURSOR c_exists (
2447: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
2448: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
2449: )
2450: IS
2451: SELECT 'x'
2452: FROM igs_en_stdnt_ps_att

Line 2452: FROM igs_en_stdnt_ps_att

2448: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
2449: )
2450: IS
2451: SELECT 'x'
2452: FROM igs_en_stdnt_ps_att
2453: WHERE person_id = cp_person_id
2454: AND course_cd = cp_course_cd
2455: AND course_attempt_status IN
2456: ('ENROLLED',

Line 2646: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;

2642: l_s_adv_stnd_type igs_av_stnd_unit_all.s_adv_stnd_type%TYPE;
2643: l_cal_type igs_ca_inst.cal_type%TYPE;
2644: l_seq_number igs_ca_inst.sequence_number%TYPE;
2645: l_auth_pers_id igs_pe_person.person_id%TYPE;
2646: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
2647: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
2648: l_request_id igs_av_stnd_unit_all.request_id%TYPE;
2649: l_program_id igs_av_stnd_unit_all.program_id%TYPE;
2650: l_program_application_id igs_av_stnd_unit_all.program_application_id%TYPE;