DBA Data[Home] [Help]

PACKAGE: APPS.OE_PAYMENT_DATA_MIGRATION_UTIL

Source


1 PACKAGE OE_Payment_Data_Migration_Util AUTHID CURRENT_USER AS
2 -- $Header: OEXUPDMS.pls 120.2.12010000.2 2008/08/04 15:04:33 amallik ship $
3 --+=======================================================================+
4 --|               Copyright (c) 2000 Oracle Corporation                   |
5 --|                       Redwood Shores, CA, USA                         |
6 --|                         All rights reserved.                          |
7 --+=======================================================================+
8 --| FILENAME                                                              |
9 --|    OEXUPDMS.pls                                                       |
10 --|                                                                       |
11 --| DESCRIPTION                                                           |
12 --|     Package Spec of OE_Payment_Data_Migration_Util                    |
13 --|                                                                       |
14 --| PROCEDURE LIST                                                        |
15 --|     Migrate_Data_MGR                                                  |
16 --|     Migrate_Data_WKR                                                  |
17 --|     Purge_Data_MGR                                                    |
18 --|     Purge_Data_WKR                                                    |
19 --|                                                                       |
20 --| HISTORY                                                               |
21 --|    JUN-25-2005 Initial Creation                                       |
22 --|                                                                       |
23 --|=======================================================================+
24 
25 PROCEDURE Migrate_Data_MGR
26 (   X_errbuf       OUT NOCOPY VARCHAR2,
27     X_retcode      OUT NOCOPY VARCHAR2,
28     X_batch_size    IN NUMBER,
29     X_Num_Workers   IN NUMBER
30 ) ;
31 
32 PROCEDURE Migrate_Data_WKR
33 (   X_errbuf       OUT NOCOPY VARCHAR2,
34     X_retcode      OUT NOCOPY VARCHAR2,
35     X_batch_size    IN NUMBER,
36     X_Worker_Id     IN NUMBER,
37     X_Num_Workers   IN NUMBER
38 ) ;
39 
40 PROCEDURE Purge_Data_MGR
41 (   X_errbuf       OUT NOCOPY VARCHAR2,
42     X_retcode      OUT NOCOPY VARCHAR2,
43     X_batch_size    IN NUMBER,
44     X_Num_Workers   IN NUMBER
45 ) ;
46 
47 PROCEDURE Purge_Data_WKR
48 (   X_errbuf       OUT NOCOPY VARCHAR2,
49     X_retcode      OUT NOCOPY VARCHAR2,
50     X_batch_size    IN NUMBER,
51     X_Worker_Id     IN NUMBER,
52     X_Num_Workers   IN NUMBER
53 ) ;
54 
55 --6757060
56 Function Strip_Non_Numeric_Char(
57    p_credit_card_num IN  iby_ext_bank_accounts_v.bank_account_number%TYPE
58    )
59 RETURN VARCHAR2 ;
60 --6757060
61 
62 END OE_Payment_Data_Migration_Util ;