1 PACKAGE HZ_DQM_SYNC AUTHID CURRENT_USER AS
2 /* $Header: ARHDQSNS.pls 120.7 2006/01/19 09:50:13 repuri noship $ */
3
4 PROCEDURE sync_org (
5 p_party_id IN NUMBER,
6 p_create_upd IN VARCHAR2
7 );
8
9 PROCEDURE sync_person (
10 p_party_id IN NUMBER,
11 p_create_upd IN VARCHAR2
12 );
13
14 PROCEDURE sync_party_site (
15 p_party_site_id IN NUMBER,
16 p_create_upd IN VARCHAR2
17 );
18
19 PROCEDURE sync_contact (
20 p_org_contact_id IN NUMBER,
21 p_create_upd IN VARCHAR2
22 );
23
24 PROCEDURE sync_contact_point (
25 p_contact_point_id IN NUMBER,
26 p_create_upd IN VARCHAR2
27 );
28
29
30 PROCEDURE sync_location (
31 p_location_id IN NUMBER,
32 p_create_upd IN VARCHAR2
33 );
34
35 PROCEDURE sync_relationship (
36 p_relationship_id IN NUMBER,
37 p_create_upd IN VARCHAR2
38 );
39
40 PROCEDURE sync_cust_account (
41 p_cust_acct_id IN NUMBER,
42 p_create_upd IN VARCHAR2
43 );
44 /*
45 PROCEDURE sync_parties (
46 errbuf OUT NOCOPY VARCHAR2,
47 retcode OUT NOCOPY VARCHAR2
48 ); */
49
50 PROCEDURE optimize_indexes (
51 errbuf OUT NOCOPY VARCHAR2,
52 retcode OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE stage_party_merge(
56 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
57 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
58 x_to_id IN OUT NOCOPY NUMBER,
59 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
60 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
61 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
62 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
63 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
64 x_return_status OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE stage_party_site_merge(
68 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
69 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
70 x_to_id IN OUT NOCOPY NUMBER,
71 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
72 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
74 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
75 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
76 x_return_status OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE stage_contact_merge(
80 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
81 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
82 x_to_id IN OUT NOCOPY NUMBER,
83 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
86 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
87 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
88 x_return_status OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE stage_contact_point_merge(
92 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94 x_to_id IN OUT NOCOPY NUMBER,
95 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100 x_return_status OUT NOCOPY VARCHAR2
101 );
102
103 FUNCTION realtime_sync (p_subscription_guid IN RAW,
104 p_event IN OUT NOCOPY WF_EVENT_T)
105 RETURN VARCHAR2 ;
106
107
108 TYPE SyncCurTyp IS REF CURSOR;
109
110 PROCEDURE sync_work_unit(retcode OUT NOCOPY VARCHAR2,
111 err OUT NOCOPY VARCHAR2,
112 p_from_rec IN VARCHAR2,
113 p_to_rec IN VARCHAR2,
114 p_sync_type IN VARCHAR2 );
115
116 PROCEDURE sync_parties(retcode OUT NOCOPY VARCHAR2,
117 err OUT NOCOPY VARCHAR2,
118 p_num_of_workers IN VARCHAR2,
119 p_indexes_only IN VARCHAR2 );
120
121 PROCEDURE sync_index_conc(
122 retcode OUT NOCOPY VARCHAR2,
123 err OUT NOCOPY VARCHAR2,
124 p_index_name IN VARCHAR2 );
125
126 PROCEDURE set_to_batch_sync;
127
128 -- VJN modified for R12 for Bulk Import
129 -- This API would be called by the Bulk Import Post Processing Program, to directly insert
130 -- data into the STAGING tables
131 -- Modified for R12 using collections instead of Ref Cursors
132
133 -- REPURI. Modified to get batch details instead of collections. Bug 4884735.
134
135 PROCEDURE sync_work_unit_imp(
136 p_batch_id IN NUMBER,
137 p_batch_mode_flag IN VARCHAR2,
138 p_from_osr IN VARCHAR2,
139 p_to_osr IN VARCHAR2,
140 p_os IN VARCHAR2,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2
144 ) ;
145
146 -- REPURI. Added to enable inserting data into HZ_DQM_SH_SYNC_INTERFACE table.
147 -- The table is the Interface table for Shadow Sync. Bug 4884742.
148
149 PROCEDURE insert_sh_interface_rec (
150 p_party_id IN NUMBER,
151 p_record_id IN NUMBER,
152 p_party_site_id IN NUMBER,
153 p_org_contact_id IN NUMBER,
154 p_entity IN VARCHAR2,
155 p_operation IN VARCHAR2,
156 p_staged_flag IN VARCHAR2 DEFAULT 'N'
157 );
158
159 -- REPURI. Introduced to check if shadow staging has completed successfully. Bug 4884742.
160
161 FUNCTION is_shadow_staging_complete RETURN BOOLEAN;
162
163 -- VJN Introduced for setting transactional property of Index, a new feature
164 -- for text indexes, available as part of 10g.
165 PROCEDURE set_index_transactional ( enabled IN VARCHAR2 ) ;
166
167 ------------------------------
168 -- VJN Sync changes for R12
169 -----------------------------
170
171 -- conc program executable for Serial Sync Index Concurrent Program
172 -- This will be used only online (API) flows
173 PROCEDURE sync_index_serial(
174 retcode OUT NOCOPY VARCHAR2,
175 err OUT NOCOPY VARCHAR2
176 );
177
178 -- conc program executable for Parallel Sync Index Parent Concurrent Program
179 -- This will be used by both Manual ( Batch) Synchronization and Bulk Import
180
181 PROCEDURE sync_index_parallel_parent (
182 retcode OUT NOCOPY VARCHAR2,
183 err OUT NOCOPY VARCHAR2,
184 p_request_id IN NUMBER
185 );
186
187 -- conc program executable for Parallel Sync Index Child Concurrent Program
188 -- This will be used by both Manual ( Batch) Synchronization and Bulk Import
189 PROCEDURE sync_index_parallel_child (
190 retcode OUT NOCOPY VARCHAR2,
191 err OUT NOCOPY VARCHAR2,
192 p_request_id IN NUMBER,
193 p_index_name IN VARCHAR2
194 );
195
196 END HZ_DQM_SYNC;
197