[Home] [Help]
574: x_score_report_date => test_rec.score_report_date,
575: x_edu_level_id => test_rec.edu_level_id,
576: x_score_type => l_score_type,
577: x_score_source_id => test_rec.score_source_id,
578: x_non_standard_admin => NVL(test_rec.non_standard_admin,'N'),
579: x_comp_test_score => NULL,
580: x_special_code => test_rec.special_code,
581: x_registration_number => test_rec.registration_number,
582: x_grade_id => test_rec.grade_id,
623: x_score_report_date => NVL(test_rec.score_report_date,c_null_hdlg_test_rec.score_report_date),
624: x_edu_level_id => NVL(test_rec.edu_level_id,c_null_hdlg_test_rec.edu_level_id),
625: x_score_type => NVL(l_score_type, c_null_hdlg_test_rec.score_type) ,
626: x_score_source_id => NVL(test_rec.score_source_id,c_null_hdlg_test_rec.score_source_id),
627: x_non_standard_admin => NVL(test_rec.non_standard_admin,c_null_hdlg_test_rec.non_standard_admin),
628: x_comp_test_score => c_null_hdlg_test_rec.comp_test_score,
629: x_special_code => NVL(test_rec.special_code,c_null_hdlg_test_rec.special_code),
630: x_registration_number => NVL(test_rec.registration_number,c_null_hdlg_test_rec.registration_number),
631: x_grade_id => NVL(test_rec.grade_id,c_null_hdlg_test_rec.grade_id),
1093: AND TRUNC(NVL(mn_rec.score_report_date, SYSDATE)) = TRUNC(NVL(in_rec.score_report_date, NVL(mn_rec.score_report_date, SYSDATE)))
1094: AND NVL(mn_rec.edu_level_id, -99) = NVL(in_rec.edu_level_id, NVL(mn_rec.edu_level_id, -99))
1095: AND NVL(mn_rec.score_type, '~') = NVL(in_rec.score_type, NVL(mn_rec.score_type, '~'))
1096: AND NVL(mn_rec.score_source_id, -99) = NVL(in_rec.score_source_id, NVL(mn_rec.score_source_id, -99))
1097: AND NVL(mn_rec.non_standard_admin, '~') = NVL(in_rec.non_standard_admin, NVL(mn_rec.non_standard_admin, '~'))
1098: AND NVL(mn_rec.special_code, '~') = NVL(in_rec.special_code, NVL(mn_rec.special_code, '~'))
1099: AND NVL(mn_rec.grade_id, -99) = NVL(in_rec.grade_id, NVL(mn_rec.grade_id, -99))
1100: );
1101: COMMIT;