371:
372: IF (p_action = 'INSERT') THEN
373: --Update the schedule status of the occurrence to USER_UPDATE if inserting a record
374: FOR l_occurs_rec IN c_occurs(new_references.unit_section_occurrence_id) LOOP
375: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
376: END LOOP;
377:
378: ELSIF (p_action = 'UPDATE') THEN
379: --Update the schedule status of the occurrence to USER_UPDATE if updating a record
377:
378: ELSIF (p_action = 'UPDATE') THEN
379: --Update the schedule status of the occurrence to USER_UPDATE if updating a record
380: FOR l_occurs_rec IN c_occurs(new_references.unit_section_occurrence_id) LOOP
381: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
382: END LOOP;
383:
384:
385: ELSIF (p_action = 'DELETE') THEN
384:
385: ELSIF (p_action = 'DELETE') THEN
386: --Update the schedule status of the occurrence to USER_UPDATE if updating a record
387: FOR l_occurs_rec IN c_occurs(old_references.unit_section_occurrence_id) LOOP
388: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
389: END LOOP;
390:
391: END IF;
392: