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.

[Home] [Help]

APPS.IGS_PR_CLASS_RANK dependencies on IGS_PR_COHORT_INST

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 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 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 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 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 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 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 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 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 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 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 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: