[Home] [Help]
PACKAGE: APPS.CSP_CMERGE
Source
1 PACKAGE CSP_CMERGE AUTHID CURRENT_USER as
2 /* $Header: cscm100s.pls 115.0 99/07/16 08:47:19 porting ship $ */
3
4 /* This is the main process that calls all the building blocks for the
5 customer merge for the service data base.
6 There are three blocks, each block is reponsible for doing a complete
7 merge of a table to be merged. Within each building block there is
8 a procedure 'merge' that calls locall routines that merge the different
9 fields of the table. Below is a diagram of the calling sequence.
10
11 CSP_CMERGE.MERGE ( all tables for CS )
12 |
13 |---CSP_CMERGE_BB1.MERGE ( table cs_access_control_templates )
14 | |
15 | CS_MERGE_SYS_INSTALL_SITE_ID
16 | CS_MERGE_SYS_SHIP_USE_ID
17 | CS_MERGE_CP_INSTALL_SITE_ID
18 | CS_MERGE_CP_SHIP_SITE_ID
19 | CS_MERGE_CUSTOMER_ID
20 | CS_CHECK_MERGE_DATA
21 |
22 |---CSP_CMERGE_BB2.MERGE ( table cs_customer_products )
23 | |
24 | CS_MERGE_BILL_TO_SITE_ID
25 | CS_MERGE_INSTALL_SITE_ID
26 | CS_MERGE_SHIP_TO_SITE_ID
27 | CS_MERGE_ORDER_BILL_TO_SITE_ID
28 | CS_MERGE_ORDER_SHIP_TO_SITE_ID
29 | CS_MERGE_CUSTOMER_ID
30 |
31 |---CSP_CMERGE_BB3.MERGE ( table cs_systems )
32 | |
33 | CS_MERGE_BILL_TO_SITE_ID
34 | CS_MERGE_INSTALL_SITE_ID
35 | CS_MERGE_SHIP_TO_SITE_ID
36 | CS_MERGE_CUSTOMER_ID
37 | CS_CHECK_MERGE_DATA
38 |
39 |---CSP_CMERGE_BB4.MERGE ( table cs_templates_interface )
40 | |
41 | CS_MERGE_SYS_INSTALL_SITE_ID
42 | CS_MERGE_SYS_SHIP_TO_SITE_ID
43 | CS_MERGE_CP_INSTALL_SITE_ID
44 | CS_MERGE_CP_SHIP_TO_SITE_ID
45 | CS_MERGE_CUSTOMER_ID
46 | CS_CHECK_MERGE_DATA
47 |
48 |---CSP_CMERGE_BB5.MERGE ( table cs_mass_notification_txns_temp )
49 | |
50 | CS_MERGE_CUSTOMER_ID
51 |
52 |---CSP_CMERGE_BB6.MERGE ( table cs_mass_service_txns_temp )
53 | |
54 | CS_MERGE_CUSTOMER_ID
55 |
56 |---CSP_CMERGE_BB7.MERGE (table cs_repairs)
57 | |
58 | RMA_CUSTOMER_ID
59 |
60 |---CSP_CMERGE_BB8.MERGE (table cs_incidents)
61 | |
62 | CUSTOMER_ID
63 | SHIP_TO_SITE_USE_ID
64 | BILL_TO_SITE_USE_ID
65 | INSTALL_TO_SITE_USE_ID
66
67
68
69
70
71 */
72
73 PROCEDURE MERGE ( req_id IN NUMBER,
74 set_number IN NUMBER,
75 process_mode IN VARCHAR2 );
76
77
78 END CSP_CMERGE;