[Home] [Help]
PACKAGE: APPS.HZ_STAGE_MAP_TRANSFORM
Source
1 package HZ_STAGE_MAP_TRANSFORM AS
2 /* $Header: ARHDQSMS.pls 120.9 2006/01/11 03:05:18 repuri noship $ */
3
4 PROCEDURE open_party_cursor(
5 p_select_type IN VARCHAR2,
6 p_party_type IN VARCHAR2,
7 p_worker_number IN NUMBER,
8 p_num_workers IN NUMBER,
9 p_party_id IN NUMBER,
10 p_continue IN VARCHAR2,
11 x_party_cur IN OUT NOCOPY HZ_PARTY_STAGE.StageCurTyp);
12
13 PROCEDURE open_sync_party_cursor (
14 p_operation IN VARCHAR2,
15 p_party_type IN VARCHAR2,
16 p_from_rec IN VARCHAR2,
17 p_to_rec IN VARCHAR2,
18 x_sync_party_cur IN OUT NOCOPY HZ_DQM_SYNC.SyncCurTyp );
19
20 PROCEDURE open_sync_party_site_cursor (
21 p_operation IN VARCHAR2,
22 p_from_rec IN VARCHAR2,
23 p_to_rec IN VARCHAR2,
24 x_sync_party_site_cur IN OUT NOCOPY HZ_DQM_SYNC.SyncCurTyp );
25
26 PROCEDURE open_sync_contact_cursor (
27 p_operation IN VARCHAR2,
28 p_from_rec IN VARCHAR2,
29 p_to_rec IN VARCHAR2,
30 x_sync_contact_cur IN OUT NOCOPY HZ_DQM_SYNC.SyncCurTyp );
31
32 PROCEDURE open_sync_cpt_cursor (
33 p_operation IN VARCHAR2,
34 p_from_rec IN VARCHAR2,
35 p_to_rec IN VARCHAR2,
36 x_sync_cpt_cur IN OUT NOCOPY HZ_DQM_SYNC.SyncCurTyp );
37
38 -- REPURI. Modified the 4 sync_all_xxx to include the
39 -- p_bulk_sync_type parameter to distinguish the calling API.
40 -- Bug 4884735.
41 PROCEDURE sync_all_parties (
42 p_operation IN VARCHAR2,
43 p_bulk_sync_type IN VARCHAR2,
44 p_sync_all_party_cur IN HZ_DQM_SYNC.SyncCurTyp);
45
46 PROCEDURE sync_all_party_sites (
47 p_operation IN VARCHAR2,
48 p_bulk_sync_type IN VARCHAR2,
49 p_sync_all_party_site_cur IN HZ_DQM_SYNC.SyncCurTyp);
50
51 PROCEDURE sync_all_contacts (
52 p_operation IN VARCHAR2,
53 p_bulk_sync_type IN VARCHAR2,
54 p_sync_all_contact_cur IN HZ_DQM_SYNC.SyncCurTyp);
55
56 PROCEDURE sync_all_contact_points (
57 p_operation IN VARCHAR2,
58 p_bulk_sync_type IN VARCHAR2,
59 p_sync_all_cpt_cur IN HZ_DQM_SYNC.SyncCurTyp);
60
61 PROCEDURE insert_stage_parties (
62 p_continue IN VARCHAR2,
63 p_party_cur IN HZ_PARTY_STAGE.StageCurTyp);
64
65 PROCEDURE insert_stage_party_sites;
66 PROCEDURE insert_stage_contacts;
67 PROCEDURE insert_stage_contact_pts;
68
69 PROCEDURE sync_single_party (
70 p_party_id NUMBER,
71 p_party_type VARCHAR2,
72 p_operation VARCHAR2);
73
74 PROCEDURE sync_single_party_site (
75 p_party_site_id NUMBER,
76 p_operation VARCHAR2);
77
78 PROCEDURE sync_single_contact (
79 p_org_contact_id NUMBER,
80 p_operation VARCHAR2);
81
82 PROCEDURE sync_single_contact_point (
83 p_contact_point_id NUMBER,
84 p_operation VARCHAR2);
85
86 PROCEDURE log (
87 message IN VARCHAR2,
88 newline IN BOOLEAN DEFAULT TRUE);
89
90 -- VJN Introduced for R12
91 -- REPURI modifications for Sync Enhancements, changed the signatures of
92 -- sync_single_xxx_online, to be similar to sync_single_xxx Procedures.
93
94 PROCEDURE sync_single_party_online (
95 p_party_id NUMBER,
96 p_operation VARCHAR2);
97
98 PROCEDURE sync_single_party_site_online (
99 p_party_site_id NUMBER,
100 p_operation VARCHAR2);
101
102 PROCEDURE sync_single_contact_online (
103 p_org_contact_id NUMBER,
104 p_operation VARCHAR2);
105
106 PROCEDURE sync_single_cpt_online (
107 p_contact_point_id NUMBER,
108 p_operation VARCHAR2);
109
110 FUNCTION miscp (rid IN ROWID) RETURN CLOB;
111 FUNCTION miscps (rid IN ROWID) RETURN CLOB;
112 FUNCTION miscct (rid IN ROWID) RETURN CLOB;
113 FUNCTION misccpt (rid IN ROWID) RETURN CLOB;
114
115 FUNCTION den_ps (party_id NUMBER) RETURN VARCHAR2;
116 FUNCTION den_cpt (party_id NUMBER) RETURN VARCHAR2;
117 FUNCTION den_ct (party_id NUMBER) RETURN VARCHAR2;
118
119 -- REPURI. Adding 4 new procedures to populate
120 -- bulk import ref cursors. Bug 4884735.
121 PROCEDURE open_bulk_imp_sync_cpt_cur (
122 p_batch_id IN NUMBER,
123 p_batch_mode_flag IN VARCHAR2,
124 p_from_osr IN VARCHAR2,
125 p_to_osr IN VARCHAR2,
126 p_os IN VARCHAR2,
127 p_operation IN VARCHAR2,
128 x_sync_cpt_cur IN OUT NOCOPY HZ_DQM_SYNC.SyncCurTyp);
129 PROCEDURE open_bulk_imp_sync_ct_cur (
130 p_batch_id IN NUMBER,
131 p_batch_mode_flag IN VARCHAR2,
132 p_from_osr IN VARCHAR2,
133 p_to_osr IN VARCHAR2,
134 p_os IN VARCHAR2,
135 p_operation IN VARCHAR2,
136 x_sync_contact_cur IN OUT NOCOPY HZ_DQM_SYNC.SyncCurTyp);
137 PROCEDURE open_bulk_imp_sync_party_cur(
138 p_batch_id IN NUMBER,
139 p_batch_mode_flag IN VARCHAR2,
140 p_from_osr IN VARCHAR2,
141 p_to_osr IN VARCHAR2,
142 p_os IN VARCHAR2,
143 p_party_type IN VARCHAR2,
144 p_operation IN VARCHAR2,
145 x_sync_party_cur IN OUT NOCOPY HZ_DQM_SYNC.SyncCurTyp);
146 PROCEDURE open_bulk_imp_sync_psite_cur (
147 p_batch_id IN NUMBER,
148 p_batch_mode_flag IN VARCHAR2,
149 p_from_osr IN VARCHAR2,
150 p_to_osr IN VARCHAR2,
151 p_os IN VARCHAR2,
152 p_operation IN VARCHAR2,
153 x_sync_party_site_cur IN OUT NOCOPY HZ_DQM_SYNC.SyncCurTyp);
154
155 END HZ_STAGE_MAP_TRANSFORM;