The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE beforerowdelete AS
------------------------------------------------------------------
--Created by : sarakshi, Oracle India
--Date created: 16-Jun-2002
--
--Purpose: Only planned course status are allowed for deletion
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
-------------------------------------------------------------------
CURSOR cur_delete (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
cp_version_number igs_ps_ver_all.version_number%TYPE)
IS
SELECT 'x'
FROM igs_ps_ver_all uv,
igs_ps_stat us
WHERE uv.course_status=us.course_status
AND us.s_course_status='PLANNED'
AND uv.course_cd = cp_course_cd
AND uv.version_number = cp_version_number;
OPEN cur_delete (old_references.course_cd,old_references.version_number);
FETCH cur_delete INTO l_check;
IF cur_delete%NOTFOUND THEN
CLOSE cur_delete;
CLOSE cur_delete;
END beforerowdelete;
PROCEDURE beforerowupdate AS
------------------------------------------------------------------
--Created by : sarakshi, Oracle India
--Date created: 16-Jun-2002
--
--Purpose: Active/Inactive program Status can not be changed to Planned Status
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
-------------------------------------------------------------------
CURSOR cur_get_status (cp_course_status igs_ps_stat.course_status%TYPE)
IS
SELECT s_course_status
FROM igs_ps_stat
WHERE course_status = cp_course_status;
CURSOR cur_check_update (cp_course_cd igs_ps_ver_all.course_cd%TYPE,
cp_version_number igs_ps_ver_all.version_number%TYPE)
IS
SELECT 'x'
FROM igs_ps_ver_all uv,
igs_ps_stat us
WHERE uv.course_status=us.course_status
AND us.s_course_status <> 'PLANNED'
AND uv.course_cd = cp_course_cd
AND uv.version_number = cp_version_number;
OPEN cur_check_update(old_references.course_cd,old_references.version_number);
FETCH cur_check_update INTO l_check;
IF cur_check_update%FOUND THEN
CLOSE cur_check_update;
CLOSE cur_check_update;
fnd_message.set_name('FND','FORM_RECORD_DELETED');
END beforerowupdate;
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_org_id IN NUMBER ,
x_rev_account_cd IN VARCHAR2 ,
x_primary_program_rank IN NUMBER,
x_max_wlst_per_stud IN NUMBER,
x_annual_instruction_time IN NUMBER
) AS
/************************************************************************
Created By :
Date Created By :
Purpose :
Known limitations, enhancements or remarks:
Change History :
Who When What
vvutukur 18-Oct-2002 Enh#2608227.Removed references to obsoleted columns std_ft_completion_time,
std_pt_completion_time.Also removed DEFAULT keyword to avoid gscc File.Pkg.22 warning.
msrinivi 08-Aug-2001 Added new col rev_Account_cd bug # 1882122
smadathi 26-MAY-2001 Changed for new DLD Version
sbeerell 10-MAY-2000 Changed for new DLD version 2
(reverse chronological order - newest change first)
*************************************************************************/
CURSOR cur_old_ref_values IS
SELECT *
FROM igs_ps_ver_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');
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;
p_inserting IN BOOLEAN ,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
/************************************************************************
Created By :
Date Created By :
Purpose :
Known limitations, enhancements or remarks:
Change History :
Who When What
sbeerell 10-MAY-2000 Changed for new DLD version 2
(reverse chronological order - newest change first)
*************************************************************************/
v_message_name VARCHAR2(30);
SELECT s_course_status
FROM igs_ps_stat
WHERE course_status = cp_course_status;
IF p_inserting OR
(p_updating AND
((NVL(old_references.expiry_dt,
igs_ge_date.igsdate('1900/01/01')) <>
NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR
(old_references.course_status <> new_references.course_status))) THEN
IF igs_ps_val_crv.crsp_val_crv_exp_sts (
new_references.course_cd,
new_references.version_number,
new_references.expiry_dt,
new_references.course_status,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
(old_references.course_status <> new_references.course_status)) THEN
OPEN c_get_s_course_status (new_references.course_status);
PROCEDURE beforerowinsertupdatedelete1(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
/************************************************************************
Created By :
Date Created By :
Purpose :
Known limitations, enhancements or remarks:
Change History :
Who When What
vvutukur 18-Oct-2002 Enh#2608227.Removed references to std_ft_completion_time,std_pt_completion_time,
as these columns are obsolete.Also removed DEFAULT keyword to avoid gscc File.pkg.22 warning.
sbeerell 10-MAY-2000 Changed for new DLD version 2
ayedubat 25-MAY-2001 Changed for the DLD,PSP001-US.
(reverse chronological order - newest change first)
*************************************************************************/
v_message_name VARCHAR2(30);
SELECT s_course_status
FROM igs_ps_stat
WHERE course_status = new_references.course_status;
SELECT ROWID
FROM igs_ps_ver_hist
WHERE course_cd = old_references.course_cd AND
version_number = old_references.version_number;
IF p_inserting OR
(p_updating AND (old_references.course_status <> new_references.course_status)) THEN
IF igs_ps_val_crv.crsp_val_crv_status (
new_references.course_status,
old_references.course_status,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
p_inserting => p_inserting,
p_updating => p_updating,
p_deleting => p_deleting
);
IF p_inserting OR
(p_updating AND (old_references.course_type <> new_references.course_type)) THEN
IF igs_ps_val_crv.crsp_val_crv_type (
new_references.course_cd,
new_references.version_number,
new_references.course_type,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
(old_references.govt_special_course_type<> new_references.govt_special_course_type)) THEN
IF igs_ps_val_crv.crsp_val_crv_gsct (
new_references.govt_special_course_type,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND (old_references.start_dt <> new_references.start_dt)) OR
(p_updating AND
(NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01')))) OR
(p_updating AND
(NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
NVL(new_references.expiry_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
/* As part of bug# 1956374 changed the following call from igs_ps_val_crv.crsp_val_ver_dt*/
IF igs_ps_val_us.crsp_val_ver_dt (
new_references.start_dt,
new_references.end_dt,
new_references.expiry_dt,
v_message_name,FALSE) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
((old_references.responsible_org_unit_cd <> new_references.responsible_org_unit_cd) OR
(NVL(old_references.responsible_ou_start_dt,igs_ge_date.igsdate('1900/01/01')) <>
NVL(new_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01')))))THEN
IF igs_ps_val_crv.crsp_val_ou_sys_sts (
new_references.responsible_org_unit_cd,
new_references.responsible_ou_start_dt,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
((NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01'))) OR
(old_references.course_status <> new_references.course_status))) THEN
IF igs_ps_val_crv.crsp_val_crv_end_sts(
new_references.end_dt,
new_references.course_status,
v_message_name) = FALSE THEN
fnd_message.set_name('IGS',v_message_name);
SELECT decode(old_references.start_dt,new_references.start_dt,
NULL,old_references.start_dt),
decode(old_references.course_status,new_references.course_status,
NULL,old_references.course_status),
decode(old_references.title,new_references.title,
NULL,old_references.title),
decode(old_references.short_title,new_references.short_title,
NULL,old_references.short_title),
decode(old_references.abbreviation,new_references.abbreviation,NULL,
old_references.abbreviation),
decode(old_references.supp_exam_permitted_ind,new_references.supp_exam_permitted_ind,
NULL,old_references.supp_exam_permitted_ind),
decode(old_references.generic_course_ind,new_references.generic_course_ind,
NULL,old_references.generic_course_ind),
decode(old_references.graduate_students_ind,new_references.graduate_students_ind,
NULL,old_references.graduate_students_ind),
decode(old_references.count_intrmsn_in_time_ind,new_references.count_intrmsn_in_time_ind,
NULL,old_references.count_intrmsn_in_time_ind),
decode(old_references.intrmsn_allowed_ind,new_references.intrmsn_allowed_ind,
NULL,old_references.intrmsn_allowed_ind),
decode(old_references.course_type,new_references.course_type,
NULL,old_references.course_type),
decode(old_references.responsible_org_unit_cd,new_references.responsible_org_unit_cd,
NULL,old_references.responsible_org_unit_cd),
decode(old_references.govt_special_course_type,new_references.govt_special_course_type,
NULL,old_references.govt_special_course_type),
decode(NVL(old_references.qualification_recency,999999),
NVL(new_references.qualification_recency,999999),
NULL,old_references.qualification_recency),
decode(NVL(old_references.external_adv_stnd_limit,999999),
NVL(new_references.external_adv_stnd_limit,999999),
NULL,old_references.external_adv_stnd_limit),
decode(NVL(old_references.internal_adv_stnd_limit,999999),
NVL(new_references.internal_adv_stnd_limit,999999),
NULL,old_references.internal_adv_stnd_limit),
decode(NVL(old_references.contact_hours,999999),NVL(new_references.contact_hours,999999),
NULL,old_references.contact_hours),
decode(NVL(old_references.credit_points_required,999999),
NVL(new_references.credit_points_required,999999),
NULL,old_references.credit_points_required),
decode(NVL(old_references.govt_course_load,999999),
NVL(new_references.govt_course_load,999999),
NULL,old_references.govt_course_load),
decode(NVL(old_references.std_annual_load,999999),NVL(new_references.std_annual_load,999999),
NULL,old_references.std_annual_load),
decode(NVL(old_references.course_total_eftsu,999999),
NVL(new_references.course_total_eftsu,999999),
NULL,old_references.course_total_eftsu),
decode(NVL(old_references.max_intrmsn_duration,999999),
NVL(new_references.max_intrmsn_duration,999999),
NULL,old_references.max_intrmsn_duration),
decode(NVL(old_references.num_of_units_before_intrmsn,999999),
NVL(new_references.num_of_units_before_intrmsn,999999),
NULL,old_references.num_of_units_before_intrmsn),
decode(NVL(old_references.min_sbmsn_percentage,999999),
NVL(new_references.min_sbmsn_percentage,999999),
NULL,old_references.min_sbmsn_percentage),
decode(NVL(old_references.min_cp_per_calendar,999999),
NVL(new_references.min_cp_per_calendar,999999),
NULL,old_references.min_cp_per_calendar),
decode(old_references.approval_date,new_references.approval_date,
NULL,old_references.approval_date),
decode(old_references.external_approval_date,new_references.external_approval_date,
NULL,old_references.external_approval_date),
decode(old_references.federal_financial_aid,new_references.federal_financial_aid,
NULL,old_references.federal_financial_aid),
decode(old_references.institutional_financial_aid,new_references.institutional_financial_aid,
NULL,old_references.institutional_financial_aid),
decode(NVL(old_references.max_cp_per_teaching_period,999999),
NVL(new_references.max_cp_per_teaching_period,999999),
NULL,old_references.max_cp_per_teaching_period),
decode(NVL(old_references.residency_cp_required,999999),
NVL(new_references.residency_cp_required,999999),
NULL,old_references.residency_cp_required),
decode(old_references.state_financial_aid,new_references.state_financial_aid,
NULL,old_references.state_financial_aid),
decode(NVL(old_references.primary_program_rank,99999),
NVL(new_references.primary_program_rank,99999),
NULL,old_references.primary_program_rank),
decode(NVL(old_references.max_wlst_per_stud,99999),
NVL(new_references.max_wlst_per_stud,99999),
NULL,old_references.max_wlst_per_stud),
decode(NVL(old_references.annual_instruction_time,99999),
NVL(new_references.annual_instruction_time,99999),
NULL,old_references.annual_instruction_time)
INTO v_start_dt,
v_course_status,
v_title,
v_short_title,
v_abbreviation,
v_supp_exam_permitted_ind,
v_generic_course_ind,
v_graduate_students_ind,
v_count_intrmsn_in_time_ind,
v_intrmsn_allowed_ind,
v_course_type,
v_responsible_org_unit_cd,
v_govt_special_course_type,
v_qualification_recency,
v_external_adv_stnd_limit,
v_internal_adv_stnd_limit,
v_contact_hours,
v_credit_points_required,
v_govt_course_load,
v_std_annual_load,
v_course_total_eftsu,
v_max_intrmsn_duration,
v_num_of_units_before_intrmsn,
v_min_sbmsn_percentage,
v_min_cp_per_calendar,
v_approval_date,
v_external_approval_date,
v_federal_financial_aid,
v_institutional_financial_aid,
v_max_cp_per_teaching_period,
v_residency_cp_required,
v_state_financial_aid,
l_primary_program_rank,
l_n_max_wlst_per_stud,
l_n_annual_instruction_time
FROM dual;
old_references.last_update_date,
new_references.last_update_date,
old_references.last_updated_by,
v_start_dt,
v_review_dt,
v_expiry_dt,
v_end_dt,
v_course_status,
v_title,
v_short_title,
v_abbreviation,
v_supp_exam_permitted_ind,
v_generic_course_ind,
v_graduate_students_ind,
v_count_intrmsn_in_time_ind,
v_intrmsn_allowed_ind,
v_course_type,
v_responsible_org_unit_cd,
v_responsible_ou_start_dt,
v_govt_special_course_type,
v_qualification_recency,
v_external_adv_stnd_limit,
v_internal_adv_stnd_limit,
v_contact_hours,
v_credit_points_required,
v_govt_course_load,
v_std_annual_load,
v_course_total_eftsu,
v_max_intrmsn_duration,
v_num_of_units_before_intrmsn,
v_min_sbmsn_percentage,
v_min_cp_per_calendar,
v_approval_date,
v_external_approval_date,
v_federal_financial_aid,
v_institutional_financial_aid,
v_max_cp_per_teaching_period,
v_residency_cp_required,
v_state_financial_aid,
l_primary_program_rank,
l_n_max_wlst_per_stud,
l_n_annual_instruction_time);
igs_ps_ver_hist_pkg.delete_row(x_rowid => spvh_rec.rowid);
END beforerowinsertupdatedelete1;
PROCEDURE afterrowinsertupdate2(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
/************************************************************************
Created By :
Date Created By :
Purpose :
Known limitations, enhancements or remarks:
Change History :
Who When What
sarakshi 11-Aug-2005 Bug#4112225, replaced user defined course status with system defined course status
vvutukur 19-Oct-2002 Enh#2608227.Removed DEFAULT keyword to avoid gscc File.Pkg.22 warning.
sbeerell 10-MAY-2000 Changed for new DLD version 2
nalkumar 16-Dec-2003 Modified the code to fix Bug# 3310718
(reverse chronological order - newest change first)
*************************************************************************/
CURSOR cur_igs_ps_unit_lvl IS
SELECT ulvl.*
FROM igs_ps_unit_lvl_all ulvl
WHERE course_cd = new_references.course_cd;
SELECT s_course_status
FROM igs_ps_stat
WHERE course_status=cp_course_status;
igs_ps_unit_lvl_pkg.insert_row(
X_ROWID => l_rowid ,
X_UNIT_CD => rec_igs_ps_unit_lvl.unit_cd ,
X_VERSION_NUMBER => rec_igs_ps_unit_lvl.version_number,
X_COURSE_TYPE => rec_igs_ps_unit_lvl.course_type ,
X_UNIT_LEVEL => rec_igs_ps_unit_lvl.unit_level ,
X_WAM_WEIGHTING => rec_igs_ps_unit_lvl.wam_weighting ,
X_MODE => 'R' ,
X_ORG_ID => rec_igs_ps_unit_lvl.org_id ,
X_COURSE_CD => rec_igs_ps_unit_lvl.course_cd ,
X_COURSE_VERSION_NUMBER => new_references.version_number
);
IF p_inserting OR
(p_updating AND
((NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR
(old_references.course_status <> new_references.course_status))) THEN
-- Cannot call crsp_val_crv_exp_sts because trigger will be mutating.
-- Save the rowid of the current row.
rowvalmutation(
p_inserting => p_inserting,
p_updating => p_updating,
p_deleting => p_deleting
);
END afterrowinsertupdate2;
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');
ugummall 27-NOV-2003 Bug 3252832. FA 131 - COD Updates.
Added igf_gr_pell_setup_pkg.get_fk_igs_ps_ver for child existance.
ijeddy 05-nov-2003 Bug# 3181938; Modified this object as per Summary Measurement Of Attainment FD.
SELECT 1 FROM USER_OBJECTS
WHERE OBJECT_NAME = 'IGS_HE_ST_PROG_ALL_PKG'
AND object_type = 'PACKAGE BODY';
SELECT st.s_course_status
FROM igs_ps_ver_all v ,
igs_ps_stat st
WHERE v.course_status=st.course_status
AND v.course_cd = x_course_cd
AND v.version_number = x_version_number;
SELECT ROWID
FROM igs_ps_ver_all
WHERE course_cd = x_course_cd
AND version_number = x_version_number
FOR UPDATE NOWAIT;
SELECT ROWID
FROM igs_ps_ver_all
WHERE course_cd = x_course_cd
AND version_number = x_version_number;
SELECT ROWID
FROM igs_ps_ver_all
WHERE course_cd = x_course_cd ;
SELECT ROWID
FROM igs_ps_ver_all
WHERE govt_special_course_type = x_govt_special_course_type ;
SELECT ROWID
FROM igs_ps_ver_all
WHERE responsible_org_unit_cd = x_org_unit_cd
AND responsible_ou_start_dt = x_start_dt ;
SELECT ROWID
FROM igs_ps_ver_all
WHERE course_status = x_course_status ;
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_org_id IN NUMBER ,
x_rev_account_cd IN VARCHAR2 ,
x_primary_program_rank NUMBER,
x_max_wlst_per_stud IN NUMBER,
x_annual_instruction_time IN NUMBER
) AS
/************************************************************************
Created By :
Date Created By :
Purpose :
Known limitations, enhancements or remarks:
Change History :
Who When What
vvutukur 18-Oct-2002 Enh#2608227.Removed references to std_ft_completion_time,std_pt_completion_time,
as these columns are obsolete.Also modified call to beforerowinsertupdatedelete1 to pass
all the parameters as DEFAULT value is removed from the procedure definition.
sarakshi 16-jun-2002 bug#2416973,added call to beforerowupdate,beforerowdelete
smadathi 10-MAY-2001 Changed for New DLD Version
sbeerell 10-MAY-2000 Changed for new DLD version 2
(reverse chronological order - newest change first)
*************************************************************************/
BEGIN
set_column_values (
p_action,
x_rowid,
x_course_cd,
x_version_number,
x_start_dt,
x_review_dt,
x_expiry_dt,
x_end_dt,
x_course_status,
x_title,
x_short_title,
x_abbreviation,
x_supp_exam_permitted_ind,
x_generic_course_ind,
x_graduate_students_ind,
x_count_intrmsn_in_time_ind,
x_intrmsn_allowed_ind,
x_course_type,
x_responsible_org_unit_cd,
x_responsible_ou_start_dt,
x_govt_special_course_type,
x_qualification_recency,
x_external_adv_stnd_limit,
x_internal_adv_stnd_limit,
x_contact_hours,
x_credit_points_required,
x_govt_course_load,
x_std_annual_load,
x_course_total_eftsu,
x_max_intrmsn_duration,
x_num_of_units_before_intrmsn,
x_min_sbmsn_percentage,
x_max_cp_per_teaching_period,
x_approval_date,
x_external_approval_date,
x_residency_cp_required,
x_state_financial_aid,
x_federal_financial_aid,
x_institutional_financial_aid,
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_min_cp_per_calendar,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_org_id,
x_rev_account_cd,
x_primary_program_rank,
x_max_wlst_per_stud,
x_annual_instruction_time
);
IF (p_action = 'INSERT') THEN
-- Call all the PROCEDUREs related to Before Insert.
beforerowinsertupdatedelete1 ( p_inserting => TRUE,
p_updating => FALSE,
p_deleting => FALSE);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the PROCEDUREs related to Before Update.
beforerowinsertupdatedelete1 ( p_inserting => FALSE,
p_updating => TRUE,
p_deleting => FALSE);
beforerowupdate;
ELSIF (p_action = 'DELETE') THEN
-- Call all the PROCEDUREs related to Before Delete.
beforerowinsertupdatedelete1 ( p_inserting => FALSE,
p_updating => FALSE,
p_deleting => TRUE );
beforerowdelete;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF get_pk_for_validation(
new_references.course_cd ,
new_references.version_number
) 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;
Purpose : Insertion into table IGS_PS_REF_CD for mandatory ref code types and default ref codes
Known limitations, enhancements or remarks:
Change History :
Who When What
*************************************************************************/
CURSOR c_igs_ge_ref_cd_type_all
IS
SELECT
reference_cd_type,
mandatory_flag,
program_flag,
closed_ind
FROM
igs_ge_ref_cd_type_all
WHERE
mandatory_flag ='Y'
AND
program_flag ='Y'
AND
restricted_flag='Y'
AND
closed_ind = 'N';
SELECT
reference_cd,
description
FROM
igs_ge_ref_cd
WHERE
reference_cd_type = p_c_reference_cd_type
AND default_flag = 'Y';
igs_ps_ref_cd_pkg.INSERT_ROW (
X_ROWID => l_c_rowid,
X_COURSE_CD => p_course_cd,
X_VERSION_NUMBER => p_version_number,
X_REFERENCE_CD_TYPE => cur_igs_ge_ref_cd_type_all.reference_cd_type ,
X_REFERENCE_CD => cur_igs_ge_ref_cd.reference_cd ,
X_DESCRIPTION => cur_igs_ge_ref_cd.description ,
X_MODE => 'R'
);
SELECT
course_cd,
version_number
FROM
igs_ps_ver pv
WHERE
row_id = x_rowid;
IF (p_action = 'INSERT') THEN
-- Call all the PROCEDUREs related to After Insert.
afterrowinsertupdate2 ( p_inserting => TRUE,
p_updating => FALSE,
p_deleting => FALSE);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the PROCEDUREs related to After Update.
afterrowinsertupdate2 ( p_inserting => FALSE,
p_updating => TRUE,
p_deleting => FALSE);
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_course_cd IN VARCHAR2,
x_version_number IN NUMBER,
x_start_dt IN DATE,
x_review_dt IN DATE,
x_expiry_dt IN DATE,
x_end_dt IN DATE,
x_course_status IN VARCHAR2,
x_title IN VARCHAR2,
x_short_title IN VARCHAR2,
x_abbreviation IN VARCHAR2,
x_supp_exam_permitted_ind IN VARCHAR2,
x_generic_course_ind IN VARCHAR2,
x_graduate_students_ind IN VARCHAR2,
x_count_intrmsn_in_time_ind IN VARCHAR2,
x_intrmsn_allowed_ind IN VARCHAR2,
x_course_type IN VARCHAR2,
x_responsible_org_unit_cd IN VARCHAR2,
x_responsible_ou_start_dt IN DATE,
x_govt_special_course_type IN VARCHAR2,
x_qualification_recency IN NUMBER,
x_external_adv_stnd_limit IN NUMBER,
x_internal_adv_stnd_limit IN NUMBER,
x_contact_hours IN NUMBER,
x_credit_points_required IN NUMBER,
x_govt_course_load IN NUMBER,
x_std_annual_load IN NUMBER,
x_course_total_eftsu IN NUMBER,
x_max_intrmsn_duration IN NUMBER,
x_num_of_units_before_intrmsn IN NUMBER,
x_min_sbmsn_percentage IN NUMBER,
x_max_cp_per_teaching_period IN NUMBER,
x_approval_date IN DATE,
x_external_approval_date IN DATE,
x_residency_cp_required IN NUMBER,
x_state_financial_aid IN VARCHAR2,
x_federal_financial_aid IN VARCHAR2,
x_institutional_financial_aid IN VARCHAR2,
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_mode IN VARCHAR2,
x_org_id IN NUMBER,
x_min_cp_per_calendar IN NUMBER,
x_rev_account_cd IN VARCHAR2 ,
x_primary_program_rank IN NUMBER,
x_max_wlst_per_stud IN NUMBER,
x_annual_instruction_time IN NUMBER
) AS
/************************************************************************
Created By :
Date Created By :
Purpose :
Known limitations, enhancements or remarks:
Change History :
Who When What
vvutukur 18-Oct-2002 Enh#2608227.Removed references to std_ft_completion_time,std_pt_completion_time,
as these columns are obsolete.
msrinivi 08-Aug-2001 Added new col rev_Account_cd bug # 1882122
smadathi 10-MAY-2001 Changed for New DLD Version
sbeerell 10-MAY-2000 Modifiaction for DLD Version 2
(reverse chronological order - newest change first)
*************************************************************************/
CURSOR c IS SELECT ROWID FROM igs_ps_ver_all
WHERE course_cd = x_course_cd
AND version_number = x_version_number;
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
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;
before_dml( p_action => 'INSERT',
x_rowid => x_rowid,
x_course_cd => x_course_cd,
x_version_number => x_version_number,
x_start_dt => x_start_dt,
x_review_dt => x_review_dt,
x_expiry_dt => x_expiry_dt,
x_end_dt => x_end_dt,
x_course_status => x_course_status,
x_title => x_title,
x_short_title => x_short_title,
x_abbreviation => x_abbreviation,
x_supp_exam_permitted_ind => NVL(x_supp_exam_permitted_ind,'Y'),
x_generic_course_ind => NVL(x_generic_course_ind,'N'),
x_graduate_students_ind => NVL(x_graduate_students_ind,'Y'),
x_count_intrmsn_in_time_ind => NVL(x_count_intrmsn_in_time_ind,'Y'),
x_intrmsn_allowed_ind => NVL(x_intrmsn_allowed_ind,'Y'),
x_course_type => x_course_type,
x_responsible_org_unit_cd => x_responsible_org_unit_cd,
x_responsible_ou_start_dt => x_responsible_ou_start_dt,
x_govt_special_course_type => x_govt_special_course_type,
x_qualification_recency => x_qualification_recency,
x_external_adv_stnd_limit => x_external_adv_stnd_limit,
x_internal_adv_stnd_limit => x_internal_adv_stnd_limit,
x_contact_hours => x_contact_hours,
x_credit_points_required => x_credit_points_required,
x_govt_course_load => x_govt_course_load,
x_std_annual_load => x_std_annual_load,
x_course_total_eftsu => x_course_total_eftsu,
x_max_intrmsn_duration => x_max_intrmsn_duration,
x_num_of_units_before_intrmsn => x_num_of_units_before_intrmsn,
x_min_sbmsn_percentage=>x_min_sbmsn_percentage,
x_max_cp_per_teaching_period=>x_max_cp_per_teaching_period,
x_approval_date=>x_approval_date,
x_external_approval_date=>x_external_approval_date,
x_residency_cp_required=>x_residency_cp_required,
x_state_financial_aid=>x_state_financial_aid,
x_federal_financial_aid=>x_federal_financial_aid,
x_institutional_financial_aid=>x_institutional_financial_aid,
x_attribute_category=>x_attribute_category,
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_min_cp_per_calendar=>x_min_cp_per_calendar,
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_org_id=>igs_ge_gen_003.get_org_id,
x_rev_account_cd =>x_rev_account_cd,
x_primary_program_rank => x_primary_program_rank,
x_max_wlst_per_stud => x_max_wlst_per_stud,
x_annual_instruction_time => x_annual_instruction_time
);
INSERT INTO igs_ps_ver_all (
graduate_students_ind,
count_intrmsn_in_time_ind,
intrmsn_allowed_ind,
course_type,
responsible_org_unit_cd,
responsible_ou_start_dt,
govt_special_course_type,
qualification_recency,
external_adv_stnd_limit,
internal_adv_stnd_limit,
contact_hours,
credit_points_required,
govt_course_load,
std_annual_load,
course_total_eftsu,
max_intrmsn_duration,
num_of_units_before_intrmsn,
min_sbmsn_percentage,
course_cd,
version_number,
start_dt,
review_dt,
expiry_dt,
end_dt,
course_status,
title,
short_title,
abbreviation,
supp_exam_permitted_ind,
generic_course_ind,
max_cp_per_teaching_period,
approval_date,
external_approval_date,
residency_cp_required,
state_financial_aid,
federal_financial_aid,
institutional_financial_aid,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
org_id,
min_cp_per_calendar,
rev_account_cd,
primary_program_rank,
max_wlst_per_stud,
annual_instruction_time
) VALUES (
new_references.graduate_students_ind,
new_references.count_intrmsn_in_time_ind,
new_references.intrmsn_allowed_ind,
new_references.course_type,
new_references.responsible_org_unit_cd,
new_references.responsible_ou_start_dt,
new_references.govt_special_course_type,
new_references.qualification_recency,
new_references.external_adv_stnd_limit,
new_references.internal_adv_stnd_limit,
new_references.contact_hours,
new_references.credit_points_required,
new_references.govt_course_load,
new_references.std_annual_load,
new_references.course_total_eftsu,
new_references.max_intrmsn_duration,
new_references.num_of_units_before_intrmsn,
new_references.min_sbmsn_percentage,
new_references.course_cd,
new_references.version_number,
new_references.start_dt,
new_references.review_dt,
new_references.expiry_dt,
new_references.end_dt,
new_references.course_status,
new_references.title,
new_references.short_title,
new_references.abbreviation,
new_references.supp_exam_permitted_ind,
new_references.generic_course_ind,
new_references.max_cp_per_teaching_period,
new_references.approval_date,
new_references.external_approval_date,
new_references.residency_cp_required,
new_references.state_financial_aid,
new_references.federal_financial_aid,
new_references.institutional_financial_aid,
new_references.attribute_category,
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,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
new_references.org_id,
new_references.min_cp_per_calendar,
new_references.rev_account_cd,
new_references.primary_program_rank,
new_references.max_wlst_per_stud,
new_references.annual_instruction_time
);
p_action => 'INSERT',
x_rowid => x_rowid
);
END insert_row;
CURSOR c1 IS SELECT
graduate_students_ind,
count_intrmsn_in_time_ind,
intrmsn_allowed_ind,
course_type,
responsible_org_unit_cd,
responsible_ou_start_dt,
govt_special_course_type,
qualification_recency,
external_adv_stnd_limit,
internal_adv_stnd_limit,
contact_hours,
credit_points_required,
govt_course_load,
std_annual_load,
course_total_eftsu,
max_intrmsn_duration,
num_of_units_before_intrmsn,
min_sbmsn_percentage,
start_dt,
review_dt,
expiry_dt,
end_dt,
course_status,
title,
short_title,
abbreviation,
supp_exam_permitted_ind,
generic_course_ind,
max_cp_per_teaching_period,
approval_date,
external_approval_date,
residency_cp_required,
state_financial_aid,
federal_financial_aid,
institutional_financial_aid,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
min_cp_per_calendar,
rev_account_cd,
primary_program_rank,
max_wlst_per_stud,
annual_instruction_time
FROM igs_ps_ver_all
WHERE ROWID = x_rowid FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_course_cd IN VARCHAR2,
x_version_number IN NUMBER,
x_start_dt IN DATE,
x_review_dt IN DATE,
x_expiry_dt IN DATE,
x_end_dt IN DATE,
x_course_status IN VARCHAR2,
x_title IN VARCHAR2,
x_short_title IN VARCHAR2,
x_abbreviation IN VARCHAR2,
x_supp_exam_permitted_ind IN VARCHAR2,
x_generic_course_ind IN VARCHAR2,
x_graduate_students_ind IN VARCHAR2,
x_count_intrmsn_in_time_ind IN VARCHAR2,
x_intrmsn_allowed_ind IN VARCHAR2,
x_course_type IN VARCHAR2,
x_responsible_org_unit_cd IN VARCHAR2,
x_responsible_ou_start_dt IN DATE,
x_govt_special_course_type IN VARCHAR2,
x_qualification_recency IN NUMBER,
x_external_adv_stnd_limit IN NUMBER,
x_internal_adv_stnd_limit IN NUMBER,
x_contact_hours IN NUMBER,
x_credit_points_required IN NUMBER,
x_govt_course_load IN NUMBER,
x_std_annual_load IN NUMBER,
x_course_total_eftsu IN NUMBER,
x_max_intrmsn_duration IN NUMBER,
x_num_of_units_before_intrmsn IN NUMBER,
x_min_sbmsn_percentage IN NUMBER,
x_max_cp_per_teaching_period IN NUMBER,
x_approval_date IN DATE,
x_external_approval_date IN DATE,
x_residency_cp_required IN NUMBER,
x_state_financial_aid IN VARCHAR2,
x_federal_financial_aid IN VARCHAR2,
x_institutional_financial_aid IN VARCHAR2,
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_min_cp_per_calendar IN NUMBER,
x_mode IN VARCHAR2,
x_rev_account_cd IN VARCHAR2 ,
x_primary_program_rank IN NUMBER,
x_max_wlst_per_stud IN NUMBER,
x_annual_instruction_time IN NUMBER
) AS
/************************************************************************
Created By :
Date Created By :
Purpose :
Known limitations, enhancements or remarks:
Change History :
Who When What
vvutukur 18-Oct-2002 Enh#2608227.Removed references to std_ft_completion_time,std_pt_completion_time,
as these columns are obsolete.Also removed DEFAULT keyword to avoid gscc File.Pkg.22 warning.
smadathi 10-MAY-2001 Changed for New DLD Version
sbeerell 10-MAY-2000 Changed for new DLD version 2
(reverse chronological order - newest change first)
*************************************************************************/
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
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;
before_dml( p_action => 'UPDATE',
x_rowid => x_rowid,
x_course_cd => x_course_cd,
x_version_number => x_version_number,
x_start_dt => x_start_dt,
x_review_dt => x_review_dt,
x_expiry_dt => x_expiry_dt,
x_end_dt => x_end_dt,
x_course_status => x_course_status,
x_title => x_title,
x_short_title => x_short_title,
x_abbreviation => x_abbreviation,
x_supp_exam_permitted_ind => x_supp_exam_permitted_ind,
x_generic_course_ind => x_generic_course_ind,
x_graduate_students_ind => x_graduate_students_ind,
x_count_intrmsn_in_time_ind => x_count_intrmsn_in_time_ind,
x_intrmsn_allowed_ind => x_intrmsn_allowed_ind,
x_course_type => x_course_type,
x_responsible_org_unit_cd => x_responsible_org_unit_cd,
x_responsible_ou_start_dt => x_responsible_ou_start_dt,
x_govt_special_course_type => x_govt_special_course_type,
x_qualification_recency => x_qualification_recency,
x_external_adv_stnd_limit => x_external_adv_stnd_limit,
x_internal_adv_stnd_limit => x_internal_adv_stnd_limit,
x_contact_hours => x_contact_hours,
x_credit_points_required => x_credit_points_required,
x_govt_course_load => x_govt_course_load,
x_std_annual_load => x_std_annual_load,
x_course_total_eftsu => x_course_total_eftsu,
x_max_intrmsn_duration => x_max_intrmsn_duration,
x_num_of_units_before_intrmsn => x_num_of_units_before_intrmsn,
x_min_sbmsn_percentage=>x_min_sbmsn_percentage,
x_max_cp_per_teaching_period=>x_max_cp_per_teaching_period,
x_approval_date=>x_approval_date,
x_external_approval_date=>x_external_approval_date,
x_residency_cp_required=>x_residency_cp_required,
x_state_financial_aid=>x_state_financial_aid,
x_federal_financial_aid=>x_federal_financial_aid,
x_institutional_financial_aid=>x_institutional_financial_aid,
x_attribute_category=>x_attribute_category,
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_min_cp_per_calendar=>x_min_cp_per_calendar,
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_rev_account_cd => x_rev_account_cd,
x_primary_program_rank => x_primary_program_rank,
x_max_wlst_per_stud => x_max_wlst_per_stud,
x_annual_instruction_time => x_annual_instruction_time
);
UPDATE igs_ps_ver_all SET
graduate_students_ind = new_references.graduate_students_ind,
count_intrmsn_in_time_ind = new_references.count_intrmsn_in_time_ind,
intrmsn_allowed_ind = new_references.intrmsn_allowed_ind,
course_type = new_references.course_type,
responsible_org_unit_cd = new_references.responsible_org_unit_cd,
responsible_ou_start_dt = new_references.responsible_ou_start_dt,
govt_special_course_type = new_references.govt_special_course_type,
qualification_recency = new_references.qualification_recency,
external_adv_stnd_limit = new_references.external_adv_stnd_limit,
internal_adv_stnd_limit = new_references.internal_adv_stnd_limit,
contact_hours = new_references.contact_hours,
credit_points_required = new_references.credit_points_required,
govt_course_load = new_references.govt_course_load,
std_annual_load = new_references.std_annual_load,
course_total_eftsu = new_references.course_total_eftsu,
max_intrmsn_duration = new_references.max_intrmsn_duration,
num_of_units_before_intrmsn = new_references.num_of_units_before_intrmsn,
min_sbmsn_percentage = new_references.min_sbmsn_percentage,
start_dt = new_references.start_dt,
review_dt = new_references.review_dt,
expiry_dt = new_references.expiry_dt,
end_dt = new_references.end_dt,
course_status = new_references.course_status,
title = new_references.title,
short_title = new_references.short_title,
abbreviation = new_references.abbreviation,
supp_exam_permitted_ind = new_references.supp_exam_permitted_ind,
generic_course_ind = new_references.generic_course_ind,
max_cp_per_teaching_period = new_references.max_cp_per_teaching_period,
approval_date = new_references.approval_date,
external_approval_date = new_references.external_approval_date,
residency_cp_required = new_references.residency_cp_required,
state_financial_aid = new_references.state_financial_aid,
federal_financial_aid = new_references.federal_financial_aid,
institutional_financial_aid = new_references.institutional_financial_aid,
attribute_category = new_references.attribute_category,
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,
min_cp_per_calendar = new_references.min_cp_per_calendar,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login,
rev_account_cd = x_rev_account_cd,
primary_program_rank = new_references.primary_program_rank,
max_wlst_per_stud = new_references.max_wlst_per_stud,
annual_instruction_time = new_references.annual_instruction_time
WHERE ROWID = x_rowid
;
p_action => 'UPDATE',
x_rowid => x_rowid
);
END update_row;
CURSOR c1 IS SELECT ROWID FROM igs_ps_ver_all
WHERE course_cd = x_course_cd
AND version_number = x_version_number ;
insert_row (
x_rowid,
x_course_cd,
x_version_number,
x_start_dt,
x_review_dt,
x_expiry_dt,
x_end_dt,
x_course_status,
x_title,
x_short_title,
x_abbreviation,
x_supp_exam_permitted_ind,
x_generic_course_ind,
x_graduate_students_ind,
x_count_intrmsn_in_time_ind,
x_intrmsn_allowed_ind,
x_course_type,
x_responsible_org_unit_cd,
x_responsible_ou_start_dt,
x_govt_special_course_type,
x_qualification_recency,
x_external_adv_stnd_limit,
x_internal_adv_stnd_limit,
x_contact_hours,
x_credit_points_required,
x_govt_course_load,
x_std_annual_load,
x_course_total_eftsu,
x_max_intrmsn_duration,
x_num_of_units_before_intrmsn,
x_min_sbmsn_percentage,
x_max_cp_per_teaching_period,
x_approval_date,
x_external_approval_date,
x_residency_cp_required,
x_state_financial_aid,
x_federal_financial_aid,
x_institutional_financial_aid,
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_min_cp_per_calendar,
x_mode,
x_org_id,
x_rev_account_cd,
x_primary_program_rank,
x_max_wlst_per_stud,
x_annual_instruction_time);
update_row (
x_rowid,
x_course_cd,
x_version_number,
x_start_dt,
x_review_dt,
x_expiry_dt,
x_end_dt,
x_course_status,
x_title,
x_short_title,
x_abbreviation,
x_supp_exam_permitted_ind,
x_generic_course_ind,
x_graduate_students_ind,
x_count_intrmsn_in_time_ind,
x_intrmsn_allowed_ind,
x_course_type,
x_responsible_org_unit_cd,
x_responsible_ou_start_dt,
x_govt_special_course_type,
x_qualification_recency,
x_external_adv_stnd_limit,
x_internal_adv_stnd_limit,
x_contact_hours,
x_credit_points_required,
x_govt_course_load,
x_std_annual_load,
x_course_total_eftsu,
x_max_intrmsn_duration,
x_num_of_units_before_intrmsn,
x_min_sbmsn_percentage,
x_max_cp_per_teaching_period,
x_approval_date,
x_external_approval_date,
x_residency_cp_required,
x_state_financial_aid,
x_federal_financial_aid,
x_institutional_financial_aid,
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_min_cp_per_calendar,
x_mode,
x_rev_account_cd,
x_primary_program_rank,
x_max_wlst_per_stud,
x_annual_instruction_time
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2
) AS
/************************************************************************
Created By :
Date Created By :
Purpose :
Known limitations, enhancements or remarks:
Change History :
Who When What
sbeerell 10-MAY-2000 Changed for new DLD version 2
(reverse chronological order - newest change first)
*************************************************************************/
BEGIN
before_dml( p_action => 'DELETE',
x_rowid => x_rowid
);
DELETE FROM igs_ps_ver_all
WHERE ROWID = x_rowid;
p_action => 'DELETE',
x_rowid => x_rowid
);
END delete_row;