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_SU_ATTEMPT_PKG dependencies on IGS_PS_RSV_EXT

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 4783: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE)

4779: --
4780: -- 25-Jun-2002 pmarada Added the code when the unit deleting from the su_attempt, decreasing the
4781: -- actual enrollment. bug 2423787
4782:
4783: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE)
4784: IS
4785: SELECT rsv.ROWID row_id, rsv.*
4786: FROM igs_ps_rsv_ext rsv
4787: WHERE rsv_ext_id = cp_rsv_ext_id;

Line 4786: FROM igs_ps_rsv_ext rsv

4782:
4783: CURSOR cur_igs_ps_rsv_ext (cp_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE)
4784: IS
4785: SELECT rsv.ROWID row_id, rsv.*
4786: FROM igs_ps_rsv_ext rsv
4787: WHERE rsv_ext_id = cp_rsv_ext_id;
4788:
4789: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
4790: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;

Line 4789: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;

4785: SELECT rsv.ROWID row_id, rsv.*
4786: FROM igs_ps_rsv_ext rsv
4787: WHERE rsv_ext_id = cp_rsv_ext_id;
4788:
4789: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
4790: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;
4791:
4792: BEGIN
4793: IF ( p_action = 'UPDATE') THEN

Line 4790: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;

4786: FROM igs_ps_rsv_ext rsv
4787: WHERE rsv_ext_id = cp_rsv_ext_id;
4788:
4789: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
4790: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;
4791:
4792: BEGIN
4793: IF ( p_action = 'UPDATE') THEN
4794: -- checking if the unit attempt status has been changed from ENROLLED/INVALID to DROPPED/DISCONTIN

Line 4803: OPEN cur_igs_ps_rsv_ext(l_rsv_ext_id);

4799: ELSE
4800: l_rsv_ext_id := new_references.rsv_seat_ext_id;
4801: END IF;
4802:
4803: OPEN cur_igs_ps_rsv_ext(l_rsv_ext_id);
4804: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;
4805: CLOSE cur_igs_ps_rsv_ext;
4806:
4807:

Line 4804: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;

4800: l_rsv_ext_id := new_references.rsv_seat_ext_id;
4801: END IF;
4802:
4803: OPEN cur_igs_ps_rsv_ext(l_rsv_ext_id);
4804: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;
4805: CLOSE cur_igs_ps_rsv_ext;
4806:
4807:
4808: -- If the unit attempt status is changed then the actual seats enrolled column has to be decreased by one

Line 4805: CLOSE cur_igs_ps_rsv_ext;

4801: END IF;
4802:
4803: OPEN cur_igs_ps_rsv_ext(l_rsv_ext_id);
4804: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;
4805: CLOSE cur_igs_ps_rsv_ext;
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

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

4805: CLOSE cur_igs_ps_rsv_ext;
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,

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 4811: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_ext_id,

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,
4815: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,

Line 4812: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,

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,
4815: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4816: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,

Line 4813: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,

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,
4815: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4816: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
4817: x_mode => 'R'

Line 4814: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,

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,
4815: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4816: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
4817: x_mode => 'R'
4818: );

Line 4815: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,

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,
4815: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4816: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
4817: x_mode => 'R'
4818: );
4819: END IF;

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

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,
4815: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4816: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
4817: x_mode => 'R'
4818: );
4819: END IF;
4820: END IF;

Line 4828: OPEN cur_igs_ps_rsv_ext(old_references.rsv_seat_ext_id);

4824: -- Suppose user added the unit to cart and closed the browser or timeout, the actual enrollment is matching.
4825: -- while user login into SS, decrementing the actual seat enrollment., pmarada, bug 2423787
4826:
4827: IF old_references.rsv_seat_ext_id IS NOT NULL THEN
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,

Line 4829: FETCH cur_igs_ps_rsv_ext INTO l_cur_igs_ps_rsv_ext;

4825: -- while user login into SS, decrementing the actual seat enrollment., pmarada, bug 2423787
4826:
4827: IF old_references.rsv_seat_ext_id IS NOT NULL THEN
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,

Line 4830: CLOSE cur_igs_ps_rsv_ext;

4826:
4827: IF old_references.rsv_seat_ext_id IS NOT NULL THEN
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,

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

4827: IF old_references.rsv_seat_ext_id IS NOT NULL THEN
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,

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,

Line 4833: x_rsv_ext_id => l_cur_igs_ps_rsv_ext.rsv_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,
4837: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,

Line 4834: x_uoo_id => l_cur_igs_ps_rsv_ext.uoo_id,

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,
4837: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4838: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,

Line 4835: x_priority_id => l_cur_igs_ps_rsv_ext.priority_id,

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,
4837: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4838: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
4839: x_mode => 'R'

Line 4836: x_preference_id => l_cur_igs_ps_rsv_ext.preference_id,

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,
4837: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4838: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
4839: x_mode => 'R'
4840: );

Line 4837: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,

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,
4837: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4838: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
4839: x_mode => 'R'
4840: );
4841: END IF;

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

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,
4837: x_rsv_level => l_cur_igs_ps_rsv_ext.rsv_level,
4838: x_actual_seat_enrolled => l_cur_igs_ps_rsv_ext.actual_seat_enrolled -1,
4839: x_mode => 'R'
4840: );
4841: END IF;
4842: END IF;