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.

[Home] [Help]

APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_EIT_INT

Line 239: UPDATE igs_pe_eit_int pei

235: END IF;
236:
237:
238: -- Populating the child interface table with the interface_run_id value.
239: UPDATE igs_pe_eit_int pei
240: SET
241: interface_run_id=l_interface_run_id
242: WHERE pei.status='2' AND
243: EXISTS (SELECT 1

Line 252: tabname => 'IGS_PE_EIT_INT',

248: ai.interface_run_id=l_interface_run_id);
249:
250:
251: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
252: tabname => 'IGS_PE_EIT_INT',
253: cascade => TRUE);
254:
255: -- Populating the child interface table with the interface_run_id value.
256: UPDATE igs_pe_race_int adli

Line 271: UPDATE igs_pe_eit_int

267: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
268: tabname => 'IGS_PE_RACE_INT',
269: cascade => TRUE);
270:
271: UPDATE igs_pe_eit_int
272: SET status = '1'
273: WHERE match_ind = '22' AND
274: status = '2' AND
275: INTERFACE_RUN_ID = l_interface_run_id;

Line 523: UPDATE IGS_PE_EIT_INT pei

519: AND INTERFACE_RUN_ID = l_interface_run_id;
520:
521: -- Populating the child interface table with the interface_run_id value.
522: --skpandey, Bug#4114660: Changed table alias name to optimize performance
523: UPDATE IGS_PE_EIT_INT pei
524: SET
525: interface_run_id=l_interface_run_id
526: WHERE pei.status='2' AND
527: EXISTS (SELECT 1

Line 536: tabname => 'IGS_PE_EIT_INT',

532: ai.interface_run_id=l_interface_run_id);
533:
534: -- gather statistics for the table after populating it's interface_run_id
535: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
536: tabname => 'IGS_PE_EIT_INT',
537: cascade => TRUE);
538: UPDATE IGS_PE_EIT_INT SET STATUS = '1'
539: WHERE MATCH_IND = '22' AND STATUS = '2'
540: AND INFORMATION_TYPE = 'PE_INT_PERM_RES'

Line 538: UPDATE IGS_PE_EIT_INT SET STATUS = '1'

534: -- gather statistics for the table after populating it's interface_run_id
535: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
536: tabname => 'IGS_PE_EIT_INT',
537: cascade => TRUE);
538: UPDATE IGS_PE_EIT_INT SET STATUS = '1'
539: WHERE MATCH_IND = '22' AND STATUS = '2'
540: AND INFORMATION_TYPE = 'PE_INT_PERM_RES'
541: AND INTERFACE_RUN_ID = l_interface_run_id;
542:

Line 1292: DELETE FROM igs_pe_eit_int WHERE

1288: -- new logic to delete processed records from interface table
1289: DELETE FROM igs_pe_race_int WHERE
1290: STATUS = '1' AND interface_run_id = l_interface_run_id;
1291:
1292: DELETE FROM igs_pe_eit_int WHERE
1293: STATUS = '1' AND interface_run_id = l_interface_run_id;
1294:
1295: END IF;
1296:

Line 1365: DELETE FROM igs_pe_eit_int WHERE

1361:
1362: DELETE FROM igs_pe_fund_src_int WHERE
1363: STATUS = '1' AND interface_run_id = l_interface_run_id;
1364:
1365: DELETE FROM igs_pe_eit_int WHERE
1366: STATUS = '1' AND interface_run_id = l_interface_run_id;
1367:
1368: END IF;
1369:

Line 1576: OR EXISTS (SELECT 1 FROM igs_pe_eit_int ai WHERE ad.interface_id = ai.interface_id)

1572: OR EXISTS (SELECT 1 FROM igs_ad_stat_int_all ai WHERE ad.interface_id = ai.interface_id)
1573: OR EXISTS (SELECT 1 FROM igs_ad_addr_int_all ai WHERE ad.interface_id = ai.interface_id)
1574: OR EXISTS (SELECT 1 FROM igs_ad_api_int_all ai WHERE ad.interface_id = ai.interface_id)
1575: OR EXISTS (SELECT 1 FROM igs_pe_race_int ai WHERE ad.interface_id = ai.interface_id)
1576: OR EXISTS (SELECT 1 FROM igs_pe_eit_int ai WHERE ad.interface_id = ai.interface_id)
1577: OR EXISTS (SELECT 1 FROM igs_pe_type_int ai WHERE ad.interface_id = ai.interface_id)
1578: OR EXISTS (SELECT 1 FROM igs_ad_alias_int_all ai WHERE ad.interface_id = ai.interface_id)
1579: OR EXISTS (SELECT 1 FROM igs_ad_disablty_int_all ai WHERE ad.interface_id = ai.interface_id)
1580: OR EXISTS (SELECT 1 FROM igs_ad_emp_int_all ai WHERE ad.interface_id = ai.interface_id)

Line 1885: SELECT count(*) count1,status FROM IGS_PE_EIT_INT WHERE interface_run_id = p_interface_run_id AND

1881: CURSOR cur_person_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1882: SELECT count(*) count1,status FROM IGS_AD_STAT_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1883:
1884: CURSOR cur_person_stat_eit_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1885: SELECT count(*) count1,status FROM IGS_PE_EIT_INT WHERE interface_run_id = p_interface_run_id AND
1886: information_type IN ('PE_STAT_RES_COUNTRY','PE_STAT_RES_STATE', 'PE_STAT_RES_STATUS') GROUP BY status;
1887:
1888: CURSOR cur_person_race_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1889: SELECT count(*) count1,status FROM IGS_PE_RACE_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1925: SELECT count(*) count1,status FROM IGS_PE_EIT_INT WHERE interface_run_id = p_interface_run_id AND

1921: CURSOR cur_person_hist_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1922: SELECT count(*) count1,status FROM IGS_PE_VST_HIST_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1923:
1924: CURSOR cur_person_eit_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE,p_information_type VARCHAR2) IS
1925: SELECT count(*) count1,status FROM IGS_PE_EIT_INT WHERE interface_run_id = p_interface_run_id AND
1926: information_type = p_information_type GROUP BY status;
1927:
1928: CURSOR cur_person_citizen_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1929: SELECT count(*) count1,status FROM IGS_PE_CITIZEN_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 2203: l_tab := 'IGS_PE_EIT_INT-STAT';

2199: IF l_warning IS NULL THEN
2200: l_warning := 0;
2201: END IF;
2202: l_total_rec := l_success + l_error + l_warning;
2203: l_tab := 'IGS_PE_EIT_INT-STAT';
2204: INSERT INTO IGS_AD_IMP_STATS
2205: (
2206: INTERFACE_RUN_ID,
2207: SRC_CAT_CODE,

Line 2920: l_tab := 'IGS_PE_EIT_INT-INTL';

2916: l_warning := 0;
2917: END IF;
2918:
2919: l_total_rec := l_success + l_error + l_warning;
2920: l_tab := 'IGS_PE_EIT_INT-INTL';
2921: INSERT INTO IGS_AD_IMP_STATS
2922: (
2923: INTERFACE_RUN_ID,
2924: SRC_CAT_CODE,