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.

[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGF_AP_PERSON_MATCH

Line 2336: pn_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,

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

Line 2337: pn_sequence_number igf_ap_person_match_all.ci_sequence_number%TYPE,

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
2340:
2341: /*

Line 3348: PROCEDURE update_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE,

3344: log_debug_message('IGF_AP_MATCH_PROFILE_PK.create_admission_rec'|| SQLERRM);
3345: END create_admission_rec;
3346:
3347:
3348: PROCEDURE update_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE,
3349: pv_record_status igf_ap_person_match.record_status%TYPE
3350: ) IS
3351:
3352: /*

Line 3349: pv_record_status igf_ap_person_match.record_status%TYPE

3345: END create_admission_rec;
3346:
3347:
3348: PROCEDURE update_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE,
3349: pv_record_status igf_ap_person_match.record_status%TYPE
3350: ) IS
3351:
3352: /*
3353: || Created By : Meghana

Line 3366: CURSOR cur_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE) IS

3362: ln_org_id NUMBER ;
3363: retcode NUMBER;
3364: errbuf VARCHAR2(300);
3365:
3366: CURSOR cur_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE) IS
3367: SELECT apm.*
3368: FROM igf_ap_person_match apm
3369: WHERE apm.apm_id = pn_apm_id FOR UPDATE NOWAIT ;
3370:

Line 3368: FROM igf_ap_person_match apm

3364: errbuf VARCHAR2(300);
3365:
3366: CURSOR cur_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE) IS
3367: SELECT apm.*
3368: FROM igf_ap_person_match apm
3369: WHERE apm.apm_id = pn_apm_id FOR UPDATE NOWAIT ;
3370:
3371:
3372: BEGIN

Line 3378: igf_ap_person_match_pkg.update_row(

3374: -- Update record _status
3375: FOR person_data IN cur_person_match(pn_apm_id)
3376: LOOP
3377:
3378: igf_ap_person_match_pkg.update_row(
3379: x_rowid => person_data.row_id ,
3380: x_apm_id => pn_apm_id ,
3381: x_css_id => person_data.css_id ,
3382: x_si_id => person_data.si_id ,

Line 3565: PROCEDURE unmatched_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE) IS

3561: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:'||SQLERRM );
3562: app_exception.raise_exception;
3563: END update_fa_base_rec ;
3564:
3565: PROCEDURE unmatched_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE) IS
3566: /*
3567: || Created By : vivuyyur
3568: || Created On : 11-JUN-2000
3569: || Purpose : To create fa_base_rec ,person_record,admission record for the unmatched record

Line 3584: -- Cursor to update the record_status of igf_ap_person_match to unmatched

3580: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
3581: lv_mesg_data VARCHAR2(2000);
3582:
3583:
3584: -- Cursor to update the record_status of igf_ap_person_match to unmatched
3585: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3586: SELECT apm.*
3587: FROM igf_ap_person_match apm
3588: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;

Line 3585: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS

3581: lv_mesg_data VARCHAR2(2000);
3582:
3583:
3584: -- Cursor to update the record_status of igf_ap_person_match to unmatched
3585: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3586: SELECT apm.*
3587: FROM igf_ap_person_match apm
3588: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3589:

Line 3587: FROM igf_ap_person_match apm

3583:
3584: -- Cursor to update the record_status of igf_ap_person_match to unmatched
3585: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3586: SELECT apm.*
3587: FROM igf_ap_person_match apm
3588: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3589:
3590: BEGIN
3591: -- here the profile check needs to be added

Line 3640: -- procedure to update the record_status of igf_ap_person_match to 'MATCHED'

3636: ) ;
3637:
3638: --Opening the cursor to update the record_status field to MATCHED
3639: FOR person_data IN cur_person_match(p_apm_id) LOOP
3640: -- procedure to update the record_status of igf_ap_person_match to 'MATCHED'
3641: igf_ap_person_match_pkg.update_row(
3642: x_rowid => person_data.row_id ,
3643: x_apm_id => person_data.apm_id ,
3644: x_css_id => person_data.css_id ,

Line 3641: igf_ap_person_match_pkg.update_row(

3637:
3638: --Opening the cursor to update the record_status field to MATCHED
3639: FOR person_data IN cur_person_match(p_apm_id) LOOP
3640: -- procedure to update the record_status of igf_ap_person_match to 'MATCHED'
3641: igf_ap_person_match_pkg.update_row(
3642: x_rowid => person_data.row_id ,
3643: x_apm_id => person_data.apm_id ,
3644: x_css_id => person_data.css_id ,
3645: x_si_id => person_data.si_id ,

Line 3668: -- procedure to update the record_status of igf_ap_person_match to 'UNMATCHED'

3664:
3665: ELSE
3666: --Opening the cursor to update the record_status field to UNMATCHED
3667: FOR person_data IN cur_person_match(p_apm_id) LOOP
3668: -- procedure to update the record_status of igf_ap_person_match to 'UNMATCHED'
3669: igf_ap_person_match_pkg.update_row(
3670: x_rowid => person_data.row_id ,
3671: x_apm_id => person_data.apm_id ,
3672: x_css_id => person_data.css_id ,

Line 3669: igf_ap_person_match_pkg.update_row(

3665: ELSE
3666: --Opening the cursor to update the record_status field to UNMATCHED
3667: FOR person_data IN cur_person_match(p_apm_id) LOOP
3668: -- procedure to update the record_status of igf_ap_person_match to 'UNMATCHED'
3669: igf_ap_person_match_pkg.update_row(
3670: x_rowid => person_data.row_id ,
3671: x_apm_id => person_data.apm_id ,
3672: x_css_id => person_data.css_id ,
3673: x_si_id => person_data.si_id ,

Line 3694: -- procedure to update the record_status of igf_ap_person_match to 'UNMATCHED'

3690:
3691: --Opening the cursor to update the record_status field to UNMATCHED
3692: FOR person_data IN cur_person_match(p_apm_id)
3693: LOOP
3694: -- procedure to update the record_status of igf_ap_person_match to 'UNMATCHED'
3695: igf_ap_person_match_pkg.update_row(
3696: x_rowid => person_data.row_id ,
3697: x_apm_id => person_data.apm_id ,
3698: x_css_id => person_data.css_id ,

Line 3695: igf_ap_person_match_pkg.update_row(

3691: --Opening the cursor to update the record_status field to UNMATCHED
3692: FOR person_data IN cur_person_match(p_apm_id)
3693: LOOP
3694: -- procedure to update the record_status of igf_ap_person_match to 'UNMATCHED'
3695: igf_ap_person_match_pkg.update_row(
3696: x_rowid => person_data.row_id ,
3697: x_apm_id => person_data.apm_id ,
3698: x_css_id => person_data.css_id ,
3699: x_si_id => person_data.si_id ,

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

3730: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);
3731: app_exception.raise_exception;
3732: END unmatched_rec ;
3733:
3734: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE ) IS
3735: /*
3736: || Created By : vivuyyur
3737: || Created On : 11-JUN-2000
3738: || Purpose : To update the record_status of igf_ap_person_match,igf_ap_css_interface to review

Line 3738: || Purpose : To update the record_status of igf_ap_person_match,igf_ap_css_interface to review

3734: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE ) IS
3735: /*
3736: || Created By : vivuyyur
3737: || Created On : 11-JUN-2000
3738: || Purpose : To update the record_status of igf_ap_person_match,igf_ap_css_interface to review
3739: || Known limitations, enhancements or remarks :
3740: || Change History :
3741: || Who When What
3742: || (reverse chronological order - newest change first)

Line 3745: person_data igf_ap_person_match%ROWTYPE ;

3741: || Who When What
3742: || (reverse chronological order - newest change first)
3743: */
3744:
3745: person_data igf_ap_person_match%ROWTYPE ;
3746:
3747: -- Cursor to update the record_status of igf_ap_person_match to review
3748: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3749: SELECT apm.*

Line 3747: -- Cursor to update the record_status of igf_ap_person_match to review

3743: */
3744:
3745: person_data igf_ap_person_match%ROWTYPE ;
3746:
3747: -- Cursor to update the record_status of igf_ap_person_match to review
3748: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3749: SELECT apm.*
3750: FROM igf_ap_person_match apm
3751: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;

Line 3748: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS

3744:
3745: person_data igf_ap_person_match%ROWTYPE ;
3746:
3747: -- Cursor to update the record_status of igf_ap_person_match to review
3748: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3749: SELECT apm.*
3750: FROM igf_ap_person_match apm
3751: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3752:

Line 3750: FROM igf_ap_person_match apm

3746:
3747: -- Cursor to update the record_status of igf_ap_person_match to review
3748: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3749: SELECT apm.*
3750: FROM igf_ap_person_match apm
3751: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3752:
3753: BEGIN
3754: FOR person_data IN cur_person_match(p_apm_id)

Line 3757: --Procedure to update the record_status of igf_ap_person_match to review

3753: BEGIN
3754: FOR person_data IN cur_person_match(p_apm_id)
3755: LOOP
3756:
3757: --Procedure to update the record_status of igf_ap_person_match to review
3758: igf_ap_person_match_pkg.update_row(
3759: x_rowid => person_data.row_id ,
3760: x_apm_id => person_data.apm_id ,
3761: x_css_id => person_data.css_id ,

Line 3758: igf_ap_person_match_pkg.update_row(

3754: FOR person_data IN cur_person_match(p_apm_id)
3755: LOOP
3756:
3757: --Procedure to update the record_status of igf_ap_person_match to review
3758: igf_ap_person_match_pkg.update_row(
3759: x_rowid => person_data.row_id ,
3760: x_apm_id => person_data.apm_id ,
3761: x_css_id => person_data.css_id ,
3762: x_si_id => person_data.si_id ,

Line 3797: p_apm_id igf_ap_person_match_all.apm_id%TYPE,

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

Line 3798: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,

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
3801:
3802: /*

Line 3799: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE

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
3801:
3802: /*
3803: || Created By : vivuyyur

Line 3812: person_data igf_ap_person_match%ROWTYPE;

3808: || Who When What
3809: || (reverse chronological order - newest change first)
3810: */
3811:
3812: person_data igf_ap_person_match%ROWTYPE;
3813: css_profile_data igf_ap_css_profile%ROWTYPE ;
3814: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
3815: fabase_data igf_ap_fa_base_rec%ROWTYPE ;
3816: lv_base_id igf_ap_css_profile.base_id%TYPE ;

Line 3820: -- Cursor to update the record_status of igf_ap_person_match to matched

3816: lv_base_id igf_ap_css_profile.base_id%TYPE ;
3817: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
3818: fa_base_found BOOLEAN ;
3819:
3820: -- Cursor to update the record_status of igf_ap_person_match to matched
3821: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3822: SELECT apm.*
3823: FROM igf_ap_person_match apm
3824: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;

Line 3821: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS

3817: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
3818: fa_base_found BOOLEAN ;
3819:
3820: -- Cursor to update the record_status of igf_ap_person_match to matched
3821: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3822: SELECT apm.*
3823: FROM igf_ap_person_match apm
3824: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3825:

Line 3823: FROM igf_ap_person_match apm

3819:
3820: -- Cursor to update the record_status of igf_ap_person_match to matched
3821: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
3822: SELECT apm.*
3823: FROM igf_ap_person_match apm
3824: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
3825:
3826: -- cursor to update the profile_status, profile_fc of igf_ap_fa_base_rec
3827: CURSOR cur_fabase(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

Line 3916: PROCEDURE perform_record_matching(p_out_apm_id OUT NOCOPY igf_ap_person_match_all.apm_id%TYPE)

3912: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec'|| SQLERRM);
3913: app_exception.raise_exception;
3914: END auto_fa_rec ;
3915:
3916: PROCEDURE perform_record_matching(p_out_apm_id OUT NOCOPY igf_ap_person_match_all.apm_id%TYPE)
3917: IS
3918: /*
3919: || Created By : rasahoo
3920: || Created On : 24-AUG-2004

Line 3958: lv_apm_id igf_ap_person_match.apm_id%TYPE;

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;
3961: lv_lname igf_ap_match_details.sur_name_txt%TYPE;
3962: l_fname_exact_match VARCHAR2(1);

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

3979: WHEN others THEN
3980: NULL;
3981: END;
3982:
3983: -- Inserting new student record into igf_ap_person_match table.
3984: lv_rowid := NULL;
3985: igf_ap_person_match_pkg.insert_row(
3986: x_rowid => lv_rowid ,
3987: x_apm_id => p_out_apm_id,

Line 3985: igf_ap_person_match_pkg.insert_row(

3981: END;
3982:
3983: -- Inserting new student record into igf_ap_person_match table.
3984: lv_rowid := NULL;
3985: igf_ap_person_match_pkg.insert_row(
3986: x_rowid => lv_rowid ,
3987: x_apm_id => p_out_apm_id,
3988: x_css_id => g_cur_data.css_id,
3989: x_si_id => NULL ,

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

4180: || (reverse chronological order - newest change first)
4181: */
4182:
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

Line 4269: -- Cursor to update the record_status of igf_ap_person_match to matched

4265: css_profile_data1 igf_ap_css_profile%ROWTYPE ;
4266: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
4267: fa_base_found BOOLEAN ;
4268:
4269: -- Cursor to update the record_status of igf_ap_person_match to matched
4270: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
4271: SELECT apm.*
4272: FROM igf_ap_person_match apm
4273: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;

Line 4270: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS

4266: lv_cssp_id igf_ap_css_profile.cssp_id%TYPE ;
4267: fa_base_found BOOLEAN ;
4268:
4269: -- Cursor to update the record_status of igf_ap_person_match to matched
4270: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
4271: SELECT apm.*
4272: FROM igf_ap_person_match apm
4273: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
4274:

Line 4272: FROM igf_ap_person_match apm

4268:
4269: -- Cursor to update the record_status of igf_ap_person_match to matched
4270: CURSOR cur_person_match(p_apm_id igf_ap_person_match.apm_id%TYPE) IS
4271: SELECT apm.*
4272: FROM igf_ap_person_match apm
4273: WHERE apm.apm_id = p_apm_id FOR UPDATE NOWAIT ;
4274:
4275:
4276: -- cursor to update the active_profile of igf_ap_css_profile to 'N'

Line 4482: lv_apm_id igf_ap_person_match.APM_ID%TYPE ;

4478: SELECT *
4479: FROM igf_ap_record_match
4480: WHERE match_code = cp_match_code;
4481:
4482: lv_apm_id igf_ap_person_match.APM_ID%TYPE ;
4483: alt_code_rec cur_alt_code%ROWTYPE;
4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;

Line 4761: FROM igf_ap_person_match

4757:
4758: CURSOR get_apm_id(cp_css_id NUMBER)
4759: IS
4760: SELECT apm_id
4761: FROM igf_ap_person_match
4762: WHERE css_id = cp_css_id;
4763:
4764: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
4765: SELECT ibm.ci_cal_type, ibm.ci_sequence_number