APPS.HZ_LOCATION_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 138: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

134: l_rowid ROWID := NULL;
135: l_key VARCHAR2(2000);
136: l_dummy VARCHAR2(1);
137: l_debug_prefix VARCHAR2(30) := '';
138: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
139: l_msg_count number;
140: l_message_count NUMBER;
141: l_msg_data varchar2(2000);
142: l_return_status varchar2(1);

Line 412: hz_orig_system_ref_pub.create_orig_system_reference(

408: l_orig_sys_reference_rec.owner_table_name := 'HZ_LOCATIONS';
409: l_orig_sys_reference_rec.owner_table_id := p_location_rec.location_id;
410: l_orig_sys_reference_rec.created_by_module := p_location_rec.created_by_module;
411:
412: hz_orig_system_ref_pub.create_orig_system_reference(
413: FND_API.G_FALSE,
414: l_orig_sys_reference_rec,
415: x_return_status,
416: l_msg_count,

Line 490: hz_orig_system_ref_pub.get_owner_table_id

486: and p_location_rec.orig_system <>fnd_api.g_miss_char)
487: and (p_location_rec.orig_system_reference is not null
488: and p_location_rec.orig_system_reference <>fnd_api.g_miss_char)
489: and (p_location_rec.location_id = FND_API.G_MISS_NUM or p_location_rec.location_id is null) THEN
490: hz_orig_system_ref_pub.get_owner_table_id
491: (p_orig_system => p_location_rec.orig_system,
492: p_orig_system_reference => p_location_rec.orig_system_reference,
493: p_owner_table_name => 'HZ_LOCATIONS',
494: x_owner_table_id => p_location_rec.location_id,

Line 1498: hz_orig_system_ref_pub.get_owner_table_id

1494: and p_location_rec.orig_system <>fnd_api.g_miss_char)
1495: and (p_location_rec.orig_system_reference is not null
1496: and p_location_rec.orig_system_reference <>fnd_api.g_miss_char)
1497: and (p_location_rec.location_id = FND_API.G_MISS_NUM or p_location_rec.location_id is null) THEN
1498: hz_orig_system_ref_pub.get_owner_table_id
1499: (p_orig_system => p_location_rec.orig_system,
1500: p_orig_system_reference => p_location_rec.orig_system_reference,
1501: p_owner_table_name => 'HZ_LOCATIONS',
1502: x_owner_table_id => l_location_rec.location_id,