PACKAGE: APPS.IGF_AP_MATCHING_PROCESS_PKG

Source

1 PACKAGE igf_ap_matching_process_pkg AS
2 /* $Header: IGFAP04S.pls 120.0 2005/06/01 13:44:19 appldev noship $ */
3 
4 
5 PROCEDURE main ( errbuf            OUT NOCOPY VARCHAR2,
6                  retcode           OUT NOCOPY NUMBER,
7                  p_force_add       IN VARCHAR2,
8                  p_create_inquiry  IN VARCHAR2,
9                  p_adm_source_type IN VARCHAR2,
10                  p_batch_year      IN VARCHAR2,
11                  p_match_code      IN VARCHAR2,
12                  p_del_int         IN VARCHAR2,
13                  p_parent_req_id   IN VARCHAR2,             -- when called as sub request
14                  p_sub_req_num     IN VARCHAR2,             -- when called as sub request
15                  p_si_id           IN VARCHAR2,
16                  p_upd_ant_val     IN VARCHAR2   DEFAULT 'Y'
17                  );
18 
19 
20 -- # 2376750  Added match_records procedure.
21 
22 FUNCTION format_SSN (l_ssn  VARCHAR2 )
23 RETURN VARCHAR2 ;
24 
25 FUNCTION convert_to_date(pv_org_date  VARCHAR2)
26 RETURN DATE;
27 
28 FUNCTION convert_to_number(pv_org_number VARCHAR2)
29 RETURN NUMBER;
30 
31 FUNCTION is_fa_base_record_present(pn_person_id   NUMBER,
32                                   pn_batch_year  NUMBER,
33                                   pn_base_id     OUT  NOCOPY  NUMBER)
34 RETURN BOOLEAN;
35 
36 FUNCTION convert_negative_char(pv_charnum   VARCHAR2)
37 RETURN NUMBER;
38 
39 PROCEDURE load_matched_isir(pv_ssn                 VARCHAR2,
40                             pv_last_name           VARCHAR2,
41                             pd_date_of_birth       DATE,
42                             pn_ci_sequence_number  NUMBER,
43                             pv_ci_cal_type         VARCHAR2,
44                             pn_base_id             igf_ap_isir_matched.base_id%TYPE);
45 
46 PROCEDURE create_isir_matched(pn_si_id           NUMBER,
47                               pn_isir_id   OUT NOCOPY  NUMBER,
48                               pn_base_id   IN    NUMBER );
49 
50 
51 PROCEDURE update_isir_intrface(pn_si_id           NUMBER,
52                                pv_record_status   VARCHAR2 );
53 
54 
55 PROCEDURE create_nslds_data(pn_si_id     NUMBER,
56                             pn_isir_id   NUMBER,
57                             pn_base_id   NUMBER
58                           );
59 
60 FUNCTION check_ptyp_code(p_person_id   igf_ap_person_v.person_id%TYPE)
61 RETURN BOOLEAN;
62 
63 FUNCTION remove_spl_chr(pv_ssn  igf_ap_isir_ints_all.current_ssn_txt%TYPE )
64 RETURN VARCHAR2;
65 
66 PRAGMA RESTRICT_REFERENCES(remove_spl_chr, WNDS, WNPS, RNPS);
67 
68 
69 FUNCTION get_msg_class_from_filename(p_filename VARCHAR2)
70 RETURN VARCHAR2 ;
71 
72 -- Added p_award_yr as a part of Bug Fix 4241350
73 PROCEDURE wrpr_auto_fa_rec(p_si_id          IN igf_ap_isir_ints_all.si_id%TYPE,
74                            p_person_id      IN igf_ap_match_details.person_id%TYPE,
75 			   p_batch_year       IN igf_ap_isir_matched.batch_year%TYPE,
76                            p_return_status OUT NOCOPY VARCHAR2,
77                            p_message_out   OUT NOCOPY VARCHAR2);
78 
79 
80 PROCEDURE wrpr_unmatched_rec(p_si_id          IN igf_ap_isir_ints_all.si_id%TYPE,
81                              p_return_status OUT NOCOPY VARCHAR2,
82                              p_message_out   OUT NOCOPY VARCHAR2);
83 
84 PROCEDURE wrpr_refresh_matches(p_si_id          IN igf_ap_isir_ints_all.si_id%TYPE,
85                                p_match_code     IN igf_ap_record_match_all.match_code%TYPE,
86                                p_return_status OUT NOCOPY VARCHAR2,
87                                p_message_out   OUT NOCOPY VARCHAR2);
88 
89 END igf_ap_matching_process_pkg;