APPS.HZ_CUST_ACCOUNT_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 214: l_orig_system_ref_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

210: l_party_number HZ_PARTIES.party_number%TYPE;
211: l_party_type HZ_PARTIES.party_type%TYPE;
212: l_profile_id NUMBER;
213: l_cust_account_profile_id NUMBER;
214: l_orig_system_ref_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
215:
216: CURSOR check_orig_sys_ref IS
217: select 'Y' from hz_cust_accounts
218: where ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;

Line 582: hz_orig_system_ref_pub.create_orig_system_reference(

578: l_orig_system_ref_rec.owner_table_name := 'HZ_CUST_ACCOUNTS';
579: l_orig_system_ref_rec.owner_table_id := p_cust_account_rec.cust_account_id;
580: l_orig_system_ref_rec.created_by_module := p_cust_account_rec.created_by_module;
581:
582: hz_orig_system_ref_pub.create_orig_system_reference(
583: FND_API.G_FALSE,
584: l_orig_system_ref_rec,
585: x_return_status,
586: l_msg_count,

Line 728: l_orig_system_ref_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

724: l_debug_prefix VARCHAR2(30) := ''; --'do_update_cust_account';
725:
726: l_rowid ROWID := NULL;
727: l_object_version_number NUMBER;
728: l_orig_system_ref_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
729:
730: CURSOR check_orig_sys_ref IS
731: select 'Y' from hz_cust_accounts
732: where ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;

Line 2043: hz_orig_system_ref_pub.get_owner_table_id

2039:
2040: IF (p_cust_account_rec.orig_system is not null and p_cust_account_rec.orig_system <>fnd_api.g_miss_char)
2041: and (p_cust_account_rec.orig_system_reference is not null and p_cust_account_rec.orig_system_reference <>fnd_api.g_miss_char)
2042: and (p_cust_account_rec.cust_account_id = FND_API.G_MISS_NUM or p_cust_account_rec.cust_account_id is null) THEN
2043: hz_orig_system_ref_pub.get_owner_table_id
2044: (p_orig_system => p_cust_account_rec.orig_system,
2045: p_orig_system_reference => p_cust_account_rec.orig_system_reference,
2046: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
2047: x_owner_table_id => l_cust_account_rec.cust_account_id,