DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUSTOMER_PROFILE_V2PUB

Line 39: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

35: );
36:
37: PROCEDURE do_create_cust_site_use (
38: p_cust_site_use_rec IN OUT NOCOPY CUST_SITE_USE_REC_TYPE,
39: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
40: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
41: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
42: x_site_use_id OUT NOCOPY NUMBER,
43: x_return_status IN OUT NOCOPY VARCHAR2

Line 1023: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

1019: */
1020:
1021: PROCEDURE do_create_cust_site_use (
1022: p_cust_site_use_rec IN OUT NOCOPY CUST_SITE_USE_REC_TYPE,
1023: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
1024: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
1025: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
1026: x_site_use_id OUT NOCOPY NUMBER,
1027: x_return_status IN OUT NOCOPY VARCHAR2

Line 1462: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1458: SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
1459: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1460: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1461:
1462: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1463: p_customer_profile_rec => p_customer_profile_rec,
1464: p_create_profile_amt => p_create_profile_amt,
1465: x_return_status => x_return_status,
1466: x_msg_count => l_msg_count,

Line 2843: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2839:
2840: PROCEDURE create_cust_site_use (
2841: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2842: p_cust_site_use_rec IN CUST_SITE_USE_REC_TYPE,
2843: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2844: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2845: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2846: x_site_use_id OUT NOCOPY NUMBER,
2847: x_return_status OUT NOCOPY VARCHAR2,

Line 2853: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE := p_customer_profile_rec;

2849: x_msg_data OUT NOCOPY VARCHAR2
2850: ) IS
2851:
2852: l_cust_site_use_rec CUST_SITE_USE_REC_TYPE := p_cust_site_use_rec;
2853: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE := p_customer_profile_rec;
2854: l_debug_prefix VARCHAR2(30) := '';
2855:
2856: BEGIN
2857:

Line 3051: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

3047: ) IS
3048:
3049: l_cust_site_use_rec CUST_SITE_USE_REC_TYPE := p_cust_site_use_rec;
3050: l_old_cust_site_use_rec CUST_SITE_USE_REC_TYPE ;
3051: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
3052: l_debug_prefix VARCHAR2(30) := '';
3053:
3054: BEGIN
3055:

Line 3270: x_customer_profile_rec OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

3266: PROCEDURE get_cust_site_use_rec (
3267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3268: p_site_use_id IN NUMBER,
3269: x_cust_site_use_rec OUT NOCOPY CUST_SITE_USE_REC_TYPE,
3270: x_customer_profile_rec OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
3271: x_return_status OUT NOCOPY VARCHAR2,
3272: x_msg_count OUT NOCOPY NUMBER,
3273: x_msg_data OUT NOCOPY VARCHAR2
3274: ) IS

Line 3435: HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec (

3431: SELECT CUST_ACCOUNT_PROFILE_ID INTO l_cust_account_profile_id
3432: FROM HZ_CUSTOMER_PROFILES
3433: WHERE SITE_USE_ID = p_site_use_id;
3434:
3435: HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec (
3436: p_cust_account_profile_id => l_cust_account_profile_id,
3437: x_customer_profile_rec => x_customer_profile_rec,
3438: x_return_status => x_return_status,
3439: x_msg_count => x_msg_count,