APPS.IGS_TR_VAL_TRI dependencies on IGS_TR_TYPE

Line 119: v_closed_ind igs_tr_type.closed_ind%TYPE;

115:
116: -- Validate the IGS_TR_ITEM.tracking_type.
117: DECLARE
118:
119: v_closed_ind igs_tr_type.closed_ind%TYPE;
120: CURSOR c_get_closed_ind ( cp_tracking_type igs_tr_item.tracking_type%TYPE) IS
121: SELECT closed_ind
122: FROM igs_tr_type
123: WHERE tracking_type = cp_tracking_type;

Line 122: FROM igs_tr_type

118:
119: v_closed_ind igs_tr_type.closed_ind%TYPE;
120: CURSOR c_get_closed_ind ( cp_tracking_type igs_tr_item.tracking_type%TYPE) IS
121: SELECT closed_ind
122: FROM igs_tr_type
123: WHERE tracking_type = cp_tracking_type;
124:
125: BEGIN
126:

Line 140: p_message_name := 'IGS_TR_TYPE_CLOSED';

136: IF (v_closed_ind = 'N') THEN
137: RETURN TRUE;
138: END IF;
139:
140: p_message_name := 'IGS_TR_TYPE_CLOSED';
141:
142: RETURN FALSE;
143:
144: END;