DBA Data[Home] [Help]

PACKAGE: APPS.CSC_ACCOUNT_MERGE_PKG

Source


1 PACKAGE CSC_ACCOUNT_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: cscvmacs.pls 115.1 2003/05/12 11:40:07 bhroy noship $ */
3 -- Start of Comments
4 -- Package name     : CSC_ACCOUNT_MERGE_PKG
5 -- Purpose          : Merges duplicate customer accounts in Customer Care
6 --                    tables.
7 --
8 -- History
9 -- MM-DD-YYYY    NAME          MODIFICATIONS
10 -- 10-06-2000    dejoseph      Created.
11 -- 12-02-2003	 bhroy		All parameter names changed to match with the prcedures generated by Perl script, i.e p_request_id -> req_id, p_set_number -> set_num, p_process_mode -> process_mode
12 --
13 -- End of Comments
14 
15 -- Global variable declarations
16    G_PROC_NAME               CONSTANT VARCHAR2(30)  := 'CSC_ACCOUNT_MERGE_PKG';
17    G_FILE_NAME               CONSTANT VARCHAR2(12)  := 'cscvmacs.pls';
18 
19    --   *******************************************************
20    --    Start of Comments
21    --   *******************************************************
22    --   API Name:  csc_merge_all_accounts
23    --   Purpose :  Calls all the individually defined account merge procedures
24    --              of Customer Care. This proc. is not being used, but can be
25    --              used in future as a single call out from the main TCA proc.
26    --              to merge all accounts in Customer Care tables.
27    --   Type    :  Private
28    --   Pre-Req :  None.
29    --   Parameters:
30    --   IN
31    --       req_id              IN   NUMBER     Required
32    --       set_num              IN   NUMBER     Required
33    --       process_mode            IN   VARCHAR2   Optional  Default = 'LOCK'
34    --   OUT:
35    --
36    --   Version : Current version 1.0
37    --
38    --   End of Comments
39    --
40 PROCEDURE CSC_MERGE_ALL_ACCOUNTS (
41     req_id                 IN   NUMBER,
42     set_num                 IN   NUMBER,
43     process_mode               IN   VARCHAR2   := 'LOCK' );
44 
45    --   *******************************************************
46    --    Start of Comments
47    --   *******************************************************
48    --   API Name:  csc_customers_merge
49    --   Purpose :  Merges duplicate customer accounts in CSC_CUSTOMERS table.
50    --   Type    :  Private
51    --   Pre-Req :  None.
52    --   Parameters:
53    --   IN
54    --       req_id              IN   NUMBER     Required
55    --       set_num              IN   NUMBER     Required
56    --       process_mode            IN   VARCHAR2   Optional  Default = 'LOCK'
57    --   OUT:
58    --
59    --   Version : Current version 1.0
60    --
61    --   End of Comments
62    --
63 PROCEDURE CSC_CUSTOMERS_MERGE (
64     req_id                 IN   NUMBER,
65     set_num                IN   NUMBER,
66     process_mode           IN   VARCHAR2   := 'LOCK' );
67 
68    --   *******************************************************
69    --    Start of Comments
70    --   *******************************************************
71    --   API Name:  csc_customers_audit_hist_merge
72    --   Purpose :  Merges duplicate customer accounts in
73    --              CSC_CUSTOMERS_AUDIT_HIST table.
74    --   Type    :  Private
75    --   Pre-Req :  None.
76    --   Parameters:
77    --   IN
78    --       req_id              IN   NUMBER     Required
79    --       set_num              IN   NUMBER     Required
80    --       process_mode            IN   VARCHAR2   Optional  Default = 'LOCK'
81    --   OUT:
82    --
83    --   Version : Current version 1.0
84    --
85    --   End of Comments
86    --
87 PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (
88     req_id                 IN   NUMBER,
89     set_num                 IN   NUMBER,
90     process_mode               IN   VARCHAR2   := 'LOCK' );
91 
92    --   *******************************************************
93    --    Start of Comments
94    --   *******************************************************
95    --   API Name:  csc_customized_plans_merge
96    --   Purpose :  Merges duplicate customer accounts in
97    --              CSC_CUSTOMIZED_PLANS table.
98    --   Type    :  Private
99    --   Pre-Req :  None.
100    --   Parameters:
101    --   IN
102    --       req_id              IN   NUMBER     Required
103    --       set_num              IN   NUMBER     Required
104    --       process_mode            IN   VARCHAR2   Optional  Default = 'LOCK'
105    --   OUT:
106    --
107    --   Version : Current version 1.0
108    --
109    --   End of Comments
110    --
111 PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (
112     req_id                 IN   NUMBER,
113     set_num                 IN   NUMBER,
114     process_mode               IN   VARCHAR2   := 'LOCK' );
115 
116    --   *******************************************************
117    --    Start of Comments
118    --   *******************************************************
119    --   API Name:  csc_cust_plans_merge
120    --   Purpose :  Merges duplicate customer accounts in
121    --              CSC_CUST_PLANS table.
122    --   Type    :  Private
123    --   Pre-Req :  None.
124    --   Parameters:
125    --   IN
126    --       req_id              IN   NUMBER     Required
127    --       set_num              IN   NUMBER     Required
128    --       process_mode            IN   VARCHAR2   Optional  Default = 'LOCK'
129    --   OUT:
130    --
131    --   Version : Current version 1.0
132    --
133    --   End of Comments
134    --
135 PROCEDURE CSC_CUST_PLANS_MERGE (
136     req_id                 IN   NUMBER,
137     set_num                 IN   NUMBER,
138     process_mode               IN   VARCHAR2   := 'LOCK' );
139 
140    --   *******************************************************
141    --    Start of Comments
142    --   *******************************************************
143    --   API Name:  csc_cust_plans_audit_merge
144    --   Purpose :  Merges duplicate customer accounts in
145    --              CSC_CUST_PLANS_AUDIT table.
146    --   Type    :  Private
147    --   Pre-Req :  None.
148    --   Parameters:
149    --   IN
150    --       req_id              IN   NUMBER     Required
151    --       set_num              IN   NUMBER     Required
152    --       process_mode            IN   VARCHAR2   Optional  Default = 'LOCK'
153    --   OUT:
154    --
155    --   Version : Current version 1.0
156    --
157    --   End of Comments
158    --
159 PROCEDURE CSC_CUST_PLANS_AUDIT_MERGE (
160     req_id                 IN   NUMBER,
161     set_num                 IN   NUMBER,
162     process_mode               IN   VARCHAR2   := 'LOCK' );
163 
164 END  CSC_ACCOUNT_MERGE_PKG;