[Home] [Help]
398:
399: count NUMBER := 0;
400: l_os VARCHAR2(30);
401: BEGIN
402: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
403: open p_party_cur FOR
404: 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.DUNS_NUMBER_C, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, a.rowid, a.party_type , a.party_id
405: from hz_imp_parties_int a
406: where a.batch_id = p_batch_id
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);
465: open l_party_site_cur for
466: 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
467: from hz_imp_addresses_int a
468: where a.batch_id = p_batch_id
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
528: 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, 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
529: from HZ_IMP_CONTACTPTS_INT a
530: where a.batch_id = p_batch_id
595: where match_rule_id = 52 ) and rownum = 1;
596:
597: l_os VARCHAR2(30);
598: BEGIN --
599: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
600: OPEN c1;
601: LOOP
602: FETCH c1 into is_using_allow_cust_attr;
603: EXIT when c1%NOTFOUND;