APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_PARTY_STAGE

Line 85: p_party_cur HZ_PARTY_STAGE.StageCurTyp;

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

Line 151: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

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

Line 218: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;

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

Line 397: p_party_cur HZ_PARTY_STAGE.StageCurTyp;

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

Line 460: l_party_site_cur HZ_PARTY_STAGE.StageCurTyp;

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

Line 523: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;

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