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

Line 194: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

190: l_msg_data VARCHAR2(2000);
191:
192: l_location_id NUMBER;
193: l_loc_id NUMBER;
194: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
195: l_cust_acct_site_orig_sys VARCHAR2(255);
196:
197: /* 3456489 Added org_id for Shared Service Uptake */
198: CURSOR check_orig_sys_ref IS

Line 487: hz_orig_system_ref_pub.create_orig_system_reference(

483: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCT_SITES_ALL';
484: l_orig_sys_reference_rec.owner_table_id := p_cust_acct_site_rec.cust_acct_site_id;
485: l_orig_sys_reference_rec.created_by_module := p_cust_acct_site_rec.created_by_module;
486:
487: hz_orig_system_ref_pub.create_orig_system_reference(
488: FND_API.G_FALSE,
489: l_orig_sys_reference_rec,
490: x_return_status,
491: l_msg_count,

Line 635: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

631: l_rowid ROWID := NULL;
632: l_object_version_number NUMBER;
633: l_location_id NUMBER;
634: l_loc_id NUMBER;
635: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
636:
637:
638: /* 3456489 Added org_id for Shared Service Uptake */
639:

Line 964: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

960: l_cust_account_profile_id NUMBER;
961: l_bill_to_flag HZ_CUST_ACCT_SITES.bill_to_flag%TYPE;
962: l_ship_to_flag HZ_CUST_ACCT_SITES.ship_to_flag%TYPE;
963: l_market_flag HZ_CUST_ACCT_SITES.market_flag%TYPE;
964: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
965:
966: l_cnt number := 1;
967: l_cust_acct_id number;
968:

Line 1283: hz_orig_system_ref_pub.create_orig_system_reference(

1279: l_orig_sys_reference_rec.orig_system_reference := p_cust_site_use_rec.orig_system_reference;
1280: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_SITE_USES_ALL';
1281: l_orig_sys_reference_rec.owner_table_id := p_cust_site_use_rec.site_use_id;
1282: l_orig_sys_reference_rec.created_by_module := p_cust_site_use_rec.created_by_module;
1283: hz_orig_system_ref_pub.create_orig_system_reference(
1284: FND_API.G_FALSE,
1285: l_orig_sys_reference_rec,
1286: x_return_status,
1287: l_msg_count,

Line 1411: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

1407: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
1408: l_cust_acct_site_id NUMBER;
1409: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;
1410: l_status HZ_CUST_SITE_USES.status%TYPE;
1411: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1412:
1413: /* Bug Fix:5036975 */
1414: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;
1415: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;

Line 2243: hz_orig_system_ref_pub.get_owner_table_id

2239: IF (p_cust_acct_site_rec.orig_system is not null and p_cust_acct_site_rec.orig_system <>fnd_api.g_miss_char)
2240: and (p_cust_acct_site_rec.orig_system_reference is not null and p_cust_acct_site_rec.orig_system_reference <>fnd_api.g_miss_char)
2241: and (p_cust_acct_site_rec.cust_acct_site_id = FND_API.G_MISS_NUM or p_cust_acct_site_rec.cust_acct_site_id is null) THEN
2242:
2243: hz_orig_system_ref_pub.get_owner_table_id
2244: (p_orig_system => p_cust_acct_site_rec.orig_system,
2245: p_orig_system_reference => p_cust_acct_site_rec.orig_system_reference,
2246: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
2247: x_owner_table_id => l_cust_acct_site_rec.cust_acct_site_id,

Line 2941: hz_orig_system_ref_pub.get_owner_table_id

2937:
2938: IF (p_cust_site_use_rec.orig_system is not null and p_cust_site_use_rec.orig_system <>fnd_api.g_miss_char)
2939: and (p_cust_site_use_rec.orig_system_reference is not null and p_cust_site_use_rec.orig_system_reference <>fnd_api.g_miss_char)
2940: and (p_cust_site_use_rec.site_use_id = FND_API.G_MISS_NUM or p_cust_site_use_rec.site_use_id is null) THEN
2941: hz_orig_system_ref_pub.get_owner_table_id
2942: (p_orig_system => p_cust_site_use_rec.orig_system,
2943: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
2944: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
2945: x_owner_table_id => l_cust_site_use_rec.site_use_id ,