APPS.IGS_AV_GEN_001 dependencies on IGS_AV_ADV_STANDING

Line 84: FROM IGS_AV_ADV_STANDING_ALL asal

80: asua.as_course_cd = p_course_cd ;
81:
82: CURSOR c_adv_all IS
83: SELECT rowid
84: FROM IGS_AV_ADV_STANDING_ALL asal
85: WHERE asal.person_id = p_person_id AND
86: asal.course_cd = p_course_cd;
87:
88: CURSOR c_unit_lvl_all IS

Line 189: igs_av_adv_standing_pkg.DELETE_ROW (

185: END LOOP;
186:
187: FOR v_adv_all IN c_adv_all
188: LOOP
189: igs_av_adv_standing_pkg.DELETE_ROW (
190: X_ROWID => v_adv_all.rowid );
191:
192: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
193: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted from IGS_AV_ADV_STANDING_ALL');

Line 193: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted from IGS_AV_ADV_STANDING_ALL');

189: igs_av_adv_standing_pkg.DELETE_ROW (
190: X_ROWID => v_adv_all.rowid );
191:
192: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
193: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted from IGS_AV_ADV_STANDING_ALL');
194: END IF;
195:
196: END LOOP;
197:

Line 461: v_advanced_standing IGS_AV_ADV_STANDING%ROWTYPE;

457: v_major_exmpt_inst VARCHAR2(64);
458: v_exemption_institution_cd IGS_AV_STND_UNIT_CREDIT_V.exemption_institution_cd%TYPE;
459: v_max_credit NUMBER(5);
460: v_check CHAR;
461: v_advanced_standing IGS_AV_ADV_STANDING%ROWTYPE;
462: CURSOR c_ascv IS
463: SELECT suc.exemption_institution_cd,
464: SUM (suc.credit)
465: FROM (SELECT asu.person_id person_id,

Line 513: FROM IGS_AV_ADV_STANDING

509: AND ihp.inst_org_ind = 'I'
510: AND ihp.oi_os_ind = 'Y';
511: CURSOR c_advanced_standing IS
512: SELECT *
513: FROM IGS_AV_ADV_STANDING
514: WHERE person_id = p_person_id AND
515: course_cd = p_course_cd AND
516: version_number = p_version_number
517: FOR UPDATE OF exemption_institution_cd NOWAIT;

Line 563: UPDATE IGS_AV_ADV_STANDING

559: CLOSE c_ascv;
560: OPEN c_advanced_standing;
561: FETCH c_advanced_standing INTO v_advanced_standing;
562: IF (c_advanced_standing%FOUND) THEN
563: UPDATE IGS_AV_ADV_STANDING
564: SET exemption_institution_cd = v_major_exmpt_inst
565: WHERE CURRENT OF c_advanced_standing;
566: END IF;
567: CLOSE c_advanced_standing;

Line 1239: FROM IGS_AV_ADV_STANDING adv

1235: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1236: cp_version_number IGS_AV_STND_UNIT.as_version_number%TYPE
1237: ) IS
1238: SELECT rowid , adv.*
1239: FROM IGS_AV_ADV_STANDING adv
1240: WHERE adv.person_id = cp_person_id AND
1241: adv.course_cd = cp_course_cd AND
1242: adv.version_number = cp_version_number AND
1243: adv.exemption_institution_cd = p_exemption_institution_cd;

Line 1302: IGS_AV_ADV_STANDING_PKG.Update_Row(

1298: ) LOOP
1299: -- set that a record has been found
1300: v_adv_stnd_recs_found := TRUE;
1301: -- ****************************************************************************************
1302: IGS_AV_ADV_STANDING_PKG.Update_Row(
1303: X_Rowid => v_adv_stnd.rowid,
1304: X_PERSON_ID => v_adv_stnd.person_id,
1305: X_COURSE_CD => v_adv_stnd.course_cd,
1306: X_VERSION_NUMBER => v_adv_stnd.version_number ,

Line 2158: FROM igs_av_adv_standing_all

2154:
2155: CURSOR c_adv_stnd
2156: IS
2157: SELECT *
2158: FROM igs_av_adv_standing_all
2159: WHERE person_id = p_person_id
2160: AND course_cd = p_course_cd
2161: AND version_number = p_version_number;
2162:

Line 2227: UPDATE igs_av_adv_standing_all

2223: INTO l_grnt_val;
2224:
2225: CLOSE c_granted;
2226:
2227: UPDATE igs_av_adv_standing_all
2228: SET total_exmptn_approved = l_app_val,
2229: total_exmptn_granted = l_grnt_val
2230: WHERE person_id = p_person_id
2231: AND course_cd = p_course_cd