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_PS_VAL_US dependencies on IGS_EN_UNIT_SET_STAT

Line 17: v_closed_ind IGS_EN_UNIT_SET_STAT.closed_ind%TYPE;

13: RETURN BOOLEAN AS
14: BEGIN -- crsp_val_uss_closed
15: -- Validate the IGS_PS_UNIT set status closed indicator
16: DECLARE
17: v_closed_ind IGS_EN_UNIT_SET_STAT.closed_ind%TYPE;
18: CURSOR c_uss IS
19: SELECT uss.closed_ind
20: FROM IGS_EN_UNIT_SET_STAT uss
21: WHERE uss.unit_set_status = p_unit_set_status;

Line 20: FROM IGS_EN_UNIT_SET_STAT uss

16: DECLARE
17: v_closed_ind IGS_EN_UNIT_SET_STAT.closed_ind%TYPE;
18: CURSOR c_uss IS
19: SELECT uss.closed_ind
20: FROM IGS_EN_UNIT_SET_STAT uss
21: WHERE uss.unit_set_status = p_unit_set_status;
22: BEGIN
23: OPEN c_uss;
24: FETCH c_uss INTO v_closed_ind;

Line 165: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';

161: -- This module performs cross-field validation on the IGS_PS_UNIT set
162: -- version end date and the IGS_PS_UNIT version status.
163: -- - End date can only be set if the IGS_PS_UNIT set system status is INACTIVE
164: DECLARE
165: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';
166: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
167: CURSOR c_uss IS
168: SELECT uss.s_unit_set_status
169: FROM IGS_EN_UNIT_SET_STAT uss

Line 166: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

162: -- version end date and the IGS_PS_UNIT version status.
163: -- - End date can only be set if the IGS_PS_UNIT set system status is INACTIVE
164: DECLARE
165: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';
166: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
167: CURSOR c_uss IS
168: SELECT uss.s_unit_set_status
169: FROM IGS_EN_UNIT_SET_STAT uss
170: WHERE uss.unit_set_status = p_unit_set_status;

Line 169: FROM IGS_EN_UNIT_SET_STAT uss

165: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';
166: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
167: CURSOR c_uss IS
168: SELECT uss.s_unit_set_status
169: FROM IGS_EN_UNIT_SET_STAT uss
170: WHERE uss.unit_set_status = p_unit_set_status;
171: BEGIN
172: -- 1. Select the IGS_EN_UNIT_SET_STAT.s_unit_set_status for
173: -- the given p_unit_set_status.

Line 172: -- 1. Select the IGS_EN_UNIT_SET_STAT.s_unit_set_status for

168: SELECT uss.s_unit_set_status
169: FROM IGS_EN_UNIT_SET_STAT uss
170: WHERE uss.unit_set_status = p_unit_set_status;
171: BEGIN
172: -- 1. Select the IGS_EN_UNIT_SET_STAT.s_unit_set_status for
173: -- the given p_unit_set_status.
174: OPEN c_uss;
175: FETCH c_uss INTO v_s_unit_set_status;
176: CLOSE c_uss;

Line 274: -- This module validates the IGS_EN_UNIT_SET.IGS_EN_UNIT_SET_STAT. It is fired at

270: p_new_unit_set_status IN VARCHAR2 ,
271: p_message_name OUT NOCOPY VARCHAR2 )
272: RETURN BOOLEAN AS
273: BEGIN -- crsp_val_us_status
274: -- This module validates the IGS_EN_UNIT_SET.IGS_EN_UNIT_SET_STAT. It is fired at
275: -- item level. The checks are:
276: -- IGS_PS_UNIT_STAT cannot be set back to a system status of 'PLANNED' once
277: -- it is 'ACTIVE' or 'INACTIVE'.
278: DECLARE

Line 279: cst_planned CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'PLANNED';

275: -- item level. The checks are:
276: -- IGS_PS_UNIT_STAT cannot be set back to a system status of 'PLANNED' once
277: -- it is 'ACTIVE' or 'INACTIVE'.
278: DECLARE
279: cst_planned CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'PLANNED';
280: v_new_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
281: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
282: CURSOR c_uss (
283: cp_unit_set_status IGS_EN_UNIT_SET_STAT.unit_set_status%TYPE) IS

Line 280: v_new_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

276: -- IGS_PS_UNIT_STAT cannot be set back to a system status of 'PLANNED' once
277: -- it is 'ACTIVE' or 'INACTIVE'.
278: DECLARE
279: cst_planned CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'PLANNED';
280: v_new_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
281: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
282: CURSOR c_uss (
283: cp_unit_set_status IGS_EN_UNIT_SET_STAT.unit_set_status%TYPE) IS
284: SELECT uss.s_unit_set_status

Line 281: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

277: -- it is 'ACTIVE' or 'INACTIVE'.
278: DECLARE
279: cst_planned CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'PLANNED';
280: v_new_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
281: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
282: CURSOR c_uss (
283: cp_unit_set_status IGS_EN_UNIT_SET_STAT.unit_set_status%TYPE) IS
284: SELECT uss.s_unit_set_status
285: FROM IGS_EN_UNIT_SET_STAT uss

Line 283: cp_unit_set_status IGS_EN_UNIT_SET_STAT.unit_set_status%TYPE) IS

