[Home] [Help]
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 unit status are allowed for deletion
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
-------------------------------------------------------------------
CURSOR cur_delete (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
cp_version_number igs_ps_unit_ver_all.version_number%TYPE)
IS
SELECT 'x'
FROM igs_ps_unit_ver_all uv,
igs_ps_unit_stat us
WHERE uv.unit_status=us.unit_status
AND us.s_unit_status='PLANNED'
AND uv.unit_cd = cp_unit_cd
AND uv.version_number = cp_version_number;
OPEN cur_delete (old_references.unit_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 unit Status can not be changed to Planned Status
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
--sarakshi 26-Jul-2004 bug#3793607,added code such that statsu cannot be changed to INACTIVE when enrolled/waitlisted student unit attempt exists
-------------------------------------------------------------------
CURSOR cur_get_status (cp_unit_status igs_ps_unit_stat.unit_status%TYPE)
IS
SELECT s_unit_status
FROM igs_ps_unit_stat
WHERE unit_status = cp_unit_status;
CURSOR cur_check_update (cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
cp_version_number igs_ps_unit_ver_all.version_number%TYPE)
IS
SELECT 'x'
FROM igs_ps_unit_ver_all uv,
igs_ps_unit_stat us
WHERE uv.unit_status=us.unit_status
AND us.s_unit_status <> 'PLANNED'
AND uv.unit_cd = cp_unit_cd
AND uv.version_number = cp_version_number;
SELECT 'X'
FROM igs_en_su_attempt_all a,
igs_ps_unit_ofr_opt_all b
WHERE a.uoo_id = b.uoo_id
AND b.unit_cd = cp_unit_cd
AND b.version_number = cp_version_number
AND a.unit_attempt_status IN ('ENROLLED','WAITLISTED');
OPEN cur_check_update(old_references.unit_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_updated_by in NUMBER ,
x_last_update_date in DATE ,
x_last_update_login in NUMBER ,
x_org_id in NUMBER ,
x_ss_enrol_ind in VARCHAR2 ,
x_ivr_enrol_ind in VARCHAR2 ,
x_rev_account_cd IN VARCHAR2 ,
x_claimable_hours IN NUMBER ,
x_anon_unit_grading_ind IN VARCHAR2 ,
x_anon_assess_grading_ind IN VARCHAR2 ,
x_auditable_ind IN VARCHAR2,
x_audit_permission_ind IN VARCHAR2 ,
x_max_auditors_allowed IN NUMBER ,
x_billing_credit_points IN NUMBER,
x_ovrd_wkld_val_flag IN VARCHAR2 ,
x_workload_val_code IN VARCHAR2 ,
x_billing_hrs IN NUMBER
) AS
------------------------------------------------------------------
--Purpose: As per enhancement bug no.1775394 , the column subtitle in
-- igs_ps_unit_ver_all is obsoleted . Irrespective of the value passed
-- to this column , it will always be assigned NULL .
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
--smadathi 13-JUN-2001 refer purpose
--msrinivi 20-Jul-2001 Added new col : rev_account_Cd
-------------------------------------------------------------------
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_PS_UNIT_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;
PROCEDURE BeforeRowInsertUpdateDelete1(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN ,
p_deleting IN BOOLEAN
) AS
--modified rgangara as per DLD Unit Section Enrollment on 03-May-2001 added two nwe Columns SS_enrol_ind and IVr_enrol_ind
v_message_name Varchar2(30);
SELECT s_unit_status
FROM IGS_PS_UNIT_STAT
WHERE unit_status = new_references.unit_status ;
SELECT Rowid
FROM IGS_PS_UNIT_VER_HIST
WHERE unit_cd = old_references.unit_cd AND
version_number = old_references.version_number;
SELECT '1'
FROM igs_ps_unit_ver_v uv
WHERE unit_cd = new_references.unit_cd
AND version_number = new_references.version_number
AND curriculum_id = new_references.curriculum_id
AND EXISTS (SELECT '1'
FROM igs_ps_unt_crclm ucur
WHERE ucur.curriculum_id = uv.curriculum_id
AND ucur.closed_ind = 'Y' ) ;
-- Closed curriculum id should not allow any update to existing repeat fail of units .
-- added by smadathi on 25-MAY-2001 as per new DLD requirement
OPEN c_igs_ps_unit_ver_all ;
IF p_inserting OR
(p_updating AND
(old_references.unit_int_course_level_cd <>
new_references.unit_int_course_level_cd)) THEN
IF IGS_PS_VAL_UV.crsp_val_uv_uicl (
new_references.unit_int_course_level_cd, v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
(old_references.unit_level <> new_references.unit_level)) THEN
IF IGS_PS_VAL_UV.crsp_val_unit_lvl (
new_references.unit_level,v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
(old_references.credit_point_descriptor <>
new_references.credit_point_descriptor )) THEN
IF IGS_PS_VAL_UV.crsp_val_uv_cp_desc (
new_references.credit_point_descriptor,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 the bug# 1956374 changed to the below call from IGS_PS_VAL_UV.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.owner_org_unit_cd <> new_references.owner_org_unit_cd) OR
(old_references.owner_ou_start_dt <> new_references.owner_ou_start_dt))) THEN
-- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_UV.crsp_val_ou_sys_sts
IF IGS_PS_VAL_CRV.crsp_val_ou_sys_sts (
new_references.owner_org_unit_cd,
new_references.owner_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.unit_status <> new_references.unit_status))) THEN
IF IGS_PS_VAL_UV.crsp_val_uv_end_sts(
new_references.end_dt,
new_references.unit_status,v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
((old_references.points_override_ind <> new_references.points_override_ind) OR
(NVL(old_references.points_increment, 0) <> NVL(new_references.points_increment, 0)) OR
(NVL(old_references.points_min, 0) <> NVL(new_references.points_min, 0)) OR
(NVL(old_references.points_max, 0) <> NVL(new_references.points_max, 0)) OR
(NVL(old_references.enrolled_credit_points, 0) <>
NVL(new_references.enrolled_credit_points, 0)) OR
(NVL(old_references.achievable_credit_points, 0) <>
NVL(new_references.achievable_credit_points,0)))) THEN
IF IGS_PS_VAL_UV.crsp_val_uv_pnt_ovrd(
new_references.points_override_ind,
new_references.points_increment,
new_references.points_min,
new_references.points_max,
new_references.enrolled_credit_points,
new_references.achievable_credit_points,v_message_name,FALSE) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
((old_references.supp_exam_permitted_ind <>
new_references.supp_exam_permitted_ind) OR
(old_references.assessable_ind <>
new_references.assessable_ind))) THEN
IF IGS_PS_VAL_UV.crsp_val_uv_sup_exam (
new_references.supp_exam_permitted_ind,
new_references.assessable_ind,v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR p_updating THEN
IF (new_references.ss_enrol_ind = 'N' AND new_references.ivr_enrol_ind = 'N') THEN
Fnd_Message.Set_Name('IGS','IGS_PS_ONE_UNIT_ENR_MTHD');
SELECT DECODE(old_references.start_dt,new_references.start_dt,
NULL,old_references.start_dt),
DECODE(old_references.unit_status,new_references.unit_status,
NULL,old_references.unit_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.title_override_ind,new_references.title_override_ind,
NULL,old_references.title_override_ind),
DECODE(old_references.abbreviation,new_references.abbreviation,NULL,
old_references.abbreviation),
DECODE(old_references.unit_level,new_references.unit_level,
NULL,old_references.unit_level),
DECODE(old_references.credit_point_descriptor,new_references.credit_point_descriptor,
NULL,old_references.credit_point_descriptor),
DECODE(NVL(old_references.achievable_credit_points,999999),
NVL(new_references.achievable_credit_points,999999),
NULL,old_references.achievable_credit_points),
DECODE(old_references.enrolled_credit_points,new_references.enrolled_credit_points,
NULL,old_references.enrolled_credit_points),
DECODE(old_references.supp_exam_permitted_ind,new_references.supp_exam_permitted_ind,
NULL,old_references.supp_exam_permitted_ind),
DECODE(NVL(old_references.points_increment,999999),
NVL(new_references.points_increment,999999),
NULL,old_references.points_increment),
DECODE(NVL(old_references.points_min,999999),NVL(new_references.points_min,999999),
NULL,old_references.points_min),
DECODE(NVL(old_references.points_max,999999),NVL(new_references.points_max,999999),
NULL,old_references.points_max),
DECODE(old_references.points_override_ind,new_references.points_override_ind,
NULL,old_references.points_override_ind),
DECODE(old_references.coord_person_id,new_references.coord_person_id,
NULL,old_references.coord_person_id),
DECODE(old_references.owner_org_unit_cd,new_references.owner_org_unit_cd,
NULL,old_references.owner_org_unit_cd),
DECODE(old_references.owner_ou_start_dt,new_references.owner_ou_start_dt,
NULL,old_references.owner_ou_start_dt),
DECODE(old_references.award_course_only_ind,new_references.award_course_only_ind,
NULL,old_references.award_course_only_ind),
DECODE(old_references.research_unit_ind,new_references.research_unit_ind,
NULL,old_references.research_unit_ind),
DECODE(old_references.industrial_ind,new_references.industrial_ind,
NULL,old_references.industrial_ind),
DECODE(old_references.practical_ind,new_references.practical_ind,
NULL,old_references.practical_ind),
DECODE(old_references.repeatable_ind,new_references.repeatable_ind,
NULL,old_references.repeatable_ind),
DECODE(old_references.assessable_ind,new_references.assessable_ind,
NULL,old_references.assessable_ind),
DECODE(NVL(old_references.unit_int_course_leveL_cd,'NULL'),
NVL(new_references.unit_int_course_level_cd,'NULL'),
NULL,old_references.unit_int_course_level_cd),
-- Added by rbezawad as per DLD PSP001-US on 24-May-2001
DECODE( NVL(old_references.advance_maximum,999999),
NVL(new_references.advance_maximum,999999),
NULL, old_references.advance_maximum),
DECODE( NVL(old_references.approval_date, IGS_GE_DATE.IGSDATE('1900/01/01')),
NVL(new_references.approval_date,IGS_GE_DATE.IGSDATE('1900/01/01')) ,
NULL, old_references.approval_date),
DECODE( NVL(old_references.cal_type_enrol_load_cal,'null'),
NVL(new_references.cal_type_enrol_load_cal,'null') ,
NULL, old_references.cal_type_enrol_load_cal),
DECODE( NVL(old_references.cal_type_offer_load_cal,'null'),
NVL(new_references.cal_type_offer_load_cal,'null') ,
NULL, old_references.cal_type_offer_load_cal),
DECODE( NVL(old_references.clock_hours,999999),
NVL(new_references.clock_hours,999999) ,
NULL, old_references.clock_hours),
DECODE( NVL(old_references.contact_hrs_lab,999999),
NVL(new_references.contact_hrs_lab,999999) ,
NULL, old_references.contact_hrs_lab),
DECODE( NVL(old_references.contact_hrs_lecture,999999),
NVL(new_references.contact_hrs_lecture,999999) ,
NULL, old_references.contact_hrs_lecture),
DECODE( NVL(old_references.contact_hrs_other,999999),
NVL(new_references.contact_hrs_other,999999) ,
NULL, old_references.contact_hrs_other),
DECODE( NVL(old_references.continuing_education_units,999999),
NVL(new_references.continuing_education_units,999999) ,
NULL, old_references.continuing_education_units),
DECODE( NVL(old_references.curriculum_id,'null'),
NVL(new_references.curriculum_id,'null') ,
NULL, old_references.curriculum_id),
DECODE( NVL(old_references.enrollment_expected,999999),
NVL(new_references.enrollment_expected,999999) ,
NULL, old_references.enrollment_expected),
DECODE( NVL(old_references.enrollment_maximum,999999),
NVL(new_references.enrollment_maximum,999999) ,
NULL, old_references.enrollment_maximum),
DECODE( NVL(old_references.enrollment_minimum,999999),
NVL(new_references.enrollment_minimum,999999) ,
NULL, old_references.enrollment_minimum),
DECODE( NVL(old_references.exclude_from_max_cp_limit,'N'),
NVL(new_references.exclude_from_max_cp_limit,'N') ,
NULL, old_references.exclude_from_max_cp_limit),
DECODE( NVL(old_references.federal_financial_aid,'N'),
NVL(new_references.federal_financial_aid,'N') ,
NULL, old_references.federal_financial_aid),
DECODE( NVL(old_references.institutional_financial_aid,'N'),
NVL(new_references.institutional_financial_aid,'N') ,
NULL, old_references.institutional_financial_aid),
DECODE( NVL(old_references.lab_credit_points,999999),
NVL(new_references.lab_credit_points,999999) ,
NULL, old_references.lab_credit_points),
DECODE( NVL(old_references.lecture_credit_points,999999),
NVL(new_references.lecture_credit_points,999999) ,
NULL, old_references.lecture_credit_points),
DECODE( NVL(old_references.max_repeat_credit_points,999999),
NVL(new_references.max_repeat_credit_points,999999) ,
NULL, old_references.max_repeat_credit_points),
DECODE( NVL(old_references.max_repeats_for_credit,999999),
NVL(new_references.max_repeats_for_credit,999999) ,
NULL, old_references.max_repeats_for_credit),
DECODE( NVL(old_references.max_repeats_for_funding,999999),
NVL(new_references.max_repeats_for_funding,999999) ,
NULL, old_references.max_repeats_for_funding),
DECODE( NVL(old_references.non_schd_required_hrs,999999),
NVL(new_references.non_schd_required_hrs,999999) ,
NULL, old_references.non_schd_required_hrs),
DECODE( NVL(old_references.other_credit_points,999999),
NVL(new_references.other_credit_points,999999) ,
NULL, old_references.other_credit_points),
DECODE( NVL(old_references.override_enrollment_max,999999),
NVL(new_references.override_enrollment_max,999999) ,
NULL, old_references.override_enrollment_max),
DECODE( NVL(old_references.record_exclusion_flag,'N'),
NVL(new_references.record_exclusion_flag,'N') ,
NULL, old_references.record_exclusion_flag),
DECODE( NVL(old_references.ss_display_ind,'N'),
NVL(new_references.ss_display_ind,'N') ,
NULL, old_references.ss_display_ind ),
DECODE( NVL(old_references.rpt_fmly_id,999999),
NVL(new_references.rpt_fmly_id,999999),
NULL, old_references.rpt_fmly_id),
DECODE( NVL(old_references.same_teach_period_repeats,999999),
NVL(new_references.same_teach_period_repeats,999999) ,
NULL, old_references.same_teach_period_repeats),
DECODE( NVL(old_references.same_teach_period_repeats_cp,999999),
NVL(new_references.same_teach_period_repeats_cp,999999),
NULL, old_references.same_teach_period_repeats_cp),
DECODE( NVL(old_references.same_teaching_period,'N'),
NVL(new_references.same_teaching_period,'N') ,
NULL, old_references.same_teaching_period),
DECODE( NVL(old_references.sequence_num_enrol_load_cal,999999),
NVL(new_references.sequence_num_enrol_load_cal,999999) ,
NULL, old_references.sequence_num_enrol_load_cal),
DECODE( NVL(old_references.sequence_num_offer_load_cal,999999),
NVL(new_references.sequence_num_offer_load_cal,999999) ,
NULL, old_references.sequence_num_offer_load_cal),
DECODE( NVL(old_references.special_permission_ind,'N'),
NVL(new_references.special_permission_ind,'N') ,
NULL, old_references.special_permission_ind),
DECODE( NVL(old_references.state_financial_aid,'N'),
NVL(new_references.state_financial_aid,'N') ,
NULL, old_references.state_financial_aid),
DECODE( NVL(old_references.subtitle_id,999999),
NVL(new_references.subtitle_id,999999) ,
NULL, old_references.subtitle_id),
DECODE( NVL(old_references.subtitle_modifiable_flag,'N'),
NVL(new_references.subtitle_modifiable_flag,'N') ,
NULL, old_references.subtitle_modifiable_flag),
DECODE( NVL(old_references.unit_type_id,999999),
NVL(new_references.unit_type_id,999999) ,
NULL, old_references.unit_type_id),
DECODE( NVL(old_references.work_load_cp_lab,999999),
NVL(new_references.work_load_cp_lab,999999) ,
NULL, old_references.work_load_cp_lab),
DECODE( NVL(old_references.work_load_cp_lecture,999999),
NVL(new_references.work_load_cp_lecture,999999) ,
NULL, old_references.work_load_cp_lecture),
DECODE( NVL(old_references.work_load_other,999999),
NVL(new_references.work_load_other,999999),
NULL, old_references.work_load_other),
DECODE( NVL(old_references.claimable_hours,9999999),
NVL(new_references.claimable_hours,9999999),
NULL, old_references.claimable_hours),
DECODE( NVL(old_references.auditable_ind,'N'),
NVL(new_references.auditable_ind,'N'),
NULL, old_references.auditable_ind),
DECODE( NVL(old_references.audit_permission_ind,'N'),
NVL(new_references.audit_permission_ind,'N'),
NULL, old_references.audit_permission_ind),
DECODE( NVL(old_references.max_auditors_allowed,9999999),
NVL(new_references.max_auditors_allowed,9999999),
NULL, old_references.max_auditors_allowed),
DECODE( NVL(old_references.billing_credit_points,9999999),
NVL(new_references.billing_credit_points,9999999),
NULL, old_references.billing_credit_points),
DECODE( NVL(old_references.ovrd_wkld_val_flag,'N'),
NVL(new_references.ovrd_wkld_val_flag,'N'),
NULL, old_references.ovrd_wkld_val_flag),
DECODE( NVL(old_references.workload_val_code,'NULL'),
NVL(new_references.workload_val_code,'NULL'),
NULL, old_references.workload_val_code),
DECODE( NVL(old_references.billing_hrs,9999999),
NVL(new_references.billing_hrs,9999999),
NULL, old_references.billing_hrs)
--
INTO v_start_dt,
v_unit_status,
v_title,
v_short_title,
v_title_override_ind,
v_abbreviation,
v_unit_level,
v_credit_point_descriptor,
v_achievable_credit_points,
v_enrolled_credit_points,
v_supp_exam_permitted_ind,
v_points_increment,
v_points_min,
v_points_max,
v_points_override_ind,
v_coord_person_id,
v_owner_org_unit_cd,
v_owner_ou_start_dt,
v_award_course_only_ind,
v_research_unit_ind,
v_industrial_ind,
v_practical_ind,
v_repeatable_ind,
v_assessable_ind,
v_unit_int_course_level_cd,
-- Added by rbezawad as per PSP001-US DLD on 24-May-2001
v_advance_maximum,
v_approval_date,
v_cal_type_enrol_load_cal,
v_cal_type_offer_load_cal,
v_clock_hours,
v_contact_hrs_lab,
v_contact_hrs_lecture,
v_contact_hrs_other,
v_continuing_education_units,
v_curriculum_id,
v_enrollment_expected,
v_enrollment_maximum,
v_enrollment_minimum,
v_exclude_from_max_cp_limit,
v_federal_financial_aid,
v_institutional_financial_aid,
v_lab_credit_points,
v_lecture_credit_points,
v_max_repeat_credit_points,
v_max_repeats_for_credit,
v_max_repeats_for_funding,
v_non_schd_required_hrs,
v_other_credit_points,
v_override_enrollment_max,
v_record_exclusion_flag,
v_ss_display_ind,
v_rpt_fmly_id,
v_same_teach_period_repeats,
v_same_teach_period_repeats_cp,
v_same_teaching_period,
v_sequence_num_enrol_load_cal,
v_sequence_num_offer_load_cal,
v_special_permission_ind,
v_state_financial_aid,
v_subtitle_id,
v_subtitle_modifiable_flag,
v_unit_type_id,
v_work_load_cp_lab,
v_work_load_cp_lecture,
v_work_load_other,
v_claimable_hours,
v_auditable_ind,
v_audit_permission_ind,
v_max_auditors_allowed,
v_billing_credit_points,
v_ovrd_wkld_val_flag,
v_workload_val_code,
v_billing_hrs
--
FROM dual;
-- Create history record for update
IGS_PS_GEN_006.CRSP_INS_UV_HIST(
old_references.unit_cd,
old_references.version_number,
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_unit_status,
v_title,
v_short_title,
v_title_override_ind,
v_abbreviation,
v_unit_level,
v_credit_point_descriptor,
v_achievable_credit_points,
v_enrolled_credit_points,
v_supp_exam_permitted_ind,
v_points_increment,
v_points_min,
v_points_max,
v_points_override_ind,
v_coord_person_id,
v_owner_org_unit_cd,
v_owner_ou_start_dt,
v_award_course_only_ind,
v_research_unit_ind,
v_industrial_ind,
v_practical_ind,
v_repeatable_ind,
v_assessable_ind,
v_unit_int_course_level_cd,
v_ss_enrol_ind,
v_ivr_enrol_ind,
-- added by rbezawad as per PSP001-US DLD ON 24-MAY-2001
v_advance_maximum,
v_approval_date,
v_cal_type_enrol_load_cal,
v_cal_type_offer_load_cal,
v_clock_hours,
v_contact_hrs_lab,
v_contact_hrs_lecture,
v_contact_hrs_other,
v_continuing_education_units,
v_curriculum_id,
v_enrollment_expected,
v_enrollment_maximum,
v_enrollment_minimum,
v_exclude_from_max_cp_limit,
v_federal_financial_aid,
v_institutional_financial_aid,
v_lab_credit_points,
v_lecture_credit_points,
v_max_repeat_credit_points,
v_max_repeats_for_credit,
v_max_repeats_for_funding,
v_non_schd_required_hrs,
v_other_credit_points,
v_override_enrollment_max,
v_record_exclusion_flag,
v_ss_display_ind,
v_rpt_fmly_id,
v_same_teach_period_repeats,
v_same_teach_period_repeats_cp,
v_same_teaching_period,
v_sequence_num_enrol_load_cal,
v_sequence_num_offer_load_cal,
v_special_permission_ind,
v_state_financial_aid,
v_subtitle_id,
v_subtitle_modifiable_flag,
v_unit_type_id,
v_work_load_cp_lab,
v_work_load_cp_lecture,
v_work_load_other,
v_claimable_hours,
v_auditable_ind,
v_audit_permission_ind,
v_max_auditors_allowed,
v_billing_credit_points,
v_ovrd_wkld_val_flag,
v_workload_val_code
,v_billing_hrs
);
IGS_PS_UNIT_VER_HIST_PKG.Delete_Row(X_ROWID=>SPUVH_Rec.Rowid);
END BeforeRowInsertUpdateDelete1;
PROCEDURE AfterRowInsertUpdate2(
p_inserting IN BOOLEAN ,
p_updating IN BOOLEAN ,
p_deleting IN BOOLEAN
) AS
cst_active VARCHAR2 (6) ;
SELECT s_unit_status
FROM IGS_PS_UNIT_STAT
WHERE unit_status = cp_unit_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.unit_status <> new_references.unit_status))) THEN
v_rowid_saved:= TRUE;
IF p_inserting OR
(p_updating AND (old_references.unit_status <> new_references.unit_status)) THEN
-- Save the rowid, old expiry date and old IGS_PS_UNIT status so
-- the IGS_PS_UNIT status can be validated in the after statement
-- trigger as calling IGS_PS_VAL_UV.crsp_val_uv_unit_sts from
-- here will cause mutating table error. Also, the quality check
-- may need to be performed if the status has been altered to
-- active.
v_rowid_saved:= TRUE;
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.unit_status <> new_references.unit_status))) THEN
IF IGS_PS_VAL_UV.crsp_val_uv_exp_sts (
new_references.unit_cd,
new_references.version_number,
new_references.expiry_dt,
new_references.unit_status,v_message_name) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
IF p_inserting OR
(p_updating AND
(old_references.unit_status <> new_references.unit_status)) THEN
IF IGS_PS_VAL_UV.crsp_val_uv_unit_sts (
new_references.unit_cd,
new_references.version_number,
new_references.unit_status,
old_references.unit_status,v_message_name,FALSE) = FALSE THEN
Fnd_Message.Set_Name('IGS',v_message_name);
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');
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 us.s_unit_status
FROM igs_ps_unit_ver_all uv,
igs_ps_unit_stat us
WHERE uv.unit_status=us.unit_status
AND uv.unit_cd = x_unit_cd
AND uv.version_number = x_version_number;
SELECT ROWID
FROM igs_ps_unit_ver_all
WHERE unit_cd = x_unit_cd
AND version_number = x_version_number
FOR UPDATE NOWAIT;
SELECT ROWID
FROM igs_ps_unit_ver_all
WHERE unit_cd = x_unit_cd
AND version_number = x_version_number;
SELECT rowid
FROM IGS_PS_UNIT_VER_ALL
WHERE credit_point_descriptor = x_credit_point_descriptor ;
SELECT rowid
FROM IGS_PS_UNIT_VER_ALL
WHERE owner_org_unit_cd = x_org_unit_cd
AND owner_ou_start_dt = x_start_dt ;
SELECT rowid
FROM IGS_PS_UNIT_VER_ALL
WHERE coord_person_id = x_person_id ;
SELECT rowid
FROM IGS_PS_UNIT_VER_ALL
WHERE unit_int_course_level_cd = x_unit_int_course_level_cd ;
SELECT rowid
FROM IGS_PS_UNIT_VER_ALL
WHERE unit_cd = x_unit_cd ;
SELECT rowid
FROM IGS_PS_UNIT_VER_ALL
WHERE unit_status = x_unit_status ;
SELECT rowid
FROM igs_ps_unit_ver_all
WHERE ((rpt_fmly_id = x_rpt_fmly_id));
SELECT rowid
FROM igs_ps_unit_ver_all
WHERE ((subtitle_id = x_subtitle_id));
SELECT rowid
FROM igs_ps_unit_ver_all
WHERE ((curriculum_id = x_curriculum_id));
SELECT rowid
FROM igs_ps_unit_ver_all
WHERE (cal_type_enrol_load_cal = x_cal_type and
sequence_num_enrol_load_cal = x_sequence_number);
SELECT rowid
FROM igs_ps_unit_ver_all
WHERE (cal_type_offer_load_cal = x_cal_type and
sequence_num_offer_load_cal = x_sequence_number);
x_last_updated_by in NUMBER ,
x_last_update_date in DATE ,
x_last_update_login in NUMBER ,
x_org_id in NUMBER ,
x_ss_enrol_ind in VARCHAR2 ,
x_ivr_enrol_ind in VARCHAR2 ,
x_rev_account_cd IN VARCHAR2 ,
x_claimable_hours IN NUMBER ,
x_anon_unit_grading_ind IN VARCHAR2 ,
x_anon_assess_grading_ind IN VARCHAR2 ,
x_auditable_ind IN VARCHAR2,
x_audit_permission_ind IN VARCHAR2,
x_max_auditors_allowed IN NUMBER,
x_billing_credit_points IN NUMBER,
x_ovrd_wkld_val_flag IN VARCHAR2 ,
x_workload_val_code IN VARCHAR2 ,
x_billing_hrs IN NUMBER
) AS
BEGIN
Set_Column_Values (
p_action,
x_rowid,
x_unit_cd,
x_version_number,
x_start_dt,
x_review_dt,
x_expiry_dt,
x_end_dt,
x_unit_status,
x_title,
x_short_title,
x_title_override_ind,
x_abbreviation,
x_unit_level,
x_credit_point_descriptor,
x_enrolled_credit_points,
x_points_override_ind,
x_supp_exam_permitted_ind,
x_coord_person_id,
x_owner_org_unit_cd,
x_owner_ou_start_dt,
x_award_course_only_ind,
x_research_unit_ind,
x_industrial_ind,
x_practical_ind,
x_repeatable_ind,
x_assessable_ind,
x_achievable_credit_points,
x_points_increment,
x_points_min,
x_points_max,
x_unit_int_course_level_cd,
x_subtitle,
x_subtitle_modifiable_flag,
x_approval_date,
x_lecture_credit_points,
x_lab_credit_points,
x_other_credit_points,
x_clock_hours,
x_work_load_cp_lecture,
x_work_load_cp_lab,
x_continuing_education_units,
x_enrollment_expected,
x_enrollment_minimum,
x_enrollment_maximum,
x_advance_maximum,
x_state_financial_aid,
x_federal_financial_aid,
x_institutional_financial_aid,
x_same_teaching_period,
x_max_repeats_for_credit,
x_max_repeats_for_funding,
x_max_repeat_credit_points,
x_same_teach_period_repeats,
x_same_teach_period_repeats_cp,
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_SUBTITLE_ID,
x_work_load_other,
x_contact_hrs_lecture,
x_contact_hrs_lab,
x_contact_hrs_other,
x_non_schd_required_hrs,
x_exclude_from_max_cp_limit,
x_record_exclusion_flag,
x_ss_display_ind,
x_cal_type_enrol_load_cal,
x_sequence_num_enrol_load_cal,
x_cal_type_offer_load_cal,
x_sequence_num_offer_load_cal,
x_curriculum_id,
x_override_enrollment_max,
x_rpt_fmly_id,
x_unit_type_id,
x_special_permission_ind,
x_created_by,
x_creation_date,
x_last_updated_by,
x_last_update_date,
x_last_update_login,
x_org_id,
x_ss_enrol_ind,
x_ivr_enrol_ind,
x_rev_account_cd,
x_claimable_hours,
x_anon_unit_grading_ind,
x_anon_assess_grading_ind,
x_auditable_ind,
x_audit_permission_ind,
x_max_auditors_allowed,
x_billing_credit_points,
x_ovrd_wkld_val_flag ,
x_workload_val_code ,
x_billing_hrs
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE,
p_deleting => FALSE,
p_updating => FALSE );
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
BeforeRowInsertUpdateDelete1 ( p_updating => TRUE,
p_inserting => FALSE,
p_deleting => FALSE );
beforerowupdate;
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
BeforeRowInsertUpdateDelete1 ( p_deleting => TRUE ,
p_inserting => FALSE,
p_updating => FALSE );
beforerowdelete;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF Get_PK_For_Validation (New_References.unit_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;
SELECT reference_cd_type
FROM igs_ge_ref_cd_type
WHERE mandatory_flag ='Y'
AND unit_flag ='Y'
AND restricted_flag ='Y'
AND closed_ind = 'N';
SELECT reference_cd,
description
FROM igs_ge_ref_cd
WHERE reference_cd_type = cp_reference_cd_type
AND default_flag = 'Y';
igs_ps_unit_ref_cd_pkg.insert_row(x_rowid => l_c_rowid,
x_unit_cd => p_c_unit_cd,
x_reference_cd_type => cur_igs_ge_ref_cd_type.reference_cd_type,
x_version_number => p_n_version_number,
x_reference_cd => cur_igs_ge_ref_cd.reference_cd,
x_description => cur_igs_ge_ref_cd.description,
x_mode => 'R');
SELECT unit_cd, version_number
FROM igs_ps_unit_ver
WHERE ROWID = cp_rowid;
SELECT uso.unit_section_occurrence_id
FROM Igs_ps_usec_occurs_all uso,
Igs_ps_unit_ofr_opt_all us,
Igs_ca_inst_all ci
WHERE uso.uoo_id=us.uoo_id
AND us.cal_type=ci.cal_type
AND us.ci_sequence_number = ci.sequence_number
AND TRUNC (ci.end_dt) > TRUNC (SYSDATE)
AND (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
AND uso.no_set_day_ind ='N'
AND us.unit_section_status <> 'NOT_OFFERED'
AND us.unit_cd =cp_unit_cd
AND us.version_number =cp_version_number
AND NOT EXISTS (SELECT 'X' FROM igs_ps_usec_lim_wlst ulw WHERE ulw.uoo_id = us.uoo_id);
SELECT a.*,a.rowid
FROM igs_ps_usec_ref a ,
igs_ps_unit_ofr_opt_all b,
igs_ca_inst_all c
WHERE a.uoo_id= b.uoo_id
AND b.unit_cd= cp_unit_cd
AND b.version_number = cp_version_number
AND b.cal_type=c.cal_type
AND b.ci_sequence_number=c.sequence_number;
SELECT subtitle_id
FROM igs_ps_unit_subtitle_v
WHERE unit_cd = cp_unit_cd AND
version_number = cp_version_number AND
subtitle =cp_subtitle;
update_flag BOOLEAN := FALSE;
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_updating => TRUE ,
p_inserting => FALSE,
p_deleting => FALSE);
igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
update_flag := FALSE;
update_flag := TRUE;
update_flag := TRUE;
IF update_flag THEN
Igs_Ps_Usec_Ref_Pkg.Update_Row (
X_Mode => 'R',
X_rowid => c_title_rec.rowid,
X_Unit_Section_Reference_Id => c_title_rec.unit_section_reference_id,
X_Uoo_Id => c_title_rec.uoo_id,
X_Short_Title => c_title_rec.Short_Title,
X_Subtitle => NULL,
X_Subtitle_ModIFiable_Flag => c_title_rec.subtitle_modifiable_flag,
X_Class_Sched_Exclusion_Flag => c_title_rec.class_schedule_exclusion_flag,
X_Registration_Exclusion_Flag => c_title_rec.registration_exclusion_flag,
X_Attribute_Category => c_title_rec.attribute_category,
X_Attribute1 => c_title_rec.Attribute1,
X_Attribute2 => c_title_rec.Attribute2,
X_Attribute3 => c_title_rec.Attribute3,
X_Attribute4 => c_title_rec.Attribute4,
X_Attribute5 => c_title_rec.Attribute5,
X_Attribute6 => c_title_rec.Attribute6,
X_Attribute7 => c_title_rec.Attribute7,
X_Attribute8 => c_title_rec.Attribute8,
X_Attribute9 => c_title_rec.Attribute9,
X_Attribute10 => c_title_rec.Attribute10,
X_Attribute11 => c_title_rec.Attribute11,
X_Attribute12 => c_title_rec.Attribute12,
X_Attribute13 => c_title_rec.Attribute13,
X_Attribute14 => c_title_rec.Attribute14,
X_Attribute15 => c_title_rec.Attribute15,
X_Attribute16 => c_title_rec.Attribute16,
X_Attribute17 => c_title_rec.Attribute17,
X_Attribute18 => c_title_rec.Attribute18,
X_Attribute19 => c_title_rec.Attribute19,
X_Attribute20 => c_title_rec.Attribute20,
X_Title => v_title,
X_Subtitle_id => r_unit_subtitle,
X_Record_Exclusion_Flag => c_title_rec.record_exclusion_flag
);
PROCEDURE insert_row (
X_ROWID in out NOCOPY VARCHAR2,
X_UNIT_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_UNIT_STATUS in VARCHAR2,
X_TITLE in VARCHAR2,
X_SHORT_TITLE in VARCHAR2,
X_TITLE_OVERRIDE_IND in VARCHAR2,
X_ABBREVIATION in VARCHAR2,
X_UNIT_LEVEL in VARCHAR2,
X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
X_ENROLLED_CREDIT_POINTS in NUMBER,
X_POINTS_OVERRIDE_IND in VARCHAR2,
X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
X_COORD_PERSON_ID in NUMBER,
X_OWNER_ORG_UNIT_CD in VARCHAR2,
X_OWNER_OU_START_DT in DATE,
X_AWARD_COURSE_ONLY_IND in VARCHAR2,
X_RESEARCH_UNIT_IND in VARCHAR2,
X_INDUSTRIAL_IND in VARCHAR2,
X_PRACTICAL_IND in VARCHAR2,
X_REPEATABLE_IND in VARCHAR2,
X_ASSESSABLE_IND in VARCHAR2,
X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
X_POINTS_INCREMENT in NUMBER,
X_POINTS_MIN in NUMBER,
X_POINTS_MAX in NUMBER,
X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
X_SUBTITLE in VARCHAR2,
X_SUBTITLE_MODIFIABLE_FLAG in VARCHAR2,
X_APPROVAL_DATE in DATE,
X_LECTURE_CREDIT_POINTS in NUMBER,
X_LAB_CREDIT_POINTS in NUMBER,
X_OTHER_CREDIT_POINTS in NUMBER,
X_CLOCK_HOURS in NUMBER,
X_WORK_LOAD_CP_LECTURE in NUMBER,
X_WORK_LOAD_CP_LAB in NUMBER,
X_CONTINUING_EDUCATION_UNITS in NUMBER,
X_ENROLLMENT_EXPECTED in NUMBER,
X_ENROLLMENT_MINIMUM in NUMBER,
X_ENROLLMENT_MAXIMUM in NUMBER,
X_ADVANCE_MAXIMUM in NUMBER,
X_STATE_FINANCIAL_AID in VARCHAR2,
X_FEDERAL_FINANCIAL_AID in VARCHAR2,
X_INSTITUTIONAL_FINANCIAL_AID in VARCHAR2,
X_SAME_TEACHING_PERIOD in VARCHAR2,
X_MAX_REPEATS_FOR_CREDIT in NUMBER,
X_MAX_REPEATS_FOR_FUNDING in NUMBER,
X_MAX_REPEAT_CREDIT_POINTS in NUMBER,
X_SAME_TEACH_PERIOD_REPEATS in NUMBER,
X_SAME_TEACH_PERIOD_REPEATS_CP in NUMBER,
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_subtitle_id IN NUMBER ,
x_work_load_other IN NUMBER ,
x_contact_hrs_lecture IN NUMBER ,
x_contact_hrs_lab IN NUMBER ,
x_contact_hrs_other IN NUMBER ,
x_non_schd_required_hrs IN NUMBER ,
x_exclude_from_max_cp_limit IN VARCHAR2 ,
x_record_exclusion_flag IN VARCHAR2 ,
x_ss_display_ind IN VARCHAR2 ,
x_cal_type_enrol_load_cal IN VARCHAR2 ,
x_sequence_num_enrol_load_cal IN NUMBER ,
x_cal_type_offer_load_cal IN VARCHAR2 ,
x_sequence_num_offer_load_cal IN NUMBER ,
x_curriculum_id IN VARCHAR2 ,
x_override_enrollment_max IN NUMBER ,
x_rpt_fmly_id IN NUMBER ,
x_unit_type_id IN NUMBER ,
x_special_permission_ind IN VARCHAR2 ,
X_MODE in VARCHAR2 ,
X_ORG_ID IN NUMBER,
X_SS_ENROL_IND IN VARCHAR2 ,
X_IVR_ENROL_IND IN VARCHAR2 ,
x_claimable_hours IN NUMBER ,
x_rev_account_cd IN VARCHAR2 ,
x_anon_unit_grading_ind IN VARCHAR2 ,
x_anon_assess_grading_ind IN VARCHAR2 ,
x_auditable_ind IN VARCHAR2,
x_audit_permission_ind IN VARCHAR2,
x_max_auditors_allowed IN NUMBER,
x_billing_credit_points IN NUMBER ,
x_ovrd_wkld_val_flag IN VARCHAR2 ,
x_workload_val_code IN VARCHAR2 ,
x_billing_hrs IN NUMBER
) AS
/**********************************************************************************************************************************
sarakshi 14-oct-2003 Enh#3052452,removed the nvl clause from max_repeats_for_credits in the before_dml call.
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_PS_UNIT_VER_ALL
where UNIT_CD = X_UNIT_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;
p_action => 'INSERT',
x_rowid => X_ROWID,
x_unit_cd => X_UNIT_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_unit_status => X_UNIT_STATUS,
x_title => X_TITLE,
x_short_title => X_SHORT_TITLE,
x_title_override_ind => NVL(X_TITLE_OVERRIDE_IND,'Y'),
x_abbreviation => X_ABBREVIATION,
x_unit_level => X_UNIT_LEVEL,
x_credit_point_descriptor => X_CREDIT_POINT_DESCRIPTOR,
x_enrolled_credit_points => X_ENROLLED_CREDIT_POINTS,
x_points_override_ind => NVL(X_POINTS_OVERRIDE_IND,'Y'),
x_supp_exam_permitted_ind => NVL(X_SUPP_EXAM_PERMITTED_IND,'Y'),
x_coord_person_id => X_COORD_PERSON_ID,
x_owner_org_unit_cd => X_OWNER_ORG_UNIT_CD,
x_owner_ou_start_dt => X_OWNER_OU_START_DT,
x_award_course_only_ind => NVL(X_AWARD_COURSE_ONLY_IND,'Y'),
x_research_unit_ind => NVL(X_RESEARCH_UNIT_IND,'N'),
x_industrial_ind => NVL(X_INDUSTRIAL_IND,'N'),
x_practical_ind => NVL(X_PRACTICAL_IND,'N'),
x_repeatable_ind => NVL(X_REPEATABLE_IND,'Y'),
x_assessable_ind => NVL(X_ASSESSABLE_IND,'Y'),
x_achievable_credit_points => X_ACHIEVABLE_CREDIT_POINTS,
x_points_increment => X_POINTS_INCREMENT,
x_points_min => X_POINTS_MIN,
x_points_max => X_POINTS_MAX,
x_unit_int_course_level_cd => X_UNIT_INT_COURSE_LEVEL_CD,
x_subtitle => X_SUBTITLE,
x_subtitle_modifiable_flag => X_SUBTITLE_MODIFIABLE_FLAG,
x_approval_date => X_APPROVAL_DATE,
x_lecture_credit_points => X_LECTURE_CREDIT_POINTS,
x_lab_credit_points => X_LAB_CREDIT_POINTS,
x_other_credit_points => X_OTHER_CREDIT_POINTS,
x_clock_hours => X_CLOCK_HOURS,
x_work_load_cp_lecture => X_WORK_LOAD_CP_LECTURE,
x_work_load_cp_lab => X_WORK_LOAD_CP_LAB,
x_continuing_education_units => X_CONTINUING_EDUCATION_UNITS,
x_enrollment_expected => X_ENROLLMENT_EXPECTED,
x_enrollment_minimum => X_ENROLLMENT_MINIMUM,
x_enrollment_maximum => X_ENROLLMENT_MAXIMUM,
x_advance_maximum => X_ADVANCE_MAXIMUM,
x_state_financial_aid => NVL(X_STATE_FINANCIAL_AID, 'Y'),
x_federal_financial_aid => NVL(X_FEDERAL_FINANCIAL_AID, 'Y'),
x_institutional_financial_aid => NVL(X_INSTITUTIONAL_FINANCIAL_AID, 'Y'),
x_same_teaching_period => X_SAME_TEACHING_PERIOD,
x_max_repeats_for_credit => X_MAX_REPEATS_FOR_CREDIT,
x_max_repeats_for_funding => X_MAX_REPEATS_FOR_FUNDING,
x_max_repeat_credit_points => X_MAX_REPEAT_CREDIT_POINTS,
x_same_teach_period_repeats => X_SAME_TEACH_PERIOD_REPEATS,
x_same_teach_period_repeats_cp => X_SAME_TEACH_PERIOD_REPEATS_CP,
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_subtitle_id => X_SUBTITLE_ID,
x_work_load_other => x_work_load_other,
x_contact_hrs_lecture => x_contact_hrs_lecture,
x_contact_hrs_lab => x_contact_hrs_lab,
x_contact_hrs_other => x_contact_hrs_other,
x_non_schd_required_hrs => x_non_schd_required_hrs,
x_exclude_from_max_cp_limit => NVL(x_exclude_from_max_cp_limit,'N'),
x_record_exclusion_flag => NVL(x_record_exclusion_flag,'N'),
x_ss_display_ind => NVL(x_ss_display_ind,'N'),
x_cal_type_enrol_load_cal => x_cal_type_enrol_load_cal,
x_sequence_num_enrol_load_cal => x_sequence_num_enrol_load_cal,
x_cal_type_offer_load_cal => x_cal_type_offer_load_cal,
x_sequence_num_offer_load_cal => x_sequence_num_offer_load_cal,
x_curriculum_id => x_curriculum_id,
x_override_enrollment_max => x_override_enrollment_max,
x_rpt_fmly_id => x_rpt_fmly_id,
x_unit_type_id => x_unit_type_id,
x_special_permission_ind => NVL(x_special_permission_ind,'N'),
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_ss_enrol_ind => X_SS_ENROL_IND,
x_ivr_enrol_ind => X_IVR_ENROL_IND,
x_rev_account_cd => x_rev_account_cd ,
x_claimable_hours => x_claimable_hours ,
x_anon_unit_grading_ind => x_anon_unit_grading_ind ,
x_anon_assess_grading_ind => x_anon_assess_grading_ind ,
x_auditable_ind => x_auditable_ind,
x_audit_permission_ind => x_audit_permission_ind,
x_max_auditors_allowed => x_max_auditors_allowed,
x_billing_credit_points => x_billing_credit_points,
x_ovrd_wkld_val_flag => x_ovrd_wkld_val_flag ,
x_workload_val_code => x_workload_val_code ,
x_billing_hrs => x_billing_hrs
);
INSERT INTO IGS_PS_UNIT_VER_ALL (
UNIT_CD,
VERSION_NUMBER,
START_DT,
REVIEW_DT,
EXPIRY_DT,
END_DT,
UNIT_STATUS,
TITLE,
SHORT_TITLE,
TITLE_OVERRIDE_IND,
ABBREVIATION,
UNIT_LEVEL,
CREDIT_POINT_DESCRIPTOR,
ENROLLED_CREDIT_POINTS,
POINTS_OVERRIDE_IND,
SUPP_EXAM_PERMITTED_IND,
COORD_PERSON_ID,
OWNER_ORG_UNIT_CD,
OWNER_OU_START_DT,
AWARD_COURSE_ONLY_IND,
RESEARCH_UNIT_IND,
INDUSTRIAL_IND,
PRACTICAL_IND,
REPEATABLE_IND,
ASSESSABLE_IND,
ACHIEVABLE_CREDIT_POINTS,
POINTS_INCREMENT,
POINTS_MIN,
POINTS_MAX,
UNIT_INT_COURSE_LEVEL_CD,
SUBTITLE_MODIFIABLE_FLAG,
APPROVAL_DATE,
LECTURE_CREDIT_POINTS,
LAB_CREDIT_POINTS,
OTHER_CREDIT_POINTS,
CLOCK_HOURS,
WORK_LOAD_CP_LECTURE,
WORK_LOAD_CP_LAB,
CONTINUING_EDUCATION_UNITS,
ENROLLMENT_EXPECTED,
ENROLLMENT_MINIMUM,
ENROLLMENT_MAXIMUM,
ADVANCE_MAXIMUM,
STATE_FINANCIAL_AID,
FEDERAL_FINANCIAL_AID,
INSTITUTIONAL_FINANCIAL_AID,
SAME_TEACHING_PERIOD,
MAX_REPEATS_FOR_CREDIT,
MAX_REPEATS_FOR_FUNDING,
MAX_REPEAT_CREDIT_POINTS,
SAME_TEACH_PERIOD_REPEATS,
SAME_TEACH_PERIOD_REPEATS_CP,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
subtitle_id,
work_load_other,
contact_hrs_lecture,
contact_hrs_lab,
contact_hrs_other,
non_schd_required_hrs,
exclude_from_max_cp_limit,
record_exclusion_flag,
ss_display_ind,
cal_type_enrol_load_cal,
sequence_num_enrol_load_cal,
cal_type_offer_load_cal,
sequence_num_offer_load_cal,
curriculum_id,
override_enrollment_max,
rpt_fmly_id,
unit_type_id,
special_permission_ind,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
ORG_ID,
SS_ENROL_IND,
IVR_ENROL_IND,
REV_ACCOUNT_CD,
CLAIMABLE_HOURS,
ANON_UNIT_GRADING_IND,
ANON_ASSESS_GRADING_IND,
AUDITABLE_IND,
AUDIT_PERMISSION_IND,
MAX_AUDITORS_ALLOWED,
BILLING_CREDIT_POINTS,
OVRD_WKLD_VAL_FLAG,
WORKLOAD_VAL_CODE,
BILLING_HRS
) VALUES (
NEW_REFERENCES.UNIT_CD,
NEW_REFERENCES.VERSION_NUMBER,
NEW_REFERENCES.START_DT,
NEW_REFERENCES.REVIEW_DT,
NEW_REFERENCES.EXPIRY_DT,
NEW_REFERENCES.END_DT,
NEW_REFERENCES.UNIT_STATUS,
NEW_REFERENCES.TITLE,
NEW_REFERENCES.SHORT_TITLE,
NEW_REFERENCES.TITLE_OVERRIDE_IND,
NEW_REFERENCES.ABBREVIATION,
NEW_REFERENCES.UNIT_LEVEL,
NEW_REFERENCES.CREDIT_POINT_DESCRIPTOR,
NEW_REFERENCES.ENROLLED_CREDIT_POINTS,
NEW_REFERENCES.POINTS_OVERRIDE_IND,
NEW_REFERENCES.SUPP_EXAM_PERMITTED_IND,
NEW_REFERENCES.COORD_PERSON_ID,
NEW_REFERENCES.OWNER_ORG_UNIT_CD,
NEW_REFERENCES.OWNER_OU_START_DT,
NEW_REFERENCES.AWARD_COURSE_ONLY_IND,
NEW_REFERENCES.RESEARCH_UNIT_IND,
NEW_REFERENCES.INDUSTRIAL_IND,
NEW_REFERENCES.PRACTICAL_IND,
NEW_REFERENCES.REPEATABLE_IND,
NEW_REFERENCES.ASSESSABLE_IND,
NEW_REFERENCES.ACHIEVABLE_CREDIT_POINTS,
NEW_REFERENCES.POINTS_INCREMENT,
NEW_REFERENCES.POINTS_MIN,
NEW_REFERENCES.POINTS_MAX,
NEW_REFERENCES.UNIT_INT_COURSE_LEVEL_CD,
NEW_REFERENCES.SUBTITLE_MODIFIABLE_FLAG,
NEW_REFERENCES.APPROVAL_DATE,
NEW_REFERENCES.LECTURE_CREDIT_POINTS,
NEW_REFERENCES.LAB_CREDIT_POINTS,
NEW_REFERENCES.OTHER_CREDIT_POINTS,
NEW_REFERENCES.CLOCK_HOURS,
NEW_REFERENCES.WORK_LOAD_CP_LECTURE,
NEW_REFERENCES.WORK_LOAD_CP_LAB,
NEW_REFERENCES.CONTINUING_EDUCATION_UNITS,
NEW_REFERENCES.ENROLLMENT_EXPECTED,
NEW_REFERENCES.ENROLLMENT_MINIMUM,
NEW_REFERENCES.ENROLLMENT_MAXIMUM,
NEW_REFERENCES.ADVANCE_MAXIMUM,
NEW_REFERENCES.STATE_FINANCIAL_AID,
NEW_REFERENCES.FEDERAL_FINANCIAL_AID,
NEW_REFERENCES.INSTITUTIONAL_FINANCIAL_AID,
NEW_REFERENCES.SAME_TEACHING_PERIOD,
NEW_REFERENCES.MAX_REPEATS_FOR_CREDIT,
NEW_REFERENCES.MAX_REPEATS_FOR_FUNDING,
NEW_REFERENCES.MAX_REPEAT_CREDIT_POINTS,
NEW_REFERENCES.SAME_TEACH_PERIOD_REPEATS,
NEW_REFERENCES.SAME_TEACH_PERIOD_REPEATS_CP,
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,
NEW_REFERENCES.subtitle_id,
new_references.work_load_other,
new_references.contact_hrs_lecture,
new_references.contact_hrs_lab,
new_references.contact_hrs_other,
new_references.non_schd_required_hrs,
new_references.exclude_from_max_cp_limit,
new_references.record_exclusion_flag,
new_references.ss_display_ind,
new_references.cal_type_enrol_load_cal,
new_references.sequence_num_enrol_load_cal,
new_references.cal_type_offer_load_cal,
new_references.sequence_num_offer_load_cal,
new_references.curriculum_id,
new_references.override_enrollment_max,
new_references.rpt_fmly_id,
new_references.unit_type_id,
new_references.special_permission_ind,
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.ss_enrol_ind,
new_references.ivr_enrol_ind,
new_references.rev_account_cd,
new_references.claimable_hours,
new_references.anon_unit_grading_ind,
new_references.anon_assess_grading_ind,
new_references.auditable_ind,
new_references.audit_permission_ind,
new_references.max_auditors_allowed,
new_references.billing_credit_points,
new_references.ovrd_wkld_val_flag,
new_references.workload_val_code,
new_references.billing_hrs
);
p_action => 'INSERT',
x_rowid => X_ROWID
);
END insert_row;
cursor c1 is select
START_DT,
REVIEW_DT,
EXPIRY_DT,
END_DT,
UNIT_STATUS,
TITLE,
SHORT_TITLE,
TITLE_OVERRIDE_IND,
ABBREVIATION,
UNIT_LEVEL,
CREDIT_POINT_DESCRIPTOR,
ENROLLED_CREDIT_POINTS,
POINTS_OVERRIDE_IND,
SUPP_EXAM_PERMITTED_IND,
COORD_PERSON_ID,
OWNER_ORG_UNIT_CD,
OWNER_OU_START_DT,
AWARD_COURSE_ONLY_IND,
RESEARCH_UNIT_IND,
INDUSTRIAL_IND,
PRACTICAL_IND,
REPEATABLE_IND,
ASSESSABLE_IND,
ACHIEVABLE_CREDIT_POINTS,
POINTS_INCREMENT,
POINTS_MIN,
POINTS_MAX,
UNIT_INT_COURSE_LEVEL_CD,
SUBTITLE_MODIFIABLE_FLAG,
APPROVAL_DATE,
LECTURE_CREDIT_POINTS,
LAB_CREDIT_POINTS,
OTHER_CREDIT_POINTS,
CLOCK_HOURS,
WORK_LOAD_CP_LECTURE,
WORK_LOAD_CP_LAB,
CONTINUING_EDUCATION_UNITS,
ENROLLMENT_EXPECTED,
ENROLLMENT_MINIMUM,
ENROLLMENT_MAXIMUM,
ADVANCE_MAXIMUM,
STATE_FINANCIAL_AID,
FEDERAL_FINANCIAL_AID,
INSTITUTIONAL_FINANCIAL_AID,
SAME_TEACHING_PERIOD,
MAX_REPEATS_FOR_CREDIT,
MAX_REPEATS_FOR_FUNDING,
MAX_REPEAT_CREDIT_POINTS,
SAME_TEACH_PERIOD_REPEATS,
SAME_TEACH_PERIOD_REPEATS_CP,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
subtitle_id,
work_load_other,
contact_hrs_lecture,
contact_hrs_lab,
contact_hrs_other,
non_schd_required_hrs,
exclude_from_max_cp_limit,
record_exclusion_flag,
ss_display_ind,
cal_type_enrol_load_cal,
sequence_num_enrol_load_cal,
cal_type_offer_load_cal,
sequence_num_offer_load_cal,
curriculum_id,
override_enrollment_max,
rpt_fmly_id,
unit_type_id,
special_permission_ind,
SS_ENROL_IND,
IVR_ENROL_IND,
rev_account_cd,
claimable_hours ,
anon_unit_grading_ind,
anon_assess_grading_ind,
auditable_ind,
audit_permission_ind,
max_auditors_allowed,
billing_credit_points,
ovrd_wkld_val_flag,
workload_val_code,
billing_hrs
FROM IGS_PS_UNIT_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_UNIT_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_UNIT_STATUS in VARCHAR2,
X_TITLE in VARCHAR2,
X_SHORT_TITLE in VARCHAR2,
X_TITLE_OVERRIDE_IND in VARCHAR2,
X_ABBREVIATION in VARCHAR2,
X_UNIT_LEVEL in VARCHAR2,
X_CREDIT_POINT_DESCRIPTOR in VARCHAR2,
X_ENROLLED_CREDIT_POINTS in NUMBER,
X_POINTS_OVERRIDE_IND in VARCHAR2,
X_SUPP_EXAM_PERMITTED_IND in VARCHAR2,
X_COORD_PERSON_ID in NUMBER,
X_OWNER_ORG_UNIT_CD in VARCHAR2,
X_OWNER_OU_START_DT in DATE,
X_AWARD_COURSE_ONLY_IND in VARCHAR2,
X_RESEARCH_UNIT_IND in VARCHAR2,
X_INDUSTRIAL_IND in VARCHAR2,
X_PRACTICAL_IND in VARCHAR2,
X_REPEATABLE_IND in VARCHAR2,
X_ASSESSABLE_IND in VARCHAR2,
X_ACHIEVABLE_CREDIT_POINTS in NUMBER,
X_POINTS_INCREMENT in NUMBER,
X_POINTS_MIN in NUMBER,
X_POINTS_MAX in NUMBER,
X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
X_SUBTITLE in VARCHAR2,
X_SUBTITLE_MODIFIABLE_FLAG in VARCHAR2,
X_APPROVAL_DATE in DATE,
X_LECTURE_CREDIT_POINTS in NUMBER,
X_LAB_CREDIT_POINTS in NUMBER,
X_OTHER_CREDIT_POINTS in NUMBER,
X_CLOCK_HOURS in NUMBER,
X_WORK_LOAD_CP_LECTURE in NUMBER,
X_WORK_LOAD_CP_LAB in NUMBER,
X_CONTINUING_EDUCATION_UNITS in NUMBER,
X_ENROLLMENT_EXPECTED in NUMBER,
X_ENROLLMENT_MINIMUM in NUMBER,
X_ENROLLMENT_MAXIMUM in NUMBER,
X_ADVANCE_MAXIMUM in NUMBER,
X_STATE_FINANCIAL_AID in VARCHAR2,
X_FEDERAL_FINANCIAL_AID in VARCHAR2,
X_INSTITUTIONAL_FINANCIAL_AID in VARCHAR2,
X_SAME_TEACHING_PERIOD in VARCHAR2,
X_MAX_REPEATS_FOR_CREDIT in NUMBER,
X_MAX_REPEATS_FOR_FUNDING in NUMBER,
X_MAX_REPEAT_CREDIT_POINTS in NUMBER,
X_SAME_TEACH_PERIOD_REPEATS in NUMBER,
X_SAME_TEACH_PERIOD_REPEATS_CP in NUMBER,
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_subtitle_id IN NUMBER ,
x_work_load_other IN NUMBER ,
x_contact_hrs_lecture IN NUMBER ,
x_contact_hrs_lab IN NUMBER ,
x_contact_hrs_other IN NUMBER ,
x_non_schd_required_hrs IN NUMBER ,
x_exclude_from_max_cp_limit IN VARCHAR2 ,
x_record_exclusion_flag IN VARCHAR2 ,
x_ss_display_ind IN VARCHAR2 ,
x_cal_type_enrol_load_cal IN VARCHAR2 ,
x_sequence_num_enrol_load_cal IN NUMBER ,
x_cal_type_offer_load_cal IN VARCHAR2 ,
x_sequence_num_offer_load_cal IN NUMBER ,
x_curriculum_id IN VARCHAR2 ,
x_override_enrollment_max IN NUMBER ,
x_rpt_fmly_id IN NUMBER ,
x_unit_type_id IN NUMBER ,
x_special_permission_ind IN VARCHAR2 ,
X_MODE in VARCHAR2,
X_SS_ENROL_IND in VARCHAR2 ,
X_IVR_ENROL_IND in VARCHAR2 ,
x_rev_account_cd IN VARCHAR2 ,
x_claimable_hours IN NUMBER ,
x_anon_unit_grading_ind IN VARCHAR2 ,
x_anon_assess_grading_ind IN VARCHAR2 ,
x_auditable_ind IN VARCHAR2,
x_audit_permission_ind IN VARCHAR2,
x_max_auditors_allowed IN NUMBER,
x_billing_credit_points IN NUMBER,
x_ovrd_wkld_val_flag IN VARCHAR2 ,
x_workload_val_code IN VARCHAR2 ,
x_billing_hrs IN NUMBER
) AS
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;
p_action => 'UPDATE',
x_rowid => X_ROWID,
x_unit_cd => X_UNIT_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_unit_status => X_UNIT_STATUS,
x_title => X_TITLE,
x_short_title => X_SHORT_TITLE,
x_title_override_ind => X_TITLE_OVERRIDE_IND,
x_abbreviation => X_ABBREVIATION,
x_unit_level => X_UNIT_LEVEL,
x_credit_point_descriptor => X_CREDIT_POINT_DESCRIPTOR,
x_enrolled_credit_points => X_ENROLLED_CREDIT_POINTS,
x_points_override_ind => X_POINTS_OVERRIDE_IND,
x_supp_exam_permitted_ind => X_SUPP_EXAM_PERMITTED_IND,
x_coord_person_id => X_COORD_PERSON_ID,
x_owner_org_unit_cd => X_OWNER_ORG_UNIT_CD,
x_owner_ou_start_dt => X_OWNER_OU_START_DT,
x_award_course_only_ind => X_AWARD_COURSE_ONLY_IND,
x_research_unit_ind => X_RESEARCH_UNIT_IND,
x_industrial_ind => X_INDUSTRIAL_IND,
x_practical_ind => X_PRACTICAL_IND,
x_repeatable_ind => X_REPEATABLE_IND,
x_assessable_ind => X_ASSESSABLE_IND,
x_achievable_credit_points => X_ACHIEVABLE_CREDIT_POINTS,
x_points_increment => X_POINTS_INCREMENT,
x_points_min => X_POINTS_MIN,
x_points_max => X_POINTS_MAX,
x_unit_int_course_level_cd => X_UNIT_INT_COURSE_LEVEL_CD,
x_subtitle_modifiable_flag => X_SUBTITLE_MODIFIABLE_FLAG,
x_approval_date => X_APPROVAL_DATE,
x_lecture_credit_points => X_LECTURE_CREDIT_POINTS,
x_lab_credit_points => X_LAB_CREDIT_POINTS,
x_other_credit_points => X_OTHER_CREDIT_POINTS,
x_clock_hours => X_CLOCK_HOURS,
x_work_load_cp_lecture => X_WORK_LOAD_CP_LECTURE,
x_work_load_cp_lab => X_WORK_LOAD_CP_LAB,
x_continuing_education_units => X_CONTINUING_EDUCATION_UNITS,
x_enrollment_expected => X_ENROLLMENT_EXPECTED,
x_enrollment_minimum => X_ENROLLMENT_MINIMUM,
x_enrollment_maximum => X_ENROLLMENT_MAXIMUM,
x_advance_maximum => X_ADVANCE_MAXIMUM,
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_same_teaching_period => X_SAME_TEACHING_PERIOD,
x_max_repeats_for_credit => X_MAX_REPEATS_FOR_CREDIT,
x_max_repeats_for_funding => X_MAX_REPEATS_FOR_FUNDING,
x_max_repeat_credit_points => X_MAX_REPEAT_CREDIT_POINTS,
x_same_teach_period_repeats => X_SAME_TEACH_PERIOD_REPEATS,
x_same_teach_period_repeats_cp => X_SAME_TEACH_PERIOD_REPEATS_CP,
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_subtitle_id => x_subtitle_id,
x_work_load_other => x_work_load_other,
x_contact_hrs_lecture => x_contact_hrs_lecture,
x_contact_hrs_lab => x_contact_hrs_lab,
x_contact_hrs_other => x_contact_hrs_other,
x_non_schd_required_hrs => x_non_schd_required_hrs,
x_exclude_from_max_cp_limit => x_exclude_from_max_cp_limit,
x_record_exclusion_flag => x_record_exclusion_flag,
x_ss_display_ind => x_ss_display_ind,
x_cal_type_enrol_load_cal => x_cal_type_enrol_load_cal,
x_sequence_num_enrol_load_cal => x_sequence_num_enrol_load_cal,
x_cal_type_offer_load_cal => x_cal_type_offer_load_cal,
x_sequence_num_offer_load_cal => x_sequence_num_offer_load_cal,
x_curriculum_id => x_curriculum_id,
x_override_enrollment_max => x_override_enrollment_max,
x_rpt_fmly_id => x_rpt_fmly_id,
x_unit_type_id => x_unit_type_id,
x_special_permission_ind => x_special_permission_ind,
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_ss_enrol_ind => X_SS_ENROL_IND,
x_ivr_enrol_ind => X_IVR_ENROL_IND,
x_rev_account_cd => x_rev_account_cd,
x_claimable_hours => x_claimable_hours,
x_anon_unit_grading_ind => x_anon_unit_grading_ind ,
x_anon_assess_grading_ind => x_anon_assess_grading_ind,
x_auditable_ind => x_auditable_ind,
x_audit_permission_ind => x_audit_permission_ind,
x_max_auditors_allowed => x_max_auditors_allowed,
x_billing_credit_points => x_billing_credit_points,
x_ovrd_wkld_val_flag => x_ovrd_wkld_val_flag ,
x_workload_val_code => x_workload_val_code,
x_billing_hrs => x_billing_hrs
);
update IGS_PS_UNIT_VER_ALL set
START_DT = NEW_REFERENCES.START_DT,
REVIEW_DT = NEW_REFERENCES.REVIEW_DT,
EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
END_DT = NEW_REFERENCES.END_DT,
UNIT_STATUS = NEW_REFERENCES.UNIT_STATUS,
TITLE = NEW_REFERENCES.TITLE,
SHORT_TITLE = NEW_REFERENCES.SHORT_TITLE,
TITLE_OVERRIDE_IND = NEW_REFERENCES.TITLE_OVERRIDE_IND,
ABBREVIATION = NEW_REFERENCES.ABBREVIATION,
UNIT_LEVEL = NEW_REFERENCES.UNIT_LEVEL,
CREDIT_POINT_DESCRIPTOR = NEW_REFERENCES.CREDIT_POINT_DESCRIPTOR,
ENROLLED_CREDIT_POINTS = NEW_REFERENCES.ENROLLED_CREDIT_POINTS,
POINTS_OVERRIDE_IND = NEW_REFERENCES.POINTS_OVERRIDE_IND,
SUPP_EXAM_PERMITTED_IND = NEW_REFERENCES.SUPP_EXAM_PERMITTED_IND,
COORD_PERSON_ID = NEW_REFERENCES.COORD_PERSON_ID,
OWNER_ORG_UNIT_CD = NEW_REFERENCES.OWNER_ORG_UNIT_CD,
OWNER_OU_START_DT = NEW_REFERENCES.OWNER_OU_START_DT,
AWARD_COURSE_ONLY_IND = NEW_REFERENCES.AWARD_COURSE_ONLY_IND,
RESEARCH_UNIT_IND = NEW_REFERENCES.RESEARCH_UNIT_IND,
INDUSTRIAL_IND = NEW_REFERENCES.INDUSTRIAL_IND,
PRACTICAL_IND = NEW_REFERENCES.PRACTICAL_IND,
REPEATABLE_IND = NEW_REFERENCES.REPEATABLE_IND,
ASSESSABLE_IND = NEW_REFERENCES.ASSESSABLE_IND,
ACHIEVABLE_CREDIT_POINTS = NEW_REFERENCES.ACHIEVABLE_CREDIT_POINTS,
POINTS_INCREMENT = NEW_REFERENCES.POINTS_INCREMENT,
POINTS_MIN = NEW_REFERENCES.POINTS_MIN,
POINTS_MAX = NEW_REFERENCES.POINTS_MAX,
UNIT_INT_COURSE_LEVEL_CD = NEW_REFERENCES.UNIT_INT_COURSE_LEVEL_CD,
SUBTITLE_MODIFIABLE_FLAG = NEW_REFERENCES.SUBTITLE_MODIFIABLE_FLAG,
APPROVAL_DATE = NEW_REFERENCES.APPROVAL_DATE,
LECTURE_CREDIT_POINTS = NEW_REFERENCES.LECTURE_CREDIT_POINTS,
LAB_CREDIT_POINTS = NEW_REFERENCES.LAB_CREDIT_POINTS,
OTHER_CREDIT_POINTS = NEW_REFERENCES.OTHER_CREDIT_POINTS,
CLOCK_HOURS = NEW_REFERENCES.CLOCK_HOURS,
WORK_LOAD_CP_LECTURE = NEW_REFERENCES.WORK_LOAD_CP_LECTURE,
WORK_LOAD_CP_LAB = NEW_REFERENCES.WORK_LOAD_CP_LAB,
CONTINUING_EDUCATION_UNITS = NEW_REFERENCES.CONTINUING_EDUCATION_UNITS,
ENROLLMENT_EXPECTED = NEW_REFERENCES.ENROLLMENT_EXPECTED,
ENROLLMENT_MINIMUM = NEW_REFERENCES.ENROLLMENT_MINIMUM,
ENROLLMENT_MAXIMUM = NEW_REFERENCES.ENROLLMENT_MAXIMUM,
ADVANCE_MAXIMUM = NEW_REFERENCES.ADVANCE_MAXIMUM,
STATE_FINANCIAL_AID = NEW_REFERENCES.STATE_FINANCIAL_AID,
FEDERAL_FINANCIAL_AID = NEW_REFERENCES.FEDERAL_FINANCIAL_AID,
INSTITUTIONAL_FINANCIAL_AID = NEW_REFERENCES.INSTITUTIONAL_FINANCIAL_AID,
SAME_TEACHING_PERIOD = NEW_REFERENCES.SAME_TEACHING_PERIOD,
MAX_REPEATS_FOR_CREDIT = NEW_REFERENCES.MAX_REPEATS_FOR_CREDIT,
MAX_REPEATS_FOR_FUNDING = NEW_REFERENCES.MAX_REPEATS_FOR_FUNDING,
MAX_REPEAT_CREDIT_POINTS = NEW_REFERENCES.MAX_REPEAT_CREDIT_POINTS,
SAME_TEACH_PERIOD_REPEATS = NEW_REFERENCES.SAME_TEACH_PERIOD_REPEATS,
SAME_TEACH_PERIOD_REPEATS_CP = NEW_REFERENCES.SAME_TEACH_PERIOD_REPEATS_CP,
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,
subtitle_id = new_references.subtitle_id,
work_load_other = new_references.work_load_other ,
contact_hrs_lecture = new_references.contact_hrs_lecture,
contact_hrs_lab = new_references.contact_hrs_lab,
contact_hrs_other = new_references.contact_hrs_other,
non_schd_required_hrs = new_references.non_schd_required_hrs,
exclude_from_max_cp_limit = new_references.exclude_from_max_cp_limit,
record_exclusion_flag = new_references.record_exclusion_flag,
ss_display_ind = new_references.ss_display_ind,
cal_type_enrol_load_cal = new_references.cal_type_enrol_load_cal,
sequence_num_enrol_load_cal = new_references.sequence_num_enrol_load_cal,
cal_type_offer_load_cal = new_references.cal_type_offer_load_cal,
sequence_num_offer_load_cal = new_references.sequence_num_offer_load_cal,
curriculum_id = new_references.curriculum_id,
override_enrollment_max = new_references.override_enrollment_max,
rpt_fmly_id = new_references.rpt_fmly_id,
unit_type_id = new_references.unit_type_id,
special_permission_ind = new_references.special_permission_ind,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
SS_ENROL_IND = NEW_REFERENCES.SS_ENROL_IND,
IVR_ENROL_IND = NEW_REFERENCES.IVR_ENROL_IND,
rev_account_cd = new_references.rev_account_cd,
claimable_hours = new_references.claimable_hours,
anon_unit_grading_ind = new_references.anon_unit_grading_ind,
anon_assess_grading_ind = new_references.anon_assess_grading_ind,
auditable_ind = new_references.auditable_ind,
audit_permission_ind = new_references.audit_permission_ind,
max_auditors_allowed = new_references.max_auditors_allowed,
billing_credit_points = new_references.billing_credit_points,
ovrd_wkld_val_flag = new_references.ovrd_wkld_val_flag ,
workload_val_code = new_references.workload_val_code,
billing_hrs = new_references.billing_hrs
WHERE ROWID = X_ROWID;
p_action => 'UPDATE',
x_rowid => X_ROWID
);
END update_row;
cursor c1 is select rowid from IGS_PS_UNIT_VER_ALL
where UNIT_CD = X_UNIT_CD
and VERSION_NUMBER = X_VERSION_NUMBER;
INSERT_ROW(
X_ROWID,
X_UNIT_CD,
X_VERSION_NUMBER,
X_START_DT,
X_REVIEW_DT,
X_EXPIRY_DT,
X_END_DT,
X_UNIT_STATUS,
X_TITLE,
X_SHORT_TITLE,
X_TITLE_OVERRIDE_IND,
X_ABBREVIATION,
X_UNIT_LEVEL,
X_CREDIT_POINT_DESCRIPTOR,
X_ENROLLED_CREDIT_POINTS,
X_POINTS_OVERRIDE_IND,
X_SUPP_EXAM_PERMITTED_IND,
X_COORD_PERSON_ID,
X_OWNER_ORG_UNIT_CD,
X_OWNER_OU_START_DT,
X_AWARD_COURSE_ONLY_IND,
X_RESEARCH_UNIT_IND,
X_INDUSTRIAL_IND,
X_PRACTICAL_IND,
X_REPEATABLE_IND,
X_ASSESSABLE_IND,
X_ACHIEVABLE_CREDIT_POINTS,
X_POINTS_INCREMENT,
X_POINTS_MIN,
X_POINTS_MAX,
X_UNIT_INT_COURSE_LEVEL_CD,
X_SUBTITLE,
X_SUBTITLE_MODIFIABLE_FLAG,
X_APPROVAL_DATE,
X_LECTURE_CREDIT_POINTS,
X_LAB_CREDIT_POINTS,
X_OTHER_CREDIT_POINTS,
X_CLOCK_HOURS,
X_WORK_LOAD_CP_LECTURE,
X_WORK_LOAD_CP_LAB,
X_CONTINUING_EDUCATION_UNITS,
X_ENROLLMENT_EXPECTED,
X_ENROLLMENT_MINIMUM,
X_ENROLLMENT_MAXIMUM,
X_ADVANCE_MAXIMUM,
X_STATE_FINANCIAL_AID,
X_FEDERAL_FINANCIAL_AID,
X_INSTITUTIONAL_FINANCIAL_AID,
X_SAME_TEACHING_PERIOD,
X_MAX_REPEATS_FOR_CREDIT,
X_MAX_REPEATS_FOR_FUNDING,
X_MAX_REPEAT_CREDIT_POINTS,
X_SAME_TEACH_PERIOD_REPEATS,
X_SAME_TEACH_PERIOD_REPEATS_CP,
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_SUBTITLE_ID,
x_work_load_other,
x_contact_hrs_lecture,
x_contact_hrs_lab,
x_contact_hrs_other,
x_non_schd_required_hrs,
x_exclude_from_max_cp_limit,
x_record_exclusion_flag,
x_ss_display_ind,
x_cal_type_enrol_load_cal,
x_sequence_num_enrol_load_cal,
x_cal_type_offer_load_cal,
x_sequence_num_offer_load_cal,
x_curriculum_id,
x_override_enrollment_max,
x_rpt_fmly_id,
x_unit_type_id,
x_special_permission_ind,
X_MODE,
X_ORG_ID,
X_SS_ENROL_IND,
X_IVR_ENROL_IND,
x_rev_account_cd,
x_claimable_hours,
x_anon_unit_grading_ind,
x_anon_assess_grading_ind,
x_auditable_ind,
x_audit_permission_ind,
x_max_auditors_allowed,
x_billing_credit_points,
x_ovrd_wkld_val_flag,
x_workload_val_code,
x_billing_hrs
);
UPDATE_ROW (
X_ROWID,
X_UNIT_CD,
X_VERSION_NUMBER,
X_START_DT,
X_REVIEW_DT,
X_EXPIRY_DT,
X_END_DT,
X_UNIT_STATUS,
X_TITLE,
X_SHORT_TITLE,
X_TITLE_OVERRIDE_IND,
X_ABBREVIATION,
X_UNIT_LEVEL,
X_CREDIT_POINT_DESCRIPTOR,
X_ENROLLED_CREDIT_POINTS,
X_POINTS_OVERRIDE_IND,
X_SUPP_EXAM_PERMITTED_IND,
X_COORD_PERSON_ID,
X_OWNER_ORG_UNIT_CD,
X_OWNER_OU_START_DT,
X_AWARD_COURSE_ONLY_IND,
X_RESEARCH_UNIT_IND,
X_INDUSTRIAL_IND,
X_PRACTICAL_IND,
X_REPEATABLE_IND,
X_ASSESSABLE_IND,
X_ACHIEVABLE_CREDIT_POINTS,
X_POINTS_INCREMENT,
X_POINTS_MIN,
X_POINTS_MAX,
X_UNIT_INT_COURSE_LEVEL_CD,
X_SUBTITLE,
X_SUBTITLE_MODIFIABLE_FLAG,
X_APPROVAL_DATE,
X_LECTURE_CREDIT_POINTS,
X_LAB_CREDIT_POINTS,
X_OTHER_CREDIT_POINTS,
X_CLOCK_HOURS,
X_WORK_LOAD_CP_LECTURE,
X_WORK_LOAD_CP_LAB,
X_CONTINUING_EDUCATION_UNITS,
X_ENROLLMENT_EXPECTED,
X_ENROLLMENT_MINIMUM,
X_ENROLLMENT_MAXIMUM,
X_ADVANCE_MAXIMUM,
X_STATE_FINANCIAL_AID,
X_FEDERAL_FINANCIAL_AID,
X_INSTITUTIONAL_FINANCIAL_AID,
X_SAME_TEACHING_PERIOD,
X_MAX_REPEATS_FOR_CREDIT,
X_MAX_REPEATS_FOR_FUNDING,
X_MAX_REPEAT_CREDIT_POINTS,
X_SAME_TEACH_PERIOD_REPEATS,
X_SAME_TEACH_PERIOD_REPEATS_CP,
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_SUBTITLE_ID,
x_work_load_other,
x_contact_hrs_lecture,
x_contact_hrs_lab,
x_contact_hrs_other,
x_non_schd_required_hrs,
x_exclude_from_max_cp_limit,
x_record_exclusion_flag,
x_ss_display_ind,
x_cal_type_enrol_load_cal,
x_sequence_num_enrol_load_cal,
x_cal_type_offer_load_cal,
x_sequence_num_offer_load_cal,
x_curriculum_id,
x_override_enrollment_max,
x_rpt_fmly_id,
x_unit_type_id,
x_special_permission_ind,
X_MODE,
X_SS_ENROL_IND,
X_IVR_ENROL_IND,
x_rev_account_cd,
x_claimable_hours,
x_anon_unit_grading_ind,
x_anon_assess_grading_ind,
x_auditable_ind,
x_audit_permission_ind,
x_max_auditors_allowed,
x_billing_credit_points,
x_ovrd_wkld_val_flag,
x_workload_val_code,
x_billing_hrs
);
PROCEDURE delete_row (
X_ROWID in VARCHAR2
) AS
BEGIN
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);
delete from IGS_PS_UNIT_VER_ALL
where ROWID = X_ROWID
;
p_action => 'DELETE',
x_rowid => X_ROWID
);
END delete_row;
PROCEDURE update_row_subtitle_id(X_RowId IN VARCHAR2,X_Subtitle_Id IN NUMBER) AS
BEGIN
UPDATE IGS_PS_UNIT_VER_ALL set
subtitle_id = X_Subtitle_Id
WHERE ROWID = X_ROWID;
END update_row_subtitle_id;