The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ca.sequence_number,
ca.min_submission_dt
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND (
(p_parent = cst_SCA AND
ca.sca_course_cd = p_course_cd) OR
(p_parent = cst_ACAI and
ca.acai_admission_appl_number = p_acai_admission_appl_number AND
ca.acai_nominated_course_cd = p_acai_nominated_course_cd AND
ca.acai_sequence_number = p_acai_sequence_number));
SELECT cty.research_type_ind
FROM IGS_PS_VER crv,
IGS_PS_TYPE cty
WHERE crv.course_cd = p_course_cd AND
crv.version_number = p_crv_version_number AND
crv.course_type = cty.course_type;
SELECT 'x'
FROM IGS_AD_APPL aa,
IGS_AD_PRCS_CAT_STEP apcs
WHERE aa.person_id = p_person_id AND
aa.admission_appl_number = p_acai_admission_appl_number AND
aa.admission_cat = apcs.admission_cat AND
aa.s_admission_process_type = apcs.s_admission_process_type AND
apcs.s_admission_step_type = cst_research AND
apcs.mandatory_step_ind = 'Y' AND
apcs.step_group_type <> 'TRACK'; --2402377
SELECT acaiv.adm_cal_type,
acaiv.adm_ci_sequence_number
FROM IGS_AD_PS_APPL_INST_APLINST_V acaiv
WHERE acaiv.person_id = p_person_id AND
acaiv.admission_appl_number = p_acai_admission_appl_number AND
acaiv.nominated_course_cd = p_acai_nominated_course_cd AND
acaiv.sequence_number = p_acai_sequence_number;
SELECT daiv.alias_val,
daiv.cal_type,
daiv.ci_sequence_number
FROM IGS_CA_INST_REL cir,
IGS_CA_TYPE cat,
IGS_CA_DA_INST_V daiv,
IGS_RE_S_RES_CAL_CON srcc
WHERE cir.sub_cal_type = v_adm_cal_type AND
cir.sub_ci_sequence_number = v_adm_ci_sequence_number AND
cir.sup_cal_type = cat.cal_type AND
cat.s_cal_cat = cst_teaching AND
cir.sup_cal_type = daiv.cal_type AND
cir.sup_ci_sequence_number = daiv.ci_sequence_number AND
daiv.dt_alias = srcc.effective_strt_dt_alias AND
srcc.s_control_num = 1
ORDER BY daiv.alias_val ASC;
SELECT 'x'
FROM IGS_CA_INST_REL cir,
IGS_CA_TYPE cat,
IGS_CA_DA_INST_V daiv,
IGS_GE_S_GEN_CAL_CON sgcc
WHERE cir.sub_cal_type = v_adm_cal_type AND
cir.sub_ci_sequence_number = v_adm_ci_sequence_number AND
cir.sup_cal_type = cat.cal_type AND
cat.s_cal_cat = cst_teaching AND
cir.sup_cal_type = daiv.cal_type AND
cir.sup_ci_sequence_number = daiv.ci_sequence_number AND
daiv.dt_alias = sgcc.census_dt_alias AND
sgcc.s_control_num = 1 AND
daiv.alias_val < v_course_start_dt AND
daiv.alias_val > p_prpsd_commencement_dt;
SELECT sca.attendance_type,
sca.student_confirmed_ind
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_course_cd;
SELECT ca.attendance_percentage
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
ca.sca_course_cd = p_course_cd;
SELECT cir.sup_cal_type,
cir.sup_ci_sequence_number,
sua.cal_type
FROM IGS_EN_SU_ATTEMPT sua,
IGS_CA_INST_REL cir,
IGS_CA_INST ci,
IGS_CA_TYPE cat,
IGS_PS_UNIT_VER uv
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_cd = uv.unit_cd AND
sua.version_number = uv.version_number AND
uv.research_unit_ind = 'Y' AND
sua.cal_type = ci.cal_type AND
sua.ci_sequence_number = ci.sequence_number AND
ci.start_dt <= TRUNC(SYSDATE) AND
ci.end_dt > TRUNC(SYSDATE) AND
sua.cal_type = cir.sub_cal_type AND
sua.ci_sequence_number = cir.sub_ci_sequence_number AND
cir.sup_cal_type = cat.cal_type AND
cat.s_cal_cat = cst_academic;
SELECT dla.cal_type,
dla.ci_sequence_number
FROM IGS_CA_INST_REL cir,
IGS_ST_DFT_LOAD_APPO dla
WHERE cir.sup_cal_type = cp_acad_cal_type AND
cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
cir.sub_cal_type = dla.cal_type AND
cir.sub_ci_sequence_number = dla.ci_sequence_number AND
dla.teach_cal_type = cp_teach_cal_type AND
dla.percentage = 100;
SELECT atl.lower_enr_load_range,
atl.upper_enr_load_range
FROM IGS_EN_ATD_TYPE_LOAD atl
WHERE atl.cal_type = cp_load_cal_type AND
atl.attendance_type = cp_attendance_type;
SELECT cty.research_type_ind
FROM IGS_PS_VER crv,
IGS_PS_TYPE cty
WHERE crv.course_cd = p_course_cd AND
crv.version_number = p_crv_version_number AND
crv.course_type = cty.course_type;
SELECT ca.sequence_number,
ca.attendance_percentage,
ca.max_submission_dt,
ca.min_submission_dt,
ca.research_topic
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_person_id AND
((ca.acai_admission_appl_number = p_acai_admission_appl_number AND
ca.acai_nominated_course_cd =p_acai_nominated_course_cd AND
ca.acai_sequence_number = p_acai_sequence_number) OR
(p_parent <> cst_acai AND
ca.sca_course_cd = p_sca_course_cd)) AND
ca.research_topic IS NOT NULL;
SELECT sua.unit_cd,
sua.version_number,
sua.cal_type,
sua.ci_sequence_number,
sua.rule_waived_dt,
sua.uoo_id
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status = cst_enrolled;
SELECT sua.cal_type,
sua.ci_sequence_number,
sua.unit_attempt_status
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status IN (
cst_invalid,
cst_enrolled,
cst_unconfirm);
SELECT s_admission_process_type
FROM IGS_AD_APPL
WHERE person_id = p_person_id AND
admission_appl_number = p_admission_appl_number;
SELECT 'x'
FROM IGS_AD_PS_APPL aca,
IGS_PS_STDNT_TRN sct
WHERE aca.person_id = p_person_id AND
aca.admission_appl_number = p_admission_appl_number AND
aca.nominated_course_cd = p_nominated_course_cd AND
sct.person_id = aca.person_id AND
sct.course_cd = p_course_cd AND
sct.transfer_course_cd = aca.transfer_course_cd;
SELECT course_attempt_status,
version_number
FROM
IGS_EN_STDNT_PS_ATT
WHERE
person_id = cp_person_id AND
course_cd = cp_course_cd;
ELSIF (v_sca_rec.course_attempt_status = 'DELETED') THEN
p_message_name := 'IGS_EN_CHG_OPT_NOTALLOW_DEL';
SELECT sua.location_cd,
sua.unit_class
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = cp_person_id AND
sua.course_cd = cp_course_cd AND
sua.unit_attempt_status = 'ENROLLED' AND
IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
cp_cal_type,
cp_ci_sequence_number,
sua.cal_type,
sua.ci_sequence_number,
'N') = 'Y';
SELECT 'x'
FROM IGS_EN_SU_ATTEMPT
WHERE person_id = p_person_id AND
course_cd = p_course_cd AND
unit_attempt_status <> cst_unconfirm;
Purpose : This procedure updates Enrolled_Cp and achieveable_Cp in SUA record
when Approved Credit Points is created.
Known limitations,
enhancements,
remarks :
Change History
Who When What
ckasu 24-APR-2006 Modified as a part of bug#5191592 inorder to consider passed in Term Calendar
alone during efstu caluculation when Term calendar or Teach calendar is passed
else earlier logic of getting all the load calendar associated to the academic
calendar is remained intact.
*********************************************************************/
BEGIN
DECLARE
cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
SELECT COO.course_cd,
COO.attendance_type,
COO.forced_att_type_ind
FROM IGS_PS_OFR_OPT COO
WHERE COO.coo_id = cp_coo_id
AND COO.delete_flag = 'N';
SELECT ATT.lower_enr_load_range,
ATT.upper_enr_load_range
FROM IGS_EN_ATD_TYPE ATT
WHERE ATT.attendance_type = cp_attendance_type;
SELECT CI.cal_type,
CI.sequence_number,
CI.start_dt
FROM IGS_CA_INST_REL CIR,
IGS_CA_INST CI,
IGS_CA_TYPE CT,
IGS_CA_STAT CS
WHERE CT.closed_ind = 'N' AND
CT.s_cal_cat = cst_load AND
CS.s_cal_status = cst_active AND
CI.cal_status = CS.cal_status AND
CI.cal_type = CT.cal_type AND
CIR.sup_cal_type = cp_cal_type AND
CIR.sup_ci_sequence_number = cp_sequence_number AND
CIR.sub_cal_type = CI.cal_type AND
CIR.sub_ci_sequence_number = CI.sequence_number
ORDER BY CI.start_dt;
SELECT ct.s_cal_cat
FROM igs_ca_inst ci,
igs_ca_type ct
WHERE ci.cal_type = ct.cal_type
AND ct.closed_ind = 'N'
AND ci.cal_type = cp_cal_type
AND ci.sequence_number = cp_seq_number;
SELECT load_cal_type,load_ci_sequence_number
FROM igs_ca_teach_to_load_v
WHERE teach_cal_type = cp_cal_type
AND teach_ci_sequence_number = cp_seq_number
ORDER BY load_start_dt;
SELECT dr.closed_ind,
dr.s_discontinuation_reason_type
FROM IGS_EN_DCNT_REASONCD dr
WHERE dr.discontinuation_reason_cd = p_discontinuation_reason_cd;
SELECT 'X'
FROM IGS_PS_STDNT_TRN sct
WHERE sct.person_id = p_person_id AND
sct.transfer_course_cd = p_course_cd AND
(sct.status_date >= p_discontinued_dt OR
sct.status_flag = 'U');
SELECT funding_source,
restricted_ind
FROM IGS_FI_FND_SRC_RSTN
WHERE course_cd = cp_course_cd AND
version_number = cp_version_number AND
restricted_ind = 'Y';
|| DISCONTIN prior to update.
|| * If the discontinued date is set then it must be less than or equal to
|| the transfer date if the cours attempt has been transferred
|| * If the discontinued date is set and <= today?s date then there
|| should be no student unit attempts enrolled.
|| * If the discontinued date is set, then it must be greater than the
|| outcome date of any completed student unit attempts.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| kkillams 11-11-2002 Modified function logic due to addition of new parameter p_legacy
|| if p_legacy set to 'Y' then error message should be stacked instead of
|| returning the function in the normal way else function should behave in
|| normal way.Legacy Build Bug no: 2661533
|| kkillams 29-04-2003 Modified the c_sua_comp cursor where clause due to change in the pk of
|| student unit attempt w.r.t. bug number 2829262
|| bdeviset 22-Dec-2004 Modifed cursor c_sct in enrp_val_sca_discont as part Bug#4083015.
------------------------------------------------------------------------------*/
BEGIN
DECLARE
cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE :='ACTIVE';
SELECT 'x'
FROM IGS_PS_VER cv,
IGS_PS_STAT cs
WHERE cv.course_cd = p_course_cd AND
cv.version_number = p_version_number AND
cs.course_status = cv.course_status AND
cs.s_course_status <> cst_active;
SELECT 'x'
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status = cst_enrolled;
SELECT 'x'
FROM IGS_AS_SU_STMPTOUT suao,
IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status = cst_completed AND
suao.person_id = sua.person_id AND
suao.course_cd = sua.course_cd AND
suao.uoo_id = sua.uoo_id AND
TRUNC(suao.outcome_dt) > TRUNC(p_discontinued_dt) AND
suao.finalised_outcome_ind = 'Y';
SELECT sct.transfer_course_cd,
sct.status_date
FROM IGS_PS_STDNT_TRN sct
WHERE sct.person_id = p_person_id AND
(sct.course_cd = p_course_cd OR
sct.transfer_course_cd = p_course_cd) AND
sct.status_flag = 'T'
ORDER BY sct.status_date desc;
SELECT sca.commencement_dt
FROM IGS_PS_STDNT_TRN sct,
IGS_EN_STDNT_PS_ATT sca,
IGS_PS_VER crv
WHERE sct.person_id = p_person_id AND
sca.person_id = sct.person_id AND
sct.course_cd = p_course_cd AND
sca.course_cd = sct.transfer_course_cd AND
crv.course_cd = sca.course_cd AND
crv.version_number = sca.version_number AND
crv.generic_course_ind = 'Y'
ORDER BY sca.commencement_dt ASC;
SELECT sca.version_number,
sca.person_id,
sca.adm_admission_appl_number,
sca.adm_nominated_course_cd,
sca.adm_sequence_number
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_course_cd;
SELECT acaiv.admission_appl_number,
acaiv.nominated_course_cd,
acaiv.sequence_number,
acaiv.adm_cal_type,
acaiv.adm_ci_sequence_number
FROM IGS_AD_PS_APPL_INST_APLINST_V acaiv
WHERE acaiv.person_id = cp_person_id AND
acaiv.admission_appl_number = cp_adm_adm_appl_num AND
acaiv.nominated_course_cd = cp_adm_nom_course_cd AND
acaiv.sequence_number = cp_adm_sequence_number;
SELECT birth_date date_of_birth
FROM igs_pe_person_base_v
WHERE person_id = p_person_id;
SELECT daiv.alias_val
FROM IGS_CA_DA_INST_V daiv,
IGS_EN_CAL_CONF secc
WHERE daiv.cal_type = p_acad_cal_type AND
daiv.ci_sequence_number = p_acad_ci_sequence_number AND
secc.commencement_dt_alias = daiv.dt_alias AND
secc.s_control_num = 1;
SELECT aa.s_admission_process_type
FROM IGS_AD_APPL aa
WHERE aa.person_id = cp_person_id AND
aa.admission_appl_number = cp_adm_admission_appl_number;
SELECT 'x'
FROM IGS_EN_SU_ATTEMPT sua,
IGS_CA_INST ci
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status IN(
cst_enrolled,
cst_discontin,
cst_invalid,
cst_completed) AND
sua.cal_type = ci.cal_type AND
sua.ci_sequence_number = ci.sequence_number AND
sua.ci_end_dt < p_commencement_dt;
SELECT sca.commencement_dt
FROM IGS_PS_STDNT_TRN sct,
IGS_RE_CANDIDATURE ca,
IGS_EN_STDNT_PS_ATT sca
WHERE sct.person_id = p_person_id AND
sct.course_cd = p_course_cd AND
sct.person_id = ca.person_id AND
sct.transfer_course_cd = ca.sca_course_cd AND
ca.person_id = sca.person_id AND
ca.sca_course_cd = sca.course_cd
ORDER BY sct.status_date desc; -- (use latest record)
SELECT closed_ind
FROM IGS_FI_FUND_SRC
WHERE funding_source = p_funding_source;
SELECT 'Y'
FROM IGS_FI_FND_SRC_RSTN
WHERE course_cd = p_course_cd AND
version_number = p_version_number AND
funding_source = p_funding_source AND
restricted_ind = 'Y';
SELECT 'Y'
FROM IGS_FI_FND_SRC_RSTN
WHERE course_cd = p_course_cd AND
version_number = p_version_number AND
restricted_ind = 'Y';
SELECT *
FROM IGS_PS_OFR_PAT
WHERE course_cd = p_course_cd AND
version_number = p_version_number AND
location_cd = p_location_cd AND
attendance_mode = p_attendance_mode AND
attendance_type = p_attendance_type AND
cal_type = p_cal_type AND
ci_sequence_number = p_ci_sequence_number;
SELECT *
FROM IGS_CA_INST
WHERE cal_type = p_cal_type AND
sequence_number = p_ci_sequence_number;
SELECT s_cal_status
FROM IGS_CA_STAT,
IGS_CA_INST
WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;
SELECT fc.closed_ind
FROM IGS_FI_FEE_CAT fc
WHERE fc.fee_cat = p_fee_cat;
SELECT tlv.LOAD_END_DT
From igs_ca_teach_to_load_V tlv,
igs_en_su_attempt sua
Where sua.person_id = cp_person_id
AND sua.course_cd = cp_course_cd
AND sua.unit_attempt_status NOT IN ('DROPPED','UNCONFIRM')
AND teach_cal_type = sua.cal_type
And teach_ci_sequence_number = sua.ci_sequence_number
Order by LOAD_START_DT asc;
SELECT uoo_id
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id
AND sua.course_cd = p_course_cd
AND sua.unit_attempt_status = 'UNCONFIRM' ;
Select spa.rowid,spa.*
from igs_en_stdnt_ps_att_all spa
where spa.rowid = cp_rowid;
Select 'x'
from IGS_EN_SU_ATTEMPT_ALL sua
where sua.person_id=cp_person_id
and sua.course_cd=cp_course_cd
and sua.unit_attempt_status <> 'UNCONFIRM';
Select susa.rowid,susa.*
from igs_as_su_setatmpt susa
where susa.person_id=cp_person_id
and susa.course_cd=cp_course_cd;
Select 'x'
from IGS_EN_SU_ATTEMPT_ALL sua
where sua.person_id=cp_person_id
and sua.course_cd=cp_course_cd
and sua.unit_attempt_status = 'UNCONFIRM';
Select ps.course_type
from igs_ps_ver ps,
igs_en_stdnt_ps_att sca
where ps.course_cd=cp_course_cd
and ps.version_number = cp_version_number
and sca.course_cd = ps.course_cd
and sca.version_number = ps.version_number
and sca.person_id = cp_person_id;
SELECT spa.course_cd
FROM igs_en_stdnt_ps_att spa,
igs_ps_ver pv
WHERE spa.person_id = cp_person_id
AND spa.primary_program_type = 'SECONDARY'
AND spa.STUDENT_CONFIRMED_IND = 'Y'
AND spa.course_cd = pv.course_cd
AND spa.version_number = pv.version_number
AND pv.course_type = cp_course_type;
SELECT effective_term_cal_type,effective_term_sequence_num
FROM IGS_PS_STDNT_TRN trnsf
WHERE trnsf.person_id = cp_person_id
AND trnsf.course_cd = cp_course_cd
AND trnsf.STATUS_FLAG = 'U' ;
SELECT 'x'
FROM igs_en_stdnt_ps_att spa,
igs_ps_ver pv
WHERE spa.person_id = cp_person_id
AND spa.primary_program_type = 'PRIMARY'
AND spa.course_cd = pv.course_cd
AND spa.version_number = pv.version_number
AND pv.course_type <> cp_course_type;
SELECT 'x'
FROM igs_en_stdnt_ps_att spa
WHERE spa.person_id = cp_person_id
AND spa.course_cd <> cp_course_cd
AND spa.student_confirmed_ind = 'Y' ;
IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(
X_ROWID => vcur_susa.rowid,
X_PERSON_ID => vcur_susa.person_id ,
X_COURSE_CD => vcur_susa.course_cd ,
X_UNIT_SET_CD => vcur_susa.unit_set_cd ,
X_SEQUENCE_NUMBER => vcur_susa.sequence_number,
X_US_VERSION_NUMBER => vcur_susa.us_version_number,
X_SELECTION_DT => NULL,
X_STUDENT_CONFIRMED_IND => 'N',
X_END_DT => NULL ,
X_PARENT_UNIT_SET_CD => vcur_susa.parent_unit_set_cd ,
X_PARENT_SEQUENCE_NUMBER => vcur_susa.parent_sequence_number ,
X_PRIMARY_SET_IND => vcur_susa.primary_set_ind ,
X_VOLUNTARY_END_IND => 'N' ,
X_AUTHORISED_PERSON_ID => vcur_susa.authorised_person_id ,
X_AUTHORISED_ON => vcur_susa.authorised_on ,
X_OVERRIDE_TITLE => vcur_susa.override_title ,
X_RQRMNTS_COMPLETE_IND => vcur_susa.rqrmnts_complete_ind ,
X_RQRMNTS_COMPLETE_DT => NULL ,
X_S_COMPLETED_SOURCE_TYPE => vcur_susa.s_completed_source_type ,
X_CATALOG_CAL_TYPE => NULL ,
X_CATALOG_SEQ_NUM => NULL ,
X_ATTRIBUTE_CATEGORY => vcur_susa.attribute_category ,
X_ATTRIBUTE1 => vcur_susa.attribute1 ,
X_ATTRIBUTE2 => vcur_susa.attribute2 ,
X_ATTRIBUTE3 => vcur_susa.attribute3 ,
X_ATTRIBUTE4 => vcur_susa.attribute4 ,
X_ATTRIBUTE5 => vcur_susa.attribute5 ,
X_ATTRIBUTE6 => vcur_susa.attribute6 ,
X_ATTRIBUTE7 => vcur_susa.attribute7 ,
X_ATTRIBUTE8 => vcur_susa.attribute8 ,
X_ATTRIBUTE9 => vcur_susa.attribute9 ,
X_ATTRIBUTE10 => vcur_susa.attribute10 ,
X_ATTRIBUTE11 => vcur_susa.attribute11 ,
X_ATTRIBUTE12 => vcur_susa.attribute12 ,
X_ATTRIBUTE13 => vcur_susa.attribute13 ,
X_ATTRIBUTE14 => vcur_susa.attribute14 ,
X_ATTRIBUTE15 => vcur_susa.attribute15 ,
X_ATTRIBUTE16 => vcur_susa.attribute16 ,
X_ATTRIBUTE17 => vcur_susa.attribute17 ,
X_ATTRIBUTE18 => vcur_susa.attribute18 ,
X_ATTRIBUTE19 => vcur_susa.attribute19 ,
X_ATTRIBUTE20 => vcur_susa.attribute20 ,
X_MODE => 'R');
IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
X_ROWID => vcur_spa.rowid,
X_PERSON_ID => vcur_spa.PERSON_ID,
X_COURSE_CD => vcur_spa.COURSE_CD,
X_ADVANCED_STANDING_IND => vcur_spa.ADVANCED_STANDING_IND,
X_FEE_CAT => vcur_spa.FEE_CAT,
X_CORRESPONDENCE_CAT => vcur_spa.CORRESPONDENCE_CAT,
X_SELF_HELP_GROUP_IND => vcur_spa.SELF_HELP_GROUP_IND,
X_LOGICAL_DELETE_DT => vcur_spa.LOGICAL_DELETE_DT,
X_ADM_ADMISSION_APPL_NUMBER => vcur_spa.ADM_ADMISSION_APPL_NUMBER,
X_ADM_NOMINATED_COURSE_CD => vcur_spa.ADM_NOMINATED_COURSE_CD,
X_ADM_SEQUENCE_NUMBER => vcur_spa.ADM_SEQUENCE_NUMBER,
X_VERSION_NUMBER => vcur_spa.VERSION_NUMBER,
X_CAL_TYPE => vcur_spa.CAL_TYPE,
X_LOCATION_CD => vcur_spa.LOCATION_CD,
X_ATTENDANCE_MODE => vcur_spa.ATTENDANCE_MODE,
X_ATTENDANCE_TYPE => vcur_spa.ATTENDANCE_TYPE,
X_COO_ID => vcur_spa.COO_ID,
X_STUDENT_CONFIRMED_IND => 'N',
X_COMMENCEMENT_DT => NULL,
X_COURSE_ATTEMPT_STATUS => 'UNCONFIRM',
X_PROGRESSION_STATUS => vcur_spa.PROGRESSION_STATUS,
X_DERIVED_ATT_TYPE => vcur_spa.DERIVED_ATT_TYPE,
X_DERIVED_ATT_MODE => vcur_spa.DERIVED_ATT_MODE,
X_PROVISIONAL_IND => vcur_spa.PROVISIONAL_IND ,
X_DISCONTINUED_DT => vcur_spa.DISCONTINUED_DT,
X_DISCONTINUATION_REASON_CD => vcur_spa.DISCONTINUATION_REASON_CD,
X_LAPSED_DT => vcur_spa.LAPSED_DT,
X_FUNDING_SOURCE => vcur_spa.FUNDING_SOURCE,
X_EXAM_LOCATION_CD => vcur_spa.EXAM_LOCATION_CD,
X_DERIVED_COMPLETION_YR => vcur_spa.DERIVED_COMPLETION_YR,
X_DERIVED_COMPLETION_PERD => vcur_spa.DERIVED_COMPLETION_PERD,
X_NOMINATED_COMPLETION_YR => vcur_spa.nominated_completion_yr,
X_NOMINATED_COMPLETION_PERD => vcur_spa.NOMINATED_COMPLETION_PERD,
X_RULE_CHECK_IND => vcur_spa.RULE_CHECK_IND,
X_WAIVE_OPTION_CHECK_IND => vcur_spa.WAIVE_OPTION_CHECK_IND,
X_LAST_RULE_CHECK_DT => vcur_spa.LAST_RULE_CHECK_DT,
X_PUBLISH_OUTCOMES_IND => vcur_spa.PUBLISH_OUTCOMES_IND,
X_COURSE_RQRMNT_COMPLETE_IND => vcur_spa.COURSE_RQRMNT_COMPLETE_IND,
X_COURSE_RQRMNTS_COMPLETE_DT => vcur_spa.COURSE_RQRMNTS_COMPLETE_DT,
X_S_COMPLETED_SOURCE_TYPE => vcur_spa.S_COMPLETED_SOURCE_TYPE,
X_OVERRIDE_TIME_LIMITATION => vcur_spa.OVERRIDE_TIME_LIMITATION,
X_MODE => 'R',
x_last_date_of_attendance => vcur_spa.LAST_DATE_OF_ATTENDANCE,
x_dropped_by => vcur_spa.DROPPED_BY,
X_IGS_PR_CLASS_STD_ID => vcur_spa.IGS_PR_CLASS_STD_ID,
x_primary_program_type => l_primaryInd,
x_primary_prog_type_source => vcur_spa.PRIMARY_PROG_TYPE_SOURCE,
x_catalog_cal_type => NULL,
x_catalog_seq_num => NULL,
x_key_program => 'N',
x_override_cmpl_dt => vcur_spa.OVERRIDE_CMPL_DT,
x_manual_ovr_cmpl_dt_ind => vcur_spa.MANUAL_OVR_CMPL_DT_IND,
X_ATTRIBUTE_CATEGORY => vcur_spa.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => vcur_spa.ATTRIBUTE1,
X_ATTRIBUTE2 => vcur_spa.ATTRIBUTE2,
X_ATTRIBUTE3 => vcur_spa.ATTRIBUTE3,
X_ATTRIBUTE4 => vcur_spa.ATTRIBUTE4,
X_ATTRIBUTE5 => vcur_spa.ATTRIBUTE5,
X_ATTRIBUTE6 => vcur_spa.ATTRIBUTE6,
X_ATTRIBUTE7 => vcur_spa.ATTRIBUTE7,
X_ATTRIBUTE8 => vcur_spa.ATTRIBUTE8,
X_ATTRIBUTE9 => vcur_spa.ATTRIBUTE9,
X_ATTRIBUTE10 => vcur_spa.ATTRIBUTE10,
X_ATTRIBUTE11 => vcur_spa.ATTRIBUTE11,
X_ATTRIBUTE12 => vcur_spa.ATTRIBUTE12,
X_ATTRIBUTE13 => vcur_spa.ATTRIBUTE13,
X_ATTRIBUTE14 => vcur_spa.ATTRIBUTE14,
X_ATTRIBUTE15 => vcur_spa.ATTRIBUTE15,
X_ATTRIBUTE16 => vcur_spa.ATTRIBUTE16,
X_ATTRIBUTE17 => vcur_spa.ATTRIBUTE17,
X_ATTRIBUTE18 => vcur_spa.ATTRIBUTE18,
X_ATTRIBUTE19 => vcur_spa.ATTRIBUTE19,
X_ATTRIBUTE20 => vcur_spa.ATTRIBUTE20,
X_FUTURE_DATED_TRANS_FLAG => vcur_spa.FUTURE_DATED_TRANS_FLAG);
Select spa.rowid
from igs_en_stdnt_ps_att_all spa
where spa.person_id=cp_person_id
and spa.adm_admission_appl_number=cp_adm_appl_number
and spa.adm_nominated_course_cd=cp_adm_nom_course_cd
and spa.adm_sequence_number = cp_adm_sequence_num;
SELECT spa.rowid
FROM igs_en_stdnt_ps_att_all spa
WHERE spa.person_id = p_person_id
AND spa.course_cd = p_nominated_course_cd;