APPS.IGS_DA_TRNS_IMP dependencies on IGS_AD_ACAD_HISTORY_V

Line 356: FROM igs_ad_acad_history_v ah

352: AS
353: CURSOR c_dup_cur
354: IS
355: SELECT ah.*
356: FROM igs_ad_acad_history_v ah
357: WHERE ( person_id = acad_hist_rec.person_id
358: AND institution_code = acad_hist_rec.prev_institution_code
359: );
360:

Line 1953: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE

1949: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1950: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1951: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1952: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
1953: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
1954: )
1955: RETURN BOOLEAN
1956: IS
1957: /*===========================================================================+

Line 2011: cp_exemption_institution_cd igs_ad_acad_history_v.institution_code%TYPE

2007: check whether exemtion_inst_cd is valid or not
2008: */
2009: DECLARE
2010: CURSOR c_validate_inst (
2011: cp_exemption_institution_cd igs_ad_acad_history_v.institution_code%TYPE
2012: )
2013: IS
2014: SELECT hp.party_number tca_party_number,
2015: ihp.oss_org_unit_cd exemption_institution_cd, hp.party_name,

Line 2191: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%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
2195: /*===========================================================================+

Line 2325: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%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
2328: IS
2329: /*===========================================================================+

Line 2510: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE

2506: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2507: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2508: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2509: p_batch_id igs_da_rqst.batch_id%TYPE,
2510: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2511: )
2512: RETURN BOOLEAN
2513: IS
2514: /*===========================================================================+

Line 2661: l_prev_institution_code igs_ad_acad_history_v.institution_code%TYPE;

2657: l_person_number igs_av_lgcy_unt_int.person_number%TYPE;
2658: l_return_status VARCHAR2 (30);
2659: l_msg_count NUMBER;
2660: l_msg_data VARCHAR2 (200);
2661: l_prev_institution_code igs_ad_acad_history_v.institution_code%TYPE;
2662: l_achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE;
2663: l_institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE;
2664: l_dmmy_rowid ROWID;
2665: