APPS.IGS_EN_VAL_UDDC dependencies on IGS_AD_ADM_UNIT_STAT

Line 15: FROM IGS_AD_ADM_UNIT_STAT

11:
12: v_closed_ind VARCHAR2(1);
13: CURSOR c_aus IS
14: SELECT closed_ind
15: FROM IGS_AD_ADM_UNIT_STAT
16: WHERE administrative_unit_status = p_aus;
17: BEGIN
18: -- Check if the IGS_AD_ADM_UNIT_STAT is closed
19: p_message_name := null;

Line 18: -- Check if the IGS_AD_ADM_UNIT_STAT is closed

14: SELECT closed_ind
15: FROM IGS_AD_ADM_UNIT_STAT
16: WHERE administrative_unit_status = p_aus;
17: BEGIN
18: -- Check if the IGS_AD_ADM_UNIT_STAT is closed
19: p_message_name := null;
20: OPEN c_aus;
21: FETCH c_aus INTO v_closed_ind;
22: IF (c_aus%NOTFOUND) THEN

Line 50: v_unit_att_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;

46: RETURN BOOLEAN AS
47: BEGIN
48: DECLARE
49:
50: v_unit_att_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
51: CURSOR c_aus IS
52: SELECT unit_attempt_status
53: FROM IGS_AD_ADM_UNIT_STAT
54: WHERE administrative_unit_status = p_aus;

Line 53: FROM IGS_AD_ADM_UNIT_STAT

49:
50: v_unit_att_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
51: CURSOR c_aus IS
52: SELECT unit_attempt_status
53: FROM IGS_AD_ADM_UNIT_STAT
54: WHERE administrative_unit_status = p_aus;
55: BEGIN
56: -- Check if the IGS_AD_ADM_UNIT_STAT is closed
57: p_message_name := null;

Line 56: -- Check if the IGS_AD_ADM_UNIT_STAT is closed

52: SELECT unit_attempt_status
53: FROM IGS_AD_ADM_UNIT_STAT
54: WHERE administrative_unit_status = p_aus;
55: BEGIN
56: -- Check if the IGS_AD_ADM_UNIT_STAT is closed
57: p_message_name := null;
58: OPEN c_aus;
59: FETCH c_aus INTO v_unit_att_status;
60: IF (c_aus%NOTFOUND) THEN

Line 141: -- either the IGS_AD_ADM_UNIT_STAT field or the delete_ind field

137: BEGIN
138: DECLARE
139: BEGIN
140: --When inserting/updating unit discontinuation date criteria, ensure that
141: -- either the IGS_AD_ADM_UNIT_STAT field or the delete_ind field
142: -- is set.
143: p_message_name := null;
144: IF (p_aus IS NULL AND
145: p_delete_ind <> 'Y') THEN