eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_GEN_004 dependencies on HZ_CITIZENSHIP

Line 102: FROM hz_citizenship

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
104: party_id = cp_person_id AND
105: SYSDATE BETWEEN NVL(DATE_RECOGNIZED,SYSDATE) AND NVL(END_DATE,SYSDATE);
106:

Line 259: FROM hz_citizenship

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
260: WHERE country_code = cp_country_code AND
261: party_id = cp_person_id;
262:
263: ctzn_country_rec ctzn_country_cur%ROWTYPE;

Line 270: FROM hz_citizenship

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
271: WHERE country_code <> cp_country_code AND
272: party_id = cp_person_id AND
273: SYSDATE BETWEEN NVL(DATE_RECOGNIZED,SYSDATE) AND NVL(END_DATE,SYSDATE);
274:

Line 309: l_object_version_number hz_citizenship.object_version_number%TYPE;

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;
312: l_rowid ROWID;
313: l_pe_eit_id igs_pe_eit.pe_eit_id%TYPE;

Line 310: l_last_update_date hz_citizenship.last_update_date%TYPE;

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;
312: l_rowid ROWID;
313: l_pe_eit_id igs_pe_eit.pe_eit_id%TYPE;
314: l_message VARCHAR2(2000);

Line 311: l_citizenship_id hz_citizenship.citizenship_id%TYPE;

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;
312: l_rowid ROWID;
313: l_pe_eit_id igs_pe_eit.pe_eit_id%TYPE;
314: l_message VARCHAR2(2000);
315: l_return_status VARCHAR2(10);

Line 334: -- Check whether in HZ_CITIZENSHIP the person has any record with the Country as in the profile OSS_COUNTRY_CODE.

330: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');
331: l_per_country_code := convert_country_code (l_fnd_country_code);
332:
333: /* Logic if p_has_citizen = 'Y' THEN
334: -- Check whether in HZ_CITIZENSHIP the person has any record with the Country as in the profile OSS_COUNTRY_CODE.
335: If there is no record create a record in HZ_CITIZENSHIP passing the Country as in the profile OSS_COUNTRY_CODE
336: and DATE_RECOGNIZED as the Current Date.
337: -- If there is already a Record with the Country as in the profile OSS_COUNTRY_CODE then update the record with end date as NULL.
338: -- In both the above scnerios if there is any other Active record with country other than the Country as in the

Line 335: If there is no record create a record in HZ_CITIZENSHIP passing the Country as in the profile OSS_COUNTRY_CODE

331: l_per_country_code := convert_country_code (l_fnd_country_code);
332:
333: /* Logic if p_has_citizen = 'Y' THEN
334: -- Check whether in HZ_CITIZENSHIP the person has any record with the Country as in the profile OSS_COUNTRY_CODE.
335: If there is no record create a record in HZ_CITIZENSHIP passing the Country as in the profile OSS_COUNTRY_CODE
336: and DATE_RECOGNIZED as the Current Date.
337: -- If there is already a Record with the Country as in the profile OSS_COUNTRY_CODE then update the record with end date as NULL.
338: -- In both the above scnerios if there is any other Active record with country other than the Country as in the
339: profile OSS_COUNTRY_CODE, then make them inactive (set the end date of those records as current date).

Line 441: -- Check whether in HZ_CITIZENSHIP the person has any record with the country as in P_CITIZEN_COUNTRY. If there is no record

437: END LOOP;
438: END IF;
439:
440: /* Logic if p_has_citizen = 'N' THEN
441: -- Check whether in HZ_CITIZENSHIP the person has any record with the country as in P_CITIZEN_COUNTRY. If there is no record
442: create a record in HZ_CITIZENSHIP passing the Country as in P_CITIZEN_COUNTRY and DATE_RECOGNIZED as the Current Date.
443: -- If there is already a Record with the country as in P_CITIZEN_COUNTRY then update the record with the end date as NULL.
444: -- In both the above scnerios if there is any other Active record (Current Date between Start Date and End Date) with country
445: other than P_CITIZEN_COUNTRY, then make them inactive (set the end date of those records as current date).

Line 442: create a record in HZ_CITIZENSHIP passing the Country as in P_CITIZEN_COUNTRY and DATE_RECOGNIZED as the Current Date.

438: END IF;
439:
440: /* Logic if p_has_citizen = 'N' THEN
441: -- Check whether in HZ_CITIZENSHIP the person has any record with the country as in P_CITIZEN_COUNTRY. If there is no record
442: create a record in HZ_CITIZENSHIP passing the Country as in P_CITIZEN_COUNTRY and DATE_RECOGNIZED as the Current Date.
443: -- If there is already a Record with the country as in P_CITIZEN_COUNTRY then update the record with the end date as NULL.
444: -- In both the above scnerios if there is any other Active record (Current Date between Start Date and End Date) with country
445: other than P_CITIZEN_COUNTRY, then make them inactive (set the end date of those records as current date).
446: */