[Home] [Help]
504: WHERE interface_run_id = p_interface_run_id
505: AND status = cst_s_val_2
506: AND ( ( NVL(match_ind,'15') = '15'
507: AND NOT EXISTS ( SELECT 1
508: FROM igs_ad_unit_sets mn_rec
509: WHERE mn_rec.person_id = in_rec.person_id
510: AND mn_rec.sequence_number = in_rec.sequence_number
511: AND mn_rec.unit_set_cd = in_rec.unit_set_cd
512: AND mn_rec.version_number = in_rec.version_number
521: AND status = cst_s_val_2
522: AND ( (p_rule = cst_rule_val_I)
523: OR (p_rule = cst_rule_val_R AND match_ind = cst_mi_val_21))
524: AND EXISTS ( SELECT 1
525: FROM igs_ad_unit_sets mn_rec
526: WHERE mn_rec.person_id = in_rec.person_id
527: AND mn_rec.sequence_number = in_rec.sequence_number
528: AND mn_rec.unit_set_cd = in_rec.unit_set_cd
529: AND mn_rec.version_number = in_rec.version_number
531: AND mn_rec.nominated_course_cd = in_rec.nominated_course_cd);
532:
533: CURSOR c_null_hdlg_unitsets_cur_rec(cp_unit_set_cur c_igs_ad_unitsets_int%ROWTYPE) IS
534: SELECT ROWID, mn_rec.*
535: FROM igs_ad_unit_sets mn_rec
536: WHERE mn_rec.person_id = cp_unit_set_cur.person_id
537: AND mn_rec.sequence_number = cp_unit_set_cur.sequence_number
538: AND mn_rec.unit_set_cd = cp_unit_set_cur.unit_set_cd
539: AND mn_rec.version_number = cp_unit_set_cur.version_number
551: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
552:
553: l_records_processed NUMBER;
554: l_rowid VARCHAR2(30);
555: l_unit_set_id igs_ad_unit_sets.unit_set_id%TYPE;
556:
557: l_admission_cat igs_ad_appl.admission_cat%TYPE;
558: l_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
559:
597: SAVEPOINT before_creatupdate;
598: l_msg_at_index := igs_ge_msg_stack.count_msg;
599:
600: IF unitsets_rec.dmlmode = cst_insert THEN
601: igs_ad_unit_sets_pkg.INSERT_ROW (
602: x_rowid => l_rowid,
603: x_unit_set_id => l_unit_set_id,
604: x_person_id => unitsets_rec.person_id,
605: x_admission_appl_number => unitsets_rec.admission_appl_number,
614: OPEN c_null_hdlg_unitsets_cur_rec(unitsets_rec);
615: FETCH c_null_hdlg_unitsets_cur_rec INTO c_null_hdlg_unitsets_rec;
616: CLOSE c_null_hdlg_unitsets_cur_rec;
617:
618: igs_ad_unit_sets_pkg.update_row(
619: x_rowid => c_null_hdlg_unitsets_rec.rowid,
620: x_unit_set_id => c_null_hdlg_unitsets_rec.unit_set_id,
621: x_person_id => NVL(unitsets_rec.person_id,c_null_hdlg_unitsets_rec.person_id),
622: x_admission_appl_number=> NVL(unitsets_rec.admission_appl_number,c_null_hdlg_unitsets_rec.admission_appl_number),
773: , match_ind = cst_mi_val_19
774: WHERE interface_run_id = p_interface_run_id
775: AND status = cst_s_val_2
776: AND EXISTS ( SELECT 1
777: FROM igs_ad_unit_sets mn_rec
778: WHERE mn_rec.person_id = in_rec.person_id
779: AND mn_rec.sequence_number = in_rec.sequence_number
780: AND mn_rec.unit_set_cd = in_rec.unit_set_cd
781: AND mn_rec.version_number = in_rec.version_number
809: WHERE interface_run_id = p_interface_run_id
810: AND status = cst_s_val_2
811: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
812: AND EXISTS ( SELECT 1
813: FROM igs_ad_unit_sets mn_rec
814: WHERE NVL(mn_rec.person_id, -99) = NVL(in_rec.person_id,NVL(mn_rec.person_id, -99) )
815: AND NVL(mn_rec.admission_appl_number, -99) = NVL(in_rec.admission_appl_number,NVL(mn_rec.admission_appl_number, -99) )
816: AND NVL(mn_rec.nominated_course_cd,'~') = NVL(in_rec.nominated_course_cd, NVL(mn_rec.nominated_course_cd,'~') )
817: AND NVL(mn_rec.sequence_number, -99) = NVL(in_rec.sequence_number, NVL(mn_rec.sequence_number, -99))
832: WHERE interface_run_id = p_interface_run_id
833: AND status = cst_s_val_2
834: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
835: AND EXISTS ( SELECT rowid
836: FROM igs_ad_unit_sets mn_rec
837: WHERE mn_rec.person_id = in_rec.person_id
838: AND mn_rec.sequence_number = in_rec.sequence_number
839: AND mn_rec.unit_set_cd = in_rec.unit_set_cd
840: AND mn_rec.version_number = in_rec.version_number