eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_PS_RSV_EXT

Line 1552: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE) IS

1548: WHERE person_id = cp_person_id
1549: AND course_cd = cp_program_cd
1550: AND uoo_Id = cp_uoo_Id;
1551:
1552: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE) IS
1553: SELECT rsv.ROWID row_id, rsv.*
1554: FROM igs_ps_rsv_ext rsv
1555: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
1556:

Line 1554: FROM igs_ps_rsv_ext rsv

1550: AND uoo_Id = cp_uoo_Id;
1551:
1552: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE) IS
1553: SELECT rsv.ROWID row_id, rsv.*
1554: FROM igs_ps_rsv_ext rsv
1555: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
1556:
1557:
1558: old_rec igs_en_su_attempt_all%rowTYPE;

Line 1586: FOR rec_igs_ps_rsv_ext IN cur_igs_ps_rsv_ext(new_rec.rsv_seat_ext_id) LOOP

1582: -- if reserve seating is existing then need to decrement the actual seat enrolled
1583: -- which was not done during swap drop.
1584:
1585: IF new_rec.rsv_seat_ext_id IS NOT NULL THEN
1586: FOR rec_igs_ps_rsv_ext IN cur_igs_ps_rsv_ext(new_rec.rsv_seat_ext_id) LOOP
1587: IF ((rec_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
1588: igs_ps_rsv_ext_pkg.update_row( x_rowid => rec_igs_ps_rsv_ext.row_id,
1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,
1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,

Line 1587: IF ((rec_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN

1583: -- which was not done during swap drop.
1584:
1585: IF new_rec.rsv_seat_ext_id IS NOT NULL THEN
1586: FOR rec_igs_ps_rsv_ext IN cur_igs_ps_rsv_ext(new_rec.rsv_seat_ext_id) LOOP
1587: IF ((rec_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
1588: igs_ps_rsv_ext_pkg.update_row( x_rowid => rec_igs_ps_rsv_ext.row_id,
1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,
1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,
1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,

Line 1588: igs_ps_rsv_ext_pkg.update_row( x_rowid => rec_igs_ps_rsv_ext.row_id,

1584:
1585: IF new_rec.rsv_seat_ext_id IS NOT NULL THEN
1586: FOR rec_igs_ps_rsv_ext IN cur_igs_ps_rsv_ext(new_rec.rsv_seat_ext_id) LOOP
1587: IF ((rec_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
1588: igs_ps_rsv_ext_pkg.update_row( x_rowid => rec_igs_ps_rsv_ext.row_id,
1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,
1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,
1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,
1592: x_preference_id => rec_igs_ps_rsv_ext.preference_id,

Line 1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,

1585: IF new_rec.rsv_seat_ext_id IS NOT NULL THEN
1586: FOR rec_igs_ps_rsv_ext IN cur_igs_ps_rsv_ext(new_rec.rsv_seat_ext_id) LOOP
1587: IF ((rec_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
1588: igs_ps_rsv_ext_pkg.update_row( x_rowid => rec_igs_ps_rsv_ext.row_id,
1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,
1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,
1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,
1592: x_preference_id => rec_igs_ps_rsv_ext.preference_id,
1593: x_rsv_level => rec_igs_ps_rsv_ext.rsv_level,

Line 1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,

1586: FOR rec_igs_ps_rsv_ext IN cur_igs_ps_rsv_ext(new_rec.rsv_seat_ext_id) LOOP
1587: IF ((rec_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
1588: igs_ps_rsv_ext_pkg.update_row( x_rowid => rec_igs_ps_rsv_ext.row_id,
1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,
1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,
1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,
1592: x_preference_id => rec_igs_ps_rsv_ext.preference_id,
1593: x_rsv_level => rec_igs_ps_rsv_ext.rsv_level,
1594: x_actual_seat_enrolled => rec_igs_ps_rsv_ext.actual_seat_enrolled -1,

Line 1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,

1587: IF ((rec_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
1588: igs_ps_rsv_ext_pkg.update_row( x_rowid => rec_igs_ps_rsv_ext.row_id,
1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,
1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,
1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,
1592: x_preference_id => rec_igs_ps_rsv_ext.preference_id,
1593: x_rsv_level => rec_igs_ps_rsv_ext.rsv_level,
1594: x_actual_seat_enrolled => rec_igs_ps_rsv_ext.actual_seat_enrolled -1,
1595: x_mode => 'R'

Line 1592: x_preference_id => rec_igs_ps_rsv_ext.preference_id,

1588: igs_ps_rsv_ext_pkg.update_row( x_rowid => rec_igs_ps_rsv_ext.row_id,
1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,
1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,
1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,
1592: x_preference_id => rec_igs_ps_rsv_ext.preference_id,
1593: x_rsv_level => rec_igs_ps_rsv_ext.rsv_level,
1594: x_actual_seat_enrolled => rec_igs_ps_rsv_ext.actual_seat_enrolled -1,
1595: x_mode => 'R'
1596: );

Line 1593: x_rsv_level => rec_igs_ps_rsv_ext.rsv_level,

1589: x_rsv_ext_id => rec_igs_ps_rsv_ext.rsv_ext_id,
1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,
1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,
1592: x_preference_id => rec_igs_ps_rsv_ext.preference_id,
1593: x_rsv_level => rec_igs_ps_rsv_ext.rsv_level,
1594: x_actual_seat_enrolled => rec_igs_ps_rsv_ext.actual_seat_enrolled -1,
1595: x_mode => 'R'
1596: );
1597: END IF;

Line 1594: x_actual_seat_enrolled => rec_igs_ps_rsv_ext.actual_seat_enrolled -1,

1590: x_uoo_id => rec_igs_ps_rsv_ext.uoo_id,
1591: x_priority_id => rec_igs_ps_rsv_ext.priority_id,
1592: x_preference_id => rec_igs_ps_rsv_ext.preference_id,
1593: x_rsv_level => rec_igs_ps_rsv_ext.rsv_level,
1594: x_actual_seat_enrolled => rec_igs_ps_rsv_ext.actual_seat_enrolled -1,
1595: x_mode => 'R'
1596: );
1597: END IF;
1598: END LOOP;

Line 2176: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE) IS

2172: WHERE person_id = cp_person_id
2173: AND course_cd = cp_program_cd
2174: AND uoo_Id = cp_uoo_Id;
2175:
2176: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE) IS
2177: SELECT rsv.ROWID row_id, rsv.*
2178: FROM igs_ps_rsv_ext rsv
2179: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
2180:

Line 2178: FROM igs_ps_rsv_ext rsv

2174: AND uoo_Id = cp_uoo_Id;
2175:
2176: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE) IS
2177: SELECT rsv.ROWID row_id, rsv.*
2178: FROM igs_ps_rsv_ext rsv
2179: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
2180:
2181: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
2182: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;

Line 2181: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;

2177: SELECT rsv.ROWID row_id, rsv.*
2178: FROM igs_ps_rsv_ext rsv
2179: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
2180:
2181: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
2182: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;
2183: old_rec igs_en_su_attempt_all%rowTYPE;
2184: new_rec igs_en_su_attempt_all%ROWTYPE;
2185: l_uoo_ids varchar2(30);

Line 2182: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;

2178: FROM igs_ps_rsv_ext rsv
2179: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
2180:
2181: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
2182: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;
2183: old_rec igs_en_su_attempt_all%rowTYPE;
2184: new_rec igs_en_su_attempt_all%ROWTYPE;
2185: l_uoo_ids varchar2(30);
2186: l_cur_uoo_id varchar2(30);

Line 2245: OPEN cur_igs_ps_rsv_ext(l_rsv_ext_id);

2241: ELSE
2242: l_rsv_ext_id := new_rec.rsv_seat_ext_id;
2243: END IF;
2244:
2245: OPEN cur_igs_ps_rsv_ext(l_rsv_ext_id);
2246: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;
2247: CLOSE cur_igs_ps_rsv_ext;
2248:
2249:

Line 2246: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;

2242: l_rsv_ext_id := new_rec.rsv_seat_ext_id;
2243: END IF;
2244:
2245: OPEN cur_igs_ps_rsv_ext(l_rsv_ext_id);
2246: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;
2247: CLOSE cur_igs_ps_rsv_ext;
2248:
2249:
2250: -- If the unit attempt status is changed then the actual seats enrolled column has to be decreased by one

Line 2247: CLOSE cur_igs_ps_rsv_ext;

2243: END IF;
2244:
2245: OPEN cur_igs_ps_rsv_ext(l_rsv_ext_id);
2246: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;
2247: CLOSE cur_igs_ps_rsv_ext;
2248:
2249:
2250: -- If the unit attempt status is changed then the actual seats enrolled column has to be decreased by one
2251: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN

Line 2251: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN

2247: CLOSE cur_igs_ps_rsv_ext;
2248:
2249:
2250: -- If the unit attempt status is changed then the actual seats enrolled column has to be decreased by one
2251: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
2252: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,
2253: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,

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

2248:
2249:
2250: -- If the unit attempt status is changed then the actual seats enrolled column has to be decreased by one
2251: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
2252: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,
2253: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
2256: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,

Line 2253: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,

2249:
2250: -- If the unit attempt status is changed then the actual seats enrolled column has to be decreased by one
2251: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
2252: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,
2253: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
2256: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,
2257: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,

Line 2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,

2250: -- If the unit attempt status is changed then the actual seats enrolled column has to be decreased by one
2251: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
2252: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,
2253: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
2256: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,
2257: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
2258: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,

Line 2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,

2251: IF ((l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1) >= 0) THEN
2252: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,
2253: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
2256: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,
2257: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
2258: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
2259: x_mode => 'R'

Line 2256: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,

2252: igs_ps_rsv_ext_pkg.update_row( x_rowid => l_cur_igs_ps_rsv_ext.row_id,
2253: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
2256: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,
2257: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
2258: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
2259: x_mode => 'R'
2260: );

Line 2257: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,

2253: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,
2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
2256: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,
2257: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
2258: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
2259: x_mode => 'R'
2260: );
2261: END IF;

Line 2258: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,

2254: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,
2255: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,
2256: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,
2257: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
2258: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
2259: x_mode => 'R'
2260: );
2261: END IF;
2262: END IF;