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_REGISTRY_VALIDATE_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 1152: -- hz_orig_system_ref_pub.get_owner_table_id

1148: l_validate_osr varchar2(1) := 'Y';
1149: l_mosr_owner_table_id number;
1150:
1151: l_temp_return_status VARCHAR2(10); -- for storing return status from
1152: -- hz_orig_system_ref_pub.get_owner_table_id
1153:
1154: -- Bug 2197181: selecting actual_content_source for mix-n-match
1155: -- Bug 4203495 selecting primary_flag
1156: CURSOR c_update IS

Line 1638: hz_orig_system_ref_pub.get_owner_table_id

1634: and (p_contact_point_rec.orig_system_reference is not null
1635: and p_contact_point_rec.orig_system_reference <>fnd_api.g_miss_char)
1636: and p_create_update_flag = 'U'
1637: then
1638: hz_orig_system_ref_pub.get_owner_table_id
1639: (p_orig_system => p_contact_point_rec.orig_system,
1640: p_orig_system_reference => p_contact_point_rec.orig_system_reference,
1641: p_owner_table_name => 'HZ_CONTACT_POINTS',
1642: x_owner_table_id => l_mosr_owner_table_id,

Line 1654: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the

1650: -- we will use unique osr and os for update - bypass osr validation
1651: ELSE l_validate_osr := 'Y';
1652: END IF;
1653:
1654: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
1655: -- x_return_status. Set x_return_status to error, ONLY if there is error.
1656: -- In case of success, leave it to carry over previous value as before this call.
1657: -- Fix for Bug 5498116 (29-AUG-2006)
1658: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2922: -- hz_orig_system_ref_pub.get_owner_table_id

2918: l_validate_osr varchar2(1) := 'Y';
2919: l_mosr_owner_table_id number;
2920:
2921: l_temp_return_status VARCHAR2(10); -- for storing return status from
2922: -- hz_orig_system_ref_pub.get_owner_table_id
2923: /*
2924:
2925: CURSOR c_temp_hr_party_exist IS
2926: select 1

Line 2980: hz_orig_system_ref_pub.get_owner_table_id

2976: and (p_party_rec.orig_system_reference is not null
2977: and p_party_rec.orig_system_reference <>fnd_api.g_miss_char)
2978: and p_create_update_flag = 'U'
2979: then
2980: hz_orig_system_ref_pub.get_owner_table_id
2981: (p_orig_system => p_party_rec.orig_system,
2982: p_orig_system_reference => p_party_rec.orig_system_reference,
2983: p_owner_table_name => 'HZ_PARTIES',
2984: x_owner_table_id => l_mosr_owner_table_id,

Line 2996: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the

2992: -- we will use unique osr and os for update - bypass osr validation
2993: ELSE l_validate_osr := 'Y';
2994: END IF;
2995:
2996: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
2997: -- x_return_status. Set x_return_status to error, ONLY if there is error.
2998: -- In case of success, leave it to carry over previous value as before this call.
2999: -- Fix for Bug 5498116 (29-AUG-2006)
3000: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 5938: -- hz_orig_system_ref_pub.get_owner_table_id

5934: -- Bug 3175816
5935: l_global_location_number HZ_PARTY_SITES.GLOBAL_LOCATION_NUMBER%TYPE;
5936:
5937: l_temp_return_status VARCHAR2(10); -- for storing return status from
5938: -- hz_orig_system_ref_pub.get_owner_table_id
5939: BEGIN
5940:
5941: --enable_debug;
5942:

Line 6200: hz_orig_system_ref_pub.get_owner_table_id

6196: and (p_party_site_rec.orig_system_reference is not null
6197: and p_party_site_rec.orig_system_reference <>fnd_api.g_miss_char)
6198: and p_create_update_flag = 'U'
6199: then
6200: hz_orig_system_ref_pub.get_owner_table_id
6201: (p_orig_system => p_party_site_rec.orig_system,
6202: p_orig_system_reference => p_party_site_rec.orig_system_reference,
6203: p_owner_table_name => 'HZ_PARTY_SITES',
6204: x_owner_table_id => l_mosr_owner_table_id,

Line 6216: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the

6212: -- we will use unique osr and os for update - bypass osr validation
6213: ELSE l_validate_osr := 'Y';
6214: END IF;
6215:
6216: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
6217: -- x_return_status. Set x_return_status to error, ONLY if there is error.
6218: -- In case of success, leave it to carry over previous value as before this call.
6219: -- Fix for Bug 5498116 (29-AUG-2006)
6220: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 7320: -- hz_orig_system_ref_pub.get_owner_table_id

7316: l_debug_prefix VARCHAR2(30) := '';
7317: l_validate_osr varchar2(1) := 'Y';
7318: l_mosr_owner_table_id number;
7319: l_temp_return_status VARCHAR2(10); -- for storing return status from
7320: -- hz_orig_system_ref_pub.get_owner_table_id
7321: BEGIN
7322:
7323: --enable_debug;
7324:

Line 7447: hz_orig_system_ref_pub.get_owner_table_id

7443: and p_org_contact_role_rec.orig_system_reference <>fnd_api.g_miss_char)
7444: and p_create_update_flag = 'U'
7445:
7446: then
7447: hz_orig_system_ref_pub.get_owner_table_id
7448: (p_orig_system => p_org_contact_role_rec.orig_system,
7449: p_orig_system_reference => p_org_contact_role_rec.orig_system_reference,
7450: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',
7451: x_owner_table_id => l_mosr_owner_table_id,

Line 7463: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the

7459: -- we will use unique osr and os for update - bypass osr validation
7460: ELSE l_validate_osr := 'Y';
7461: END IF;
7462:
7463: -- Call to hz_orig_system_ref_pub.get_owner_table_id API was resetting the
7464: -- x_return_status. Set x_return_status to error, ONLY if there is error.
7465: -- In case of success, leave it to carry over previous value as before this call.
7466: -- Fix for Bug 5498116 (29-AUG-2006)
7467: IF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN