1 PACKAGE igf_ap_match_details_pkg AS
2 /* $Header: IGFAI38S.pls 120.0 2005/06/01 15:27:54 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_amd_id IN OUT NOCOPY NUMBER,
7 x_apm_id IN NUMBER,
8 x_person_id IN NUMBER,
9 x_ssn_match IN NUMBER,
10 x_given_name_match IN NUMBER,
11 x_surname_match IN NUMBER,
12 x_dob_match IN NUMBER,
13 x_address_match IN NUMBER,
14 x_city_match IN NUMBER,
15 x_zip_match IN NUMBER,
16 x_match_score IN NUMBER,
17 x_record_status IN VARCHAR2,
18 x_mode IN VARCHAR2 DEFAULT 'R',
19 x_ssn_txt IN VARCHAR2 DEFAULT NULL,
20 x_given_name_txt IN VARCHAR2 DEFAULT NULL,
21 x_sur_name_txt IN VARCHAR2 DEFAULT NULL,
22 x_birth_date IN DATE DEFAULT NULL,
23 x_address_txt IN VARCHAR2 DEFAULT NULL,
24 x_city_txt IN VARCHAR2 DEFAULT NULL,
25 x_zip_txt IN VARCHAR2 DEFAULT NULL,
26 x_gender_txt IN VARCHAR2 DEFAULT NULL,
27 x_email_id_txt IN VARCHAR2 DEFAULT NULL,
28 x_email_id_match IN NUMBER DEFAULT NULL,
29 x_gender_match IN NUMBER DEFAULT NULL
30 );
31
32 PROCEDURE lock_row (
33 x_rowid IN VARCHAR2,
34 x_amd_id IN NUMBER,
35 x_apm_id IN NUMBER,
36 x_person_id IN NUMBER,
37 x_ssn_match IN NUMBER,
38 x_given_name_match IN NUMBER,
39 x_surname_match IN NUMBER,
40 x_dob_match IN NUMBER,
41 x_address_match IN NUMBER,
42 x_city_match IN NUMBER,
43 x_zip_match IN NUMBER,
44 x_match_score IN NUMBER,
45 x_record_status IN VARCHAR2,
46 x_ssn_txt IN VARCHAR2 DEFAULT NULL,
47 x_given_name_txt IN VARCHAR2 DEFAULT NULL,
48 x_sur_name_txt IN VARCHAR2 DEFAULT NULL,
49 x_birth_date IN DATE DEFAULT NULL,
50 x_address_txt IN VARCHAR2 DEFAULT NULL,
51 x_city_txt IN VARCHAR2 DEFAULT NULL,
52 x_zip_txt IN VARCHAR2 DEFAULT NULL,
53 x_gender_txt IN VARCHAR2 DEFAULT NULL,
54 x_email_id_txt IN VARCHAR2 DEFAULT NULL,
55 x_email_id_match IN NUMBER DEFAULT NULL,
56 x_gender_match IN NUMBER DEFAULT NULL
57 );
58
59 PROCEDURE update_row (
60 x_rowid IN VARCHAR2,
61 x_amd_id IN NUMBER,
62 x_apm_id IN NUMBER,
63 x_person_id IN NUMBER,
64 x_ssn_match IN NUMBER,
65 x_given_name_match IN NUMBER,
66 x_surname_match IN NUMBER,
67 x_dob_match IN NUMBER,
68 x_address_match IN NUMBER,
69 x_city_match IN NUMBER,
70 x_zip_match IN NUMBER,
71 x_match_score IN NUMBER,
72 x_record_status IN VARCHAR2,
73 x_mode IN VARCHAR2 DEFAULT 'R',
74 x_ssn_txt IN VARCHAR2 DEFAULT NULL,
75 x_given_name_txt IN VARCHAR2 DEFAULT NULL,
76 x_sur_name_txt IN VARCHAR2 DEFAULT NULL,
77 x_birth_date IN DATE DEFAULT NULL,
78 x_address_txt IN VARCHAR2 DEFAULT NULL,
79 x_city_txt IN VARCHAR2 DEFAULT NULL,
80 x_zip_txt IN VARCHAR2 DEFAULT NULL,
81 x_gender_txt IN VARCHAR2 DEFAULT NULL,
82 x_email_id_txt IN VARCHAR2 DEFAULT NULL,
83 x_email_id_match IN NUMBER DEFAULT NULL,
84 x_gender_match IN NUMBER DEFAULT NULL
85 );
86
87 PROCEDURE add_row (
88 x_rowid IN OUT NOCOPY VARCHAR2,
89 x_amd_id IN OUT NOCOPY NUMBER,
90 x_apm_id IN NUMBER,
91 x_person_id IN NUMBER,
92 x_ssn_match IN NUMBER,
93 x_given_name_match IN NUMBER,
94 x_surname_match IN NUMBER,
95 x_dob_match IN NUMBER,
96 x_address_match IN NUMBER,
97 x_city_match IN NUMBER,
98 x_zip_match IN NUMBER,
99 x_match_score IN NUMBER,
100 x_record_status IN VARCHAR2,
101 x_mode IN VARCHAR2 DEFAULT 'R',
102 x_ssn_txt IN VARCHAR2 DEFAULT NULL,
103 x_given_name_txt IN VARCHAR2 DEFAULT NULL,
104 x_sur_name_txt IN VARCHAR2 DEFAULT NULL,
105 x_birth_date IN DATE DEFAULT NULL,
106 x_address_txt IN VARCHAR2 DEFAULT NULL,
107 x_city_txt IN VARCHAR2 DEFAULT NULL,
108 x_zip_txt IN VARCHAR2 DEFAULT NULL,
109 x_gender_txt IN VARCHAR2 DEFAULT NULL,
110 x_email_id_txt IN VARCHAR2 DEFAULT NULL,
111 x_email_id_match IN NUMBER DEFAULT NULL,
112 x_gender_match IN NUMBER DEFAULT NULL
113 );
114
115 PROCEDURE delete_row (
116 x_rowid IN VARCHAR2
117 );
118
119 FUNCTION get_pk_for_validation (
120 x_amd_id IN NUMBER
121 ) RETURN BOOLEAN;
122
123 PROCEDURE get_fk_igf_ap_person_match_all (
124 x_apm_id IN NUMBER
125 );
126
127 PROCEDURE before_dml (
128 p_action IN VARCHAR2,
129 x_rowid IN VARCHAR2 DEFAULT NULL,
130 x_amd_id IN NUMBER DEFAULT NULL,
131 x_apm_id IN NUMBER DEFAULT NULL,
132 x_person_id IN NUMBER DEFAULT NULL,
133 x_ssn_match IN NUMBER DEFAULT NULL,
134 x_given_name_match IN NUMBER DEFAULT NULL,
135 x_surname_match IN NUMBER DEFAULT NULL,
136 x_dob_match IN NUMBER DEFAULT NULL,
137 x_address_match IN NUMBER DEFAULT NULL,
138 x_city_match IN NUMBER DEFAULT NULL,
139 x_zip_match IN NUMBER DEFAULT NULL,
140 x_match_score IN NUMBER DEFAULT NULL,
141 x_record_status IN VARCHAR2 DEFAULT NULL,
142 x_creation_date IN DATE DEFAULT NULL,
143 x_created_by IN NUMBER DEFAULT NULL,
144 x_last_update_date IN DATE DEFAULT NULL,
145 x_last_updated_by IN NUMBER DEFAULT NULL,
146 x_last_update_login IN NUMBER DEFAULT NULL,
147 x_ssn_txt IN VARCHAR2 DEFAULT NULL,
148 x_given_name_txt IN VARCHAR2 DEFAULT NULL,
149 x_sur_name_txt IN VARCHAR2 DEFAULT NULL,
150 x_birth_date IN DATE DEFAULT NULL,
151 x_address_txt IN VARCHAR2 DEFAULT NULL,
152 x_city_txt IN VARCHAR2 DEFAULT NULL,
153 x_zip_txt IN VARCHAR2 DEFAULT NULL,
154 x_gender_txt IN VARCHAR2 DEFAULT NULL,
155 x_email_id_txt IN VARCHAR2 DEFAULT NULL,
156 x_email_id_match IN NUMBER DEFAULT NULL,
157 x_gender_match IN NUMBER DEFAULT NULL
158 );
159
160 END igf_ap_match_details_pkg;