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.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGS_PE_PERSON

Line 16: gv_format igs_pe_person_id_typ.format_mask%TYPE := NULL;

12: g_bad_rec NUMBER := 0;
13: g_dup_rec NUMBER := 0;
14: g_review_count NUMBER := 0;
15: g_rec_not_ins BOOLEAN := TRUE;
16: gv_format igs_pe_person_id_typ.format_mask%TYPE := NULL;
17: g_setup_score igf_ap_record_match%ROWTYPE;
18: g_isir_intrface_rec igf_ap_isir_ints%ROWTYPE;
19: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
20: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;

Line 2486: FROM igs_pe_person

2482: SELECT person_number,
2483: api_person_id,
2484: birth_dt,
2485: sex
2486: FROM igs_pe_person
2487: WHERE person_id = ln_person_id;
2488:
2489: person_rec person_cur%ROWTYPE;
2490:

Line 2517: FROM igs_pe_person_id_typ

2513: AND SYSDATE BETWEEN altp.start_dt and NVL(altp.end_dt, SYSDATE);
2514:
2515: CURSOR person_id_type_cur ( cp_pers_id_type VARCHAR2 ) IS
2516: SELECT person_id_type
2517: FROM igs_pe_person_id_typ
2518: WHERE s_person_id_type = cp_pers_id_type ;
2519:
2520: l_pers_id_type igs_pe_person_id_typ.person_id_type%TYPE;
2521:

Line 2520: l_pers_id_type igs_pe_person_id_typ.person_id_type%TYPE;

2516: SELECT person_id_type
2517: FROM igs_pe_person_id_typ
2518: WHERE s_person_id_type = cp_pers_id_type ;
2519:
2520: l_pers_id_type igs_pe_person_id_typ.person_id_type%TYPE;
2521:
2522:
2523: CURSOR cur_lkups(cp_lkup_type VARCHAR2, cp_lkup_cd VARCHAR2) IS
2524: SELECT tag

Line 2533: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;

2529:
2530:
2531: ln_person_number hz_parties.party_number%TYPE;
2532: ln_person_id igf_ap_fa_base_rec.person_id%TYPE;
2533: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
2534: alt_person_id_rec alt_person_id_cur%ROWTYPE;
2535: ln_msg_count NUMBER;
2536: lv_msg_data VARCHAR2(2000);
2537: lv_return_status VARCHAR2(1);

Line 3079: FROM igs_pe_person_types

3075: FROM igs_ad_cal_conf;
3076:
3077: CURSOR cur_person_type ( cp_sys_type VARCHAR2) IS
3078: SELECT person_type_code
3079: FROM igs_pe_person_types
3080: WHERE system_type = cp_sys_type
3081: AND closed_ind = 'N' ;
3082:
3083: l_sys_type VARCHAR2(30) ;

Line 3084: l_person_type igs_pe_person_types.person_type_code%TYPE;

3080: WHERE system_type = cp_sys_type
3081: AND closed_ind = 'N' ;
3082:
3083: l_sys_type VARCHAR2(30) ;
3084: l_person_type igs_pe_person_types.person_type_code%TYPE;
3085: l_inq_cal_type igs_ad_cal_conf.inq_cal_type%TYPE;
3086: l_rowid ROWID;
3087: l_adm_seq igs_ca_inst.sequence_number%TYPE;
3088: l_acad_cal_type igs_ca_type.cal_type%TYPE;

Line 3325: FROM igs_pe_person_id_typ

3321: */
3322:
3323: CURSOR person_id_type_cur ( cp_pers_id_type VARCHAR2 ) IS
3324: SELECT person_id_type
3325: FROM igs_pe_person_id_typ
3326: WHERE s_person_id_type = cp_pers_id_type ;
3327:
3328: CURSOR cur_lookups (p_lkup_type igf_lookups_view.Lookup_type%TYPE,
3329: p_lkup_code igf_lookups_view.Lookup_code%TYPE) IS

Line 3339: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;

3335:
3336:
3337: l_pers_id_typ VARCHAR2(30) ;
3338: ln_person_number hz_parties.party_number%TYPE;
3339: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
3340: ln_msg_count NUMBER;
3341: lv_msg_data VARCHAR2(2000);
3342: lv_return_status VARCHAR2(1);
3343: lv_row_id VARCHAR2(30);

Line 3400: igs_pe_person_pkg.insert_row(

3396: SAVEPOINT person_SP1;
3397: lv_row_id := NULL;
3398: l_object_version_number := NULL;
3399:
3400: igs_pe_person_pkg.insert_row(
3401: x_MSG_COUNT => ln_msg_count,
3402: x_MSG_DATA => lv_msg_data,
3403: x_RETURN_STATUS => lv_return_status,
3404: x_ROWID => lv_row_id,

Line 3551: igs_pe_person_addr_pkg.insert_row(

3547:
3548: lv_row_id := NULL;
3549: ln_party_site_id := NULL;
3550:
3551: igs_pe_person_addr_pkg.insert_row(
3552: P_ACTION => 'R',
3553: P_ROWID => lv_row_id,
3554: P_LOCATION_ID => lv_location_id,
3555: P_START_DT => NULL,

Line 3903: ); -- igs_pe_person_pkg.insert_row();

3899: -- Creation of Person record for the unmatched record
3900: create_person_record(p_called_from => p_called_from,
3901: pn_person_id => lv_person_id, -- OUT parameter
3902: pv_mesg_data => p_msg_out -- OUT parameter
3903: ); -- igs_pe_person_pkg.insert_row();
3904:
3905:
3906: log_debug_message('Person Created.... ID= ' || lv_person_id);
3907: fnd_message.set_name('IGF','IGF_AP_SUCCESS_CREATE_PERSON');

Line 4512: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit

4508: hz.email_address email_address,
4509: hp.date_of_birth date_of_birth,
4510: hp.gender gender
4511: FROM ( SELECT apii.pe_person_id, apii.api_person_id_uf
4512: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit
4513: WHERE apii.person_id_type = pit.person_id_type
4514: AND pit.s_person_id_type = 'SSN'
4515: AND SYSDATE BETWEEN apii.start_dt AND NVL (apii.end_dt, SYSDATE)) api,
4516: hz_parties hz,

Line 7659: FROM igs_pe_person_id_typ

7655:
7656:
7657: CURSOR cur_format IS
7658: SELECT NVL(format_mask,'999999999')
7659: FROM igs_pe_person_id_typ
7660: WHERE s_person_id_type = 'SSN';
7661:
7662: l_formated_ssn VARCHAR2(30);
7663: cur NUMBER(15);

Line 8202: igs_pe_person_types pt

8198:
8199: CURSOR cur_ptyp_code IS
8200: SELECT COUNT(*)
8201: FROM igs_pe_typ_instances_all pti,
8202: igs_pe_person_types pt
8203: WHERE pti.person_id = p_person_id
8204: AND pti.person_type_code = pt.person_type_code
8205: AND SYSDATE BETWEEN pti.start_date and NVL(pti.end_date,SYSDATE)
8206: AND pt.system_type IN ('PROSPECT','APPLICANT','STUDENT')