[Home] [Help]
PACKAGE: APPS.IBE_MERGE_PVT
Source
1 Package IBE_MERGE_PVT AUTHID CURRENT_USER As
2 /* $Header: IBEVMRGS.pls 115.9 2003/05/12 22:52:00 adwu ship $ */
3
4 PROCEDURE acc_merge_oneclick (
5 req_id NUMBER,
6 set_num NUMBER,
7 process_mode VARCHAR2);
8
9 PROCEDURE acc_merge_active_quotes (
10 req_id NUMBER,
11 set_num NUMBER,
12 process_mode VARCHAR2);
13
14
15 PROCEDURE acc_merge_shared_quote (
16 req_id NUMBER,
17 set_num NUMBER,
18 process_mode VARCHAR2,
19 customer_type VARCHAR2);
20
21
22 PROCEDURE acc_merge_shp_lists(
23 req_id NUMBER,
24 set_num NUMBER,
25 Process_MODE VARCHAR2,
26 customer_type VARCHAR2);
27
28
29 PROCEDURE CUSTOMER_MERGE(
30 Request_id NUMBER,
31 Set_Number NUMBER,
32 Process_MODE VARCHAR2
33 );
34 /*----------------------------------------------------------------------------*
35 | PUBLIC PROCEDURES |
36 | MERGE_SHIP_LISTS -- |
37 | When in ERP Parties are merged the |
38 | The Foriegn keys to party_id and other columns |
39 | should also be updated in iStore tables. |
40 | This procedure will update IBE_SH_SHP_LISTS_ALL table |
41 | and will be called from party Merge concurrent program. |
42 | DESCRIPTION |
43 | |
44 | REQUIRES |
45 | |
46 | |
47 | EXCEPTIONS RAISED |
48 | |
49 | KNOWN BUGS |
50 | |
51 | NOTES |
52 | |
53 | HISTORY |
54 | Harish Ekkirala Created 02/12/2001. |
55 | |
56 *----------------------------------------------------------------------------*/
57
58 PROCEDURE MERGE_SHIP_LISTS(
59 P_entity_name IN VARCHAR2,
60 P_from_id IN NUMBER,
61 X_to_id OUT NOCOPY NUMBER,
62 P_from_fk_id IN NUMBER,
63 P_to_fk_id IN NUMBER,
64 P_parent_entity_name IN VARCHAR2,
65 P_batch_id IN NUMBER,
66 P_batch_party_id IN NUMBER,
67 X_return_status OUT NOCOPY VARCHAR2
68 );
69
70 /*----------------------------------------------------------------------------*
71 | PUBLIC PROCEDURES |
72 | MERGE_ONECLICK-- |
73 | When in ERP Parties are merged the |
74 | The Foriegn keys to party_id and other columns |
75 | should also be updated in iStore tables. |
76 | This procedure will update |
77 | IBE_ORD_ONECLICK table and will be called from party |
78 | Merge concurrent program. |
79 | DESCRIPTION |
80 | |
81 | REQUIRES |
82 | |
83 | |
84 | EXCEPTIONS RAISED |
85 | |
86 | KNOWN BUGS |
87 | |
88 | NOTES |
89 | |
90 | HISTORY |
91 | Harish Ekkirala Created 02/12/2001. |
92 | |
93 *----------------------------------------------------------------------------*/
94
95 PROCEDURE MERGE_ONECLICK(
96 P_entity_name IN VARCHAR2,
97 P_from_id IN NUMBER,
98 X_to_id OUT NOCOPY NUMBER,
99 P_from_fk_id IN NUMBER,
100 P_to_fk_id IN NUMBER,
101 P_parent_entity_name IN VARCHAR2,
102 P_batch_id IN NUMBER,
103 P_batch_party_id IN NUMBER,
104 X_return_status OUT NOCOPY VARCHAR2
105 );
106
107 /*----------------------------------------------------------------------------*
108 | PUBLIC PROCEDURES |
109 | MERGE_MSITE_PARTY_ACCESS -- |
110 | When in ERP Parties are merged the |
111 | The Foriegn keys to party_id and other columns |
112 | should also be updated in iStore tables. |
113 | This procedure will update |
114 | IBE_MSITE_PRTY_ACCSS table and will be called from party |
115 | Merge concurrent program. |
116 | DESCRIPTION |
117 | |
118 | REQUIRES |
119 | |
120 | |
121 | EXCEPTIONS RAISED |
122 | |
123 | KNOWN BUGS |
124 | |
125 | NOTES |
126 | |
127 | HISTORY |
128 | Harish Ekkirala Created 02/12/2001. |
129 | |
130 *----------------------------------------------------------------------------*/
131
132 PROCEDURE MERGE_MSITE_PARTY_ACCESS(
133 P_entity_name IN VARCHAR2,
134 P_from_id IN NUMBER,
135 X_to_id OUT NOCOPY NUMBER,
136 P_from_fk_id IN NUMBER,
137 P_to_fk_id IN NUMBER,
138 P_parent_entity_name IN VARCHAR2,
139 P_batch_id IN NUMBER,
140 P_batch_party_id IN NUMBER,
141 X_return_status OUT NOCOPY VARCHAR2
142 );
143
144
145 /*----------------------------------------------------------------------------*
146 | PUBLIC PROCEDURES |
147 | MERGE_SHARED_QUOTE -- |
148 | When in ERP Parties are merged the |
149 | The Foriegn keys to party_id and other columns |
150 | should also be updated in iStore tables. |
151 | This procedure will update IBE_SH_QUOTE table |
152 | and will be called from party Merge concurrent program. |
153 | DESCRIPTION |
154 | |
155 | REQUIRES |
156 | |
157 | |
158 | EXCEPTIONS RAISED |
159 | |
160 | KNOWN BUGS |
161 | |
162 | NOTES |
163 | |
164 | HISTORY |
165 | Adam Wu Created 12/05/2002. |
166 | |
167 *----------------------------------------------------------------------------*/
168
169 PROCEDURE MERGE_SHARED_QUOTE(
170 P_entity_name IN VARCHAR2,
171 P_from_id IN NUMBER,
172 X_to_id OUT NOCOPY NUMBER,
173 P_from_fk_id IN NUMBER,
174 P_to_fk_id IN NUMBER,
175 P_parent_entity_name IN VARCHAR2,
176 P_batch_id IN NUMBER,
177 P_batch_party_id IN NUMBER,
178 X_return_status OUT NOCOPY VARCHAR2
179 );
180
181 /*----------------------------------------------------------------------------*
182 | PUBLIC PROCEDURES |
183 | MERGE_ACTIVE_QUOTE -- |
184 | When in ERP Parties are merged the |
185 | The Foriegn keys to party_id and other columns |
186 | should also be updated in iStore tables. |
187 | This procedure will update IBE_ACTIVE_QUOTES_ALL table |
188 | and will be called from party Merge concurrent program. |
189 | DESCRIPTION |
190 | |
191 | REQUIRES |
192 | |
193 | |
194 | EXCEPTIONS RAISED |
195 | |
196 | KNOWN BUGS |
197 | |
198 | NOTES |
199 | |
200 | HISTORY |
201 | Adam Wu Created 12/05/2002. |
202 | |
203 *----------------------------------------------------------------------------*/
204 procedure MERGE_ACTIVE_QUOTE(
205 P_entity_name IN VARCHAR2,
206 P_from_id IN NUMBER,
207 X_to_id OUT NOCOPY NUMBER,
208 P_from_fk_id IN NUMBER,
209 P_to_fk_id IN NUMBER,
210 P_parent_entity_name IN VARCHAR2,
211 P_batch_id IN NUMBER,
212 P_batch_party_id IN NUMBER,
216
213 X_return_status OUT NOCOPY VARCHAR2
214 );
215
217 End IBE_MERGE_PVT;
218
219