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