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_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 795: FROM igs_pe_alt_pers_id

791: IS
792:
793: CURSOR c_alt_id IS
794: SELECT api_person_id
795: FROM igs_pe_alt_pers_id
796: WHERE pe_person_id = p_person_id
797: AND person_id_type
798: IN (SELECT person_id_type
799: FROM igs_pe_person_id_typ

Line 1639: FROM igs_pe_alt_pers_id palt,

1635:
1636: CURSOR c_alternate_id(cp_system_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
1637: SELECT palt.api_person_id_uf,
1638: palt.region_cd
1639: FROM igs_pe_alt_pers_id palt,
1640: igs_pe_person_id_typ typv
1641: WHERE typv.s_person_id_type = cp_system_person_id_type
1642: AND palt.person_id_type = typv.person_id_type
1643: AND palt.pe_person_id = p_person_rec.person_id

Line 1646: l_drivers_license IGS_PE_ALT_PERS_ID.api_person_id%TYPE;

1642: AND palt.person_id_type = typv.person_id_type
1643: AND palt.pe_person_id = p_person_rec.person_id
1644: AND SYSDATE BETWEEN palt.start_dt AND NVL(palt.end_dt,SYSDATE);
1645:
1646: l_drivers_license IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1647: l_drivers_license_state IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1648: l_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1649: l_new_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1650: l_taxid IGS_PE_ALT_PERS_ID.api_person_id%TYPE;

Line 1647: l_drivers_license_state IGS_PE_ALT_PERS_ID.region_cd%TYPE;

1643: AND palt.pe_person_id = p_person_rec.person_id
1644: AND SYSDATE BETWEEN palt.start_dt AND NVL(palt.end_dt,SYSDATE);
1645:
1646: l_drivers_license IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1647: l_drivers_license_state IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1648: l_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1649: l_new_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1650: l_taxid IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1651: l_not_valid BOOLEAN := FALSE;

Line 1648: l_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;

1644: AND SYSDATE BETWEEN palt.start_dt AND NVL(palt.end_dt,SYSDATE);
1645:
1646: l_drivers_license IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1647: l_drivers_license_state IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1648: l_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1649: l_new_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1650: l_taxid IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1651: l_not_valid BOOLEAN := FALSE;
1652: l_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;

Line 1649: l_new_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;

1645:
1646: l_drivers_license IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1647: l_drivers_license_state IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1648: l_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1649: l_new_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1650: l_taxid IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1651: l_not_valid BOOLEAN := FALSE;
1652: l_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1653: lv_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;

Line 1650: l_taxid IGS_PE_ALT_PERS_ID.api_person_id%TYPE;

1646: l_drivers_license IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1647: l_drivers_license_state IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1648: l_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1649: l_new_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1650: l_taxid IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1651: l_not_valid BOOLEAN := FALSE;
1652: l_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1653: lv_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1654:

Line 1652: l_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;

1648: l_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1649: l_new_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1650: l_taxid IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1651: l_not_valid BOOLEAN := FALSE;
1652: l_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1653: lv_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1654:
1655: BEGIN
1656: /* Debug */

Line 1653: lv_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;

1649: l_new_ssn IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1650: l_taxid IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
1651: l_not_valid BOOLEAN := FALSE;
1652: l_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1653: lv_region_cd IGS_PE_ALT_PERS_ID.region_cd%TYPE;
1654:
1655: BEGIN
1656: /* Debug */
1657: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 3670: FROM igs_pe_alt_pers_id alt

3666:
3667: CURSOR c_get_sevis_user_id(c_dep_id NUMBER)
3668: IS
3669: SELECT alt.api_person_id
3670: FROM igs_pe_alt_pers_id alt
3671: WHERE
3672: alt.pe_person_id = c_dep_id AND
3673: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ
3674: WHERE s_person_id_type = 'SEVIS_ID') AND

Line 10393: FROM igs_pe_ev_form fr, hz_parties pr, igs_pe_alt_pers_id alt

10389: l_btch_id igs_sv_batches.batch_id%TYPE;
10390:
10391: CURSOR C_EV_CUR IS
10392: SELECT fr.person_id, min(ev_form_id) form_id, pr.party_number person_number, fr.no_show_flag, fr.reprint_reason reprint_reason
10393: FROM igs_pe_ev_form fr, hz_parties pr, igs_pe_alt_pers_id alt
10394: WHERE pr.party_id = fr.person_id AND fr.form_effective_date <= trunc(sysdate)
10395: AND fr.ev_form_id NOT IN
10396: (SELECT st.ev_form_id FROM igs_pe_ev_form_stat st
10397: WHERE st.action_type IN ('TR','ED')

Line 10406: fr.person_id IN (SELECT rel.object_id FROM hz_relationships rel, igs_pe_alt_pers_id alt

10402: AND pr.record_status <> 'E' AND prs.person_id = fr.person_id)
10403: ) AND fr.sevis_school_identifier = p_org_party_id AND
10404: (
10405: p_dso_id IS NULL OR
10406: fr.person_id IN (SELECT rel.object_id FROM hz_relationships rel, igs_pe_alt_pers_id alt
10407: WHERE rel.subject_id = alt.pe_person_id and
10408: alt.api_person_id = p_dso_id and
10409: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ WHERE s_person_id_type = 'SEVIS_ID')
10410: AND rel.DIRECTIONAL_FLAG = 'F' AND sysdate between rel.start_date AND nvl(end_date, sysdate)

Line 10433: FROM hz_relationships rel, igs_pe_alt_pers_id alt

10429: ) )
10430: AND fr.sevis_school_identifier = p_org_party_id AND
10431: ( p_dso_id IS NULL OR
10432: fr.person_id IN (SELECT rel.object_id
10433: FROM hz_relationships rel, igs_pe_alt_pers_id alt
10434: WHERE rel.subject_id = alt.pe_person_id and
10435: alt.api_person_id = p_dso_id and
10436: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ
10437: WHERE s_person_id_type = 'SEVIS_ID') AND

Line 10495: FROM hz_relationships rel, igs_pe_alt_pers_id alt

10491:
10492: CURSOR c_get_dso_id(c_person_id igs_pe_ev_form.person_id%TYPE)
10493: IS
10494: SELECT alt.api_person_id
10495: FROM hz_relationships rel, igs_pe_alt_pers_id alt
10496: WHERE rel.subject_id = c_person_id and
10497: rel.object_id = alt.pe_person_id AND
10498: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
10499: rel.RELATIONSHIP_CODE = 'NEXT_OF_KIN_FOR' AND

Line 11846: UPDATE igs_pe_alt_pers_id

11842:
11843: -- Update sevis id
11844: -- end date current one (if any)
11845:
11846: UPDATE igs_pe_alt_pers_id
11847: SET end_dt = trunc(sysdate)
11848: WHERE pe_person_id = p_person_id
11849: AND person_id_type
11850: IN (SELECT person_id_type

Line 11861: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (

11857: FETCH c_alt INTO l_alt_id;
11858: CLOSE c_alt;
11859:
11860: -- Insert new
11861: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (
11862: X_ROWID => l_rowid,
11863: X_PE_PERSON_ID => p_person_id,
11864: X_API_PERSON_ID => p_sevisID,
11865: X_API_PERSON_ID_UF => p_sevisID,