[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT unit_section_occurrence_id
FROM igs_ps_usec_occurs
WHERE uoo_id = cp_uoo_id;
SELECT IGS_PS_USEC_WF_ITEM_KEY_S.NEXTVAL INTO l_key FROM dual;
PROCEDURE update_usec_occurs (p_usec_occur_id IN NUMBER)
------------------------------------------------------------------------------------
--Created by : smanglm ( Oracle IDC)
--Date created: 19-JUL-2001
--
--Purpose: local procedure update_usec_occurs for updating notify_status
-- local to wf_create_event
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
--smvk 25-jun-2003 Enh bug#2918094. Added column cancel_flag.
-------------------------------------------------------------------------------------
IS
--
-- cursor to get the usec details
--
CURSOR c_usec_details (cp_usec_occur_id igs_ps_usec_occurs.unit_section_occurrence_id%TYPE) IS
SELECT *
FROM igs_ps_usec_occurs
WHERE unit_section_occurrence_id = cp_usec_occur_id;
igs_ps_usec_occurs_pkg.update_row
(
X_ROWID => rec_usec_details.ROW_ID,
X_UNIT_SECTION_OCCURRENCE_ID => rec_usec_details.UNIT_SECTION_OCCURRENCE_ID,
X_UOO_ID => rec_usec_details.UOO_ID,
X_MONDAY => rec_usec_details.MONDAY,
X_TUESDAY => rec_usec_details.TUESDAY,
X_WEDNESDAY => rec_usec_details.WEDNESDAY,
X_THURSDAY => rec_usec_details.THURSDAY,
X_FRIDAY => rec_usec_details.FRIDAY,
X_SATURDAY => rec_usec_details.SATURDAY,
X_SUNDAY => rec_usec_details.SUNDAY,
X_START_TIME => rec_usec_details.START_TIME,
X_END_TIME => rec_usec_details.END_TIME,
X_BUILDING_CODE => rec_usec_details.BUILDING_CODE,
X_ROOM_CODE => rec_usec_details.ROOM_CODE,
X_SCHEDULE_STATUS => rec_usec_details.SCHEDULE_STATUS,
X_STATUS_LAST_UPDATED => rec_usec_details.STATUS_LAST_UPDATED,
X_INSTRUCTOR_ID => rec_usec_details.INSTRUCTOR_ID,
X_ATTRIBUTE_CATEGORY => rec_usec_details.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => rec_usec_details.ATTRIBUTE1,
X_ATTRIBUTE2 => rec_usec_details.ATTRIBUTE2,
X_ATTRIBUTE3 => rec_usec_details.ATTRIBUTE3,
X_ATTRIBUTE4 => rec_usec_details.ATTRIBUTE4,
X_ATTRIBUTE5 => rec_usec_details.ATTRIBUTE5,
X_ATTRIBUTE6 => rec_usec_details.ATTRIBUTE6,
X_ATTRIBUTE7 => rec_usec_details.ATTRIBUTE7,
X_ATTRIBUTE8 => rec_usec_details.ATTRIBUTE8,
X_ATTRIBUTE9 => rec_usec_details.ATTRIBUTE9,
X_ATTRIBUTE10 => rec_usec_details.ATTRIBUTE10,
X_ATTRIBUTE11 => rec_usec_details.ATTRIBUTE11,
X_ATTRIBUTE12 => rec_usec_details.ATTRIBUTE12,
X_ATTRIBUTE13 => rec_usec_details.ATTRIBUTE13,
X_ATTRIBUTE14 => rec_usec_details.ATTRIBUTE14,
X_ATTRIBUTE15 => rec_usec_details.ATTRIBUTE15,
X_ATTRIBUTE16 => rec_usec_details.ATTRIBUTE16,
X_ATTRIBUTE17 => rec_usec_details.ATTRIBUTE17,
X_ATTRIBUTE18 => rec_usec_details.ATTRIBUTE18,
X_ATTRIBUTE19 => rec_usec_details.ATTRIBUTE19,
X_ATTRIBUTE20 => rec_usec_details.ATTRIBUTE20,
X_ERROR_TEXT => rec_usec_details.ERROR_TEXT,
X_MODE => 'R',
X_START_DATE => rec_usec_details.START_DATE,
X_END_DATE => rec_usec_details.END_DATE,
X_TO_BE_ANNOUNCED => rec_usec_details.TO_BE_ANNOUNCED,
X_INST_NOTIFY_IND => rec_usec_details.INST_NOTIFY_IND,
X_NOTIFY_STATUS => l_cst_complete,
X_DEDICATED_BUILDING_CODE => rec_usec_details.DEDICATED_BUILDING_CODE,
X_DEDICATED_ROOM_CODE => rec_usec_details.DEDICATED_ROOM_CODE,
X_PREFERRED_BUILDING_CODE => rec_usec_details.PREFERRED_BUILDING_CODE,
X_PREFERRED_ROOM_CODE => rec_usec_details.PREFERRED_ROOM_CODE,
X_PREFERRED_REGION_CODE => rec_usec_details.PREFERRED_REGION_CODE,
X_NO_SET_DAY_IND => rec_usec_details.NO_SET_DAY_IND,
X_cancel_flag => rec_usec_details.cancel_flag,
x_occurrence_identifier => rec_usec_details.occurrence_identifier,
x_abort_flag => rec_usec_details.abort_flag
);
UPDATE igs_ps_sh_usec_occurs SET
monday = NULL,
tuesday = NULL,
wednesday = NULL,
thursday = NULL,
friday = NULL,
saturday = NULL,
sunday = NULL,
room_code = NULL,
building_code = NULL,
start_time = NULL,
end_time = NULL,
instructor_id = NULL
WHERE unit_section_occurrence_id = p_usec_occur_id;
END update_usec_occurs;
update_usec_occurs (p_usec_occur_id => rec_usec_occur_id.unit_section_occurrence_id);
update_usec_occurs (p_usec_occur_id => p_usec_occur_id);
SELECT 'x' FROM igs_ps_emp_cats_wl
WHERE rownum = 1;
SELECT IGS_PS_EXCEED_FAC_WL_S.NEXTVAL
FROM DUAL;
SELECT pti.person_id
FROM igs_pe_typ_instances_all pti, igs_pe_person_types pt
WHERE NVL (pti.org_id, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
= NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
AND pt.person_type_code = pti.person_type_code
AND pt.system_type IN ('STAFF','FACULTY')
AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);
SELECT peo.party_id
FROM per_person_type_usages_f usg,per_people_f peo,
igs_pe_per_type_map map
WHERE usg.person_id = peo.person_id AND
usg.person_type_id = map.per_person_type_id AND
SYSDATE BETWEEN usg.effective_start_date and usg.effective_end_date AND
TRUNC(SYSDATE) BETWEEN peo.effective_start_date AND peo.effective_end_date;
SELECT hz.party_name
FROM hz_parties hz
WHERE party_id = cp_n_person_id AND
hz.status = 'A';