APPS.IGS_PE_GEN_004 dependencies on FND_TERRITORIES_VL

Line 99: cp_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE)

95: WHERE PERSON_ID = cp_person_id AND
96: INFORMATION_TYPE = cp_information_type;
97:
98: CURSOR active_ctzn_cur (cp_person_id NUMBER,
99: cp_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE)
100: IS
101: SELECT 'Y'
102: FROM hz_citizenship
103: WHERE country_code <> cp_country_code AND

Line 109: l_fnd_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE;

105: SYSDATE BETWEEN NVL(DATE_RECOGNIZED,SYSDATE) AND NVL(END_DATE,SYSDATE);
106:
107: check_eit_exists_rec check_eit_exists_cur%ROWTYPE;
108: check_eit_rec check_eit_cur%ROWTYPE;
109: l_fnd_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE;
110: l_per_country_code VARCHAR2(30);
111: l_oth_ctzn_exists VARCHAR2(1);
112: BEGIN
113: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');

Line 176: l_fnd_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE;

172: PEI_INFORMATION1= cp_country_code AND
173: SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);
174:
175: check_eit_rec check_eit_cur%ROWTYPE;
176: l_fnd_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE;
177: l_per_country_code VARCHAR2(30);
178: BEGIN
179:
180: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');

Line 195: Purpose: This function takes the Country code defined in FND_TERRITORIES_VL as an input and returns the

191: FUNCTION CONVERT_COUNTRY_CODE (
192: P_COUNTRY_CODE IN VARCHAR2)
193: RETURN VARCHAR2 IS
194: /*
195: Purpose: This function takes the Country code defined in FND_TERRITORIES_VL as an input and returns the
196: corresponding mapping value as defined the lookup type PER_US_COUNTRY_CODE
197:
198: Change History:
199: Who When What

Line 255: cp_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE)

251: typ.system_type = cp_system_type AND
252: SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
253:
254: CURSOR ctzn_country_cur (cp_person_id NUMBER,
255: cp_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE)
256: IS
257: SELECT citizenship_id, country_code, object_version_number, date_recognized, end_date, document_reference,
258: document_type, birth_or_selected
259: FROM hz_citizenship

Line 266: cp_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE)

262:
263: ctzn_country_rec ctzn_country_cur%ROWTYPE;
264:
265: CURSOR active_ctzn_cur (cp_person_id NUMBER,
266: cp_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE)
267: IS
268: SELECT birth_or_selected, country_code, date_recognized, document_reference, document_type,
269: citizenship_id, object_version_number
270: FROM hz_citizenship

Line 307: l_fnd_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE;

303:
304: permres_rec permres_cur%ROWTYPE;
305:
306: l_count NUMBER(1);
307: l_fnd_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE;
308: l_per_country_code VARCHAR2(30);
309: l_object_version_number hz_citizenship.object_version_number%TYPE;
310: l_last_update_date hz_citizenship.last_update_date%TYPE;
311: l_citizenship_id hz_citizenship.citizenship_id%TYPE;