APPS.CSP_CMERGE dependencies on CSP_CMERGE

Line 1: PACKAGE BODY CSP_CMERGE as

1: PACKAGE BODY CSP_CMERGE as
2: /* $Header: cscm100b.pls 115.1 99/09/13 16:55:11 porting ship $ */
3:
4: /* Call all the blocks to update all the table for Service merge.
5: Below is a diagram of the calling sequence.

Line 7: CSP_CMERGE.MERGE ( all tables for CS )

3:
4: /* Call all the blocks to update all the table for Service merge.
5: Below is a diagram of the calling sequence.
6:
7: CSP_CMERGE.MERGE ( all tables for CS )
8: |
9: |---CSP_CMERGE_BB1.MERGE ( table cs_access_control_templates )
10: | |
11: | CS_MERGE_SYS_INSTALL_SITE_ID

Line 9: |---CSP_CMERGE_BB1.MERGE ( table cs_access_control_templates )

5: Below is a diagram of the calling sequence.
6:
7: CSP_CMERGE.MERGE ( all tables for CS )
8: |
9: |---CSP_CMERGE_BB1.MERGE ( table cs_access_control_templates )
10: | |
11: | CS_MERGE_SYS_INSTALL_SITE_ID
12: | CS_MERGE_SYS_SHIP_USE_ID
13: | CS_MERGE_CP_INSTALL_SITE_ID

Line 18: |---CSP_CMERGE_BB2.MERGE ( table cs_customer_products )

14: | CS_MERGE_CP_SHIP_SITE_ID
15: | CS_MERGE_CUSTOMER_ID
16: | CS_CHECK_MERGE_DATA
17: |
18: |---CSP_CMERGE_BB2.MERGE ( table cs_customer_products )
19: | |
20: | CS_MERGE_BILL_TO_SITE_ID
21: | CS_MERGE_INSTALL_SITE_ID
22: | CS_MERGE_SHIP_TO_SITE_ID

Line 27: |---CSP_CMERGE_BB3.MERGE ( table cs_systems )

23: | CS_MERGE_ORDER_BILL_TO_SITE_ID
24: | CS_MERGE_ORDER_SHIP_TO_SITE_ID
25: | CS_MERGE_CUSTOMER_ID
26: |
27: |---CSP_CMERGE_BB3.MERGE ( table cs_systems )
28: | |
29: | CS_MERGE_BILL_TO_SITE_ID
30: | CS_MERGE_INSTALL_SITE_ID
31: | CS_MERGE_SHIP_TO_SITE_ID

Line 35: |---CSP_CMERGE_BB4.MERGE ( table cs_templates_interface )

31: | CS_MERGE_SHIP_TO_SITE_ID
32: | CS_MERGE_CUSTOMER_ID
33: | CS_CHECK_MERGE_DATA
34: |
35: |---CSP_CMERGE_BB4.MERGE ( table cs_templates_interface )
36: | |
37: | CS_MERGE_SYS_INSTALL_SITE_ID
38: | CS_MERGE_SYS_SHIP_TO_SITE_ID
39: | CS_MERGE_CP_INSTALL_SITE_ID

Line 45: |---CSP_CMERGE_BB5.MERGE ( table cs_mass_notification_txns_temp )

41:
42: | CS_MERGE_CUSTOMER_ID
43: | CS_CHECK_MERGE_DATA
44: |
45: |---CSP_CMERGE_BB5.MERGE ( table cs_mass_notification_txns_temp )
46: | |
47: | CS_MERGE_CUSTOMER_ID
48: |
49: |---CSP_CMERGE_BB6.MERGE ( table cs_mass_service_txns_temp )

Line 49: |---CSP_CMERGE_BB6.MERGE ( table cs_mass_service_txns_temp )

45: |---CSP_CMERGE_BB5.MERGE ( table cs_mass_notification_txns_temp )
46: | |
47: | CS_MERGE_CUSTOMER_ID
48: |
49: |---CSP_CMERGE_BB6.MERGE ( table cs_mass_service_txns_temp )
50: |
51: | CS_MERGE_CUSTOMER_ID
52: |
53: |---CSP_CMERGE_BB7.MERGE (table cs_repairs)

Line 53: |---CSP_CMERGE_BB7.MERGE (table cs_repairs)

49: |---CSP_CMERGE_BB6.MERGE ( table cs_mass_service_txns_temp )
50: |
51: | CS_MERGE_CUSTOMER_ID
52: |
53: |---CSP_CMERGE_BB7.MERGE (table cs_repairs)
54: | |
55: | RMA_CUSTOMER_ID
56: |
57: |---CSP_CMERGE_BB8.MERGE (table cs_incidents)

Line 57: |---CSP_CMERGE_BB8.MERGE (table cs_incidents)

53: |---CSP_CMERGE_BB7.MERGE (table cs_repairs)
54: | |
55: | RMA_CUSTOMER_ID
56: |
57: |---CSP_CMERGE_BB8.MERGE (table cs_incidents)
58: | |
59: | CUSTOMER_ID
60: | SHIP_TO_SITE_USE_ID
61: | BILL_TO_SITE_USE_ID

Line 97: CSP_CMERGE_BB1.MERGE ( req_id,

93:
94: message_text := '******** -- STARTING THE MERGE PROCESS FOR CUSTOMER SERVICE -- ********';
95: arp_message.put_line(message_text);
96:
97: CSP_CMERGE_BB1.MERGE ( req_id,
98: set_number,
99: process_mode );
100:
101: CSP_CMERGE_BB2.MERGE ( req_id,

Line 101: CSP_CMERGE_BB2.MERGE ( req_id,

97: CSP_CMERGE_BB1.MERGE ( req_id,
98: set_number,
99: process_mode );
100:
101: CSP_CMERGE_BB2.MERGE ( req_id,
102: set_number,
103: process_mode );
104:
105: CSP_CMERGE_BB3.MERGE ( req_id,

Line 105: CSP_CMERGE_BB3.MERGE ( req_id,

101: CSP_CMERGE_BB2.MERGE ( req_id,
102: set_number,
103: process_mode );
104:
105: CSP_CMERGE_BB3.MERGE ( req_id,
106: set_number,
107: process_mode );
108:
109: CSP_CMERGE_BB4.MERGE ( req_id,

Line 109: CSP_CMERGE_BB4.MERGE ( req_id,

105: CSP_CMERGE_BB3.MERGE ( req_id,
106: set_number,
107: process_mode );
108:
109: CSP_CMERGE_BB4.MERGE ( req_id,
110: set_number,
111: process_mode );
112:
113: CSP_CMERGE_BB5.MERGE ( req_id,

Line 113: CSP_CMERGE_BB5.MERGE ( req_id,

109: CSP_CMERGE_BB4.MERGE ( req_id,
110: set_number,
111: process_mode );
112:
113: CSP_CMERGE_BB5.MERGE ( req_id,
114: set_number,
115: process_mode );
116:
117: CSP_CMERGE_BB6.MERGE ( req_id,

Line 117: CSP_CMERGE_BB6.MERGE ( req_id,

113: CSP_CMERGE_BB5.MERGE ( req_id,
114: set_number,
115: process_mode );
116:
117: CSP_CMERGE_BB6.MERGE ( req_id,
118: set_number,
119: process_mode );
120:
121: CSP_CMERGE_BB7.MERGE ( req_id,

Line 121: CSP_CMERGE_BB7.MERGE ( req_id,

117: CSP_CMERGE_BB6.MERGE ( req_id,
118: set_number,
119: process_mode );
120:
121: CSP_CMERGE_BB7.MERGE ( req_id,
122: set_number,
123: process_mode );
124:
125: CSP_CMERGE_BB8.MERGE ( req_id,

Line 125: CSP_CMERGE_BB8.MERGE ( req_id,

121: CSP_CMERGE_BB7.MERGE ( req_id,
122: set_number,
123: process_mode );
124:
125: CSP_CMERGE_BB8.MERGE ( req_id,
126: set_number,
127: process_mode );
128:
129: message_text := '******** -- MERGE PROCESS FOR CUSTOMER SERVICE HAS COMPLETED -- ********';

Line 137: END CSP_CMERGE;

133:
134: END MERGE;
135:
136:
137: END CSP_CMERGE;