DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_USEC_SCHEDULE

Line 1190: IF igs_ps_usec_schedule.prgp_get_schd_status(p_uoo_id => rec_cur_usecs_in_group.uoo_id,

1186:
1187: --for loop which loops thru all unit sections within a group.
1188: FOR rec_cur_usecs_in_group IN cur_usecs_in_group(c_val_enr_rec.class_meet_group_id) LOOP
1189: --Before updating check for validity of schedule status...
1190: IF igs_ps_usec_schedule.prgp_get_schd_status(p_uoo_id => rec_cur_usecs_in_group.uoo_id,
1191: p_usec_id => NULL,
1192: p_message_name => l_message_name ) = TRUE THEN
1193: IF l_message_name IS NULL THEN
1194: l_message_name := 'IGS_PS_SCST_PROC';

Line 1201: ELSIF igs_ps_usec_schedule.prgp_upd_usec_dtls

1197: fnd_message.set_name('IGS',l_message_name);
1198: fnd_msg_pub.add;
1199: p_uso_cm_grp_rec.status := 'E';
1200: --update the schedule status to 'Rescheduling Requested', if unit section occurrence is a scheduled one.
1201: ELSIF igs_ps_usec_schedule.prgp_upd_usec_dtls
1202: (
1203: p_uoo_id => rec_cur_usecs_in_group.uoo_id,
1204: p_location_cd => NULL,
1205: p_usec_status => NULL,

Line 1758: IF igs_ps_usec_schedule.prgp_get_schd_status( p_uoo_id => rec_cur_usecs_in_group.uoo_id,

1754:
1755: --for loop which loops thru all unit sections within a group.
1756: FOR rec_cur_usecs_in_group IN cur_usecs_in_group(c_val_enr_rec.usec_x_listed_group_id) LOOP
1757: --Before updating check for validity of schedule status...
1758: IF igs_ps_usec_schedule.prgp_get_schd_status( p_uoo_id => rec_cur_usecs_in_group.uoo_id,
1759: p_usec_id => NULL,
1760: p_message_name => l_message_name ) = TRUE THEN
1761: IF l_message_name IS NULL THEN
1762: l_message_name := 'IGS_PS_SCST_PROC';

Line 1769: ELSIF igs_ps_usec_schedule.prgp_upd_usec_dtls

1765: fnd_message.set_name('IGS',l_message_name);
1766: fnd_msg_pub.add;
1767: p_usec_x_grp_rec.status := 'E';
1768: --update the schedule status to 'Rescheduling Requested', if unit section occurrence is a scheduled one.
1769: ELSIF igs_ps_usec_schedule.prgp_upd_usec_dtls
1770: (
1771: p_uoo_id => rec_cur_usecs_in_group.uoo_id,
1772: p_location_cd => NULL,
1773: p_usec_status => NULL,

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

2397:
2398: --Update the schedule status of the occurrence to USER_UPDATE if inserting/updating a record
2399: IF p_uso_fclt_rec.status = 'S' THEN
2400: FOR l_occurs_rec IN c_occurs(p_uso_id) LOOP
2401: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
2402: END LOOP;
2403: END IF;
2404:
2405: END IF;