APPS.IGS_CA_VAL_DAIOC SQL Statements

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

Line: 15

  		SELECT	s_cal_cat
  		FROM	IGS_CA_TYPE
  		WHERE	cal_type = cp_cal_type;

Line: 77

  		SELECT	daoc.s_dt_offset_constraint_type,
  			daoc.constraint_condition,
  			daoc.constraint_resolution
  		FROM	IGS_CA_DA_OFFCNT	 daoc
  		WHERE	daoc.dt_alias			= p_dt_alias		AND
  			daoc.offset_dt_alias		= p_offset_dt_alias	AND
  			daoc.s_dt_offset_constraint_type <> p_s_dt_offset_constraint_type;

Line: 85

  		SELECT	daioc.s_dt_offset_constraint_type,
  			daioc.constraint_condition,
  			daioc.constraint_resolution
  		FROM	IGS_CA_DA_INST_OFCNT	 daioc
  		WHERE	daioc.dt_alias			= p_dt_alias		AND
  			daioc.dai_sequence_number	= p_dai_sequence_number	AND
  			daioc.cal_type			= p_cal_type		AND
  			daioc.ci_sequence_number	= p_ci_sequence_number	AND
  			daioc.offset_dt_alias		= p_offset_dt_alias	AND
  			daioc.offset_dai_sequence_number = p_offset_dai_sequence_number AND
  			daioc.offset_cal_type		= p_offset_cal_type	AND
  			daioc.offset_ci_sequence_number = p_offset_ci_sequence_number	AND
  			daioc.s_dt_offset_constraint_type <> p_s_dt_offset_constraint_type;

Line: 279

  	-- 3. Use a loop to select each existing constraint record and determine if
  	--    the current s_dt_offset_constraint_type clashes with an existing
  	--    s_dt_offset_constraint_type for the same dt_alias/offset_dt_alias.
  	IF p_cal_type IS NULL THEN
  		-- function has been called from IGS_CA_DA_OFFCNT
  		FOR v_daoc_rec IN c_daoc LOOP
  			v_message_name := calpl_val_constraint(
  								p_s_dt_offset_constraint_type,
  								p_constraint_condition,
  								v_daoc_rec.s_dt_offset_constraint_type,
  								v_daoc_rec.constraint_condition,
  								v_daoc_rec.constraint_resolution);

Line: 350

  		SELECT 	'X'
  		FROM	IGS_CA_DA_INST_OFST	daio,
  			IGS_CA_DA_INST_OFCNT	daioc
  		WHERE	daio.dt_alias = p_dt_alias AND
  			daio.dai_sequence_number = p_dai_sequence_number AND
  			daio.cal_type = p_cal_type AND
  			daio.ci_sequence_number = p_ci_sequence_number AND
  			daioc.dt_alias = daio.dt_alias AND
  			daioc.dai_sequence_number = daio.dai_sequence_number AND
  			daioc.cal_type = daio.cal_type AND
  			daioc.ci_sequence_number = daio.ci_sequence_number;

Line: 388

  		SELECT	sdoct.closed_ind
  		FROM	IGS_LOOKUPS_VIEW	sdoct
  		WHERE	sdoct.LOOKUP_CODE = p_s_dt_offset_constraint_type
		AND	sdoct.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE';