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_TST_RSLT_DTLS

Line 129: FROM igs_ad_tst_rslt_dtls mn_rec

125: WHERE status = cst_s_val_2
126: AND interface_test_id = cp_interface_test_id
127: AND (( NVL(match_ind,'15') = '15'
128: AND NOT EXISTS (SELECT 1
129: FROM igs_ad_tst_rslt_dtls mn_rec
130: WHERE mn_rec.test_results_id = in_rec.test_results_id
131: AND mn_rec.test_segment_id = in_rec.test_segment_id))
132: OR ( p_rule = cst_rule_val_R
133: AND match_ind IN (cst_mi_val_16, cst_mi_val_25)))

Line 142: FROM igs_ad_tst_rslt_dtls mn_rec

138: AND interface_test_id = cp_interface_test_id
139: AND ( (p_rule = cst_rule_val_I)
140: OR (p_rule = cst_rule_val_R AND match_ind = cst_mi_val_21))
141: AND EXISTS (SELECT 1
142: FROM igs_ad_tst_rslt_dtls mn_rec
143: WHERE mn_rec.test_results_id = in_rec.test_results_id
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

Line 156: cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE) IS

152:
153: c_null_hdlg_test_rec c_null_hdlg_tst_rsl_cur%ROWTYPE;
154:
155: CURSOR c_null_hdlg_tst_dtls_cur(cp_test_segment_id igs_ad_test_segs_int.test_segment_id%TYPE,
156: cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE) IS
157: SELECT ROWID, ar.*
158: FROM igs_ad_tst_rslt_dtls ar
159: WHERE test_results_id = cp_test_results_id
160: AND test_segment_id = cp_test_segment_id;

Line 158: FROM igs_ad_tst_rslt_dtls ar

154:
155: CURSOR c_null_hdlg_tst_dtls_cur(cp_test_segment_id igs_ad_test_segs_int.test_segment_id%TYPE,
156: cp_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE) IS
157: SELECT ROWID, ar.*
158: FROM igs_ad_tst_rslt_dtls ar
159: WHERE test_results_id = cp_test_results_id
160: AND test_segment_id = cp_test_segment_id;
161:
162: c_null_hdlg_tst_dtls_rec c_null_hdlg_tst_dtls_cur%ROWTYPE;

Line 185: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%TYPE;

181: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
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);

Line 202: p_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE,

198:
199: test_seg_failed EXCEPTION;
200:
201: PROCEDURE upd_tst_dtls_atm_bef ( p_interface_test_id igs_ad_test_segs_int.interface_test_id%TYPE,
202: p_test_results_id igs_ad_tst_rslt_dtls.test_results_id%TYPE,
203: p_success IN OUT NOCOPY BOOLEAN) AS
204: PRAGMA AUTONOMOUS_TRANSACTION;
205: BEGIN
206: IF p_rule IN ('E','I') AND p_success THEN

Line 244: FROM igs_ad_tst_rslt_dtls mn_rec

240: , match_ind = cst_mi_val_19
241: WHERE status = '2'
242: AND interface_test_id = p_interface_test_id
243: AND EXISTS ( SELECT 1
244: FROM igs_ad_tst_rslt_dtls mn_rec
245: WHERE mn_rec.test_results_id = p_test_results_id
246: AND mn_rec.test_segment_id = in_rec.test_segment_id);
247: COMMIT;
248: END IF;

Line 321: FROM igs_ad_tst_rslt_dtls mn_rec

317: AND interface_test_id = p_interface_test_id
318: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
319: AND EXISTS (
320: SELECT 1
321: FROM igs_ad_tst_rslt_dtls mn_rec
322: WHERE mn_rec.test_results_id = in_rec.test_results_id
323: AND mn_rec.test_segment_id = in_rec.test_segment_id
324: AND NVL(mn_rec.percentile,-99) = NVL(in_rec.percentile,NVL(mn_rec.percentile,-99))
325: AND NVL(mn_rec.national_percentile,-99) = NVL(in_rec.national_percentile,NVL(mn_rec.national_percentile,-99))

Line 368: FROM igs_ad_tst_rslt_dtls mn_rec

364: WHERE status = cst_s_val_2
365: AND interface_test_id = p_interface_test_id
366: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
367: AND EXISTS ( SELECT rowid
368: FROM igs_ad_tst_rslt_dtls mn_rec
369: WHERE mn_rec.test_results_id = in_rec.test_results_id
370: AND mn_rec.test_segment_id = in_rec.test_segment_id);
371: IF SQL%ROWCOUNT > 0 THEN
372: p_success := FALSE;

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 682: Igs_Ad_Tst_Rslt_Dtls_Pkg.Insert_Row (

678: l_msg_at_index := igs_ge_msg_stack.count_msg;
679:
680: IF test_dtls_rec.dmlmode = cst_insert THEN
681: l_rowid := NULL;
682: Igs_Ad_Tst_Rslt_Dtls_Pkg.Insert_Row (
683: x_rowId => l_rowid,
684: x_tst_rslt_dtls_id => l_tst_rslt_dtls_id,
685: x_test_results_id => l_test_results_id,
686: x_test_segment_id => test_dtls_rec.test_segment_id,

Line 724: Igs_Ad_Tst_Rslt_Dtls_Pkg.Update_Row (

720: OPEN c_null_hdlg_tst_dtls_cur(test_dtls_rec.test_segment_id,test_dtls_rec.test_results_id);
721: FETCH c_null_hdlg_tst_dtls_cur INTO c_null_hdlg_tst_dtls_rec;
722: CLOSE c_null_hdlg_tst_dtls_cur;
723:
724: Igs_Ad_Tst_Rslt_Dtls_Pkg.Update_Row (
725: x_rowid => c_null_hdlg_tst_dtls_rec.rowid,
726: x_tst_rslt_dtls_id => c_null_hdlg_tst_dtls_rec.tst_rslt_dtls_id,
727: x_test_results_id => c_null_hdlg_tst_dtls_rec.test_results_id ,
728: x_test_segment_id => NVL( test_dtls_rec.test_segment_id, c_null_hdlg_tst_dtls_rec.test_segment_id ),