APPS.IGS_TR_VAL_TRI SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

    p_inserting IN BOOLEAN ,
    p_message_name OUT NOCOPY VARCHAR2 )
  RETURN BOOLEAN IS

    gv_other_detail  VARCHAR2(255);

Line: 57

        SELECT  s_tracking_status, closed_ind
        FROM    igs_tr_status
        WHERE   tracking_status = cp_tracking_status;

Line: 81

      IF p_inserting THEN
        IF v_s_tracking_status <> 'ACTIVE' THEN
          p_message_name := 'IGS_TR_MUST_HAVE_STATUS_ACTIV';

Line: 121

      SELECT  closed_ind
      FROM    igs_tr_type
      WHERE   tracking_type = cp_tracking_type;

Line: 207

       	SELECT  closed_ind
        	FROM    igs_tr_step_ctlg
        	WHERE   step_catalog_cd = cp_step_catalog_cd;