APPS.IGS_TR_VAL_TRI dependencies on IGS_TR_STEP_CTLG

Line 204: v_closed_ind igs_tr_step_ctlg.closed_ind%TYPE;

200: FUNCTION val_tr_step_ctlg(
201: p_step_catalog_cd IN VARCHAR2 ,
202: p_message_name OUT NOCOPY VARCHAR2 )
203: RETURN BOOLEAN IS
204: v_closed_ind igs_tr_step_ctlg.closed_ind%TYPE;
205:
206: CURSOR c_get_closed_ind ( cp_step_catalog_cd igs_tr_step_ctlg.step_catalog_cd%TYPE) IS
207: SELECT closed_ind
208: FROM igs_tr_step_ctlg

Line 206: CURSOR c_get_closed_ind ( cp_step_catalog_cd igs_tr_step_ctlg.step_catalog_cd%TYPE) IS

202: p_message_name OUT NOCOPY VARCHAR2 )
203: RETURN BOOLEAN IS
204: v_closed_ind igs_tr_step_ctlg.closed_ind%TYPE;
205:
206: CURSOR c_get_closed_ind ( cp_step_catalog_cd igs_tr_step_ctlg.step_catalog_cd%TYPE) IS
207: SELECT closed_ind
208: FROM igs_tr_step_ctlg
209: WHERE step_catalog_cd = cp_step_catalog_cd;
210:

Line 208: FROM igs_tr_step_ctlg

204: v_closed_ind igs_tr_step_ctlg.closed_ind%TYPE;
205:
206: CURSOR c_get_closed_ind ( cp_step_catalog_cd igs_tr_step_ctlg.step_catalog_cd%TYPE) IS
207: SELECT closed_ind
208: FROM igs_tr_step_ctlg
209: WHERE step_catalog_cd = cp_step_catalog_cd;
210:
211: BEGIN
212:

Line 222: p_message_name := 'IGS_TR_STEP_CTLG_CLOSED';

218: RETURN TRUE;
219: END IF;
220: CLOSE c_get_closed_ind;
221: IF (v_closed_ind = 'Y') THEN
222: p_message_name := 'IGS_TR_STEP_CTLG_CLOSED';
223: RETURN FALSE;
224: END IF;
225: RETURN TRUE;
226: END val_tr_step_ctlg;