DBA Data[Home] [Help]

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_PS_RSV_EXT_PKG

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 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,