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

Line 156: FUNCTION validate_tin(p_v_api_pers_id igs_pe_alt_pers_id.api_person_id%TYPE) RETURN BOOLEAN AS

152:
153: RETURN l_v_ret_val;
154: END validate_namecontrol;
155:
156: FUNCTION validate_tin(p_v_api_pers_id igs_pe_alt_pers_id.api_person_id%TYPE) RETURN BOOLEAN AS
157: /******************************************************************
158: Created By : Amit Gairola
159: Date Created By : 04-Aug-2005
160: Purpose : Procedure for validating TIN

Line 844: p_v_api_pers_id OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,

840:
841: PROCEDURE get_alt_person_id(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
842: p_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,
843: p_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE,
844: p_v_api_pers_id OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
845: p_v_api_pers_id_uf OUT NOCOPY igs_pe_alt_pers_id.api_person_id_uf%TYPE) AS
846:
847: /******************************************************************
848: Created By : Amit Gairola

Line 845: p_v_api_pers_id_uf OUT NOCOPY igs_pe_alt_pers_id.api_person_id_uf%TYPE) AS

841: PROCEDURE get_alt_person_id(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
842: p_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,
843: p_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE,
844: p_v_api_pers_id OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
845: p_v_api_pers_id_uf OUT NOCOPY igs_pe_alt_pers_id.api_person_id_uf%TYPE) AS
846:
847: /******************************************************************
848: Created By : Amit Gairola
849: Date Created By : 06-May-2005

Line 860: FROM igs_pe_alt_pers_id altid,

856: CURSOR cur_api_pid1(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
857: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
858: SELECT altid.api_person_id,
859: altid.api_person_id_uf
860: FROM igs_pe_alt_pers_id altid,
861: igs_pe_person_id_typ pid
862: WHERE altid.pe_person_id = cp_n_person_id
863: AND altid.person_id_type = pid.person_id_type
864: AND pid.s_person_id_type = cp_v_s_person_id_type

Line 873: FROM igs_pe_alt_pers_id altid,

869: cp_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE,
870: cp_v_s_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
871: SELECT altid.api_person_id,
872: altid.api_person_id_uf
873: FROM igs_pe_alt_pers_id altid,
874: igs_pe_person_id_typ pid
875: WHERE altid.pe_person_id = cp_n_person_id
876: AND altid.person_id_type = pid.person_id_type
877: AND pid.s_person_id_type = cp_v_s_person_id_type

Line 882: l_v_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;

878: AND altid.person_id_type = cp_v_person_id_type
879: AND sysdate BETWEEN altid.start_dt AND NVL(altid.end_dt, sysdate)
880: AND pid.closed_ind = 'N';
881:
882: l_v_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
883: l_v_api_person_id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;
884:
885: BEGIN
886: IF p_v_s_person_id_type IN ('SSN','NAME_CONTROL') THEN

Line 883: l_v_api_person_id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;

879: AND sysdate BETWEEN altid.start_dt AND NVL(altid.end_dt, sysdate)
880: AND pid.closed_ind = 'N';
881:
882: l_v_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
883: l_v_api_person_id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;
884:
885: BEGIN
886: IF p_v_s_person_id_type IN ('SSN','NAME_CONTROL') THEN
887: OPEN cur_api_pid1(p_n_person_id,

Line 2022: l_v_api_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;

2018: FOR UPDATE NOWAIT;
2019:
2020: l_rec_1098t_data cur_data_exists%ROWTYPE;
2021:
2022: l_v_api_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;
2023: l_v_api_pers_id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;
2024:
2025: l_v_rowid VARCHAR2(2000);
2026:

Line 2023: l_v_api_pers_id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;

2019:
2020: l_rec_1098t_data cur_data_exists%ROWTYPE;
2021:
2022: l_v_api_pers_id igs_pe_alt_pers_id.api_person_id%TYPE;
2023: l_v_api_pers_id_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;
2024:
2025: l_v_rowid VARCHAR2(2000);
2026:
2027: CURSOR cur_party_sites(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,

Line 2087: l_v_name_control igs_pe_alt_pers_id.api_person_id%TYPE;

2083:
2084: l_rec_1098t_data_lat cur_1098t_data_lat%ROWTYPE;
2085: l_b_perm_addr BOOLEAN;
2086: l_b_temp_addr BOOLEAN;
2087: l_v_name_control igs_pe_alt_pers_id.api_person_id%TYPE;
2088: l_v_name_control_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;
2089: l_b_correction_record BOOLEAN;
2090: l_v_correction_flag igs_fi_1098t_data.correction_flag%TYPE;
2091: l_v_correction_code igs_fi_1098t_data.correction_type_code%TYPE;

Line 2088: l_v_name_control_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;

2084: l_rec_1098t_data_lat cur_1098t_data_lat%ROWTYPE;
2085: l_b_perm_addr BOOLEAN;
2086: l_b_temp_addr BOOLEAN;
2087: l_v_name_control igs_pe_alt_pers_id.api_person_id%TYPE;
2088: l_v_name_control_uf igs_pe_alt_pers_id.api_person_id_uf%TYPE;
2089: l_b_correction_record BOOLEAN;
2090: l_v_correction_flag igs_fi_1098t_data.correction_flag%TYPE;
2091: l_v_correction_code igs_fi_1098t_data.correction_type_code%TYPE;
2092: l_n_stu_1098t_id igs_fi_1098t_data.stu_1098t_id%TYPE;