1 PACKAGE HZ_COPY_REL_PVT AUTHID CURRENT_USER AS
2 /* $Header: ARHCPRLS.pls 120.1 2005/06/16 21:09:38 jhuang noship $ */
3 --------------------------------------
4 -- AUTHOR :::::: COLATHUR VIJAYAN (VJN)
5 --------------------------------------
6
7
8 --------------------------------------------------------------------------------------
9 -- copy_rel_type_only ::: This will take a relationship type A and create a relationship
10 -- type B, which is a copy of A in the following sense:
11 -- B will be identical to A in terms of all the properties( phrase pairs,hierarchical type,
12 -- circular flag etc., as seen in HZ_RELATIONSHIP_TYPES), that are
13 -- associated with any relationship type.
14 --
15 -- HOWEVER, THIS PROCEDURE WILL NOT COPY RELATIONSHIPS UNDER A TO B.
16 --------------------------------------------------------------------------------------
17
18 PROCEDURE copy_rel_type_only (
19 -- in parameters
20 p_source_rel_type IN VARCHAR2
21 ,p_dest_rel_type IN VARCHAR2
22 ,p_dest_rel_type_role_prefix IN VARCHAR2
23 ,p_dest_rel_type_role_suffix IN VARCHAR2
24 -- out NOCOPY parameters
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_msg_count OUT NOCOPY NUMBER
27 ,x_msg_data OUT NOCOPY VARCHAR2
28 );
29
30 ----------------------------------------------------------------------------------------------------
31 -- copy_rel_type_and_all_rels ::: This will take a relationship type A and create a relationship
32 -- type B, which is a copy of A in the following sense:
33 -- 1. B will be identical to A in terms of all the properties( hierarchical type, circular flag
34 -- etc., as seen in HZ_RELATIONSHIP_TYPES), that are
35 -- associated with any relationship type.
36 -- 2. ALL THE RELATIONSHIPS UNDER A WILL BE CREATED UNDER B.
37 ----------------------------------------------------------------------------------------------------
38
39 PROCEDURE copy_rel_type_and_all_rels (
40 errbuf OUT NOCOPY VARCHAR2
41 ,Retcode OUT NOCOPY VARCHAR2
42 ,p_source_rel_type IN VARCHAR2
43 ,p_dest_rel_type IN VARCHAR2
44 ,p_dest_rel_type_role_prefix IN VARCHAR2
45 ,p_dest_rel_type_role_suffix IN VARCHAR2
46 ,p_rel_valid_date IN DATE DEFAULT SYSDATE
47 );
48
49 ----------------------------------------------------------------
50 -- WRAPPER ON TOP OF THE copy_rel_typ_and_all_relships PROCEDURE
51 -- SO THAT IT CAN BE CALLED AS A CONCURRENT PROGRAM
52 ----------------------------------------------------------------
53
54 PROCEDURE submit_copy_rel_type_rels_conc (
55 -- in parameters
56 p_source_rel_type IN VARCHAR2
57 ,p_dest_rel_type IN VARCHAR2
58 ,p_dest_rel_type_role_prefix IN VARCHAR2
59 ,p_dest_rel_type_role_suffix IN VARCHAR2
60 ,p_rel_valid_date IN DATE DEFAULT SYSDATE
61 ,x_request_id OUT NOCOPY NUMBER
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2 );
65
66
67 ----------------------------------------------------------------------------------------------------
68 -------- NOTE THAT A HAS TO BE A HIERARCHICAL RELATIONSHIP TYPE TO BEGIN WITH, FOR THIS PROCEDURE
69 ----------------------------------------------------------------------------------------------------
70 -- copy_hierarchy ::: This will take 2 Hierarchical relationship types A, B and do the following:
71 -- 1. If B does not exist already, create B as a copy of A, in the sense of
72 -- copy_rel_type_only, mentioned above.
73 -- 2. Given a party id P, copy the complete hierarchy tree under P in A, to B.
74 -- In other words, copy all relationships under A, that pertain to P's
75 -- Hierarchy tree ( ie., the tree starting from P and going down) to B.
76 -- If B exists already, this would mean that, when ever we create relationships in B,
77 -- we need to make sure, that they do not already exist in A.
78 --
79 -- IT SHOULD BE NOTED THAT IF B EXISTS ALREADY, THEN ALL THE PHRASE PAIRS
80 -- PERTAINING TO A THAT DO NOT ALREADY EXIST IN B, SHOULD BE FIRST CREATED IN B,
81 -- BEFORE PROCEEDING TO STEP 2.
82 --------------------------------------------------------------------------------------
83
84 PROCEDURE copy_hierarchy (
85 errbuf OUT NOCOPY VARCHAR2
86 ,Retcode OUT NOCOPY VARCHAR2
87 ,p_source_rel_type IN VARCHAR2
88 ,p_dest_rel_type IN VARCHAR2
89 ,p_dest_rel_type_role_prefix IN VARCHAR2
90 ,p_dest_rel_type_role_suffix IN VARCHAR2
91 ,p_rel_valid_date IN DATE DEFAULT SYSDATE
92 ,p_party_id IN NUMBER
93 );
94
95 ----------------------------------------------------------------
96 -- WRAPPER ON TOP OF THE copy_hierarchy PROCEDURE
97 -- SO THAT IT CAN BE CALLED AS A CONCURRENT PROGRAM
98 ----------------------------------------------------------------
99
100 PROCEDURE submit_copy_hierarchy_conc (
101 -- in parameters
102 p_source_rel_type IN VARCHAR2
103 ,p_dest_rel_type IN VARCHAR2
104 ,p_dest_rel_type_role_prefix IN VARCHAR2
105 ,p_dest_rel_type_role_suffix IN VARCHAR2
106 ,p_rel_valid_date IN DATE DEFAULT SYSDATE
107 ,p_party_id IN NUMBER
108 ,x_request_id OUT NOCOPY NUMBER
109 ,x_return_status OUT NOCOPY VARCHAR2
110 ,x_msg_count OUT NOCOPY NUMBER
111 ,x_msg_data OUT NOCOPY VARCHAR2 );
112
113 ------------------------------------------------------------------------
114 -- This procedure will convert a non-hierarchical relationship type to a
115 -- hierarchical relationship type.
116 ------------------------------------------------------------------------
117
118 PROCEDURE convert_rel_type(
119 errbuf OUT NOCOPY VARCHAR2,
120 Retcode OUT NOCOPY VARCHAR2,
121 p_rel_type IN VARCHAR2
122 );
123
124 ----------------------------------------------------------------
125 -- WRAPPER ON TOP OF THE convert_rel_type PROCEDURE
126 -- SO THAT IT CAN BE CALLED AS A CONCURRENT PROGRAM
127 ----------------------------------------------------------------
128
129 PROCEDURE submit_convert_rel_type_conc (
130 -- in parameters
131 p_rel_type IN VARCHAR2
132 -- out NOCOPY parameters
133 ,x_request_id OUT NOCOPY NUMBER
134 ,x_return_status OUT NOCOPY VARCHAR2
135 ,x_msg_count OUT NOCOPY NUMBER
136 ,x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139
140 END HZ_COPY_REL_PVT ;
141
142