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_PE_PERS_IMP_001 dependencies on IGS_AD_IMP_001

Line 84: l_enable_log := igs_ad_imp_001.g_enable_log;

80: p_batch_id);
81:
82: l_return := fnd_installation.get_app_info('IGS', l_status, l_industry, l_schema);
83:
84: l_enable_log := igs_ad_imp_001.g_enable_log;
85: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
86:
87: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
88: tabname => 'IGS_AD_INTERFACE_ALL',

Line 85: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

81:
82: l_return := fnd_installation.get_app_info('IGS', l_status, l_industry, l_schema);
83:
84: l_enable_log := igs_ad_imp_001.g_enable_log;
85: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
86:
87: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
88: tabname => 'IGS_AD_INTERFACE_ALL',
89: cascade => TRUE);

Line 234: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_STAT');

230:
231:
232: IF g_person_stat_inc THEN
233: IF l_enable_log = 'Y' THEN
234: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_STAT');
235: END IF;
236:
237:
238: -- Populating the child interface table with the interface_run_id value.

Line 292: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ADDR');

288:
289: IF g_person_addr_inc THEN
290:
291: IF l_enable_log = 'Y' THEN
292: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ADDR');
293: END IF;
294:
295:
296: Igs_Ad_Imp_026.PRC_PE_ADDR(

Line 305: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ALIAS');

301:
302:
303: IF g_person_alias_inc THEN
304: IF l_enable_log = 'Y' THEN
305: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ALIAS');
306: END IF;
307:
308: -- Populating the child interface table with the interface_run_id value.
309: UPDATE igs_ad_alias_int_all adai

Line 336: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ID_TYP');

332:
333:
334: IF g_person_id_types_inc THEN
335: IF l_enable_log = 'Y' THEN
336: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ID_TYP');
337: END IF;
338:
339: Igs_Ad_Imp_007.PRC_PE_ID_TYPES(
340: p_source_type_id=>p_source_type_id,

Line 347: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_SPL_NEED');

343:
344:
345: IF g_person_spcl_need_inc THEN
346: IF l_enable_log = 'Y' THEN
347: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_SPL_NEED');
348: END IF;
349:
350: -- pupulate the child table with the interface run ID from the package.
351: UPDATE igs_ad_disablty_int_all adi

Line 422: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_EMP_DTL');

418: END IF;
419:
420: IF g_person_emp_dtl_inc THEN
421: IF l_enable_log = 'Y' THEN
422: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_EMP_DTL');
423: END IF;
424:
425: -- Populating the child interface table with the interface_run_id value.
426: UPDATE igs_ad_emp_int_all admpi

Line 454: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_INTL_DTL');

450: END IF;
451:
452: IF g_person_int_dtl_inc THEN
453: IF l_enable_log = 'Y' THEN
454: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_INTL_DTL');
455: END IF;
456:
457: -- Populating the child interface table with the interface_run_id value.
458: UPDATE IGS_PE_VISA_INT pvi

Line 589: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_HLTH_INS');

585: END IF;
586:
587: IF g_person_hlth_ins_inc THEN
588: IF l_enable_log = 'Y' THEN
589: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_HLTH_INS');
590: END IF;
591:
592: -- Populating the child interface table with the interface_run_id value.
593: UPDATE igs_pe_immu_dtl_int pidi

Line 644: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_MIL');

640: END IF;
641:
642: IF g_person_mil_dtl_inc THEN
643: IF l_enable_log = 'Y' THEN
644: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_MIL');
645: END IF;
646:
647: -- Populating the child interface table with the interface_run_id value.
648: UPDATE igs_ad_military_int_all admi

Line 676: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_EXTR_CUR');

672: END IF;
673:
674: IF g_person_act_inc THEN
675: IF l_enable_log = 'Y' THEN
676: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_EXTR_CUR');
677: END IF;
678:
679:
680:

Line 709: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_REL');

705: END IF;
706:
707: IF g_person_rel_inc THEN
708: IF l_enable_log = 'Y' THEN
709: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_REL');
710: END IF;
711:
712: -- Populating the child interface table with the interface_run_id value.
713: UPDATE IGS_AD_RELATIONS_INT_ALL ari

Line 838: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ATHL');

834:
835:
836: IF g_person_ath_inc THEN
837: IF l_enable_log = 'Y' THEN
838: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_ATHL');
839: END IF;
840:
841: -- Populating the child interface table with the interface_run_id value.
842: UPDATE igs_pe_ath_dtl_int adli

Line 891: igs_ad_imp_001.set_message(p_name => 'IGS_PE_BEG_PE_LAN');

887: END IF;
888:
889: IF g_person_lang_inc THEN
890: IF l_enable_log = 'Y' THEN
891: igs_ad_imp_001.set_message(p_name => 'IGS_PE_BEG_PE_LAN');
892: END IF;
893:
894: -- Populating the child interface table with the interface_run_id value.
895: UPDATE igs_ad_language_int_all adli

Line 924: igs_ad_imp_001.set_message(p_name => 'IGS_PE_BEG_PE_CON');

920:
921:
922: IF g_person_contact_inc THEN
923: IF l_enable_log = 'Y' THEN
924: igs_ad_imp_001.set_message(p_name => 'IGS_PE_BEG_PE_CON');
925: END IF;
926:
927: -- Populating the child interface table with the interface_run_id value.
928: UPDATE igs_ad_contacts_int_all adci

Line 956: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_DISCIPLINARY');

952:
953:
954: IF g_person_disc_dtls_inc THEN
955: IF l_enable_log = 'Y' THEN
956: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_DISCIPLINARY');
957: END IF;
958:
959: -- Update interface tables for Felony and hearing details.
960:

Line 1007: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_HOUSING');

1003: END IF;
1004:
1005: IF g_person_housing_stat_inc THEN
1006: IF l_enable_log = 'Y' THEN
1007: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_HOUSING');
1008: END IF;
1009:
1010: -- Populating the child interface table with the interface_run_id value.
1011: UPDATE igs_pe_housing_int phi

Line 1039: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_ACAD_HONORS');

1035: END IF;
1036:
1037: IF g_person_acad_honors_inc THEN
1038: IF l_enable_log = 'Y' THEN
1039: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_ACAD_HONORS');
1040: END IF;
1041:
1042:
1043: -- Populating the child interface table with the interface_run_id value.

Line 1072: igs_ad_imp_001.set_message(p_name => 'IGS_PE_BEG_RES_DTLS');

1068: END IF;
1069:
1070: IF g_person_res_dtl_inc THEN
1071: IF l_enable_log = 'Y' THEN
1072: igs_ad_imp_001.set_message(p_name => 'IGS_PE_BEG_RES_DTLS');
1073: END IF;
1074:
1075:
1076: -- Update interface tables for Felony and hearing details.

Line 1108: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',

1104: IF g_person_creds_inc THEN
1105:
1106: IF l_enable_log = 'Y' THEN
1107: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'PERSON_CREDENTIALS', 8405);
1108: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
1109: p_token_name => 'TYPE_NAME',
1110: p_token_value => l_meaning);
1111: END IF;
1112:

