APPS.IGS_PR_CLSRNK_LGCY_PUB SQL Statements

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

Line: 172

	      insert into igs_pr_cohinst_rank
	   */
           INSERT INTO IGS_PR_COHINST_RANK (
			PERSON_ID              ,
			COURSE_CD              ,
			COHORT_NAME            ,
			LOAD_CAL_TYPE          ,
			LOAD_CI_SEQUENCE_NUMBER,
			AS_OF_RANK_GPA         ,
			COHORT_RANK            ,
			COHORT_OVERRIDE_RANK   ,
			COMMENTS               ,
			CREATED_BY             ,
			CREATION_DATE          ,
			LAST_UPDATED_BY        ,
			LAST_UPDATE_DATE       ,
			LAST_UPDATE_LOGIN      ,
			REQUEST_ID             ,
			PROGRAM_APPLICATION_ID ,
			PROGRAM_ID             ,
			PROGRAM_UPDATE_DATE )
			VALUES (
                        l_person_id,
			p_lgcy_clsrnk_rec.program_cd,
			p_lgcy_clsrnk_rec.cohort_name,
			l_cal_type,
			l_sequence_number,
                        p_lgcy_clsrnk_rec.as_of_rank_gpa,
			p_lgcy_clsrnk_rec.cohort_rank,
			p_lgcy_clsrnk_rec.cohort_override_rank,
			p_lgcy_clsrnk_rec.comments,
			NVL(FND_GLOBAL.USER_ID,-1),
                        SYSDATE,
			NVL(FND_GLOBAL.USER_ID,-1),
			SYSDATE,
			NVL(FND_GLOBAL.LOGIN_ID,-1),
			DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
			DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
			DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
			DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE)
			);