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

Line 81: CURSOR housing_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

77: l_request_id NUMBER;
78:
79:
80: --Pick up the records for processing from the Housing Status Interface Table
81: CURSOR housing_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
82: SELECT ai.*, i.person_id
83: FROM igs_pe_housing_int ai, igs_ad_interface_all i
84: WHERE ai.interface_id = i.interface_id AND
85: ai.status = '2' AND

Line 83: FROM igs_pe_housing_int ai, igs_ad_interface_all i

79:
80: --Pick up the records for processing from the Housing Status Interface Table
81: CURSOR housing_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
82: SELECT ai.*, i.person_id
83: FROM igs_pe_housing_int ai, igs_ad_interface_all i
84: WHERE ai.interface_id = i.interface_id AND
85: ai.status = '2' AND
86: i.interface_run_id = cp_interface_run_id AND
87: ai.interface_run_id = cp_interface_run_id;

Line 386: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai

382: WHERE phi.status = '2' AND
383: phi.interface_run_id = l_interface_run_id AND
384: EXISTS
385: (SELECT 1
386: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai
387: WHERE phi.interface_id = ai.interface_id AND
388: ai.interface_run_id = l_interface_run_id AND
389: ai.person_id = pi.person_id AND
390: UPPER(phi.cal_type) = pi.cal_type AND

Line 424: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai

420: phi.interface_run_id = l_interface_run_id AND
421: phi.match_ind IS NULL AND
422: EXISTS
423: (SELECT 1
424: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai
425: WHERE phi.interface_id = ai.interface_id AND
426: ai.interface_run_id = l_interface_run_id AND
427: pi.person_id = ai.person_id AND
428: pi.TEACH_PERIOD_RESID_STAT_CD = UPPER(phi.TEACH_PERIOD_RESID_STAT_CD) AND

Line 442: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai

438: UPDATE igs_pe_housing_int phi
439: SET status = 3,
440: match_ind = 20,
441: dup_teaching_period_id = (SELECT pi.teaching_period_id
442: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai
443: WHERE ai.interface_id = phi.interface_id AND
444: ai.interface_run_id = l_interface_run_id AND
445: ai.person_id = pi.person_id AND
446: UPPER(phi.cal_type) = pi.cal_type AND

Line 454: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai

450: phi.interface_run_id = l_interface_run_id AND
451: phi.match_ind IS NULL AND
452: EXISTS
453: (SELECT 1
454: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai
455: WHERE ai.interface_run_id = l_interface_run_id AND
456: ai.interface_id = phi.interface_id AND
457: ai.person_id = pi.person_id AND
458: UPPER(phi.cal_type) = pi.cal_type AND

Line 532: CURSOR felony_dtls_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

528: l_enable_log VARCHAR2(1);
529: l_request_id NUMBER;
530:
531: --Pick up the records for processing from the Felony Details Interface Table
532: CURSOR felony_dtls_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
533: SELECT ai.*, i.person_id
534: FROM igs_pe_flny_dtl_int ai,
535: igs_ad_interface_all i
536: WHERE ai.interface_id = i.interface_id

Line 535: igs_ad_interface_all i

531: --Pick up the records for processing from the Felony Details Interface Table
532: CURSOR felony_dtls_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
533: SELECT ai.*, i.person_id
534: FROM igs_pe_flny_dtl_int ai,
535: igs_ad_interface_all i
536: WHERE ai.interface_id = i.interface_id
537: AND ai.status = '2'
538: AND ai.interface_run_id=cp_interface_run_id
539: AND i.interface_run_id = cp_interface_run_id;

Line 727: igs_ad_interface_all aii

723: pfi.interface_run_id = l_interface_run_id AND
724: pfi.match_ind IS NULL AND
725: EXISTS (SELECT 1
726: FROM igs_pe_felony_dtls pi,
727: igs_ad_interface_all aii
728: WHERE pfi.interface_id = aii.interface_id
729: AND aii.interface_run_id = l_interface_run_id
730: AND aii.person_id = pi.person_id
731: AND UPPER(pfi.crime_nature) = UPPER(pi.crime_nature)

Line 768: igs_ad_interface_all aii

764: pfi.match_ind IS NULL AND
765: EXISTS
766: (SELECT 1
767: FROM igs_pe_felony_dtls pi,
768: igs_ad_interface_all aii
769: WHERE pfi.interface_id = aii.interface_id
770: AND aii.interface_run_id = l_interface_run_id
771: AND NVL(aii.person_id,-99)= NVL(pi.person_id,-99)
772: AND UPPER(pfi.crime_nature) = UPPER(pi.crime_nature)

Line 788: igs_ad_interface_all aii

784: SET status='3',
785: match_ind='20',
786: dup_felony_details_id=(SELECT pi.FELONY_DETAILS_ID
787: FROM igs_pe_felony_dtls pi,
788: igs_ad_interface_all aii
789: WHERE pfi.interface_id = aii.interface_id
790: AND aii.interface_run_id = l_interface_run_id
791: AND aii.person_id = pi.person_id
792: AND UPPER(pfi.crime_nature) = UPPER(pi.crime_nature)

Line 800: igs_ad_interface_all aii

796: pfi.match_ind IS NULL AND
797: EXISTS
798: (SELECT 1
799: FROM igs_pe_felony_dtls pi,
800: igs_ad_interface_all aii
801: WHERE pfi.interface_id = aii.interface_id
802: AND aii.interface_run_id = l_interface_run_id
803: AND aii.person_id = pi.person_id
804: AND UPPER(pfi.crime_nature) = UPPER(pi.crime_nature)

Line 1006: CURSOR hearing_dtls_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

1002: l_enable_log VARCHAR2(1);
1003: l_request_id NUMBER;
1004:
1005: --Pick up the records for processing from the Hearing Details Interface Table
1006: CURSOR hearing_dtls_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1007: SELECT ai.*, i.person_id
1008: FROM igs_pe_hear_dtl_int ai,
1009: igs_ad_interface_all i
1010: WHERE ai.interface_id = i.interface_id

Line 1009: igs_ad_interface_all i

1005: --Pick up the records for processing from the Hearing Details Interface Table
1006: CURSOR hearing_dtls_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1007: SELECT ai.*, i.person_id
1008: FROM igs_pe_hear_dtl_int ai,
1009: igs_ad_interface_all i
1010: WHERE ai.interface_id = i.interface_id
1011: AND ai.status = '2'
1012: AND ai.interface_run_id=cp_interface_run_id
1013: AND i.interface_run_id = cp_interface_run_id;

Line 1207: igs_ad_interface_all aiii

1203: WHERE pdi.status = '2' AND
1204: pdi.interface_run_id = l_interface_run_id AND
1205: EXISTS (SELECT 1
1206: FROM igs_pe_hearing_dtls pi,
1207: igs_ad_interface_all aiii
1208: WHERE pdi.interface_id = aiii.interface_id
1209: AND aiii.interface_run_id = l_interface_run_id
1210: AND aiii.person_id = pi.person_id
1211: AND UPPER(pdi.description) = UPPER(pi.description)

Line 1249: igs_ad_interface_all aiii

1245: pdi.interface_run_id = l_interface_run_id AND
1246: pdi.match_ind IS NULL AND
1247: EXISTS (SELECT 1
1248: FROM igs_pe_hearing_dtls pi,
1249: igs_ad_interface_all aiii
1250: WHERE NVL(pi.person_id,-99) = NVL(aiii.person_id,-99)
1251: AND pdi.interface_id = aiii.interface_id
1252: AND aiii.interface_run_id = l_interface_run_id
1253: AND UPPER(pi.description) = UPPER(pdi.description)

Line 1270: igs_ad_interface_all aiii

1266: SET status = '3',
1267: match_ind = '20',
1268: dup_hearing_details_id=(SELECT pi.hearing_details_id
1269: FROM igs_pe_hearing_dtls pi,
1270: igs_ad_interface_all aiii
1271: WHERE pdi.interface_id = aiii.interface_id
1272: AND aiii.interface_run_id = l_interface_run_id
1273: AND aiii.person_id = pi.person_id
1274: AND UPPER(pdi.description) = UPPER(pi.description)

Line 1283: igs_ad_interface_all aiii

1279: pdi.interface_run_id = l_interface_run_id AND
1280: pdi.match_ind IS NULL AND
1281: EXISTS (SELECT 1
1282: FROM igs_pe_hearing_dtls pi,
1283: igs_ad_interface_all aiii
1284: WHERE pdi.interface_id = aiii.interface_id
1285: AND aiii.interface_run_id = l_interface_run_id
1286: AND aiii.person_id = pi.person_id
1287: AND UPPER(pdi.description) = UPPER(pi.description)

Line 1510: CURSOR race_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

1506: l_dup_exists VARCHAR2(1);
1507: l_rule VARCHAR2(1);
1508:
1509: --Pick up the records for processing from the Races Interface Table
1510: CURSOR race_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1511: SELECT ai.*,i.person_id
1512: FROM igs_pe_race_int ai, igs_ad_interface_all i
1513: WHERE ai.interface_id = i.interface_id AND
1514: ai.status = '2' AND

Line 1512: FROM igs_pe_race_int ai, igs_ad_interface_all i

1508:
1509: --Pick up the records for processing from the Races Interface Table
1510: CURSOR race_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1511: SELECT ai.*,i.person_id
1512: FROM igs_pe_race_int ai, igs_ad_interface_all i
1513: WHERE ai.interface_id = i.interface_id AND
1514: ai.status = '2' AND
1515: ai.interface_run_id=cp_interface_run_id AND
1516: i.interface_run_id = cp_interface_run_id;

Line 1685: igs_ad_interface_all ai

1681: AND pri.interface_run_id = l_interface_run_id
1682: AND EXISTS
1683: (SELECT 1
1684: FROM igs_pe_race pr,
1685: igs_ad_interface_all ai
1686: WHERE pri.interface_id=ai.interface_id
1687: AND ai.interface_run_id = l_interface_run_id
1688: AND pr.person_id=ai.person_id
1689: AND UPPER(pri.race_cd)=UPPER(pr.race_cd)

Line 1757: CURSOR privacy_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE)

1753: l_grp_id igs_pe_priv_level.data_group_id%TYPE;
1754: l_lvl igs_pe_priv_level.lvl%TYPE;
1755:
1756: --Pick up the records for processing from the privacy details interface table.
1757: CURSOR privacy_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE)
1758: IS
1759: SELECT ai.*, i.person_id
1760: FROM igs_pe_privacy_int ai,
1761: igs_ad_interface_all i

Line 1761: igs_ad_interface_all i

1757: CURSOR privacy_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE)
1758: IS
1759: SELECT ai.*, i.person_id
1760: FROM igs_pe_privacy_int ai,
1761: igs_ad_interface_all i
1762: WHERE ai.interface_id = i.interface_id AND
1763: ai.status = '2' AND
1764: i.interface_run_id = cp_interface_run_id AND
1765: ai.interface_run_id = cp_interface_run_id;

Line 2135: FROM igs_pe_priv_level pi, igs_ad_interface_all ai

2131: WHERE phi.status = '2' AND
2132: phi.interface_run_id = l_interface_run_id AND
2133: EXISTS
2134: (SELECT 1
2135: FROM igs_pe_priv_level pi, igs_ad_interface_all ai
2136: WHERE phi.interface_id = ai.interface_id AND
2137: ai.interface_run_id = l_interface_run_id AND
2138: ai.person_id = pi.person_id AND
2139: pi.data_group = UPPER(phi.data_group) AND

Line 2173: FROM igs_pe_priv_level pi, igs_ad_interface_all ai

2169: phi.interface_run_id = l_interface_run_id AND
2170: phi.match_ind IS NULL AND
2171: EXISTS
2172: (SELECT 1
2173: FROM igs_pe_priv_level pi, igs_ad_interface_all ai
2174: WHERE phi.interface_id = ai.interface_id AND
2175: ai.interface_run_id = l_interface_run_id AND
2176: pi.person_id = ai.person_id AND
2177: pi.data_group = UPPER(phi.data_group) AND

Line 2193: FROM igs_pe_priv_level pi, igs_ad_interface_all ai

2189: UPDATE igs_pe_privacy_int phi
2190: SET status = 3,
2191: match_ind = 20,
2192: dup_privacy_level_id = (SELECT pi.privacy_level_id
2193: FROM igs_pe_priv_level pi, igs_ad_interface_all ai
2194: WHERE ai.interface_id = phi.interface_id AND
2195: ai.interface_run_id = l_interface_run_id AND
2196: ai.person_id = pi.person_id AND
2197: UPPER(phi.data_group) = pi.data_group AND

Line 2204: FROM igs_pe_priv_level pi, igs_ad_interface_all ai

2200: phi.interface_run_id = l_interface_run_id AND
2201: phi.match_ind IS NULL AND
2202: EXISTS
2203: (SELECT 1
2204: FROM igs_pe_priv_level pi, igs_ad_interface_all ai
2205: WHERE ai.interface_run_id = l_interface_run_id AND
2206: ai.interface_id = phi.interface_id AND
2207: ai.person_id = pi.person_id AND
2208: UPPER(phi.data_group) = pi.data_group AND