APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_PE_ALT_PERS_ID

Line 19: Modified the the signatute of call to TBH IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW

15: new columns being added to IGS_AD_PS_APPL_INST
16: knag 21-Nov-2002 Added new parameters to admp_ins_adm_appl for bug 2664410
17: and new parameters to call to igs_ad_appl_pkg.insert_row
18: pkpatel 01-DEC-2002 Bug NO: 2599109 (Sevis DLD)
19: Modified the the signatute of call to TBH IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW
20: anilk 18-FEB-2003 Bug#2784198
21: Added closed_ind = 'N' to where clause for cursor c_hl
22: asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed
23: gmaheswa 19-Nov-2003 3227107: Modified cursor c_pa in admp_ins_person_addr to select records having active status.

Line 2058: -- inserts a new record into the IGS_PE_ALT_PERS_ID table

2054: App_Exception.Raise_Exception;
2055: END admp_ins_tert_edu;
2056:
2057: --
2058: -- inserts a new record into the IGS_PE_ALT_PERS_ID table
2059: PROCEDURE admp_ins_alt_prsn_id(
2060: p_alt_person_id IN VARCHAR2 ,
2061: p_alt_person_id_type IN VARCHAR2 ,
2062: p_person_id IN NUMBER ,

Line 2068: v_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE;

2064: p_end_dt IN DATE )
2065: IS
2066: BEGIN
2067: DECLARE
2068: v_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
2069: CURSOR c_api IS
2070: SELECT api.api_person_id
2071: FROM IGS_PE_ALT_PERS_ID api
2072: WHERE pe_person_id = p_person_id AND

Line 2071: FROM IGS_PE_ALT_PERS_ID api

2067: DECLARE
2068: v_api_person_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
2069: CURSOR c_api IS
2070: SELECT api.api_person_id
2071: FROM IGS_PE_ALT_PERS_ID api
2072: WHERE pe_person_id = p_person_id AND
2073: api_person_id = p_alt_person_id AND
2074: person_id_type = p_alt_person_id_type;
2075: lv_rowid VARCHAR2(25);

Line 2082: IGS_PE_ALT_PERS_ID_Pkg.Insert_Row (

2078: OPEN c_api;
2079: FETCH c_api INTO v_api_person_id;
2080: IF (c_api%NOTFOUND) THEN
2081:
2082: IGS_PE_ALT_PERS_ID_Pkg.Insert_Row (
2083: X_Mode => 'R',
2084: X_RowId => lv_rowid,
2085: X_Pe_Person_Id => p_person_id,
2086: X_Api_Person_Id => p_alt_person_id,

Line 2163: FROM IGS_PE_ALT_PERS_ID

2159: v_new_sex VARCHAR2(1) DEFAULT NULL;
2160: l_sex Varchar2(30) DEFAULT NULL;
2161: CURSOR c_api IS
2162: SELECT 'x'
2163: FROM IGS_PE_ALT_PERS_ID
2164: WHERE pe_person_id = p_person_id AND
2165: api_person_id = p_tac_person_id AND
2166: person_id_type = p_alt_person_id_type;
2167: lv_rowid VARCHAR2(25);

Line 2187: -- IGS_PE_ALT_PERS_ID rec

2183: 'matched Callista person' || ' ' ||
2184: IGS_GE_NUMBER.TO_CANN(p_person_id);
2185: -- Record the new TAC ID
2186: -- First check if this TAC ID already exists in
2187: -- IGS_PE_ALT_PERS_ID rec
2188: OPEN c_api;
2189: FETCH c_api INTO v_api_x;
2190: IF (c_api%NOTFOUND) THEN
2191: admp_ins_alt_prsn_id(