[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT load_cal_type, load_ci_sequence_number
FROM IGS_CA_TEACH_TO_LOAD_V
WHERE teach_cal_type = p_teach_cal_type
AND teach_ci_sequence_number = p_teach_ci_sequence_number
ORDER BY LOAD_START_DT ASC;
SELECT meaning
FROM IGS_LOOKUPS_VIEW
WHERE lookup_type = 'CRS_ATTEMPT_STATUS'
AND lookup_CODE = 'INTERMIT';
SELECT variation_cutoff_dt_alias
FROM IGS_EN_CAL_CONF
WHERE s_control_num = 1;
SELECT
MAX(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;
SELECT census_dt_alias
FROM IGS_GE_S_GEN_CAL_CON
WHERE s_control_num = 1;
SELECT DISTINCT sua.cal_type,
sua.ci_sequence_number,
ci.end_dt
FROM
IGS_EN_SU_ATTEMPT sua,
IGS_CA_INST ci
WHERE
sua.person_id = cp_person_id AND
sua.course_cd = cp_course_cd AND
sua.unit_attempt_status IN ('UNCONFIRM', 'ENROLLED') AND
ci.cal_type = sua.cal_type AND
ci.sequence_number = sua.ci_sequence_number;
SELECT unit_cd,
version_number,
cal_type,
ci_sequence_number,
ci_start_dt,
ci_end_dt,
enrolled_dt,
uoo_id,
unit_attempt_status
FROM IGS_EN_SU_ATTEMPT
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
cal_type = cp_cal_type AND
ci_sequence_number = cp_ci_sequence_number AND
unit_attempt_status = 'ENROLLED';
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 'x' FROM IGS_AS_SU_STMPTOUT ou, igs_en_su_attempt sua
where sua . person_id = p_person_id
and sua .course_cd = p_course_cd
AND sua .unit_attempt_status = 'ENROLLED'
AND sua.person_id = ou.person_id
AND sua.course_cd = ou.course_cd
AND sua.uoo_id = ou.uoo_id;
SELECT igs_en_su_attempt.*
FROM igs_en_su_attempt
WHERE person_id = p_person_id AND
course_cd = p_course_cd AND
uoo_id = v_suaci_rec.uoo_id;
igs_en_sua_api.update_unit_attempt(
X_ROWID => igs_en_su_attempt_rec.row_id,
X_PERSON_ID => igs_en_su_attempt_rec.person_id,
X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
X_UNIT_ATTEMPT_STATUS => igs_en_su_attempt_rec.unit_attempt_status,
X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_PRIORITY,
X_DISCONTINUED_DT => v_discontinuation_dt,
X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
X_MODE => 'R',
X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
X_CART => igs_en_su_attempt_rec.CART,
X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
-- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
-- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code
);
SELECT igs_en_su_attempt.*
FROM igs_en_su_attempt
WHERE person_id = p_person_id AND
course_cd = p_course_cd AND
uoo_id = v_suaci_rec.uoo_id;
igs_en_sua_api.update_unit_attempt(
X_ROWID => igs_en_su_attempt_rec.row_id,
X_PERSON_ID => igs_en_su_attempt_rec.person_id,
X_COURSE_CD => igs_en_su_attempt_rec.course_cd,
X_UNIT_CD => igs_en_su_attempt_rec.unit_cd,
X_CAL_TYPE => igs_en_su_attempt_rec.cal_type,
X_CI_SEQUENCE_NUMBER => igs_en_su_attempt_rec.ci_sequence_number,
X_VERSION_NUMBER => igs_en_su_attempt_rec.version_number,
X_LOCATION_CD => igs_en_su_attempt_rec.location_cd,
X_UNIT_CLASS => igs_en_su_attempt_rec.unit_class,
X_CI_START_DT => igs_en_su_attempt_rec.ci_start_dt,
X_CI_END_DT => igs_en_su_attempt_rec.ci_end_dt,
X_UOO_ID => igs_en_su_attempt_rec.uoo_id,
X_ENROLLED_DT => igs_en_su_attempt_rec.enrolled_dt,
X_UNIT_ATTEMPT_STATUS => 'DROPPED',
X_ADMINISTRATIVE_UNIT_STATUS => igs_en_su_attempt_rec.administrative_unit_status,
X_ADMINISTRATIVE_PRIORITY => igs_en_su_attempt_rec.administrative_priority,
X_DISCONTINUED_DT => nvl(igs_en_su_attempt_rec.discontinued_dt,trunc(sysdate)),
X_DCNT_REASON_CD => igs_en_su_attempt_rec.dcnt_reason_cd,
X_RULE_WAIVED_DT => igs_en_su_attempt_rec.rule_waived_dt,
X_RULE_WAIVED_PERSON_ID => igs_en_su_attempt_rec.rule_waived_person_id,
X_NO_ASSESSMENT_IND => igs_en_su_attempt_rec.no_assessment_ind,
X_SUP_UNIT_CD => igs_en_su_attempt_rec.sup_unit_cd,
X_SUP_VERSION_NUMBER => igs_en_su_attempt_rec.SUP_VERSION_NUMBER,
X_EXAM_LOCATION_CD => igs_en_su_attempt_rec.exam_location_cd,
X_ALTERNATIVE_TITLE => igs_en_su_attempt_rec.alternative_title,
X_OVERRIDE_ENROLLED_CP => igs_en_su_attempt_rec.OVERRIDE_ENROLLED_CP,
X_OVERRIDE_EFTSU => igs_en_su_attempt_rec.OVERRIDE_EFTSU,
X_OVERRIDE_ACHIEVABLE_CP => igs_en_su_attempt_rec.OVERRIDE_ACHIEVABLE_CP,
X_OVERRIDE_OUTCOME_DUE_DT => igs_en_su_attempt_rec.OVERRIDE_OUTCOME_DUE_DT,
X_OVERRIDE_CREDIT_REASON => igs_en_su_attempt_rec.OVERRIDE_CREDIT_REASON,
X_WAITLIST_DT => igs_en_su_attempt_rec.WAITLIST_DT,
X_MODE => 'R',
X_GS_VERSION_NUMBER => igs_en_su_attempt_rec.GS_VERSION_NUMBER,
X_ENR_METHOD_TYPE => igs_en_su_attempt_rec.ENR_METHOD_TYPE,
X_FAILED_UNIT_RULE => igs_en_su_attempt_rec.FAILED_UNIT_RULE,
X_CART => igs_en_su_attempt_rec.CART,
X_RSV_SEAT_EXT_ID => igs_en_su_attempt_rec.RSV_SEAT_EXT_ID,
X_ORG_UNIT_CD => igs_en_su_attempt_rec.ORG_UNIT_CD,
-- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
X_SESSION_ID => igs_en_su_attempt_rec.SESSION_ID,
X_GRADING_SCHEMA_CODE => igs_en_su_attempt_rec.GRADING_SCHEMA_CODE,
X_DEG_AUD_DETAIL_ID => igs_en_su_attempt_rec.DEG_AUD_DETAIL_ID,
X_SUBTITLE => igs_en_su_attempt_rec.subtitle,
X_STUDENT_CAREER_TRANSCRIPT => igs_en_su_attempt_rec.student_career_transcript,
X_STUDENT_CAREER_STATISTICS => igs_en_su_attempt_rec.student_career_statistics,
X_ATTRIBUTE_CATEGORY => igs_en_su_attempt_rec.attribute_category,
X_ATTRIBUTE1 => igs_en_su_attempt_rec.attribute1,
X_ATTRIBUTE2 => igs_en_su_attempt_rec.attribute2,
X_ATTRIBUTE3 => igs_en_su_attempt_rec.attribute3,
X_ATTRIBUTE4 => igs_en_su_attempt_rec.attribute4,
X_ATTRIBUTE5 => igs_en_su_attempt_rec.attribute5,
X_ATTRIBUTE6 => igs_en_su_attempt_rec.attribute6,
X_ATTRIBUTE7 => igs_en_su_attempt_rec.attribute7,
X_ATTRIBUTE8 => igs_en_su_attempt_rec.attribute8,
X_ATTRIBUTE9 => igs_en_su_attempt_rec.attribute9,
X_ATTRIBUTE10 => igs_en_su_attempt_rec.attribute10,
X_ATTRIBUTE11 => igs_en_su_attempt_rec.attribute11,
X_ATTRIBUTE12 => igs_en_su_attempt_rec.attribute12,
X_ATTRIBUTE13 => igs_en_su_attempt_rec.attribute13,
X_ATTRIBUTE14 => igs_en_su_attempt_rec.attribute14,
X_ATTRIBUTE15 => igs_en_su_attempt_rec.attribute15,
X_ATTRIBUTE16 => igs_en_su_attempt_rec.attribute16,
X_ATTRIBUTE17 => igs_en_su_attempt_rec.attribute17,
X_ATTRIBUTE18 => igs_en_su_attempt_rec.attribute18,
X_ATTRIBUTE19 => igs_en_su_attempt_rec.attribute19,
X_ATTRIBUTE20 => igs_en_su_attempt_rec.attribute20,
X_WAITLIST_MANUAL_IND => igs_en_su_attempt_rec.waitlist_manual_ind, --Added by mesriniv for Bug 2554109 Mini Waitlist Build.
X_WLST_PRIORITY_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_priority_weight_num,
X_WLST_PREFERENCE_WEIGHT_NUM => igs_en_su_attempt_rec.wlst_preference_weight_num,
-- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
X_CORE_INDICATOR_CODE => igs_en_su_attempt_rec.core_indicator_code);
Fnd_Message.Set_name('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_name('FND','FORM_RECORD_DELETED');
v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
SELECT susa.ROWID,
susa.unit_set_cd,
susa.us_version_number,
susa.sequence_number,
susa.authorised_person_id,
susa.authorised_on,
susa.selection_dt,
susa.end_dt,
susa.rqrmnts_complete_dt,
susa.parent_unit_set_cd,
susa.parent_sequence_number,
susa.student_confirmed_ind,
susa.primary_set_ind,
susa.voluntary_end_ind,
susa.override_title,
susa.rqrmnts_complete_ind,
susa.s_completed_source_type,
susa.catalog_cal_type,
susa.catalog_seq_num,
susa.attribute_category, --kkillams columns attribute_category to attribute20 added to cursor w.r.t to YOP-EN bug id :2156956
susa.attribute1,
susa.attribute2,
susa.attribute3,
susa.attribute4,
susa.attribute5,
susa.attribute6,
susa.attribute7,
susa.attribute8,
susa.attribute9,
susa.attribute10,
susa.attribute11,
susa.attribute12,
susa.attribute13,
susa.attribute14,
susa.attribute15,
susa.attribute16,
susa.attribute17,
susa.attribute18,
susa.attribute19,
susa.attribute20
FROM IGS_AS_SU_SETATMPT susa
START WITH susa.person_id = p_person_id AND
susa.course_cd = p_course_cd AND
susa.parent_unit_set_cd = p_unit_set_cd AND
susa.parent_sequence_number = p_sequence_number
CONNECT BY
PRIOR susa.person_id = susa.person_id AND
PRIOR susa.course_cd = susa.course_cd AND
PRIOR susa.unit_set_cd = susa.parent_unit_set_cd AND
PRIOR susa.sequence_number = susa.parent_sequence_number
FOR UPDATE OF end_dt,
voluntary_end_ind,
authorised_person_id,
authorised_on NOWAIT;
v_selection_dt,
v_end_dt,
v_rqrmnts_complete_dt,
v_parent_unit_set_cd,
v_parent_sequence_number,
v_student_confirmed_ind,
v_primary_set_ind,
v_voluntary_end_ind,
v_override_title,
v_rqrmnts_complete_ind,
v_s_completed_source_type,
v_catalog_cal_type,
v_catalog_seq_num,
v_attribute_category, --kkillams variables attribute_category to attribute20 are added w.r.t to YOP-EN bug id :2156956
v_attribute1,
v_attribute2,
v_attribute3,
v_attribute4,
v_attribute5,
v_attribute6,
v_attribute7,
v_attribute8,
v_attribute9,
v_attribute10,
v_attribute11,
v_attribute12,
v_attribute13,
v_attribute14,
v_attribute15,
v_attribute16,
v_attribute17,
v_attribute18,
v_attribute19,
v_attribute20;
v_selection_dt,
v_student_confirmed_ind,
p_end_dt,
v_parent_unit_set_cd,
v_parent_sequence_number,
v_primary_set_ind,
p_voluntary_end_ind,
v_authorised_person_id,
v_authorised_on,
v_override_title,
v_rqrmnts_complete_ind,
v_rqrmnts_complete_dt,
v_s_completed_source_type,
'UPDATE',
v_message_name,
v_message_text) = FALSE THEN
-- IGS_GE_NOTE: The IGS_RU_RULE check will only be called when confirming the IGS_PS_UNIT set.
-- Hence no need to check and handle if v_message_text returned.
CLOSE c_susa;
IGS_GE_S_DSB_TAB_TRG_PKG.INSERT_ROW(
X_ROWID => L_ROWID ,
X_TABLE_NAME =>'IGS_AS_SU_SETATMPT',
X_SESSION_ID => userenv('SESSIONID'),
x_mode => 'R'
);
IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(
X_ROWID => V_ROWID,
X_PERSON_ID => P_PERSON_ID,
X_COURSE_CD => P_COURSE_CD,
X_UNIT_SET_CD => V_UNIT_SET_CD,
X_SEQUENCE_NUMBER => V_SEQUENCE_NUMBER,
X_US_VERSION_NUMBER => V_US_VERSION_NUMBER,
X_SELECTION_DT => V_SELECTION_DT,
X_STUDENT_CONFIRMED_IND => V_STUDENT_CONFIRMED_IND,
X_END_DT => P_END_DT,
X_PARENT_UNIT_SET_CD => V_PARENT_UNIT_SET_CD,
X_PARENT_SEQUENCE_NUMBER => V_PARENT_SEQUENCE_NUMBER,
X_PRIMARY_SET_IND => V_PRIMARY_SET_IND,
X_VOLUNTARY_END_IND => P_VOLUNTARY_END_IND,
X_AUTHORISED_PERSON_ID => V_AUTHORISED_PERSON_ID,
X_AUTHORISED_ON => V_AUTHORISED_ON,
X_OVERRIDE_TITLE => V_OVERRIDE_TITLE,
X_RQRMNTS_COMPLETE_IND => V_RQRMNTS_COMPLETE_IND,
X_RQRMNTS_COMPLETE_DT => V_RQRMNTS_COMPLETE_DT,
X_S_COMPLETED_SOURCE_TYPE => V_S_COMPLETED_SOURCE_TYPE,
X_CATALOG_CAL_TYPE => V_CATALOG_CAL_TYPE,
X_CATALOG_SEQ_NUM => V_CATALOG_SEQ_NUM,
X_ATTRIBUTE_CATEGORY => V_ATTRIBUTE_CATEGORY, --kkillams attribute_category to attribute20 parameters are added to
X_ATTRIBUTE1 => V_ATTRIBUTE1, --IGS_AS_SU_SETATMPT_PKG.update_row call w.r.t to YOP-EN bug id :2156956
X_ATTRIBUTE2 => V_ATTRIBUTE2,
X_ATTRIBUTE3 => V_ATTRIBUTE3,
X_ATTRIBUTE4 => V_ATTRIBUTE4,
X_ATTRIBUTE5 => V_ATTRIBUTE5,
X_ATTRIBUTE6 => V_ATTRIBUTE6,
X_ATTRIBUTE7 => V_ATTRIBUTE7,
X_ATTRIBUTE8 => V_ATTRIBUTE8,
X_ATTRIBUTE9 => V_ATTRIBUTE9,
X_ATTRIBUTE10 => V_ATTRIBUTE10,
X_ATTRIBUTE11 => V_ATTRIBUTE11,
X_ATTRIBUTE12 => V_ATTRIBUTE12,
X_ATTRIBUTE13 => V_ATTRIBUTE13,
X_ATTRIBUTE14 => V_ATTRIBUTE14,
X_ATTRIBUTE15 => V_ATTRIBUTE15,
X_ATTRIBUTE16 => V_ATTRIBUTE16,
X_ATTRIBUTE17 => V_ATTRIBUTE17,
X_ATTRIBUTE18 => V_ATTRIBUTE18,
X_ATTRIBUTE19 => V_ATTRIBUTE19,
X_ATTRIBUTE20 => V_ATTRIBUTE20,
X_MODE => 'R');
v_selection_dt,
v_end_dt,
v_rqrmnts_complete_dt,
v_parent_unit_set_cd,
v_parent_sequence_number,
v_student_confirmed_ind,
v_primary_set_ind,
v_voluntary_end_ind,
v_override_title,
v_rqrmnts_complete_ind,
v_s_completed_source_type,
v_catalog_cal_type,
v_catalog_seq_num,
v_attribute_category, --kkillams variables attribute_category to attribute20 are added w.r.t to YOP-EN bug id :2156956
v_attribute1,
v_attribute2,
v_attribute3,
v_attribute4,
v_attribute5,
v_attribute6,
v_attribute7,
v_attribute8,
v_attribute9,
v_attribute10,
v_attribute11,
v_attribute12,
v_attribute13,
v_attribute14,
v_attribute15,
v_attribute16,
v_attribute17,
v_attribute18,
v_attribute19,
v_attribute20;
SELECT susa.ROWID,
susa.unit_set_cd,
susa.us_version_number,
susa.sequence_number,
susa.authorised_person_id,
susa.authorised_on,
susa.selection_dt,
susa.end_dt,
susa.rqrmnts_complete_dt,
susa.parent_unit_set_cd,
susa.parent_sequence_number,
susa.student_confirmed_ind,
susa.primary_set_ind,
susa.voluntary_end_ind,
susa.override_title,
susa.rqrmnts_complete_ind,
susa.s_completed_source_type,
susa.catalog_cal_type,
susa.catalog_seq_num,
susa.attribute_category, --kkillams columns attribute_category to attribute20 added to cursor w.r.t to YOP-EN bug id :2156956
susa.attribute1,
susa.attribute2,
susa.attribute3,
susa.attribute4,
susa.attribute5,
susa.attribute6,
susa.attribute7,
susa.attribute8,
susa.attribute9,
susa.attribute10,
susa.attribute11,
susa.attribute12,
susa.attribute13,
susa.attribute14,
susa.attribute15,
susa.attribute16,
susa.attribute17,
susa.attribute18,
susa.attribute19,
susa.attribute20
FROM IGS_AS_SU_SETATMPT susa
START WITH susa.person_id = p_person_id AND
susa.course_cd = p_course_cd AND
susa.parent_unit_set_cd = p_unit_set_cd AND
susa.parent_sequence_number = p_sequence_number
CONNECT BY
PRIOR susa.person_id = susa.person_id AND
PRIOR susa.course_cd = susa.course_cd AND
PRIOR susa.unit_set_cd = susa.parent_unit_set_cd AND
PRIOR susa.sequence_number = susa.parent_sequence_number
FOR UPDATE OF student_confirmed_ind,
selection_dt NOWAIT;
NULL, -- selection_dt
'N', -- student_confirmed_ind
v_susa_rec.end_dt,
v_susa_rec.parent_unit_set_cd,
v_susa_rec.parent_sequence_number,
v_susa_rec.primary_set_ind,
v_susa_rec.voluntary_end_ind,
v_susa_rec.authorised_person_id,
v_susa_rec.authorised_on,
v_susa_rec.override_title,
v_susa_rec.rqrmnts_complete_ind,
v_susa_rec.rqrmnts_complete_dt,
v_susa_rec.s_completed_source_type,
'UPDATE',
v_message_name,
v_message_text) = FALSE THEN
-- IGS_GE_NOTE: The IGS_RU_RULE check will only be called when confirming the IGS_PS_UNIT set.
-- Hence no need to check and handle if v_message_text returned.
p_message_name := v_message_name;
IGS_GE_S_DSB_TAB_TRG_PKG.INSERT_ROW(
X_ROWID => L_ROWID ,
X_TABLE_NAME =>'IGS_AS_SU_SETATMPT',
X_SESSION_ID => userenv('SESSIONID'),
x_mode => 'R'
);
IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(X_ROWID => v_susa_rec.rowid,
X_PERSON_ID => P_PERSON_ID,
X_COURSE_CD => P_COURSE_CD,
X_UNIT_SET_CD => v_susa_rec.unit_set_cd,
X_SEQUENCE_NUMBER => v_susa_rec.sequence_number,
X_US_VERSION_NUMBER => v_susa_rec.us_version_number,
X_SELECTION_DT => NULL,
X_STUDENT_CONFIRMED_IND => 'N',
X_END_DT => v_susa_rec.end_dt,
X_PARENT_UNIT_SET_CD => v_susa_rec.parent_unit_set_cd,
X_PARENT_SEQUENCE_NUMBER => v_susa_rec.parent_sequence_number,
X_PRIMARY_SET_IND => v_susa_rec.primary_set_ind,
X_VOLUNTARY_END_IND => v_susa_rec.voluntary_end_ind,
X_AUTHORISED_PERSON_ID => v_susa_rec.authorised_person_id,
X_AUTHORISED_ON => v_susa_rec.authorised_on,
X_OVERRIDE_TITLE => v_susa_rec.override_title,
X_RQRMNTS_COMPLETE_IND => v_susa_rec.rqrmnts_complete_ind,
X_RQRMNTS_COMPLETE_DT => v_susa_rec.rqrmnts_complete_dt,
X_S_COMPLETED_SOURCE_TYPE => v_susa_rec.s_completed_source_type,
X_CATALOG_CAL_TYPE => v_susa_rec.catalog_cal_type,
X_CATALOG_SEQ_NUM => v_susa_rec.catalog_seq_num,
X_ATTRIBUTE_CATEGORY => v_susa_rec.attribute_category, --kkillams attribute_category to attribute20 parameters are added to
X_ATTRIBUTE1 => v_susa_rec.attribute1, --IGS_AS_SU_SETATMPT_PKG.update_row call w.r.t to YOP-EN bug id :2156956
X_ATTRIBUTE2 => v_susa_rec.attribute2,
X_ATTRIBUTE3 => v_susa_rec.attribute3,
X_ATTRIBUTE4 => v_susa_rec.attribute4,
X_ATTRIBUTE5 => v_susa_rec.attribute5,
X_ATTRIBUTE6 => v_susa_rec.attribute6,
X_ATTRIBUTE7 => v_susa_rec.attribute7,
X_ATTRIBUTE8 => v_susa_rec.attribute8,
X_ATTRIBUTE9 => v_susa_rec.attribute9,
X_ATTRIBUTE10 => v_susa_rec.attribute10,
X_ATTRIBUTE11 => v_susa_rec.attribute11,
X_ATTRIBUTE12 => v_susa_rec.attribute12,
X_ATTRIBUTE13 => v_susa_rec.attribute13,
X_ATTRIBUTE14 => v_susa_rec.attribute14,
X_ATTRIBUTE15 => v_susa_rec.attribute15,
X_ATTRIBUTE16 => v_susa_rec.attribute16,
X_ATTRIBUTE17 => v_susa_rec.attribute17,
X_ATTRIBUTE18 => v_susa_rec.attribute18,
X_ATTRIBUTE19 => v_susa_rec.attribute19,
X_ATTRIBUTE20 => v_susa_rec.attribute20,
X_MODE => 'R'
);