DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_CUSTOMER_PROFILE_V2PUB

Line 2287: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2283: );
2284:
2285: PROCEDURE do_create_cust_site_use (
2286: p_cust_site_use_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2287: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2288: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2289: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2290: p_org_id IN NUMBER DEFAULT null,
2291: x_site_use_id OUT NOCOPY NUMBER,

Line 2414: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2410:
2411:
2412: PROCEDURE do_create_cust_site_use (
2413: p_cust_site_use_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2414: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2415: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2416: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2417: p_org_id IN NUMBER DEFAULT null,
2418: x_site_use_id OUT NOCOPY NUMBER,

Line 2742: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2738:
2739: PROCEDURE create_cust_site_use (
2740: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2741: p_cust_site_use_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
2742: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2743: p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
2744: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
2745: p_org_id IN NUMBER ,
2746: x_site_use_id OUT NOCOPY NUMBER,

Line 2754: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

2750: ) IS
2751:
2752: l_cust_site_use_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE
2753: := p_cust_site_use_rec;
2754: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2755: := p_customer_profile_rec;
2756:
2757: BEGIN
2758:

Line 2834: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2830: ----------------CUST_PROFILE-----------------------------------------------------
2831:
2832: ----Private procedures
2833: PROCEDURE do_create_customer_profile (
2834: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2835: p_create_profile_amt IN VARCHAR2,
2836: x_cust_account_profile_id OUT NOCOPY NUMBER,
2837: x_return_status IN OUT NOCOPY VARCHAR2
2838: );

Line 2843: p_cust_profile_amt_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,

2839:
2840:
2841: PROCEDURE do_create_cust_profile_amt (
2842: p_check_foreign_key IN VARCHAR2,
2843: p_cust_profile_amt_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
2844: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
2845: x_return_status IN OUT NOCOPY VARCHAR2
2846: );
2847:

Line 2851: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

2847:
2848: ---Definition
2849:
2850: PROCEDURE do_create_customer_profile (
2851: p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
2852: p_create_profile_amt IN VARCHAR2,
2853: x_cust_account_profile_id OUT NOCOPY NUMBER,
2854: x_return_status IN OUT NOCOPY VARCHAR2
2855: ) IS

Line 2996: p_cust_profile_amt_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,

2992:
2993:
2994: PROCEDURE do_create_cust_profile_amt (
2995: p_check_foreign_key IN VARCHAR2,
2996: p_cust_profile_amt_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
2997: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
2998: x_return_status IN OUT NOCOPY VARCHAR2
2999: ) IS
3000:

Line 3109: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,

3105: -- public procedures and functions
3106: --------------------------------------
3107: PROCEDURE create_customer_profile (
3108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3109: p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
3110: p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
3111: x_cust_account_profile_id OUT NOCOPY NUMBER,
3112: x_return_status OUT NOCOPY VARCHAR2,
3113: x_msg_count OUT NOCOPY NUMBER,

Line 3117: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

3113: x_msg_count OUT NOCOPY NUMBER,
3114: x_msg_data OUT NOCOPY VARCHAR2
3115: ) IS
3116:
3117: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
3118: := p_customer_profile_rec;
3119:
3120: BEGIN
3121:

Line 3197: p_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,

3193:
3194: PROCEDURE create_cust_profile_amt (
3195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3196: p_check_foreign_key IN VARCHAR2 := FND_API.G_TRUE,
3197: p_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
3198: x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
3199: x_return_status OUT NOCOPY VARCHAR2,
3200: x_msg_count OUT NOCOPY NUMBER,
3201: x_msg_data OUT NOCOPY VARCHAR2

Line 3204: l_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE :=

3200: x_msg_count OUT NOCOPY NUMBER,
3201: x_msg_data OUT NOCOPY VARCHAR2
3202: ) IS
3203:
3204: l_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE :=
3205: p_cust_profile_amt_rec;
3206:
3207: BEGIN
3208: