APPS.HZ_IMP_LOAD_CPT_PKG dependencies on HZ_ORIG_SYS_REFERENCES

Line 793: into hz_orig_sys_references (

789: telex_number, web_type, url,
790: raw_phone_number,1,nvl(nullif(created_by_module,:G_MISS_CHAR),''HZ_IMPORT''),
791: contact_point_purpose, eft_transmission_program_id, eft_printing_program_id,
792: eft_user_number, eft_swift_code)
793: into hz_orig_sys_references (
794: application_id, created_by, creation_date,
795: last_updated_by, last_update_date, last_update_login,
796: orig_system_ref_id, orig_system, orig_system_reference,
797: owner_table_name, owner_table_id, status,

Line 987: from hz_orig_sys_references

983: nvl2(createdby_l.lookup_code, ''Y'', null) createdby_l,
984: --nvl(mosr_site.owner_table_id,mosr_party.owner_table_id) mosr_owner_table_id, --Bug No:3443866
985: nvl2(pi.site_orig_system_reference,mosr_site.owner_table_id,hp.party_id) mosr_owner_table_id, --Bug No:3443866
986: /*(select ''Y''
987: from hz_orig_sys_references
988: where status = ''A''
989: and rownum = 1
990: and (orig_system, orig_system_reference, owner_table_name) in (
991: (pi.site_orig_system, pi.site_orig_system_reference,

Line 1000: --hz_orig_sys_references mosr_party,

996: hp.party_id party_owner_table_id,
997: mosr_site.owner_table_id site_owner_table_id
998: from hz_imp_contactpts_int pi,
999: hz_imp_contactpts_sg ps,
1000: --hz_orig_sys_references mosr_party,
1001: hz_parties hp,
1002: hz_orig_sys_references mosr_site,
1003: --(select distinct phone_country_code from hz_phone_country_codes) hpc,--3401319
1004: (select 0 a from dual union all select 1 a from dual) tc,--3401319

Line 1002: hz_orig_sys_references mosr_site,

998: from hz_imp_contactpts_int pi,
999: hz_imp_contactpts_sg ps,
1000: --hz_orig_sys_references mosr_party,
1001: hz_parties hp,
1002: hz_orig_sys_references mosr_site,
1003: --(select distinct phone_country_code from hz_phone_country_codes) hpc,--3401319
1004: (select 0 a from dual union all select 1 a from dual) tc,--3401319
1005: fnd_timezones_b ht,
1006: fnd_lookup_values contact_point_type_l,

Line 1890: update HZ_ORIG_SYS_REFERENCES set

1886: /******************************************/
1887:
1888: /* End date current MOSR mapping */
1889: ForAll j in 1..l_cp_orig_system_reference.count
1890: update HZ_ORIG_SYS_REFERENCES set
1891: STATUS = 'I',
1892: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
1893: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
1894: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,

Line 1910: insert into HZ_ORIG_SYS_REFERENCES

1906:
1907:
1908: /* Insert new MOSR mapping in case of OSR change */
1909: ForAll j in 1..l_cp_orig_system_reference.count
1910: insert into HZ_ORIG_SYS_REFERENCES
1911: (
1912: ORIG_SYSTEM_REF_ID,
1913: ORIG_SYSTEM,
1914: ORIG_SYSTEM_REFERENCE,