The following lines contain the word 'select', 'insert', 'update' or 'delete':
smvk 09-Jul-2004 Bug # 3676145. Modified the cursor c_ucl to select active (not closed) unit classes.
********************************************************************************************** */
BEGIN
fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
SELECT unit_mode
FROM IGS_AS_UNIT_CLASS
WHERE unit_class = cp_unit_class
AND closed_ind = 'N';
SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
FROM IGS_PS_UNIT_OFR_OPT
WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = p_unit_cd AND
IGS_PS_UNIT_OFR_OPT.version_number = p_version_number AND
IGS_PS_UNIT_OFR_OPT.cal_type = p_cal_type AND
IGS_PS_UNIT_OFR_OPT.ci_sequence_number = p_ci_sequence_number AND
IGS_PS_UNIT_OFR_OPT.location_cd = p_location_cd AND
IGS_PS_UNIT_OFR_OPT.unit_class = p_unit_class;
SELECT IGS_PS_UNIT_OFR_OPT.uoo_id
FROM IGS_PS_UNIT_OFR_OPT
WHERE IGS_PS_UNIT_OFR_OPT.unit_cd = cp_unit_cd AND
IGS_PS_UNIT_OFR_OPT.version_number = cp_version_number AND
IGS_PS_UNIT_OFR_OPT.cal_type= cp_cal_type AND
IGS_PS_UNIT_OFR_OPT.ci_sequence_number = cp_ci_sequence_number AND
IGS_PS_UNIT_OFR_OPT.location_cd = cp_location_cd AND
IGS_PS_UNIT_OFR_OPT.unit_class = cp_unit_class;
SELECT *
FROM IGS_PS_UNIT_OFR_OPT
WHERE IGS_PS_UNIT_OFR_OPT.uoo_id = cp_uoo_id;
SELECT us.administrative_ind
FROM IGS_EN_UNIT_SET us
WHERE us.unit_set_cd = p_unit_set_cd AND
us.version_number = p_version_number;
SELECT uss.s_unit_set_status
FROM IGS_EN_UNIT_SET_STAT uss
WHERE uss.unit_set_status = p_unit_set_status;
gv_rec_inserted_cnt NUMBER(4);
v_none_uoo_uai_recs_inserted BOOLEAN ;
v_some_uoo_uai_recs_inserted BOOLEAN ;
v_all_uoo_uai_recs_inserted BOOLEAN ;
v_total_none_uoo_uai_inserted BOOLEAN ;
v_total_some_uoo_uai_inserted BOOLEAN ;
v_total_all_uoo_uai_inserted BOOLEAN ;
v_none_uop_recs_inserted BOOLEAN ;
v_some_uop_recs_inserted BOOLEAN ;
v_all_uop_recs_inserted BOOLEAN ;
v_uap_insert_error BOOLEAN ;
SELECT 'x'
FROM igs_ca_type
WHERE cal_type = p_source_cal_type;
SELECT *
FROM igs_ca_inst
WHERE cal_type = cp_cal_type
AND sequence_number = cp_sequence_number;
SELECT uop.unit_cd,
uop.version_number,
uop.cal_type,
uop.ci_sequence_number,
uop.ci_start_dt,
uop.ci_end_dt,
uop.waitlist_allowed,
uop.max_students_per_waitlist,
uop.delete_flag
FROM igs_ps_unit_ofr_pat uop,
igs_ps_unit_ver uv
WHERE uop.cal_type = p_source_cal_type
AND uop.ci_sequence_number = p_source_sequence_number
AND uv.unit_cd = uop.unit_cd
AND uv.version_number = uop.version_number
AND uv.expiry_dt IS NULL
AND uv.owner_org_unit_cd = NVL(p_org_unit,uv.owner_org_unit_cd)
AND uop.delete_flag = 'N';
SELECT 'x' FROM igs_ps_unit_ofr
WHERE unit_cd = cp_unit_cd
AND version_number = cp_version_number
AND cal_type = cp_dest_cal_type;
SELECT 'x'
FROM igs_ps_unit_ofr_pat
WHERE unit_cd = cp_unit_cd
AND version_number = cp_version_number
AND cal_type = p_dest_cal_type
AND ci_sequence_number = p_dest_sequence_number
AND delete_flag = 'N';
gv_rec_inserted_cnt := 0;
v_none_uoo_uai_recs_inserted := FALSE;
v_some_uoo_uai_recs_inserted := FALSE;
v_all_uoo_uai_recs_inserted := FALSE;
v_total_none_uoo_uai_inserted := FALSE;
v_total_some_uoo_uai_inserted := FALSE;
v_total_all_uoo_uai_inserted := FALSE;
v_none_uop_recs_inserted := FALSE;
v_some_uop_recs_inserted := FALSE;
v_all_uop_recs_inserted := FALSE;
v_uap_insert_error := FALSE;
v_uap_insert_error := FALSE;
igs_ps_unit_ofr_pat_pkg.Insert_Row(
x_rowid => x_rowid,
x_unit_cd => gv_uop_rec.unit_cd,
x_version_number => gv_uop_rec.version_number,
x_ci_sequence_number => p_dest_sequence_number,
x_cal_type => p_dest_cal_type,
x_ci_start_dt => gv_start_dt,
x_ci_end_dt => gv_end_dt,
x_waitlist_allowed => gv_uop_rec.waitlist_allowed,
x_max_students_per_waitlist => gv_uop_rec.max_students_per_waitlist,
x_mode => 'R',
x_org_id => p_org_id,
x_delete_flag => gv_uop_rec.delete_flag,
x_abort_flag => 'N');
gv_rec_inserted_cnt := gv_rec_inserted_cnt + 1;
v_none_uoo_uai_recs_inserted := TRUE;
v_some_uoo_uai_recs_inserted := TRUE;
v_some_uoo_uai_recs_inserted := TRUE;
v_uap_insert_error := TRUE;
v_all_uoo_uai_recs_inserted := TRUE;
v_all_uoo_uai_recs_inserted := TRUE;
v_uap_insert_error := TRUE;
v_none_uoo_uai_recs_inserted := TRUE;
v_some_uoo_uai_recs_inserted := TRUE;
v_some_uoo_uai_recs_inserted := TRUE;
v_uap_insert_error := TRUE;
IF ((v_none_uoo_uai_recs_inserted = TRUE AND
v_some_uoo_uai_recs_inserted = TRUE AND
v_all_uoo_uai_recs_inserted = TRUE) OR
(v_none_uoo_uai_recs_inserted = TRUE AND
v_some_uoo_uai_recs_inserted = TRUE AND
v_all_uoo_uai_recs_inserted = FALSE) OR
(v_none_uoo_uai_recs_inserted = TRUE AND
v_some_uoo_uai_recs_inserted = FALSE AND
v_all_uoo_uai_recs_inserted = TRUE) OR
(v_none_uoo_uai_recs_inserted = FALSE AND
v_some_uoo_uai_recs_inserted = TRUE AND
v_all_uoo_uai_recs_inserted = TRUE) OR
(v_none_uoo_uai_recs_inserted = FALSE AND
v_some_uoo_uai_recs_inserted = TRUE AND
v_all_uoo_uai_recs_inserted = FALSE)) THEN
v_total_some_uoo_uai_inserted := TRUE;
ELSIF ((v_none_uoo_uai_recs_inserted = TRUE AND
v_some_uoo_uai_recs_inserted = FALSE AND
v_all_uoo_uai_recs_inserted = FALSE) OR
(v_none_uoo_uai_recs_inserted = FALSE AND
v_some_uoo_uai_recs_inserted = FALSE AND
v_all_uoo_uai_recs_inserted = FALSE)) THEN
v_total_none_uoo_uai_inserted := TRUE;
ELSIF ( v_none_uoo_uai_recs_inserted = FALSE AND
v_some_uoo_uai_recs_inserted = FALSE AND
v_all_uoo_uai_recs_inserted = TRUE) THEN
v_total_all_uoo_uai_inserted := TRUE;
IF (gv_rec_inserted_cnt = 0) THEN
v_none_uop_recs_inserted := TRUE;
ELSIF (gv_rec_inserted_cnt = gc_unit_offering_pattern%ROWCOUNT) THEN
v_all_uop_recs_inserted := TRUE;
v_some_uop_recs_inserted := TRUE;
IF v_none_uop_recs_inserted = TRUE THEN
IF v_total_none_uoo_uai_inserted = TRUE THEN
IF v_uoo_uai_error_flag = FALSE THEN
v_message := 'IGS_PS_NO_UOP_UO_UAI';
ELSIF v_total_some_uoo_uai_inserted = TRUE THEN
IF v_uoo_uai_error_flag = FALSE THEN
IF v_uap_insert_error = FALSE THEN
v_message := 'IGS_PS_PAR_ROLL_UOP_UO_UAI';
IF v_uap_insert_error = FALSE THEN
v_message :='IGS_PS_NO_UOP_HAVE_BEEN_ROLL';
ELSIF v_total_all_uoo_uai_inserted = TRUE THEN
IF v_uap_insert_error = FALSE THEN
v_message := 'IGS_PS_PAR_ROLL_UOP_UO_UAI';
ELSIF v_some_uop_recs_inserted = TRUE THEN
IF v_total_none_uoo_uai_inserted = TRUE THEN
IF v_uoo_uai_error_flag = FALSE THEN
v_message := 'IGS_PS_PAR_ROLL_UOP_UO_UAI';
ELSIF v_total_some_uoo_uai_inserted = TRUE THEN
IF v_uoo_uai_error_flag = FALSE THEN
IF v_uap_insert_error = FALSE THEN
v_message := 'IGS_PS_PAR_ROLL_UOP_UO_UAI';
IF v_uap_insert_error = FALSE THEN
v_message :='IGS_PS_PAR_ROLL_UOP_UO_UAI';
ELSIF v_total_all_uoo_uai_inserted = TRUE THEN
IF v_uap_insert_error = FALSE THEN
v_message := 'IGS_PS_PAR_ROLL_UOP_UO_UAI';
ELSIF v_all_uop_recs_inserted = TRUE THEN
IF v_total_none_uoo_uai_inserted = TRUE THEN
IF v_uoo_uai_error_flag = FALSE THEN
v_message := 'IGS_PS_SUCCESSROLL_UOP_UO_UAI';
ELSIF v_total_some_uoo_uai_inserted = TRUE THEN
IF v_uoo_uai_error_flag = FALSE THEN
IF v_uap_insert_error = FALSE THEN
v_message := 'IGS_PS_SUCCESSROLL_UOP_UO_UAI';
IF v_uap_insert_error = FALSE THEN
v_message := 'IGS_PS_SUCCESSFUL_ROLL_UOP';
ELSIF v_total_all_uoo_uai_inserted = TRUE THEN
IF v_uap_insert_error = FALSE THEN
v_message := 'IGS_PS_SUCCESSROLL_UOP_UO_UAI';
p_new_update_who IN VARCHAR2 ,
p_old_update_who IN VARCHAR2 ,
p_new_update_on IN DATE ,
p_old_update_on IN DATE )
AS
lv_param_values VARCHAR2(1080);
v_hist_start_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
v_hist_end_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
v_hist_who IGS_EN_UNIT_SET.LAST_UPDATED_BY%TYPE;
SELECT ou.party_name description
FROM IGS_OR_INST_ORG_BASE_V ou
WHERE ou.party_number = p_old_responsible_org_unit_cd AND
ou.start_dt = p_old_responsible_ou_start_dt;
v_ush_rec.hist_start_dt := p_old_update_on;
v_ush_rec.hist_end_dt := p_new_update_on;
v_ush_rec.hist_who := p_old_update_who;
IGS_EN_UNIT_SET_HIST_PKG.Insert_Row(
X_ROWID => x_rowid,
X_UNIT_SET_CD => v_ush_rec.unit_set_cd,
X_VERSION_NUMBER => v_ush_rec.version_number,
X_HIST_START_DT => v_ush_rec.hist_start_dt,
X_HIST_END_DT => v_ush_rec.hist_end_dt,
X_HIST_WHO => v_ush_rec.hist_who,
X_UNIT_SET_STATUS => v_ush_rec.unit_set_status,
X_UNIT_SET_CAT => v_ush_rec.unit_set_cat,
X_START_DT => v_ush_rec.start_dt,
X_REVIEW_DT => v_ush_rec.review_dt,
X_EXPIRY_DT => v_ush_rec.expiry_dt,
X_END_DT => v_ush_rec.end_dt,
X_TITLE => v_ush_rec.title,
X_SHORT_TITLE => v_ush_rec.short_title,
X_ABBREVIATION => v_ush_rec.abbreviation,
X_RESPONSIBLE_ORG_UNIT_CD=> v_ush_rec.responsible_org_unit_cd,
X_RESPONSIBLE_OU_START_DT=> v_ush_rec.responsible_ou_start_dt,
X_OU_DESCRIPTION => v_ush_rec.ou_description,
X_ADMINISTRATIVE_IND => v_ush_rec.administrative_ind,
X_AUTHORISATION_RQRD_IND => v_ush_rec.authorisation_rqrd_ind,
X_MODE => 'R',
X_ORG_ID => l_org_id);
p_new_update_who||','||p_old_update_who||','||
fnd_date.date_to_displaydate(p_new_update_on)||','||fnd_date.date_to_displaydate(p_old_update_on);
p_last_update_on IN DATE ,
p_update_on IN DATE ,
p_last_update_who IN VARCHAR2 ,
p_start_dt IN DATE ,
p_review_dt IN DATE ,
p_expiry_dt IN DATE ,
p_end_dt IN DATE ,
p_unit_status IN VARCHAR2 ,
p_title IN VARCHAR2 ,
p_short_title IN VARCHAR2 ,
p_title_override_ind IN VARCHAR2 ,
p_abbreviation IN VARCHAR2 ,
p_unit_level IN VARCHAR2 ,
p_credit_point_descriptor IN VARCHAR2 ,
p_achievable_credit_points IN NUMBER ,
p_enrolled_credit_points IN NUMBER ,
p_supp_exam_permitted_ind IN VARCHAR2 ,
p_points_increment IN NUMBER ,
p_points_min IN NUMBER ,
p_points_max IN NUMBER ,
p_points_override_ind IN VARCHAR2 ,
p_coord_person_id IN NUMBER ,
p_owner_org_unit_cd IN VARCHAR2 ,
p_owner_ou_start_dt IN DATE ,
p_award_course_only_ind IN VARCHAR2 ,
p_research_unit_ind IN VARCHAR2 ,
p_industrial_ind IN VARCHAR2 ,
p_practical_ind IN VARCHAR2 ,
p_repeatable_ind IN VARCHAR2 ,
p_assessable_ind IN VARCHAR2 ,
p_unit_int_course_level_cd IN VARCHAR2,
p_ss_enrol_ind IN VARCHAR2 ,
p_ivr_enrol_ind IN VARCHAR2 ,
-- Added by rbezawad as per PSP001-US DLD on 24-May-2001
p_advance_maximum IN NUMBER,
p_approval_date IN DATE,
p_cal_type_enrol_load_cal IN VARCHAR2,
p_cal_type_offer_load_cal IN VARCHAR2,
p_clock_hours IN NUMBER,
p_contact_hrs_lab IN NUMBER,
p_contact_hrs_lecture IN NUMBER,
p_contact_hrs_other IN NUMBER,
p_continuing_education_units IN NUMBER,
p_curriculum_id IN VARCHAR2 ,
p_enrollment_expected IN NUMBER,
p_enrollment_maximum IN NUMBER,
p_enrollment_minimum IN NUMBER,
p_exclude_from_max_cp_limit IN VARCHAR2 ,
p_federal_financial_aid IN VARCHAR2 ,
p_institutional_financial_aid IN VARCHAR2 ,
p_lab_credit_points IN NUMBER,
p_lecture_credit_points IN NUMBER,
p_max_repeat_credit_points IN NUMBER,
p_max_repeats_for_credit IN NUMBER,
p_max_repeats_for_funding IN NUMBER,
p_non_schd_required_hrs IN NUMBER,
p_other_credit_points IN NUMBER,
p_override_enrollment_max IN NUMBER,
p_record_exclusion_flag IN VARCHAR2 ,
p_ss_display_ind IN VARCHAR2 ,
p_rpt_fmly_id IN NUMBER,
p_same_teach_period_repeats IN NUMBER ,
p_same_teach_period_repeats_cp IN NUMBER,
p_same_teaching_period IN VARCHAR2,
p_sequence_num_enrol_load_cal IN NUMBER,
p_sequence_num_offer_load_cal IN NUMBER,
p_special_permission_ind IN VARCHAR2 ,
p_state_financial_aid IN VARCHAR2 ,
p_subtitle_id IN NUMBER,
p_subtitle_modifiable_flag IN VARCHAR2 ,
p_unit_type_id IN NUMBER,
p_work_load_cp_lab IN NUMBER,
p_work_load_cp_lecture IN NUMBER,
p_work_load_other IN NUMBER,
p_claimable_hours IN NUMBER ,
p_auditable_ind IN VARCHAR2,
p_audit_permission_ind IN VARCHAR2,
p_max_auditors_allowed IN NUMBER,
p_billing_credit_points IN NUMBER,
p_ovrd_wkld_val_flag IN VARCHAR2,
p_workload_val_code IN VARCHAR2,
p_billing_hrs IN NUMBER )
AS
lv_param_values VARCHAR2(1080);
SELECT description
FROM IGS_PS_UNIT_LEVEL
WHERE unit_level = cp_unit_level;
SELECT party_name description
FROM IGS_OR_INST_ORG_BASE_V
WHERE party_number = cp_org_unit_cd AND
start_dt = cp_start_dt;
SELECT description
FROM IGS_PS_UNIT_INT_LVL
WHERE unit_int_course_level_cd = cp_unit_int_course_level_cd;
SELECT level_code
FROM IGS_PS_UNIT_TYPE_LVL
WHERE UNIT_TYPE_ID = cp_unit_type_id;
SELECT repeat_code
FROM IGS_PS_RPT_FMLY_ALL
WHERE RPT_FMLY_ID= cp_rpt_fmly_id;
SELECT subtitle
FROM igs_ps_unit_subtitle
WHERE subtitle_id = cp_subtitle_id;
IGS_PS_UNIT_VER_HIST_PKG.Insert_Row(
X_ROWID => x_rowid,
X_UNIT_CD => p_unit_cd,
X_VERSION_NUMBER => p_version_number,
X_HIST_START_DT => p_last_update_on,
X_HIST_END_DT => p_update_on,
X_HIST_WHO => p_last_update_who,
X_START_DT => p_start_dt,
X_REVIEW_DT => p_review_dt,
X_EXPIRY_DT => p_expiry_dt,
X_END_DT => p_end_dt,
X_UNIT_STATUS => p_unit_status,
X_TITLE => p_title,
X_SHORT_TITLE => p_short_title,
X_TITLE_OVERRIDE_IND => p_title_override_ind,
X_ABBREVIATION => p_abbreviation,
X_UNIT_LEVEL => p_unit_level,
X_UL_DESCRIPTION => v_ul_description,
X_CREDIT_POINT_DESCRIPTOR => p_credit_point_descriptor,
X_ENROLLED_CREDIT_POINTS => p_enrolled_credit_points,
X_POINTS_OVERRIDE_IND => p_points_override_ind,
X_SUPP_EXAM_PERMITTED_IND => p_supp_exam_permitted_ind,
X_COORD_PERSON_ID => p_coord_person_id,
X_OWNER_ORG_UNIT_CD => p_owner_org_unit_cd,
X_OWNER_OU_START_DT => p_owner_ou_start_dt,
X_OU_DESCRIPTION => v_ou_description,
X_AWARD_COURSE_ONLY_IND => p_award_course_only_ind,
X_RESEARCH_UNIT_IND => p_research_unit_ind,
X_INDUSTRIAL_IND => p_industrial_ind,
X_PRACTICAL_IND => p_practical_ind,
X_REPEATABLE_IND => p_repeatable_ind,
X_ASSESSABLE_IND => p_assessable_ind,
X_ACHIEVABLE_CREDIT_POINTS => p_achievable_credit_points,
X_POINTS_INCREMENT => p_points_increment,
X_POINTS_MIN => p_points_min,
X_POINTS_MAX => p_points_max,
X_UNIT_INT_COURSE_LEVEL_CD => p_unit_int_course_level_cd,
X_UICL_DESCRIPTION => v_uicl_description,
X_MODE => 'R',
X_ORG_ID => l_org_id,
X_SS_ENROL_IND => p_ss_enrol_ind,
X_IVR_ENROL_IND => p_ivr_enrol_ind,
-- Added By rbezawad as per PSP001-US DLD on 24-May-2001
X_ADVANCE_MAXIMUM => p_advance_maximum,
X_APPROVAL_DATE => p_approval_date,
X_CAL_TYPE_ENROL_LOAD_CAL => p_cal_type_enrol_load_cal,
X_CAL_TYPE_OFFER_LOAD_CAL => p_cal_type_offer_load_cal,
X_CLOCK_HOURS => p_clock_hours,
X_CONTACT_HRS_LAB => p_contact_hrs_lab,
X_CONTACT_HRS_LECTURE => p_contact_hrs_lecture,
X_CONTACT_HRS_OTHER => p_contact_hrs_other,
X_CONTINUING_EDUCATION_UNITS => p_continuing_education_units,
X_CURRICULUM_ID => p_curriculum_id,
X_ENROLLMENT_EXPECTED => p_enrollment_expected,
X_ENROLLMENT_MAXIMUM => p_enrollment_maximum,
X_ENROLLMENT_MINIMUM => p_enrollment_minimum,
X_EXCLUDE_FROM_MAX_CP_LIMIT => p_exclude_from_max_cp_limit,
X_FEDERAL_FINANCIAL_AID => p_federal_financial_aid,
X_INSTITUTIONAL_FINANCIAL_AID => p_institutional_financial_aid,
X_LAB_CREDIT_POINTS => p_lab_credit_points,
X_LECTURE_CREDIT_POINTS => p_lecture_credit_points,
X_LEVEL_CODE => v_level_code,
X_MAX_REPEAT_CREDIT_POINTS => p_max_repeat_credit_points,
X_MAX_REPEATS_FOR_CREDIT => p_max_repeats_for_credit,
X_MAX_REPEATS_FOR_FUNDING => p_max_repeats_for_funding,
X_NON_SCHD_REQUIRED_HRS => p_non_schd_required_hrs,
X_OTHER_CREDIT_POINTS => p_other_credit_points,
X_OVERRIDE_ENROLLMENT_MAX => p_override_enrollment_max,
X_RECORD_EXCLUSION_FLAG => p_record_exclusion_flag,
X_SS_DISPLAY_IND => p_ss_display_ind,
X_REPEAT_CODE => v_repeat_code,
X_RPT_FMLY_ID => p_rpt_fmly_id,
X_SAME_TEACH_PERIOD_REPEATS => p_same_teach_period_repeats,
X_SAME_TEACH_PERIOD_REPEATS_CP => p_same_teach_period_repeats_cp,
X_SAME_TEACHING_PERIOD => p_same_teaching_period,
X_SEQUENCE_NUM_ENROL_LOAD_CAL => p_sequence_num_enrol_load_cal,
X_SEQUENCE_NUM_OFFER_LOAD_CAL => p_sequence_num_offer_load_cal,
X_SPECIAL_PERMISSION_IND => p_special_permission_ind,
X_STATE_FINANCIAL_AID => p_state_financial_aid,
X_SUBTITLE => v_subtitle,
X_SUBTITLE_ID => p_subtitle_id,
X_SUBTITLE_MODIFIABLE_FLAG => p_subtitle_modifiable_flag,
X_UNIT_TYPE_ID => p_unit_type_id,
X_WORK_LOAD_CP_LAB => p_work_load_cp_lab,
X_WORK_LOAD_CP_LECTURE => p_work_load_cp_lecture,
X_WORK_LOAD_OTHER => p_work_load_other,
x_claimable_hours => p_claimable_hours ,
x_auditable_ind => p_auditable_ind,
x_audit_permission_ind => p_audit_permission_ind,
x_max_auditors_allowed => p_max_auditors_allowed,
x_billing_credit_points => p_billing_credit_points,
x_ovrd_wkld_val_flag => p_ovrd_wkld_val_flag,
x_workload_val_code => p_workload_val_code,
x_billing_hrs => p_billing_hrs);
lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||fnd_date.date_to_displaydate(p_last_update_on)||','||fnd_date.date_to_displaydate(p_update_on)||','
||p_last_update_who||','
||fnd_date.date_to_displaydate(p_start_dt)||','||fnd_date.date_to_displaydate(p_review_dt)||','||fnd_date.date_to_displaydate(p_expiry_dt)||','
||fnd_date.date_to_displaydate(p_end_dt)||','||p_unit_status||','||p_title||','||p_short_title||
','||p_title_override_ind||','||p_abbreviation||','||p_unit_level||','||
p_credit_point_descriptor||','||to_char(p_achievable_credit_points)||','||
to_char(p_enrolled_credit_points)||','||p_supp_exam_permitted_ind||','||
to_char(p_points_increment)||','||to_char(p_points_min)||','||to_char(p_points_max)
||','||p_points_override_ind ||','||to_char(p_coord_person_id )||','|| p_owner_org_unit_cd
||','||fnd_date.date_to_displaydate(p_owner_ou_start_dt)||','||p_award_course_only_ind ||','||p_research_unit_ind
||','|| p_industrial_ind
||','||p_practical_ind||','||p_repeatable_ind||','||p_assessable_ind||','||p_unit_int_course_level_cd||','||TO_CHAR(p_billing_credit_points)||','||p_ovrd_wkld_val_flag||','||p_workload_val_code
||',' || to_char(p_billing_hrs);