1 PACKAGE BODY OE_MGD_MCC_MERGE AS
2 /* $Header: OEXCMCRB.pls 120.1 2006/03/29 16:42:18 spooruli noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2001 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| OEXCMCRB.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Package body of OE_MGD_MCC_MERGE |
13 --| |
14 --| PUBLIC PROCEDURES |
15 --| Customer_Merge |
16 --| Note: This procedure is OBSOLETE. This is now handled by an AR |
17 --| package since the table is HZ. Previously, it was called by the main |
18 --| Customer Merge(TCA) feature. |
19 --| |
20 --| HISTORY |
21 --| 09/07/2001 vjavli Created |
22 --| |
23 --| 09/17/2001 vjavli modified to have cursor for duplicate_id |
24 --| 10/09/2002 vjavli Bug#2619854 fix: COMMIT removed |
25 --| records will be deleted in full and not in |
26 --| batches |
27 --| 01/28/2003 vjavli Bug#2447520 fix: TCA enhancments to insert |
28 --| deleted record in the log table |
29 --| 08/07/2003 vto bug 3089178. stub out this file. |
30 --+======================================================================*/
31
32 --=================
33 -- CONSTANTS
34 --=================
35 G_OE_MGD_MCC_MERGE VARCHAR2(30) := 'OE_MGD_MCC_MERGE';
36
37 --====================
38 -- Debug log variables
39 --====================
40 g_log_level NUMBER := NULL; -- 0 for manual test
41 g_log_mode VARCHAR2(3) := 'OFF'; -- possible values: OFF, SQL, SRS
42
43 --=====================================
44 -- PRIVATE VARIABLES
45 --=====================================
46 g_count NUMBER := 0;
47
48 --========================================================================
49 -- PROCEDURE : Log_Initialize PRIVATE OBSOLETE
50 -- COMMENT : Initializes the log facility. It should be called from
51 -- the top level procedure of each concurrent program
52 --=======================================================================--
53 PROCEDURE Log_Initialize
54 IS
55 BEGIN
56 NULL;
57 END Log_Initialize;
58
59
60 --========================================================================
61 -- PROCEDURE : Log PRIVATE OBSOLETE
62 -- PARAMETERS: p_level IN priority of the message - from
63 -- highest to lowest:
64 -- -- G_LOG_ERROR
65 -- -- G_LOG_EXCEPTION
66 -- -- G_LOG_EVENT
67 -- -- G_LOG_PROCEDURE
68 -- -- G_LOG_STATEMENT
69 -- p_msg IN message to be print on the log
70 -- file
71 -- COMMENT : Add an entry to the log
72 --========================================================================
73 PROCEDURE Log
74 ( p_priority IN NUMBER
75 , p_msg IN VARCHAR2
76 )
77 IS
78 BEGIN
79 NULL;
80 END Log;
81
82 --=========================================================================
83 -- PROCEDURE : Customer_merge PUBLIC OBSOLETE
84 -- PARAMETERS: req_id IN NUMBER Concurrent process request id
85 -- set_number IN NUMBER Set Number
86 -- process_mode IN VARCHAR2 Process mode of the called
87 -- program
88 -- COMMENT : This procedure deletes the records from the table
89 -- HZ_CREDIT_USAGES for the corresponding customer Ids in
90 -- RA_CUSTOMER_MERGES
91 --=========================================================================
92 PROCEDURE Customer_Merge
93 ( req_id IN NUMBER
94 ,set_number IN NUMBER
95 ,process_mode IN VARCHAR2
96 ) IS
97
98 BEGIN
99 NULL;
100 END Customer_Merge;
101
102 END OE_MGD_MCC_MERGE;