DBA Data[Home] [Help]

APPS.IGS_PS_USEC_OCUR_REF_PKG dependencies on IGS_PS_USEC_SCHEDULE

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

456:
457: IF (p_action = 'INSERT') THEN
458: --Update the schedule status of the occurrence to USER_UPDATE if inserting a record
459: FOR l_occurs_rec IN c_occurs(new_references.unit_section_occurrence_id) LOOP
460: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
461: END LOOP;
462:
463: ELSIF (p_action = 'UPDATE') THEN
464: --Update the schedule status of the occurrence to USER_UPDATE if updating a record

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

462:
463: ELSIF (p_action = 'UPDATE') THEN
464: --Update the schedule status of the occurrence to USER_UPDATE if updating a record
465: FOR l_occurs_rec IN c_occurs(new_references.unit_section_occurrence_id) LOOP
466: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
467: END LOOP;
468:
469:
470: ELSIF (p_action = 'DELETE') THEN

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

469:
470: ELSIF (p_action = 'DELETE') THEN
471: --Update the schedule status of the occurrence to USER_UPDATE if updating a record
472: FOR l_occurs_rec IN c_occurs(old_references.unit_section_occurrence_id) LOOP
473: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
474: END LOOP;
475:
476: END IF;
477: