PACKAGE: APPS.ARP_CMERGE_ARCUS

Source

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