APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_RSV_EXT_PKG

Line 3536: igs_ps_rsv_ext_pkg.update_row(x_rowid => cur_rsv_ext_rec.ROWID,

3532: FETCH cur_rsv_ext INTO cur_rsv_ext_rec;
3533: -- record already exist against given priority/preference
3534: IF cur_rsv_ext%FOUND THEN
3535: l_rsv_ext_id := cur_rsv_ext_rec.rsv_ext_id;
3536: igs_ps_rsv_ext_pkg.update_row(x_rowid => cur_rsv_ext_rec.ROWID,
3537: x_rsv_ext_id => cur_rsv_ext_rec.rsv_ext_id,
3538: x_uoo_id => cur_rsv_ext_rec.uoo_id,
3539: x_priority_id => cur_rsv_ext_rec.priority_id,
3540: x_preference_id => cur_rsv_ext_rec.preference_id ,

Line 3545: igs_ps_rsv_ext_pkg.insert_row(x_rowid => l_rowid,

3541: x_rsv_level => cur_rsv_ext_rec.rsv_level ,
3542: x_actual_seat_enrolled => cur_rsv_ext_rec.actual_seat_enrolled + 1,
3543: x_mode => 'R' );
3544: ELSE -- record is not exist against given priority/preference, so inserting a new record
3545: igs_ps_rsv_ext_pkg.insert_row(x_rowid => l_rowid,
3546: x_rsv_ext_id => l_rsv_ext_id,
3547: x_uoo_id => p_uoo_id,
3548: x_priority_id => p_priority_id,
3549: x_preference_id => p_preference_id ,

Line 3657: igs_ps_rsv_ext_pkg.update_row(x_rowid => cur_rsv_ext_rec.ROWID,

3653: CLOSE cur_rsv_ext;
3654: RETURN FALSE;
3655: END IF;
3656: l_rsv_ext_id := cur_rsv_ext_rec.rsv_ext_id;
3657: igs_ps_rsv_ext_pkg.update_row(x_rowid => cur_rsv_ext_rec.ROWID,
3658: x_rsv_ext_id => cur_rsv_ext_rec.rsv_ext_id,
3659: x_uoo_id => cur_rsv_ext_rec.uoo_id,
3660: x_priority_id => cur_rsv_ext_rec.priority_id,
3661: x_preference_id => cur_rsv_ext_rec.preference_id ,

Line 3672: igs_ps_rsv_ext_pkg.insert_row(x_rowid => l_rowid,

3668: -- no seat available under the given priority/ preference
3669: CLOSE cur_rsv_ext;
3670: RETURN FALSE;
3671: END IF;
3672: igs_ps_rsv_ext_pkg.insert_row(x_rowid => l_rowid,
3673: x_rsv_ext_id => l_rsv_ext_id,
3674: x_uoo_id => p_uoo_id,
3675: x_priority_id => p_priority_id,
3676: x_preference_id => p_preference_id ,