APPS.IGS_PS_GEN_007 SQL Statements

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

Line: 14

		SELECT	srct.lookup_code
		FROM	IGS_GE_REF_CD_TYPE	rct,
			IGS_LOOKUPS_VIEW	srct
		WHERE	rct.reference_cd_type		= p_reference_cd_type AND
			rct.closed_ind			= 'N' AND
			srct.lookup_code        	= rct.s_reference_cd_type AND
			srct.lookup_type			= 'REFERENCE_CD_TYPE' AND
			srct.closed_ind			= 'N';

Line: 53

  p_last_update_on IN DATE ,
  p_update_on IN DATE ,
  p_last_update_who IN VARCHAR2 ,
  p_percentage IN NUMBER )
--who        when          what
--sarakshi   12-Apr-2006   Bug#3655441, modified procedure crsp_ins_cow_hist to include PLANNED status also
AS
	v_s_course_status	IGS_PS_STAT.s_course_status%TYPE;

Line: 62

		SELECT s_course_status
		FROM 	IGS_PS_STAT, IGS_PS_VER
		WHERE	IGS_PS_VER.course_cd	= p_course_cd		AND
			IGS_PS_VER.version_number 	= p_version_number 	AND
			IGS_PS_STAT.course_status	= IGS_PS_VER.course_status;

Line: 78

		IGS_PS_OWN_HIST_PKG.Insert_Row(
						X_ROWID        	=> x_rowid,
						X_COURSE_CD    	=>p_course_cd,
						X_HIST_START_DT	=>p_last_update_on,
						X_OU_START_DT  	=>p_ou_start_dt,
						X_VERSION_NUMBER	=>p_version_number,
						X_ORG_UNIT_CD  	=>p_org_unit_cd,
						X_HIST_END_DT  	=>p_update_on,
						X_HIST_WHO     	=>p_last_update_who,
						X_PERCENTAGE   	=>p_percentage,
						X_MODE         	=>'R',
						X_ORG_ID        =>l_org_id);

Line: 104

  p_last_update_on IN DATE ,
  p_update_on IN DATE ,
  p_last_update_who IN VARCHAR2 ,
  p_description IN VARCHAR2 )
--who        when          what
--sarakshi   12-Apr-2006   Bug#3655441, modified procedure crsp_ins_cow_hist to include PLANNED status also
AS
	CURSOR	c_course_status(
			cp_course_cd IGS_PS_VER.course_cd%TYPE,
			cp_version_number IGS_PS_VER.version_number%TYPE) IS
		SELECT	IGS_PS_STAT.s_course_status
		FROM	IGS_PS_STAT,IGS_PS_VER
		WHERE	IGS_PS_VER.course_cd = cp_course_cd AND
			IGS_PS_VER.version_number = cp_version_number AND
			IGS_PS_STAT.course_status = IGS_PS_VER.course_status;

Line: 132

		IGS_PS_REF_CD_HIST_PKG.Insert_Row(
					 X_ROWID      		=>x_rowid,
				       X_COURSE_CD 	 	=>p_course_cd,
					 X_REFERENCE_CD_TYPE    =>p_reference_cd_type,
					 X_REFERENCE_CD         =>p_reference_cd,
					 X_HIST_START_DT        =>p_last_update_on,
					 X_VERSION_NUMBER       =>p_version_number,
					 X_HIST_END_DT          =>p_update_on,
					 X_HIST_WHO             =>p_last_update_who,
					 X_DESCRIPTION          =>p_description,
					 X_MODE                 =>'R',
					 X_ORG_ID               =>l_org_id);

Line: 158

  p_last_update_on IN DATE ,
  p_update_on IN DATE ,
  p_last_update_who IN VARCHAR2 ,
  p_unit_level IN VARCHAR2 ,
  p_wam_weighting IN NUMBER,
  p_course_cd VARCHAR2,
  p_course_version_number NUMBER)
--who        when          what
--sarakshi   12-Apr-2006   Bug#3655441, modified procedure crsp_ins_cow_hist to include PLANNED status also

AS
	v_s_unit_status		IGS_PS_UNIT_STAT.s_unit_status%TYPE;

Line: 171

		SELECT s_unit_status
		FROM 	IGS_PS_UNIT_STAT, IGS_PS_UNIT_VER
		WHERE	IGS_PS_UNIT_VER.unit_cd		= p_unit_cd		AND
			IGS_PS_UNIT_VER.version_number 	= p_version_number 	AND
			IGS_PS_UNIT_STAT.unit_status		= IGS_PS_UNIT_VER.unit_status;

Line: 189

		IGS_PS_UNIT_LVL_HIST_PKG.Insert_Row(
						X_ROWID                  => x_rowid,
						X_UNIT_CD                => p_unit_cd,
						X_VERSION_NUMBER         =>p_version_number,
						X_HIST_START_DT          =>p_last_update_on,
						X_HIST_END_DT            =>p_update_on,
						X_HIST_WHO               =>p_last_update_who,
						X_UNIT_LEVEL             =>p_unit_level,
						X_WAM_WEIGHTING          =>p_wam_weighting,
						X_MODE                   =>'R',
						X_ORG_ID                 =>l_org_id,
						X_COURSE_CD              =>p_course_cd,
                                                X_COURSE_VERSION_NUMBER  =>p_course_version_number
						);