DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_CUSTOMER_PROFILE_V2PUB

Line 2293: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2289: );
2290:
2291: PROCEDURE do_create_cust_site_use (
2292: p_cust_site_use_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2293: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2294: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2295: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2296: p_org_id IN NUMBER DEFAULT null,
2297: x_site_use_id OUT NOCOPY NUMBER,

Line 2420: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2416:
2417:
2418: PROCEDURE do_create_cust_site_use (
2419: p_cust_site_use_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2420: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2421: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2422: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2423: p_org_id IN NUMBER DEFAULT null,
2424: x_site_use_id OUT NOCOPY NUMBER,

Line 2750: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2746:
2747: PROCEDURE create_cust_site_use (
2748: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2749: p_cust_site_use_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2750: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2751: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2752: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2753: p_org_id IN NUMBER ,
2754: x_site_use_id OUT NOCOPY NUMBER,

Line 2762: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

2758: ) IS
2759:
2760: l_cust_site_use_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE
2761: := p_cust_site_use_rec;
2762: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2763: := p_customer_profile_rec;
2764:
2765: BEGIN
2766:

Line 2844: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2840: ----------------CUST_PROFILE-----------------------------------------------------
2841:
2842: ----Private procedures
2843: PROCEDURE do_create_customer_profile (
2844: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2845: p_create_profile_amt IN VARCHAR2,
2846: x_cust_account_profile_id OUT NOCOPY NUMBER,
2847: x_return_status IN OUT NOCOPY VARCHAR2
2848: );

Line 2853: p_cust_profile_amt_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,

2849:
2850:
2851: PROCEDURE do_create_cust_profile_amt (
2852: p_check_foreign_key IN VARCHAR2,
2853: p_cust_profile_amt_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
2854: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
2855: x_return_status IN OUT NOCOPY VARCHAR2
2856: );
2857:

Line 2861: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2857:
2858: ---Definition
2859:
2860: PROCEDURE do_create_customer_profile (
2861: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2862: p_create_profile_amt IN VARCHAR2,
2863: x_cust_account_profile_id OUT NOCOPY NUMBER,
2864: x_return_status IN OUT NOCOPY VARCHAR2
2865: ) IS

Line 3007: p_cust_profile_amt_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,

3003:
3004:
3005: PROCEDURE do_create_cust_profile_amt (
3006: p_check_foreign_key IN VARCHAR2,
3007: p_cust_profile_amt_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
3008: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
3009: x_return_status IN OUT NOCOPY VARCHAR2
3010: ) IS
3011:

Line 3120: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

3116: -- public procedures and functions
3117: --------------------------------------
3118: PROCEDURE create_customer_profile (
3119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3120: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
3121: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
3122: x_cust_account_profile_id OUT NOCOPY NUMBER,
3123: x_return_status OUT NOCOPY VARCHAR2,
3124: x_msg_count OUT NOCOPY NUMBER,

Line 3128: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

3124: x_msg_count OUT NOCOPY NUMBER,
3125: x_msg_data OUT NOCOPY VARCHAR2
3126: ) IS
3127:
3128: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
3129: := p_customer_profile_rec;
3130:
3131: BEGIN
3132:

Line 3210: p_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,

3206:
3207: PROCEDURE create_cust_profile_amt (
3208: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3209: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
3210: p_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
3211: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
3212: x_return_status OUT NOCOPY VARCHAR2,
3213: x_msg_count OUT NOCOPY NUMBER,
3214: x_msg_data OUT NOCOPY VARCHAR2

Line 3217: l_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE :=

3213: x_msg_count OUT NOCOPY NUMBER,
3214: x_msg_data OUT NOCOPY VARCHAR2
3215: ) IS
3216:
3217: l_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE :=
3218: p_cust_profile_amt_rec;
3219:
3220: BEGIN
3221: