APPS.IGS_AD_ASSIGN_EVAL_AI_PKG dependencies on IGS_AD_APPL_EVAL_PKG

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