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 399: hz_orig_system_ref_pub.create_orig_system_reference(

395: l_orig_sys_reference_rec.owner_table_name := 'HZ_LOCATIONS';
396: l_orig_sys_reference_rec.owner_table_id := p_location_rec.location_id;
397: l_orig_sys_reference_rec.created_by_module := p_location_rec.created_by_module;
398:
399: hz_orig_system_ref_pub.create_orig_system_reference(
400: FND_API.G_FALSE,
401: l_orig_sys_reference_rec,
402: x_return_status,
403: l_msg_count,

Line 477: hz_orig_system_ref_pub.get_owner_table_id

473: and p_location_rec.orig_system <>fnd_api.g_miss_char)
474: and (p_location_rec.orig_system_reference is not null
475: and p_location_rec.orig_system_reference <>fnd_api.g_miss_char)
476: and (p_location_rec.location_id = FND_API.G_MISS_NUM or p_location_rec.location_id is null) THEN
477: hz_orig_system_ref_pub.get_owner_table_id
478: (p_orig_system => p_location_rec.orig_system,
479: p_orig_system_reference => p_location_rec.orig_system_reference,
480: p_owner_table_name => 'HZ_LOCATIONS',
481: x_owner_table_id => p_location_rec.location_id,

Line 1485: hz_orig_system_ref_pub.get_owner_table_id

1481: and p_location_rec.orig_system <>fnd_api.g_miss_char)
1482: and (p_location_rec.orig_system_reference is not null
1483: and p_location_rec.orig_system_reference <>fnd_api.g_miss_char)
1484: and (p_location_rec.location_id = FND_API.G_MISS_NUM or p_location_rec.location_id is null) THEN
1485: hz_orig_system_ref_pub.get_owner_table_id
1486: (p_orig_system => p_location_rec.orig_system,
1487: p_orig_system_reference => p_location_rec.orig_system_reference,
1488: p_owner_table_name => 'HZ_LOCATIONS',
1489: x_owner_table_id => l_location_rec.location_id,