[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT person_id
FROM igs_gr_awd_crmn_hist
WHERE person_id = cp_person_id
AND create_dt = cp_create_dt
AND grd_cal_type = cp_grd_cal_type
AND grd_ci_sequence_number = cp_grd_ci_sequence_number
AND ceremony_number = cp_ceremony_number
AND award_course_cd = cp_award_course_cd
AND award_crs_version_number = cp_award_crs_version_number
AND award_cd = cp_award_cd;
SELECT ROWID,
person_id
FROM igs_gr_awd_crmn_hist
WHERE person_id = cp_person_id
AND create_dt = cp_create_dt
AND grd_cal_type = cp_grd_cal_type
AND grd_ci_sequence_number = cp_grd_ci_sequence_number
AND ceremony_number = cp_ceremony_number
AND award_course_cd = cp_award_course_cd
AND award_crs_version_number = cp_award_crs_version_number
AND award_cd = cp_award_cd
FOR UPDATE OF person_id NOWAIT;
igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);
SELECT gr.person_id,
gr.create_dt
FROM igs_gr_graduand_all gr,
igs_gr_stat gst
WHERE gr.grd_cal_type = p_grd_cal_type
AND gr.grd_ci_sequence_number = p_grd_ci_sequence_number
AND gr.graduand_status = gst.graduand_status
AND gst.s_graduand_status = 'POTENTIAL'
AND gr.grd_cal_type = p_grd_cal_type
AND gr.grd_ci_sequence_number = p_grd_ci_sequence_number;
SELECT ROWID
FROM igs_gr_graduand_all gr
WHERE gr.person_id = cp_gr_person_id
AND gr.create_dt = cp_gr_create_dt
AND NOT EXISTS (SELECT 'X'
FROM igs_gr_awd_crmn gac
WHERE gac.person_id = cp_gr_person_id
AND gac.create_dt = cp_gr_create_dt)
FOR UPDATE OF gr.person_id NOWAIT;
SELECT ROWID
FROM igs_gr_graduand_hist grh
WHERE grh.person_id = cp_gr_person_id
AND grh.create_dt = cp_gr_create_dt
FOR UPDATE OF grh.person_id NOWAIT;
SELECT ROWID
FROM igs_gr_awd_crmn gac
WHERE gac.person_id = cp_gr_person_id
AND gac.create_dt = cp_gr_create_dt
FOR UPDATE OF gac.person_id NOWAIT;
SELECT ROWID
FROM igs_gr_awd_crmn_hist gach
WHERE gach.person_id = cp_gr_person_id
AND gach.create_dt = cp_gr_create_dt
AND gach.grd_cal_type = p_grd_cal_type
AND gach.grd_ci_sequence_number = p_grd_ci_sequence_number
FOR UPDATE OF gach.person_id NOWAIT;
igs_gr_awd_crmn_pkg.delete_row (x_rowid => v_gac_rec.ROWID);
igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);
igs_gr_graduand_pkg.delete_row (x_rowid => v_gr_del_rec.ROWID);
igs_gr_graduand_hist_pkg.delete_row (x_rowid => v_grh_del_rec.ROWID);
SELECT acusg.override_title
FROM igs_gr_awd_crm_us_gp acusg
WHERE acusg.grd_cal_type = p_grd_cal_type
AND acusg.grd_ci_sequence_number = p_grd_ci_sequence_number
AND acusg.ceremony_number = p_ceremony_number
AND acusg.award_course_cd = p_award_course_cd
AND acusg.award_crs_version_number = p_award_crs_version_number
AND acusg.award_cd = p_award_cd
AND acusg.us_group_number = p_us_group_number
AND acusg.override_title IS NOT NULL;
SELECT us.short_title
FROM igs_en_unit_set us,
igs_gr_awd_crm_ut_st acus
WHERE acus.grd_cal_type = p_grd_cal_type
AND acus.grd_ci_sequence_number = p_grd_ci_sequence_number
AND acus.ceremony_number = p_ceremony_number
AND acus.award_course_cd = p_award_course_cd
AND acus.award_crs_version_number = p_award_crs_version_number
AND acus.award_cd = p_award_cd
AND acus.us_group_number = p_us_group_number
AND acus.unit_set_cd = us.unit_set_cd
AND acus.us_version_number = us.version_number
ORDER BY acus.order_in_group;
SELECT pe.last_name,
pe.first_name,
pe.title
FROM igs_pe_person_base_v pe
WHERE pe.person_id = p_person_id;
SELECT hl.govt_honours_level
FROM igs_gr_graduand_all gr,
igs_gr_stat gst,
igs_ps_awd aw,
igs_gr_honours_level hl
WHERE gr.person_id = p_person_id
AND gr.course_cd = p_course_cd
AND gr.award_course_cd = gr.course_cd
AND gst.graduand_status = gr.graduand_status
AND gst.s_graduand_status = 'GRADUATED'
AND aw.award_cd = gr.award_cd
AND aw.s_award_type = 'COURSE'
AND hl.honours_level = gr.honours_level;
p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
p_old_comments igs_gr_awd_crmn.comments%TYPE,
p_new_comments igs_gr_awd_crmn.comments%TYPE
) AS
BEGIN -- grdp_ins_gr_hist
--
IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
fnd_log.string (
fnd_log.level_procedure, g_module_head || 'grdp_ins_gac_hist.begin',
'In Params: p_person_id=>' || p_person_id || ';' ||
'p_old_update_who=>' || p_old_update_who || ';' ||
'p_new_update_who=>' || p_new_update_who || ';' ||
'p_old_update_on=>' || p_old_update_on || ';' ||
'p_new_update_on=>' || p_new_update_on || ';' ||
v_gac_rec.hist_start_dt := p_old_update_on;
v_gac_rec.hist_end_dt := p_new_update_on;
v_gac_rec.hist_who := p_old_update_who;
igs_gr_awd_crmn_hist_pkg.insert_row (
x_rowid => lv_rowid,
x_gach_id => lv_seqnc,
x_name_pronunciation => v_gac_rec.name_pronunciation,
x_name_announced => v_gac_rec.name_announced,
x_academic_dress_rqrd_ind => v_gac_rec.academic_dress_rqrd_ind,
x_academic_gown_size => v_gac_rec.academic_gown_size,
x_academic_hat_size => v_gac_rec.academic_hat_size,
x_guest_tickets_requested => v_gac_rec.guest_tickets_requested,
x_guest_tickets_allocated => v_gac_rec.guest_tickets_allocated,
x_guest_seats => v_gac_rec.guest_seats,
x_fees_paid_ind => v_gac_rec.fees_paid_ind,
x_special_requirements => v_gac_rec.special_requirements,
x_comments => v_gac_rec.comments,
x_person_id => v_gac_rec.person_id,
x_create_dt => v_gac_rec.create_dt,
x_grd_cal_type => v_gac_rec.grd_cal_type,
x_graduand_seat_number => v_gac_rec.graduand_seat_number,
x_hist_who => v_gac_rec.hist_who,
x_us_group_number => v_gac_rec.us_group_number,
x_order_in_presentation => v_gac_rec.order_in_presentation,
x_hist_end_dt => v_gac_rec.hist_end_dt,
x_grd_ci_sequence_number => v_gac_rec.grd_ci_sequence_number,
x_ceremony_number => v_gac_rec.ceremony_number,
x_award_course_cd => v_gac_rec.award_course_cd,
x_award_crs_version_number => v_gac_rec.award_crs_version_number,
x_award_cd => v_gac_rec.award_cd,
x_hist_start_dt => v_gac_rec.hist_start_dt,
x_mode => 'R'
);