APPS.IGS_EN_VAL_UDDC SQL Statements

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

Line: 14

  		SELECT	closed_ind
  		FROM	IGS_AD_ADM_UNIT_STAT
  		WHERE	administrative_unit_status = p_aus;

Line: 52

  		SELECT	unit_attempt_status
  		FROM	IGS_AD_ADM_UNIT_STAT
  		WHERE	administrative_unit_status = p_aus;

Line: 91

  		SELECT 	s_cal_cat,
  			closed_ind
  		FROM	IGS_CA_DA
  		WHERE	dt_alias = p_dt_alias;

Line: 133

  p_delete_ind IN VARCHAR2 DEFAULT 'N',
  p_message_name OUT NOCOPY varchar2 )
  RETURN BOOLEAN AS

  BEGIN
  DECLARE
  BEGIN
  	--When inserting/updating unit discontinuation date criteria, ensure that
  	-- either the IGS_AD_ADM_UNIT_STAT field or the delete_ind field
  	-- is set.
  	p_message_name := null;

Line: 145

  			p_delete_ind <> 'Y') THEN
  		p_message_name := 'IGS_EN_ADMIN_UNIT_ST_DEL';

Line: 150

  			p_delete_ind = 'Y') THEN
  		p_message_name := 'IGS_EN_ADMIN_UNIT_ST_NOTSET';