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