1 PACKAGE IGS_PARTY_MERGE AUTHID CURRENT_USER AS
2 /* $Header: IGSPE06S.pls 115.6 2003/05/30 07:51:52 npalanis noship $ */
3
4 /* This package is to incorporate the Oracle Student System Requirement
5 for the R11i.1+Party Merge DLD TCA
6 Change History
7 Who When What
8 npalanis 16-may-2003 Bug : 2853529
9 Merge party relations new procedure added*/
10
11
12 PROCEDURE MERGE_PARTY (
13 P_Entity_Name IN VARCHAR2,
14 P_From_Id IN NUMBER,
15 P_To_Id IN OUT NOCOPY NUMBER,
16 P_From_FK_Id IN NUMBER,
17 P_To_FK_Id IN NUMBER,
18 P_Parent_Entity_Name IN VARCHAR2,
19 P_Batch_Id IN NUMBER,
20 P_Batch_Party_Id IN NUMBER,
21 X_Return_Status IN OUT NOCOPY VARCHAR2
22
23 );
24
25 PROCEDURE MERGE_PERSON_PROFILE (
26 P_Entity_Name IN VARCHAR2,
27 P_From_Id IN NUMBER,
28 P_To_Id IN OUT NOCOPY NUMBER,
29 P_From_FK_Id IN NUMBER,
30 P_To_FK_Id IN NUMBER,
31 P_Parent_Entity_Name IN VARCHAR2,
32 P_Batch_Id IN NUMBER,
33 P_Batch_Party_Id IN NUMBER,
34 X_Return_Status IN OUT NOCOPY VARCHAR2
35
36 );
37
38
39 PROCEDURE MERGE_EDUCATION (
40 P_Entity_Name IN VARCHAR2,
41 P_From_Id IN NUMBER,
42 P_To_Id IN OUT NOCOPY NUMBER,
43 P_From_FK_Id IN NUMBER,
44 P_To_FK_Id IN NUMBER,
45 P_Parent_Entity_Name IN VARCHAR2,
46 P_Batch_Id IN NUMBER,
47 P_Batch_Party_Id IN NUMBER,
48 X_Return_Status IN OUT NOCOPY VARCHAR2
49
50 );
51
52 PROCEDURE MERGE_ACAD_HIST (
53 P_Entity_Name IN VARCHAR2,
54 P_From_Id IN NUMBER,
55 P_To_Id IN OUT NOCOPY NUMBER,
56 P_From_FK_Id IN NUMBER,
57 P_To_FK_Id IN NUMBER,
58 P_Parent_Entity_Name IN VARCHAR2,
59 P_Batch_Id IN NUMBER,
60 P_Batch_Party_Id IN NUMBER,
61 X_Return_Status IN OUT NOCOPY VARCHAR2
62
63 );
64
65 PROCEDURE MERGE_PARTY_REL (
66 P_Entity_Name IN VARCHAR2,
67 P_From_Id IN NUMBER,
68 P_To_Id IN OUT NOCOPY NUMBER,
69 P_From_FK_Id IN NUMBER,
70 P_To_FK_Id IN NUMBER,
71 P_Parent_Entity_Name IN VARCHAR2,
72 P_Batch_Id IN NUMBER,
73 P_Batch_Party_Id IN NUMBER,
74 X_Return_Status IN OUT NOCOPY VARCHAR2
75
76 );
77
78 PROCEDURE MERGE_EMP_DTL (
79 P_Entity_Name IN VARCHAR2,
80 P_From_Id IN NUMBER,
81 P_To_Id IN OUT NOCOPY NUMBER,
82 P_From_FK_Id IN NUMBER,
83 P_To_FK_Id IN NUMBER,
84 P_Parent_Entity_Name IN VARCHAR2,
85 P_Batch_Id IN NUMBER,
86 P_Batch_Party_Id IN NUMBER,
87 X_Return_Status IN OUT NOCOPY VARCHAR2
88
89 );
90
91 PROCEDURE MERGE_EXTRACURR_ACT (
92 P_Entity_Name IN VARCHAR2,
93 P_From_Id IN NUMBER,
94 P_To_Id IN OUT NOCOPY NUMBER,
95 P_From_FK_Id IN NUMBER,
96 P_To_FK_Id IN NUMBER,
97 P_Parent_Entity_Name IN VARCHAR2,
98 P_Batch_Id IN NUMBER,
99 P_Batch_Party_Id IN NUMBER,
100 X_Return_Status IN OUT NOCOPY VARCHAR2
101
102 );
103
104
105 END IGS_PARTY_MERGE;