DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_V2PUB dependencies on HZ_CUSTOMER_PROFILES

Line 617: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );

613: p_customer_profile_rec.site_use_id <> FND_API.G_MISS_NUM
614: THEN
615: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
616: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
617: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:

Line 2415: FROM HZ_CUSTOMER_PROFILES

2411: END IF;
2412:
2413: -- Fetch customer profile id.
2414: SELECT CUST_ACCOUNT_PROFILE_ID INTO l_cust_account_profile_id
2415: FROM HZ_CUSTOMER_PROFILES
2416: WHERE CUST_ACCOUNT_ID = p_cust_account_id
2417: AND SITE_USE_ID IS NULL;
2418:
2419: HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec (