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_IMP_016 dependencies on IGS_AD_TEST_RESULTS

Line 88: FROM igs_ad_test_results mn_rec

84: AND status = cst_s_val_2
85: AND interface_test_id between cp_lower_bound and cp_higher_bound
86: AND (( NVL(match_ind,'15') = '15'
87: AND NOT EXISTS (SELECT 1
88: FROM igs_ad_test_results mn_rec
89: WHERE mn_rec.person_id = in_rec.person_id
90: AND mn_rec.admission_test_type = in_rec.admission_test_type
91: AND TRUNC(mn_rec.test_date) = TRUNC(in_rec.test_date)))
92: OR ( p_rule = cst_rule_val_R

Line 103: FROM igs_ad_test_results mn_rec

99: AND interface_test_id between cp_lower_bound and cp_higher_bound
100: AND ( (p_rule = cst_rule_val_I)
101: OR (p_rule = cst_rule_val_R AND match_ind = cst_mi_val_21))
102: AND EXISTS (SELECT 1
103: FROM igs_ad_test_results mn_rec
104: WHERE mn_rec.person_id = in_rec.person_id
105: AND mn_rec.admission_test_type = in_rec.admission_test_type
106: AND TRUNC(mn_rec.test_date) = TRUNC(in_rec.test_date))
107:

Line 148: FROM igs_ad_test_results ar

144: AND mn_rec.test_segment_id = in_rec.test_segment_id);
145:
146: CURSOR c_null_hdlg_tst_rsl_cur(cp_tst_rsl_cur c_igs_ad_test_int%ROWTYPE) IS
147: SELECT ROWID, ar.*
148: FROM igs_ad_test_results ar
149: WHERE ar.person_id = cp_tst_rsl_cur.person_id
150: AND ar.admission_test_type = cp_tst_rsl_cur.admission_test_type
151: AND TRUNC(ar.test_date) = TRUNC(cp_tst_rsl_cur.test_date);
152:

Line 186: l_test_results_id igs_ad_test_results.test_results_id%TYPE;

182:
183: l_records_processed NUMBER;
184: l_rowid VARCHAR2(30);
185: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%TYPE;
186: l_test_results_id igs_ad_test_results.test_results_id%TYPE;
187:
188: l_prog_label VARCHAR2(100);
189: l_label VARCHAR2(100);
190: l_debug_str VARCHAR2(2000);

Line 484: FROM igs_ad_tst_rslt_dtls a, igs_ad_test_results b

480: WHERE tst_seg_int.interface_test_id = tst_int.interface_test_id
481: AND status = '2'
482: UNION
483: SELECT 1
484: FROM igs_ad_tst_rslt_dtls a, igs_ad_test_results b
485: WHERE person_id = tst_int.person_id
486: AND admission_test_type = tst_int.admission_test_type
487: AND TRUNC(test_date) = tst_int.test_date
488: AND a.test_results_id = b.test_results_id);

