1 PACKAGE AR_MCC_MERGE AUTHID CURRENT_USER AS
2 /* $Header: ARXCMCRS.pls 115.0 2003/08/07 21:02:57 apandit noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2001 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| ARXCMCRS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Spec of AR_MCC_MERGE |
13 --| |
14 --| PUBLIC PROCEDURES |
15 --| Customer_Merge |
16 --| Note: This procedure will be called by the main Customer Merge(TCA) |
17 --| feature |
18 --| |
19 --| HISTORY |
20 --| 09/07/2001 vjavli Created |
21 --| |
22 --+======================================================================*/
23
24
25 --===================
26 -- CONSTANTS
27 --===================
28
29 G_LOG_ERROR CONSTANT NUMBER := 5;
30 G_LOG_EXCEPTION CONSTANT NUMBER := 4;
31 G_LOG_EVENT CONSTANT NUMBER := 3;
32 G_LOG_PROCEDURE CONSTANT NUMBER := 2;
33 G_LOG_STATEMENT CONSTANT NUMBER := 1;
34
35 --========================================================================
36 -- PROCEDURE : Customer_merge PUBLIC
37 -- PARAMETERS: req_id IN NUMBER Concurrent process request id
38 -- set_number IN NUMBER Set Number
39 -- process_mode IN VARCHAR2 Process mode of the called
40 -- program
41 -- COMMENT : This procedure deletes the records from the table
42 -- HZ_CREDIT_USAGES for the corresponding customer Ids in
43 -- RA_CUSTOMER_MERGE
44 --=========================================================================
45 PROCEDURE Customer_Merge
46 ( req_id IN NUMBER
47 ,set_number IN NUMBER
48 ,process_mode IN VARCHAR2
49 );
50
51 END AR_MCC_MERGE;