DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_ROLE_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 163: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

159: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
160: l_location_id NUMBER;
161: l_party_site_id NUMBER;
162: l_party_site_number HZ_PARTY_SITES.party_site_number%TYPE;
163: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
164:
165: BEGIN
166:
167: -- Debug info.

Line 329: hz_orig_system_ref_pub.create_orig_system_reference(

325: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCOUNT_ROLES';
326: l_orig_sys_reference_rec.owner_table_id := p_cust_account_role_rec.cust_account_role_id;
327: l_orig_sys_reference_rec.created_by_module := p_cust_account_role_rec.created_by_module;
328:
329: hz_orig_system_ref_pub.create_orig_system_reference(
330: FND_API.G_FALSE,
331: l_orig_sys_reference_rec,
332: x_return_status,
333: l_msg_count,

Line 387: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

383: l_debug_prefix VARCHAR2(30) := ''; --'do_update_cust_account_role'
384:
385: l_rowid ROWID := NULL;
386: l_object_version_number NUMBER;
387: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
388:
389:
390: BEGIN
391:

Line 1028: hz_orig_system_ref_pub.get_owner_table_id

1024: IF (p_cust_account_role_rec.orig_system is not null and p_cust_account_role_rec.orig_system <>fnd_api.g_miss_char)
1025: and (p_cust_account_role_rec.orig_system_reference is not null and p_cust_account_role_rec.orig_system_reference <>fnd_api.g_miss_char)
1026: and (p_cust_account_role_rec.cust_account_role_id = FND_API.G_MISS_NUM or p_cust_account_role_rec.cust_account_role_id is null) THEN
1027:
1028: hz_orig_system_ref_pub.get_owner_table_id
1029: (p_orig_system => p_cust_account_role_rec.orig_system,
1030: p_orig_system_reference => p_cust_account_role_rec.orig_system_reference,
1031: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
1032: x_owner_table_id => l_cust_account_role_rec.cust_account_role_id,