APPS.IGS_FI_GET_SCAEH SQL Statements

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

Line: 17

  		SELECT	*
  		FROM	IGS_EN_STDNT_PS_ATT	sca
  		WHERE	sca.person_id = p_person_id AND
  			sca.course_cd = p_course_cd AND
  			sca.logical_delete_dt IS NULL;

Line: 23

  		SELECT	*
  		FROM	IGS_AS_SC_ATTEMPT_H	scah
  		WHERE	scah.person_id = p_person_id AND
  			scah.course_cd = p_course_cd AND
  			cp_effective_dt	BETWEEN	scah.hist_start_dt AND
  						scah.hist_end_dt;

Line: 44

  		gr_scaeh.r_scah.hist_who := p_sca_rec.LAST_UPDATED_BY;

Line: 89

  		gr_scaeh.r_scah.LAST_UPDATED_BY := p_sca_rec.LAST_UPDATED_BY;

Line: 90

  		gr_scaeh.r_scah.LAST_UPDATE_DATE := p_sca_rec.LAST_UPDATE_DATE;

Line: 438

  		gr_scaeh.r_scah.LAST_UPDATED_BY := p_scah_rec.LAST_UPDATED_BY;

Line: 439

  		gr_scaeh.r_scah.LAST_UPDATE_DATE := p_scah_rec.LAST_UPDATE_DATE;

Line: 508

  		gr_scaeh.r_scah.LAST_UPDATED_BY := p_scahv_rec.LAST_UPDATED_BY;

Line: 509

  		gr_scaeh.r_scah.LAST_UPDATE_DATE := p_scahv_rec.LAST_UPDATE_DATE;

Line: 526

  			SELECT	*
  			FROM	IGS_AS_SCA_H_V	scahv
  			WHERE	scahv.person_id = p_person_id AND
  				scahv.course_cd = p_course_cd AND
  				scahv.course_attempt_status = 'ENROLLED' AND
  				cp_effective_dt	<= scahv.hist_start_dt
  			ORDER BY scahv.hist_start_dt desc;

Line: 560

  			IF TRUNC(gv_effective_dt) >= TRUNC(p_sca_rec.LAST_UPDATE_DATE) THEN
  				-- save the current sca data
--commented by syam to avoid adchkdrv errors -dbms_output.put_line('before finpl_ins_sca_rec');

Line: 564

  						p_sca_rec.LAST_UPDATE_DATE,
  						SYSDATE,
  						p_sca_rec);

Line: 574

  						p_sca_rec.LAST_UPDATE_DATE,
  						p_sca_rec);

Line: 593

  	--	  		-> DELETED
  	--			-> INACTIVE
  	--
  	--	DELETED		-> UNCONFIRM
  	--
  	--	ENROLLED	-> UNCONFIRM
  	--			-> DISCONTIN
  	--			-> LAPSED
  	--			-> INACTIVE
  	--			-> INTERMIT
  	--			-> COMPLETED
  	--
  	--	LAPSED		-> ENROLLED
  	--			-> DISCONTIN
  	--			-> INACTIVE
  	--
  	--	INACTIVE	-> UNCONFIRM
  	--			-> ENROLLED
  	--			-> DISCONTIN
  	--			-> COMPLETED
  	--			-> INTERMIT
  	--			-> LAPSED
  	--
  	--	INTERMIT	-> ENROLLED
  	--			-> DISCONTIN
  	--			-> COMPLETED
  	--			-> INACTIVE
  	--
  	--	DISCONTIN	-> ENROLLED
  	--			-> LAPSED
  	--			-> INACTIVE
  	--			-> INTERMIT
  	--
  	--	COMPLETE	-> ENROLLED
  	--			-> INACTIVE
  	--
  	-- the effective history transitions are
  	--	UNCONFIRM -> ENROLLED -> INTERMIT -> ENROLLED -> COMPLETED
  	--	UNCONFIRM -> ENROLLED -> DISCONTIN
  	-- check parameters
--commented by syam to avoid adchkdrv errors -dbms_output.put_line('in procedure : IGS_FI_GET_SCAEH.FINP_GET_SCAEH');

Line: 705

  					r_sca.LAST_UPDATE_DATE,
  					gv_effective_dt,
  					r_sca);

Line: 922

  			IF TRUNC(gv_effective_dt) >= TRUNC(r_sca.LAST_UPDATE_DATE) THEN
  				-- save the current student IGS_PS_COURSE attempt data
--commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');

Line: 925

  				finpl_ins_sca_rec(r_sca.LAST_UPDATE_DATE,
  						SYSDATE,
  						r_sca);

Line: 982

  	ELSIF r_sca.course_attempt_status = 'DELETED' THEN
  		IF v_scah_found = TRUE THEN
  			IF r_scah.course_attempt_status IN ('DELETED',
  							'UNCONFIRM') THEN
  				-- save the student IGS_PS_COURSE attempt history data
--commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_scah_rec');

Line: 992

  			ELSE	-- delete overrides history
  				-- save the current student IGS_PS_COURSE attempt data
--commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');

Line: 1003

  			IF TRUNC(gv_effective_dt) >= TRUNC(r_sca.LAST_UPDATE_DATE) THEN
  				-- save the current student IGS_PS_COURSE attempt data
--commented by syam to avoid adchkdrv errors -dbms_output.put_line('b finpl_ins_sca_rec');

Line: 1006

  				finpl_ins_sca_rec(	r_sca.LAST_UPDATE_DATE,
  							SYSDATE,
  							r_sca);