[Home] [Help]
PACKAGE: APPS.IGF_AP_PROFILE_MATCHING_PKG
Source
1 PACKAGE igf_ap_profile_matching_pkg AS
2 /* $Header: IGFAP16S.pls 120.0 2005/06/01 15:01:20 appldev noship $ */
3
4 PROCEDURE create_fa_base_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
5 pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
6 pn_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
7 ) ;
8
9 PROCEDURE create_fnar_data(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
10 pn_cssp_id igf_ap_css_profile.cssp_id%TYPE
11 ) ;
12
13 PROCEDURE create_person_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
14 pn_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
15 pv_mesg_data OUT NOCOPY VARCHAR2,
16 p_called_from VARCHAR2
17 ) ;
18
19 PROCEDURE create_person_addr_record(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
20 pn_person_id igf_ap_fa_base_rec_all.person_id%TYPE
21 ) ;
22
23 PROCEDURE create_profile_matched(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
24 pn_cssp_id OUT NOCOPY igf_ap_css_profile.cssp_id%TYPE,
25 pn_base_id igf_ap_css_profile.base_id%TYPE,
26 pn_system_record_type igf_ap_css_profile.system_record_type%TYPE
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
36 PROCEDURE update_css_interface(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
37 pv_record_status igf_ap_css_interface_all.record_status%TYPE,
38 pv_match_code VARCHAR2
39 ) ;
40
41 FUNCTION convert_int(col_value VARCHAR2) RETURN VARCHAR2 ;
42
43 PROCEDURE main( errbuf OUT NOCOPY VARCHAR2,
44 retcode OUT NOCOPY NUMBER,
45 p_org_id IN NUMBER,
46 p_award_year IN VARCHAR2,
47 p_force_add IN VARCHAR2,
48 p_create_inquiry IN VARCHAR2,
49 p_adm_source_type IN VARCHAR2,
50 p_match_code IN VARCHAR2,
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
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
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
74
75 FUNCTION remove_spl_chr(pv_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE)
76 RETURN VARCHAR2;
77
78 PROCEDURE ss_wrap_create_person_record (p_css_id IN NUMBER);
79
80 PROCEDURE ss_wrap_refresh_matches(p_css_id IN NUMBER,
81 p_match_code IN VARCHAR2,
82 p_batch_year IN NUMBER);
83
84 PROCEDURE ss_wrap_create_base_record ( p_css_id IN NUMBER,
85 p_person_id IN NUMBER,
86 p_batch_year IN NUMBER);
87
88 PROCEDURE ss_wrap_upload_Profile ( p_css_id IN NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 x_return_status OUT NOCOPY VARCHAR2
91 );
92
93 END igf_ap_profile_matching_pkg;