279: cst_planned CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'PLANNED';
280: v_new_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
281: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
282: CURSOR c_uss (
283: cp_unit_set_status IGS_EN_UNIT_SET_STAT.unit_set_status%TYPE) IS
284: SELECT uss.s_unit_set_status
285: FROM IGS_EN_UNIT_SET_STAT uss
286: WHERE uss.unit_set_status = cp_unit_set_status;
287: BEGIN

Line 285: FROM IGS_EN_UNIT_SET_STAT uss

281: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
282: CURSOR c_uss (
283: cp_unit_set_status IGS_EN_UNIT_SET_STAT.unit_set_status%TYPE) IS
284: SELECT uss.s_unit_set_status
285: FROM IGS_EN_UNIT_SET_STAT uss
286: WHERE uss.unit_set_status = cp_unit_set_status;
287: BEGIN
288: -- Validate the system status is not being altered to PLANNED from
289: -- ACTIVE or INACTIVE.

Line 343: FROM IGS_EN_UNIT_SET_STAT uss

339: cst_active CONSTANT VARCHAR2(10) :='ACTIVE';
340: v_dummy VARCHAR2(1);
341: CURSOR c_uss IS
342: SELECT 'x'
343: FROM IGS_EN_UNIT_SET_STAT uss
344: WHERE uss.unit_set_status = unit_set_status AND
345: uss.s_unit_set_status = cst_active;
346: CURSOR c_us_uss IS
347: SELECT 'X'

Line 349: IGS_EN_UNIT_SET_STAT uss

345: uss.s_unit_set_status = cst_active;
346: CURSOR c_us_uss IS
347: SELECT 'X'
348: FROM IGS_EN_UNIT_SET us,
349: IGS_EN_UNIT_SET_STAT uss
350: WHERE us.unit_set_cd = p_unit_set_cd AND
351: us.version_number <> p_version_number AND
352: us.expiry_dt IS NULL AND
353: us.unit_set_status = uss.unit_set_status AND

Line 359: -- s_unit_set_status from IGS_EN_UNIT_SET_STAT table) is ACTIVE and the expiry

355: BEGIN
356: --Set the default message number
357: p_message_name := NULL;
358: -- Check parameters passed in. If the IGS_PS_UNIT set system status (fetch
359: -- s_unit_set_status from IGS_EN_UNIT_SET_STAT table) is ACTIVE and the expiry
360: -- date not set.
361: OPEN c_uss;
362: FETCH c_uss INTO v_dummy;
363: IF c_uss%FOUND THEN

Line 412: v_new_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

408: -- on the IGS_PS_UNIT set record. It is fired at record level (hence could not be
409: -- incorporated
410: -- in the CRSP_VAL_US_STATUS validation).
411: DECLARE
412: v_new_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
413: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
414: -- Fetch new system status
415: CURSOR c_new_uss IS
416: SELECT uss.s_unit_set_status

Line 413: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

409: -- incorporated
410: -- in the CRSP_VAL_US_STATUS validation).
411: DECLARE
412: v_new_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
413: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
414: -- Fetch new system status
415: CURSOR c_new_uss IS
416: SELECT uss.s_unit_set_status
417: FROM IGS_EN_UNIT_SET_STAT uss

Line 417: FROM IGS_EN_UNIT_SET_STAT uss

413: v_old_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
414: -- Fetch new system status
415: CURSOR c_new_uss IS
416: SELECT uss.s_unit_set_status
417: FROM IGS_EN_UNIT_SET_STAT uss
418: WHERE uss.unit_set_status = p_new_unit_set_status;
419: -- Fetch old system status
420: CURSOR c_old_uss IS
421: SELECT uss.s_unit_set_status

Line 422: FROM IGS_EN_UNIT_SET_STAT uss

418: WHERE uss.unit_set_status = p_new_unit_set_status;
419: -- Fetch old system status
420: CURSOR c_old_uss IS
421: SELECT uss.s_unit_set_status
422: FROM IGS_EN_UNIT_SET_STAT uss
423: WHERE uss.unit_set_status = p_old_unit_set_status;
424: BEGIN
425: -- Set the default message number
426: p_message_name := NULL;

Line 477: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

473: BEGIN -- crsp_val_us_category
474: -- This module provides a warning if the IGS_PS_UNIT set is active
475: -- when the IGS_PS_UNIT set category is being changed.
476: DECLARE
477: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
478: CURSOR c_uss IS
479: SELECT uss.s_unit_set_status
480: FROM IGS_EN_UNIT_SET_STAT uss
481: WHERE uss.unit_set_status = p_unit_set_status;

Line 480: FROM IGS_EN_UNIT_SET_STAT uss

476: DECLARE
477: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
478: CURSOR c_uss IS
479: SELECT uss.s_unit_set_status
480: FROM IGS_EN_UNIT_SET_STAT uss
481: WHERE uss.unit_set_status = p_unit_set_status;
482: BEGIN
483: -- Set the default message number
484: p_message_name := NULL;

Line 486: -- check whether IGS_EN_UNIT_SET_STAT is ACTIVE

482: BEGIN
483: -- Set the default message number
484: p_message_name := NULL;
485: IF p_old_unit_set_cat <> p_new_unit_set_cat THEN
486: -- check whether IGS_EN_UNIT_SET_STAT is ACTIVE
487: OPEN c_uss;
488: FETCH c_uss INTO v_s_unit_set_status;
489: --if the unit set status is not planned and unit set category is getting changed, throw error message.bug#2121770.
490: IF (c_uss%FOUND) THEN