1 PACKAGE HZ_IMP_LOAD_SSM_MATCHING_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHLSSMS.pls 120.5 2005/10/30 03:53:21 appldev noship $*/
3
4
5 /* Party is the root entities - first entity to be processed */
6 PROCEDURE match_parties(
7 P_BATCH_ID IN NUMBER,
8 P_OS IN VARCHAR2,
9 P_FROM_OSR IN VARCHAR2,
10 P_TO_OSR IN VARCHAR2,
11 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
12 P_RERUN IN VARCHAR2,
13 P_BATCH_MODE_FLAG IN VARCHAR2
14 );
15
16
17 /* Address is the second entity to be processed. */
18 PROCEDURE match_addresses(
19 P_BATCH_ID IN NUMBER,
20 P_OS IN VARCHAR2,
21 P_FROM_OSR IN VARCHAR2,
22 P_TO_OSR IN VARCHAR2,
23 P_RERUN IN VARCHAR2,
24 P_BATCH_MODE_FLAG IN VARCHAR2
25 );
26
27
28 PROCEDURE match_contact_points(
29 P_BATCH_ID IN NUMBER,
30 P_OS IN VARCHAR2,
31 P_FROM_OSR IN VARCHAR2,
32 P_TO_OSR IN VARCHAR2,
33 P_RERUN IN VARCHAR2,
34 P_BATCH_MODE_FLAG IN VARCHAR2
35 );
36
37
38 PROCEDURE match_credit_ratings(
39 P_BATCH_ID IN NUMBER,
40 P_OS IN VARCHAR2,
41 P_FROM_OSR IN VARCHAR2,
42 P_TO_OSR IN VARCHAR2,
43 P_DEF_START_TIME IN DATE,
44 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
45 P_RERUN IN VARCHAR2,
46 P_BATCH_MODE_FLAG IN VARCHAR2
47 );
48
49
50 PROCEDURE match_code_assignments(
51 P_BATCH_ID IN NUMBER,
52 P_OS IN VARCHAR2,
53 P_FROM_OSR IN VARCHAR2,
54 P_TO_OSR IN VARCHAR2,
55 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
56 P_RERUN IN VARCHAR2,
57 P_BATCH_MODE_FLAG IN VARCHAR2
58 );
59
60
61 PROCEDURE match_financial_reports(
62 P_BATCH_ID IN NUMBER,
63 P_OS IN VARCHAR2,
64 P_FROM_OSR IN VARCHAR2,
65 P_TO_OSR IN VARCHAR2,
66 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
67 P_RERUN IN VARCHAR2,
68 P_BATCH_MODE_FLAG IN VARCHAR2
69 );
70
71
72 PROCEDURE match_financial_numbers(
73 P_BATCH_ID IN NUMBER,
74 P_OS IN VARCHAR2,
75 P_FROM_OSR IN VARCHAR2,
76 P_TO_OSR IN VARCHAR2,
77 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
78 P_RERUN IN VARCHAR2,
79 P_BATCH_MODE_FLAG IN VARCHAR2
80 );
81
82
83 PROCEDURE match_relationships(
84 P_BATCH_ID IN NUMBER,
85 P_OS IN VARCHAR2,
86 P_FROM_OSR IN VARCHAR2,
87 P_TO_OSR IN VARCHAR2,
88 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
89 P_RERUN IN VARCHAR2,
90 P_BATCH_MODE_FLAG IN VARCHAR2
91 );
92
93
94 PROCEDURE match_contacts(
95 P_BATCH_ID IN NUMBER,
96 P_OS IN VARCHAR2,
97 P_FROM_OSR IN VARCHAR2,
98 P_TO_OSR IN VARCHAR2,
99 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
100 P_RERUN IN VARCHAR2,
101 P_BATCH_MODE_FLAG IN VARCHAR2
102 );
103
104
105 PROCEDURE match_contactroles(
106 P_BATCH_ID IN NUMBER,
107 P_OS IN VARCHAR2,
108 P_FROM_OSR IN VARCHAR2,
109 P_TO_OSR IN VARCHAR2,
110 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
111 P_RERUN IN VARCHAR2,
112 P_BATCH_MODE_FLAG IN VARCHAR2
113 );
114
115
116 PROCEDURE match_addruses(
117 P_BATCH_ID IN NUMBER,
118 P_OS IN VARCHAR2,
119 P_FROM_OSR IN VARCHAR2,
120 P_TO_OSR IN VARCHAR2,
121 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
122 P_RERUN IN VARCHAR2,
123 P_BATCH_MODE_FLAG IN VARCHAR2
124 );
125
126
127 END HZ_IMP_LOAD_SSM_MATCHING_PKG;