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_MATCH_DETAILS

Line 45: TYPE match_details_amd_id IS TABLE OF igf_ap_match_details.amd_id%TYPE;

41: g_debug_seq NUMBER:=0; --- #R1 Remove after debugging
42: g_old_active_isir_id igf_ap_isir_matched_all.isir_id%TYPE; -- bbb
43:
44: -- pl/sql table def for deleting from match details using BULK operation.
45: TYPE match_details_amd_id IS TABLE OF igf_ap_match_details.amd_id%TYPE;
46: g_amd_id_tab match_details_amd_id;
47:
48: CURSOR cur_setup_score (cp_match_code igf_ap_record_match_all.match_code%TYPE) IS
49: SELECT *

Line 1942: FROM igf_ap_match_details amd

1938: -- match details
1939: CURSOR match_details_cur (cp_apm_id NUMBER) IS
1940: SELECT amd.rowid row_id,
1941: amd.*
1942: FROM igf_ap_match_details amd
1943: WHERE amd.apm_id = cp_apm_id
1944: FOR UPDATE NOWAIT;
1945:
1946: BEGIN

Line 1975: igf_ap_match_details_pkg.update_row(

1971: -- update record status for corresponding match detail records
1972: FOR match_details_rec IN match_details_cur(person_match_rec.apm_id) LOOP
1973:
1974: -- call TBH for updating corresp recs.
1975: igf_ap_match_details_pkg.update_row(
1976: x_mode => 'R',
1977: x_rowid => match_details_rec.row_id,
1978: x_amd_id => match_details_rec.amd_id,
1979: x_apm_id => match_details_rec.apm_id,

Line 2983: FROM igf_ap_match_details amd

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:
2986: l_apm_id igf_ap_person_match_all.apm_id%TYPE;
2987: l_cnt_match_dtls NUMBER;

Line 3019: DELETE FROM igf_ap_match_details

3015: IF l_cnt_match_dtls > 0 THEN
3016: -- i.e. corresp apm id recs exist in match details.
3017: -- delete them using using bulk delete option
3018: FORALL k IN 1..l_cnt_match_dtls
3019: DELETE FROM igf_ap_match_details
3020: WHERE amd_id = g_amd_id_tab(k);
3021:
3022: log_debug_message(' Deleted Match Details records for APM ID : ' || l_apm_id);
3023: RAM_D_MD := RAM_D_MD + 1;

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

3645:
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

Line 4033: p_match_dtls_rec igf_ap_match_details%ROWTYPE,

4029:
4030:
4031: PROCEDURE calculate_match_score(p_isir_rec igf_ap_isir_ints%ROWTYPE,
4032: p_match_setup igf_ap_record_match%ROWTYPE,
4033: p_match_dtls_rec igf_ap_match_details%ROWTYPE,
4034: p_apm_id NUMBER,
4035: p_person_id NUMBER)
4036: IS
4037: /*

Line 4061: FROM igf_ap_match_details ad

4057:
4058:
4059: CURSOR chk_match_dtls_exists_cur(cp_apm_id NUMBER, cp_person_id NUMBER) IS
4060: SELECT ad.rowid row_id, ad.*
4061: FROM igf_ap_match_details ad
4062: WHERE apm_id = cp_apm_id
4063: AND person_id = cp_person_id;
4064:
4065: chk_match_dtls_exists_rec chk_match_dtls_exists_cur%ROWTYPE;

Line 4067: l_ssn_match igf_ap_match_details.ssn_match%TYPE;

4063: AND person_id = cp_person_id;
4064:
4065: chk_match_dtls_exists_rec chk_match_dtls_exists_cur%ROWTYPE;
4066:
4067: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
4068: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
4069: l_surname_match igf_ap_match_details.surname_match%TYPE;
4070: l_address_match igf_ap_match_details.address_match%TYPE;
4071: l_city_match igf_ap_match_details.city_match%TYPE;

Line 4068: l_given_name_match igf_ap_match_details.given_name_match%TYPE;

4064:
4065: chk_match_dtls_exists_rec chk_match_dtls_exists_cur%ROWTYPE;
4066:
4067: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
4068: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
4069: l_surname_match igf_ap_match_details.surname_match%TYPE;
4070: l_address_match igf_ap_match_details.address_match%TYPE;
4071: l_city_match igf_ap_match_details.city_match%TYPE;
4072: l_zip_match igf_ap_match_details.zip_match%TYPE;

Line 4069: l_surname_match igf_ap_match_details.surname_match%TYPE;

4065: chk_match_dtls_exists_rec chk_match_dtls_exists_cur%ROWTYPE;
4066:
4067: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
4068: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
4069: l_surname_match igf_ap_match_details.surname_match%TYPE;
4070: l_address_match igf_ap_match_details.address_match%TYPE;
4071: l_city_match igf_ap_match_details.city_match%TYPE;
4072: l_zip_match igf_ap_match_details.zip_match%TYPE;
4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;

Line 4070: l_address_match igf_ap_match_details.address_match%TYPE;

4066:
4067: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
4068: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
4069: l_surname_match igf_ap_match_details.surname_match%TYPE;
4070: l_address_match igf_ap_match_details.address_match%TYPE;
4071: l_city_match igf_ap_match_details.city_match%TYPE;
4072: l_zip_match igf_ap_match_details.zip_match%TYPE;
4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
4074: l_dob_match igf_ap_match_details.dob_match%TYPE;

Line 4071: l_city_match igf_ap_match_details.city_match%TYPE;

4067: l_ssn_match igf_ap_match_details.ssn_match%TYPE;
4068: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
4069: l_surname_match igf_ap_match_details.surname_match%TYPE;
4070: l_address_match igf_ap_match_details.address_match%TYPE;
4071: l_city_match igf_ap_match_details.city_match%TYPE;
4072: l_zip_match igf_ap_match_details.zip_match%TYPE;
4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
4074: l_dob_match igf_ap_match_details.dob_match%TYPE;
4075: l_gender_match igf_ap_match_details.gender_match%TYPE;

Line 4072: l_zip_match igf_ap_match_details.zip_match%TYPE;

4068: l_given_name_match igf_ap_match_details.given_name_match%TYPE;
4069: l_surname_match igf_ap_match_details.surname_match%TYPE;
4070: l_address_match igf_ap_match_details.address_match%TYPE;
4071: l_city_match igf_ap_match_details.city_match%TYPE;
4072: l_zip_match igf_ap_match_details.zip_match%TYPE;
4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
4074: l_dob_match igf_ap_match_details.dob_match%TYPE;
4075: l_gender_match igf_ap_match_details.gender_match%TYPE;
4076: l_match_score igf_ap_match_details.match_score%TYPE;

Line 4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;

4069: l_surname_match igf_ap_match_details.surname_match%TYPE;
4070: l_address_match igf_ap_match_details.address_match%TYPE;
4071: l_city_match igf_ap_match_details.city_match%TYPE;
4072: l_zip_match igf_ap_match_details.zip_match%TYPE;
4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
4074: l_dob_match igf_ap_match_details.dob_match%TYPE;
4075: l_gender_match igf_ap_match_details.gender_match%TYPE;
4076: l_match_score igf_ap_match_details.match_score%TYPE;
4077:

Line 4074: l_dob_match igf_ap_match_details.dob_match%TYPE;

4070: l_address_match igf_ap_match_details.address_match%TYPE;
4071: l_city_match igf_ap_match_details.city_match%TYPE;
4072: l_zip_match igf_ap_match_details.zip_match%TYPE;
4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
4074: l_dob_match igf_ap_match_details.dob_match%TYPE;
4075: l_gender_match igf_ap_match_details.gender_match%TYPE;
4076: l_match_score igf_ap_match_details.match_score%TYPE;
4077:
4078: l_primary_match_score NUMBER;

Line 4075: l_gender_match igf_ap_match_details.gender_match%TYPE;

4071: l_city_match igf_ap_match_details.city_match%TYPE;
4072: l_zip_match igf_ap_match_details.zip_match%TYPE;
4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
4074: l_dob_match igf_ap_match_details.dob_match%TYPE;
4075: l_gender_match igf_ap_match_details.gender_match%TYPE;
4076: l_match_score igf_ap_match_details.match_score%TYPE;
4077:
4078: l_primary_match_score NUMBER;
4079:

Line 4076: l_match_score igf_ap_match_details.match_score%TYPE;

4072: l_zip_match igf_ap_match_details.zip_match%TYPE;
4073: l_email_id_match igf_ap_match_details.email_id_match%TYPE;
4074: l_dob_match igf_ap_match_details.dob_match%TYPE;
4075: l_gender_match igf_ap_match_details.gender_match%TYPE;
4076: l_match_score igf_ap_match_details.match_score%TYPE;
4077:
4078: l_primary_match_score NUMBER;
4079:
4080: BEGIN

Line 4286: igf_ap_match_details_pkg.insert_row(

4282: IF chk_match_dtls_exists_rec.row_id IS NULL THEN
4283:
4284: log_debug_message(' INSERTING Match Details record .... : ');
4285: -- insert a new match details rec
4286: igf_ap_match_details_pkg.insert_row(
4287: x_mode => 'R',
4288: x_rowid => chk_match_dtls_exists_rec.row_id,
4289: x_amd_id => chk_match_dtls_exists_rec.amd_id,
4290: x_apm_id => p_apm_id,

Line 4329: igf_ap_match_details_pkg.update_row(

4325: -- for SSN, first name and last name from OSS.
4326: -- 2nd part of the query returns matches based on SSN from HRMS (This is the only possibility of being in update mode)
4327:
4328: -- update existing rec
4329: igf_ap_match_details_pkg.update_row(
4330: x_mode => 'R',
4331: x_rowid => chk_match_dtls_exists_rec.row_id ,
4332: x_amd_id => chk_match_dtls_exists_rec.amd_id ,
4333: x_apm_id => chk_match_dtls_exists_rec.apm_id ,

Line 4420: match_details_rec igf_ap_match_details%ROWTYPE;

4416: t_dob_tab dobtab;
4417: t_gender gendertab;
4418: t_tot_match_score totmatchscoretab;
4419:
4420: match_details_rec igf_ap_match_details%ROWTYPE;
4421:
4422: CURSOR check_oss_person_match(p_apm_id NUMBER, p_person_id NUMBER) IS
4423: SELECT ssn_txt
4424: FROM igf_ap_match_details ad

Line 4424: FROM igf_ap_match_details ad

4420: match_details_rec igf_ap_match_details%ROWTYPE;
4421:
4422: CURSOR check_oss_person_match(p_apm_id NUMBER, p_person_id NUMBER) IS
4423: SELECT ssn_txt
4424: FROM igf_ap_match_details ad
4425: WHERE apm_id = p_apm_id
4426: AND person_id = p_person_id;
4427:
4428: oss_person_match_rec check_oss_person_match%ROWTYPE;

Line 4430: lv_ssn igf_ap_match_details.ssn_txt%TYPE;

4426: AND person_id = p_person_id;
4427:
4428: oss_person_match_rec check_oss_person_match%ROWTYPE;
4429:
4430: lv_ssn igf_ap_match_details.ssn_txt%TYPE;
4431: lv_fname igf_ap_match_details.given_name_txt%TYPE;
4432: lv_lname igf_ap_match_details.sur_name_txt%TYPE;
4433: l_fname_exact_match VARCHAR2(1);
4434: l_lname_exact_match VARCHAR2(1);

Line 4431: lv_fname igf_ap_match_details.given_name_txt%TYPE;

4427:
4428: oss_person_match_rec check_oss_person_match%ROWTYPE;
4429:
4430: lv_ssn igf_ap_match_details.ssn_txt%TYPE;
4431: lv_fname igf_ap_match_details.given_name_txt%TYPE;
4432: lv_lname igf_ap_match_details.sur_name_txt%TYPE;
4433: l_fname_exact_match VARCHAR2(1);
4434: l_lname_exact_match VARCHAR2(1);
4435: l_process_rec VARCHAR2(1);

Line 4432: lv_lname igf_ap_match_details.sur_name_txt%TYPE;

4428: oss_person_match_rec check_oss_person_match%ROWTYPE;
4429:
4430: lv_ssn igf_ap_match_details.ssn_txt%TYPE;
4431: lv_fname igf_ap_match_details.given_name_txt%TYPE;
4432: lv_lname igf_ap_match_details.sur_name_txt%TYPE;
4433: l_fname_exact_match VARCHAR2(1);
4434: l_lname_exact_match VARCHAR2(1);
4435: l_process_rec VARCHAR2(1);
4436: lv_tot NUMBER;

Line 4686: FROM igf_ap_match_details

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
4688: ORDER BY match_score DESC;
4689:
4690: CURSOR c_base_id(p_person_id NUMBER,

Line 4711: lv_person_id igf_ap_match_details.person_id%TYPE;

4707:
4708: l_chk_isir_exist chk_isir_exist%ROWTYPE;
4709:
4710: lv_rowid VARCHAR2(30);
4711: lv_person_id igf_ap_match_details.person_id%TYPE;
4712: ln_match_score igf_ap_match_details.match_score%TYPE;
4713: ln_apm_id igf_ap_match_details.apm_id%TYPE;
4714: lv_msg_out VARCHAR2(2000);
4715:

Line 4712: ln_match_score igf_ap_match_details.match_score%TYPE;

4708: l_chk_isir_exist chk_isir_exist%ROWTYPE;
4709:
4710: lv_rowid VARCHAR2(30);
4711: lv_person_id igf_ap_match_details.person_id%TYPE;
4712: ln_match_score igf_ap_match_details.match_score%TYPE;
4713: ln_apm_id igf_ap_match_details.apm_id%TYPE;
4714: lv_msg_out VARCHAR2(2000);
4715:
4716: BEGIN

Line 4713: ln_apm_id igf_ap_match_details.apm_id%TYPE;

4709:
4710: lv_rowid VARCHAR2(30);
4711: lv_person_id igf_ap_match_details.person_id%TYPE;
4712: ln_match_score igf_ap_match_details.match_score%TYPE;
4713: ln_apm_id igf_ap_match_details.apm_id%TYPE;
4714: lv_msg_out VARCHAR2(2000);
4715:
4716: BEGIN
4717:

Line 8272: FROM igf_ap_match_details md

8268:
8269: -- for deleting recs
8270: CURSOR get_match_details_cur (cp_apm_id IN NUMBER) IS
8271: SELECT md.rowid row_id
8272: FROM igf_ap_match_details md
8273: WHERE apm_id = cp_apm_id;
8274: lv_rowid VARCHAR2(30);
8275: ln_apm_id igf_ap_match_details.apm_id%TYPE;
8276: BEGIN

Line 8275: ln_apm_id igf_ap_match_details.apm_id%TYPE;

8271: SELECT md.rowid row_id
8272: FROM igf_ap_match_details md
8273: WHERE apm_id = cp_apm_id;
8274: lv_rowid VARCHAR2(30);
8275: ln_apm_id igf_ap_match_details.apm_id%TYPE;
8276: BEGIN
8277: g_enable_debug_logging := 'N';
8278: -- get Int rec details
8279: OPEN cur_isir_intrface (p_si_id);

Line 8348: igf_ap_match_details_pkg.delete_row(match_details_rec.row_id);

8344:
8345: -- delete existing match details record for the apm_id
8346: FOR match_details_rec IN get_match_details_cur (person_match_rec.apm_id)
8347: LOOP
8348: igf_ap_match_details_pkg.delete_row(match_details_rec.row_id);
8349: END LOOP;
8350:
8351: ln_apm_id := person_match_rec.apm_id;
8352:

Line 8382: p_person_id IN igf_ap_match_details.person_id%TYPE,

8378: END wrpr_refresh_matches;
8379:
8380: -- Added p_award_yr as a part of Bug Fix 4241350
8381: PROCEDURE wrpr_auto_fa_rec(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,
8382: p_person_id IN igf_ap_match_details.person_id%TYPE,
8383: p_batch_year IN igf_ap_isir_matched.batch_year%TYPE,
8384: p_return_status OUT NOCOPY VARCHAR2,
8385: p_message_out OUT NOCOPY VARCHAR2)
8386: IS