APPS.IGS_PS_VAL_CAW SQL Statements

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

Line: 42

  FUNCTION crsp_val_caw_insert(
  p_course_cd IN VARCHAR2 ,
  p_version_number IN NUMBER ,
  p_message_name OUT NOCOPY VARCHAR2 )
  RETURN BOOLEAN AS
  	v_award_crs_ind		IGS_PS_TYPE.award_course_ind%TYPE;

Line: 49

  		SELECT	award_course_ind
  		FROM	IGS_PS_VER,
  			IGS_PS_TYPE
  		WHERE	course_cd		= p_course_cd		AND
  			version_number		= p_version_number	AND
  			IGS_PS_VER.course_type	= IGS_PS_TYPE.course_type;

Line: 60

  		-- validate the insert of IGS_PS_AWARD record
  		IF (v_award_crs_ind <> 'Y') THEN
  			p_message_name := 'IGS_PS_PRGAWARD_MAYNOT_CREAT';

Line: 73

		Fnd_Message.Set_Token('NAME','IGS_PS_VAL_CAW.crsp_val_caw_insert');

Line: 76

  END crsp_val_caw_insert;