DBA Data[Home] [Help]

APPS.HZ_ORIG_SYSTEM_REF_BO_PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 26: x_orig_sys_rec OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE

22: --
23:
24: PROCEDURE assign_orig_sys_ref(
25: p_orig_sys_obj IN HZ_ORIG_SYS_REF_OBJ,
26: x_orig_sys_rec OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE
27: );
28:
29: -- PRIVATE PROCEDURE assign_orig_sys_ref
30: --

Line 51: x_orig_sys_rec OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE

47: --
48:
49: PROCEDURE assign_orig_sys_ref(
50: p_orig_sys_obj IN HZ_ORIG_SYS_REF_OBJ,
51: x_orig_sys_rec OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE
52: ) IS
53: BEGIN
54: x_orig_sys_rec.orig_system := p_orig_sys_obj.orig_system;
55: x_orig_sys_rec.orig_system_reference := p_orig_sys_obj.orig_system_reference;

Line 131: l_ososr_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2
129: ) IS
130: l_otn VARCHAR2(30);
131: l_ososr_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
132: l_debug_prefix VARCHAR2(30);
133: BEGIN
134: -- Standard start of API savepoint
135: SAVEPOINT create_osr_bo_pub;

Line 191: HZ_ORIG_SYSTEM_REF_PUB.create_orig_system_reference(

187: p_orig_sys_obj => p_orig_sys_refs(i),
188: x_orig_sys_rec => l_ososr_rec
189: );
190:
191: HZ_ORIG_SYSTEM_REF_PUB.create_orig_system_reference(
192: p_init_msg_list => p_init_msg_list,
193: p_orig_sys_reference_rec => l_ososr_rec,
194: x_return_status => x_return_status,
195: x_msg_count => x_msg_count,

Line 344: l_ososr_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

340: x_msg_data OUT NOCOPY VARCHAR2
341: ) IS
342: l_otn VARCHAR2(30);
343: l_ovn NUMBER;
344: l_ososr_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
345: l_debug_prefix VARCHAR2(30);
346: BEGIN
347: -- Standard start of API savepoint
348: SAVEPOINT update_osr_bo_pub;

Line 400: HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(

396: x_orig_sys_rec => l_ososr_rec
397: );
398:
399: l_ososr_rec.created_by_module := null;
400: HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(
401: p_orig_sys_reference_rec => l_ososr_rec,
402: p_object_version_number => l_ovn,
403: x_return_status => x_return_status,
404: x_msg_count => x_msg_count,

Line 572: HZ_ORIG_SYSTEM_REF_PUB.remap_internal_identifier(

568: END IF;
569:
570: FOR i IN 1..p_orig_sys_refs.object_type.COUNT LOOP
571: l_otn := HZ_REGISTRY_VALIDATE_BO_PVT.get_owner_table_name(p_orig_sys_refs.object_type(i));
572: HZ_ORIG_SYSTEM_REF_PUB.remap_internal_identifier(
573: p_old_owner_table_id => p_orig_sys_refs.old_object_id(i),
574: p_new_owner_table_id => p_orig_sys_refs.new_object_id(i),
575: p_owner_table_name => l_otn,
576: p_orig_system => p_orig_sys_refs.object_os(i),