Line 568: Igs_Ad_Test_Results_Pkg.Insert_Row (

564: IF test_rec.dmlmode = cst_insert THEN
565: l_rowid := NULL;
566: l_test_results_id := NULL;
567:
568: Igs_Ad_Test_Results_Pkg.Insert_Row (
569: x_rowid => l_rowid,
570: x_test_results_id => l_test_results_id,
571: x_person_id => test_rec.person_id,
572: x_admission_test_type => test_rec.admission_test_type,

Line 617: Igs_Ad_Test_Results_Pkg.update_row(

613:
614: l_test_results_id := c_null_hdlg_test_rec.test_results_id;
615:
616:
617: Igs_Ad_Test_Results_Pkg.update_row(
618: x_rowid => c_null_hdlg_test_rec.ROWID,
619: x_test_results_id => c_null_hdlg_test_rec.test_results_id,
620: x_person_id => NVL(test_rec.person_id,c_null_hdlg_test_rec.person_id),
621: x_admission_test_type => NVL(test_rec.admission_test_type,c_null_hdlg_test_rec.admission_test_type),

Line 1028: FROM igs_ad_test_results mn_rec

1024: , match_ind = cst_mi_val_19
1025: WHERE interface_run_id = p_interface_run_id
1026: AND status = cst_s_val_2
1027: AND EXISTS ( SELECT 1
1028: FROM igs_ad_test_results mn_rec
1029: WHERE mn_rec.person_id = in_rec.person_id
1030: AND mn_rec.admission_test_type = in_rec.admission_test_type
1031: AND TRUNC(mn_rec.test_date) = TRUNC(in_rec.test_date));
1032: COMMIT;

Line 1049: FROM igs_ad_test_results mn_rec

1045: WHERE interface_run_id = p_interface_run_id
1046: AND status = cst_s_val_2
1047: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
1048: AND 1 < ( SELECT COUNT (*)
1049: FROM igs_ad_test_results mn_rec
1050: WHERE mn_rec.person_id = in_rec.person_id
1051: AND mn_rec.admission_test_type = in_rec.admission_test_type
1052: AND TRUNC(mn_rec.test_date) = TRUNC(in_rec.test_date));
1053: COMMIT;

Line 1070: FROM igs_ad_test_results mn_rec

1066: WHERE interface_run_id = p_interface_run_id
1067: AND status = cst_s_val_2
1068: AND NVL (match_ind, cst_mi_val_15) IN (cst_mi_val_15, cst_mi_val_21)
1069: AND 1 < ( SELECT COUNT (*)
1070: FROM igs_ad_test_results mn_rec
1071: WHERE mn_rec.person_id = in_rec.person_id
1072: AND mn_rec.admission_test_type = in_rec.admission_test_type
1073: AND TRUNC(mn_rec.test_date) = TRUNC(in_rec.test_date));
1074: COMMIT;

Line 1078: FROM igs_ad_test_results mn_rec

1074: COMMIT;
1075:
1076: UPDATE igs_ad_test_int in_rec
1077: SET test_results_id = (SELECT test_results_id
1078: FROM igs_ad_test_results mn_rec
1079: WHERE mn_rec.person_id = in_rec.person_id
1080: AND mn_rec.admission_test_type = in_rec.admission_test_type
1081: AND TRUNC(mn_rec.test_date) = TRUNC(in_rec.test_date))
1082: ,status = cst_s_val_1

Line 1089: FROM igs_ad_test_results mn_rec

1085: AND status = cst_s_val_2
1086: AND NVL (match_ind, cst_mi_val_15) IN (cst_mi_val_15)
1087: AND EXISTS (
1088: SELECT 1
1089: FROM igs_ad_test_results mn_rec
1090: WHERE NVL(mn_rec.person_id,-99) = NVL(in_rec.person_id, NVL(mn_rec.person_id,-99) )
1091: AND NVL(mn_rec.admission_test_type, '~') = NVL(in_rec.admission_test_type, NVL(mn_rec.admission_test_type, '~'))
1092: AND TRUNC(NVL(mn_rec.test_date, SYSDATE)) = TRUNC(NVL(in_rec.test_date, NVL(mn_rec.test_date, SYSDATE)))
1093: AND TRUNC(NVL(mn_rec.score_report_date, SYSDATE)) = TRUNC(NVL(in_rec.score_report_date, NVL(mn_rec.score_report_date, SYSDATE)))

Line 1130: FROM igs_ad_test_results mn_rec

1126: status = cst_s_val_3
1127: , match_ind = cst_mi_val_20
1128: ,(dup_test_results_id)
1129: = (SELECT mn_rec.test_results_id
1130: FROM igs_ad_test_results mn_rec
1131: WHERE mn_rec.person_id = in_rec.person_id
1132: AND mn_rec.admission_test_type = in_rec.admission_test_type
1133: AND TRUNC(mn_rec.test_date) = TRUNC(in_rec.test_date)
1134: AND ROWNUM = 1)

Line 1139: FROM igs_ad_test_results mn_rec

1135: WHERE interface_run_id = p_interface_run_id
1136: AND status = cst_s_val_2
1137: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
1138: AND EXISTS ( SELECT rowid
1139: FROM igs_ad_test_results mn_rec
1140: WHERE mn_rec.person_id = in_rec.person_id
1141: AND mn_rec.admission_test_type = in_rec.admission_test_type
1142: AND TRUNC(mn_rec.test_date) = TRUNC(in_rec.test_date));
1143: COMMIT;