APPS.HZ_MIGRATE_MOSR_REFERENCES dependencies on HZ_ORIG_SYSTEM_REF_S

Line 146: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_PARTIES', party_id(i),

142: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
143: status, start_date_active, end_date_active, reason_code, created_by,
144: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
145: last_update_date,last_update_login, object_version_number)
146: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_PARTIES', party_id(i),
147: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i),
148: creation_date(i), last_updated_by(i), last_update_date(i),
149: last_update_login(i), 1);
150:

Line 180: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_LOCATIONS', location_id(i),

176: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
177: status, start_date_active, end_date_active, reason_code, created_by,
178: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
179: last_update_date,last_update_login, object_version_number)
180: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_LOCATIONS', location_id(i),
181: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i),
182: creation_date(i), last_updated_by(i), last_update_date(i), last_update_login(i), 1);
183:
184: if l_last_fetch then

Line 213: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_ORG_CONTACTS', org_contact_id(i),

209: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
210: status, start_date_active, end_date_active, reason_code, created_by,
211: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
212: last_update_date,last_update_login, object_version_number)
213: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_ORG_CONTACTS', org_contact_id(i),
214: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i), creation_date(i),
215: last_updated_by(i), last_update_date(i), last_update_login(i), 1);
216:
217: if l_last_fetch then

Line 245: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_CONTACT_POINTS', contact_point_id(i),

241: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
242: status, start_date_active, end_date_active, reason_code, created_by,
243: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
244: last_update_date,last_update_login, object_version_number)
245: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_CONTACT_POINTS', contact_point_id(i),
246: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i), creation_date(i), last_updated_by(i),
247: last_update_date(i), last_update_login(i), 1);
248:
249: if l_last_fetch then

Line 277: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_ORG_CONTACT_ROLES', org_contact_role_id(i),

273: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
274: status, start_date_active, end_date_active, reason_code, created_by,
275: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
276: last_update_date,last_update_login, object_version_number)
277: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_ORG_CONTACT_ROLES', org_contact_role_id(i),
278: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i), creation_date(i), last_updated_by(i),
279: last_update_date(i), last_update_login(i), 1);
280:
281: if l_last_fetch then

Line 309: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_PARTY_SITES', party_site_id(i),

305: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
306: status, start_date_active, end_date_active, reason_code, created_by,
307: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
308: last_update_date,last_update_login, object_version_number)
309: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_PARTY_SITES', party_site_id(i),
310: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i), creation_date(i),
311: last_updated_by(i), last_update_date(i), last_update_login(i), 1);
312:
313: if l_last_fetch then