APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_SN_CONCT_INT

Line 391: UPDATE igs_pe_sn_conct_int psci

387: WHERE match_ind = '22' AND
388: status = '2' AND
389: INTERFACE_RUN_ID = l_interface_run_id;
390:
391: UPDATE igs_pe_sn_conct_int psci
392: SET
393: interface_run_id=l_interface_run_id
394: WHERE psci.status='2' AND
395: EXISTS (SELECT 1

Line 406: tabname => 'IGS_PE_SN_CONCT_INT',

402: ai.interface_run_id=l_interface_run_id);
403:
404: -- gather statistics for the table after populating it's interface_run_id
405: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
406: tabname => 'IGS_PE_SN_CONCT_INT',
407: cascade => TRUE);
408: UPDATE igs_pe_sn_conct_int
409: SET status = '1'
410: WHERE match_ind = '22' AND

Line 408: UPDATE igs_pe_sn_conct_int

404: -- gather statistics for the table after populating it's interface_run_id
405: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
406: tabname => 'IGS_PE_SN_CONCT_INT',
407: cascade => TRUE);
408: UPDATE igs_pe_sn_conct_int
409: SET status = '1'
410: WHERE match_ind = '22' AND
411: status = '2' AND
412: INTERFACE_RUN_ID = l_interface_run_id;

Line 1321: DELETE FROM igs_pe_sn_conct_int WHERE

1317:
1318: DELETE FROM igs_pe_sn_srvce_int WHERE
1319: STATUS = '1' AND interface_run_id = l_interface_run_id;
1320:
1321: DELETE FROM igs_pe_sn_conct_int WHERE
1322: STATUS = '1' AND interface_run_id = l_interface_run_id;
1323:
1324: DELETE FROM IGS_AD_DISABLTY_INT_all WHERE
1325: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1910: SELECT count(*) count1,status FROM IGS_PE_SN_CONCT_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

1906: CURSOR cur_person_srvc_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1907: SELECT count(*) count1,status FROM IGS_PE_SN_SRVCE_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1908:
1909: CURSOR cur_person_conc_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1910: SELECT count(*) count1,status FROM IGS_PE_SN_CONCT_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1911:
1912: CURSOR cur_person_emp_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1913: SELECT count(*) count1,status FROM IGS_AD_EMP_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1914:

Line 2644: l_tab := 'IGS_PE_SN_CONCT_INT';

2640: IF l_warning IS NULL THEN
2641: l_warning := 0;
2642: END IF;
2643: l_total_rec := l_success + l_error + l_warning;
2644: l_tab := 'IGS_PE_SN_CONCT_INT';
2645: INSERT INTO IGS_AD_IMP_STATS
2646: (
2647: INTERFACE_RUN_ID,
2648: SRC_CAT_CODE,