APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_PS_RSV_EXT_PKG

Line 1654: ELSIF NOT IGS_PS_RSV_EXT_PKG.Get_PK_For_Validation (

1650:
1651: IF ( (old_references.rsv_seat_ext_id = new_references.rsv_seat_ext_id) OR
1652: (new_references.rsv_seat_ext_id IS NULL ) ) THEN
1653: NULL;
1654: ELSIF NOT IGS_PS_RSV_EXT_PKG.Get_PK_For_Validation (
1655: new_references.rsv_seat_ext_id
1656: ) THEN
1657: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
1658: IGS_GE_MSG_STACK.ADD;

Line 4810: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,

4806:
4807:
4808: -- If the unit attempt status is changed then the actual seats enrolled column has to be decreased by one
4809: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
4810: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,
4811: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
4812: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
4813: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
4814: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,

Line 4832: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,

4828: OPEN cur_igs_ps_rsv_ext(old_references.rsv_seat_ext_id);
4829: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;
4830: CLOSE cur_igs_ps_rsv_ext;
4831: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
4832: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,
4833: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
4834: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
4835: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
4836: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,