[Home] [Help]
301:
302: count NUMBER := 0;
303: l_os VARCHAR2(30);
304: BEGIN
305: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
306: open p_party_cur FOR
307: select decode(a.party_type, 'ORGANIZATION', a.organization_name, 'PERSON', a.person_first_name || ' ' || a.person_last_name) as PARTY_NAME , a.PARTY_TYPE, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, a.rowid, a.party_type , a.party_id
308: from hz_imp_parties_int a
309: where a.batch_id = p_batch_id
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);
367: open l_party_site_cur for
368: select a.CITY, a.POSTAL_CODE, a.STATE, a.COUNTRY, a.party_orig_system, a.party_orig_system_reference, a.site_orig_system, a.site_orig_system_reference, a.rowid, a.address1 || ' ' || a.address2 || ' ' || a.address3 || ' ' || a.address4 as address , a.party_id
369: from hz_imp_addresses_int a
370: where a.batch_id = p_batch_id
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
430: 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, 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 , a.party_id
431: from HZ_IMP_CONTACTPTS_INT a
432: where a.batch_id = p_batch_id
496: where match_rule_id = 51 ) and rownum = 1;
497:
498: l_os VARCHAR2(30);
499: BEGIN --
500: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
501: null;
502: END get_contact_cur_int;
503:
504: PROCEDURE pop_contacts_int (