APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_PARTY_STAGE

Line 72: p_party_cur HZ_PARTY_STAGE.StageCurTyp;

68: p_to_osr IN VARCHAR2,
69: p_batch_mode_flag IN VARCHAR2
70: ) IS
71: l_last_fetch BOOLEAN := FALSE;
72: p_party_cur HZ_PARTY_STAGE.StageCurTyp;
73:
74: count NUMBER := 0;
75: BEGIN
76: -- query for interface to TCA

Line 137: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

133: p_to_osr IN VARCHAR2,
134: p_batch_mode_flag IN VARCHAR2
135: ) IS
136: l_last_fetch BOOLEAN := FALSE;
137: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
138:
139: BEGIN
140: -- query for interface to tca
141: open l_party_site_cur for

Line 204: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;

200: p_batch_mode_flag IN VARCHAR2
201: ) IS
202:
203: l_last_fetch BOOLEAN := FALSE;
204: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;
205: BEGIN
206: open l_cp_cur for
207: select a.EMAIL_ADDRESS, a.party_orig_system, a.party_orig_system_reference, a.cp_orig_system, a.cp_orig_system_reference, a.site_orig_system, a.site_orig_system_reference, b.party_site_id, b.contact_point_id, b.party_id, b.party_action_flag, a.rowid, a.contact_point_type, decode(a.raw_phone_number, null, a.PHONE_COUNTRY_CODE||a.PHONE_AREA_CODE ||a.phone_number, a.raw_phone_number) as raw_phone_number
208: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b --

Line 300: p_party_cur HZ_PARTY_STAGE.StageCurTyp;

296: p_from_osr IN VARCHAR2,
297: p_to_osr IN VARCHAR2
298: ) IS
299: l_last_fetch BOOLEAN := FALSE;
300: p_party_cur HZ_PARTY_STAGE.StageCurTyp;
301:
302: count NUMBER := 0;
303: l_os VARCHAR2(30);
304: BEGIN

Line 362: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

358: p_from_osr IN VARCHAR2,
359: p_to_osr IN VARCHAR2
360: ) IS
361: l_last_fetch BOOLEAN := FALSE;
362: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
363:
364: l_os VARCHAR2(30);
365: BEGIN
366: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);

Line 425: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;

421: p_from_osr IN VARCHAR2,
422: p_to_osr IN VARCHAR2
423: ) IS
424: l_last_fetch BOOLEAN := FALSE;
425: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;
426: l_os VARCHAR2(30);
427: BEGIN
428: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
429: open l_cp_cur for