APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_PARTY_STAGE

Line 84: p_party_cur HZ_PARTY_STAGE.StageCurTyp;

80: p_to_osr IN VARCHAR2,
81: p_batch_mode_flag IN VARCHAR2
82: ) IS
83: l_last_fetch BOOLEAN := FALSE;
84: p_party_cur HZ_PARTY_STAGE.StageCurTyp;
85:
86: count NUMBER := 0;
87: BEGIN
88: -- query for interface to TCA

Line 150: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

146: p_to_osr IN VARCHAR2,
147: p_batch_mode_flag IN VARCHAR2
148: ) IS
149: l_last_fetch BOOLEAN := FALSE;
150: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
151:
152: BEGIN
153: -- query for interface to tca
154: open l_party_site_cur for

Line 217: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;

213: p_batch_mode_flag IN VARCHAR2
214: ) IS
215:
216: l_last_fetch BOOLEAN := FALSE;
217: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;
218: BEGIN
219: open l_cp_cur for
220: select a.URL, 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
221: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b --

Line 396: p_party_cur HZ_PARTY_STAGE.StageCurTyp;

392: p_from_osr IN VARCHAR2,
393: p_to_osr IN VARCHAR2
394: ) IS
395: l_last_fetch BOOLEAN := FALSE;
396: p_party_cur HZ_PARTY_STAGE.StageCurTyp;
397:
398: count NUMBER := 0;
399: l_os VARCHAR2(30);
400: BEGIN

Line 459: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

455: p_from_osr IN VARCHAR2,
456: p_to_osr IN VARCHAR2
457: ) IS
458: l_last_fetch BOOLEAN := FALSE;
459: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;
460:
461: l_os VARCHAR2(30);
462: BEGIN
463: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);

Line 522: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;

518: p_from_osr IN VARCHAR2,
519: p_to_osr IN VARCHAR2
520: ) IS
521: l_last_fetch BOOLEAN := FALSE;
522: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;
523: l_os VARCHAR2(30);
524: BEGIN
525: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
526: open l_cp_cur for