APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_EN_STD_WARNINGS

Line 1079: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,

1075: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1076: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
1079: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,
1080: p_message_icon IN IGS_EN_STD_WARNINGS.message_icon%TYPE,
1081: p_message_name IN IGS_EN_STD_WARNINGS.message_name%TYPE,
1082: p_message_rule_text IN VARCHAR2,
1083: p_message_tokens IN VARCHAR2,

Line 1080: p_message_icon IN IGS_EN_STD_WARNINGS.message_icon%TYPE,

1076: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
1079: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,
1080: p_message_icon IN IGS_EN_STD_WARNINGS.message_icon%TYPE,
1081: p_message_name IN IGS_EN_STD_WARNINGS.message_name%TYPE,
1082: p_message_rule_text IN VARCHAR2,
1083: p_message_tokens IN VARCHAR2,
1084: p_message_action IN VARCHAR2,

Line 1081: p_message_name IN IGS_EN_STD_WARNINGS.message_name%TYPE,

1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
1079: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,
1080: p_message_icon IN IGS_EN_STD_WARNINGS.message_icon%TYPE,
1081: p_message_name IN IGS_EN_STD_WARNINGS.message_name%TYPE,
1082: p_message_rule_text IN VARCHAR2,
1083: p_message_tokens IN VARCHAR2,
1084: p_message_action IN VARCHAR2,
1085: p_destination IN IGS_EN_STD_WARNINGS.destination%TYPE,

Line 1085: p_destination IN IGS_EN_STD_WARNINGS.destination%TYPE,

1081: p_message_name IN IGS_EN_STD_WARNINGS.message_name%TYPE,
1082: p_message_rule_text IN VARCHAR2,
1083: p_message_tokens IN VARCHAR2,
1084: p_message_action IN VARCHAR2,
1085: p_destination IN IGS_EN_STD_WARNINGS.destination%TYPE,
1086: p_parameters IN IGS_EN_STD_WARNINGS.p_parameters%TYPE,
1087: p_step_type IN IGS_EN_STD_WARNINGS.step_type%TYPE) AS
1088:
1089: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1086: p_parameters IN IGS_EN_STD_WARNINGS.p_parameters%TYPE,

1082: p_message_rule_text IN VARCHAR2,
1083: p_message_tokens IN VARCHAR2,
1084: p_message_action IN VARCHAR2,
1085: p_destination IN IGS_EN_STD_WARNINGS.destination%TYPE,
1086: p_parameters IN IGS_EN_STD_WARNINGS.p_parameters%TYPE,
1087: p_step_type IN IGS_EN_STD_WARNINGS.step_type%TYPE) AS
1088:
1089: PRAGMA AUTONOMOUS_TRANSACTION;
1090:

Line 1087: p_step_type IN IGS_EN_STD_WARNINGS.step_type%TYPE) AS

1083: p_message_tokens IN VARCHAR2,
1084: p_message_action IN VARCHAR2,
1085: p_destination IN IGS_EN_STD_WARNINGS.destination%TYPE,
1086: p_parameters IN IGS_EN_STD_WARNINGS.p_parameters%TYPE,
1087: p_step_type IN IGS_EN_STD_WARNINGS.step_type%TYPE) AS
1088:
1089: PRAGMA AUTONOMOUS_TRANSACTION;
1090:
1091: -------------------------------------------------------------------------------------------

Line 1115: FROM igs_en_std_warnings warn

1111: -- UNIT step : person_id,course_cd,p_term_cal_type,p_term_ci_sequence_number,step_type,uoo_id,message_name
1112:
1113: CURSOR c_rec_exists IS
1114: SELECT ROWID,warn.*
1115: FROM igs_en_std_warnings warn
1116: WHERE person_id = p_person_id
1117: AND course_cd = p_course_cd
1118: AND term_cal_type = p_term_cal_type
1119: AND term_ci_sequence_number = p_term_ci_sequence_number

Line 1162: IGS_EN_STD_WARNINGS_PKG.INSERT_ROW (

1158: OPEN c_rec_exists;
1159: FETCH c_rec_exists INTO l_warn_rec;
1160: IF c_rec_exists%NOTFOUND THEN
1161:
1162: IGS_EN_STD_WARNINGS_PKG.INSERT_ROW (
1163: x_rowid => l_row_id,
1164: x_warning_id => x_warning_id,
1165: x_person_id => p_person_id,
1166: x_course_cd => p_course_cd,

Line 1181: IGS_EN_STD_WARNINGS_PKG.UPDATE_ROW (

1177: x_step_type => p_step_type,
1178: x_session_id => igs_en_add_units_api.g_ss_session_id,
1179: x_mode => 'R' );
1180: ELSE -- update the row
1181: IGS_EN_STD_WARNINGS_PKG.UPDATE_ROW (
1182: x_rowid => l_warn_rec.rowid,
1183: x_warning_id => l_warn_rec.warning_id,
1184: x_person_id => p_person_id,
1185: x_course_cd => p_course_cd,