eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 139: x_orig_sys_reference_rec OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,

135:
136: PROCEDURE get_orig_sys_reference_rec (
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_orig_system_ref_id in number,
139: x_orig_sys_reference_rec OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2
143: ) is

Line 245: p_orig_sys_entity_map_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,

241: END get_orig_sys_reference_rec;
242:
243:
244: PROCEDURE do_create_orig_sys_entity_map(
245: p_orig_sys_entity_map_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status IN OUT NOCOPY VARCHAR2
248: ) is
249: begin

Line 299: p_orig_sys_entity_map_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,

295: );
296: end do_create_orig_sys_entity_map;
297:
298: PROCEDURE do_update_orig_sys_entity_map(
299: p_orig_sys_entity_map_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,
300: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301: p_object_version_number IN OUT NOCOPY NUMBER,
302: x_return_status IN OUT NOCOPY VARCHAR2
303: ) is

Line 390: p_orig_sys_entity_map_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,

386: /* This is private API and should be only called in HTML admin UI */
387: PROCEDURE create_orig_sys_entity_mapping(
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_orig_sys_entity_map_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2
394: ) is

Line 395: l_orig_sys_entity_map_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE := p_orig_sys_entity_map_rec;

391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2
394: ) is
395: l_orig_sys_entity_map_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE := p_orig_sys_entity_map_rec;
396:
397: begin
398: -- standard start of API savepoint
399: SAVEPOINT create_orig_sys_entity_mapping;

Line 455: p_orig_sys_entity_map_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,

451: /* This is private API and should be only called in HTML admin UI */
452: PROCEDURE update_orig_sys_entity_mapping(
453: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455: p_orig_sys_entity_map_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE,
456: p_object_version_number IN OUT NOCOPY NUMBER,
457: x_return_status OUT NOCOPY VARCHAR2,
458: x_msg_count OUT NOCOPY NUMBER,
459: x_msg_data OUT NOCOPY VARCHAR2

Line 461: l_orig_sys_entity_map_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE := p_orig_sys_entity_map_rec;

457: x_return_status OUT NOCOPY VARCHAR2,
458: x_msg_count OUT NOCOPY NUMBER,
459: x_msg_data OUT NOCOPY VARCHAR2
460: ) is
461: l_orig_sys_entity_map_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_ENTITY_MAP_REC_TYPE := p_orig_sys_entity_map_rec;
462: begin
463:
464: -- standard start of API savepoint
465: SAVEPOINT update_orig_sys_entity_mapping;

Line 519: p_orig_sys_reference_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,

515:
516: end update_orig_sys_entity_mapping;
517:
518: PROCEDURE do_create_orig_sys_reference(
519: p_orig_sys_reference_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
521: x_return_status IN OUT NOCOPY VARCHAR2
522: ) is
523: l_dummy VARCHAR2(32);

Line 746: p_orig_sys_reference_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,

742: return l_date;
743: end get_start_date_active;
744:
745: PROCEDURE do_update_orig_sys_reference(
746: p_orig_sys_reference_rec IN OUT NOCOPY HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
748: p_object_version_number IN OUT NOCOPY NUMBER,
749: x_return_status IN OUT NOCOPY VARCHAR2
750: ) is

Line 763: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;

759: l_object_version_number NUMBER;
760: l_orig_system_ref_id NUMBER;
761: l_orig_system VARCHAR2(30);
762: l_orig_system_reference VARCHAR2(255);
763: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;
764: l_old_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
765: l_msg_count number;
766: l_msg_data varchar2(2000);
767: l_count number;

Line 764: l_old_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

760: l_orig_system_ref_id NUMBER;
761: l_orig_system VARCHAR2(30);
762: l_orig_system_reference VARCHAR2(255);
763: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;
764: l_old_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
765: l_msg_count number;
766: l_msg_data varchar2(2000);
767: l_count number;
768: l_dummy varchar2(32);

Line 1060: p_orig_sys_reference_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,

1056: /* Public API */
1057: PROCEDURE create_orig_system_reference(
1058: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1059: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1060: p_orig_sys_reference_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
1061: x_return_status OUT NOCOPY VARCHAR2,
1062: x_msg_count OUT NOCOPY NUMBER,
1063: x_msg_data OUT NOCOPY VARCHAR2
1064: ) is

Line 1065: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE :=p_orig_sys_reference_rec;

1061: x_return_status OUT NOCOPY VARCHAR2,
1062: x_msg_count OUT NOCOPY NUMBER,
1063: x_msg_data OUT NOCOPY VARCHAR2
1064: ) is
1065: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE :=p_orig_sys_reference_rec;
1066: l_orig_sys_reference_rec1 HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;
1067: l_object_version_number number;
1068: l_start_date_active date;
1069:

Line 1066: l_orig_sys_reference_rec1 HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;

1062: x_msg_count OUT NOCOPY NUMBER,
1063: x_msg_data OUT NOCOPY VARCHAR2
1064: ) is
1065: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE :=p_orig_sys_reference_rec;
1066: l_orig_sys_reference_rec1 HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;
1067: l_object_version_number number;
1068: l_start_date_active date;
1069:
1070: --raji

Line 1233: p_orig_sys_reference_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,

1229: /* Public API */
1230: PROCEDURE update_orig_system_reference(
1231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1233: p_orig_sys_reference_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
1234: p_object_version_number IN OUT NOCOPY NUMBER,
1235: x_return_status OUT NOCOPY VARCHAR2,
1236: x_msg_count OUT NOCOPY NUMBER,
1237: x_msg_data OUT NOCOPY VARCHAR2

Line 1241: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;

1237: x_msg_data OUT NOCOPY VARCHAR2
1238: )is
1239:
1240: l_object_version_number number:= p_object_version_number;
1241: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;
1242: lc_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;
1243: l_start_date_active date;
1244: l_inactive_mosr_exist varchar2(1);
1245:

Line 1242: lc_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;

1238: )is
1239:
1240: l_object_version_number number:= p_object_version_number;
1241: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;
1242: lc_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE := p_orig_sys_reference_rec;
1243: l_start_date_active date;
1244: l_inactive_mosr_exist varchar2(1);
1245:
1246: --raji

Line 1584: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

1580: where owner_table_id = p_old_owner_table_id
1581: and owner_table_name = p_owner_table_name
1582: and status = 'A'; /* Bug 3235877 */
1583:
1584: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1585: l_orig_system varchar2(30);
1586: l_orig_system_reference varchar2(255);
1587: l_orig_system_ref_id number;
1588: l_object_version_number number;

Line 1872: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

1868: and status = 'A';
1869: l_created_by_module varchar2(150);
1870: l_orig_system varchar2(30);
1871: l_orig_system_reference varchar2(255);
1872: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1873:
1874: --//introduce this new cursor,
1875:
1876: cursor get_multi_mosr_flag(p_orig_system NUMBER) is