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_AD_ASSIGN_EVAL_AI_PKG dependencies on IGS_AD_APPL_EVAL

Line 55: FROM igs_ad_appl_eval aev

51: FROM igs_ad_ou_stat ou
52: WHERE ou.s_adm_outcome_status = 'PENDING'
53: AND apl.adm_outcome_status = ou.adm_outcome_status )
54: AND NOT EXISTS (SELECT '1'
55: FROM igs_ad_appl_eval aev
56: WHERE aev.person_id = apl.person_id
57: AND aev.admission_appl_number = apl.admission_appl_number
58: AND aev.nominated_course_cd = apl.nominated_course_cd
59: AND aev.sequence_number = apl.sequence_number );

Line 81: FROM igs_ad_appl_eval aev

77: FROM igs_ad_ou_stat ou
78: WHERE ou.s_adm_outcome_status = 'PENDING'
79: AND apl.adm_outcome_status = ou.adm_outcome_status )
80: AND NOT EXISTS (SELECT '1'
81: FROM igs_ad_appl_eval aev
82: WHERE aev.person_id = apl.person_id
83: AND aev.admission_appl_number = apl.admission_appl_number
84: AND aev.nominated_course_cd = apl.nominated_course_cd
85: AND aev.sequence_number = apl.sequence_number )

Line 108: FROM igs_ad_appl_eval aev

104: FROM igs_ad_ou_stat ou
105: WHERE ou.s_adm_outcome_status = 'PENDING'
106: AND apl.adm_outcome_status = ou.adm_outcome_status )
107: AND NOT EXISTS (SELECT '1'
108: FROM igs_ad_appl_eval aev
109: WHERE aev.person_id = apl.person_id
110: AND aev.admission_appl_number = apl.admission_appl_number
111: AND aev.nominated_course_cd = apl.nominated_course_cd
112: AND aev.sequence_number = apl.sequence_number )

Line 331: CURSOR c_igs_ad_appl_eval_s

327: WHERE arr.appl_rev_profile_id = cp_appl_rev_profile_id;
328:
329: arp_rate_scale_rec c_arp_rate_scale%ROWTYPE;
330:
331: CURSOR c_igs_ad_appl_eval_s
332: IS
333: SELECT Igs_ad_appl_eval_s.nextval
334: FROM DUAL;
335:

Line 333: SELECT Igs_ad_appl_eval_s.nextval

