APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_SN_SRVCE_INT

Line 369: UPDATE igs_pe_sn_srvce_int snci

365: UPDATE IGS_AD_DISABLTY_INT_all SET STATUS = '1'
366: WHERE MATCH_IND = '22' AND STATUS = '2'
367: AND INTERFACE_RUN_ID = l_interface_run_id;
368:
369: UPDATE igs_pe_sn_srvce_int snci
370: SET interface_run_id=l_interface_run_id
371: WHERE snci.status='2' AND
372: EXISTS (SELECT 1
373: FROM igs_ad_interface_all ai,

Line 381: tabname => 'IGS_PE_SN_SRVCE_INT',

377: ai.status IN ('1','4') AND
378: ai.interface_run_id=l_interface_run_id);
379:
380: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
381: tabname => 'IGS_PE_SN_SRVCE_INT',
382: cascade => TRUE);
383:
384: -- pupulate the child table with the interface run ID from the package.
385: UPDATE igs_pe_sn_srvce_int

Line 385: UPDATE igs_pe_sn_srvce_int

381: tabname => 'IGS_PE_SN_SRVCE_INT',
382: cascade => TRUE);
383:
384: -- pupulate the child table with the interface run ID from the package.
385: UPDATE igs_pe_sn_srvce_int
386: SET status = '1'
387: WHERE match_ind = '22' AND
388: status = '2' AND
389: INTERFACE_RUN_ID = l_interface_run_id;

Line 1318: DELETE FROM igs_pe_sn_srvce_int WHERE

1314: IF g_person_spcl_need_inc THEN
1315: -- call the procedure to store statistics in igs_ad_imp_stats
1316: pe_cat_stats('PERSON_SPECIAL_NEEDS');
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;

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

1903: CURSOR cur_person_spcl_need_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1904: SELECT count(*) count1,status FROM IGS_AD_DISABLTY_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1905:
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:

Line 2589: l_tab := 'IGS_PE_SN_SRVCE_INT';

2585: l_warning := 0;
2586: END IF;
2587:
2588: l_total_rec := l_success + l_error + l_warning;
2589: l_tab := 'IGS_PE_SN_SRVCE_INT';
2590: INSERT INTO IGS_AD_IMP_STATS
2591: (
2592: INTERFACE_RUN_ID,
2593: SRC_CAT_CODE,