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