329: arp_rate_scale_rec c_arp_rate_scale%ROWTYPE;
330:
331: CURSOR c_igs_ad_appl_eval_s
332: IS
333: SELECT Igs_ad_appl_eval_s.nextval
334: FROM DUAL;
335:
336: -- Cursor fetching the review_profile_name for the corresponding review profile id (rghosh bug#2871426)
337: CURSOR c_appl_rev_profile (cp_appl_rev_profile_id igs_ad_apl_rev_prf.appl_rev_profile_id%TYPE) IS

Line 346: CURSOR c_existing_evaluators (cp_person_id igs_ad_appl_eval.person_id%TYPE,

342: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;
343:
344:
345: -- Cursor to get the existing evaluators (rghosh bug #2986802)
346: CURSOR c_existing_evaluators (cp_person_id igs_ad_appl_eval.person_id%TYPE,
347: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
348: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
349: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE ) IS
350: SELECT *

Line 347: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,

343:
344:
345: -- Cursor to get the existing evaluators (rghosh bug #2986802)
346: CURSOR c_existing_evaluators (cp_person_id igs_ad_appl_eval.person_id%TYPE,
347: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
348: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
349: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE ) IS
350: SELECT *
351: FROM igs_ad_appl_eval_v

Line 348: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,

344:
345: -- Cursor to get the existing evaluators (rghosh bug #2986802)
346: CURSOR c_existing_evaluators (cp_person_id igs_ad_appl_eval.person_id%TYPE,
347: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
348: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
349: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE ) IS
350: SELECT *
351: FROM igs_ad_appl_eval_v
352: WHERE person_id = cp_person_id

Line 349: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE ) IS

345: -- Cursor to get the existing evaluators (rghosh bug #2986802)
346: CURSOR c_existing_evaluators (cp_person_id igs_ad_appl_eval.person_id%TYPE,
347: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
348: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
349: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE ) IS
350: SELECT *
351: FROM igs_ad_appl_eval_v
352: WHERE person_id = cp_person_id
353: AND admission_appl_number = cp_admission_appl_number

Line 351: FROM igs_ad_appl_eval_v

347: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
348: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
349: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE ) IS
350: SELECT *
351: FROM igs_ad_appl_eval_v
352: WHERE person_id = cp_person_id
353: AND admission_appl_number = cp_admission_appl_number
354: AND nominated_course_cd = cp_nominated_course_cd
355: AND sequence_number = cp_sequence_number;

Line 360: CURSOR c_max_evaluation_sequence(cp_person_id igs_ad_appl_eval.person_id%TYPE,

356:
357: l_existing_evaluators_rec c_existing_evaluators%ROWTYPE;
358:
359: -- Cursor to fetch the next evaluation sequence that is available for that particular application instance (rghosh bug #2986802)
360: CURSOR c_max_evaluation_sequence(cp_person_id igs_ad_appl_eval.person_id%TYPE,
361: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
362: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
363: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE) IS
364: SELECT (max(evaluation_sequence))

Line 361: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,

357: l_existing_evaluators_rec c_existing_evaluators%ROWTYPE;
358:
359: -- Cursor to fetch the next evaluation sequence that is available for that particular application instance (rghosh bug #2986802)
360: CURSOR c_max_evaluation_sequence(cp_person_id igs_ad_appl_eval.person_id%TYPE,
361: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
362: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
363: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE) IS
364: SELECT (max(evaluation_sequence))
365: FROM igs_ad_appl_eval

Line 362: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,

358:
359: -- Cursor to fetch the next evaluation sequence that is available for that particular application instance (rghosh bug #2986802)
360: CURSOR c_max_evaluation_sequence(cp_person_id igs_ad_appl_eval.person_id%TYPE,
361: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
362: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
363: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE) IS
364: SELECT (max(evaluation_sequence))
365: FROM igs_ad_appl_eval
366: WHERE person_id = cp_person_id

Line 363: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE) IS

359: -- Cursor to fetch the next evaluation sequence that is available for that particular application instance (rghosh bug #2986802)
360: CURSOR c_max_evaluation_sequence(cp_person_id igs_ad_appl_eval.person_id%TYPE,
361: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
362: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
363: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE) IS
364: SELECT (max(evaluation_sequence))
365: FROM igs_ad_appl_eval
366: WHERE person_id = cp_person_id
367: AND admission_appl_number = cp_admission_appl_number

Line 365: FROM igs_ad_appl_eval

361: cp_admission_appl_number igs_ad_appl_eval.admission_appl_number%TYPE,
362: cp_nominated_course_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
363: cp_sequence_number igs_ad_appl_eval.sequence_number%TYPE) IS
364: SELECT (max(evaluation_sequence))
365: FROM igs_ad_appl_eval
366: WHERE person_id = cp_person_id
367: AND admission_appl_number = cp_admission_appl_number
368: AND nominated_course_cd = cp_nominated_course_cd
369: AND sequence_number = cp_sequence_number;

Line 391: l_igs_ad_appl_eval_s NUMBER;

387: l_evaluators_exists VARCHAR2(1);
388: l_matching_ind VARCHAR2(1);
389:
390: lv_rowid VARCHAR2(25);
391: l_igs_ad_appl_eval_s NUMBER;
392: l_sequence_number NUMBER:= 0;
393: i NUMBER:= 0;
394: l_exists VARCHAR2(1);
395: l_list_count BINARY_INTEGER := 0 ;

Line 478: -- Get the next sequence value for table igs_ad_appl_eval.

474: LOOP -- Loop through all the Rating Scales of that Application Review Profile.
475: FETCH c_arp_rate_scale INTO arp_rate_scale_rec;
476: EXIT WHEN c_arp_rate_scale%NOTFOUND;
477:
478: -- Get the next sequence value for table igs_ad_appl_eval.
479: OPEN c_igs_ad_appl_eval_s;
480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;
481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';

Line 479: OPEN c_igs_ad_appl_eval_s;

475: FETCH c_arp_rate_scale INTO arp_rate_scale_rec;
476: EXIT WHEN c_arp_rate_scale%NOTFOUND;
477:
478: -- Get the next sequence value for table igs_ad_appl_eval.
479: OPEN c_igs_ad_appl_eval_s;
480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;
481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(

Line 480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;

476: EXIT WHEN c_arp_rate_scale%NOTFOUND;
477:
478: -- Get the next sequence value for table igs_ad_appl_eval.
479: OPEN c_igs_ad_appl_eval_s;
480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;
481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(
484: x_rowid => lv_rowid,

Line 481: CLOSE c_igs_ad_appl_eval_s;

477:
478: -- Get the next sequence value for table igs_ad_appl_eval.
479: OPEN c_igs_ad_appl_eval_s;
480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;
481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(
484: x_rowid => lv_rowid,
485: x_appl_eval_id => l_igs_ad_appl_eval_s,

Line 483: Igs_ad_appl_eval_pkg.insert_row(

479: OPEN c_igs_ad_appl_eval_s;
480: FETCH c_igs_ad_appl_eval_s INTO l_igs_ad_appl_eval_s;
481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(
484: x_rowid => lv_rowid,
485: x_appl_eval_id => l_igs_ad_appl_eval_s,
486: x_person_id => p_person_id,
487: x_admission_appl_number => p_admission_appl_number,

Line 485: x_appl_eval_id => l_igs_ad_appl_eval_s,

481: CLOSE c_igs_ad_appl_eval_s;
482: l_rating_exists := 'Y';
483: Igs_ad_appl_eval_pkg.insert_row(
484: x_rowid => lv_rowid,
485: x_appl_eval_id => l_igs_ad_appl_eval_s,
486: x_person_id => p_person_id,
487: x_admission_appl_number => p_admission_appl_number,
488: x_nominated_course_cd => p_nominated_course_cd,
489: x_sequence_number=> p_sequence_number,

Line 637: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.eval_appl',

633: p_parameterlist=>l_parameter_list_t);
634: --
635: -- raise the event
636: --
637: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.eval_appl',
638: p_event_key => l_itemKey,
639: p_parameters => l_parameter_list_t);
640:
641: l_parameter_list_t.delete;

Line 655: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,

651: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
652: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
653: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
654: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
655: p_faculty_id IN igs_ad_appl_eval.evaluator_id%TYPE,
656: p_roletype IN VARCHAR2,
657: p_eval_type IN VARCHAR2,
658: p_eval_seq_number IN NUMBER)
659: RETURN VARCHAR2 IS

Line 672: From igs_ad_appl_eval

668: IF p_roletype = 'ADMIN' THEN
669:
670: Select count(rowid)
671: Into l_no_of_evaluators
672: From igs_ad_appl_eval
673: Where person_id = p_person_id
674: And Admission_appl_number = p_admission_appl_number
675: And Nominated_course_cd = p_nominated_course_cd
676: And sequence_number = p_sequence_number;

Line 680: From igs_ad_appl_eval

676: And sequence_number = p_sequence_number;
677:
678: Select count(rowid)
679: Into l_count
680: From igs_ad_appl_eval
681: Where person_id = p_person_id
682: And Admission_appl_number = p_admission_appl_number
683: And Nominated_course_cd = p_nominated_course_cd
684: And sequence_number = p_sequence_number

Line 705: From igs_ad_appl_eval

701: ELSIF p_roletype = 'FACULTY' THEN
702:
703: Select count(rowid)
704: Into l_no_of_evaluators
705: From igs_ad_appl_eval
706: Where person_id = p_person_id
707: And Admission_appl_number = p_admission_appl_number
708: And Nominated_course_cd = p_nominated_course_cd
709: And sequence_number = p_sequence_number

Line 714: From igs_ad_appl_eval

710: AND EVALUATOR_ID = p_faculty_id;
711:
712: Select count(rowid)
713: Into l_count
714: From igs_ad_appl_eval
715: Where person_id = p_person_id
716: And Admission_appl_number = p_admission_appl_number
717: And Nominated_course_cd = p_nominated_course_cd
718: And sequence_number = p_sequence_number

Line 725: l_prev_seq_number := igs_ad_appl_eval_pkg.find_prev_seq_number(p_person_id,

721: And evaluation_date is not null
722: And rating_scale_id is not null
723: And evaluator_id = p_faculty_id;
724:
725: l_prev_seq_number := igs_ad_appl_eval_pkg.find_prev_seq_number(p_person_id,
726: p_admission_appl_number,
727: p_nominated_course_cd,
728: p_sequence_number,
729: p_eval_seq_number);

Line 732: From igs_ad_appl_eval

728: p_sequence_number,
729: p_eval_seq_number);
730: Select count(rowid)
731: Into l_prev_count
732: From igs_ad_appl_eval
733: Where person_id = p_person_id
734: And Admission_appl_number = p_admission_appl_number
735: And Nominated_course_cd = p_nominated_course_cd
736: And sequence_number = p_sequence_number

Line 827: igs_ad_appl_eval_pkg.g_dns_ind := 'N';

823: -- rghosh (bug # 2871426 - Evaluator entry and assignment
824: PROCEDURE set_dns_ind (x_do_not_send_notif IN VARCHAR2) IS
825: BEGIN
826: IF NVL(x_do_not_send_notif,'N') = 'N' THEN
827: igs_ad_appl_eval_pkg.g_dns_ind := 'N';
828: ELSE
829: igs_ad_appl_eval_pkg.g_dns_ind := 'Y';
830: END IF;
831: END set_dns_ind;

Line 829: igs_ad_appl_eval_pkg.g_dns_ind := 'Y';

825: BEGIN
826: IF NVL(x_do_not_send_notif,'N') = 'N' THEN
827: igs_ad_appl_eval_pkg.g_dns_ind := 'N';
828: ELSE
829: igs_ad_appl_eval_pkg.g_dns_ind := 'Y';
830: END IF;
831: END set_dns_ind;
832:
833: --this function will return the value of the next sequence number that has to be assigned to new evaluator who is added manually

Line 839: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,

835: FUNCTION set_eval_sequence (p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
836: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
837: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
838: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
839: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
840: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
841: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE ) RETURN NUMBER IS
842:
843: CURSOR eval_type_cur( cp_person_id igs_ad_appl_arp.person_id%TYPE,

Line 840: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,

836: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
837: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
838: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
839: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
840: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
841: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE ) RETURN NUMBER IS
842:
843: CURSOR eval_type_cur( cp_person_id igs_ad_appl_arp.person_id%TYPE,
844: cp_admission_appl_number igs_ad_appl_arp.admission_appl_number%TYPE,

Line 841: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE ) RETURN NUMBER IS

837: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
838: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
839: p_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE,
840: p_rating_type_id igs_ad_appl_eval.rating_type_id%TYPE,
841: p_rating_scale_id igs_ad_appl_eval.rating_scale_id%TYPE ) RETURN NUMBER IS
842:
843: CURSOR eval_type_cur( cp_person_id igs_ad_appl_arp.person_id%TYPE,
844: cp_admission_appl_number igs_ad_appl_arp.admission_appl_number%TYPE,
845: cp_nominated_course_cd igs_ad_appl_arp.nominated_course_cd%TYPE,

Line 860: cp_person_id igs_ad_appl_eval.person_id%TYPE,

856: and nominated_course_cd = cp_nominated_course_cd
857: and sequence_number = cp_sequence_number);
858:
859: CURSOR c_max_evaluation_sequence(
860: cp_person_id igs_ad_appl_eval.person_id%TYPE,
861: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
862: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
863: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE) IS
864: SELECT

Line 861: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,

857: and sequence_number = cp_sequence_number);
858:
859: CURSOR c_max_evaluation_sequence(
860: cp_person_id igs_ad_appl_eval.person_id%TYPE,
861: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
862: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
863: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE) IS
864: SELECT
865: (max(evaluation_sequence)+1)

Line 862: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,

858:
859: CURSOR c_max_evaluation_sequence(
860: cp_person_id igs_ad_appl_eval.person_id%TYPE,
861: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
862: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
863: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE) IS
864: SELECT
865: (max(evaluation_sequence)+1)
866: FROM

Line 863: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE) IS

859: CURSOR c_max_evaluation_sequence(
860: cp_person_id igs_ad_appl_eval.person_id%TYPE,
861: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
862: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
863: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE) IS
864: SELECT
865: (max(evaluation_sequence)+1)
866: FROM
867: igs_ad_appl_eval

Line 867: igs_ad_appl_eval

863: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE) IS
864: SELECT
865: (max(evaluation_sequence)+1)
866: FROM
867: igs_ad_appl_eval
868: WHERE
869: person_id = cp_person_id AND
870: admission_appl_number = cp_adm_apl_num AND
871: nominated_course_cd = cp_nom_crs_cd AND

Line 875: cp_person_id igs_ad_appl_eval.person_id%TYPE,

871: nominated_course_cd = cp_nom_crs_cd AND
872: sequence_number = cp_seq_number;
873:
874: CURSOR c_next_seq (
875: cp_person_id igs_ad_appl_eval.person_id%TYPE,
876: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
877: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,
879: cp_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE) IS

Line 876: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,

872: sequence_number = cp_seq_number;
873:
874: CURSOR c_next_seq (
875: cp_person_id igs_ad_appl_eval.person_id%TYPE,
876: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
877: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,
879: cp_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE) IS
880: SELECT *

Line 877: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,

873:
874: CURSOR c_next_seq (
875: cp_person_id igs_ad_appl_eval.person_id%TYPE,
876: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
877: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,
879: cp_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE) IS
880: SELECT *
881: FROM igs_ad_appl_eval

Line 878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,

874: CURSOR c_next_seq (
875: cp_person_id igs_ad_appl_eval.person_id%TYPE,
876: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
877: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,
879: cp_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE) IS
880: SELECT *
881: FROM igs_ad_appl_eval
882: WHERE person_id = cp_person_id

Line 879: cp_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE) IS

875: cp_person_id igs_ad_appl_eval.person_id%TYPE,
876: cp_adm_apl_num igs_ad_appl_eval.admission_appl_number%TYPE,
877: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,
879: cp_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE) IS
880: SELECT *
881: FROM igs_ad_appl_eval
882: WHERE person_id = cp_person_id
883: AND admission_appl_number = cp_adm_apl_num

Line 881: FROM igs_ad_appl_eval

877: cp_nom_crs_cd igs_ad_appl_eval.nominated_course_cd%TYPE,
878: cp_seq_number igs_ad_appl_eval.sequence_number%TYPE,
879: cp_evaluator_id igs_ad_appl_eval.evaluator_id%TYPE) IS
880: SELECT *
881: FROM igs_ad_appl_eval
882: WHERE person_id = cp_person_id
883: AND admission_appl_number = cp_adm_apl_num
884: AND nominated_course_cd = cp_nom_crs_cd
885: AND sequence_number = cp_seq_number

Line 891: l_count igs_ad_appl_eval.evaluation_sequence%TYPE;

887:
888: l_next_seq c_next_seq%ROWTYPE;
889: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
890: l_exist_arp_id igs_ad_appl_arp_v.appl_rev_profile_id%TYPE;
891: l_count igs_ad_appl_eval.evaluation_sequence%TYPE;
892: l_max_evaluation_sequence igs_ad_appl_eval.evaluation_sequence%TYPE;
893: l_chk_rating_val_null VARCHAR2(1);
894:
895: BEGIN

Line 892: l_max_evaluation_sequence igs_ad_appl_eval.evaluation_sequence%TYPE;

888: l_next_seq c_next_seq%ROWTYPE;
889: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
890: l_exist_arp_id igs_ad_appl_arp_v.appl_rev_profile_id%TYPE;
891: l_count igs_ad_appl_eval.evaluation_sequence%TYPE;
892: l_max_evaluation_sequence igs_ad_appl_eval.evaluation_sequence%TYPE;
893: l_chk_rating_val_null VARCHAR2(1);
894:
895: BEGIN
896: OPEN eval_type_cur(p_person_id,p_admission_appl_number,p_nominated_course_cd,p_sequence_number);