Line 1138: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',

1134: IF g_acad_hist_inc THEN
1135: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'PERSON_ACADEMIC_HISTORY', 8405);
1136:
1137: IF l_enable_log = 'Y' THEN
1138: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
1139: p_token_name => 'TYPE_NAME',
1140: p_token_value => l_meaning);
1141: END IF;
1142:

Line 1172: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',p_token_name => 'TYPE_NAME',p_token_value => l_meaning);

1168:
1169: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'PRIVACY_DETAILS', 8405);
1170:
1171: IF l_enable_log = 'Y' THEN
1172: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',p_token_name => 'TYPE_NAME',p_token_value => l_meaning);
1173: END IF;
1174:
1175: -- Populating the interface table with the interface_run_id value
1176: UPDATE igs_pe_privacy_int a

Line 1231: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

1227: l_request_id NUMBER(10);
1228: l_interface_run_id IGS_AD_INTERFACE_CTL.interface_run_id%TYPE;
1229:
1230: BEGIN
1231: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1232: l_enable_log := igs_ad_imp_001.g_enable_log;
1233: l_prog_label := 'igs.plsql.igs_pe_pers_imp_001.del_cmpld_pe_records';
1234: l_label := 'igs.plsql.igs_pe_pers_imp_001.del_cmpld_pe_records.';
1235:

