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_AD_IMP_002 dependencies on IGS_PE_PERSON_ID_TYP

Line 221: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS

217: AND ai.status IN ('1','4'); --4035277, if address errors out, it sets status =4 for ad_interface
218: -- furture processing should happen..so always check for 1,4 in ad_interface
219:
220: -- Cursor to get format mask to validate person alternate id.
221: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
222: SELECT format_mask
223: FROM igs_pe_person_id_typ
224: WHERE person_id_type = cp_person_id_type;
225:

Line 223: FROM igs_pe_person_id_typ

219:
220: -- Cursor to get format mask to validate person alternate id.
221: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
222: SELECT format_mask
223: FROM igs_pe_person_id_typ
224: WHERE person_id_type = cp_person_id_type;
225:
226: api_type_rec api_type_cur%ROWTYPE;
227: api_rec api_cur%ROWTYPE;

Line 233: FROM IGS_PE_PERSON_ID_TYP

229:
230: /* Following cursor is added as a fix for bug number 2333026 */
231: CURSOR c_pref_alt_id_type IS
232: SELECT PERSON_ID_TYPE
233: FROM IGS_PE_PERSON_ID_TYP
234: WHERE PREFERRED_IND ='Y';
235:
236: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
237: SELECT pehz.ROWID, pehz.*

Line 241: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

237: SELECT pehz.ROWID, pehz.*
238: FROM IGS_PE_HZ_PARTIES pehz
239: WHERE party_id = cp_person_id;
240:
241: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
242: l_pref_altid p_person_rec.PREF_ALTERNATE_ID%TYPE;
243: tlinfo2 pe_hz_parties_cur%ROWTYPE;
244: l_rowid VARCHAR2(25);
245: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;

Line 247: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

243: tlinfo2 pe_hz_parties_cur%ROWTYPE;
244: l_rowid VARCHAR2(25);
245: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
246: l_person_number VARCHAR2(30);
247: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
248: l_statistics_id NUMBER;
249: l_Return_Status VARCHAR2(1);
250: l_Status VARCHAR2(1);
251: l_Msg_Data VARCHAR2(4000);

Line 1145: igs_pe_person_id_type_v pit

1141: FROM
1142: hz_parties p,
1143: igs_pe_hz_parties pd,
1144: hz_person_profiles pp,
1145: igs_pe_person_id_type_v pit
1146: WHERE p.party_id = cp_person_id
1147: AND p.party_id = pit.pe_person_id (+)
1148: AND p.party_id = pd.party_id (+)
1149: AND p.party_id = pp.party_id

Line 1153: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS

1149: AND p.party_id = pp.party_id
1150: AND SYSDATE BETWEEN pp.effective_start_date AND NVL(pp.effective_end_date,SYSDATE);
1151:
1152: -- Cursor to get format mask to validate person alternate id.
1153: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1154: SELECT format_mask
1155: FROM igs_pe_person_id_typ
1156: WHERE person_id_type = cp_person_id_type;
1157:

Line 1155: FROM igs_pe_person_id_typ

1151:
1152: -- Cursor to get format mask to validate person alternate id.
1153: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1154: SELECT format_mask
1155: FROM igs_pe_person_id_typ
1156: WHERE person_id_type = cp_person_id_type;
1157:
1158: api_type_rec api_type_cur%ROWTYPE;
1159:

Line 1162: FROM IGS_PE_PERSON_ID_TYP

1158: api_type_rec api_type_cur%ROWTYPE;
1159:
1160: CURSOR c_pref_alt_id_type IS
1161: SELECT PERSON_ID_TYPE
1162: FROM IGS_PE_PERSON_ID_TYP
1163: WHERE PREFERRED_IND ='Y';
1164:
1165: CURSOR pe_hz_parties_cur(cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1166: SELECT pehz.ROWID, pehz.*

Line 1175: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

1171: SELECT last_update_date, ROWID
1172: FROM hz_parties
1173: WHERE party_id = cp_person_id;
1174:
1175: l_pref_altid_type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
1176: l_pref_altid p_person_rec.PREF_ALTERNATE_ID%TYPE;
1177: tlinfo2 pe_hz_parties_cur%ROWTYPE;
1178: c_null_hdlg_per_rec c_null_hdlg_per_cur%ROWTYPE;
1179: lv_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

Line 1184: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

1180:
1181: l_location_Id NUMBER;
1182: l_rowid VARCHAR2(25);
1183: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
1184: l_PrefPersonIDType IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
1185: l_status VARCHAR2(2);
1186: l_error_code VARCHAR2(6);
1187: l_Last_Update_Date DATE;
1188: l_Error_Code_Num NUMBER;

Line 1762: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS

1758: */
1759:
1760: l_exists VARCHAR2(1);
1761:
1762: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1763: SELECT format_mask, region_ind
1764: FROM igs_pe_person_id_typ
1765: WHERE person_id_type = cp_person_id_type
1766: AND closed_ind = 'N';

Line 1764: FROM igs_pe_person_id_typ

1760: l_exists VARCHAR2(1);
1761:
1762: CURSOR api_type_cur(cp_person_id_type igs_pe_person_id_typ.person_id_type%TYPE) IS
1763: SELECT format_mask, region_ind
1764: FROM igs_pe_person_id_typ
1765: WHERE person_id_type = cp_person_id_type
1766: AND closed_ind = 'N';
1767:
1768: CURSOR region_cd_cur(cp_geography_type hz_geographies.geography_type%TYPE,

Line 3093: igs_pe_person_id_type_v pit

3089: SELECT 'X'
3090: FROM hz_parties p,
3091: igs_pe_hz_parties pd,
3092: hz_person_profiles pp,
3093: igs_pe_person_id_type_v pit
3094: WHERE p.party_id = cp_person_id
3095: AND p.party_id = pit.pe_person_id (+)
3096: AND p.party_id = pd.party_id (+)
3097: AND p.party_id = pp.party_id