1 PACKAGE AHL_PARTY_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: AHLPMRGS.pls 115.15 2003/05/16 20:57:25 sracha noship $ */
3 -- Start of Comments
4 -- Package name : AHL_PARTY_MERGE_PKG
5 -- Purpose : Merges duplicate parties in Advanced Service
6 -- Online tables. The
7 -- Tables that need to be considered for
8 -- Party Merge are:
9 -- AHL_DOCUMENTS_B
10 -- AHL_SUPPLIER_DOCUMENTS
11 -- AHL_RECIPIENT_DOCUEMTNS
12 -- AHL_SUBSCRIPTIONS_B
13 -- AHL_DOC_REVISIONS_B
14 -- AHL_DOC_REVISION_COPIES
15 --
16 -- AHL_OPERATIONS_B
17 -- AHL_OPERATIONS_H_B
18 -- AHL_ROUTES_B
19 -- AHL_ROUTES_H_B
20 --
21 -- History
22 -- MM-DD-YYYY NAME MODIFICATIONS
23 -- 07-30-2001 vrankaiy Created.
24 -- 12-20-2001 jeli Added the four entities for RM.
25 --
26 -- Refer to bug # 1539248 for party merge registration details.
27 --
28 -- 03-Sep-2002 ssurapan Commented operation party id as per route enhancements
29 -- 07-Apr-2003 jaramana Added a routine for OSP (Customer)
30 -- End of Comments
31
32 PROCEDURE AHL_DI_SOURCE_PARTY (
33 p_entity_name IN VARCHAR2,
34 p_from_id IN NUMBER,
35 x_to_id OUT NOCOPY NUMBER,
36 p_from_fk_id IN NUMBER,
37 p_to_fk_id IN NUMBER,
38 p_parent_entity_name IN VARCHAR2,
39 p_batch_id IN NUMBER,
40 p_batch_party_id IN NUMBER,
41 x_return_status OUT NOCOPY VARCHAR2);
42
43 PROCEDURE AHL_DI_SUPPLIER (
44 p_entity_name IN VARCHAR2,
45 p_from_id IN NUMBER,
46 x_to_id OUT NOCOPY NUMBER,
47 p_from_fk_id IN NUMBER,
48 p_to_fk_id IN NUMBER,
49 p_parent_entity_name IN VARCHAR2,
50 p_batch_id IN NUMBER,
51 p_batch_party_id IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2);
53
54 PROCEDURE AHL_DI_RECIPIENT_PARTY (
55 p_entity_name IN VARCHAR2,
56 p_from_id IN NUMBER,
57 x_to_id OUT NOCOPY NUMBER,
58 p_from_fk_id IN NUMBER,
59 p_to_fk_id IN NUMBER,
60 p_parent_entity_name IN VARCHAR2,
61 p_batch_id IN NUMBER,
62 p_batch_party_id IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65 PROCEDURE AHL_DI_REQUESTED_BY_PARTY (
66 p_entity_name IN VARCHAR2,
67 p_from_id IN NUMBER,
68 x_to_id OUT NOCOPY NUMBER,
69 p_from_fk_id IN NUMBER,
70 p_to_fk_id IN NUMBER,
71 p_parent_entity_name IN VARCHAR2,
72 p_batch_id IN NUMBER,
73 p_batch_party_id IN NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2);
75
76 PROCEDURE AHL_DI_SUBSCRIBED_FRM_PARTY(
77 p_entity_name IN VARCHAR2,
78 p_from_id IN NUMBER,
79 x_to_id OUT NOCOPY NUMBER,
80 p_from_fk_id IN NUMBER,
81 p_to_fk_id IN NUMBER,
82 p_parent_entity_name IN VARCHAR2,
83 p_batch_id IN NUMBER,
84 p_batch_party_id IN NUMBER,
85 x_return_status OUT NOCOPY VARCHAR2);
86
87 PROCEDURE AHL_DI_APPROVED_BY_PARTY (
88 p_entity_name IN VARCHAR2,
89 p_from_id IN NUMBER,
90 x_to_id OUT NOCOPY NUMBER,
91 p_from_fk_id IN NUMBER,
92 p_to_fk_id IN NUMBER,
93 p_parent_entity_name IN VARCHAR2,
94 p_batch_id IN NUMBER,
95 p_batch_party_id IN NUMBER,
96 x_return_status OUT NOCOPY VARCHAR2);
97
98 PROCEDURE AHL_DI_RECEIVED_BY_PARTY (
99 p_entity_name IN VARCHAR2,
100 p_from_id IN NUMBER,
101 x_to_id OUT NOCOPY NUMBER,
102 p_from_fk_id IN NUMBER,
103 p_to_fk_id IN NUMBER,
104 p_parent_entity_name IN VARCHAR2,
105 p_batch_id IN NUMBER,
106 p_batch_party_id IN NUMBER,
107 x_return_status OUT NOCOPY VARCHAR2);
108 /*
109 PROCEDURE AHL_RM_OPER_OPERATOR_PARTY (
110 p_entity_name IN VARCHAR2,
111 p_from_id IN NUMBER,
112 x_to_id OUT NOCOPY NUMBER,
113 p_from_fk_id IN NUMBER,
114 p_to_fk_id IN NUMBER,
115 p_parent_entity_name IN VARCHAR2,
116 p_batch_id IN NUMBER,
117 p_batch_party_id IN NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2);
119
120 PROCEDURE AHL_RM_OPER_H_OPERATOR_PARTY (
121 p_entity_name IN VARCHAR2,
122 p_from_id IN NUMBER,
123 x_to_id OUT NOCOPY NUMBER,
124 p_from_fk_id IN NUMBER,
125 p_to_fk_id IN NUMBER,
126 p_parent_entity_name IN VARCHAR2,
127 p_batch_id IN NUMBER,
128 p_batch_party_id IN NUMBER,
129 x_return_status OUT NOCOPY VARCHAR2);
130 */
131 PROCEDURE AHL_RM_ROUTE_OPERATOR_PARTY (
132 p_entity_name IN VARCHAR2,
133 p_from_id IN NUMBER,
134 x_to_id OUT NOCOPY NUMBER,
135 p_from_fk_id IN NUMBER,
136 p_to_fk_id IN NUMBER,
137 p_parent_entity_name IN VARCHAR2,
138 p_batch_id IN NUMBER,
139 p_batch_party_id IN NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2);
141 /*
142 PROCEDURE AHL_RM_ROUTE_H_OPERATOR_PARTY (
143 p_entity_name IN VARCHAR2,
144 p_from_id IN NUMBER,
145 x_to_id OUT NOCOPY NUMBER,
146 p_from_fk_id IN NUMBER,
147 p_to_fk_id IN NUMBER,
148 p_parent_entity_name IN VARCHAR2,
149 p_batch_id IN NUMBER,
150 p_batch_party_id IN NUMBER,
151 x_return_status OUT NOCOPY VARCHAR2);
152 */
153 PROCEDURE AHL_OSP_CUSTOMER (
154 p_entity_name IN VARCHAR2,
155 p_from_id IN NUMBER,
156 x_to_id OUT NOCOPY NUMBER,
157 p_from_fk_id IN NUMBER,
158 p_to_fk_id IN NUMBER,
159 p_parent_entity_name IN VARCHAR2,
160 p_batch_id IN NUMBER,
161 p_batch_party_id IN NUMBER,
162 x_return_status OUT NOCOPY VARCHAR2);
163 END AHL_PARTY_MERGE_PKG;