APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_USEC_SCHEDULE

Line 1171: IF igs_ps_usec_schedule.prgp_get_schd_status( c_usec_rec.uoo_id,NULL,v_message_name ) = TRUE THEN

1167: END IF;
1168:
1169: END IF;
1170:
1171: IF igs_ps_usec_schedule.prgp_get_schd_status( c_usec_rec.uoo_id,NULL,v_message_name ) = TRUE THEN
1172: IF v_message_name IS NULL THEN
1173: v_message_name := 'IGS_PS_SCST_PROC';
1174: END IF;
1175: fnd_message.set_name( 'IGS', v_message_name);

Line 1179: IF igs_ps_usec_schedule.prgp_upd_usec_dtls( c_usec_rec.uoo_id,p_usec_rec.location_cd,Null,Null,Null,Null,

1175: fnd_message.set_name( 'IGS', v_message_name);
1176: fnd_msg_pub.add;
1177: p_usec_rec.status := 'E';
1178: ELSIF c_usec_rec.location_cd <> p_usec_rec.location_cd THEN
1179: IF igs_ps_usec_schedule.prgp_upd_usec_dtls( c_usec_rec.uoo_id,p_usec_rec.location_cd,Null,Null,Null,Null,
1180: v_request_id,
1181: v_message_name
1182: ) = FALSE THEN
1183:

Line 3095: IF IGS_PS_USEC_SCHEDULE.PRGP_GET_SCHD_STATUS( p_n_uoo_id,

3091: FETCH c_usec_lim INTO c_usec_lim_rec;
3092: CLOSE c_usec_lim;
3093:
3094: --Before updating check the scheduling status is processing or not
3095: IF IGS_PS_USEC_SCHEDULE.PRGP_GET_SCHD_STATUS( p_n_uoo_id,
3096: NULL,
3097: l_message_name ) = TRUE THEN
3098: IF l_message_name IS NULL THEN
3099: l_message_name := 'IGS_PS_SCST_PROC';

Line 3198: IF igs_ps_usec_schedule.prgp_upd_usec_dtls(

3194: NVL(p_usec_rec.enrollment_maximum,-999) <> NVL(c_usec_lim_rec.enrollment_maximum,-999) OR
3195: NVL(p_usec_rec.enrollment_expected,-999) <> NVL(c_usec_lim_rec.enrollment_expected,-999) OR
3196: NVL(p_usec_rec.override_enrollment_maximum,-999) <> NVL(c_usec_lim_rec.override_enrollment_max,-999)
3197: ) THEN
3198: IF igs_ps_usec_schedule.prgp_upd_usec_dtls(
3199: p_uoo_id=>p_n_uoo_id,
3200: p_max_enrollments =>NVL(p_usec_rec.enrollment_maximum,-999) ,
3201: p_override_enrollment_max => NVL(p_usec_rec.override_enrollment_maximum,-999),
3202: p_enrollment_expected => NVL(p_usec_rec.enrollment_expected,-999),

Line 3250: IF igs_ps_usec_schedule.prgp_upd_usec_dtls(

3246: NVL(p_usec_rec.enrollment_expected,-999) <> NVL(l_c_unit.enrollment_expected,-999) OR
3247: NVL(p_usec_rec.override_enrollment_maximum,-999) <> NVL(l_c_unit.override_enrollment_max,-999)
3248: ) THEN
3249:
3250: IF igs_ps_usec_schedule.prgp_upd_usec_dtls(
3251: p_uoo_id=>p_n_uoo_id,
3252: p_max_enrollments =>NVL(l_c_unit.enrollment_maximum,-999) ,
3253: p_override_enrollment_max => NVL(l_c_unit.override_enrollment_max,-999),
3254: p_enrollment_expected => NVL(l_c_unit.enrollment_expected,-999),

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

3823:
3824: IF p_unit_ref_rec.status = 'S' THEN
3825: --Update the schedule status of the occurrence to USER_UPDATE if inserting/updating a record
3826: FOR l_occurs_rec IN c_occurs(p_n_uso_id) LOOP
3827: igs_ps_usec_schedule.update_occurrence_status(l_occurs_rec.unit_section_occurrence_id,'USER_UPDATE','N');
3828: END LOOP;
3829: END IF;
3830: END IF;
3831: