DBA Data[Home] [Help]

APPS.IGS_PR_CLSRNK_LGCY_PUB dependencies on IGS_PR_COHINST_RANK

Line 172: insert into igs_pr_cohinst_rank

168: p_lgcy_clsrnk_rec => p_lgcy_clsrnk_rec
169: );
170: IF l_return = 'S' THEN
171: /*
172: insert into igs_pr_cohinst_rank
173: */
174: INSERT INTO IGS_PR_COHINST_RANK (
175: PERSON_ID ,
176: COURSE_CD ,

Line 174: INSERT INTO IGS_PR_COHINST_RANK (

170: IF l_return = 'S' THEN
171: /*
172: insert into igs_pr_cohinst_rank
173: */
174: INSERT INTO IGS_PR_COHINST_RANK (
175: PERSON_ID ,
176: COURSE_CD ,
177: COHORT_NAME ,
178: LOAD_CAL_TYPE ,

Line 437: IF IGS_PR_COHINST_RANK_PKG.GET_PK_FOR_VALIDATION

433: If yes, then set the message IGS_PR_RANK_EXIST into message stack and return
434: from the function with return value 'W', as the record already exists in
435: the system, so no need to do other validations
436: */
437: IF IGS_PR_COHINST_RANK_PKG.GET_PK_FOR_VALIDATION
438: (
439: x_person_id => p_person_id,
440: x_course_cd => p_lgcy_clsrnk_rec.program_cd,
441: x_cohort_name => p_lgcy_clsrnk_rec.cohort_name,