DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGF_AP_PERSON_MATCH_ALL

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