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_PROFILE_MATCHING_PKG dependencies on IGF_AP_MATCH_DETAILS

Line 17: lv_record_status igf_ap_match_Details.record_status%TYPE;

13: g_bad_rec NUMBER(8) ;
14: g_duplicate_rec NUMBER(8);
15: g_record_inserted BOOLEAN ;
16: g_total_rvw NUMBER(8) ;
17: lv_record_status igf_ap_match_Details.record_status%TYPE;
18: g_force_add VARCHAR2(1);
19: g_create_inquiry VARCHAR2(1);
20: g_adm_source_type VARCHAR2(30);
21: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;

Line 623: p_match_dtls_rec igf_ap_match_details%ROWTYPE,

619: RETURN '-1';
620: END remove_spl_chr;
621:
622: PROCEDURE calculate_match_score(p_match_setup igf_ap_record_match%ROWTYPE,
623: p_match_dtls_rec igf_ap_match_details%ROWTYPE,
624: p_apm_id NUMBER,
625: p_person_id NUMBER)
626: IS
627: /*

Line 640: FROM igf_ap_match_details ad

636: */
637:
638: CURSOR chk_match_dtls_exists_cur(cp_apm_id NUMBER, cp_person_id NUMBER) IS
639: SELECT ROWID, ad.*
640: FROM igf_ap_match_details ad
641: WHERE apm_id = cp_apm_id
642: AND person_id = cp_person_id;
643:
644: rec_match_dtls chk_match_dtls_exists_cur%ROWTYPE;

Line 648: l_ssn_match igf_ap_match_details.ssn_match%TYPE;

644: rec_match_dtls chk_match_dtls_exists_cur%ROWTYPE;
645:
646: lv_rowid VARCHAR2(30);
647: lv_amd_id NUMBER;
648: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
649: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
650: l_surname_match igf_ap_match_details.surname_match%TYPE;
651: l_address_match igf_ap_match_details.address_match%TYPE;
652: l_city_match igf_ap_match_details.city_match%TYPE;

Line 649: l_given_name_match igf_ap_match_details.given_name_match%TYPE;

645:
646: lv_rowid VARCHAR2(30);
647: lv_amd_id NUMBER;
648: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
649: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
650: l_surname_match igf_ap_match_details.surname_match%TYPE;
651: l_address_match igf_ap_match_details.address_match%TYPE;
652: l_city_match igf_ap_match_details.city_match%TYPE;
653: l_zip_match igf_ap_match_details.zip_match%TYPE;

Line 650: l_surname_match igf_ap_match_details.surname_match%TYPE;

646: lv_rowid VARCHAR2(30);
647: lv_amd_id NUMBER;
648: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
649: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
650: l_surname_match igf_ap_match_details.surname_match%TYPE;
651: l_address_match igf_ap_match_details.address_match%TYPE;
652: l_city_match igf_ap_match_details.city_match%TYPE;
653: l_zip_match igf_ap_match_details.zip_match%TYPE;
654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;

Line 651: l_address_match igf_ap_match_details.address_match%TYPE;

647: lv_amd_id NUMBER;
648: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
649: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
650: l_surname_match igf_ap_match_details.surname_match%TYPE;
651: l_address_match igf_ap_match_details.address_match%TYPE;
652: l_city_match igf_ap_match_details.city_match%TYPE;
653: l_zip_match igf_ap_match_details.zip_match%TYPE;
654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
655: l_dob_match igf_ap_match_details.dob_match%TYPE;

Line 652: l_city_match igf_ap_match_details.city_match%TYPE;

648: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
649: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
650: l_surname_match igf_ap_match_details.surname_match%TYPE;
651: l_address_match igf_ap_match_details.address_match%TYPE;
652: l_city_match igf_ap_match_details.city_match%TYPE;
653: l_zip_match igf_ap_match_details.zip_match%TYPE;
654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
655: l_dob_match igf_ap_match_details.dob_match%TYPE;
656: l_gender_match igf_ap_match_details.gender_match%TYPE;

Line 653: l_zip_match igf_ap_match_details.zip_match%TYPE;

649: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
650: l_surname_match igf_ap_match_details.surname_match%TYPE;
651: l_address_match igf_ap_match_details.address_match%TYPE;
652: l_city_match igf_ap_match_details.city_match%TYPE;
653: l_zip_match igf_ap_match_details.zip_match%TYPE;
654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
655: l_dob_match igf_ap_match_details.dob_match%TYPE;
656: l_gender_match igf_ap_match_details.gender_match%TYPE;
657: l_match_score igf_ap_match_details.match_score%TYPE;

Line 654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;

650: l_surname_match igf_ap_match_details.surname_match%TYPE;
651: l_address_match igf_ap_match_details.address_match%TYPE;
652: l_city_match igf_ap_match_details.city_match%TYPE;
653: l_zip_match igf_ap_match_details.zip_match%TYPE;
654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
655: l_dob_match igf_ap_match_details.dob_match%TYPE;
656: l_gender_match igf_ap_match_details.gender_match%TYPE;
657: l_match_score igf_ap_match_details.match_score%TYPE;
658:

Line 655: l_dob_match igf_ap_match_details.dob_match%TYPE;

651: l_address_match igf_ap_match_details.address_match%TYPE;
652: l_city_match igf_ap_match_details.city_match%TYPE;
653: l_zip_match igf_ap_match_details.zip_match%TYPE;
654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
655: l_dob_match igf_ap_match_details.dob_match%TYPE;
656: l_gender_match igf_ap_match_details.gender_match%TYPE;
657: l_match_score igf_ap_match_details.match_score%TYPE;
658:
659: BEGIN

Line 656: l_gender_match igf_ap_match_details.gender_match%TYPE;

652: l_city_match igf_ap_match_details.city_match%TYPE;
653: l_zip_match igf_ap_match_details.zip_match%TYPE;
654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
655: l_dob_match igf_ap_match_details.dob_match%TYPE;
656: l_gender_match igf_ap_match_details.gender_match%TYPE;
657: l_match_score igf_ap_match_details.match_score%TYPE;
658:
659: BEGIN
660: -- =============== FIRST MATCH ATTRIBUTES ===============

Line 657: l_match_score igf_ap_match_details.match_score%TYPE;

653: l_zip_match igf_ap_match_details.zip_match%TYPE;
654: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
655: l_dob_match igf_ap_match_details.dob_match%TYPE;
656: l_gender_match igf_ap_match_details.gender_match%TYPE;
657: l_match_score igf_ap_match_details.match_score%TYPE;
658:
659: BEGIN
660: -- =============== FIRST MATCH ATTRIBUTES ===============
661:

Line 786: igf_ap_match_details_pkg.insert_row(

782: lv_rowid := NULL;
783:
784: -- insert a new match details rec
785:
786: igf_ap_match_details_pkg.insert_row(
787: x_mode => 'R',
788: x_rowid => lv_rowid,
789: x_amd_id => lv_amd_id,
790: x_apm_id => p_apm_id,

Line 817: igf_ap_match_details_pkg.update_row(

813:
814: ELSE
815: -- update existing rec
816:
817: igf_ap_match_details_pkg.update_row(
818: x_mode => 'R',
819: x_rowid => rec_match_dtls.rowid,
820: x_amd_id => rec_match_dtls.amd_id,
821: x_apm_id => rec_match_dtls.apm_id,

Line 2335: FUNCTION is_fa_base_record_present(pn_person_id igf_ap_match_details.person_id%TYPE,

2331: app_exception.raise_exception;
2332: END create_profile_matched;
2333:
2334:
2335: FUNCTION is_fa_base_record_present(pn_person_id igf_ap_match_details.person_id%TYPE,
2336: pn_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
2337: pn_sequence_number igf_ap_person_match_all.ci_sequence_number%TYPE,
2338: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
2339: )RETURN BOOLEAN IS

Line 3796: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE ,

3792: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec'|| SQLERRM);
3793: app_exception.raise_exception;
3794: END rvw_fa_rec ;
3795:
3796: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE ,
3797: p_apm_id igf_ap_person_match_all.apm_id%TYPE,
3798: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
3799: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE
3800: ) IS

Line 3956: match_details_rec igf_ap_match_details%ROWTYPE;

3952: t_dob_tab dobtab;
3953: t_gender gendertab;
3954: t_tot_match_score totmatchscoretab;
3955:
3956: match_details_rec igf_ap_match_details%ROWTYPE;
3957: lv_rowid VARCHAR2(30);
3958: lv_apm_id igf_ap_person_match.apm_id%TYPE;
3959: lv_ssn igf_ap_match_details.ssn_txt%TYPE;
3960: lv_fname igf_ap_match_details.given_name_txt%TYPE;

Line 3959: lv_ssn igf_ap_match_details.ssn_txt%TYPE;

3955:
3956: match_details_rec igf_ap_match_details%ROWTYPE;
3957: lv_rowid VARCHAR2(30);
3958: lv_apm_id igf_ap_person_match.apm_id%TYPE;
3959: lv_ssn igf_ap_match_details.ssn_txt%TYPE;
3960: lv_fname igf_ap_match_details.given_name_txt%TYPE;
3961: lv_lname igf_ap_match_details.sur_name_txt%TYPE;
3962: l_fname_exact_match VARCHAR2(1);
3963: l_lname_exact_match VARCHAR2(1);

Line 3960: lv_fname igf_ap_match_details.given_name_txt%TYPE;

3956: match_details_rec igf_ap_match_details%ROWTYPE;
3957: lv_rowid VARCHAR2(30);
3958: lv_apm_id igf_ap_person_match.apm_id%TYPE;
3959: lv_ssn igf_ap_match_details.ssn_txt%TYPE;
3960: lv_fname igf_ap_match_details.given_name_txt%TYPE;
3961: lv_lname igf_ap_match_details.sur_name_txt%TYPE;
3962: l_fname_exact_match VARCHAR2(1);
3963: l_lname_exact_match VARCHAR2(1);
3964: lv_tot NUMBER;

Line 3961: lv_lname igf_ap_match_details.sur_name_txt%TYPE;

3957: lv_rowid VARCHAR2(30);
3958: lv_apm_id igf_ap_person_match.apm_id%TYPE;
3959: lv_ssn igf_ap_match_details.ssn_txt%TYPE;
3960: lv_fname igf_ap_match_details.given_name_txt%TYPE;
3961: lv_lname igf_ap_match_details.sur_name_txt%TYPE;
3962: l_fname_exact_match VARCHAR2(1);
3963: l_lname_exact_match VARCHAR2(1);
3964: lv_tot NUMBER;
3965:

Line 3969: FROM igf_ap_match_details ad

3965:
3966: l_process_rec VARCHAR2(1);
3967: CURSOR check_oss_person_match(p_apm_id NUMBER, p_person_id NUMBER) IS
3968: SELECT 'Y'
3969: FROM igf_ap_match_details ad
3970: WHERE apm_id = p_apm_id
3971: AND person_id = p_person_id;
3972:
3973: oss_person_match_rec check_oss_person_match%ROWTYPE;

Line 4187: FROM igf_ap_match_details

4183: -- Cursor to get the person_id with highest match_score for a particulare apm_id
4184: CURSOR cur_get_max_data(cp_apm_id igf_ap_person_match.apm_id%TYPE) IS
4185: SELECT person_id,
4186: match_score
4187: FROM igf_ap_match_details
4188: WHERE apm_id = cp_apm_id
4189: ORDER BY match_score DESC;
4190:
4191: lv_person_id igf_ap_match_details.person_id%TYPE;

Line 4191: lv_person_id igf_ap_match_details.person_id%TYPE;

4187: FROM igf_ap_match_details
4188: WHERE apm_id = cp_apm_id
4189: ORDER BY match_score DESC;
4190:
4191: lv_person_id igf_ap_match_details.person_id%TYPE;
4192: ln_match_score igf_ap_match_details.match_score%TYPE;
4193: ln_apm_id igf_ap_match_details.apm_id%TYPE;
4194:
4195: BEGIN

Line 4192: ln_match_score igf_ap_match_details.match_score%TYPE;

4188: WHERE apm_id = cp_apm_id
4189: ORDER BY match_score DESC;
4190:
4191: lv_person_id igf_ap_match_details.person_id%TYPE;
4192: ln_match_score igf_ap_match_details.match_score%TYPE;
4193: ln_apm_id igf_ap_match_details.apm_id%TYPE;
4194:
4195: BEGIN
4196: -- Unidentified ISIR. Hence first need to perform person match.

Line 4193: ln_apm_id igf_ap_match_details.apm_id%TYPE;

4189: ORDER BY match_score DESC;
4190:
4191: lv_person_id igf_ap_match_details.person_id%TYPE;
4192: ln_match_score igf_ap_match_details.match_score%TYPE;
4193: ln_apm_id igf_ap_match_details.apm_id%TYPE;
4194:
4195: BEGIN
4196: -- Unidentified ISIR. Hence first need to perform person match.
4197: -- call procedure for performing person match.