APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_ORIG_SYS_REFERENCES

Line 565: into hz_orig_sys_references (

561: nullif(attr17, :2),
562: nullif(attr18, :2),
563: nullif(attr19, :2),
564: nullif(attr20, :2))
565: into hz_orig_sys_references (
566: application_id,
567: created_by,
568: creation_date,
569: last_updated_by,

Line 1484: HZ_ORIG_SYS_REFERENCES mosr,

1480: ) fnd_lang,
1481: fnd_timezones_b timezone,
1482: hz_party_sites hz_ps,
1483: hz_locations hz_loc,
1484: HZ_ORIG_SYS_REFERENCES mosr,
1485: HZ_ORIG_SYSTEMS_B hos,
1486: hz_party_sites hz_ps1,
1487: HZ_ORIG_SYS_REFERENCES mosr2,
1488: fnd_lookup_values createdby_l

Line 1487: HZ_ORIG_SYS_REFERENCES mosr2,

1483: hz_locations hz_loc,
1484: HZ_ORIG_SYS_REFERENCES mosr,
1485: HZ_ORIG_SYSTEMS_B hos,
1486: hz_party_sites hz_ps1,
1487: HZ_ORIG_SYS_REFERENCES mosr2,
1488: fnd_lookup_values createdby_l
1489:
1490: WHERE mosr.orig_system (+) = site_sg.party_orig_system
1491: AND mosr.orig_system_reference (+) = site_sg.party_orig_system_reference

Line 1715: HZ_ORIG_SYS_REFERENCES mosr,

1711: ) fnd_lang,
1712: fnd_timezones_b timezone,
1713: hz_party_sites hz_ps,
1714: hz_locations hz_loc,
1715: HZ_ORIG_SYS_REFERENCES mosr,
1716: HZ_ORIG_SYSTEMS_B hos,
1717: hz_party_sites hz_ps1,
1718: HZ_ORIG_SYS_REFERENCES mosr2,
1719: fnd_lookup_values createdby_l

Line 1718: HZ_ORIG_SYS_REFERENCES mosr2,

1714: hz_locations hz_loc,
1715: HZ_ORIG_SYS_REFERENCES mosr,
1716: HZ_ORIG_SYSTEMS_B hos,
1717: hz_party_sites hz_ps1,
1718: HZ_ORIG_SYS_REFERENCES mosr2,
1719: fnd_lookup_values createdby_l
1720: WHERE mosr.orig_system (+) = site_sg.party_orig_system
1721: AND mosr.orig_system_reference (+) = site_sg.party_orig_system_reference
1722: AND mosr.status (+) = ''A''

Line 2753: update hz_orig_sys_references mosr

2749: /* end-date old mosr entries if */
2750: /* 1) record moved
2751: /* 2) record corrected and osr change (collision or not) */
2752: forall j in 1..l_site_id.count
2753: update hz_orig_sys_references mosr
2754: set status = 'I',
2755: last_updated_by = P_DML_RECORD.USER_ID,
2756: last_update_login = P_DML_RECORD.LAST_UPDATE_LOGIN,
2757: last_update_date = P_DML_RECORD.SYSDATE,

Line 2833: update hz_orig_sys_references mosr

2829: /* end-date collided entries if */
2830: /* 1) record moved and collision happens
2831: /* 2) record corrected and collision happens */
2832: forall j in 1..l_site_id.count
2833: update hz_orig_sys_references mosr
2834: set status = 'I',
2835: last_updated_by = P_DML_RECORD.USER_ID,
2836: last_update_login = P_DML_RECORD.LAST_UPDATE_LOGIN,
2837: last_update_date = P_DML_RECORD.SYSDATE,

Line 2861: insert into HZ_ORIG_SYS_REFERENCES

2857: /* 1) record moved, or */
2858: /* 2) record corrected and osr change */
2859: /* insert new mosr entry for new address */
2860: ForAll j in 1..l_site_id.count
2861: insert into HZ_ORIG_SYS_REFERENCES
2862: ( ORIG_SYSTEM_REF_ID,
2863: ORIG_SYSTEM,
2864: ORIG_SYSTEM_REFERENCE,
2865: OWNER_TABLE_NAME,