APPS.IGS_EN_VAL_GCOC dependencies on IGS_PE_COUNTRY_CD

Line 13: v_country_cd IGS_PE_COUNTRY_CD%ROWTYPE;

9: RETURN BOOLEAN AS
10: BEGIN
11: DECLARE
12:
13: v_country_cd IGS_PE_COUNTRY_CD%ROWTYPE;
14: CURSOR c_country_cd IS
15: SELECT *
16: FROM IGS_PE_COUNTRY_CD
17: WHERE govt_country_cd = p_govt_country_cd and

Line 16: FROM IGS_PE_COUNTRY_CD

12:
13: v_country_cd IGS_PE_COUNTRY_CD%ROWTYPE;
14: CURSOR c_country_cd IS
15: SELECT *
16: FROM IGS_PE_COUNTRY_CD
17: WHERE govt_country_cd = p_govt_country_cd and
18: closed_ind = 'N';
19: BEGIN
20: -- Validate the update on a govt_country_record.

Line 22: -- there are IGS_PE_COUNTRY_CD records mapped to it that

18: closed_ind = 'N';
19: BEGIN
20: -- Validate the update on a govt_country_record.
21: -- A IGS_PE_GOV_COUNTRYCD record cannot be closed if
22: -- there are IGS_PE_COUNTRY_CD records mapped to it that
23: -- are still open
24: IF (p_closed_ind = 'Y') THEN
25: -- check if open IGS_PE_COUNTRY_CD records exist
26: OPEN c_country_cd;

Line 25: -- check if open IGS_PE_COUNTRY_CD records exist

21: -- A IGS_PE_GOV_COUNTRYCD record cannot be closed if
22: -- there are IGS_PE_COUNTRY_CD records mapped to it that
23: -- are still open
24: IF (p_closed_ind = 'Y') THEN
25: -- check if open IGS_PE_COUNTRY_CD records exist
26: OPEN c_country_cd;
27: FETCH c_country_cd INTO v_country_cd;
28: IF (c_country_cd%FOUND) THEN
29: CLOSE c_country_cd;