[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pei.image_dt
FROM IGS_PE_PERSON_IMAGE pei
WHERE pei.person_id = p_person_id AND
pei.PERSON_IMAGE IS NOT NULL
ORDER BY pei.image_dt DESC;
SELECT 'x'
FROM IGS_PE_ALT_PERS_ID api
WHERE pe_person_id = p_person_id AND
(api.start_dt IS NULL OR
api.start_dt <= p_effective_dt) AND
(api.end_dt IS NULL OR
api.end_dt >= p_effective_dt) AND
(api.start_dt <> api.end_dt OR
api.end_dt IS NULL);
SELECT 'x'
FROM IGS_PE_ADDR_V
WHERE person_id = p_person_id;
SELECT 'x'
FROM IGS_PE_PERS_DISABLTY
WHERE person_id = p_person_id;
SELECT 'x'
FROM IGS_PE_VISA iv
WHERE iv.person_id = p_person_id AND
(iv.visa_expiry_date IS NULL OR
iv.visa_expiry_date > p_effective_dt);
SELECT 'x'
FROM IGS_PE_PERS_NOTE pn
WHERE pn.person_id = p_person_id;
SELECT 'x'
FROM HZ_PARTIES ps
WHERE ps.party_id = p_person_id ;
SELECT 'x'
FROM IGS_PE_PERSON_ALIAS pal
WHERE pal.person_id = p_person_id AND
(pal.start_dt IS NULL OR
pal.start_dt <= p_effective_dt) AND
(pal.end_dt IS NULL OR
pal.end_dt >= p_effective_dt);
SELECT daiv.alias_val
FROM IGS_EN_CAL_CONF secc,
IGS_CA_DA_INST_V daiv
WHERE secc.s_control_num = 1 AND
daiv.dt_alias = DECODE(p_date_type,
'ENROLLED',NVL(secc.enrolled_rule_cutoff_dt_alias, 'NULL'),
'INVALID', NVL(secc.invalid_rule_cutoff_dt_alias,'NULL'),
'NULL' ) AND
daiv.cal_type = p_cal_type AND
daiv.ci_sequence_number = p_ci_sequence_number;
SELECT DECODE(cp_column_name, 'VERSION_NUMBER', TO_CHAR(scah.version_number),
'cal_type', scah.cal_type,
'LOCATION_CD', scah.location_cd,
'attendance_mode', scah.attendance_mode,
'attendance_type', scah.attendance_type,
'STUDENT_CONFIRMED_IND', scah.student_confirmed_ind,
'COMMENCEMENT_DT', igs_ge_date.igscharDT(scah.commencement_dt),
'COURSE_ATTEMPT_STATUS', scah.course_attempt_status,
'DERIVED_ATT_TYPE', scah.derived_att_type,
'DERIVED_ATT_MODE', scah.derived_att_mode,
'PROVISIONAL_IND', scah.provisional_ind,
'DISCONTINUED_DT', igs_ge_date.igschar(scah.discontinued_dt),
'DISCONTINUATION_REASON_CD', scah.DISCONTINUATION_REASON_CD,
'FUNDING_SOURCE', scah.FUNDING_SOURCE,
'EXAM_LOCATION_CD', scah.exam_location_cd,
'DERIVED_COMPLETION_YR', TO_CHAR(scah.derived_completion_yr),
'DERIVED_COMPLETION_PERD', scah.derived_completion_perd,
'NOMINATED_COMPLETION_YR', TO_CHAR(scah.nominated_completion_yr),
'NOMINATED_COMPLETION_PERD', scah.nominated_completion_perd,
'RULE_CHECK_IND', scah.rule_check_ind,
'WAIVE_OPTION_CHECK_IND', scah.waive_option_check_ind,
'LAST_RULE_CHECK_DT', igs_ge_date.igschar(scah.last_rule_check_dt),
'PUBLISH_OUTCOMES_IND', scah.publish_outcomes_ind,
'COURSE_RQRMNT_COMPLETE_IND', scah.course_rqrmnt_complete_ind,
'OVERRIDE_TIME_LIMITATION', TO_CHAR(scah.override_time_limitation),
'ADVANCED_STANDING_IND', scah.advanced_standing_ind,
'FEE_CAT', scah.FEE_CAT,
'IGS_CO_CAT', scah.CORRESPONDENCE_CAT,
'SELF_HELP_GROUP_IND', scah.self_help_group_ind,
'PRIMARY_PROGRAM_TYPE', primary_program_type, --Bug 2162747 by vvutukur
'KEY_PROGRAM', key_program) --Bug 2162747 by vvutukur
FROM IGS_AS_SC_ATTEMPT_H scah
WHERE scah.person_id = cp_person_id AND
scah.course_cd = cp_course_cd AND
scah.hist_start_dt >= cp_hist_end_dt
ORDER BY
scah.hist_start_dt ASC;
SELECT scae.enr_form_due_dt
FROM IGS_AS_SC_ATMPT_ENR scae
WHERE scae.person_id = p_person_id AND
scae.course_cd = p_course_cd AND
scae.cal_type = p_cal_type AND
scae.ci_sequence_number = p_ci_sequence_number AND
scae.enr_form_due_dt IS NOT NULL;
SELECT IGS_CA_GEN_001.calp_set_alias_value(
daiv.absolute_val,
IGS_CA_GEN_002.cals_clc_dt_from_dai(
daiv.ci_sequence_number,
daiv.CAL_TYPE,
daiv.DT_ALIAS,
daiv.sequence_number) ) alias_val
FROM IGS_EN_CAL_CONF secc,
IGS_CA_DA_INST daiv
WHERE secc.s_control_num = 1 AND
daiv.cal_type = p_cal_type AND
daiv.ci_sequence_number = p_ci_sequence_number AND
daiv.dt_alias = secc.enr_form_due_dt_alias AND
IGS_CA_GEN_001.calp_set_alias_value(
daiv.absolute_val,
IGS_CA_GEN_002.cals_clc_dt_from_dai(
daiv.ci_sequence_number,
daiv.CAL_TYPE,
daiv.DT_ALIAS,
daiv.sequence_number) ) IS NOT NULL
ORDER BY 1 DESC; -- gives latest date first
SELECT record_open_dt_alias,
record_cutoff_dt_alias
FROM IGS_PE_USR_ARG_ALL
WHERE person_type = cp_person_type;
SELECT alias_val FROM IGS_CA_DA_INST_V
WHERE cal_type = cp_cal_type
AND ci_sequence_number = cp_ci_sequence_number
AND dt_alias = cp_dt_alias
AND alias_val IS NOT NULL
ORDER BY alias_val ASC;
SELECT alias_val FROM IGS_CA_DA_INST_V
WHERE cal_type = cp_cal_type
AND ci_sequence_number = cp_ci_sequence_number
AND dt_alias = cp_dt_alias
AND alias_val IS NOT NULL
ORDER BY alias_val DESC;
SELECT non_std_usec_ind FROM IGS_PS_UNIT_OFR_OPT
WHERE uoo_id = p_uoo_id;
SELECT enr_dl_date
FROM IGS_EN_NSTD_USEC_DL
WHERE function_name = 'RECORD_CUTOFF'
AND uoo_id = cp_uoo_id;
SELECT record_open_dt_alias
FROM IGS_EN_CAL_CONF
WHERE s_control_num = 1;
SELECT record_open_dt_alias,
record_cutoff_dt_alias
FROM IGS_EN_CAL_CONF
WHERE s_control_num = 1;
SELECT DISTINCT cir.sup_cal_type,
cir.sup_ci_sequence_number
FROM IGS_EN_SU_ATTEMPT sua,
IGS_CA_INST_REL cir,
IGS_CA_INST ci,
IGS_CA_TYPE cat,
IGS_CA_STAT cs
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status <> cst_unconfirm AND
cir.sub_cal_type = sua.cal_type AND
cir.sub_ci_sequence_number = sua.ci_sequence_number AND
ci.cal_type = cir.sup_cal_type AND
ci.sequence_number = cir.sup_ci_sequence_number AND
cat.cal_type = ci.cal_type AND
cat.S_CAL_CAT = cst_academic AND
cs.CAL_STATUS = ci.CAL_STATUS AND
ci.start_dt < p_acad_start_dt;
mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in update row of IGS_EN_SU_ATTEMPT
for Bug 2554109 MINI Waitlist Build for Jan 03 Release
ayedubat 02-JUL-2002 Added a new validation to check the Variation Window Cutoff Date
for the bug Fix:2423605
ayedubat 26-JUN-2002 Changed the width of the variable,l_adm_unit_status_ret to VARCHAR2(255)
and also removed the exception handler for the bug fix:2423605
rvangala 07-OCT-03 Passing core_indicator_code to IGS_EN_SUA-API.UPDATE_UNIT_ATTEMPT added as part of Prevent Dropping
Core Units. Enh Bug# 3052432
amuthu 9-Aug-2006 If the default drop reason cannot be determined then
-- stopping the further processing and showing a newly added message*/
DECLARE
l_unit_attempt VARCHAR2(1);
SELECT U.*
FROM IGS_EN_SU_ATTEMPT U
WHERE person_id = p_person_id
AND ((unit_attempt_status IN ('ENROLLED','INVALID','WAITLISTED'))
OR (unit_attempt_status = 'DUPLICATE' AND P_UOO_ID IS NOT NULL))
AND course_cd = p_program_cd AND ((p_uoo_id IS NULL) OR (uoo_id = p_uoo_id));
SELECT 'x'
FROM igs_ca_load_to_teach_v
WHERE load_cal_type = p_load_cal_type
AND load_ci_sequence_number = p_load_ci_seq_number
AND teach_cal_type = p_tch_cal_type
AND teach_ci_sequence_number = p_tch_ci_seq_number;
IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(X_ROWID => c_unit_attempt_rec.row_id);
igs_en_sua_api.update_unit_attempt (
X_ROWID => c_unit_attempt_rec.row_id,
X_PERSON_ID => c_unit_attempt_rec.person_id,
X_COURSE_CD => c_unit_attempt_rec.course_cd,
X_UNIT_CD => c_unit_attempt_rec.unit_cd,
X_CAL_TYPE => c_unit_attempt_rec.cal_type,
X_CI_SEQUENCE_NUMBER => c_unit_attempt_rec.ci_sequence_number,
X_VERSION_NUMBER => c_unit_attempt_rec.version_number,
X_LOCATION_CD => c_unit_attempt_rec.location_cd,
X_UNIT_CLASS => c_unit_attempt_rec.unit_class,
X_CI_START_DT => c_unit_attempt_rec.ci_start_dt,
X_CI_END_DT => c_unit_attempt_rec.ci_end_dt,
X_UOO_ID => c_unit_attempt_rec.uoo_id,
X_ENROLLED_DT => c_unit_attempt_rec.enrolled_dt,
X_UNIT_ATTEMPT_STATUS => 'DROPPED',
X_ADMINISTRATIVE_UNIT_STATUS => NULL,
X_DISCONTINUED_DT => nvl(p_effective_date,trunc(SYSDATE)),
X_RULE_WAIVED_DT =>c_unit_attempt_rec.rule_waived_dt,
X_RULE_WAIVED_PERSON_ID =>c_unit_attempt_rec.rule_waived_person_id,
X_NO_ASSESSMENT_IND => c_unit_attempt_rec.no_assessment_ind,
X_SUP_UNIT_CD => c_unit_attempt_rec.sup_unit_cd,
X_SUP_VERSION_NUMBER => c_unit_attempt_rec.sup_version_number,
X_EXAM_LOCATION_CD => c_unit_attempt_rec.exam_location_cd,
X_ALTERNATIVE_TITLE => c_unit_attempt_rec.alternative_title,
X_OVERRIDE_ENROLLED_CP => c_unit_attempt_rec.override_enrolled_cp,
X_OVERRIDE_EFTSU => c_unit_attempt_rec.override_eftsu,
X_OVERRIDE_ACHIEVABLE_CP => c_unit_attempt_rec.override_achievable_cp,
X_OVERRIDE_OUTCOME_DUE_DT => c_unit_attempt_rec.override_outcome_due_dt,
X_OVERRIDE_CREDIT_REASON => c_unit_attempt_rec.override_credit_reason,
X_ADMINISTRATIVE_PRIORITY => c_unit_attempt_rec.administrative_priority,
X_WAITLIST_DT => c_unit_attempt_rec.waitlist_dt,
X_DCNT_REASON_CD => p_dcnt_reason_cd,
X_MODE => 'R',
X_GS_VERSION_NUMBER => c_unit_attempt_rec.gs_version_number,
X_ENR_METHOD_TYPE => c_unit_attempt_rec.enr_method_type,
X_FAILED_UNIT_RULE => c_unit_attempt_rec.failed_unit_rule,
X_CART => c_unit_attempt_rec.cart,
X_RSV_SEAT_EXT_ID => c_unit_attempt_rec.rsv_seat_ext_id,
X_ORG_UNIT_CD => c_unit_attempt_rec.org_unit_cd,
-- Added the column grading schema code as a part of the bug 2037897. - aiyer
X_GRADING_SCHEMA_CODE => c_unit_attempt_rec.grading_schema_code,
-- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
X_SESSION_ID => c_unit_attempt_rec.session_id,
--Added the column deg_aud_detail_id as part of Degree Audit Interface build. Bug# 2033208 - pradhakr
X_DEG_AUD_DETAIL_ID => c_unit_attempt_rec.deg_aud_detail_id,
X_SUBTITLE => c_unit_attempt_rec.subtitle,
--Added the columns student_career_transcript,student_career_statistics as part of Career Impact DLD
-- part 2 . Bug # svenkata
X_STUDENT_CAREER_TRANSCRIPT => c_unit_attempt_rec.student_career_transcript,
X_STUDENT_CAREER_STATISTICS => c_unit_attempt_rec.student_career_statistics,
X_ATTRIBUTE_CATEGORY => c_unit_attempt_rec.attribute_category,
X_ATTRIBUTE1 => c_unit_attempt_rec.attribute1,
X_ATTRIBUTE2 => c_unit_attempt_rec.attribute2,
X_ATTRIBUTE3 => c_unit_attempt_rec.attribute3,
X_ATTRIBUTE4 => c_unit_attempt_rec.attribute4,
X_ATTRIBUTE5 => c_unit_attempt_rec.attribute5,
X_ATTRIBUTE6 => c_unit_attempt_rec.attribute6,
X_ATTRIBUTE7 => c_unit_attempt_rec.attribute7,
X_ATTRIBUTE8 => c_unit_attempt_rec.attribute8,
X_ATTRIBUTE9 => c_unit_attempt_rec.attribute9,
X_ATTRIBUTE10 => c_unit_attempt_rec.attribute10,
X_ATTRIBUTE11 => c_unit_attempt_rec.attribute11,
X_ATTRIBUTE12 => c_unit_attempt_rec.attribute12,
X_ATTRIBUTE13 => c_unit_attempt_rec.attribute13,
X_ATTRIBUTE14 => c_unit_attempt_rec.attribute14,
X_ATTRIBUTE15 => c_unit_attempt_rec.attribute15,
X_ATTRIBUTE16 => c_unit_attempt_rec.attribute16,
X_ATTRIBUTE17 => c_unit_attempt_rec.attribute17,
X_ATTRIBUTE18 => c_unit_attempt_rec.attribute18,
X_ATTRIBUTE19 => c_unit_attempt_rec.attribute19,
X_ATTRIBUTE20 => c_unit_attempt_rec.attribute20,
X_WAITLIST_MANUAL_IND => c_unit_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.,
X_WLST_PRIORITY_WEIGHT_NUM => c_unit_attempt_rec.wlst_priority_weight_num,
X_WLST_PREFERENCE_WEIGHT_NUM=> c_unit_attempt_rec.wlst_preference_weight_num,
-- CORE_INDICATOR_CODE --added by rvangala 07-OCT-2003. Enh Bug# 3052432
x_CORE_INDICATOR_CODE => c_unit_attempt_rec.core_indicator_code
);
igs_en_sua_api.update_unit_attempt(
X_ROWID => c_unit_attempt_rec.row_id,
X_PERSON_ID => c_unit_attempt_rec.person_id,
X_COURSE_CD => c_unit_attempt_rec.course_cd,
X_UNIT_CD => c_unit_attempt_rec.unit_cd,
X_CAL_TYPE => c_unit_attempt_rec.cal_type,
X_CI_SEQUENCE_NUMBER => c_unit_attempt_rec.ci_sequence_number,
X_VERSION_NUMBER => c_unit_attempt_rec.version_number,
X_LOCATION_CD => c_unit_attempt_rec.location_cd,
X_UNIT_CLASS => c_unit_attempt_rec.unit_class,
X_CI_START_DT => c_unit_attempt_rec.ci_start_dt,
X_CI_END_DT => c_unit_attempt_rec.ci_end_dt,
X_UOO_ID => c_unit_attempt_rec.uoo_id,
X_ENROLLED_DT => c_unit_attempt_rec.enrolled_dt,
X_UNIT_ATTEMPT_STATUS => 'DISCONTIN',
X_ADMINISTRATIVE_UNIT_STATUS => l_adm_unit_status_ret,
X_DISCONTINUED_DT => p_effective_date,
X_RULE_WAIVED_DT =>c_unit_attempt_rec.rule_waived_dt,
X_RULE_WAIVED_PERSON_ID =>c_unit_attempt_rec.rule_waived_person_id,
X_NO_ASSESSMENT_IND => c_unit_attempt_rec.no_assessment_ind,
X_SUP_UNIT_CD => c_unit_attempt_rec.sup_unit_cd,
X_SUP_VERSION_NUMBER => c_unit_attempt_rec.sup_version_number,
X_EXAM_LOCATION_CD => c_unit_attempt_rec.exam_location_cd,
X_ALTERNATIVE_TITLE => c_unit_attempt_rec.alternative_title,
X_OVERRIDE_ENROLLED_CP => c_unit_attempt_rec.override_enrolled_cp,
X_OVERRIDE_EFTSU => c_unit_attempt_rec.override_eftsu,
X_OVERRIDE_ACHIEVABLE_CP => c_unit_attempt_rec.override_achievable_cp,
X_OVERRIDE_OUTCOME_DUE_DT => c_unit_attempt_rec.override_outcome_due_dt,
X_OVERRIDE_CREDIT_REASON => c_unit_attempt_rec.override_credit_reason,
X_ADMINISTRATIVE_PRIORITY => c_unit_attempt_rec.administrative_priority,
X_WAITLIST_DT => c_unit_attempt_rec.waitlist_dt,
X_DCNT_REASON_CD => p_dcnt_reason_cd,
X_MODE => 'R',
X_GS_VERSION_NUMBER => c_unit_attempt_rec.gs_version_number,
X_ENR_METHOD_TYPE => c_unit_attempt_rec.enr_method_type,
X_FAILED_UNIT_RULE => c_unit_attempt_rec.failed_unit_rule,
X_CART => c_unit_attempt_rec.cart,
X_RSV_SEAT_EXT_ID => c_unit_attempt_rec.rsv_seat_ext_id,
X_ORG_UNIT_CD => c_unit_attempt_rec.org_unit_cd,
-- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
X_SESSION_ID => c_unit_attempt_rec.session_id,
-- Added the column grading schema code as a part of the bug 2037897. - aiyer
X_GRADING_SCHEMA_CODE => c_unit_attempt_rec.grading_schema_code,
--Added the column deg_aud_detail_id as part of Degree Audit Interface build. Bug# 2033208 - pradhakr
X_DEG_AUD_DETAIL_ID => c_unit_attempt_rec.deg_aud_detail_id,
X_SUBTITLE => c_unit_attempt_rec.subtitle,
--Added the columns student_career_transcript,student_career_statistics as part of Career Impact DLD
-- part 2 . Bug # svenkata
X_STUDENT_CAREER_TRANSCRIPT => c_unit_attempt_rec.student_career_transcript,
X_STUDENT_CAREER_STATISTICS => c_unit_attempt_rec.student_career_statistics,
X_ATTRIBUTE_CATEGORY => c_unit_attempt_rec.attribute_category,
X_ATTRIBUTE1 => c_unit_attempt_rec.attribute1,
X_ATTRIBUTE2 => c_unit_attempt_rec.attribute2,
X_ATTRIBUTE3 => c_unit_attempt_rec.attribute3,
X_ATTRIBUTE4 => c_unit_attempt_rec.attribute4,
X_ATTRIBUTE5 => c_unit_attempt_rec.attribute5,
X_ATTRIBUTE6 => c_unit_attempt_rec.attribute6,
X_ATTRIBUTE7 => c_unit_attempt_rec.attribute7,
X_ATTRIBUTE8 => c_unit_attempt_rec.attribute8,
X_ATTRIBUTE9 => c_unit_attempt_rec.attribute9,
X_ATTRIBUTE10 => c_unit_attempt_rec.attribute10,
X_ATTRIBUTE11 => c_unit_attempt_rec.attribute11,
X_ATTRIBUTE12 => c_unit_attempt_rec.attribute12,
X_ATTRIBUTE13 => c_unit_attempt_rec.attribute13,
X_ATTRIBUTE14 => c_unit_attempt_rec.attribute14,
X_ATTRIBUTE15 => c_unit_attempt_rec.attribute15,
X_ATTRIBUTE16 => c_unit_attempt_rec.attribute16,
X_ATTRIBUTE17 => c_unit_attempt_rec.attribute17,
X_ATTRIBUTE18 => c_unit_attempt_rec.attribute18,
X_ATTRIBUTE19 => c_unit_attempt_rec.attribute19,
X_ATTRIBUTE20 => c_unit_attempt_rec.attribute20,
X_WAITLIST_MANUAL_IND => c_unit_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109.
X_WLST_PRIORITY_WEIGHT_NUM => c_unit_attempt_rec.wlst_priority_weight_num,
X_WLST_PREFERENCE_WEIGHT_NUM=> c_unit_attempt_rec.wlst_preference_weight_num,
-- CORE_INDICATOR_CODE --added by rvangala 07-OCT-2003. Enh Bug# 3052432
X_CORE_INDICATOR_CODE => c_unit_attempt_rec.core_indicator_code
);