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_UV dependencies on IGS_PS_UNIT_STAT

Line 12: IGS_PS_UNIT_STATUS_CLOSED, IGS_PS_UNITSTATUS_NOT_ALTERED and IGS_PS_NEWUNITVER_ST_PLANNED

8: sarakshi 02-sep-2003 Enh#3052452,removed functions crsp_val_uv_sub_ind and crsp_val_uv_sup_ind.Also removed
9: local procedures crsp_val_non_inactive_subs,crsp_val_non_active_sups and crsp_val_non_active_subs and their calls also
10: smvk 10-Dec-2002 Bug # 2699913, Modified function crsp_val_uv_unit_sts not to do the
11: validations associated with following error messages for legacy data.
12: IGS_PS_UNIT_STATUS_CLOSED, IGS_PS_UNITSTATUS_NOT_ALTERED and IGS_PS_NEWUNITVER_ST_PLANNED
13: sarakshi 14-nov-2002 bug#2649028,modified function crsp_val_uv_pnt_ovrd,
14: crsp_val_uv_unit_sts
15: jbegum 21 Mar 02 As part of big fix of bug #2192616
16: Removed the exception handling part of the

Line 134: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

130: p_end_dt IN DATE ,
131: p_unit_status IN VARCHAR2 ,
132: p_message_name OUT NOCOPY VARCHAR2)
133: RETURN BOOLEAN AS
134: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
135: CURSOR c_get_s_unit_status IS
136: SELECT s_unit_status
137: FROM IGS_PS_UNIT_STAT
138: WHERE unit_status = p_unit_status;

Line 137: FROM IGS_PS_UNIT_STAT

133: RETURN BOOLEAN AS
134: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
135: CURSOR c_get_s_unit_status IS
136: SELECT s_unit_status
137: FROM IGS_PS_UNIT_STAT
138: WHERE unit_status = p_unit_status;
139: BEGIN
140: p_message_name := NULL;
141: OPEN c_get_s_unit_status;

Line 181: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

177: p_expiry_dt IN DATE ,
178: p_unit_status IN VARCHAR2 ,
179: p_message_name OUT NOCOPY VARCHAR2 )
180: RETURN BOOLEAN AS
181: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
182: v_check CHAR;
183: CURSOR c_get_s_unit_status IS
184: SELECT s_unit_status
185: FROM IGS_PS_UNIT_STAT

Line 185: FROM IGS_PS_UNIT_STAT

181: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
182: v_check CHAR;
183: CURSOR c_get_s_unit_status IS
184: SELECT s_unit_status
185: FROM IGS_PS_UNIT_STAT
186: WHERE unit_status = p_unit_status;
187: CURSOR c_check_uv_us IS
188: SELECT 'x'
189: FROM IGS_PS_UNIT_VER uv,

Line 190: IGS_PS_UNIT_STAT us

186: WHERE unit_status = p_unit_status;
187: CURSOR c_check_uv_us IS
188: SELECT 'x'
189: FROM IGS_PS_UNIT_VER uv,
190: IGS_PS_UNIT_STAT us
191: WHERE unit_cd = p_unit_cd AND
192: version_number <> p_version_number AND
193: expiry_dt IS NULL AND
194: uv.unit_status = us.unit_status AND

Line 371: -- Validate the IGS_PS_UNIT status for IGS_PS_UNIT version

