APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_COUNTRY_INTS

Line 1668: FROM igs_uc_country_ints

1664: SELECT rowid
1665: ,countrycode
1666: ,description
1667: ,type
1668: FROM igs_uc_country_ints
1669: WHERE record_status = 'N';
1670:
1671: -- check whether corresponding record already exists.
1672: CURSOR old_country_cur (p_country_code igs_uc_ref_country.country_code%TYPE) IS

Line 1771: UPDATE igs_uc_country_ints

1767:
1768: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1769: -- while processing the record.
1770: IF g_error_code IS NOT NULL THEN
1771: UPDATE igs_uc_country_ints
1772: SET error_code = g_error_code
1773: WHERE rowid = new_country_rec.rowid;
1774:
1775: -- log error message/meaning.

Line 1781: UPDATE igs_uc_country_ints

1777: -- update error count
1778: g_error_rec_cnt := g_error_rec_cnt + 1;
1779:
1780: ELSE
1781: UPDATE igs_uc_country_ints
1782: SET record_status = 'D',
1783: error_code = NULL
1784: WHERE rowid = new_country_rec.rowid;
1785: