APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_RSV_EXT

Line 3438: l_rsv_level igs_ps_rsv_ext.rsv_level%TYPE;

3434: l_pri_satisfied VARCHAR2(1);
3435: l_unreserved_seats NUMBER;
3436:
3437: -- flag variable which stores in which level reserved seat setup found in the hierarchy
3438: l_rsv_level igs_ps_rsv_ext.rsv_level%TYPE;
3439:
3440: l_message VARCHAR2(30);
3441: l_message_icon VARCHAR2(1);
3442: -- variable which stores the total reserved percentage found in the hierarchy

Line 3485: FROM igs_ps_rsv_ext rsve

3481: -- defined at given level.
3482: CURSOR cur_rsv_ext(p_priority_id VARCHAR2, p_preference_id VARCHAR2,
3483: p_rsv_level VARCHAR2)IS
3484: SELECT rsve.ROWID, rsve.*
3485: FROM igs_ps_rsv_ext rsve
3486: WHERE rsve.priority_id = p_priority_id AND
3487: rsve.preference_id = p_preference_id AND
3488: rsve.rsv_level = p_rsv_level AND
3489: rsve.uoo_id = p_uoo_id

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 ,

Line 3920: --Assign value changed from 'UNIT_OFR_OPT' TO 'UNIT_PAT', because l_rsv_level variable is stype of IGS_PS_RSV_EXT.RSV_LEVEL

3916: -- check the priority/preferences at Unit offering pattern level
3917: --
3918: IF l_rsv_level IS NULL THEN
3919: FOR cur_rsv_uop_pri_rec IN cur_rsv_uop_pri(l_unit_cd,l_version_number,l_cal_type,l_ci_sequence_number) LOOP
3920: --Assign value changed from 'UNIT_OFR_OPT' TO 'UNIT_PAT', because l_rsv_level variable is stype of IGS_PS_RSV_EXT.RSV_LEVEL
3921: --which is VARCHAR2(10) but 'UNIT_OFR_OPT' size is 12 chars which throws value numberic value error
3922: --w.r.t. bug no 2455245 by kkillams
3923: l_rsv_level := 'UNIT_PAT';
3924: IF cur_rsv_uop_pri_rec.priority_value = 'PROGRAM' THEN