APPS.IGS_EN_VAL_LC dependencies on IGS_PE_LANGUAGE_CD

Line 13: cp_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE) IS

9: BEGIN
10: DECLARE
11: v_person_id IGS_PE_PERSON.person_id%TYPE;
12: CURSOR gc_person_statistics(
13: cp_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE) IS
14: SELECT person_id
15: FROM IGS_PE_STATISTICS
16: WHERE NVL(home_language_cd, 'NULL') = cp_language_cd;
17: BEGIN

Line 18: -- validate the deletion of IGS_PE_LANGUAGE_CD record

14: SELECT person_id
15: FROM IGS_PE_STATISTICS
16: WHERE NVL(home_language_cd, 'NULL') = cp_language_cd;
17: BEGIN
18: -- validate the deletion of IGS_PE_LANGUAGE_CD record
19: p_message_name := null;
20: IF(p_language_cd IS NULL) THEN
21: RETURN TRUE;
22: END IF;

Line 54: cp_govt_lang_cd IGS_PE_LANGUAGE_CD.govt_language_cd%TYPE) IS

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
57: WHERE IGS_PE_GOV_LANG_CD.govt_language_cd = cp_govt_lang_cd;
58: BEGIN