1 Package ASO_MERGE_PVT AUTHID CURRENT_USER As
2 /* $Header: asovmrgs.pls 115.13 2003/05/27 22:18:28 vtariker ship $ */
3
4 /*----------------------------------------------------------------------------*
5 | PUBLIC PROCEDURE |
6 | CUSTOMER_MERGE |
7 | DESCRIPTION |
8 | This API should be called from TCA customer merge concurrent |
9 | program and will merge records in Order Capture tables for |
10 | customers that being merged. |
11 | REQUIRES |
12 | |
13 | |
14 | EXCEPTIONS RAISED |
15 | DIFFERENT_PARTIES -- Raises an exception when the owner |
16 | parties are different for the cust |
17 | accounts that are being merged. |
18 | KNOWN BUGS |
19 | |
20 | NOTES |
21 | |
22 | HISTORY |
23 | Harish Ekkirala Created 03/27/2001. |
24 | Veeru Tarikere 07/18/2002 Rewrote Customer_merge |
25 | |
26 *----------------------------------------------------------------------------*/
27 PROCEDURE CUSTOMER_MERGE(
28 req_id NUMBER,
29 set_num NUMBER,
30 process_mode VARCHAR2
31 );
32
33
34 /*----------------------------------------------------------------------------*
35 | PRIVATE PROCEDURE |
36 | UPDATE_QUOTE_LINES |
37 | DESCRIPTION |
38 | This is a private procedure to update ASO_QUOTE_LINES_ALL |
39 | table with merged to cust account id. When two cust accounts |
40 | are merged. |
41 | REQUIRES |
42 | |
43 | |
44 | EXCEPTIONS RAISED |
45 | |
46 | KNOWN BUGS |
47 | |
48 | NOTES |
49 | |
50 | HISTORY |
51 | Harish Ekkirala Created 03/27/2001. |
52 | Vtariker 07/18/2002 Rewrote Update_Quote_Lines |
53 | |
54 *----------------------------------------------------------------------------*/
55 PROCEDURE UPDATE_QUOTE_LINES(
56 req_id NUMBER,
57 set_num NUMBER,
58 process_mode VARCHAR2
59 );
60
61
62 /*----------------------------------------------------------------------------*
63 | PRIVATE PROCEDURE |
64 | UPDATE_SHIPMENTS |
65 | DESCRIPTION |
66 | This is a private procedure to update ASO_SHIPMENTS |
67 | table with merged to cust account id. When two cust accounts |
68 | are merged. |
69 | REQUIRES |
70 | |
71 | |
72 | EXCEPTIONS RAISED |
73 | |
74 | KNOWN BUGS |
75 | |
76 | NOTES |
77 | |
78 | HISTORY |
79 | Harish Ekkirala Created 03/27/2001. |
80 | Vtariker 07/18/2002 Rewrote Update_Shipments |
81 | |
82 *----------------------------------------------------------------------------*/
83 PROCEDURE UPDATE_SHIPMENTS(
84 req_id NUMBER,
85 set_num NUMBER,
86 process_mode VARCHAR2
87 );
88
89
90 /*----------------------------------------------------------------------------*
91 | PUBLIC PROCEDURES |
92 | MERGE_QUOTE_HEADERS -- |
93 | When in ERP Parties are merged the |
94 | The Foriegn keys to party_id and other columns |
95 | should also be updated in iStore tables. |
96 | This procedure will update ASO_QUOTE_HEADERS_ALL table |
97 | and will be called from party Merge concurrent program. |
98 | DESCRIPTION |
99 | |
100 | REQUIRES |
101 | |
102 | |
103 | EXCEPTIONS RAISED |
104 | |
105 | KNOWN BUGS |
106 | |
107 | NOTES |
108 | |
109 | HISTORY |
110 | Harish Ekkirala Created 02/26/2001. |
111 | |
112 *----------------------------------------------------------------------------*/
113 PROCEDURE MERGE_QUOTE_HEADERS(
114 P_entity_name IN VARCHAR2,
115 P_from_id IN NUMBER,
116 X_to_id OUT NOCOPY NUMBER,
117 P_from_fk_id IN NUMBER,
118 P_to_fk_id IN NUMBER,
119 P_parent_entity_name IN VARCHAR2,
120 P_batch_id IN NUMBER,
121 P_batch_party_id IN NUMBER,
122 X_return_status OUT NOCOPY VARCHAR2
123 );
124
125 /*----------------------------------------------------------------------------*
126 | PUBLIC PROCEDURES |
127 | MERGE_QUOTE_LINES -- |
128 | When in ERP Parties are merged the |
129 | The Foriegn keys to party_id and other columns |
130 | should also be updated in iStore tables. |
131 | This procedure will update ASO_QUOTE_LINES_ALL table |
132 | and will be called from party Merge concurrent program. |
133 | DESCRIPTION |
134 | |
135 | REQUIRES |
136 | |
137 | |
138 | EXCEPTIONS RAISED |
139 | |
140 | KNOWN BUGS |
141 | |
142 | NOTES |
143 | |
144 | HISTORY |
145 | Harish Ekkirala Created 02/26/2001. |
146 | |
147 *----------------------------------------------------------------------------*/
148
149 PROCEDURE MERGE_QUOTE_LINES(
150 P_entity_name IN VARCHAR2,
151 P_from_id IN NUMBER,
152 X_to_id OUT NOCOPY NUMBER,
153 P_from_fk_id IN NUMBER,
154 P_to_fk_id IN NUMBER,
155 P_parent_entity_name IN VARCHAR2,
156 P_batch_id IN NUMBER,
157 P_batch_party_id IN NUMBER,
158 X_return_status OUT NOCOPY VARCHAR2
159 );
160
161 /*----------------------------------------------------------------------------*
162 | PUBLIC PROCEDURES |
163 | MERGE_SHIPMENTS -- |
164 | When in ERP Parties are merged the |
165 | The Foriegn keys to party_id and other columns |
166 | should also be updated in iStore tables. |
167 | This procedure will update ASO_SHIPMENTS table |
168 | and will be called from party Merge concurrent program. |
169 | DESCRIPTION |
170 | |
171 | REQUIRES |
172 | |
173 | |
174 | EXCEPTIONS RAISED |
175 | |
176 | KNOWN BUGS |
177 | |
178 | NOTES |
179 | |
180 | HISTORY |
181 | Harish Ekkirala Created 02/26/2001. |
182 | |
183 *----------------------------------------------------------------------------*/
184
185 PROCEDURE MERGE_SHIPMENTS(
186 P_entity_name IN VARCHAR2,
187 P_from_id IN NUMBER,
188 X_to_id OUT NOCOPY NUMBER,
189 P_from_fk_id IN NUMBER,
190 P_to_fk_id IN NUMBER,
191 P_parent_entity_name IN VARCHAR2,
192 P_batch_id IN NUMBER,
193 P_batch_party_id IN NUMBER,
194 X_return_status OUT NOCOPY VARCHAR2
195 );
196
197 End ASO_MERGE_PVT;
|
|
|