DBA Data[Home] [Help]

APPS.IGS_PS_USO_FACILITY_PKG dependencies on IGS_PS_USEC_SCHEDULE

Line 375: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');

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

Line 381: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');

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

Line 388: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');

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: