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 IGF_AP_PERSON_MATCH

Line 1934: FROM igf_ap_person_match_all apm

1930: -- Person match
1931: CURSOR cur_person_match (cp_apm_id NUMBER) IS
1932: SELECT apm.rowid row_id,
1933: apm.*
1934: FROM igf_ap_person_match_all apm
1935: WHERE apm.apm_id = cp_apm_id
1936: FOR UPDATE NOWAIT;
1937:
1938: -- match details

Line 1953: igf_ap_person_match_pkg.update_row(

1949:
1950: FOR person_match_rec IN cur_person_match(p_apm_id) LOOP
1951:
1952: -- call the TBH to update the isir matched record
1953: igf_ap_person_match_pkg.update_row(
1954: x_rowid => person_match_rec.row_id ,
1955: x_apm_id => person_match_rec.apm_id ,
1956: x_css_id => person_match_rec.css_id ,
1957: x_si_id => person_match_rec.si_id ,

Line 2954: PROCEDURE delete_person_match_rec(p_si_id igf_ap_person_match_all.si_id%TYPE,

2950: app_exception.raise_exception;
2951: END validate_correction_school;
2952:
2953:
2954: PROCEDURE delete_person_match_rec(p_si_id igf_ap_person_match_all.si_id%TYPE,
2955: p_apm_id igf_ap_person_match_all.apm_id%TYPE)
2956: IS
2957: /*
2958: || Created By : rgangara

Line 2955: p_apm_id igf_ap_person_match_all.apm_id%TYPE)

2951: END validate_correction_school;
2952:
2953:
2954: PROCEDURE delete_person_match_rec(p_si_id igf_ap_person_match_all.si_id%TYPE,
2955: p_apm_id igf_ap_person_match_all.apm_id%TYPE)
2956: IS
2957: /*
2958: || Created By : rgangara
2959: || Created On : 06-AUG-2004

Line 2971: FROM igf_ap_person_match pm

2967:
2968: -- to get the apm ID based on si_id
2969: CURSOR cur_prsn_match_siid(cp_si_id NUMBER) IS
2970: SELECT pm.apm_id
2971: FROM igf_ap_person_match pm
2972: WHERE pm.si_id = cp_si_id;
2973:
2974: -- to get the row_id based on apm_id
2975: CURSOR cur_prsn_match_apm(cp_apm_id NUMBER) IS

Line 2977: FROM igf_ap_person_match pm

2973:
2974: -- to get the row_id based on apm_id
2975: CURSOR cur_prsn_match_apm(cp_apm_id NUMBER) IS
2976: SELECT pm.row_id, pm.apm_id
2977: FROM igf_ap_person_match pm
2978: WHERE pm.apm_id = cp_apm_id ;
2979:
2980:
2981: CURSOR cur_match_dtls(cp_apm_id igf_ap_person_match_all.apm_id%TYPE) IS

Line 2981: CURSOR cur_match_dtls(cp_apm_id igf_ap_person_match_all.apm_id%TYPE) IS

2977: FROM igf_ap_person_match pm
2978: WHERE pm.apm_id = cp_apm_id ;
2979:
2980:
2981: CURSOR cur_match_dtls(cp_apm_id igf_ap_person_match_all.apm_id%TYPE) IS
2982: SELECT amd.amd_id
2983: FROM igf_ap_match_details amd
2984: WHERE amd.apm_id = cp_apm_id;
2985:

Line 2986: l_apm_id igf_ap_person_match_all.apm_id%TYPE;

2982: SELECT amd.amd_id
2983: FROM igf_ap_match_details amd
2984: WHERE amd.apm_id = cp_apm_id;
2985:
2986: l_apm_id igf_ap_person_match_all.apm_id%TYPE;
2987: l_cnt_match_dtls NUMBER;
2988:
2989: BEGIN
2990:

Line 3031: igf_ap_person_match_pkg.delete_row(prsn_match_rec.row_id);

3027: END IF; -- l_cnt_match_dtls
3028:
3029:
3030: -- now call tbh of person match table to delete the record
3031: igf_ap_person_match_pkg.delete_row(prsn_match_rec.row_id);
3032: RAM_D_PM := RAM_D_PM + 1;
3033:
3034: log_debug_message(' Deleted Person Match record for APM ID : ' || l_apm_id);
3035: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3650: p_apm_id igf_ap_person_match_all.apm_id%TYPE,

3646:
3647:
3648:
3649: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE,
3650: p_apm_id igf_ap_person_match_all.apm_id%TYPE,
3651: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
3652: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE)
3653: IS
3654: /*

Line 3651: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,

3647:
3648:
3649: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE,
3650: p_apm_id igf_ap_person_match_all.apm_id%TYPE,
3651: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
3652: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE)
3653: IS
3654: /*
3655: || Created By : rgangara

Line 3652: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE)

3648:
3649: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE,
3650: p_apm_id igf_ap_person_match_all.apm_id%TYPE,
3651: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
3652: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE)
3653: IS
3654: /*
3655: || Created By : rgangara
3656: || Created On : 16-AUG-2004

Line 3820: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE ) IS

3816: app_exception.raise_exception;
3817: END auto_fa_rec;
3818:
3819:
3820: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE ) IS
3821: /*
3822: || Created By : rgangara
3823: || Created On : 16-AUG-2004
3824: || Purpose : Is called only after record matching is performed and the total match score >= auto fa review rec

Line 3839: -- call procedure to update the record_status of igf_ap_person_match and match details table

3835: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3836: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.debug','Review FA Rec processing for APM ID: ' || p_apm_id);
3837: END IF;
3838:
3839: -- call procedure to update the record_status of igf_ap_person_match and match details table
3840: update_prsn_match_rec_status(p_apm_id => p_apm_id,
3841: p_rec_status => 'REVIEW');
3842:
3843: -- call procedure to update the record_status of igf_ap_isir_ints to 'REVIEW'

Line 3869: PROCEDURE unmatched_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE,

3865: app_exception.raise_exception;
3866: END rvw_fa_rec ;
3867:
3868:
3869: PROCEDURE unmatched_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE,
3870: p_called_from VARCHAR2,
3871: p_msg_out OUT NOCOPY VARCHAR2)
3872: IS
3873: /*

Line 3996: -- call procedure to update the record_status of igf_ap_person_match and match details table

3992: ELSE -- lv_person_id
3993:
3994: g_person_id := NULL;
3995: log_debug_message(' Error Creating Person ');
3996: -- call procedure to update the record_status of igf_ap_person_match and match details table
3997: update_prsn_match_rec_status(p_apm_id => p_apm_id,
3998: p_rec_status => 'UNMATCHED');
3999:
4000: -- call procedure to update the ISIR Int record_status to 'UNMATCHED'

Line 4379: PROCEDURE perform_record_matching (p_apm_id igf_ap_person_match_all.apm_id%TYPE)

4375: END calculate_match_score;
4376:
4377:
4378:
4379: PROCEDURE perform_record_matching (p_apm_id igf_ap_person_match_all.apm_id%TYPE)
4380: IS
4381: /*
4382: || Created By : rgangara
4383: || Created On : 09-Aug-2004

Line 4677: FROM igf_ap_person_match

4673:
4674: -- check for person match rec before inserting
4675: CURSOR cur_prsn_match (cp_si_id NUMBER) IS
4676: SELECT *
4677: FROM igf_ap_person_match
4678: WHERE si_id = cp_si_id;
4679:
4680: person_match_rec cur_prsn_match%ROWTYPE;
4681:

Line 4683: CURSOR cur_get_max_data(cp_apm_id igf_ap_person_match.apm_id%TYPE) IS

4679:
4680: person_match_rec cur_prsn_match%ROWTYPE;
4681:
4682: -- Cursor to get the person_id with highest match_score for a particulare apm_id
4683: CURSOR cur_get_max_data(cp_apm_id igf_ap_person_match.apm_id%TYPE) IS
4684: SELECT person_id,
4685: match_score
4686: FROM igf_ap_match_details
4687: WHERE apm_id = cp_apm_id

Line 4730: -- Inserting new student record into igf_ap_person_match table.

4726: FETCH cur_prsn_match INTO person_match_rec;
4727:
4728: IF cur_prsn_match%NOTFOUND THEN
4729: CLOSE cur_prsn_match ;
4730: -- Inserting new student record into igf_ap_person_match table.
4731: lv_rowid := NULL;
4732: igf_ap_person_match_pkg.insert_row(
4733: x_rowid => lv_rowid ,
4734: x_apm_id => ln_apm_id,

Line 4732: igf_ap_person_match_pkg.insert_row(

4728: IF cur_prsn_match%NOTFOUND THEN
4729: CLOSE cur_prsn_match ;
4730: -- Inserting new student record into igf_ap_person_match table.
4731: lv_rowid := NULL;
4732: igf_ap_person_match_pkg.insert_row(
4733: x_rowid => lv_rowid ,
4734: x_apm_id => ln_apm_id,
4735: x_css_id => NULL,
4736: x_si_id => g_isir_intrface_rec.si_id ,

Line 4753: igf_ap_person_match_pkg.update_row(

4749:
4750: ELSE
4751: CLOSE cur_prsn_match;
4752: -- record already exists??. Update the record.
4753: igf_ap_person_match_pkg.update_row(
4754: x_rowid => person_match_rec.row_id ,
4755: x_apm_id => person_match_rec.apm_id,
4756: x_css_id => person_match_rec.css_id,
4757: x_si_id => person_match_rec.si_id ,

Line 4864: -- call procedure to update the record_status of igf_ap_person_match and match details table

4860:
4861: ELSE -- i.e. g_force_add = 'N'
4862:
4863: log_debug_message(' Force ADD = N. Hence updating the status to Unmatched');
4864: -- call procedure to update the record_status of igf_ap_person_match and match details table
4865: update_prsn_match_rec_status(p_apm_id => ln_apm_id,
4866: p_rec_status => 'UNMATCHED');
4867:
4868: -- call procedure to update the ISIR Int record_status to 'UNMATCHED'

Line 7455: lv_apm_id igf_ap_person_match.apm_id%TYPE := NULL;

7451: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
7452: || (reverse chronological order - newest change first)
7453: */
7454:
7455: lv_apm_id igf_ap_person_match.apm_id%TYPE := NULL;
7456:
7457: CURSOR cur_batch_aw_map(cp_batch_yr NUMBER) IS
7458: SELECT ci_cal_type,ci_sequence_number
7459: FROM igf_ap_batch_aw_map

Line 8264: FROM igf_ap_person_match

8260: award_year_dtl_rec cur_award_year_dtl%ROWTYPE;
8261:
8262: CURSOR get_prsn_match_cur (cp_si_id IN NUMBER) IS
8263: SELECT *
8264: FROM igf_ap_person_match
8265: WHERE si_id = cp_si_id;
8266:
8267: person_match_rec get_prsn_match_cur%ROWTYPE;
8268:

Line 8323: igf_ap_person_match_pkg.insert_row(

8319:
8320: ln_apm_id := NULL;
8321: lv_rowid := NULL;
8322: log_debug_message('Inserting a record intp person match table');
8323: igf_ap_person_match_pkg.insert_row(
8324: x_rowid => lv_rowid ,
8325: x_apm_id => ln_apm_id,
8326: x_css_id => NULL,
8327: x_si_id => g_isir_intrface_rec.si_id ,

Line 8408: FROM igf_ap_person_match

8404: CURSOR get_person_match_cur (cp_si_id IN NUMBER) IS
8405: SELECT apm_id,
8406: ci_cal_type,
8407: ci_sequence_number
8408: FROM igf_ap_person_match
8409: WHERE si_id = cp_si_id;
8410:
8411: -- Added cp_batch_year as a part of Bug Fix 4241350
8412: CURSOR cur_base_id_rec(cp_person_id NUMBER, cp_batch_year NUMBER) IS

Line 8577: FROM igf_ap_person_match

8573:
8574:
8575: CURSOR get_person_match_cur (cp_si_id IN NUMBER) IS
8576: SELECT *
8577: FROM igf_ap_person_match
8578: WHERE si_id = cp_si_id;
8579:
8580: person_match_rec get_person_match_cur%ROWTYPE;
8581: