PACKAGE: APPS.JTF_IH_MERGE_PKG

Source

1 PACKAGE JTF_IH_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: JTFIHAMS.pls 115.9 2003/01/10 20:37:06 ialeshin ship $ */
3 
4 
5 -- Start of Comments
6 -- Package name     : JTF_IH_MERGE
7 -- Purpose          : Merges duplicate customer accounts in Interaction History Table
8 --                    JTF_IH_ACTIVITIES.
9 --
10 -- History
11 -- MM-DD-YYYY    NAME          		MODIFICATIONS
12 -- 11-17-2000    James Baldo Jr.      	Created
13 --
14 -- End of Comments
15 
16 -- Global variable declarations
17    G_PROC_NAME               CONSTANT VARCHAR2(30)  := 'JTF_IH_MERGE';
18    G_FILE_NAME               CONSTANT VARCHAR2(12)  := 'JTFIHAMS.pls';
19 
20 
21 
22    PROCEDURE MERGE(req_id   IN NUMBER,
23                    set_number   IN NUMBER,
24                    process_mode IN VARCHAR2);
25    --   *******************************************************
26    --    Start of Comments
27    --   *******************************************************
28    --   API Name:  MERGE
29    --   Purpose :  Calls all the individually defined account merge procedures
30    --              of Interaction History.
31    --   Type    :  Private
32    --   Pre-Req :  None.
33    --   Parameters:
34    --   IN
35    --       p_request_id              IN   NUMBER     Required
36    --       p_set_number              IN   NUMBER     Required
37    --       p_process_mode            IN   VARCHAR2   Optional  Default = 'LOCK'
38    --   OUT:
39    --
40    --   Version : Current version 1.0
41    --
42    --   End of Comments
43    --
44 
45 
46    PROCEDURE JTF_IH_MERGE(req_id   IN NUMBER,
47 	   		  set_num   IN NUMBER,
48 			  process_mode IN VARCHAR2);
49    --   *******************************************************
50    --    Start of Comments
51    --   *******************************************************
52    --   API Name:  JTF_IH_MERGE
53    --   Purpose :  Called by MERGE to update account for Interaction History table
54    --              JTF_IH_ACTIVITIES.
55    --   Type    :  Private
56    --   Pre-Req :  None.
57    --   Parameters:
58    --   IN
59    --       p_request_id              IN   NUMBER     Required
60    --       p_set_number              IN   NUMBER     Required
61    --       p_process_mode            IN   VARCHAR2   Optional  Default = 'LOCK'
62    --   OUT:
63    --
64    --   Version : Current version 1.0
65    --
66    --   End of Comments
67    --
68 
69 
70 
71 END JTF_IH_MERGE_PKG;