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:
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:
67:
68: PROCEDURE update_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE,
69: pv_record_status igf_ap_person_match.record_status%TYPE
70: ) ;
71:
72: PROCEDURE update_fa_base_rec(p_base_id igf_ap_fa_base_rec.base_id%TYPE);
65: p_batch_year igf_ap_css_interface_all.academic_year%TYPE);
66:
67:
68: PROCEDURE update_person_match(pn_apm_id igf_ap_person_match.apm_id%TYPE,
69: pv_record_status igf_ap_person_match.record_status%TYPE
70: ) ;
71:
72: PROCEDURE update_fa_base_rec(p_base_id igf_ap_fa_base_rec.base_id%TYPE);
73: