The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE beforerowdelete;
PROCEDURE AfterRowInsertUpdate5(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) ;
x_logical_delete_dt IN DATE,
x_adm_admission_appl_number IN NUMBER,
x_adm_nominated_course_cd IN VARCHAR2,
x_adm_sequence_number IN NUMBER,
x_creation_date IN DATE,
x_created_by IN NUMBER,
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_last_update_login IN NUMBER,
x_last_date_of_attendance IN DATE,
x_dropped_by IN VARCHAR2,
x_igs_pr_class_std_id IN NUMBER,
x_primary_program_type IN VARCHAR2,
x_primary_prog_type_source IN VARCHAR2,
x_catalog_cal_type IN VARCHAR2,
x_catalog_seq_num IN NUMBER ,
x_key_program IN VARCHAR2,
x_manual_ovr_cmpl_dt_ind IN VARCHAR2,
x_override_cmpl_dt IN DATE ,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_future_dated_trans_flag In VARCHAR2
) AS
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE ROWID = x_rowid;
IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
CLOSE cur_old_ref_values;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
old_references.logical_delete_dt := TRUNC(old_references.logical_delete_dt);
IF p_action = 'UPDATE' AND x_org_id IS NULL THEN
new_references.org_id := old_references.org_id;
new_references.logical_delete_dt := TRUNC(x_logical_delete_dt);
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
SELECT cal_type,ci_sequence_number,discontinued_dt
FROM IGS_EN_SU_ATTEMPT
WHERE person_id = x_person_id
AND course_cd = x_course_cd
AND discontinued_dt IS NOT NULL
ORDER BY discontinued_dt DESC;
SELECT *
FROM IGS_CA_TEACH_TO_LOAD_V
WHERE teach_cal_type = p_cal_type
AND teach_ci_sequence_number = p_ci_sequence_number
AND load_start_dt <= TRUNC(p_discontinued_dt)
ORDER BY load_start_dt DESC;
SELECT cal_type,ci_sequence_number
FROM IGS_EN_SU_ATTEMPT
WHERE person_id = x_person_id
AND course_cd = x_course_cd
AND unit_attempt_status='COMPLETED';
SELECT *
FROM IGS_CA_TEACH_TO_LOAD_V
WHERE teach_cal_type = p_cal_type
AND teach_ci_sequence_number = p_ci_sequence_number
ORDER BY load_end_dt DESC;
SELECT person_type_code
FROM IGS_PE_PERSON_TYPES_V
WHERE system_type = 'STAFF';
PROCEDURE BeforeRowInsertUpdate1(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
v_message_name VARCHAR2(30);
SELECT crv.course_type
FROM igs_ps_ver crv
WHERE course_cd = new_references.course_cd
and version_number = new_references.version_number;
IF p_inserting THEN
IGS_PS_GEN_003.CRSP_GET_COO_KEY (
new_references.coo_id,
new_references.course_cd,
new_references.version_number,
new_references.cal_type,
new_references.location_cd,
new_references.attendance_mode,
new_references.attendance_type);
IF p_inserting OR p_updating THEN
-- Validate confirming an admission course transfer
IF p_inserting OR
(p_updating AND
new_references.student_confirmed_ind <> old_references.student_confirmed_ind) THEN
IF Igs_En_Val_Sca.enrp_val_trnsfr_acpt(
neW_references.person_id,
new_references.course_cd,
new_references.student_confirmed_ind,
new_references.adm_admission_appl_number,
new_references.adm_nominated_course_cd,
NULL,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
((new_references.discontinued_dt IS NULL AND
old_references.discontinued_dt IS NOT NULL) OR
(new_references.discontinued_dt IS NOT NULL AND
old_references.discontinued_dt IS NULL) OR
(new_references.discontinued_dt IS NOT NULL AND
old_references.discontinued_dt <>new_references.discontinued_dt))) THEN
IF Igs_En_Val_Sca.enrp_val_sca_discont(
new_references.person_id,
new_references.course_cd,
new_references.version_number,
new_references.course_attempt_status,
new_references.discontinuation_reason_cd,
new_references.discontinued_dt,
new_references.commencement_dt,
v_message_name,
'N') = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
((new_references.discontinuation_reason_cd IS NULL AND
old_references.discontinuation_reason_cd IS NOT NULL) OR
(new_references.discontinuation_reason_cd IS NOT NULL AND
old_references.discontinuation_reason_cd IS NULL) OR
(new_references.discontinuation_reason_cd IS NOT NULL AND
old_references.discontinuation_reason_cd <> new_references.discontinuation_reason_cd))) THEN
IF Igs_En_Val_Sca.enrp_val_sca_dr(
new_references.person_id,
new_references.course_cd,
new_references.discontinuation_reason_cd,
new_references.discontinued_dt,
v_message_name,
'N') = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
new_references.course_rqrmnt_complete_ind <> old_references.course_rqrmnt_complete_ind) THEN
IF new_references.course_rqrmnt_complete_ind = 'Y' THEN
-- Validate that SCA Status is not 'COMPLETED' or 'UNCONFIRM'.
IF new_references.course_attempt_status IN ('COMPLETED','UNCONFIRM') THEN
Fnd_Message.set_name('IGS','IGS_PR_CANNOT_SET_COMPL_IND');
IF p_inserting OR
(p_updating AND
((new_references.course_rqrmnts_complete_dt IS NULL AND
old_references.course_rqrmnts_complete_dt IS NOT NULL) OR
(new_references.course_rqrmnts_complete_dt IS NOT NULL AND
old_references.course_rqrmnts_complete_dt IS NULL) OR
(new_references.course_rqrmnts_complete_dt IS NOT NULL AND
new_references.course_rqrmnts_complete_dt <> old_references.course_rqrmnts_complete_dt))) THEN
IF IGS_PR_VAL_SCA.prgp_val_sca_cmpl_dt (
new_references.person_id,
new_references.course_cd,
new_references.commencement_dt,
new_references.course_rqrmnts_complete_dt,
v_message_name,
'N') = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
new_references.fee_cat <> old_references.fee_cat) THEN
IF Igs_ad_Val_fcm.finp_val_fc_closed(
new_references.fee_cat,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
new_references.logical_delete_dt);
new_references.logical_delete_dt);
new_references.logical_delete_dt);
IF p_inserting OR p_updating THEN
IF new_references.course_attempt_status IS NULL THEN
new_references.course_attempt_status :=
IGS_EN_GEN_006.ENRP_GET_SCA_STATUS(
new_references.person_id,
new_references.course_cd,
v_course_attempt_status,
new_references.student_confirmed_ind,
new_references.discontinued_dt,
new_references.lapsed_dt,
new_references.course_rqrmnt_complete_ind,
new_references.logical_delete_dt);
END BeforeRowInsertUpdate1;
PROCEDURE BeforeRowInsertUpdateDelete2(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
v_sequence_number NUMBER;
IF p_inserting OR p_updating THEN
v_sequence_number := IGS_GE_GEN_003.GENP_INS_STDNT_TODO(
new_references.person_id,
'FEE_RECALC',
SYSDATE,
'Y');
END BeforeRowInsertUpdateDelete2;
PROCEDURE AfterRowInsertUpdate3(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
v_message_name VARCHAR2(30);
(p_inserting AND
new_references.student_confirmed_ind = 'Y') THEN
-- update of application response status on confirming the offer
v_save_row := TRUE;
IF p_inserting OR
(p_updating AND
new_references.fee_cat <> old_references.fee_cat) THEN
v_save_row := TRUE;
(p_inserting AND
new_references.student_confirmed_ind = 'Y') THEN
IF Igs_En_Gen_011.ENRP_UPD_ACAI_ACCEPT(
new_references.person_id,
new_references.course_cd,
new_references.adm_admission_appl_number,
new_references.adm_nominated_course_cd,
new_references.adm_sequence_number,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
END AfterRowInsertUpdate3;
PROCEDURE AfterRowInsertUpdate5(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
BEGIN
-- Bug # 2829275 . UK Correspondence. The TBH needs to be modified to so that the program discontinuation event is raised when the program attempt is changed .
IF ( p_updating
AND ((new_references.location_cd <> old_references.location_cd)
OR (new_references.attendance_mode <> old_references.attendance_mode)
OR (new_references.attendance_type <> old_references.attendance_type)
OR (new_references.cal_type <> old_references.cal_type))) THEN
igs_en_workflow.progofropt_event (
p_personid => new_references.person_id,
p_programcd => new_references.course_cd,
p_locationcd => new_references.location_cd,
p_prev_location_cd => old_references.location_cd,
p_attndmode => new_references.attendance_mode,
p_prev_attndmode => old_references.attendance_mode,
p_attndtype => new_references.attendance_type,
p_prev_attndtype => old_references.attendance_type
) ;
END AfterRowInsertUpdate5;
PROCEDURE AfterRowInsertUpdate4(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
/* HISTORY
-- who when what
--ayedubat 09-JUL-2002 Added a new cursor,cur_pe_typ_inst to consider the active person type records
-- of a student program which are mapped to a closed system type.
-- Check whenther the cursor is fetching a record whenever a person type record of a particular
-- system type should be end dated and if found, call the TBH to end date the record for the bug:2389552
--ayedubat 2nd MAY 2002 Added the code for p_inseting = TRUE as part of the bug fix:2344079
-- This will change the Person_Type from Applicant to Student during the pre_enrollment process
-- through admissions subsystem.
--shimitta 29 JUNE 2006 Modified l_method acording as bug# 2691653
*/
--modified cursor for perf bug 3696781
CURSOR cur_typ_id_inst(p_PERSON_ID NUMBER,p_COURSE_CD VARCHAR2,p_PERSON_TYPE_CODE VARCHAR2) IS
SELECT pti.*
FROM igs_pe_typ_instances_all pti
WHERE pti.PERSON_ID = p_PERSON_ID AND
pti.COURSE_CD = p_COURSE_CD AND
pti.PERSON_TYPE_CODE = p_PERSON_TYPE_CODE AND
pti.END_DATE IS NULL;
SELECT PERSON_TYPE_CODE
FROM igs_pe_person_types
WHERE SYSTEM_TYPE = p_system_type AND
CLOSED_IND = 'N';
SELECT pti.rowid row_id ,pti.*
FROM igs_pe_typ_instances_all pti,
igs_pe_person_types pty
WHERE pti.person_id = p_person_id AND
pti.course_cd = p_course_cd AND
pti.end_date IS NULL AND
pty.person_type_code = pti.person_type_code AND
pty.system_type = p_system_type;
SELECT sci.person_id,sci.course_cd,start_dt, sci.end_dt, sci.voluntary_ind,sci.comments ,sci.created_by ,sci.creation_date ,
sci.last_updated_by ,sci.last_update_date , sci.last_update_login , sci.intermission_type , sci.approved ,sci.institution_name,
sci.max_credit_pts, sci.max_terms, sci.anticipated_credit_points, sci.approver_id
FROM igs_en_stdnt_ps_intm sci,
igs_en_intm_types eit
WHERE sci.course_cd = cp_course_cd
AND sci.person_id = cp_perosn_id
AND sci.approved = eit.appr_reqd_ind
AND eit.intermission_type = sci.intermission_type
AND sci.logical_delete_date = TO_DATE ('31-12-4712','DD-MM-YYYY');
SELECT 1
FROM igs_re_candidature
WHERE sca_course_cd = cp_course_cd
AND person_id = cp_person_id ;
IF p_inserting THEN
IF new_references.course_attempt_status = 'INACTIVE' THEN
l_person_type := NULL;
igs_pe_typ_instances_pkg.update_row(
X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,
X_PERSON_TYPE_CODE => cur_pe_typ_inst_rec.PERSON_TYPE_CODE,
X_CC_VERSION_NUMBER => cur_pe_typ_inst_rec.CC_VERSION_NUMBER,
X_FUNNEL_STATUS => cur_pe_typ_inst_rec.FUNNEL_STATUS,
X_ADMISSION_APPL_NUMBER => cur_pe_typ_inst_rec.ADMISSION_APPL_NUMBER,
X_NOMINATED_COURSE_CD => cur_pe_typ_inst_rec.NOMINATED_COURSE_CD,
X_NCC_VERSION_NUMBER => cur_pe_typ_inst_rec.NCC_VERSION_NUMBER,
X_SEQUENCE_NUMBER => cur_pe_typ_inst_rec.SEQUENCE_NUMBER,
X_START_DATE => cur_pe_typ_inst_rec.START_DATE,
X_END_DATE => SYSDATE,
X_CREATE_METHOD => cur_pe_typ_inst_rec.CREATE_METHOD,
X_ENDED_BY => cur_pe_typ_inst_rec.ENDED_BY,
X_END_METHOD => l_method,
X_MODE => 'R' ,
X_EMPLMNT_CATEGORY_CODE => cur_pe_typ_inst_rec.emplmnt_category_code );
igs_pe_typ_instances_pkg.insert_row(
X_ROWID => l_ROWID,
X_PERSON_ID => new_references.PERSON_ID,
X_COURSE_CD => new_references.COURSE_CD,
X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,
X_PERSON_TYPE_CODE => l_person_type,
X_CC_VERSION_NUMBER => NULL,
X_FUNNEL_STATUS => NULL,
X_ADMISSION_APPL_NUMBER => NULL,
X_NOMINATED_COURSE_CD => NULL,
X_NCC_VERSION_NUMBER => NULL,
X_SEQUENCE_NUMBER => NULL,
X_START_DATE => SYSDATE,
X_END_DATE => NULL,
X_CREATE_METHOD => l_method,
X_ENDED_BY => NULL,
X_END_METHOD => NULL,
X_MODE => 'R',
X_ORG_ID => new_references.ORG_ID ,
X_EMPLMNT_CATEGORY_CODE => NULL
);
igs_pe_typ_instances_pkg.update_row(
X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,
X_PERSON_TYPE_CODE => cur_pe_typ_inst_rec.PERSON_TYPE_CODE,
X_CC_VERSION_NUMBER => cur_pe_typ_inst_rec.CC_VERSION_NUMBER,
X_FUNNEL_STATUS => cur_pe_typ_inst_rec.FUNNEL_STATUS,
X_ADMISSION_APPL_NUMBER => cur_pe_typ_inst_rec.ADMISSION_APPL_NUMBER,
X_NOMINATED_COURSE_CD => cur_pe_typ_inst_rec.NOMINATED_COURSE_CD,
X_NCC_VERSION_NUMBER => cur_pe_typ_inst_rec.NCC_VERSION_NUMBER,
X_SEQUENCE_NUMBER => cur_pe_typ_inst_rec.SEQUENCE_NUMBER,
X_START_DATE => cur_pe_typ_inst_rec.START_DATE,
X_END_DATE => SYSDATE,
X_CREATE_METHOD => cur_pe_typ_inst_rec.CREATE_METHOD,
X_ENDED_BY => cur_pe_typ_inst_rec.ENDED_BY,
X_END_METHOD => l_method,
X_MODE => 'R' ,
X_EMPLMNT_CATEGORY_CODE => cur_pe_typ_inst_rec.emplmnt_category_code);
igs_pe_typ_instances_pkg.insert_row(
X_ROWID => l_ROWID,
X_PERSON_ID => new_references.PERSON_ID,
X_COURSE_CD => new_references.COURSE_CD,
X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,
X_PERSON_TYPE_CODE => l_person_type,
X_CC_VERSION_NUMBER => NULL,
X_FUNNEL_STATUS => NULL,
X_ADMISSION_APPL_NUMBER => NULL,
X_NOMINATED_COURSE_CD => NULL,
X_NCC_VERSION_NUMBER => NULL,
X_SEQUENCE_NUMBER => NULL,
X_START_DATE => SYSDATE,
X_END_DATE => NULL,
X_CREATE_METHOD => l_method,
X_ENDED_BY => NULL,
X_END_METHOD => NULL,
X_MODE => 'R',
X_ORG_ID => new_references.ORG_ID,
X_EMPLMNT_CATEGORY_CODE => NULL
);
igs_pe_typ_instances_pkg.update_row(
X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,
X_PERSON_TYPE_CODE => cur_pe_typ_inst_rec.PERSON_TYPE_CODE,
X_CC_VERSION_NUMBER => cur_pe_typ_inst_rec.CC_VERSION_NUMBER,
X_FUNNEL_STATUS => cur_pe_typ_inst_rec.FUNNEL_STATUS,
X_ADMISSION_APPL_NUMBER => cur_pe_typ_inst_rec.ADMISSION_APPL_NUMBER,
X_NOMINATED_COURSE_CD => cur_pe_typ_inst_rec.NOMINATED_COURSE_CD,
X_NCC_VERSION_NUMBER => cur_pe_typ_inst_rec.NCC_VERSION_NUMBER,
X_SEQUENCE_NUMBER => cur_pe_typ_inst_rec.SEQUENCE_NUMBER,
X_START_DATE => cur_pe_typ_inst_rec.START_DATE,
X_END_DATE => SYSDATE,
X_CREATE_METHOD => cur_pe_typ_inst_rec.CREATE_METHOD,
X_ENDED_BY => cur_pe_typ_inst_rec.ENDED_BY,
X_END_METHOD => l_method,
X_MODE => 'R' ,
X_EMPLMNT_CATEGORY_CODE => cur_pe_typ_inst_rec.emplmnt_category_code);
igs_pe_typ_instances_pkg.insert_row(
X_ROWID => l_ROWID,
X_PERSON_ID => new_references.PERSON_ID,
X_COURSE_CD => new_references.COURSE_CD,
X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,
X_PERSON_TYPE_CODE => l_person_type,
X_CC_VERSION_NUMBER => NULL,
X_FUNNEL_STATUS => NULL,
X_ADMISSION_APPL_NUMBER => NULL,
X_NOMINATED_COURSE_CD => NULL,
X_NCC_VERSION_NUMBER => NULL,
X_SEQUENCE_NUMBER => NULL,
X_START_DATE => SYSDATE,
X_END_DATE => NULL,
X_CREATE_METHOD => l_method,
X_ENDED_BY => NULL,
X_END_METHOD => NULL,
X_MODE => 'R',
X_ORG_ID => new_references.ORG_ID,
X_EMPLMNT_CATEGORY_CODE => NULL
);
END AfterRowInsertUpdate4;
PROCEDURE AfterRowUpdate4(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
BEGIN
-- create a history
IGS_EN_GEN_009.ENRP_INS_SCA_HIST(
old_references.person_id,
old_references.course_cd,
new_references.version_number,
old_references.version_number,
new_references.cal_type,
old_references.cal_type,
new_references.location_cd,
old_references.location_cd,
new_references.attendance_mode,
old_references.attendance_mode,
new_references.attendance_type,
old_references.attendance_type,
new_references.student_confirmed_ind,
old_references.student_confirmed_ind,
new_references.commencement_dt,
old_references.commencement_dt,
new_references.course_attempt_status,
old_references.course_attempt_status,
new_references.progression_status,
old_references.progression_status,
new_references.derived_att_type,
old_references.derived_att_type,
new_references.derived_att_mode,
old_references.derived_att_mode,
new_references.provisional_ind,
old_references.provisional_ind,
new_references.discontinued_dt,
old_references.discontinued_dt,
new_references.discontinuation_reason_cd,
old_references.discontinuation_reason_cd,
new_references.lapsed_dt,
old_references.lapsed_dt,
new_references.funding_source,
old_references.funding_source,
new_references.exam_location_cd,
old_references.exam_location_cd,
new_references.derived_completion_yr,
old_references.derived_completion_yr,
new_references.derived_completion_perd,
old_references.derived_completion_perd,
new_references.nominated_completion_yr,
old_references.nominated_completion_yr,
new_references.nominated_completion_perd,
old_references.nominated_completion_perd,
new_references.rule_check_ind,
old_references.rule_check_ind,
new_references.waive_option_check_ind,
old_references.waive_option_check_ind,
new_references.last_rule_check_dt,
old_references.last_rule_check_dt,
new_references.publish_outcomes_ind,
old_references.publish_outcomes_ind,
new_references.course_rqrmnt_complete_ind,
old_references.course_rqrmnt_complete_ind,
new_references.course_rqrmnts_complete_dt,
old_references.course_rqrmnts_complete_dt,
new_references.s_completed_source_type,
old_references.s_completed_source_type,
new_references.override_time_limitation,
old_references.override_time_limitation,
new_references.advanced_standing_ind,
old_references.advanced_standing_ind,
new_references.fee_cat,
old_references.fee_cat,
new_references.self_help_group_ind,
old_references.self_help_group_ind,
new_references.correspondence_cat,
old_references.correspondence_cat,
new_references.adm_admission_appl_number,
old_references.adm_admission_appl_number,
new_references.adm_nominated_course_cd,
old_references.adm_nominated_course_cd,
new_references.adm_sequence_number,
old_references.adm_sequence_number,
new_references.last_updated_by,
old_references.last_updated_by,
new_references.last_update_date,
old_references.last_update_date,
new_references.last_date_of_attendance,
old_references.last_date_of_attendance,
new_references.dropped_by,
old_references.dropped_by ,
new_references.primary_program_type ,
old_references.primary_program_type ,
new_references.primary_prog_type_source ,
old_references.primary_prog_type_source ,
new_references.catalog_cal_type ,
old_references.catalog_cal_type ,
new_references.catalog_seq_num ,
old_references.catalog_seq_num ,
new_references.key_program ,
old_references.key_program,
new_references.override_cmpl_dt,
old_references.override_cmpl_dt,
new_references.manual_ovr_cmpl_dt_ind,
old_references.manual_ovr_cmpl_dt_ind,
new_references.coo_id,
old_references.coo_id,
new_references.igs_pr_class_std_id,
old_references.igs_pr_class_std_id);
END AfterRowUpdate4;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
SELECT course_attempt_status
FROM igs_en_stdnt_ps_att_all
WHERE person_id = x_person_id
AND course_cd = x_course_cd;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE person_id = x_person_id
AND course_cd = x_course_cd
FOR UPDATE NOWAIT;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE progression_status = x_progression_status ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE derived_att_mode = x_attendance_mode ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE course_attempt_status = x_course_attempt_status ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE person_id = x_person_id
AND adm_admission_appl_number = x_admission_appl_number
AND adm_nominated_course_cd = x_nominated_course_cd
AND adm_sequence_number = x_sequence_number ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE derived_att_type = x_attendance_type ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE correspondence_cat = x_correspondence_cat ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE course_cd = x_course_cd
AND version_number = x_version_number
AND cal_type = x_cal_type
AND location_cd = x_location_cd
AND attendance_mode = x_attendance_mode
AND attendance_type = x_attendance_type ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE coo_id = x_coo_id;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE course_cd = x_course_cd ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE course_cd = x_course_cd
AND version_number = x_version_number ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE fee_cat = x_fee_cat ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE funding_source = x_funding_source ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE exam_location_cd = x_location_cd ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE person_id = x_person_id ;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE IGS_PR_CLASS_STD_ID = X_IGS_PR_CLASS_STD_ID;
SELECT ROWID
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE CATALOG_CAL_TYPE = X_CATALOG_CAL_TYPE
AND CATALOG_SEQ_NUM = X_CATALOG_SEQ_NUM ;
x_logical_delete_dt IN DATE,
x_adm_admission_appl_number IN NUMBER,
x_adm_nominated_course_cd IN VARCHAR2,
x_adm_sequence_number IN NUMBER,
x_creation_date IN DATE,
x_created_by IN NUMBER,
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_last_update_login IN NUMBER,
x_last_date_of_attendance IN DATE,
x_dropped_by IN VARCHAR2,
x_igs_pr_class_std_id IN NUMBER,
x_primary_program_type IN VARCHAR2,
x_primary_prog_type_source IN VARCHAR2,
x_catalog_cal_type IN VARCHAR2,
x_catalog_seq_num IN NUMBER,
x_key_program IN VARCHAR2,
x_manual_ovr_cmpl_dt_ind IN VARCHAR2,
x_override_cmpl_dt IN DATE,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_future_dated_trans_flag In VARCHAR2
) AS
BEGIN
Set_Column_Values (
p_action,
x_rowid,
x_org_id,
x_person_id,
x_course_cd,
x_version_number,
x_cal_type,
x_location_cd,
x_attendance_mode,
x_attendance_type,
x_coo_id,
x_student_confirmed_ind,
x_commencement_dt,
x_course_attempt_status,
x_progression_status,
x_derived_att_type,
x_derived_att_mode,
x_provisional_ind,
x_discontinued_dt,
x_discontinuation_reason_cd,
x_lapsed_dt,
x_funding_source,
x_exam_location_cd,
x_derived_completion_yr,
x_derived_completion_perd,
x_nominated_completion_yr,
x_nominated_completion_perd,
x_rule_check_ind,
x_waive_option_check_ind,
x_last_rule_check_dt,
x_publish_outcomes_ind,
x_course_rqrmnt_complete_ind,
x_course_rqrmnts_complete_dt,
x_s_completed_source_type,
x_override_time_limitation,
x_advanced_standing_ind,
x_fee_cat,
x_correspondence_cat,
x_self_help_group_ind,
x_logical_delete_dt,
x_adm_admission_appl_number,
x_adm_nominated_course_cd,
x_adm_sequence_number,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_last_date_of_attendance,
x_dropped_by,
X_IGS_PR_CLASS_STD_ID,
x_primary_program_type,
x_primary_prog_type_source,
x_catalog_cal_type,
x_catalog_seq_num,
x_key_program,
x_manual_ovr_cmpl_dt_ind,
x_override_cmpl_dt,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_attribute16,
x_attribute17,
x_attribute18,
x_attribute19,
x_attribute20,
x_future_dated_trans_flag
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
BeforeRowInsertUpdate1 ( p_inserting => TRUE,
p_updating => FALSE,
p_deleting => FALSE);
BeforeRowInsertUpdateDelete2 ( p_inserting => TRUE,
p_updating => FALSE,
p_deleting => FALSE);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
BeforeRowInsertUpdate1 ( p_inserting => FALSE,
p_updating => TRUE,
p_deleting => FALSE);
BeforeRowInsertUpdateDelete2( p_inserting => FALSE,
p_updating => TRUE,
p_deleting => FALSE);
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
beforerowdelete;
BeforeRowInsertUpdateDelete2 ( p_inserting => FALSE,
p_updating => FALSE,
p_deleting => TRUE);
ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF Get_PK_For_Validation(
new_references.person_id ,
new_references.course_cd
) THEN
FND_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
Check_constraints;
ELSIF (p_action = 'VALIDATE_DELETE') THEN
Check_Child_Existance;
IF (p_action in ('INSERT','UPDATE')) AND (NOT IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml) THEN
IGS_EN_CAREER_MODEL.SCA_TBH_BEFORE_DML(
p_person_id => new_references.person_id,
p_course_cd => new_references.course_cd,
p_version_number => new_references.version_number,
p_old_course_attempt_status => old_references.course_attempt_status ,
p_new_course_attempt_status => new_references.course_attempt_status ,
p_primary_program_type => new_references.primary_program_type,
p_primary_prog_type_source => new_references.primary_prog_type_source,
p_new_key_program => new_references.key_program
);
SELECT sct.course_cd,sct.effective_term_cal_type,sct.effective_term_sequence_num
FROM IGS_PS_STDNT_TRN sct, IGS_EN_STDNT_PS_ATT sca
WHERE sct.person_id = cp_person_id
AND sct.transfer_course_cd = cp_program_cd
AND sct.course_cd = sca.course_cd
AND sct.person_id = sca.person_id
AND sca.future_dated_trans_flag = 'Y';
IF p_action = 'UPDATE' THEN
-- When a program attempt is intermitted/discontinued/lapsed/unconfirmed and it is the source program for
-- future dated program transfer then the future dated program transfer must be deleted
IF (p_old_references.course_attempt_status IN ('ENROLLED','INACTIVE') AND
p_new_references.course_attempt_status IN ('INTERMIT','DISCONTIN','LAPSED','UNCONFIRM')) THEN
OPEN cur_fut_dt_trnsf(p_new_references.person_id, p_new_references.course_cd);
'DELETE'
);
IF (p_action in ('INSERT','UPDATE')) AND (NOT p_skip_before_after_dml) THEN
IGS_EN_CAREER_MODEL.SCA_TBH_AFTER_DML(
p_person_id => p_new_references.person_id,
p_course_cd => p_new_references.course_cd,
p_version_number => p_new_references.version_number,
p_old_course_attempt_status => p_old_references.course_attempt_status ,
p_new_course_attempt_status => p_new_references.course_attempt_status ,
p_primary_prog_type_source => p_new_references.primary_prog_type_source,
p_old_pri_prog_type => p_old_references.primary_program_type,
p_new_pri_prog_type => p_new_references.primary_program_type,
p_old_key_program => p_old_references.key_program
);
SELECT course_cd
FROM igs_en_stdnt_ps_att
WHERE person_id = cp_person_id AND
course_cd <> cp_course_cd AND
key_program = 'Y';
SELECT course_type
FROM igs_ps_ver
WHERE course_cd = cp_course_cd AND
version_number = cp_version_num;
SELECT spa.course_cd
FROM igs_en_stdnt_ps_att spa,
igs_ps_ver pv
WHERE spa.person_id = cp_person_id AND
spa.course_cd <> cp_course_cd 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 spa.person_id, 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.course_cd = pv.course_cd AND
spa.version_number = pv.version_number AND
pv.course_type = cp_course_type;
SELECT sua.uoo_id
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';
IF (p_action = 'INSERT') THEN
AfterRowInsertUpdate3 ( p_inserting => TRUE,
p_updating => FALSE,
p_deleting => FALSE);
AfterRowInsertUpdate4 ( p_inserting => TRUE,
p_updating => FALSE,
p_deleting => FALSE);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to After Update.
AfterRowInsertUpdate3 ( p_inserting => FALSE,
p_updating => TRUE,
p_deleting => FALSE);
AfterRowInsertUpdate4 ( p_inserting => FALSE,
p_updating => TRUE,
p_deleting => FALSE);
AfterRowUpdate4 ( p_inserting => FALSE,
p_updating => TRUE,
p_deleting => FALSE);
AfterRowInsertUpdate5 ( p_inserting => FALSE,
p_updating => TRUE,
p_deleting => FALSE);
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to After Delete.
NULL;
IF (p_action = 'UPDATE') THEN
l_spa_term_cal_type := igs_en_spa_terms_api.g_spa_term_cal_type;
g_primary_prg_rec.delete(i);
IF (p_action = 'UPDATE') THEN
IF new_references.course_attempt_status IS NULL THEN
Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
IF p_action = 'INSERT' AND NVL(new_references.key_program,'N') = 'Y' THEN
igf_aw_coa_gen.ins_coa_todo(
p_person_id => new_references.person_id ,
p_calling_module => 'IGSEI24B',
p_program_code => new_references.course_cd,
p_version_number=> new_references.version_number) ;
IF p_action = 'DELETE' AND NVL(old_references.key_program,'N') = 'Y' THEN
igf_aw_coa_gen. ins_coa_todo(
p_person_id => old_references.person_id ,
p_calling_module => 'IGSEI24B_D',
p_program_code => old_references.course_cd,
p_version_number=> old_references.version_number) ;
IF (p_action='INSERT' OR p_action='UPDATE') THEN
IF (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N')='Y') THEN
IF (NVL(new_references.primary_program_type,'SECONDARY')='PRIMARY' AND
new_references.student_confirmed_ind='Y') THEN
BEGIN
-- Get the Program Type/Career for the program version.
OPEN cur_get_prog_type(new_references.course_cd,new_references.version_number);
--call to delete the unit attemps
l_delflag := IGS_EN_FUTURE_DT_TRANS.del_sua_for_reopen(cur_pattempts_rec.person_id,
cur_pattempts_rec.course_cd,
cur_sua_uooid_rec.uoo_id);
/* recursively calls update_row resetting the package variable new_references which might result in some */
/* unexpected behaviour. So, add any new code before this call. */
/**********************************************************************************************************/
AFTER_DML_RECURSIVE_CALLS(p_old_references => old_references,
p_new_references => new_references,
p_action => p_action,
p_skip_before_after_dml => IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml);
PROCEDURE INSERT_ROW (
X_ROWID IN OUT NOCOPY VARCHAR2,
X_ORG_ID IN NUMBER,
X_PERSON_ID IN NUMBER,
X_COURSE_CD IN VARCHAR2,
X_ADVANCED_STANDING_IND IN VARCHAR2,
X_FEE_CAT IN VARCHAR2,
X_CORRESPONDENCE_CAT IN VARCHAR2,
X_SELF_HELP_GROUP_IND IN VARCHAR2,
X_LOGICAL_DELETE_DT IN DATE,
X_ADM_ADMISSION_APPL_NUMBER IN NUMBER,
X_ADM_NOMINATED_COURSE_CD IN VARCHAR2,
X_ADM_SEQUENCE_NUMBER IN NUMBER,
X_VERSION_NUMBER IN NUMBER,
X_CAL_TYPE IN VARCHAR2,
X_LOCATION_CD IN VARCHAR2,
X_ATTENDANCE_MODE IN VARCHAR2,
X_ATTENDANCE_TYPE IN VARCHAR2,
X_COO_ID IN NUMBER,
X_STUDENT_CONFIRMED_IND IN VARCHAR2,
X_COMMENCEMENT_DT IN DATE,
X_COURSE_ATTEMPT_STATUS IN VARCHAR2,
X_PROGRESSION_STATUS IN VARCHAR2,
X_DERIVED_ATT_TYPE IN VARCHAR2,
X_DERIVED_ATT_MODE IN VARCHAR2,
X_PROVISIONAL_IND IN VARCHAR2,
X_DISCONTINUED_DT IN DATE,
X_DISCONTINUATION_REASON_CD IN VARCHAR2,
X_LAPSED_DT IN DATE,
X_FUNDING_SOURCE IN VARCHAR2,
X_EXAM_LOCATION_CD IN VARCHAR2,
X_DERIVED_COMPLETION_YR IN NUMBER,
X_DERIVED_COMPLETION_PERD IN VARCHAR2,
X_NOMINATED_COMPLETION_YR IN NUMBER,
X_NOMINATED_COMPLETION_PERD IN VARCHAR2,
X_RULE_CHECK_IND IN VARCHAR2,
X_WAIVE_OPTION_CHECK_IND IN VARCHAR2,
X_LAST_RULE_CHECK_DT IN DATE,
X_PUBLISH_OUTCOMES_IND IN VARCHAR2,
X_COURSE_RQRMNT_COMPLETE_IND IN VARCHAR2,
X_COURSE_RQRMNTS_COMPLETE_DT IN DATE,
X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
X_OVERRIDE_TIME_LIMITATION IN NUMBER,
X_MODE IN VARCHAR2 ,
X_LAST_DATE_OF_ATTENDANCE IN DATE,
X_DROPPED_BY IN VARCHAR2,
X_IGS_PR_CLASS_STD_ID IN NUMBER,
X_PRIMARY_PROGRAM_TYPE IN VARCHAR2,
X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2,
X_CATALOG_CAL_TYPE IN VARCHAR2,
X_CATALOG_SEQ_NUM IN NUMBER,
X_KEY_PROGRAM IN VARCHAR2,
X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2,
X_OVERRIDE_CMPL_DT IN DATE ,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
x_ATTRIBUTE20 IN VARCHAR2,
X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2
) AS
/*--------------------------------------------------------------------------------------------
--Change History
--Who When What
--sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id
-- in call to before_dml as part of SWCR006 build.
-----------------------------------------------------------------------------------------------*/
CURSOR C IS
SELECT ROWID FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE PERSON_ID = X_PERSON_ID
AND COURSE_CD = X_COURSE_CD;
X_LAST_UPDATE_DATE DATE;
X_LAST_UPDATED_BY NUMBER;
X_LAST_UPDATE_LOGIN NUMBER;
X_PROGRAM_UPDATE_DATE DATE;
X_LAST_UPDATE_DATE := SYSDATE;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
IF X_LAST_UPDATED_BY IS NULL THEN
X_LAST_UPDATED_BY := -1;
X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
IF X_LAST_UPDATE_LOGIN IS NULL THEN
X_LAST_UPDATE_LOGIN := -1;
X_PROGRAM_UPDATE_DATE := NULL;
X_PROGRAM_UPDATE_DATE := SYSDATE;
p_action => 'INSERT',
x_rowid => X_ROWID,
x_org_id => igs_ge_gen_003.get_org_id,
x_person_id => X_PERSON_ID,
x_course_cd => X_COURSE_CD,
x_advanced_standing_ind => NVL(X_ADVANCED_STANDING_IND,'N'),
x_fee_cat => X_FEE_CAT,
x_correspondence_cat => X_CORRESPONDENCE_CAT,
x_self_help_group_ind => NVL(X_SELF_HELP_GROUP_IND,'N'),
x_logical_delete_dt => X_LOGICAL_DELETE_DT,
x_adm_admission_appl_number => X_ADM_ADMISSION_APPL_NUMBER,
x_adm_nominated_course_cd => X_ADM_NOMINATED_COURSE_CD,
x_adm_sequence_number => X_ADM_SEQUENCE_NUMBER,
x_version_number => X_VERSION_NUMBER,
x_cal_type => X_CAL_TYPE,
x_location_cd => X_LOCATION_CD,
x_attendance_mode => X_ATTENDANCE_MODE,
x_attendance_type => X_ATTENDANCE_TYPE,
x_coo_id => X_COO_ID,
x_student_confirmed_ind => NVL(X_STUDENT_CONFIRMED_IND,'N'),
x_commencement_dt => X_COMMENCEMENT_DT,
x_course_attempt_status => X_COURSE_ATTEMPT_STATUS,
x_progression_status => NVL(X_PROGRESSION_STATUS,'GOODSTAND'),
x_derived_att_type => X_DERIVED_ATT_TYPE,
x_derived_att_mode => X_DERIVED_ATT_MODE,
x_provisional_ind => NVL(X_PROVISIONAL_IND,'N'),
x_discontinued_dt => X_DISCONTINUED_DT,
x_discontinuation_reason_cd => X_DISCONTINUATION_REASON_CD,
x_lapsed_dt => X_LAPSED_DT,
x_funding_source => X_FUNDING_SOURCE,
x_exam_location_cd => X_EXAM_LOCATION_CD,
x_derived_completion_yr => X_DERIVED_COMPLETION_YR,
x_derived_completion_perd => X_DERIVED_COMPLETION_PERD,
x_nominated_completion_yr => X_NOMINATED_COMPLETION_YR,
x_nominated_completion_perd => X_NOMINATED_COMPLETION_PERD,
x_rule_check_ind => NVL(X_RULE_CHECK_IND,'Y'),
x_waive_option_check_ind => NVL(X_WAIVE_OPTION_CHECK_IND,'N'),
x_last_rule_check_dt => X_LAST_RULE_CHECK_DT,
x_publish_outcomes_ind => NVL(X_PUBLISH_OUTCOMES_IND,'Y'),
x_course_rqrmnt_complete_ind => NVL(X_COURSE_RQRMNT_COMPLETE_IND,'N'),
x_course_rqrmnts_complete_dt => X_COURSE_RQRMNTS_COMPLETE_DT,
x_s_completed_source_type => NVL(X_S_COMPLETED_SOURCE_TYPE,'MANUAL'),
x_override_time_limitation => X_OVERRIDE_TIME_LIMITATION,
x_creation_date => X_LAST_UPDATE_DATE,
x_created_by => X_LAST_UPDATED_BY,
x_last_update_date => X_LAST_UPDATE_DATE,
x_last_updated_by => X_LAST_UPDATED_BY,
x_last_update_login => X_LAST_UPDATE_LOGIN,
x_last_date_of_attendance =>X_LAST_DATE_OF_ATTENDANCE,
x_dropped_by => X_DROPPED_BY,
X_IGS_PR_CLASS_STD_ID => X_IGS_PR_CLASS_STD_ID,
x_primary_program_type => X_PRIMARY_PROGRAM_TYPE,
x_primary_prog_type_source => X_PRIMARY_PROG_TYPE_SOURCE,
x_catalog_cal_type => X_CATALOG_CAL_TYPE,
x_catalog_seq_num => X_CATALOG_SEQ_NUM,
x_key_program => NVL(X_KEY_PROGRAM,'N'),
x_manual_ovr_cmpl_dt_ind => X_MANUAL_OVR_CMPL_DT_IND,
x_override_cmpl_dt => X_OVERRIDE_CMPL_DT,
x_attribute_category=>X_ATTRIBUTE_CATEGORY,
x_future_dated_trans_flag => NVL(X_FUTURE_DATED_TRANS_FLAG,'N'),
x_attribute1=>X_ATTRIBUTE1,
x_attribute2=>X_ATTRIBUTE2,
x_attribute3=>X_ATTRIBUTE3,
x_attribute4=>X_ATTRIBUTE4,
x_attribute5=>X_ATTRIBUTE5,
x_attribute6=>X_ATTRIBUTE6,
x_attribute7=>X_ATTRIBUTE7,
x_attribute8=>X_ATTRIBUTE8,
x_attribute9=>X_ATTRIBUTE9,
x_attribute10=>X_ATTRIBUTE10,
x_attribute11=>X_ATTRIBUTE11,
x_attribute12=>X_ATTRIBUTE12,
x_attribute13=>X_ATTRIBUTE13,
x_attribute14=>X_ATTRIBUTE14,
x_attribute15=>X_ATTRIBUTE15,
x_attribute16=>X_ATTRIBUTE16,
x_attribute17=>X_ATTRIBUTE17,
x_attribute18=>X_ATTRIBUTE18,
x_attribute19=>X_ATTRIBUTE19,
x_attribute20=>X_ATTRIBUTE20
);
INSERT INTO IGS_EN_STDNT_PS_ATT_ALL (
org_id,
ADVANCED_STANDING_IND,
FEE_CAT,
CORRESPONDENCE_CAT,
SELF_HELP_GROUP_IND,
LOGICAL_DELETE_DT,
ADM_ADMISSION_APPL_NUMBER,
ADM_NOMINATED_COURSE_CD,
ADM_SEQUENCE_NUMBER,
PERSON_ID,
COURSE_CD,
VERSION_NUMBER,
CAL_TYPE,
LOCATION_CD,
ATTENDANCE_MODE,
ATTENDANCE_TYPE,
COO_ID,
STUDENT_CONFIRMED_IND,
COMMENCEMENT_DT,
COURSE_ATTEMPT_STATUS,
PROGRESSION_STATUS,
DERIVED_ATT_TYPE,
DERIVED_ATT_MODE,
PROVISIONAL_IND,
DISCONTINUED_DT,
DISCONTINUATION_REASON_CD,
LAPSED_DT,
FUNDING_SOURCE,
EXAM_LOCATION_CD,
DERIVED_COMPLETION_YR,
DERIVED_COMPLETION_PERD,
NOMINATED_COMPLETION_YR,
NOMINATED_COMPLETION_PERD,
RULE_CHECK_IND,
WAIVE_OPTION_CHECK_IND,
LAST_RULE_CHECK_DT,
PUBLISH_OUTCOMES_IND,
COURSE_RQRMNT_COMPLETE_IND,
COURSE_RQRMNTS_COMPLETE_DT,
S_COMPLETED_SOURCE_TYPE,
OVERRIDE_TIME_LIMITATION,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE,
LAST_DATE_OF_ATTENDANCE,
DROPPED_BY,
IGS_PR_CLASS_STD_ID,
PRIMARY_PROGRAM_TYPE,
PRIMARY_PROG_TYPE_SOURCE,
CATALOG_CAL_TYPE,
CATALOG_SEQ_NUM,
KEY_PROGRAM,
MANUAL_OVR_CMPL_DT_IND,
OVERRIDE_CMPL_DT,
ATTRIBUTE_CATEGORY,
FUTURE_DATED_TRANS_FLAG,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20
) VALUES (
NEW_REFERENCES.ORG_ID,
NEW_REFERENCES.ADVANCED_STANDING_IND,
NEW_REFERENCES.FEE_CAT,
NEW_REFERENCES.CORRESPONDENCE_CAT,
NEW_REFERENCES.SELF_HELP_GROUP_IND,
NEW_REFERENCES.LOGICAL_DELETE_DT,
NEW_REFERENCES.ADM_ADMISSION_APPL_NUMBER,
NEW_REFERENCES.ADM_NOMINATED_COURSE_CD,
NEW_REFERENCES.ADM_SEQUENCE_NUMBER,
NEW_REFERENCES.PERSON_ID,
NEW_REFERENCES.COURSE_CD,
NEW_REFERENCES.VERSION_NUMBER,
NEW_REFERENCES.CAL_TYPE,
NEW_REFERENCES.LOCATION_CD,
NEW_REFERENCES.ATTENDANCE_MODE,
NEW_REFERENCES.ATTENDANCE_TYPE,
NEW_REFERENCES.COO_ID,
NEW_REFERENCES.STUDENT_CONFIRMED_IND,
NEW_REFERENCES.COMMENCEMENT_DT,
NEW_REFERENCES.COURSE_ATTEMPT_STATUS,
NEW_REFERENCES.PROGRESSION_STATUS,
NEW_REFERENCES.DERIVED_ATT_TYPE,
NEW_REFERENCES.DERIVED_ATT_MODE,
NEW_REFERENCES.PROVISIONAL_IND,
NEW_REFERENCES.DISCONTINUED_DT,
NEW_REFERENCES.DISCONTINUATION_REASON_CD,
NEW_REFERENCES.LAPSED_DT,
NEW_REFERENCES.FUNDING_SOURCE,
NEW_REFERENCES.EXAM_LOCATION_CD,
NEW_REFERENCES.DERIVED_COMPLETION_YR,
NEW_REFERENCES.DERIVED_COMPLETION_PERD,
NEW_REFERENCES.NOMINATED_COMPLETION_YR,
NEW_REFERENCES.NOMINATED_COMPLETION_PERD,
NEW_REFERENCES.RULE_CHECK_IND,
NEW_REFERENCES.WAIVE_OPTION_CHECK_IND,
NEW_REFERENCES.LAST_RULE_CHECK_DT,
NEW_REFERENCES.PUBLISH_OUTCOMES_IND,
NEW_REFERENCES.COURSE_RQRMNT_COMPLETE_IND,
NEW_REFERENCES.COURSE_RQRMNTS_COMPLETE_DT,
NEW_REFERENCES.S_COMPLETED_SOURCE_TYPE,
NEW_REFERENCES.OVERRIDE_TIME_LIMITATION,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
X_REQUEST_ID,
X_PROGRAM_ID,
X_PROGRAM_APPLICATION_ID,
X_PROGRAM_UPDATE_DATE,
NEW_REFERENCES.LAST_DATE_OF_ATTENDANCE,
NEW_REFERENCES.DROPPED_BY,
NEW_REFERENCES.IGS_PR_CLASS_STD_ID,
NEW_REFERENCES.PRIMARY_PROGRAM_TYPE,
NEW_REFERENCES.PRIMARY_PROG_TYPE_SOURCE,
NEW_REFERENCES.CATALOG_CAL_TYPE,
NEW_REFERENCES.CATALOG_SEQ_NUM,
NEW_REFERENCES.KEY_PROGRAM,
NEW_REFERENCES.MANUAL_OVR_CMPL_DT_IND,
NEW_REFERENCES.OVERRIDE_CMPL_DT,
NEW_REFERENCES.ATTRIBUTE_CATEGORY,
NEW_REFERENCES.FUTURE_DATED_TRANS_FLAG,
NEW_REFERENCES.ATTRIBUTE1,
NEW_REFERENCES.ATTRIBUTE2,
NEW_REFERENCES.ATTRIBUTE3,
NEW_REFERENCES.ATTRIBUTE4,
NEW_REFERENCES.ATTRIBUTE5,
NEW_REFERENCES.ATTRIBUTE6,
NEW_REFERENCES.ATTRIBUTE7,
NEW_REFERENCES.ATTRIBUTE8,
NEW_REFERENCES.ATTRIBUTE9,
NEW_REFERENCES.ATTRIBUTE10,
NEW_REFERENCES.ATTRIBUTE11,
NEW_REFERENCES.ATTRIBUTE12,
NEW_REFERENCES.ATTRIBUTE13,
NEW_REFERENCES.ATTRIBUTE14,
NEW_REFERENCES.ATTRIBUTE15,
NEW_REFERENCES.ATTRIBUTE16,
NEW_REFERENCES.ATTRIBUTE17,
NEW_REFERENCES.ATTRIBUTE18,
NEW_REFERENCES.ATTRIBUTE19,
NEW_REFERENCES.ATTRIBUTE20
);
p_action => 'INSERT',
x_rowid => X_ROWID
);
END INSERT_ROW;
X_LOGICAL_DELETE_DT IN DATE,
X_ADM_ADMISSION_APPL_NUMBER IN NUMBER,
X_ADM_NOMINATED_COURSE_CD IN VARCHAR2,
X_ADM_SEQUENCE_NUMBER IN NUMBER,
X_VERSION_NUMBER IN NUMBER,
X_CAL_TYPE IN VARCHAR2,
X_LOCATION_CD IN VARCHAR2,
X_ATTENDANCE_MODE IN VARCHAR2,
X_ATTENDANCE_TYPE IN VARCHAR2,
X_COO_ID IN NUMBER,
X_STUDENT_CONFIRMED_IND IN VARCHAR2,
X_COMMENCEMENT_DT IN DATE,
X_COURSE_ATTEMPT_STATUS IN VARCHAR2,
X_PROGRESSION_STATUS IN VARCHAR2,
X_DERIVED_ATT_TYPE IN VARCHAR2,
X_DERIVED_ATT_MODE IN VARCHAR2,
X_PROVISIONAL_IND IN VARCHAR2,
X_DISCONTINUED_DT IN DATE,
X_DISCONTINUATION_REASON_CD IN VARCHAR2,
X_LAPSED_DT IN DATE,
X_FUNDING_SOURCE IN VARCHAR2,
X_EXAM_LOCATION_CD IN VARCHAR2,
X_DERIVED_COMPLETION_YR IN NUMBER,
X_DERIVED_COMPLETION_PERD IN VARCHAR2,
X_NOMINATED_COMPLETION_YR IN NUMBER,
X_NOMINATED_COMPLETION_PERD IN VARCHAR2,
X_RULE_CHECK_IND IN VARCHAR2,
X_WAIVE_OPTION_CHECK_IND IN VARCHAR2,
X_LAST_RULE_CHECK_DT IN DATE,
X_PUBLISH_OUTCOMES_IND IN VARCHAR2,
X_COURSE_RQRMNT_COMPLETE_IND IN VARCHAR2,
X_COURSE_RQRMNTS_COMPLETE_DT IN DATE,
X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
X_OVERRIDE_TIME_LIMITATION IN NUMBER,
X_LAST_DATE_OF_ATTENDANCE IN DATE,
X_DROPPED_BY IN VARCHAR2,
X_IGS_PR_CLASS_STD_ID IN NUMBER,
X_PRIMARY_PROGRAM_TYPE IN VARCHAR2,
X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2,
X_CATALOG_CAL_TYPE IN VARCHAR2,
X_CATALOG_SEQ_NUM IN NUMBER ,
X_KEY_PROGRAM IN VARCHAR2,
X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2,
X_OVERRIDE_CMPL_DT IN DATE,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
x_ATTRIBUTE20 IN VARCHAR2,
X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2
) AS
CURSOR c1 IS SELECT
org_id,
ADVANCED_STANDING_IND,
FEE_CAT,
CORRESPONDENCE_CAT,
SELF_HELP_GROUP_IND,
LOGICAL_DELETE_DT,
ADM_ADMISSION_APPL_NUMBER,
ADM_NOMINATED_COURSE_CD,
ADM_SEQUENCE_NUMBER,
VERSION_NUMBER,
CAL_TYPE,
LOCATION_CD,
ATTENDANCE_MODE,
ATTENDANCE_TYPE,
COO_ID,
STUDENT_CONFIRMED_IND,
COMMENCEMENT_DT,
COURSE_ATTEMPT_STATUS,
PROGRESSION_STATUS,
DERIVED_ATT_TYPE,
DERIVED_ATT_MODE,
PROVISIONAL_IND,
DISCONTINUED_DT,
DISCONTINUATION_REASON_CD,
LAPSED_DT,
FUNDING_SOURCE,
EXAM_LOCATION_CD,
DERIVED_COMPLETION_YR,
DERIVED_COMPLETION_PERD,
NOMINATED_COMPLETION_YR,
NOMINATED_COMPLETION_PERD,
RULE_CHECK_IND,
WAIVE_OPTION_CHECK_IND,
LAST_RULE_CHECK_DT,
PUBLISH_OUTCOMES_IND,
COURSE_RQRMNT_COMPLETE_IND,
COURSE_RQRMNTS_COMPLETE_DT,
S_COMPLETED_SOURCE_TYPE,
OVERRIDE_TIME_LIMITATION,
LAST_DATE_OF_ATTENDANCE,
DROPPED_BY,
IGS_PR_CLASS_STD_ID,
PRIMARY_PROGRAM_TYPE,
PRIMARY_PROG_TYPE_SOURCE,
CATALOG_CAL_TYPE,
CATALOG_SEQ_NUM,
KEY_PROGRAM,
MANUAL_OVR_CMPL_DT_IND,
OVERRIDE_CMPL_DT,
ATTRIBUTE_CATEGORY,
FUTURE_DATED_TRANS_FLAG,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE ROWID = X_ROWID FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
AND ((TRUNC(tlinfo.LOGICAL_DELETE_DT) = TRUNC(X_LOGICAL_DELETE_DT))
OR ((tlinfo.LOGICAL_DELETE_DT IS NULL)
AND (X_LOGICAL_DELETE_DT IS NULL)))
AND ((tlinfo.ADM_ADMISSION_APPL_NUMBER = X_ADM_ADMISSION_APPL_NUMBER)
OR ((tlinfo.ADM_ADMISSION_APPL_NUMBER IS NULL)
AND (X_ADM_ADMISSION_APPL_NUMBER IS NULL)))
AND ((tlinfo.ADM_NOMINATED_COURSE_CD = X_ADM_NOMINATED_COURSE_CD)
OR ((tlinfo.ADM_NOMINATED_COURSE_CD IS NULL)
AND (X_ADM_NOMINATED_COURSE_CD IS NULL)))
AND ((tlinfo.ADM_SEQUENCE_NUMBER = X_ADM_SEQUENCE_NUMBER)
OR ((tlinfo.ADM_SEQUENCE_NUMBER IS NULL)
AND (X_ADM_SEQUENCE_NUMBER IS NULL)))
AND (tlinfo.VERSION_NUMBER = X_VERSION_NUMBER)
AND (tlinfo.CAL_TYPE = X_CAL_TYPE)
AND (tlinfo.LOCATION_CD = X_LOCATION_CD)
AND (tlinfo.ATTENDANCE_MODE = X_ATTENDANCE_MODE)
AND (tlinfo.ATTENDANCE_TYPE = X_ATTENDANCE_TYPE)
AND (tlinfo.COO_ID = X_COO_ID)
AND (tlinfo.STUDENT_CONFIRMED_IND = X_STUDENT_CONFIRMED_IND)
AND ((TRUNC(tlinfo.COMMENCEMENT_DT) = TRUNC(X_COMMENCEMENT_DT))
OR ((tlinfo.COMMENCEMENT_DT IS NULL)
AND (X_COMMENCEMENT_DT IS NULL)))
AND ((tlinfo.COURSE_ATTEMPT_STATUS = X_COURSE_ATTEMPT_STATUS)
OR ((tlinfo.COURSE_ATTEMPT_STATUS IS NULL)
AND (X_COURSE_ATTEMPT_STATUS IS NULL)))
AND ((tlinfo.PROGRESSION_STATUS = X_PROGRESSION_STATUS)
OR ((tlinfo.PROGRESSION_STATUS IS NULL)
AND (X_PROGRESSION_STATUS IS NULL)))
AND ((tlinfo.DERIVED_ATT_TYPE = X_DERIVED_ATT_TYPE)
OR ((tlinfo.DERIVED_ATT_TYPE IS NULL)
AND (X_DERIVED_ATT_TYPE IS NULL)))
AND ((tlinfo.DERIVED_ATT_MODE = X_DERIVED_ATT_MODE)
OR ((tlinfo.DERIVED_ATT_MODE IS NULL)
AND (X_DERIVED_ATT_MODE IS NULL)))
AND (tlinfo.PROVISIONAL_IND = X_PROVISIONAL_IND)
AND ((TRUNC(tlinfo.DISCONTINUED_DT) = TRUNC(X_DISCONTINUED_DT))
OR ((tlinfo.DISCONTINUED_DT IS NULL)
AND (X_DISCONTINUED_DT IS NULL)))
AND ((tlinfo.DISCONTINUATION_REASON_CD = X_DISCONTINUATION_REASON_CD)
OR ((tlinfo.DISCONTINUATION_REASON_CD IS NULL)
AND (X_DISCONTINUATION_REASON_CD IS NULL)))
AND ((TRUNC(tlinfo.LAPSED_DT) = TRUNC(X_LAPSED_DT))
OR ((tlinfo.LAPSED_DT IS NULL)
AND (X_LAPSED_DT IS NULL)))
AND ((tlinfo.FUNDING_SOURCE = X_FUNDING_SOURCE)
OR ((tlinfo.FUNDING_SOURCE IS NULL)
AND (X_FUNDING_SOURCE IS NULL)))
AND ((tlinfo.EXAM_LOCATION_CD = X_EXAM_LOCATION_CD)
OR ((tlinfo.EXAM_LOCATION_CD IS NULL)
AND (X_EXAM_LOCATION_CD IS NULL)))
AND ((tlinfo.DERIVED_COMPLETION_YR = X_DERIVED_COMPLETION_YR)
OR ((tlinfo.DERIVED_COMPLETION_YR IS NULL)
AND (X_DERIVED_COMPLETION_YR IS NULL)))
AND ((tlinfo.DERIVED_COMPLETION_PERD = X_DERIVED_COMPLETION_PERD)
OR ((tlinfo.DERIVED_COMPLETION_PERD IS NULL)
AND (X_DERIVED_COMPLETION_PERD IS NULL)))
AND ((tlinfo.NOMINATED_COMPLETION_YR = X_NOMINATED_COMPLETION_YR)
OR ((tlinfo.NOMINATED_COMPLETION_YR IS NULL)
AND (X_NOMINATED_COMPLETION_YR IS NULL)))
AND ((tlinfo.NOMINATED_COMPLETION_PERD = X_NOMINATED_COMPLETION_PERD)
OR ((tlinfo.NOMINATED_COMPLETION_PERD IS NULL)
AND (X_NOMINATED_COMPLETION_PERD IS NULL)))
AND (tlinfo.RULE_CHECK_IND = X_RULE_CHECK_IND)
AND (tlinfo.WAIVE_OPTION_CHECK_IND = X_WAIVE_OPTION_CHECK_IND)
AND ((TRUNC(tlinfo.LAST_RULE_CHECK_DT) = TRUNC(X_LAST_RULE_CHECK_DT))
OR ((tlinfo.LAST_RULE_CHECK_DT IS NULL)
AND (X_LAST_RULE_CHECK_DT IS NULL)))
AND (tlinfo.PUBLISH_OUTCOMES_IND = X_PUBLISH_OUTCOMES_IND)
AND (tlinfo.COURSE_RQRMNT_COMPLETE_IND = X_COURSE_RQRMNT_COMPLETE_IND)
AND ((TRUNC(tlinfo.COURSE_RQRMNTS_COMPLETE_DT) = TRUNC(X_COURSE_RQRMNTS_COMPLETE_DT))
OR ((tlinfo.COURSE_RQRMNTS_COMPLETE_DT IS NULL)
AND (X_COURSE_RQRMNTS_COMPLETE_DT IS NULL)))
AND ((tlinfo.S_COMPLETED_SOURCE_TYPE = X_S_COMPLETED_SOURCE_TYPE)
OR ((tlinfo.S_COMPLETED_SOURCE_TYPE IS NULL)
AND (X_S_COMPLETED_SOURCE_TYPE IS NULL)))
AND ((tlinfo.OVERRIDE_TIME_LIMITATION = X_OVERRIDE_TIME_LIMITATION)
OR ((tlinfo.OVERRIDE_TIME_LIMITATION IS NULL)
AND (X_OVERRIDE_TIME_LIMITATION IS NULL)))
AND ((TRUNC(tlinfo.LAST_DATE_OF_ATTENDANCE) = TRUNC(X_LAST_DATE_OF_ATTENDANCE))
OR ((tlinfo.LAST_DATE_OF_ATTENDANCE IS NULL)
AND (X_LAST_DATE_OF_ATTENDANCE IS NULL)))
AND ((tlinfo.DROPPED_BY = X_DROPPED_BY)
OR ((tlinfo.DROPPED_BY IS NULL)
AND (X_DROPPED_BY IS NULL)))
AND ((tlinfo.IGS_PR_CLASS_STD_ID = X_IGS_PR_CLASS_STD_ID)
OR ((tlinfo.IGS_PR_CLASS_STD_ID IS NULL)
AND (X_IGS_PR_CLASS_STD_ID IS NULL)))
AND ((tlinfo.PRIMARY_PROGRAM_TYPE = X_PRIMARY_PROGRAM_TYPE)
OR ((tlinfo.PRIMARY_PROGRAM_TYPE IS NULL)
AND (X_PRIMARY_PROGRAM_TYPE IS NULL)))
AND ((tlinfo.PRIMARY_PROG_TYPE_SOURCE = X_PRIMARY_PROG_TYPE_SOURCE)
OR ((tlinfo.PRIMARY_PROG_TYPE_SOURCE IS NULL)
AND (X_PRIMARY_PROG_TYPE_SOURCE IS NULL)))
AND ((tlinfo.CATALOG_CAL_TYPE = X_CATALOG_CAL_TYPE)
OR ((tlinfo.CATALOG_CAL_TYPE IS NULL)
AND (X_CATALOG_CAL_TYPE IS NULL)))
AND ((tlinfo.CATALOG_SEQ_NUM = X_CATALOG_SEQ_NUM)
OR ((tlinfo.CATALOG_SEQ_NUM IS NULL)
AND (X_CATALOG_SEQ_NUM IS NULL)))
AND ((tlinfo.KEY_PROGRAM = X_KEY_PROGRAM)
OR ((tlinfo.KEY_PROGRAM IS NULL)
AND (X_KEY_PROGRAM IS NULL)))
AND ((tlinfo.MANUAL_OVR_CMPL_DT_IND = X_MANUAL_OVR_CMPL_DT_IND)
OR ((tlinfo.MANUAL_OVR_CMPL_DT_IND IS NULL)
AND (X_MANUAL_OVR_CMPL_DT_IND IS NULL)))
AND ((TRUNC(tlinfo.OVERRIDE_CMPL_DT) = TRUNC(X_OVERRIDE_CMPL_DT))
OR ((tlinfo.OVERRIDE_CMPL_DT IS NULL)
AND (X_OVERRIDE_CMPL_DT IS NULL)))
AND ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
OR ((tlinfo.ATTRIBUTE_CATEGORY IS NULL)
AND (X_ATTRIBUTE_CATEGORY IS NULL)))
AND ((tlinfo.FUTURE_DATED_TRANS_FLAG = X_FUTURE_DATED_TRANS_FLAG)
OR ((tlinfo.FUTURE_DATED_TRANS_FLAG IS NULL)
AND (X_FUTURE_DATED_TRANS_FLAG IS NULL)))
AND ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
OR ((tlinfo.ATTRIBUTE1 IS NULL)
AND (X_ATTRIBUTE1 IS NULL)))
AND ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
OR ((tlinfo.ATTRIBUTE2 IS NULL)
AND (X_ATTRIBUTE2 IS NULL)))
AND ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
OR ((tlinfo.ATTRIBUTE3 IS NULL)
AND (X_ATTRIBUTE3 IS NULL)))
AND ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
OR ((tlinfo.ATTRIBUTE4 IS NULL)
AND (X_ATTRIBUTE4 IS NULL)))
AND ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
OR ((tlinfo.ATTRIBUTE5 IS NULL)
AND (X_ATTRIBUTE5 IS NULL)))
AND ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
OR ((tlinfo.ATTRIBUTE6 IS NULL)
AND (X_ATTRIBUTE6 IS NULL)))
AND ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
OR ((tlinfo.ATTRIBUTE7 IS NULL)
AND (X_ATTRIBUTE7 IS NULL)))
AND ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
OR ((tlinfo.ATTRIBUTE8 IS NULL)
AND (X_ATTRIBUTE8 IS NULL)))
AND ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
OR ((tlinfo.ATTRIBUTE9 IS NULL)
AND (X_ATTRIBUTE9 IS NULL)))
AND ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
OR ((tlinfo.ATTRIBUTE10 IS NULL)
AND (X_ATTRIBUTE10 IS NULL)))
AND ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
OR ((tlinfo.ATTRIBUTE11 IS NULL)
AND (X_ATTRIBUTE11 IS NULL)))
AND ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
OR ((tlinfo.ATTRIBUTE12 IS NULL)
AND (X_ATTRIBUTE12 IS NULL)))
AND ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
OR ((tlinfo.ATTRIBUTE13 IS NULL)
AND (X_ATTRIBUTE13 IS NULL)))
AND ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
OR ((tlinfo.ATTRIBUTE14 IS NULL)
AND (X_ATTRIBUTE14 IS NULL)))
AND ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
OR ((tlinfo.ATTRIBUTE15 IS NULL)
AND (X_ATTRIBUTE15 IS NULL)))
AND ((tlinfo.ATTRIBUTE16 = X_ATTRIBUTE16)
OR ((tlinfo.ATTRIBUTE16 IS NULL)
AND (X_ATTRIBUTE16 IS NULL)))
AND ((tlinfo.ATTRIBUTE17 = X_ATTRIBUTE17)
OR ((tlinfo.ATTRIBUTE17 IS NULL)
AND (X_ATTRIBUTE17 IS NULL)))
AND ((tlinfo.ATTRIBUTE18 = X_ATTRIBUTE18)
OR ((tlinfo.ATTRIBUTE18 IS NULL)
AND (X_ATTRIBUTE18 IS NULL)))
AND ((tlinfo.ATTRIBUTE19 = X_ATTRIBUTE19)
OR ((tlinfo.ATTRIBUTE19 IS NULL)
AND (X_ATTRIBUTE19 IS NULL)))
AND ((tlinfo.ATTRIBUTE20 = X_ATTRIBUTE20)
OR ((tlinfo.ATTRIBUTE20 IS NULL)
AND (X_ATTRIBUTE20 IS NULL)))
) THEN
NULL;
PROCEDURE UPDATE_ROW (
X_ROWID IN VARCHAR2,
X_PERSON_ID IN NUMBER,
X_COURSE_CD IN VARCHAR2,
X_ADVANCED_STANDING_IND IN VARCHAR2,
X_FEE_CAT IN VARCHAR2,
X_CORRESPONDENCE_CAT IN VARCHAR2,
X_SELF_HELP_GROUP_IND IN VARCHAR2,
X_LOGICAL_DELETE_DT IN DATE,
X_ADM_ADMISSION_APPL_NUMBER IN NUMBER,
X_ADM_NOMINATED_COURSE_CD IN VARCHAR2,
X_ADM_SEQUENCE_NUMBER IN NUMBER,
X_VERSION_NUMBER IN NUMBER,
X_CAL_TYPE IN VARCHAR2,
X_LOCATION_CD IN VARCHAR2,
X_ATTENDANCE_MODE IN VARCHAR2,
X_ATTENDANCE_TYPE IN VARCHAR2,
X_COO_ID IN NUMBER,
X_STUDENT_CONFIRMED_IND IN VARCHAR2,
X_COMMENCEMENT_DT IN DATE,
X_COURSE_ATTEMPT_STATUS IN VARCHAR2,
X_PROGRESSION_STATUS IN VARCHAR2,
X_DERIVED_ATT_TYPE IN VARCHAR2,
X_DERIVED_ATT_MODE IN VARCHAR2,
X_PROVISIONAL_IND IN VARCHAR2,
X_DISCONTINUED_DT IN DATE,
X_DISCONTINUATION_REASON_CD IN VARCHAR2,
X_LAPSED_DT IN DATE,
X_FUNDING_SOURCE IN VARCHAR2,
X_EXAM_LOCATION_CD IN VARCHAR2,
X_DERIVED_COMPLETION_YR IN NUMBER,
X_DERIVED_COMPLETION_PERD IN VARCHAR2,
X_NOMINATED_COMPLETION_YR IN NUMBER,
X_NOMINATED_COMPLETION_PERD IN VARCHAR2,
X_RULE_CHECK_IND IN VARCHAR2,
X_WAIVE_OPTION_CHECK_IND IN VARCHAR2,
X_LAST_RULE_CHECK_DT IN DATE,
X_PUBLISH_OUTCOMES_IND IN VARCHAR2,
X_COURSE_RQRMNT_COMPLETE_IND IN VARCHAR2,
X_COURSE_RQRMNTS_COMPLETE_DT IN DATE,
X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
X_OVERRIDE_TIME_LIMITATION IN NUMBER,
X_MODE IN VARCHAR2,
X_LAST_DATE_OF_ATTENDANCE IN DATE,
X_DROPPED_BY IN VARCHAR2,
X_IGS_PR_CLASS_STD_ID IN NUMBER,
X_PRIMARY_PROGRAM_TYPE IN VARCHAR2,
X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2,
X_CATALOG_CAL_TYPE IN VARCHAR2,
X_CATALOG_SEQ_NUM IN NUMBER,
X_KEY_PROGRAM IN VARCHAR2,
X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2,
X_OVERRIDE_CMPL_DT IN DATE,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
x_ATTRIBUTE20 IN VARCHAR2,
X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2
) AS
X_LAST_UPDATE_DATE DATE;
X_LAST_UPDATED_BY NUMBER;
X_LAST_UPDATE_LOGIN NUMBER;
X_PROGRAM_UPDATE_DATE DATE;
X_LAST_UPDATE_DATE := SYSDATE;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
IF X_LAST_UPDATED_BY IS NULL THEN
X_LAST_UPDATED_BY := -1;
X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
IF X_LAST_UPDATE_LOGIN IS NULL THEN
X_LAST_UPDATE_LOGIN := -1;
p_action => 'UPDATE',
x_rowid => X_ROWID,
x_person_id => X_PERSON_ID,
x_course_cd => X_COURSE_CD,
x_advanced_standing_ind => X_ADVANCED_STANDING_IND,
x_fee_cat => X_FEE_CAT,
x_correspondence_cat => X_CORRESPONDENCE_CAT,
x_self_help_group_ind => X_SELF_HELP_GROUP_IND,
x_logical_delete_dt => X_LOGICAL_DELETE_DT,
x_adm_admission_appl_number => X_ADM_ADMISSION_APPL_NUMBER,
x_adm_nominated_course_cd => X_ADM_NOMINATED_COURSE_CD,
x_adm_sequence_number => X_ADM_SEQUENCE_NUMBER,
x_version_number => X_VERSION_NUMBER,
x_cal_type => X_CAL_TYPE,
x_location_cd => X_LOCATION_CD,
x_attendance_mode => X_ATTENDANCE_MODE,
x_attendance_type => X_ATTENDANCE_TYPE,
x_coo_id => X_COO_ID,
x_student_confirmed_ind => X_STUDENT_CONFIRMED_IND,
x_commencement_dt => X_COMMENCEMENT_DT,
x_course_attempt_status => X_COURSE_ATTEMPT_STATUS,
x_progression_status => NVL(X_PROGRESSION_STATUS,'GOODSTAND'),
x_derived_att_type => X_DERIVED_ATT_TYPE,
x_derived_att_mode => X_DERIVED_ATT_MODE,
x_provisional_ind => X_PROVISIONAL_IND,
x_discontinued_dt => X_DISCONTINUED_DT,
x_discontinuation_reason_cd => X_DISCONTINUATION_REASON_CD,
x_lapsed_dt => X_LAPSED_DT,
x_funding_source => X_FUNDING_SOURCE,
x_exam_location_cd => X_EXAM_LOCATION_CD,
x_derived_completion_yr => X_DERIVED_COMPLETION_YR,
x_derived_completion_perd => X_DERIVED_COMPLETION_PERD,
x_nominated_completion_yr => X_NOMINATED_COMPLETION_YR,
x_nominated_completion_perd => X_NOMINATED_COMPLETION_PERD,
x_rule_check_ind => X_RULE_CHECK_IND,
x_waive_option_check_ind => X_WAIVE_OPTION_CHECK_IND,
x_last_rule_check_dt => X_LAST_RULE_CHECK_DT,
x_publish_outcomes_ind => X_PUBLISH_OUTCOMES_IND,
x_course_rqrmnt_complete_ind => X_COURSE_RQRMNT_COMPLETE_IND,
x_course_rqrmnts_complete_dt => X_COURSE_RQRMNTS_COMPLETE_DT,
x_s_completed_source_type => X_S_COMPLETED_SOURCE_TYPE,
x_override_time_limitation => X_OVERRIDE_TIME_LIMITATION,
x_creation_date => X_LAST_UPDATE_DATE,
x_created_by => X_LAST_UPDATED_BY,
x_last_update_date => X_LAST_UPDATE_DATE,
x_last_updated_by => X_LAST_UPDATED_BY,
x_last_update_login => X_LAST_UPDATE_LOGIN ,
x_last_date_of_attendance =>X_LAST_DATE_OF_ATTENDANCE,
x_dropped_by => X_DROPPED_BY,
X_IGS_PR_CLASS_STD_ID => X_IGS_PR_CLASS_STD_ID,
x_primary_program_type => X_PRIMARY_PROGRAM_TYPE,
x_primary_prog_type_source => X_PRIMARY_PROG_TYPE_SOURCE,
x_catalog_cal_type => X_CATALOG_CAL_TYPE,
x_catalog_seq_num => X_CATALOG_SEQ_NUM ,
x_key_program => X_KEY_PROGRAM,
x_manual_ovr_cmpl_dt_ind => X_MANUAL_OVR_CMPL_DT_IND,
x_override_cmpl_dt => X_OVERRIDE_CMPL_DT,
x_attribute_category=>X_ATTRIBUTE_CATEGORY,
x_future_dated_trans_flag => NVL(X_FUTURE_DATED_TRANS_FLAG,'N'),
x_attribute1=>X_ATTRIBUTE1,
x_attribute2=>X_ATTRIBUTE2,
x_attribute3=>X_ATTRIBUTE3,
x_attribute4=>X_ATTRIBUTE4,
x_attribute5=>X_ATTRIBUTE5,
x_attribute6=>X_ATTRIBUTE6,
x_attribute7=>X_ATTRIBUTE7,
x_attribute8=>X_ATTRIBUTE8,
x_attribute9=>X_ATTRIBUTE9,
x_attribute10=>X_ATTRIBUTE10,
x_attribute11=>X_ATTRIBUTE11,
x_attribute12=>X_ATTRIBUTE12,
x_attribute13=>X_ATTRIBUTE13,
x_attribute14=>X_ATTRIBUTE14,
x_attribute15=>X_ATTRIBUTE15,
x_attribute16=>X_ATTRIBUTE16,
x_attribute17=>X_ATTRIBUTE17,
x_attribute18=>X_ATTRIBUTE18,
x_attribute19=>X_ATTRIBUTE19,
x_attribute20=>X_ATTRIBUTE20
);
X_PROGRAM_UPDATE_DATE := SYSDATE;
UPDATE IGS_EN_STDNT_PS_ATT_ALL SET
ADVANCED_STANDING_IND = NEW_REFERENCES.ADVANCED_STANDING_IND,
FEE_CAT = NEW_REFERENCES.FEE_CAT,
CORRESPONDENCE_CAT = NEW_REFERENCES.CORRESPONDENCE_CAT,
SELF_HELP_GROUP_IND = NEW_REFERENCES.SELF_HELP_GROUP_IND,
LOGICAL_DELETE_DT = NEW_REFERENCES.LOGICAL_DELETE_DT,
ADM_ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADM_ADMISSION_APPL_NUMBER,
ADM_NOMINATED_COURSE_CD = NEW_REFERENCES.ADM_NOMINATED_COURSE_CD,
ADM_SEQUENCE_NUMBER = NEW_REFERENCES.ADM_SEQUENCE_NUMBER,
VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
COO_ID = NEW_REFERENCES.COO_ID,
STUDENT_CONFIRMED_IND = NEW_REFERENCES.STUDENT_CONFIRMED_IND,
COMMENCEMENT_DT = NEW_REFERENCES.COMMENCEMENT_DT,
COURSE_ATTEMPT_STATUS = NEW_REFERENCES.COURSE_ATTEMPT_STATUS,
PROGRESSION_STATUS = NEW_REFERENCES.PROGRESSION_STATUS,
DERIVED_ATT_TYPE = NEW_REFERENCES.DERIVED_ATT_TYPE,
DERIVED_ATT_MODE = NEW_REFERENCES.DERIVED_ATT_MODE,
PROVISIONAL_IND = NEW_REFERENCES.PROVISIONAL_IND,
DISCONTINUED_DT = NEW_REFERENCES.DISCONTINUED_DT,
DISCONTINUATION_REASON_CD = NEW_REFERENCES.DISCONTINUATION_REASON_CD,
LAPSED_DT = NEW_REFERENCES.LAPSED_DT,
FUNDING_SOURCE = NEW_REFERENCES.FUNDING_SOURCE,
EXAM_LOCATION_CD = NEW_REFERENCES.EXAM_LOCATION_CD,
DERIVED_COMPLETION_YR = NEW_REFERENCES.DERIVED_COMPLETION_YR,
DERIVED_COMPLETION_PERD = NEW_REFERENCES.DERIVED_COMPLETION_PERD,
NOMINATED_COMPLETION_YR = NEW_REFERENCES.NOMINATED_COMPLETION_YR,
NOMINATED_COMPLETION_PERD = NEW_REFERENCES.NOMINATED_COMPLETION_PERD,
RULE_CHECK_IND = NEW_REFERENCES.RULE_CHECK_IND,
WAIVE_OPTION_CHECK_IND = NEW_REFERENCES.WAIVE_OPTION_CHECK_IND,
LAST_RULE_CHECK_DT = NEW_REFERENCES.LAST_RULE_CHECK_DT,
PUBLISH_OUTCOMES_IND = NEW_REFERENCES.PUBLISH_OUTCOMES_IND,
COURSE_RQRMNT_COMPLETE_IND = NEW_REFERENCES.COURSE_RQRMNT_COMPLETE_IND,
COURSE_RQRMNTS_COMPLETE_DT = NEW_REFERENCES.COURSE_RQRMNTS_COMPLETE_DT,
S_COMPLETED_SOURCE_TYPE = NEW_REFERENCES.S_COMPLETED_SOURCE_TYPE,
OVERRIDE_TIME_LIMITATION = NEW_REFERENCES.OVERRIDE_TIME_LIMITATION,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
REQUEST_ID = X_REQUEST_ID,
PROGRAM_ID = X_PROGRAM_ID,
PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
LAST_DATE_OF_ATTENDANCE = NEW_REFERENCES.LAST_DATE_OF_ATTENDANCE,
DROPPED_BY = NEW_REFERENCES.DROPPED_BY,
IGS_PR_CLASS_STD_ID = NEW_REFERENCES.IGS_PR_CLASS_STD_ID,
PRIMARY_PROGRAM_TYPE = NEW_REFERENCES.PRIMARY_PROGRAM_TYPE,
PRIMARY_PROG_TYPE_SOURCE = NEW_REFERENCES.PRIMARY_PROG_TYPE_SOURCE,
CATALOG_CAL_TYPE = NEW_REFERENCES.CATALOG_CAL_TYPE,
CATALOG_SEQ_NUM = NEW_REFERENCES.CATALOG_SEQ_NUM,
KEY_PROGRAM = NEW_REFERENCES.KEY_PROGRAM,
MANUAL_OVR_CMPL_DT_IND = NEW_REFERENCES.MANUAL_OVR_CMPL_DT_IND,
OVERRIDE_CMPL_DT = NEW_REFERENCES.OVERRIDE_CMPL_DT,
ATTRIBUTE_CATEGORY = NEW_REFERENCES.ATTRIBUTE_CATEGORY,
FUTURE_DATED_TRANS_FLAG = NEW_REFERENCES.FUTURE_DATED_TRANS_FLAG,
ATTRIBUTE1 = NEW_REFERENCES.ATTRIBUTE1,
ATTRIBUTE2 = NEW_REFERENCES.ATTRIBUTE2,
ATTRIBUTE3 = NEW_REFERENCES.ATTRIBUTE3,
ATTRIBUTE4 = NEW_REFERENCES.ATTRIBUTE4,
ATTRIBUTE5 = NEW_REFERENCES.ATTRIBUTE5,
ATTRIBUTE6 = NEW_REFERENCES.ATTRIBUTE6,
ATTRIBUTE7 = NEW_REFERENCES.ATTRIBUTE7,
ATTRIBUTE8 = NEW_REFERENCES.ATTRIBUTE8,
ATTRIBUTE9 = NEW_REFERENCES.ATTRIBUTE9,
ATTRIBUTE10 = NEW_REFERENCES.ATTRIBUTE10,
ATTRIBUTE11 = NEW_REFERENCES.ATTRIBUTE11,
ATTRIBUTE12 = NEW_REFERENCES.ATTRIBUTE12,
ATTRIBUTE13 = NEW_REFERENCES.ATTRIBUTE13,
ATTRIBUTE14 = NEW_REFERENCES.ATTRIBUTE14,
ATTRIBUTE15 = NEW_REFERENCES.ATTRIBUTE15,
ATTRIBUTE16 = NEW_REFERENCES.ATTRIBUTE16,
ATTRIBUTE17 = NEW_REFERENCES.ATTRIBUTE17,
ATTRIBUTE18 = NEW_REFERENCES.ATTRIBUTE18,
ATTRIBUTE19 = NEW_REFERENCES.ATTRIBUTE19,
ATTRIBUTE20 = NEW_REFERENCES.ATTRIBUTE20
WHERE ROWID = X_ROWID;
p_action => 'UPDATE',
x_rowid => X_ROWID
);
END UPDATE_ROW;
X_LOGICAL_DELETE_DT IN DATE,
X_ADM_ADMISSION_APPL_NUMBER IN NUMBER,
X_ADM_NOMINATED_COURSE_CD IN VARCHAR2,
X_ADM_SEQUENCE_NUMBER IN NUMBER,
X_VERSION_NUMBER IN NUMBER,
X_CAL_TYPE IN VARCHAR2,
X_LOCATION_CD IN VARCHAR2,
X_ATTENDANCE_MODE IN VARCHAR2,
X_ATTENDANCE_TYPE IN VARCHAR2,
X_COO_ID IN NUMBER,
X_STUDENT_CONFIRMED_IND IN VARCHAR2,
X_COMMENCEMENT_DT IN DATE,
X_COURSE_ATTEMPT_STATUS IN VARCHAR2,
X_PROGRESSION_STATUS IN VARCHAR2,
X_DERIVED_ATT_TYPE IN VARCHAR2,
X_DERIVED_ATT_MODE IN VARCHAR2,
X_PROVISIONAL_IND IN VARCHAR2,
X_DISCONTINUED_DT IN DATE,
X_DISCONTINUATION_REASON_CD IN VARCHAR2,
X_LAPSED_DT IN DATE,
X_FUNDING_SOURCE IN VARCHAR2,
X_EXAM_LOCATION_CD IN VARCHAR2,
X_DERIVED_COMPLETION_YR IN NUMBER,
X_DERIVED_COMPLETION_PERD IN VARCHAR2,
X_NOMINATED_COMPLETION_YR IN NUMBER,
X_NOMINATED_COMPLETION_PERD IN VARCHAR2,
X_RULE_CHECK_IND IN VARCHAR2,
X_WAIVE_OPTION_CHECK_IND IN VARCHAR2,
X_LAST_RULE_CHECK_DT IN DATE,
X_PUBLISH_OUTCOMES_IND IN VARCHAR2,
X_COURSE_RQRMNT_COMPLETE_IND IN VARCHAR2,
X_COURSE_RQRMNTS_COMPLETE_DT IN DATE,
X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
X_OVERRIDE_TIME_LIMITATION IN NUMBER,
X_MODE IN VARCHAR2,
X_LAST_DATE_OF_ATTENDANCE IN DATE,
X_DROPPED_BY IN VARCHAR2,
X_IGS_PR_CLASS_STD_ID IN NUMBER,
X_PRIMARY_PROGRAM_TYPE IN VARCHAR2,
X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2,
X_CATALOG_CAL_TYPE IN VARCHAR2,
X_CATALOG_SEQ_NUM IN NUMBER ,
X_KEY_PROGRAM IN VARCHAR2,
X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2,
X_OVERRIDE_CMPL_DT IN DATE,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
x_ATTRIBUTE20 IN VARCHAR2,
X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2
) AS
CURSOR c1 IS SELECT ROWID FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE PERSON_ID = X_PERSON_ID
AND COURSE_CD = X_COURSE_CD;
INSERT_ROW (
X_ROWID,
x_org_id,
X_PERSON_ID,
X_COURSE_CD,
X_ADVANCED_STANDING_IND,
X_FEE_CAT,
X_CORRESPONDENCE_CAT,
X_SELF_HELP_GROUP_IND,
X_LOGICAL_DELETE_DT,
X_ADM_ADMISSION_APPL_NUMBER,
X_ADM_NOMINATED_COURSE_CD,
X_ADM_SEQUENCE_NUMBER,
X_VERSION_NUMBER,
X_CAL_TYPE,
X_LOCATION_CD,
X_ATTENDANCE_MODE,
X_ATTENDANCE_TYPE,
X_COO_ID,
X_STUDENT_CONFIRMED_IND,
X_COMMENCEMENT_DT,
X_COURSE_ATTEMPT_STATUS,
X_PROGRESSION_STATUS,
X_DERIVED_ATT_TYPE,
X_DERIVED_ATT_MODE,
X_PROVISIONAL_IND,
X_DISCONTINUED_DT,
X_DISCONTINUATION_REASON_CD,
X_LAPSED_DT,
X_FUNDING_SOURCE,
X_EXAM_LOCATION_CD,
X_DERIVED_COMPLETION_YR,
X_DERIVED_COMPLETION_PERD,
X_NOMINATED_COMPLETION_YR,
X_NOMINATED_COMPLETION_PERD,
X_RULE_CHECK_IND,
X_WAIVE_OPTION_CHECK_IND,
X_LAST_RULE_CHECK_DT,
X_PUBLISH_OUTCOMES_IND,
X_COURSE_RQRMNT_COMPLETE_IND,
X_COURSE_RQRMNTS_COMPLETE_DT,
X_S_COMPLETED_SOURCE_TYPE,
X_OVERRIDE_TIME_LIMITATION,
X_MODE,
X_LAST_DATE_OF_ATTENDANCE,
X_DROPPED_BY,
X_IGS_PR_CLASS_STD_ID,
X_PRIMARY_PROGRAM_TYPE,
X_PRIMARY_PROG_TYPE_SOURCE,
X_CATALOG_CAL_TYPE,
X_CATALOG_SEQ_NUM,
X_KEY_PROGRAM ,
X_MANUAL_OVR_CMPL_DT_IND,
X_OVERRIDE_CMPL_DT,
X_ATTRIBUTE_CATEGORY,
X_FUTURE_DATED_TRANS_FLAG,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_ATTRIBUTE16,
X_ATTRIBUTE17,
X_ATTRIBUTE18,
X_ATTRIBUTE19,
X_ATTRIBUTE20
);
UPDATE_ROW (
X_ROWID,
X_PERSON_ID,
X_COURSE_CD,
X_ADVANCED_STANDING_IND,
X_FEE_CAT,
X_CORRESPONDENCE_CAT,
X_SELF_HELP_GROUP_IND,
X_LOGICAL_DELETE_DT,
X_ADM_ADMISSION_APPL_NUMBER,
X_ADM_NOMINATED_COURSE_CD,
X_ADM_SEQUENCE_NUMBER,
X_VERSION_NUMBER,
X_CAL_TYPE,
X_LOCATION_CD,
X_ATTENDANCE_MODE,
X_ATTENDANCE_TYPE,
X_COO_ID,
X_STUDENT_CONFIRMED_IND,
X_COMMENCEMENT_DT,
X_COURSE_ATTEMPT_STATUS,
X_PROGRESSION_STATUS,
X_DERIVED_ATT_TYPE,
X_DERIVED_ATT_MODE,
X_PROVISIONAL_IND,
X_DISCONTINUED_DT,
X_DISCONTINUATION_REASON_CD,
X_LAPSED_DT,
X_FUNDING_SOURCE,
X_EXAM_LOCATION_CD,
X_DERIVED_COMPLETION_YR,
X_DERIVED_COMPLETION_PERD,
X_NOMINATED_COMPLETION_YR,
X_NOMINATED_COMPLETION_PERD,
X_RULE_CHECK_IND,
X_WAIVE_OPTION_CHECK_IND,
X_LAST_RULE_CHECK_DT,
X_PUBLISH_OUTCOMES_IND,
X_COURSE_RQRMNT_COMPLETE_IND,
X_COURSE_RQRMNTS_COMPLETE_DT,
X_S_COMPLETED_SOURCE_TYPE,
X_OVERRIDE_TIME_LIMITATION,
X_MODE,
X_LAST_DATE_OF_ATTENDANCE,
X_DROPPED_BY,
X_IGS_PR_CLASS_STD_ID,
X_PRIMARY_PROGRAM_TYPE,
X_PRIMARY_PROG_TYPE_SOURCE,
X_CATALOG_CAL_TYPE,
X_CATALOG_SEQ_NUM,
X_KEY_PROGRAM,
X_MANUAL_OVR_CMPL_DT_IND,
X_OVERRIDE_CMPL_DT,
X_ATTRIBUTE_CATEGORY,
X_FUTURE_DATED_TRANS_FLAG,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_ATTRIBUTE16,
X_ATTRIBUTE17,
X_ATTRIBUTE18,
X_ATTRIBUTE19,
X_ATTRIBUTE20
);
PROCEDURE DELETE_ROW (X_ROWID IN VARCHAR2,
x_mode IN VARCHAR2)
AS
BEGIN
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);
DELETE FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE ROWID = X_ROWID;
p_action => 'DELETE',
x_rowid => X_ROWID
);
END DELETE_ROW;
PROCEDURE beforerowdelete AS
------------------------------------------------------------------
--Created by : rnirwani
--Date created: 03-Jan-03
--
--Purpose: Validation to ensure that delation is not allowed
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
-------------------------------------------------------------------
CURSOR c_spa_stat (cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
SELECT course_attempt_status
FROM igs_en_stdnt_ps_att_all
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd;
END beforerowdelete;
SELECT ci.cal_type, ci.sequence_number
FROM igs_ca_inst ci,
igs_ca_inst_rel cir,
igs_ca_type ct,
igs_en_stdnt_ps_att sca,
igs_ca_stat cs
WHERE sca.person_id = cp_person_id AND
sca.course_cd = cp_program_cd AND
cir.sup_cal_type = sca.cal_type AND
ci.cal_type = cir.sub_cal_type AND
ci.sequence_number = cir.sub_ci_sequence_number AND
ct.cal_type = ci.cal_type AND
ct.s_cal_cat = 'LOAD' AND
cs.cal_status = ci.cal_status AND
cs.s_cal_status = 'ACTIVE' AND
igs_en_gen_015.get_effective_census_date(ci.cal_type,ci.sequence_number,NULL,NULL) > cp_prg_completion_dt
ORDER BY ci.start_dt;
l_create_update_term BOOLEAN;
l_create_update_term := FALSE;
IF (P_ACTION = 'UPDATE') THEN
IF (new_references.course_attempt_status = 'COMPLETED' AND new_references.primary_program_type = 'PRIMARY') THEN
OPEN cur_get_effective_term(new_references.person_id,
new_references.course_cd,
new_references.course_rqrmnts_complete_dt);
igs_en_spa_terms_api.create_update_term_rec(
p_person_id => new_references.person_id,
p_program_cd => new_references.course_cd,
p_term_cal_type => l_term_cal_type,
p_term_sequence_number => l_term_ci_seq_num,
p_ripple_frwrd => FALSE, -- ripple forward
p_message_name => l_message_name,
p_update_rec => TRUE);
igs_en_spa_terms_api.delete_terms_for_program(
p_person_id => new_references.person_id,
p_program_cd => new_references.course_cd);