367: IGS_GE_MSG_STACK.ADD;
368: App_Exception.Raise_Exception;
369: END crsp_val_uv_pnt_ovrd;
370: --
371: -- Validate the IGS_PS_UNIT status for IGS_PS_UNIT version
372: FUNCTION crsp_val_uv_unit_sts(
373: p_unit_cd IN VARCHAR2 ,
374: p_version_number IN NUMBER ,
375: p_new_unit_status IN VARCHAR2 ,

Line 383: gv_closed_ind IGS_PS_UNIT_STAT.closed_ind%TYPE;

379: RETURN BOOLEAN AS
380: cst_planned_status VARCHAR2(7);
381: cst_inactive_status VARCHAR2(8);
382: cst_active_status VARCHAR2(6);
383: gv_closed_ind IGS_PS_UNIT_STAT.closed_ind%TYPE;
384: gv_new_sys_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
385: gv_old_sys_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
386:
387: l_ret_status BOOLEAN :=TRUE;

Line 384: gv_new_sys_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

380: cst_planned_status VARCHAR2(7);
381: cst_inactive_status VARCHAR2(8);
382: cst_active_status VARCHAR2(6);
383: gv_closed_ind IGS_PS_UNIT_STAT.closed_ind%TYPE;
384: gv_new_sys_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
385: gv_old_sys_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
386:
387: l_ret_status BOOLEAN :=TRUE;
388:

Line 385: gv_old_sys_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

381: cst_inactive_status VARCHAR2(8);
382: cst_active_status VARCHAR2(6);
383: gv_closed_ind IGS_PS_UNIT_STAT.closed_ind%TYPE;
384: gv_new_sys_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
385: gv_old_sys_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
386:
387: l_ret_status BOOLEAN :=TRUE;
388:
389: CURSOR c_unit_sts_closed_ind IS

Line 391: FROM IGS_PS_UNIT_STAT

387: l_ret_status BOOLEAN :=TRUE;
388:
389: CURSOR c_unit_sts_closed_ind IS
390: SELECT closed_ind
391: FROM IGS_PS_UNIT_STAT
392: WHERE unit_status = p_new_unit_status;
393: CURSOR c_new_sys_status IS
394: SELECT s_unit_status
395: FROM IGS_PS_UNIT_STAT

Line 395: FROM IGS_PS_UNIT_STAT

391: FROM IGS_PS_UNIT_STAT
392: WHERE unit_status = p_new_unit_status;
393: CURSOR c_new_sys_status IS
394: SELECT s_unit_status
395: FROM IGS_PS_UNIT_STAT
396: WHERE unit_status = p_new_unit_status;
397: CURSOR c_old_sys_status IS
398: SELECT s_unit_status
399: FROM IGS_PS_UNIT_STAT

Line 399: FROM IGS_PS_UNIT_STAT

395: FROM IGS_PS_UNIT_STAT
396: WHERE unit_status = p_new_unit_status;
397: CURSOR c_old_sys_status IS
398: SELECT s_unit_status
399: FROM IGS_PS_UNIT_STAT
400: WHERE unit_status = p_old_unit_status;
401: BEGIN
402: --For gscc warning shifted down
403: cst_planned_status := 'PLANNED';

Line 424: p_message_name := 'IGS_PS_UNIT_STATUS_CLOSED';

420: END IF;
421: CLOSE c_unit_sts_closed_ind;
422: IF gv_closed_ind <> 'N' THEN
423: IF NOT p_lgcy_validator THEN
424: p_message_name := 'IGS_PS_UNIT_STATUS_CLOSED';
425: CLOSE c_unit_sts_closed_ind;
426: RETURN FALSE;
427: END IF;
428: END IF;

Line 431: --- Retrieve the system status for the new and old IGS_PS_UNIT statuses.

427: END IF;
428: END IF;
429: --- Validate the system status is not being altered to PLANNED from ACTIVE
430: --- or INACTIVE.
431: --- Retrieve the system status for the new and old IGS_PS_UNIT statuses.
432: OPEN c_new_sys_status;
433: FETCH c_new_sys_status INTO gv_new_sys_unit_status;
434: IF c_new_sys_status%NOTFOUND THEN
435: IF NOT p_lgcy_validator THEN

Line 516: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

512: -- * Validate that all referenced organisational units are active.
513: DECLARE
514: v_terminate BOOLEAN := FALSE;
515: v_uv_rec IGS_PS_UNIT_VER%ROWTYPE;
516: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
517: v_message_name VARCHAR2(30);
518: v_ret BOOLEAN;
519: CURSOR c_unit_version IS
520: SELECT *

Line 548: FROM IGS_PS_UNIT_STAT

544: WHERE unit_cd = p_unit_cd AND
545: version_number = p_version_number;
546: CURSOR c_get_s_unit_status IS
547: SELECT s_unit_status
548: FROM IGS_PS_UNIT_STAT
549: WHERE unit_status = p_old_unit_status;
550: CURSOR c_unit_offering IS
551: SELECT cal_type
552: FROM IGS_PS_UNIT_OFR

Line 694: -- No IGS_PS_UNIT_STAT found

690: RETURN FALSE;
691: END IF;
692: OPEN c_get_s_unit_status;
693: FETCH c_get_s_unit_status INTO v_s_unit_status;
694: -- No IGS_PS_UNIT_STAT found
695: IF (c_get_s_unit_status%NOTFOUND) THEN
696: CLOSE c_get_s_unit_status;
697: p_message_name := 'IGS_GE_VAL_DOES_NOT_XS';
698: RETURN FALSE;