27: ) ;
28:
29:
30: FUNCTION is_fa_base_record_present(pn_person_id igf_ap_match_details.person_id%TYPE,
31: pn_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
32: pn_sequence_number igf_ap_person_match_all.ci_sequence_number%TYPE,
33: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
34: ) RETURN BOOLEAN ;
35:
28:
29:
30: FUNCTION is_fa_base_record_present(pn_person_id igf_ap_match_details.person_id%TYPE,
31: pn_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
32: pn_sequence_number igf_ap_person_match_all.ci_sequence_number%TYPE,
33: pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
34: ) RETURN BOOLEAN ;
35:
36: PROCEDURE update_css_interface(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
51: p_school_code IN VARCHAR2
52: );
53:
54: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE ,
55: p_apm_id igf_ap_person_match_all.apm_id%TYPE,
56: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
57: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE
58: );
59:
52: );
53:
54: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE ,
55: p_apm_id igf_ap_person_match_all.apm_id%TYPE,
56: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
57: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE
58: );
59:
60: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE );
53:
54: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE ,
55: p_apm_id igf_ap_person_match_all.apm_id%TYPE,
56: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
57: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE
58: );
59:
60: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE );
61:
56: p_cal_type igf_ap_person_match_all.ci_cal_type%TYPE,
57: p_seq_num igf_ap_person_match_all.ci_sequence_number%TYPE
58: );
59:
60: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE );
61:
62: PROCEDURE unmatched_rec (p_apm_id igf_ap_person_match_all.apm_id%TYPE);
63:
64: PROCEDURE create_admission_rec(p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
58: );
59:
60: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE );
61:
62: PROCEDURE unmatched_rec (p_apm_id igf_ap_person_match_all.apm_id%TYPE);
63:
64: PROCEDURE create_admission_rec(p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
65: p_batch_year igf_ap_css_interface_all.academic_year%TYPE);
66: