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_011 dependencies on IGS_AD_INTERFACE_ALL

Line 80: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

76: l_label VARCHAR2(4000);
77: l_debug_str VARCHAR2(4000);
78: l_enable_log VARCHAR2(1);
79: l_request_id NUMBER(10);
80: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
81:
82: --
83: -- dld ref 1. Pick up the records from the tables mentioned below :
84: --

Line 85: CURSOR hnr_cur (cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

81:
82: --
83: -- dld ref 1. Pick up the records from the tables mentioned below :
84: --
85: CURSOR hnr_cur (cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
86: SELECT mi.*, i.person_id
87: FROM igs_ad_acadhonor_int_all mi,igs_ad_interface_all i
88: WHERE mi.interface_run_id = cp_interface_run_id
89: AND mi.interface_id = i.interface_id

Line 87: FROM igs_ad_acadhonor_int_all mi,igs_ad_interface_all i

83: -- dld ref 1. Pick up the records from the tables mentioned below :
84: --
85: CURSOR hnr_cur (cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
86: SELECT mi.*, i.person_id
87: FROM igs_ad_acadhonor_int_all mi,igs_ad_interface_all i
88: WHERE mi.interface_run_id = cp_interface_run_id
89: AND mi.interface_id = i.interface_id
90: AND i.interface_run_id = cp_interface_run_id
91: AND mi.status = '2';

Line 278: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

274: match_ind = cst_mi_val_19
275: WHERE mi.interface_run_id = l_interface_run_id
276: AND mi.status = cst_stat_val_2
277: AND EXISTS ( SELECT '1'
278: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii
279: WHERE ii.interface_run_id = l_interface_run_id
280: AND ii.interface_id = mi.interface_id
281: AND ii.person_id = pe.person_id
282: AND pe.acad_honor_type = UPPER(mi.acad_honor_type)

Line 315: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

311: WHERE mi.interface_run_id = l_interface_run_id
312: AND mi.match_ind IS NULL
313: AND mi.status = cst_stat_val_2
314: AND EXISTS ( SELECT '1'
315: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii
316: WHERE ii.interface_run_id = l_interface_run_id
317: AND ii.interface_id = mi.interface_id
318: AND ii.person_id = pe.person_id
319: AND pe.acad_honor_type = UPPER(mi.acad_honor_type)

Line 331: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

327: UPDATE igs_ad_acadhonor_int_all mi
328: SET status = cst_stat_val_3,
329: match_ind = cst_mi_val_20,
330: DUP_ACAD_HONOR_ID = (SELECT pe.acad_honor_id
331: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii
332: WHERE mi.interface_run_id = l_interface_run_id
333: AND ii.interface_id = mi.interface_id
334: AND ii.person_id = pe.person_id
335: AND pe.acad_honor_type = UPPER(mi.acad_honor_type)

Line 341: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

337: WHERE mi.interface_run_id = l_interface_run_id
338: AND mi.match_ind IS NULL
339: AND mi.status = cst_stat_val_2
340: AND EXISTS (SELECT '1'
341: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii
342: WHERE ii.interface_run_id = l_interface_run_id
343: AND ii.interface_id = mi.interface_id
344: AND ii.person_id = pe.person_id
345: AND pe.acad_honor_type = UPPER(mi.acad_honor_type)

Line 605: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

601: l_debug_str VARCHAR2(4000);
602: l_enable_log VARCHAR2(1);
603: l_request_id NUMBER(10);
604: l_rule VARCHAR2(1);
605: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
606:
607: CURSOR res_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
608: SELECT mi.*, i.person_id
609: FROM igs_pe_res_dtls_int mi,igs_ad_interface_all i

Line 607: CURSOR res_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

603: l_request_id NUMBER(10);
604: l_rule VARCHAR2(1);
605: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
606:
607: CURSOR res_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
608: SELECT mi.*, i.person_id
609: FROM igs_pe_res_dtls_int mi,igs_ad_interface_all i
610: WHERE mi.interface_run_id = cp_interface_run_id
611: AND mi.interface_id = i.interface_id

Line 609: FROM igs_pe_res_dtls_int mi,igs_ad_interface_all i

605: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
606:
607: CURSOR res_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
608: SELECT mi.*, i.person_id
609: FROM igs_pe_res_dtls_int mi,igs_ad_interface_all i
610: WHERE mi.interface_run_id = cp_interface_run_id
611: AND mi.interface_id = i.interface_id
612: AND i.interface_run_id = cp_interface_run_id
613: AND mi.status = '2';

Line 952: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii

948: match_ind = cst_mi_val_19
949: WHERE mi.interface_run_id = l_interface_run_id
950: AND mi.status = cst_stat_val_2
951: AND EXISTS ( SELECT '1'
952: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii
953: WHERE ii.interface_run_id = l_interface_run_id
954: AND ii.interface_id = mi.interface_id
955: AND ii.person_id = pe.person_id
956: AND UPPER(mi.residency_class_cd) = pe.residency_class_cd

Line 990: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii

986: WHERE mi.interface_run_id = l_interface_run_id
987: AND mi.match_ind IS NULL
988: AND mi.status = cst_stat_val_2
989: AND EXISTS ( SELECT '1'
990: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii
991: WHERE ii.interface_run_id = l_interface_run_id
992: AND ii.interface_id = mi.interface_id
993: AND ii.person_id = pe.person_id
994: AND pe.residency_class_cd = UPPER(mi.Residency_class_cd)

Line 1031: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii

1027: WHERE mi.interface_run_id = l_interface_run_id
1028: AND mi.match_ind IS NULL
1029: AND mi.status = cst_stat_val_2
1030: AND EXISTS (SELECT '1'
1031: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii
1032: WHERE ii.interface_run_id = l_interface_run_id
1033: AND ii.interface_id = mi.interface_id
1034: AND ii.person_id = pe.person_id
1035: AND UPPER(mi.residency_class_cd) = pe.residency_class_cd

Line 1191: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

1187: l_label VARCHAR2(4000);
1188: l_debug_str VARCHAR2(4000);
1189: l_enable_log VARCHAR2(1);
1190: l_request_id NUMBER(10);
1191: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
1192: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
1193:
1194: --Pick up the records for processing from the Special Needs Disability Interface Table
1195: CURSOR disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

Line 1195: CURSOR disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

1191: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
1192: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
1193:
1194: --Pick up the records for processing from the Special Needs Disability Interface Table
1195: CURSOR disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1196: SELECT mi.*,i.person_id
1197: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i
1198: WHERE mi.interface_run_id = cp_interface_run_id
1199: AND i.interface_run_id = cp_interface_run_id

Line 1197: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i

1193:
1194: --Pick up the records for processing from the Special Needs Disability Interface Table
1195: CURSOR disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1196: SELECT mi.*,i.person_id
1197: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i
1198: WHERE mi.interface_run_id = cp_interface_run_id
1199: AND i.interface_run_id = cp_interface_run_id
1200: AND mi.interface_id = i.interface_id
1201: AND mi.status = '2';

Line 1204: CURSOR sp_disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

1200: AND mi.interface_id = i.interface_id
1201: AND mi.status = '2';
1202:
1203: -- Pick up the records processed before the loop from the Disability Interface Table
1204: CURSOR sp_disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1205: SELECT mi.*,i.person_id
1206: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i
1207: WHERE mi.interface_run_id = cp_interface_run_id
1208: AND i.interface_run_id = cp_interface_run_id

Line 1206: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i

1202:
1203: -- Pick up the records processed before the loop from the Disability Interface Table
1204: CURSOR sp_disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1205: SELECT mi.*,i.person_id
1206: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i
1207: WHERE mi.interface_run_id = cp_interface_run_id
1208: AND i.interface_run_id = cp_interface_run_id
1209: AND mi.interface_id = i.interface_id
1210: AND mi.status = '1'

Line 1215: cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE ) IS

1211: AND mi.match_ind IN (cst_mi_val_23,cst_mi_val_19);
1212:
1213: --Pick up the records for processing from the Special Needs Service Interface Table
1214: CURSOR sn_service_cur(cp_interface_disablty_id igs_ad_disablty_int.interface_disablty_id%TYPE,
1215: cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE ) IS
1216: SELECT ai.*
1217: FROM igs_pe_sn_srvce_int ai,
1218: igs_ad_disablty_int_all ad
1219: WHERE ai.interface_run_id = cp_interface_run_id AND

Line 1227: cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE ) IS

1223: ai.status = '2';
1224:
1225: --Pick up the records for processing from the Special Needs Contact Interface Table
1226: CURSOR sn_contact_cur(cp_interface_disablty_id igs_ad_disablty_int.interface_disablty_id%TYPE,
1227: cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE ) IS
1228: SELECT ai.*
1229: FROM igs_pe_sn_conct_int ai,
1230: igs_ad_disablty_int_all ad
1231: WHERE ai.interface_run_id = cp_interface_run_id AND

Line 2740: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii

2736: UPDATE igs_ad_disablty_int_all mi
2737: SET status = cst_stat_val_1,
2738: match_ind = cst_mi_val_19,
2739: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id
2740: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii
2741: WHERE ii.interface_id = mi.interface_id AND
2742: pe.disability_type = UPPER(mi.disability_type) AND
2743: ROWNUM = 1 AND
2744: ii.person_id = pe.person_id AND

Line 2749: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii

2745: ((TRUNC(mi.start_date) = pe.start_date) OR (mi.start_date IS NULL AND pe.start_date IS NULL)))
2746: WHERE mi.interface_run_id = l_interface_run_id
2747: AND mi.status = cst_stat_val_2
2748: AND EXISTS ( SELECT '1'
2749: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii
2750: WHERE pe.disability_type = UPPER(mi.disability_type) AND
2751: ii.interface_id = mi.interface_id AND
2752: ii.person_id = pe.person_id AND
2753: ((TRUNC(mi.start_date) = pe.start_date) OR (mi.start_date IS NULL AND pe.start_date IS NULL))

Line 2784: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii

2780: UPDATE igs_ad_disablty_int_all mi
2781: SET status = cst_stat_val_1,
2782: match_ind = cst_mi_val_23,
2783: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id
2784: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii
2785: WHERE ii.person_id = pe.person_id
2786: AND ii.interface_id = mi.interface_id
2787: AND pe.disability_type = UPPER(mi.disability_type)
2788: AND ((TRUNC(mi.start_date) = pe.start_date) OR (mi.start_date IS NULL AND pe.start_date IS NULL)))

Line 2793: FROM igs_pe_pers_disablty pe, igs_AD_interface_all ii

2789: WHERE mi.interface_run_id = l_interface_run_id
2790: AND mi.match_ind IS NULL
2791: AND mi.status = cst_stat_val_2
2792: AND EXISTS ( SELECT 1
2793: FROM igs_pe_pers_disablty pe, igs_AD_interface_all ii
2794: WHERE ii.person_id = pe.person_id
2795: AND ii.interface_id = mi.interface_id
2796: AND UPPER(mi.disability_type) = pe.disability_type
2797: AND NVL(mi.special_allow_cd, -99) = NVL(pe.special_allow_cd, -99) AND

Line 2826: FROM igs_pe_pers_disablty pe, igs_Ad_interface_all ii

2822: WHERE mi.interface_run_id = l_interface_run_id
2823: AND mi.match_ind IS NULL
2824: AND mi.status = cst_stat_val_2
2825: AND EXISTS (SELECT '1'
2826: FROM igs_pe_pers_disablty pe, igs_Ad_interface_all ii
2827: WHERE pe.disability_type = UPPER(mi.disability_type) AND
2828: ii.person_id = pe.person_id AND
2829: ii.interface_id = mi.interface_id AND
2830: ((TRUNC(mi.start_date) = pe.start_date) OR (mi.start_date IS NULL AND pe.start_date IS NULL))