Line 1232: l_enable_log := igs_ad_imp_001.g_enable_log;

1228: l_interface_run_id IGS_AD_INTERFACE_CTL.interface_run_id%TYPE;
1229:
1230: BEGIN
1231: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1232: l_enable_log := igs_ad_imp_001.g_enable_log;
1233: l_prog_label := 'igs.plsql.igs_pe_pers_imp_001.del_cmpld_pe_records';
1234: l_label := 'igs.plsql.igs_pe_pers_imp_001.del_cmpld_pe_records.';
1235:
1236: -- Commit all the pending transactions

Line 1663: l_enable_log := igs_ad_imp_001.g_enable_log;

1659: g_person_creds_inc := FALSE;
1660: g_acad_hist_inc := FALSE;
1661: g_privacy_dtl_inc := FALSE;
1662:
1663: l_enable_log := igs_ad_imp_001.g_enable_log;
1664: l_prog_label := 'igs.plsql.igs_pe_pers_imp_001.set_stat_matc_rvw_pers_rcds';
1665: l_label := 'igs.plsql.igs_pe_pers_imp_001.set_stat_matc_rvw_pers_rcds.';
1666:
1667: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1875: CURSOR cur_person_type (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1871: Used local variables to populate WHO columns)
1872: (reverse chronological order - newest change first)
1873: ***************************************************************/
1874:
1875: CURSOR cur_person_type (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1876: SELECT count(*) count1,status
1877: FROM IGS_PE_TYPE_INT
1878: WHERE interface_run_id = p_interface_run_id
1879: GROUP BY status;

Line 1881: CURSOR cur_person_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1877: FROM IGS_PE_TYPE_INT
1878: WHERE interface_run_id = p_interface_run_id
1879: GROUP BY status;
1880:
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

Line 1884: CURSOR cur_person_stat_eit_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1880:
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

Line 1888: CURSOR cur_person_race_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

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;
1890:
1891: CURSOR cur_person_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1892: SELECT count(*) count1,status FROM IGS_AD_ADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1891: CURSOR cur_person_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

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;
1890:
1891: CURSOR cur_person_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1892: SELECT count(*) count1,status FROM IGS_AD_ADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1893:
1894: CURSOR cur_person_addrusage_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1895: SELECT count(*) count1, status FROM IGS_AD_ADDRUSAGE_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1894: CURSOR cur_person_addrusage_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1890:
1891: CURSOR cur_person_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1892: SELECT count(*) count1,status FROM IGS_AD_ADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1893:
1894: CURSOR cur_person_addrusage_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1895: SELECT count(*) count1, status FROM IGS_AD_ADDRUSAGE_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1896:
1897: CURSOR cur_person_alias_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1898: SELECT count(*) count1,status FROM IGS_AD_ALIAS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1897: CURSOR cur_person_alias_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1893:
1894: CURSOR cur_person_addrusage_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1895: SELECT count(*) count1, status FROM IGS_AD_ADDRUSAGE_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1896:
1897: CURSOR cur_person_alias_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1898: SELECT count(*) count1,status FROM IGS_AD_ALIAS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1899:
1900: CURSOR cur_person_id_types_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1901: SELECT count(*) count1,status FROM IGS_AD_API_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1900: CURSOR cur_person_id_types_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1896:
1897: CURSOR cur_person_alias_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1898: SELECT count(*) count1,status FROM IGS_AD_ALIAS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1899:
1900: CURSOR cur_person_id_types_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1901: SELECT count(*) count1,status FROM IGS_AD_API_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1902:
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;

Line 1903: CURSOR cur_person_spcl_need_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1899:
1900: CURSOR cur_person_id_types_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1901: SELECT count(*) count1,status FROM IGS_AD_API_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1902:
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;

Line 1906: CURSOR cur_person_srvc_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1902:
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;

Line 1909: CURSOR cur_person_conc_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

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:
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;

Line 1912: CURSOR cur_person_emp_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

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:
1915: CURSOR cur_person_visa_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1916: SELECT count(*) count1,status FROM IGS_PE_VISA_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1915: CURSOR cur_person_visa_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

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:
1915: CURSOR cur_person_visa_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1916: SELECT count(*) count1,status FROM IGS_PE_VISA_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1917:
1918: CURSOR cur_person_passport_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1919: SELECT count(*) count1,status FROM IGS_PE_PASSPORT_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1918: CURSOR cur_person_passport_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1914:
1915: CURSOR cur_person_visa_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1916: SELECT count(*) count1,status FROM IGS_PE_VISA_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1917:
1918: CURSOR cur_person_passport_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1919: SELECT count(*) count1,status FROM IGS_PE_PASSPORT_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1920:
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;

Line 1921: CURSOR cur_person_hist_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1917:
1918: CURSOR cur_person_passport_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1919: SELECT count(*) count1,status FROM IGS_PE_PASSPORT_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1920:
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

Line 1924: CURSOR cur_person_eit_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE,p_information_type VARCHAR2) IS

