APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_REF_COUNTRY

Line 1672: CURSOR old_country_cur (p_country_code igs_uc_ref_country.country_code%TYPE) IS

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
1673: SELECT rowid
1674: FROM igs_uc_ref_country
1675: WHERE country_code = p_country_code;
1676:

Line 1674: FROM igs_uc_ref_country

1670:
1671: -- check whether corresponding record already exists.
1672: CURSOR old_country_cur (p_country_code igs_uc_ref_country.country_code%TYPE) IS
1673: SELECT rowid
1674: FROM igs_uc_ref_country
1675: WHERE country_code = p_country_code;
1676:
1677: BEGIN
1678: -- initialize variables

Line 1717: igs_uc_ref_country_pkg.insert_row --

1713:
1714: -- If not found then insert
1715: IF l_rowid IS NULL THEN
1716: BEGIN
1717: igs_uc_ref_country_pkg.insert_row --
1718: (
1719: x_rowid => l_rowid
1720: ,x_country_code => new_country_rec.countrycode
1721: ,x_description => new_country_rec.description

Line 1735: igs_uc_ref_country_pkg.update_row

1731: END;
1732:
1733: ELSE -- update
1734: BEGIN
1735: igs_uc_ref_country_pkg.update_row
1736: (
1737: x_rowid => l_rowid
1738: ,x_country_code => new_country_rec.countrycode
1739: ,x_description => new_country_rec.description