DBA Data[Home] [Help]

PACKAGE: APPS.IGW_PARTY_MERGE_PUB

Source


1 PACKAGE IGW_PARTY_MERGE_PUB AUTHID CURRENT_USER as
2 --$Header: igwtcaps.pls 115.4 2002/11/14 18:48:35 vmedikon noship $
3 G_package_name   VARCHAR2(30)  := 'IGW_PARTY_MERGE_PUB';
4 
5 PROCEDURE person_degrees_party_merge(
6                            p_entity_name                IN   VARCHAR2,
7                            p_from_id                    IN   NUMBER,
8                            x_to_id                      OUT NOCOPY  NUMBER,
9               		   p_from_fk_id                 IN   NUMBER,
10                            p_to_fk_id                   IN   NUMBER,
11                            p_parent_entity_name         IN   VARCHAR2,
12 			   p_batch_id                   IN   NUMBER,
13 			   p_batch_party_id             IN   NUMBER,
14 			   x_return_status              OUT NOCOPY  VARCHAR2);
15 
16 
17 PROCEDURE person_biosketch_party_merge(
18                            p_entity_name                IN   VARCHAR2,
19                            p_from_id                    IN   NUMBER,
20                            x_to_id                      OUT NOCOPY  NUMBER,
21                		   p_from_fk_id                 IN   NUMBER,
22                            p_to_fk_id                   IN   NUMBER,
23                            p_parent_entity_name         IN   VARCHAR2,
24 			   p_batch_id                   IN   NUMBER,
25 			   p_batch_party_id             IN   NUMBER,
26 			   x_return_status              OUT NOCOPY  VARCHAR2);
27 
28 
29 PROCEDURE prop_location_party_merge(
30                            p_entity_name                IN   VARCHAR2,
31                            p_from_id                    IN   NUMBER,
32                            x_to_id                      OUT NOCOPY  NUMBER,
33                		   p_from_fk_id                 IN   NUMBER,
34                            p_to_fk_id                   IN   NUMBER,
35                            p_parent_entity_name         IN   VARCHAR2,
36 			   p_batch_id                   IN   NUMBER,
37 			   p_batch_party_id             IN   NUMBER,
38 			   x_return_status              OUT NOCOPY  VARCHAR2);
39 
40 
41 PROCEDURE prop_person_party_merge(
42                            p_entity_name                IN   VARCHAR2,
43                            p_from_id                    IN   NUMBER,
44                            x_to_id                      OUT NOCOPY  NUMBER,
45                		   p_from_fk_id                 IN   NUMBER,
46                            p_to_fk_id                   IN   NUMBER,
47                            p_parent_entity_name         IN   VARCHAR2,
48 			   p_batch_id                   IN   NUMBER,
49 			   p_batch_party_id             IN   NUMBER,
50 			   x_return_status              OUT NOCOPY  VARCHAR2);
51 
52 
53 PROCEDURE prop_org_party_merge(
54                            p_entity_name                IN   VARCHAR2,
55                            p_from_id                    IN   NUMBER,
56                            x_to_id                      OUT NOCOPY  NUMBER,
57                		   p_from_fk_id                 IN   NUMBER,
58                            p_to_fk_id                   IN   NUMBER,
59                            p_parent_entity_name         IN   VARCHAR2,
60 			   p_batch_id                   IN   NUMBER,
61 			   p_batch_party_id             IN   NUMBER,
62 			   x_return_status              OUT NOCOPY  VARCHAR2);
63 
64 PROCEDURE other_support_location_merge (
65                            p_entity_name                IN   VARCHAR2,
66                            p_from_id                    IN   NUMBER,
67                            x_to_id                      OUT NOCOPY  NUMBER,
68                		   p_from_fk_id                 IN   NUMBER,
69                            p_to_fk_id                   IN   NUMBER,
70                            p_parent_entity_name         IN   VARCHAR2,
71 			   p_batch_id                   IN   NUMBER,
72 			   p_batch_party_id             IN   NUMBER,
73 			   x_return_status              OUT NOCOPY  VARCHAR2);
74 
75 PROCEDURE other_support_pi_party_merge (
76                            p_entity_name                IN   VARCHAR2,
77                            p_from_id                    IN   NUMBER,
78                            x_to_id                      OUT NOCOPY  NUMBER,
79                		   p_from_fk_id                 IN   NUMBER,
80                            p_to_fk_id                   IN   NUMBER,
81                            p_parent_entity_name         IN   VARCHAR2,
82 			   p_batch_id                   IN   NUMBER,
83 			   p_batch_party_id             IN   NUMBER,
84 			   x_return_status              OUT NOCOPY  VARCHAR2);
85 
86 END;