1920:
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

Line 1928: CURSOR cur_person_citizen_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

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;
1930:
1931: CURSOR cur_person_fund_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1932: SELECT count(*) count1,status FROM IGS_PE_FUND_SRC_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1931: CURSOR cur_person_fund_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

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;
1930:
1931: CURSOR cur_person_fund_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1932: SELECT count(*) count1,status FROM IGS_PE_FUND_SRC_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1933:
1934: CURSOR cur_person_immu_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1935: SELECT count(*) count1,status FROM IGS_PE_IMMU_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1934: CURSOR cur_person_immu_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1930:
1931: CURSOR cur_person_fund_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1932: SELECT count(*) count1,status FROM IGS_PE_FUND_SRC_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1933:
1934: CURSOR cur_person_immu_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1935: SELECT count(*) count1,status FROM IGS_PE_IMMU_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1936:
1937: CURSOR cur_person_health_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1938: SELECT count(*) count1,status FROM IGS_AD_HLTH_INS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1937: CURSOR cur_person_health_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1933:
1934: CURSOR cur_person_immu_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1935: SELECT count(*) count1,status FROM IGS_PE_IMMU_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1936:
1937: CURSOR cur_person_health_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1938: SELECT count(*) count1,status FROM IGS_AD_HLTH_INS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1939:
1940: CURSOR cur_person_mil_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1941: SELECT count(*) count1,status FROM IGS_AD_MILITARY_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1940: CURSOR cur_person_mil_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1936:
1937: CURSOR cur_person_health_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1938: SELECT count(*) count1,status FROM IGS_AD_HLTH_INS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1939:
1940: CURSOR cur_person_mil_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1941: SELECT count(*) count1,status FROM IGS_AD_MILITARY_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1942:
1943: CURSOR cur_person_act_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1944: SELECT count(*) count1,status FROM IGS_AD_EXCURR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1943: CURSOR cur_person_act_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1939:
1940: CURSOR cur_person_mil_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1941: SELECT count(*) count1,status FROM IGS_AD_MILITARY_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1942:
1943: CURSOR cur_person_act_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1944: SELECT count(*) count1,status FROM IGS_AD_EXCURR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1945:
1946: CURSOR cur_person_rel_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1947: SELECT count(*) count1,status FROM IGS_AD_RELATIONS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1946: CURSOR cur_person_rel_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1942:
1943: CURSOR cur_person_act_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1944: SELECT count(*) count1,status FROM IGS_AD_EXCURR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1945:
1946: CURSOR cur_person_rel_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1947: SELECT count(*) count1,status FROM IGS_AD_RELATIONS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1948:
1949: CURSOR cur_person_ath_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1950: SELECT count(*) count1,status FROM IGS_PE_ATH_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1949: CURSOR cur_person_ath_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1945:
1946: CURSOR cur_person_rel_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1947: SELECT count(*) count1,status FROM IGS_AD_RELATIONS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1948:
1949: CURSOR cur_person_ath_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1950: SELECT count(*) count1,status FROM IGS_PE_ATH_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1951:
1952: CURSOR cur_person_ath_prg_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1953: SELECT count(*) count1,status FROM IGS_PE_ATH_PRG_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1952: CURSOR cur_person_ath_prg_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1948:
1949: CURSOR cur_person_ath_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1950: SELECT count(*) count1,status FROM IGS_PE_ATH_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1951:
1952: CURSOR cur_person_ath_prg_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1953: SELECT count(*) count1,status FROM IGS_PE_ATH_PRG_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1954:
1955: CURSOR cur_person_lang_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1956: SELECT count(*) count1,status FROM IGS_AD_LANGUAGE_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1955: CURSOR cur_person_lang_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1951:
1952: CURSOR cur_person_ath_prg_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1953: SELECT count(*) count1,status FROM IGS_PE_ATH_PRG_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1954:
1955: CURSOR cur_person_lang_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1956: SELECT count(*) count1,status FROM IGS_AD_LANGUAGE_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1957:
1958: CURSOR cur_person_contact_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1959: SELECT count(*) count1,status FROM IGS_AD_CONTACTS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1958: CURSOR cur_person_contact_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1954:
1955: CURSOR cur_person_lang_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1956: SELECT count(*) count1,status FROM IGS_AD_LANGUAGE_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1957:
1958: CURSOR cur_person_contact_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1959: SELECT count(*) count1,status FROM IGS_AD_CONTACTS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1960:
1961: CURSOR cur_person_flny_dtls_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1962: SELECT count(*) count1,status FROM IGS_PE_FLNY_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1961: CURSOR cur_person_flny_dtls_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1957:
1958: CURSOR cur_person_contact_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1959: SELECT count(*) count1,status FROM IGS_AD_CONTACTS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1960:
1961: CURSOR cur_person_flny_dtls_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1962: SELECT count(*) count1,status FROM IGS_PE_FLNY_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1963:
1964: CURSOR cur_person_hear_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1965: SELECT count(*) count1,status FROM IGS_PE_HEAR_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1964: CURSOR cur_person_hear_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1960:
1961: CURSOR cur_person_flny_dtls_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1962: SELECT count(*) count1,status FROM IGS_PE_FLNY_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1963:
1964: CURSOR cur_person_hear_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1965: SELECT count(*) count1,status FROM IGS_PE_HEAR_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1966:
1967: CURSOR cur_person_housing_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1968: SELECT count(*) count1,status FROM IGS_PE_HOUSING_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1967: CURSOR cur_person_housing_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1963:
1964: CURSOR cur_person_hear_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1965: SELECT count(*) count1,status FROM IGS_PE_HEAR_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1966:
1967: CURSOR cur_person_housing_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1968: SELECT count(*) count1,status FROM IGS_PE_HOUSING_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1969:
1970: CURSOR cur_person_acad_honors_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1971: SELECT count(*) count1,status FROM IGS_AD_ACADHONOR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1970: CURSOR cur_person_acad_honors_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1966:
1967: CURSOR cur_person_housing_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1968: SELECT count(*) count1,status FROM IGS_PE_HOUSING_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1969:
1970: CURSOR cur_person_acad_honors_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1971: SELECT count(*) count1,status FROM IGS_AD_ACADHONOR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1972:
1973: CURSOR cur_person_res_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1974: SELECT count(*) count1,status FROM IGS_PE_RES_DTLS_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1973: CURSOR cur_person_res_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1969:
1970: CURSOR cur_person_acad_honors_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1971: SELECT count(*) count1,status FROM IGS_AD_ACADHONOR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1972:
1973: CURSOR cur_person_res_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1974: SELECT count(*) count1,status FROM IGS_PE_RES_DTLS_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1975:
1976: CURSOR cur_relacad_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1977: SELECT count(*) count1,status FROM IGS_AD_RELACAD_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1976: CURSOR cur_relacad_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1972:
1973: CURSOR cur_person_res_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1974: SELECT count(*) count1,status FROM IGS_PE_RES_DTLS_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1975:
1976: CURSOR cur_relacad_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1977: SELECT count(*) count1,status FROM IGS_AD_RELACAD_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1978:
1979: CURSOR cur_rel_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1980: SELECT count(*) count1,status FROM IGS_AD_RELADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1979: CURSOR cur_rel_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1975:
1976: CURSOR cur_relacad_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1977: SELECT count(*) count1,status FROM IGS_AD_RELACAD_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1978:
1979: CURSOR cur_rel_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1980: SELECT count(*) count1,status FROM IGS_AD_RELADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1981:
1982: CURSOR cur_relcon_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1983: SELECT count(*) count1,status FROM IGS_AD_REL_CON_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1982: CURSOR cur_relcon_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1978:
1979: CURSOR cur_rel_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1980: SELECT count(*) count1,status FROM IGS_AD_RELADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1981:
1982: CURSOR cur_relcon_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1983: SELECT count(*) count1,status FROM IGS_AD_REL_CON_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1984:
1985: CURSOR cur_relemp_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1986: SELECT count(*) count1,status FROM IGS_AD_RELEMP_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1985: CURSOR cur_relemp_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1981:
1982: CURSOR cur_relcon_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1983: SELECT count(*) count1,status FROM IGS_AD_REL_CON_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1984:
1985: CURSOR cur_relemp_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1986: SELECT count(*) count1,status FROM IGS_AD_RELEMP_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1987:
1988: CURSOR cur_ad_interface_all (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1989: SELECT count(*) count1,status FROM IGS_AD_INTERFACE_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1988: CURSOR cur_ad_interface_all (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1984:
1985: CURSOR cur_relemp_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1986: SELECT count(*) count1,status FROM IGS_AD_RELEMP_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1987:
1988: CURSOR cur_ad_interface_all (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1989: SELECT count(*) count1,status FROM IGS_AD_INTERFACE_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1990:
1991: CURSOR cur_cred_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1992: SELECT count(*) count1,status FROM igs_pe_cred_int WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1991: CURSOR cur_cred_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1987:
1988: CURSOR cur_ad_interface_all (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1989: SELECT count(*) count1,status FROM IGS_AD_INTERFACE_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1990:
1991: CURSOR cur_cred_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1992: SELECT count(*) count1,status FROM igs_pe_cred_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1993:
1994: CURSOR cur_acadhis_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1995: SELECT count(*) count1,status FROM igs_ad_acadhis_int_all WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1994: CURSOR cur_acadhis_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1990:
1991: CURSOR cur_cred_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1992: SELECT count(*) count1,status FROM igs_pe_cred_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1993:
1994: CURSOR cur_acadhis_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1995: SELECT count(*) count1,status FROM igs_ad_acadhis_int_all WHERE interface_run_id = p_interface_run_id GROUP BY status;
1996:
1997: CURSOR cur_privacy_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1998: SELECT count(*) count1,status FROM igs_pe_privacy_int WHERE interface_run_id = p_interface_run_id GROUP BY status;

Line 1997: CURSOR cur_privacy_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS

1993:
1994: CURSOR cur_acadhis_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1995: SELECT count(*) count1,status FROM igs_ad_acadhis_int_all WHERE interface_run_id = p_interface_run_id GROUP BY status;
1996:
1997: CURSOR cur_privacy_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1998: SELECT count(*) count1,status FROM igs_pe_privacy_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1999:
2000:
2001: l_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE;

Line 2001: l_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE;

1997: CURSOR cur_privacy_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1998: SELECT count(*) count1,status FROM igs_pe_privacy_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1999:
2000:
2001: l_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE;
2002: l_success NUMBER;
2003: l_error NUMBER;
2004: l_warning NUMBER;
2005: l_total_rec NUMBER;

Line 2013: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;

2009: l_source_category VARCHAR2(30);
2010: BEGIN
2011: l_sysdate := SYSDATE;
2012: l_user_id := fnd_global.user_id;
2013: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
2014: l_success := 0;
2015: l_error := 0;
2016: l_warning := 0;
2017: l_total_rec := 0;