APPS.IGS_DA_TRNS_IMP dependencies on IGS_AV_STND_UNIT_PKG

Line 514: igs_av_stnd_unit_pkg.delete_row (l_adv_stnd_unt.ROWID);

510: IGS_AV_STD_UNT_BASIS_PKG.delete_row (l__adv_unt_basis.ROWID);
511: END LOOP;
512:
513: -- delete advanced standing information
514: igs_av_stnd_unit_pkg.delete_row (l_adv_stnd_unt.ROWID);
515: END LOOP;
516:
517: igs_ad_term_unitdtls_pkg.delete_row (l_term_unit.ROWID);
518: END LOOP;

Line 536: igs_av_stnd_unit_pkg.delete_row (l_adv_stnd_unt.ROWID);

532: FOR l_adv_unt_basis IN c_adv_unt_basis(l_adv_stnd_unt.AV_STND_UNIT_ID)
533: LOOP
534: IGS_AV_STD_UNT_BASIS_PKG.delete_row (l_adv_unt_basis.ROWID);
535: END LOOP;
536: igs_av_stnd_unit_pkg.delete_row (l_adv_stnd_unt.ROWID);
537: END LOOP;
538:
539: FOR l_adv_stnd IN c_adv_stnd
540: LOOP

Line 2923: write_message ('Before IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION'

2919: );
2920:
2921: END IF; --IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
2922:
2923: write_message ('Before IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION'
2924: );
2925:
2926: IF NOT igs_av_stnd_unit_pkg.get_uk_for_validation (x_person_id => l_person_id,
2927: x_exemption_institution_cd => UPPER (l_prev_institution_code

Line 2926: IF NOT igs_av_stnd_unit_pkg.get_uk_for_validation (x_person_id => l_person_id,

2922:
2923: write_message ('Before IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION'
2924: );
2925:
2926: IF NOT igs_av_stnd_unit_pkg.get_uk_for_validation (x_person_id => l_person_id,
2927: x_exemption_institution_cd => UPPER (l_prev_institution_code
2928: ),
2929: x_unit_details_id => p_unit_details_id,
2930: x_tst_rslt_dtls_id => NULL,

Line 3006: igs_av_stnd_unit_pkg.insert_row (x_rowid => l_dmmy_rowid,

3002: BEGIN
3003: OPEN c_unitcd_ver;
3004: FETCH c_unitcd_ver into rec_unitcd_ver;
3005: BEGIN
3006: igs_av_stnd_unit_pkg.insert_row (x_rowid => l_dmmy_rowid,
3007: x_person_id => l_person_id,
3008: x_as_course_cd => UPPER (p_program_cd
3009: ),
3010: x_as_version_number => l_as_version_number,

Line 3070: igs_av_stnd_unit_pkg.update_row (x_rowid => l_dmmy_rowid,

3066: rec_unitcd_ver c_unitcd_ver%ROWTYPE;
3067: BEGIN
3068: OPEN c_unitcd_ver;
3069: FETCH c_unitcd_ver into rec_unitcd_ver;
3070: igs_av_stnd_unit_pkg.update_row (x_rowid => l_dmmy_rowid,
3071: x_person_id => l_person_id,
3072: x_as_course_cd => UPPER (p_program_cd
3073: ),
3074: x_as_version_number => l_as_version_number,

Line 3155: igs_av_stnd_unit_pkg.update_row (x_rowid => l_adv_stnd_unt.ROWID,

3151: rec_unitcd_ver c_unitcd_ver%ROWTYPE;
3152: BEGIN
3153: OPEN c_unitcd_ver;
3154: FETCH c_unitcd_ver into rec_unitcd_ver;
3155: igs_av_stnd_unit_pkg.update_row (x_rowid => l_adv_stnd_unt.ROWID,
3156: x_person_id => l_adv_stnd_unt.person_id,
3157: x_as_course_cd => l_adv_stnd_unt.as_course_cd,
3158: x_as_version_number => l_adv_stnd_unt.as_version_number,
3159: x_s_adv_stnd_type => l_adv_stnd_unt.s_adv_stnd_type,

Line 3189: write_message ('DONE IGS_AV_STND_UNIT_PKG.UPDATE_ROW ');

3185: );
3186:
3187: CLOSE c_unitcd_ver;
3188: END;
3189: write_message ('DONE IGS_AV_STND_UNIT_PKG.UPDATE_ROW ');
3190: END IF;
3191:
3192: CLOSE c_adv_stnd_unt;
3193: END IF; --IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION

Line 3193: END IF; --IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION

3189: write_message ('DONE IGS_AV_STND_UNIT_PKG.UPDATE_ROW ');
3190: END IF;
3191:
3192: CLOSE c_adv_stnd_unt;
3193: END IF; --IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION
3194:
3195: IF NOT create_post_unit (p_person_id => l_person_id,
3196: p_course_version => l_as_version_number,
3197: p_unit_details_id => p_unit_details_id,