PACKAGE: APPS.ARP_CMERGE_ARCUS

Source

1 PACKAGE ARP_CMERGE_ARCUS AUTHID CURRENT_USER AS
2 /* $Header: ARHCMGNS.pls 120.4.12020000.2 2013/03/01 08:41:17 vsegu ship $ */
3 
4   g_table_name               CONSTANT VARCHAR2(30) :=
5                                    'HZ_CMERGE_TEMP';
6   g_transfer_account_contacts        VARCHAR2(10) := fnd_profile.value('HZ_CM_TRANSFER_ACCOUNT_CONTACTS');
7 
8 --fnd_profile.value('HZ_TRANSFER_CONTACTS');
9 
10   PROCEDURE merge (
11          req_id                    NUMBER,
12          set_num                   NUMBER,
13          process_mode              VARCHAR2 );
14 
15   --create sites where 'create same site' option has been checked
16   procedure create_same_sites (
17             req_id                 NUMBER,
18             set_num                NUMBER,
19             status             OUT NOCOPY NUMBER,
20 	    error_text         OUT NOCOPY VARCHAR2 );
21 
22   --create global temporary table.
23   PROCEDURE create_temporary_table;
24 
25   --physically delete rows in customer tables after merging each set.
26   PROCEDURE delete_rows (
27          req_id                    NUMBER,
28          set_num                   NUMBER );
29 
30    PROCEDURE merge_history(req_id  NUMBER,
31                            set_num NUMBER,
32                            status  OUT NOCOPY NUMBER);
33 
34 END ARP_CMERGE_ARCUS;