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 941: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

937: */
938:
939: PROCEDURE do_create_cust_site_use (
940: p_cust_site_use_rec IN OUT NOCOPY CUST_SITE_USE_REC_TYPE,
941: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
942: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
943: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
944: x_site_use_id OUT NOCOPY NUMBER,
945: x_return_status IN OUT NOCOPY VARCHAR2

Line 1331: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

1327: SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
1328: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1329: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1330:
1331: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1332: p_customer_profile_rec => p_customer_profile_rec,
1333: p_create_profile_amt => p_create_profile_amt,
1334: x_return_status => x_return_status,
1335: x_msg_count => l_msg_count,

Line 2704: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2700:
2701: PROCEDURE create_cust_site_use (
2702: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2703: p_cust_site_use_rec IN CUST_SITE_USE_REC_TYPE,
2704: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2705: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2706: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2707: x_site_use_id OUT NOCOPY NUMBER,
2708: x_return_status OUT NOCOPY VARCHAR2,

Line 2714: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE := p_customer_profile_rec;

2710: x_msg_data OUT NOCOPY VARCHAR2
2711: ) IS
2712:
2713: l_cust_site_use_rec CUST_SITE_USE_REC_TYPE := p_cust_site_use_rec;
2714: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE := p_customer_profile_rec;
2715: l_debug_prefix VARCHAR2(30) := '';
2716:
2717: BEGIN
2718:

Line 2912: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

2908: ) IS
2909:
2910: l_cust_site_use_rec CUST_SITE_USE_REC_TYPE := p_cust_site_use_rec;
2911: l_old_cust_site_use_rec CUST_SITE_USE_REC_TYPE ;
2912: l_old_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
2913: l_debug_prefix VARCHAR2(30) := '';
2914:
2915: BEGIN
2916:

Line 3131: x_customer_profile_rec OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

3127: PROCEDURE get_cust_site_use_rec (
3128: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3129: p_site_use_id IN NUMBER,
3130: x_cust_site_use_rec OUT NOCOPY CUST_SITE_USE_REC_TYPE,
3131: x_customer_profile_rec OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
3132: x_return_status OUT NOCOPY VARCHAR2,
3133: x_msg_count OUT NOCOPY NUMBER,
3134: x_msg_data OUT NOCOPY VARCHAR2
3135: ) IS

Line 3296: HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec (

3292: SELECT CUST_ACCOUNT_PROFILE_ID INTO l_cust_account_profile_id
3293: FROM HZ_CUSTOMER_PROFILES
3294: WHERE SITE_USE_ID = p_site_use_id;
3295:
3296: HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec (
3297: p_cust_account_profile_id => l_cust_account_profile_id,
3298: x_customer_profile_rec => x_customer_profile_rec,
3299: x_return_status => x_return_status,
3300: x_msg_count => x_msg_count,