eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_CLASS_RANK dependencies on IGS_PR_COHORT

Line 57: CURSOR cur_inst_query (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,

53: invalid_parameter_combination EXCEPTION;
54:
55: -- This cursor fetches the Cohart Instances
56:
57: CURSOR cur_inst_query (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
58: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
59: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
60: SELECT cohiv.*
61: FROM igs_pr_cohort_inst_v cohiv

Line 58: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

54:
55: -- This cursor fetches the Cohart Instances
56:
57: CURSOR cur_inst_query (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
58: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
59: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
60: SELECT cohiv.*
61: FROM igs_pr_cohort_inst_v cohiv
62: WHERE cohiv.cohort_name = cp_cohort_name

Line 59: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS

55: -- This cursor fetches the Cohart Instances
56:
57: CURSOR cur_inst_query (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
58: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
59: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
60: SELECT cohiv.*
61: FROM igs_pr_cohort_inst_v cohiv
62: WHERE cohiv.cohort_name = cp_cohort_name
63: AND cohiv.load_cal_type = cp_cal_type

Line 61: FROM igs_pr_cohort_inst_v cohiv

57: CURSOR cur_inst_query (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
58: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
59: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
60: SELECT cohiv.*
61: FROM igs_pr_cohort_inst_v cohiv
62: WHERE cohiv.cohort_name = cp_cohort_name
63: AND cohiv.load_cal_type = cp_cal_type
64: AND cohiv.load_ci_sequence_number = cp_ci_sequence_number ;
65:

Line 70: CURSOR cur_cohort_old (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,

66:
67:
68: -- This Cursor is used to get all the cohort name in the organization, whose instance are not present.
69:
70: CURSOR cur_cohort_old (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
71: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
72: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
73: SELECT cohr.cohort_name
74: FROM igs_pr_cohort cohr

Line 71: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

67:
68: -- This Cursor is used to get all the cohort name in the organization, whose instance are not present.
69:
70: CURSOR cur_cohort_old (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
71: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
72: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
73: SELECT cohr.cohort_name
74: FROM igs_pr_cohort cohr
75: WHERE cohr.org_unit_cd = cp_org_unit_cd

Line 72: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS

68: -- This Cursor is used to get all the cohort name in the organization, whose instance are not present.
69:
70: CURSOR cur_cohort_old (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
71: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
72: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
73: SELECT cohr.cohort_name
74: FROM igs_pr_cohort cohr
75: WHERE cohr.org_unit_cd = cp_org_unit_cd
76:

Line 74: FROM igs_pr_cohort cohr

70: CURSOR cur_cohort_old (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
71: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
72: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
73: SELECT cohr.cohort_name
74: FROM igs_pr_cohort cohr
75: WHERE cohr.org_unit_cd = cp_org_unit_cd
76:
77: MINUS
78:

Line 80: FROM igs_pr_cohort coh,

76:
77: MINUS
78:
79: SELECT cohi.cohort_name
80: FROM igs_pr_cohort coh,
81: igs_pr_cohort_inst cohi
82: WHERE coh.cohort_name = cohi.cohort_name
83: AND coh.org_unit_cd = cp_org_unit_cd
84: AND cohi.load_cal_type = cp_cal_type

Line 81: igs_pr_cohort_inst cohi

77: MINUS
78:
79: SELECT cohi.cohort_name
80: FROM igs_pr_cohort coh,
81: igs_pr_cohort_inst cohi
82: WHERE coh.cohort_name = cohi.cohort_name
83: AND coh.org_unit_cd = cp_org_unit_cd
84: AND cohi.load_cal_type = cp_cal_type
85: AND cohi.load_ci_sequence_number = cp_ci_sequence_number ;

Line 90: CURSOR cur_cohort_inst_exist (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,

86:
87:
88: -- This Cursor is used to get all the cohort name in the organization, whose instance are not present.
89:
90: CURSOR cur_cohort_inst_exist (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
91: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
92: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
93: SELECT cohi.*
94: FROM igs_pr_cohort coh,

Line 91: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

87:
88: -- This Cursor is used to get all the cohort name in the organization, whose instance are not present.
89:
90: CURSOR cur_cohort_inst_exist (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
91: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
92: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
93: SELECT cohi.*
94: FROM igs_pr_cohort coh,
95: igs_pr_cohort_inst cohi

Line 92: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS

88: -- This Cursor is used to get all the cohort name in the organization, whose instance are not present.
89:
90: CURSOR cur_cohort_inst_exist (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
91: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
92: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
93: SELECT cohi.*
94: FROM igs_pr_cohort coh,
95: igs_pr_cohort_inst cohi
96: WHERE coh.cohort_name = cohi.cohort_name

Line 94: FROM igs_pr_cohort coh,

90: CURSOR cur_cohort_inst_exist (cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
91: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
92: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
93: SELECT cohi.*
94: FROM igs_pr_cohort coh,
95: igs_pr_cohort_inst cohi
96: WHERE coh.cohort_name = cohi.cohort_name
97: AND coh.org_unit_cd = cp_org_unit_cd
98: AND cohi.load_cal_type = cp_cal_type

Line 95: igs_pr_cohort_inst cohi

91: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
92: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
93: SELECT cohi.*
94: FROM igs_pr_cohort coh,
95: igs_pr_cohort_inst cohi
96: WHERE coh.cohort_name = cohi.cohort_name
97: AND coh.org_unit_cd = cp_org_unit_cd
98: AND cohi.load_cal_type = cp_cal_type
99: AND cohi.load_ci_sequence_number = cp_ci_sequence_number ;

Line 103: CURSOR cur_cohort_org_inst (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,

99: AND cohi.load_ci_sequence_number = cp_ci_sequence_number ;
100:
101: -- This Cursor is used to get all the cohort instance when in the particular Orginanization
102:
103: CURSOR cur_cohort_org_inst (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
104: cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
105: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
106: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
107: SELECT cohi.cohort_name

Line 104: cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,

100:
101: -- This Cursor is used to get all the cohort instance when in the particular Orginanization
102:
103: CURSOR cur_cohort_org_inst (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
104: cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
105: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
106: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
107: SELECT cohi.cohort_name
108: FROM igs_pr_cohort coh,

Line 105: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

101: -- This Cursor is used to get all the cohort instance when in the particular Orginanization
102:
103: CURSOR cur_cohort_org_inst (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
104: cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
105: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
106: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
107: SELECT cohi.cohort_name
108: FROM igs_pr_cohort coh,
109: igs_pr_cohort_inst cohi

Line 106: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS

102:
103: CURSOR cur_cohort_org_inst (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
104: cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
105: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
106: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
107: SELECT cohi.cohort_name
108: FROM igs_pr_cohort coh,
109: igs_pr_cohort_inst cohi
110: WHERE coh.cohort_name = cohi.cohort_name

Line 108: FROM igs_pr_cohort coh,

104: cp_org_unit_cd igs_pr_cohort_inst.cohort_name%TYPE,
105: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
106: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
107: SELECT cohi.cohort_name
108: FROM igs_pr_cohort coh,
109: igs_pr_cohort_inst cohi
110: WHERE coh.cohort_name = cohi.cohort_name
111: AND coh.cohort_name = cp_cohort_name
112: AND coh.org_unit_cd = cp_org_unit_cd

Line 109: igs_pr_cohort_inst cohi

105: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
106: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
107: SELECT cohi.cohort_name
108: FROM igs_pr_cohort coh,
109: igs_pr_cohort_inst cohi
110: WHERE coh.cohort_name = cohi.cohort_name
111: AND coh.cohort_name = cp_cohort_name
112: AND coh.org_unit_cd = cp_org_unit_cd
113: AND cohi.load_cal_type = cp_cal_type

Line 119: cp_org_unit_cd igs_pr_cohort.org_unit_cd%TYPE,

115:
116: -- Cursor Finds if cogert exists for the organization
117:
118: CURSOR cur_cohort_org (
119: cp_org_unit_cd igs_pr_cohort.org_unit_cd%TYPE,
120: cp_cohort_name igs_pr_cohort.cohort_name%TYPE) IS
121: SELECT coh.cohort_name
122: FROM igs_pr_cohort coh
123: WHERE coh.org_unit_cd = cp_org_unit_cd

Line 120: cp_cohort_name igs_pr_cohort.cohort_name%TYPE) IS

116: -- Cursor Finds if cogert exists for the organization
117:
118: CURSOR cur_cohort_org (
119: cp_org_unit_cd igs_pr_cohort.org_unit_cd%TYPE,
120: cp_cohort_name igs_pr_cohort.cohort_name%TYPE) IS
121: SELECT coh.cohort_name
122: FROM igs_pr_cohort coh
123: WHERE coh.org_unit_cd = cp_org_unit_cd
124: AND coh.cohort_name = cp_cohort_name;

Line 122: FROM igs_pr_cohort coh

118: CURSOR cur_cohort_org (
119: cp_org_unit_cd igs_pr_cohort.org_unit_cd%TYPE,
120: cp_cohort_name igs_pr_cohort.cohort_name%TYPE) IS
121: SELECT coh.cohort_name
122: FROM igs_pr_cohort coh
123: WHERE coh.org_unit_cd = cp_org_unit_cd
124: AND coh.cohort_name = cp_cohort_name;
125:
126:

Line 161: igs_pr_cohort_inst_pkg.INSERT_ROW(

157: CLOSE cur_inst_query;
158:
159: l_rowid := NULL;
160:
161: igs_pr_cohort_inst_pkg.INSERT_ROW(
162: x_rowid => l_rowid ,
163: x_cohort_name => p_cohort_name,
164: x_load_cal_type => p_cal_type ,
165: x_load_ci_sequence_number => p_ci_sequence_number ,

Line 228: igs_pr_cohort_inst_pkg.insert_row(

224: FOR cohort_old_rec IN cur_cohort_old (p_org_unit_cd,p_cal_type,p_ci_sequence_number) LOOP
225:
226: -- The Cohort Instances are created for the Cohort Name which are in the Organization but does not have the Instance
227:
228: igs_pr_cohort_inst_pkg.insert_row(
229: x_rowid => l_rowid ,
230: x_cohort_name => cohort_old_rec.cohort_name,
231: x_load_cal_type => p_cal_type ,
232: x_load_ci_sequence_number => p_ci_sequence_number ,

Line 296: igs_pr_cohort_inst_pkg.insert_row(

292: l_count := l_count + 1;
293:
294: -- Instance for this cohort is created and then the ranking process for this new instance is run.
295:
296: igs_pr_cohort_inst_pkg.insert_row(
297: x_rowid => l_rowid ,
298: x_cohort_name => cohort_org_rec.cohort_name,
299: x_load_cal_type => p_cal_type ,
300: x_load_ci_sequence_number => p_ci_sequence_number ,

Line 398: CURSOR cur_rank_status (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,

394: p_id number;
395:
396: -- This Cursor fetches the Rank status for the corrosponding Cohort Name
397:
398: CURSOR cur_rank_status (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
399: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
400: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE ) IS
401: SELECT *
402: FROM igs_pr_cohort_inst_v

Line 399: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

395:
396: -- This Cursor fetches the Rank status for the corrosponding Cohort Name
397:
398: CURSOR cur_rank_status (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
399: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
400: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE ) IS
401: SELECT *
402: FROM igs_pr_cohort_inst_v
403: WHERE cohort_name = cp_cohort_name

Line 400: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE ) IS

396: -- This Cursor fetches the Rank status for the corrosponding Cohort Name
397:
398: CURSOR cur_rank_status (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
399: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
400: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE ) IS
401: SELECT *
402: FROM igs_pr_cohort_inst_v
403: WHERE cohort_name = cp_cohort_name
404: AND load_cal_type = cp_cal_type

Line 402: FROM igs_pr_cohort_inst_v

398: CURSOR cur_rank_status (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
399: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
400: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE ) IS
401: SELECT *
402: FROM igs_pr_cohort_inst_v
403: WHERE cohort_name = cp_cohort_name
404: AND load_cal_type = cp_cal_type
405: AND load_ci_sequence_number = cp_ci_sequence_number;
406:

Line 410: CURSOR cur_stat_type (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE) IS

406:
407:
408: -- This Cursor fetches the Stat type,TimeFrame for the corrosponding Cohort Name
409:
410: CURSOR cur_stat_type (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE) IS
411: SELECT *
412: FROM igs_pr_cohort
413: WHERE cohort_name = cp_cohort_name ;
414:

Line 412: FROM igs_pr_cohort

408: -- This Cursor fetches the Stat type,TimeFrame for the corrosponding Cohort Name
409:
410: CURSOR cur_stat_type (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE) IS
411: SELECT *
412: FROM igs_pr_cohort
413: WHERE cohort_name = cp_cohort_name ;
414:
415: -- The cursor is used when the Cohort Status is FROZEN and the rank status is Not Final. This cursor is used when,
416: -- the Dense Rank Indicator is set as 'N' in the table igs_pr_cohort

Line 416: -- the Dense Rank Indicator is set as 'N' in the table igs_pr_cohort

412: FROM igs_pr_cohort
413: WHERE cohort_name = cp_cohort_name ;
414:
415: -- The cursor is used when the Cohort Status is FROZEN and the rank status is Not Final. This cursor is used when,
416: -- the Dense Rank Indicator is set as 'N' in the table igs_pr_cohort
417:
418: TYPE cur_frozen_rank IS REF CURSOR;
419:
420: -- The cursor is used when the Cohort Status is FROZEN and the rank status is Not Final. This cursor is used when,

Line 421: -- the Dense Rank Indicator is set as 'Y' in the table igs_pr_cohort

417:
418: TYPE cur_frozen_rank IS REF CURSOR;
419:
420: -- The cursor is used when the Cohort Status is FROZEN and the rank status is Not Final. This cursor is used when,
421: -- the Dense Rank Indicator is set as 'Y' in the table igs_pr_cohort
422:
423: TYPE cur_frozen_denserank IS REF CURSOR;
424:
425:

Line 428: CURSOR cur_cal_cat (cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE ) IS

424:
425:
426: -- Cursor to determine the Calander Category for a particular calander type
427:
428: CURSOR cur_cal_cat (cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE ) IS
429: SELECT s_cal_cat
430: FROM igs_ca_type
431: WHERE cal_type = cp_cal_type ;
432:

Line 435: CURSOR cur_acad_cal (cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

431: WHERE cal_type = cp_cal_type ;
432:
433: -- Cursor to determine the Academic Calander for the corrosponding load calander
434:
435: CURSOR cur_acad_cal (cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
436: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
437: SELECT sup_cal_type, sup_ci_sequence_number
438: FROM igs_ca_inst_rel
439: WHERE

Line 436: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS

432:
433: -- Cursor to determine the Academic Calander for the corrosponding load calander
434:
435: CURSOR cur_acad_cal (cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
436: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
437: SELECT sup_cal_type, sup_ci_sequence_number
438: FROM igs_ca_inst_rel
439: WHERE
440: sub_cal_type = cp_cal_type

Line 446: -- This cursor is used when,the Dense Rank Indicator is set as 'N' in the table igs_pr_cohort

442: AND sup_cal_type IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC') ;
443:
444: --
445: -- Cursor used to rank the student based on the Rule. This is done when the rank status is not FINAL and the cohort status is WORKING
446: -- This cursor is used when,the Dense Rank Indicator is set as 'N' in the table igs_pr_cohort
447: --
448:
449: TYPE cur_student_ranked_query IS REF CURSOR;
450:

Line 454: -- This cursor is used when,the Dense Rank Indicator is set as 'Y' in the table igs_pr_cohort

450:
451:
452: --
453: -- Cursor used to rank the student based on the Rule. This is done when the rank status is not FINAL and the cohort status is WORKING
454: -- This cursor is used when,the Dense Rank Indicator is set as 'Y' in the table igs_pr_cohort
455: --
456:
457: TYPE cur_student_denseranked_query IS REF CURSOR;
458:

Line 462: CURSOR cur_old_rank (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,

458:
459:
460: -- Cursor get the old data when the cohort status is 'WORKING'
461:
462: CURSOR cur_old_rank (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
463: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
464: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
465: SELECT cohi.*
466: FROM igs_pr_cohort_inst_rank_v cohi

Line 463: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

459:
460: -- Cursor get the old data when the cohort status is 'WORKING'
461:
462: CURSOR cur_old_rank (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
463: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
464: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
465: SELECT cohi.*
466: FROM igs_pr_cohort_inst_rank_v cohi
467: WHERE cohi.cohort_name = cp_cohort_name

Line 464: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS

460: -- Cursor get the old data when the cohort status is 'WORKING'
461:
462: CURSOR cur_old_rank (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
463: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
464: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
465: SELECT cohi.*
466: FROM igs_pr_cohort_inst_rank_v cohi
467: WHERE cohi.cohort_name = cp_cohort_name
468: AND cohi.load_cal_type = cp_cal_type

Line 466: FROM igs_pr_cohort_inst_rank_v cohi

462: CURSOR cur_old_rank (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
463: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
464: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
465: SELECT cohi.*
466: FROM igs_pr_cohort_inst_rank_v cohi
467: WHERE cohi.cohort_name = cp_cohort_name
468: AND cohi.load_cal_type = cp_cal_type
469: AND cohi.load_ci_sequence_number = cp_ci_sequence_number ;
470:

Line 474: CURSOR cur_cohort_inst_person (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,

470:
471:
472: -- Cursor get the cohort Institution Name Corrosponding to the cp_cohort_name,cp_cal_type,cp_ci_sequence_number
473:
474: CURSOR cur_cohort_inst_person (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
475: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
476: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
477: cp_person_id igs_en_sca_v.person_id%TYPE,
478: cp_course_cd igs_en_sca_v.course_cd%TYPE) IS

Line 475: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

471:
472: -- Cursor get the cohort Institution Name Corrosponding to the cp_cohort_name,cp_cal_type,cp_ci_sequence_number
473:
474: CURSOR cur_cohort_inst_person (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
475: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
476: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
477: cp_person_id igs_en_sca_v.person_id%TYPE,
478: cp_course_cd igs_en_sca_v.course_cd%TYPE) IS
479: SELECT cohi.*

Line 476: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,

472: -- Cursor get the cohort Institution Name Corrosponding to the cp_cohort_name,cp_cal_type,cp_ci_sequence_number
473:
474: CURSOR cur_cohort_inst_person (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
475: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
476: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
477: cp_person_id igs_en_sca_v.person_id%TYPE,
478: cp_course_cd igs_en_sca_v.course_cd%TYPE) IS
479: SELECT cohi.*
480: FROM igs_pr_cohort_inst_rank_v cohi

Line 480: FROM igs_pr_cohort_inst_rank_v cohi

476: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
477: cp_person_id igs_en_sca_v.person_id%TYPE,
478: cp_course_cd igs_en_sca_v.course_cd%TYPE) IS
479: SELECT cohi.*
480: FROM igs_pr_cohort_inst_rank_v cohi
481: WHERE cohi.cohort_name = cp_cohort_name
482: AND cohi.load_cal_type = cp_cal_type
483: AND cohi.load_ci_sequence_number = cp_ci_sequence_number
484: AND cohi.person_id = cp_person_id

Line 629: -- This means that the student population is frozen. The student population is chosen from IGS_PR_COHORT_INST_RANK_V. This is the population that needs to be ranked.

625:
626: END IF; --3
627:
628: -- Ranking for the student are done for the students where the rank status is working and the cohort status is 'FROZEN'
629: -- This means that the student population is frozen. The student population is chosen from IGS_PR_COHORT_INST_RANK_V. This is the population that needs to be ranked.
630:
631: IF rank_status_rec.cohort_status = 'FROZEN' THEN --2
632: p_count := 0;
633:

Line 638: -- The Dense Rank Indicator should be set as 'N' in the table igs_pr_cohort

634: IF stat_type_rec.dense_rank_ind = 'N' THEN --4
635:
636: --
637: -- Ranking the student in the Cohert in a particular Calender Instance when the Rank Status is Not final and the Cohort Status Is Froozen.
638: -- The Dense Rank Indicator should be set as 'N' in the table igs_pr_cohort
639: --(p_cohort_name,p_cal_type,p_ci_sequence_number,stat_type_rec.stat_type,l_cumulative_ind)
640:
641: OPEN frozen_rank_type_rec FOR
642: 'SELECT res.*,

Line 654: FROM igs_pr_cohort_inst_rank_v cohiv

650: cohiv.load_ci_sequence_number,
651: ''' || stat_type_rec.stat_type || ''',
652: '''|| l_cumulative_ind || '''
653: ) cum_gpa
654: FROM igs_pr_cohort_inst_rank_v cohiv
655: WHERE cohiv.cohort_name = ''' || p_cohort_name || '''
656: AND cohiv.load_cal_type = ''' || p_cal_type || '''
657: AND cohiv.load_ci_sequence_number = ' || p_ci_sequence_number || ') res' ;
658:

Line 698: -- The Dense Rank Indicator should be set as 'Y' in the table igs_pr_cohort

694: ELSIF stat_type_rec.dense_rank_ind = 'Y' THEN --4
695:
696: --
697: -- Ranking the student in the Cohert in a particular Calender Instance when the Rank Status is Not final and the Cohort Status Is Froozen
698: -- The Dense Rank Indicator should be set as 'Y' in the table igs_pr_cohort
699: --
700:
701: OPEN frozen_denserank_type_rec FOR
702: 'SELECT res.*,

Line 714: FROM igs_pr_cohort_inst_rank_v cohiv

710: cohiv.load_ci_sequence_number,
711: ''' || stat_type_rec.stat_type || ''',
712: '''|| l_cumulative_ind || '''
713: ) cum_gpa
714: FROM igs_pr_cohort_inst_rank_v cohiv
715: WHERE cohiv.cohort_name = ''' || p_cohort_name || '''
716: AND cohiv.load_cal_type = ''' || p_cal_type || '''
717: AND cohiv.load_ci_sequence_number = ' || p_ci_sequence_number || ') res' ;
718:

Line 763: igs_pr_cohort_inst_pkg.update_row(

759: --
760: -- Updating the Cohert Instance table with the rundate as the System Date. Rest of the values are retained.
761: --
762:
763: igs_pr_cohort_inst_pkg.update_row(
764: x_rowid => rank_status_rec.row_id,
765: x_cohort_name => rank_status_rec.cohort_name,
766: x_load_cal_type => rank_status_rec.load_cal_type,
767: x_load_ci_sequence_number => rank_status_rec.load_ci_sequence_number,

Line 827: IF stat_type_rec.dense_rank_ind = 'N' THEN -- The Dense Rank Indicator should be set as 'N' in the table igs_pr_cohort

823:
824: l_acad_cal := '(' || '''' || p_cal_type || '''' || ')' ;
825:
826: END IF;
827: IF stat_type_rec.dense_rank_ind = 'N' THEN -- The Dense Rank Indicator should be set as 'N' in the table igs_pr_cohort
828: l_old_count := 0;
829:
830: -- The existing list of students whose ranking is done for the Cohort Instance
831:

Line 1010: ELSIF stat_type_rec.dense_rank_ind = 'Y' THEN -- The Dense Rank Indicator should be set as 'Y' in the table igs_pr_cohort

1006: END IF;
1007:
1008: END LOOP;
1009:
1010: ELSIF stat_type_rec.dense_rank_ind = 'Y' THEN -- The Dense Rank Indicator should be set as 'Y' in the table igs_pr_cohort
1011:
1012: l_old_count := 0;
1013:
1014: -- The existing list of students whose ranking is done for the Cohort Instance

Line 1197: igs_pr_cohort_inst_pkg.update_row(

1193: --
1194: -- Updating the Cohert Instance table with the rundate as the System Date. Rest of the values are retained.
1195: --
1196:
1197: igs_pr_cohort_inst_pkg.update_row(
1198: x_rowid => rank_status_rec.row_id,
1199: x_cohort_name => rank_status_rec.cohort_name,
1200: x_load_cal_type => rank_status_rec.load_cal_type,
1201: x_load_ci_sequence_number => rank_status_rec.load_ci_sequence_number,

Line 1225: p_cohort_name IN igs_pr_cohort.cohort_name%TYPE,

1221:
1222: FUNCTION get_cum_gpa
1223: ( p_person_id IN igs_en_sca_v.person_id%TYPE,
1224: p_course_cd IN igs_en_sca_v.course_cd%TYPE,
1225: p_cohort_name IN igs_pr_cohort.cohort_name%TYPE,
1226: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1227: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1228: p_stat_type IN VARCHAR2,
1229: p_cumulative_ind IN VARCHAR2

Line 1522: CURSOR c_dflt_disp_type (cp_cohort_name igs_pr_cohort.cohort_name%TYPE) IS

1518: x_msg_count OUT NOCOPY NUMBER,
1519: x_msg_data OUT NOCOPY VARCHAR2)
1520: AS
1521: -- cursor to get default display type
1522: CURSOR c_dflt_disp_type (cp_cohort_name igs_pr_cohort.cohort_name%TYPE) IS
1523: SELECT dflt_display_type
1524: FROM igs_pr_cohort
1525: WHERE cohort_name = cp_cohort_name;
1526: l_disp_type igs_pr_cohort.dflt_display_type%TYPE;

Line 1524: FROM igs_pr_cohort

1520: AS
1521: -- cursor to get default display type
1522: CURSOR c_dflt_disp_type (cp_cohort_name igs_pr_cohort.cohort_name%TYPE) IS
1523: SELECT dflt_display_type
1524: FROM igs_pr_cohort
1525: WHERE cohort_name = cp_cohort_name;
1526: l_disp_type igs_pr_cohort.dflt_display_type%TYPE;
1527:
1528: -- cursor to select the rank

Line 1526: l_disp_type igs_pr_cohort.dflt_display_type%TYPE;

1522: CURSOR c_dflt_disp_type (cp_cohort_name igs_pr_cohort.cohort_name%TYPE) IS
1523: SELECT dflt_display_type
1524: FROM igs_pr_cohort
1525: WHERE cohort_name = cp_cohort_name;
1526: l_disp_type igs_pr_cohort.dflt_display_type%TYPE;
1527:
1528: -- cursor to select the rank
1529: CURSOR c_rank (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1530: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

Line 1529: CURSOR c_rank (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,

1525: WHERE cohort_name = cp_cohort_name;
1526: l_disp_type igs_pr_cohort.dflt_display_type%TYPE;
1527:
1528: -- cursor to select the rank
1529: CURSOR c_rank (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1530: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1531: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
1532: cp_person_id igs_pr_cohinst_rank.person_id%TYPE,
1533: cp_program_cd igs_pr_cohinst_rank.course_cd%TYPE) IS

Line 1530: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

1526: l_disp_type igs_pr_cohort.dflt_display_type%TYPE;
1527:
1528: -- cursor to select the rank
1529: CURSOR c_rank (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1530: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1531: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
1532: cp_person_id igs_pr_cohinst_rank.person_id%TYPE,
1533: cp_program_cd igs_pr_cohinst_rank.course_cd%TYPE) IS
1534: SELECT NVL(cohort_override_rank, cohort_rank)

Line 1531: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,

1527:
1528: -- cursor to select the rank
1529: CURSOR c_rank (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1530: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1531: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
1532: cp_person_id igs_pr_cohinst_rank.person_id%TYPE,
1533: cp_program_cd igs_pr_cohinst_rank.course_cd%TYPE) IS
1534: SELECT NVL(cohort_override_rank, cohort_rank)
1535: FROM igs_pr_cohort_inst_rank_v cohirv

Line 1535: FROM igs_pr_cohort_inst_rank_v cohirv

1531: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
1532: cp_person_id igs_pr_cohinst_rank.person_id%TYPE,
1533: cp_program_cd igs_pr_cohinst_rank.course_cd%TYPE) IS
1534: SELECT NVL(cohort_override_rank, cohort_rank)
1535: FROM igs_pr_cohort_inst_rank_v cohirv
1536: WHERE cohirv.cohort_name = cp_cohort_name
1537: AND cohirv.load_cal_type = cp_cal_type
1538: AND cohirv.load_ci_sequence_number = cp_ci_sequence_number
1539: AND cohirv.person_id = cp_person_id

Line 1544: CURSOR c_cohort_population (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,

1540: AND cohirv.course_cd = cp_program_cd;
1541: l_rank igs_pr_cohinst_rank.cohort_rank%TYPE;
1542:
1543: -- cursor to get the cohort population
1544: CURSOR c_cohort_population (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1545: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1546: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
1547: SELECT COUNT (*)
1548: FROM igs_pr_cohort_inst_rank_v cohirv

Line 1545: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,

1541: l_rank igs_pr_cohinst_rank.cohort_rank%TYPE;
1542:
1543: -- cursor to get the cohort population
1544: CURSOR c_cohort_population (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1545: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1546: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
1547: SELECT COUNT (*)
1548: FROM igs_pr_cohort_inst_rank_v cohirv
1549: WHERE cohirv.cohort_name = cp_cohort_name

Line 1546: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS

1542:
1543: -- cursor to get the cohort population
1544: CURSOR c_cohort_population (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1545: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1546: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
1547: SELECT COUNT (*)
1548: FROM igs_pr_cohort_inst_rank_v cohirv
1549: WHERE cohirv.cohort_name = cp_cohort_name
1550: AND cohirv.load_cal_type = cp_cal_type

Line 1548: FROM igs_pr_cohort_inst_rank_v cohirv

1544: CURSOR c_cohort_population (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1545: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1546: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
1547: SELECT COUNT (*)
1548: FROM igs_pr_cohort_inst_rank_v cohirv
1549: WHERE cohirv.cohort_name = cp_cohort_name
1550: AND cohirv.load_cal_type = cp_cal_type
1551: AND cohirv.load_ci_sequence_number = cp_ci_sequence_number;
1552: