[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_last_update_on IN DATE ,
p_update_on IN DATE ,
p_last_update_who IN VARCHAR2 ,
p_dflt_ind IN VARCHAR2,
p_restricted_ind IN VARCHAR2 )
AS
CURSOR c_course_status(
cp_course_cd IGS_PS_VER.course_cd%TYPE,
cp_version_number IGS_PS_VER.version_number%TYPE) IS
SELECT IGS_PS_STAT.s_course_status
FROM IGS_PS_STAT,IGS_PS_VER
WHERE IGS_PS_VER.course_cd = cp_course_cd AND
IGS_PS_VER.version_number = cp_version_number AND
IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
IGS_FI_FD_SRC_RSTN_H_pkg.Insert_Row(
X_ROWID => x_rowid,
X_COURSE_CD => p_course_cd,
X_HIST_START_DT => p_last_update_on,
X_VERSION_NUMBER => p_version_number,
X_FUNDING_SOURCE => p_funding_source,
X_HIST_END_DT => p_update_on,
X_HIST_WHO => p_last_update_who,
X_DFLT_IND => p_dflt_ind,
X_RESTRICTED_IND => p_restricted_ind,
X_MODE => 'R',
X_ORG_ID => l_org_id);
SELECT 'x'
FROM IGS_PS_UNIT_OFR_OPT uoo
WHERE uoo.cal_type = p_cal_type AND
uoo.ci_sequence_number = p_ci_sequence_number AND
uoo.call_number = p_call_number;
SELECT enr_dl_offset_cons_id FROM igs_en_dl_offset_cons
WHERE non_std_usec_dls_id = p_setup_id
AND deadline_type = 'E';
SELECT disc_dl_cons_id FROM igs_en_disc_dl_cons
WHERE non_std_disc_dl_stp_id = p_setup_id ;
SELECT UNIT_SECTION_START_DATE, UNIT_SECTION_END_DATE
FROM igs_ps_unit_ofr_opt_all
WHERE uoo_id = p_v_uoo_id;
SELECT
DISTINCT cv.alias_val
FROM
igs_ca_inst ci,
igs_ca_type ct,
igs_ca_stat cs,
igs_ca_da_inst_v cv
WHERE
ci.cal_type = ct.cal_type AND
ct.s_cal_cat = 'HOLIDAY' AND
ci.cal_status = cs.cal_status AND
cs.s_cal_status = 'ACTIVE' AND
ci.cal_type = cv.cal_type AND
ci.sequence_number = cv.ci_sequence_number AND
ci.start_dt < cp_d_end_dt AND
ci.end_dt > cp_d_start_dt AND
(cv.alias_val BETWEEN cp_d_start_dt AND cp_d_end_dt);
select 'TRUE'
from igs_ps_usec_occurs_v
where uoo_id = p_v_uoo_id and
monday = 'Y';
select 'TRUE'
from igs_ps_usec_occurs_v
where uoo_id = p_v_uoo_id and
tuesday = 'Y';
select 'TRUE'
from igs_ps_usec_occurs_v
where uoo_id = p_v_uoo_id and
wednesday = 'Y';
select 'TRUE'
from igs_ps_usec_occurs_v
where uoo_id = p_v_uoo_id and
thursday = 'Y';
select 'TRUE'
from igs_ps_usec_occurs_v
where uoo_id = p_v_uoo_id and
friday = 'Y';
select 'TRUE'
from igs_ps_usec_occurs_v
where uoo_id = p_v_uoo_id and
saturday = 'Y';
select 'TRUE'
from igs_ps_usec_occurs_v
where uoo_id = p_v_uoo_id and
sunday = 'Y';
SELECT start_date,end_date,to_be_announced,monday, tuesday,wednesday,thursday,friday,saturday,sunday
FROM igs_ps_usec_occurs
WHERE uoo_id=p_v_uoo_id
AND NO_SET_DAY_IND = 'N';
SELECT ci.start_dt, ci.end_dt
FROM igs_ca_inst_all ci,
igs_ps_unit_ofr_opt_all uoo
WHERE uoo.uoo_id = cp_n_uoo_id
AND uoo.cal_type = ci.cal_type
AND uoo.ci_sequence_number = ci.sequence_number;
SELECT incl_wkend_duration_flag
FROM igs_en_nsu_dlstp_all
WHERE non_std_usec_dls_id = cp_n_id;
SELECT incl_wkend_duration_flag
FROM igs_en_nsd_dlstp_all
WHERE non_std_disc_dl_stp_id = cp_n_id;
plsql_meet_days.DELETE; --Initialization
plsql_meet_days_temp.DELETE;
plsql_date_tab.DELETE;
SELECT ceil((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
SELECT round((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
SELECT ceil((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
SELECT round((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
plsql_meet_days.delete;
SELECT ceil((meetingdays*offsetduration)/100) INTO offsetdays FROM dual;
SELECT round((meetingdays*offsetduration)/100) INTO offsetdays FROM dual;
SELECT daoc.OFFSET_CONS_TYPE_CD,
daoc.CONSTRAINT_CONDITION,
daoc.CONSTRAINT_RESOLUTION
FROM IGS_EN_DL_OFFSET_CONS daoc
WHERE daoc.NON_STD_USEC_DLS_ID = p_offset_cnstr_id --bug#5190760,replaced ENR_DL_OFFSET_CONS_ID with NON_STD_USEC_DLS_ID
AND daoc.deadline_type = p_deadline_type;
SELECT daoc.OFFSET_CONS_TYPE_CD,
daoc.CONSTRAINT_CONDITION,
daoc.CONSTRAINT_RESOLUTION
FROM IGS_EN_DISC_DL_CONS daoc
WHERE daoc.DISC_DL_CONS_ID = p_offset_cnstr_id;
SELECT TRUNC(max(dai.absolute_val)), TRUNC(min(dai.absolute_val))
FROM IGS_CA_DA_INST dai,
IGS_CA_INST ci,
IGS_CA_TYPE ct,
IGS_CA_STAT cs
WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
ct.S_CAL_CAT = cst_holiday AND
cs.s_cal_status = ci.CAL_STATUS AND
cs.s_cal_status = cst_active AND
dai.CAL_TYPE = ci.CAL_TYPE;
SELECT 'x'
FROM IGS_CA_TYPE ct
WHERE ct.S_CAL_CAT = cst_holiday AND
EXISTS (SELECT 'x'
FROM IGS_CA_INST ci,
IGS_CA_STAT cs
WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
ci.CAL_STATUS = cs.CAL_STATUS AND
cs.s_cal_status = cst_active AND
EXISTS (SELECT 'x'
FROM IGS_CA_DA_INST dai
WHERE dai.CAL_TYPE = ct.CAL_TYPE AND
TRUNC(dai.absolute_val)= cp_date_val));
SELECT TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
FROM IGS_CA_DA_INST dai1,
IGS_CA_DA_INST dai2,
IGS_CA_DA_INST_PAIR daip,
IGS_CA_INST ci,
IGS_CA_TYPE ct,
IGS_CA_STAT cs
WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
ct.S_CAL_CAT = cst_holiday AND
cs.cal_status = ci.CAL_STATUS AND
cs.s_cal_status = cst_active AND
dai1.CAL_TYPE = ci.CAL_TYPE AND
dai1.DT_ALIAS = daip.DT_ALIAS AND
dai1.sequence_number = daip.dai_sequence_number AND
dai1.CAL_TYPE = daip.CAL_TYPE AND
dai1.ci_sequence_number = daip.ci_sequence_number AND
dai2.DT_ALIAS = daip.related_dt_alias AND
dai2.sequence_number = daip.related_dai_sequence_number AND
dai2.CAL_TYPE = daip.related_cal_type AND
dai2.ci_sequence_number = daip.related_ci_sequence_number;
SELECT 'x'
FROM IGS_CA_TYPE ct
WHERE ct.S_CAL_CAT = cst_holiday AND
EXISTS (SELECT 'x'
FROM IGS_CA_INST ci,
IGS_CA_STAT cs
WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
ci.CAL_STATUS = cs.CAL_STATUS AND
cs.s_cal_status = cst_active AND
EXISTS (SELECT 'x'
FROM IGS_CA_DA_INST dai1,
IGS_CA_DA_INST dai2,
IGS_CA_DA_INST_PAIR daip
WHERE dai1.CAL_TYPE = ct.CAL_TYPE AND
dai1.DT_ALIAS = daip.DT_ALIAS AND
dai1.sequence_number = daip.dai_sequence_number AND
dai1.CAL_TYPE = daip.CAL_TYPE AND
dai1.ci_sequence_number = daip.ci_sequence_number AND
dai2.DT_ALIAS = daip.related_dt_alias AND
dai2.sequence_number = daip.related_dai_sequence_number AND
dai2.CAL_TYPE = daip.related_cal_type AND
dai2.ci_sequence_number = daip.related_ci_sequence_number AND
cp_date_val BETWEEN TRUNC(dai1.absolute_val) AND
TRUNC(dai2.absolute_val)));
SELECT cal_type,ci_sequence_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_uoo_id;
SELECT unit_section_end_date
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_uoo_id;
SELECT end_dt
FROM igs_ca_inst
WHERE cal_type=cp_cal_type
AND sequence_number=cp_seq_number;
SELECT a.unit_section_start_date,
NVL(a.unit_section_end_date,b.end_dt)
FROM igs_ps_unit_ofr_opt_all a,
igs_ca_inst_all b
WHERE a.uoo_id = cp_n_uoo_id
AND a.cal_type = b.cal_type
AND a.ci_sequence_number = b.sequence_number;
l_tab_holidays.DELETE;
SELECT start_date,end_date,to_be_announced,monday, tuesday,wednesday,thursday,friday,saturday,sunday
FROM igs_ps_usec_occurs
WHERE uoo_id=cp_n_uoo_id
AND NO_SET_DAY_IND = 'N';
l_temp_meeting_days.delete;
l_tab_holidays.delete(i);
SELECT DISTINCT ai.absolute_val
FROM igs_ca_da_inst ai,
igs_ca_inst_all ci,
igs_ca_type ct,
igs_ca_stat cs
WHERE ai.cal_type = ci.cal_type
AND ai.ci_sequence_number = ci.sequence_number
AND ci.cal_type = ct.cal_type
AND ct.s_cal_cat = 'HOLIDAY'
AND ci.CAL_STATUS = cs.CAL_STATUS
AND cs.S_CAL_STATUS = 'ACTIVE'
AND ct.closed_ind = 'N'
AND cs.closed_ind = 'N'
AND ci.start_dt < cp_d_end_dt
AND ci.end_dt > cp_d_start_dt
AND (ai.absolute_val between cp_d_start_dt AND cp_d_end_dt);
p_tab_holiday.delete;
SELECT non_std_usec_rtn_id
FROM igs_ps_nsus_rtn
WHERE definition_code = 'INSTITUTION'
AND ROWNUM <2 ;