APPS.IGS_EN_VAL_LC dependencies on IGS_PE_GOV_LANG_CD

Line 52: gv_closed_ind IGS_PE_GOV_LANG_CD.closed_ind%TYPE;

48: p_message_name OUT NOCOPY VARCHAR2)
49: RETURN BOOLEAN AS
50: BEGIN
51: DECLARE
52: gv_closed_ind IGS_PE_GOV_LANG_CD.closed_ind%TYPE;
53: CURSOR gc_govt_lang_cd(
54: cp_govt_lang_cd IGS_PE_LANGUAGE_CD.govt_language_cd%TYPE) IS
55: SELECT IGS_PE_GOV_LANG_CD.closed_ind
56: FROM IGS_PE_GOV_LANG_CD

Line 55: SELECT IGS_PE_GOV_LANG_CD.closed_ind

51: DECLARE
52: gv_closed_ind IGS_PE_GOV_LANG_CD.closed_ind%TYPE;
53: CURSOR gc_govt_lang_cd(
54: cp_govt_lang_cd IGS_PE_LANGUAGE_CD.govt_language_cd%TYPE) IS
55: SELECT IGS_PE_GOV_LANG_CD.closed_ind
56: FROM IGS_PE_GOV_LANG_CD
57: WHERE IGS_PE_GOV_LANG_CD.govt_language_cd = cp_govt_lang_cd;
58: BEGIN
59: -- This module validates if IGS_PE_GOV_LANG_CD.govt_language_cd

Line 56: FROM IGS_PE_GOV_LANG_CD

52: gv_closed_ind IGS_PE_GOV_LANG_CD.closed_ind%TYPE;
53: CURSOR gc_govt_lang_cd(
54: cp_govt_lang_cd IGS_PE_LANGUAGE_CD.govt_language_cd%TYPE) IS
55: SELECT IGS_PE_GOV_LANG_CD.closed_ind
56: FROM IGS_PE_GOV_LANG_CD
57: WHERE IGS_PE_GOV_LANG_CD.govt_language_cd = cp_govt_lang_cd;
58: BEGIN
59: -- This module validates if IGS_PE_GOV_LANG_CD.govt_language_cd
60: -- is closed

Line 57: WHERE IGS_PE_GOV_LANG_CD.govt_language_cd = cp_govt_lang_cd;

53: CURSOR gc_govt_lang_cd(
54: cp_govt_lang_cd IGS_PE_LANGUAGE_CD.govt_language_cd%TYPE) IS
55: SELECT IGS_PE_GOV_LANG_CD.closed_ind
56: FROM IGS_PE_GOV_LANG_CD
57: WHERE IGS_PE_GOV_LANG_CD.govt_language_cd = cp_govt_lang_cd;
58: BEGIN
59: -- This module validates if IGS_PE_GOV_LANG_CD.govt_language_cd
60: -- is closed
61: p_message_name := null;

Line 59: -- This module validates if IGS_PE_GOV_LANG_CD.govt_language_cd

55: SELECT IGS_PE_GOV_LANG_CD.closed_ind
56: FROM IGS_PE_GOV_LANG_CD
57: WHERE IGS_PE_GOV_LANG_CD.govt_language_cd = cp_govt_lang_cd;
58: BEGIN
59: -- This module validates if IGS_PE_GOV_LANG_CD.govt_language_cd
60: -- is closed
61: p_message_name := null;
62: OPEN gc_govt_lang_cd(
63: p_govt_language_cd);