APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_EN_STD_WARNINGS

Line 44: FROM igs_en_std_warnings

40: -------------------------------------------------------------------------------------------
41:
42: CURSOR get_deny_warn(cp_msg_icon VARCHAR2) IS
43: SELECT 'X'
44: FROM igs_en_std_warnings
45: WHERE person_id = p_person_id
46: AND course_cd = p_course_cd
47: AND term_cal_type = p_load_cal_type
48: AND term_ci_sequence_number = p_load_sequence_number

Line 54: FROM igs_en_std_warnings

50: AND step_type <> 'DROP';
51:
52: CURSOR get_error_warn IS
53: SELECT 'X'
54: FROM igs_en_std_warnings
55: WHERE person_id = p_person_id
56: AND course_cd = p_course_cd
57: AND term_cal_type = p_load_cal_type
58: AND term_ci_sequence_number = p_load_sequence_number

Line 63: l_msg_icon igs_en_std_warnings.message_icon%TYPE;

59: AND message_icon <> 'D'
60: AND step_type <> 'DROP';
61:
62: l_deny_warn VARCHAR2(1);
63: l_msg_icon igs_en_std_warnings.message_icon%TYPE;
64:
65: BEGIN
66:
67: l_deny_warn := NULL;

Line 231: FROM igs_en_std_warnings

227:
228: -- cursor to get distinct uooids in warnings table with message icon as 'D'
229: CURSOR c_dist_uooids IS
230: SELECT DISTINCT uoo_id
231: FROM igs_en_std_warnings
232: WHERE person_id = p_person_id
233: AND course_cd = p_course_cd
234: AND term_cal_type = p_load_cal_type
235: AND term_ci_sequence_number = p_load_sequence_number

Line 259: FROM igs_en_std_warnings warn

255: AND cart_error_flag = 'Y';
256:
257: CURSOR get_warn_rec (cp_uoo_id NUMBER) IS
258: SELECT ROWID,warn.*
259: FROM igs_en_std_warnings warn
260: WHERE warn.person_id = p_person_id
261: AND warn.course_cd = p_course_cd
262: AND warn.term_cal_type = p_load_cal_type
263: AND warn.term_ci_sequence_number = p_load_sequence_number

Line 309: IGS_EN_STD_WARNINGS_PKG.UPDATE_ROW (

305: IF l_sua_exists IS NULL AND l_ps_rec_exists IS NULL THEN
306:
307: FOR l_warn_rec IN get_warn_rec(dist.uoo_id) LOOP
308:
309: IGS_EN_STD_WARNINGS_PKG.UPDATE_ROW (
310: x_rowid => l_warn_rec.rowid,
311: x_warning_id => l_warn_rec.warning_id,
312: x_person_id => p_person_id,
313: x_course_cd => p_course_cd,

Line 459: FROM IGS_EN_STD_WARNINGS

455:
456: -- -- cursor to get the warnings records against the person,course and uooid/message_for
457: CURSOR c_ss_warn IS
458: SELECT ROWID
459: FROM IGS_EN_STD_WARNINGS
460: WHERE person_id = p_person_id
461: AND course_cd = p_course_cd
462: AND term_cal_type = p_load_cal_type
463: AND term_ci_sequence_number = p_load_sequence_number

Line 486: IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid => l_rowid);

482: CLOSE c_ss_warn;
483: EXIT;
484: END IF;
485:
486: IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid => l_rowid);
487:
488:
489: END LOOP;
490: ELSE

Line 497: FROM IGS_EN_STD_WARNINGS

493:
494: IF p_uoo_id IS NOT NULL THEN
495:
496: l_stmt := 'SELECT ROWID
497: FROM IGS_EN_STD_WARNINGS
498: WHERE person_id = :p_person_id
499: AND course_cd = :p_course_cd
500: AND term_cal_type = :p_load_cal_type
501: AND term_ci_sequence_number = :p_load_sequence_number

Line 509: FROM IGS_EN_STD_WARNINGS

505:
506: ELSE
507:
508: l_stmt := 'SELECT ROWID
509: FROM IGS_EN_STD_WARNINGS
510: WHERE person_id = :p_person_id
511: AND course_cd = :p_course_cd
512: AND term_cal_type = :p_load_cal_type
513: AND term_ci_sequence_number = :p_load_sequence_number

Line 527: IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid => l_rowid);

523: CLOSE c_ss_warn_of_steps;
524: EXIT;
525: END IF;
526:
527: IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid => l_rowid);
528:
529:
530: END LOOP;
531:

Line 2101: l_message_for igs_en_std_warnings.message_for%TYPE;

2097:
2098: l_message_name VARCHAR2(30);
2099: l_message_name2 VARCHAR2(30);
2100: l_return_type VARCHAR2(50);
2101: l_message_for igs_en_std_warnings.message_for%TYPE;
2102:
2103: BEGIN
2104: IF NOT IGS_EN_VAL_ENCMB.enrp_val_enr_encmb(p_person_id => p_person_id,
2105: p_course_cd => p_course_cd ,

Line 5125: FROM IGS_EN_STD_WARNINGS

5121: AND cart_error_flag = 'Y';
5122:
5123: CURSOR c_ss_warn IS
5124: SELECT ROWID
5125: FROM IGS_EN_STD_WARNINGS
5126: WHERE person_id = p_person_id
5127: AND course_cd = p_course_cd
5128: AND term_cal_type = p_load_cal_type
5129: AND term_ci_sequence_number = p_load_sequence_number

Line 5142: IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid => c_ss_warn_rec.rowid);

5138:
5139: END LOOP;
5140:
5141: FOR c_ss_warn_rec IN c_ss_warn LOOP
5142: IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid => c_ss_warn_rec.rowid);
5143: END LOOP;
5144:
5145:
5146: EXCEPTION

Line 5632: FROM IGS_EN_STD_WARNINGS

5628: ) AS
5629: PRAGMA AUTONOMOUS_TRANSACTION;
5630: CURSOR c_get_warnings IS
5631: SELECT ROWID
5632: FROM IGS_EN_STD_WARNINGS
5633: WHERE person_id = p_person_id
5634: AND course_cd = p_course_cd
5635: AND term_cal_type = p_load_cal_type
5636: AND term_ci_sequence_number = p_load_sequence_number

Line 5641: IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid => c_get_warnings_rec.ROWID);

5637: AND step_type <> 'PERSON';
5638: BEGIN
5639: p_delete_message_count := 0;
5640: FOR c_get_warnings_rec IN c_get_warnings LOOP
5641: IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid => c_get_warnings_rec.ROWID);
5642: p_delete_message_count := p_delete_message_count + 1;
5643: END LOOP;
5644:
5645: COMMIT;