APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2398: 'HZ_CUST_ACCT_SITES_ALL',

2394: /*
2395: per HLD,mosr record should not be created for copy case, since old osr is still active
2396: hz_orig_system_ref_pvt.create_mosr_for_merge(
2397: FND_API.G_FALSE,
2398: 'HZ_CUST_ACCT_SITES_ALL',
2399: p_cust_acct_site_rec.cust_acct_site_id,
2400: x_return_status,
2401: l_msg_count,
2402: l_msg_data);

Line 2433: l_bill_to_flag HZ_CUST_ACCT_SITES_ALL.bill_to_flag%TYPE;

2429: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
2430: l_party_site_id NUMBER;
2431: l_party_site_use_id NUMBER;
2432: l_cust_account_profile_id NUMBER;
2433: l_bill_to_flag HZ_CUST_ACCT_SITES_ALL.bill_to_flag%TYPE;
2434: l_ship_to_flag HZ_CUST_ACCT_SITES_ALL.ship_to_flag%TYPE;
2435: l_market_flag HZ_CUST_ACCT_SITES_ALL.market_flag%TYPE;
2436:
2437: BEGIN

Line 2434: l_ship_to_flag HZ_CUST_ACCT_SITES_ALL.ship_to_flag%TYPE;

2430: l_party_site_id NUMBER;
2431: l_party_site_use_id NUMBER;
2432: l_cust_account_profile_id NUMBER;
2433: l_bill_to_flag HZ_CUST_ACCT_SITES_ALL.bill_to_flag%TYPE;
2434: l_ship_to_flag HZ_CUST_ACCT_SITES_ALL.ship_to_flag%TYPE;
2435: l_market_flag HZ_CUST_ACCT_SITES_ALL.market_flag%TYPE;
2436:
2437: BEGIN
2438:

Line 2435: l_market_flag HZ_CUST_ACCT_SITES_ALL.market_flag%TYPE;

2431: l_party_site_use_id NUMBER;
2432: l_cust_account_profile_id NUMBER;
2433: l_bill_to_flag HZ_CUST_ACCT_SITES_ALL.bill_to_flag%TYPE;
2434: l_ship_to_flag HZ_CUST_ACCT_SITES_ALL.ship_to_flag%TYPE;
2435: l_market_flag HZ_CUST_ACCT_SITES_ALL.market_flag%TYPE;
2436:
2437: BEGIN
2438:
2439: p_cust_site_use_rec.created_by_module := 'HZ_TCA_CUSTOMER_MERGE';

Line 2553: -- set the appropriate denormalized flag in hz_cust_acct_sites_all.

2549: X_ORG_ID => p_org_id
2550: );
2551:
2552: -- If this is a active bill_to or ship_to or market,
2553: -- set the appropriate denormalized flag in hz_cust_acct_sites_all.
2554:
2555: IF p_cust_site_use_rec.site_use_code IN ('BILL_TO', 'SHIP_TO', 'MARKET' ) THEN
2556: ----Bug No.5211233
2557: IF p_cust_site_use_rec.primary_flag = 'Y' THEN

Line 2586: FROM HZ_CUST_ACCT_SITES_ALL

2582: p_customer_profile_rec.created_by_module := p_cust_site_use_rec.created_by_module;
2583: p_customer_profile_rec.application_id := p_cust_site_use_rec.application_id;
2584:
2585: SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
2586: FROM HZ_CUST_ACCT_SITES_ALL
2587: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
2588:
2589: create_customer_profile (
2590: p_customer_profile_rec => p_customer_profile_rec,

Line 2636: UPDATE HZ_CUST_ACCT_SITES_ALL

2632: BEGIN
2633:
2634:
2635: IF p_site_use_code = 'BILL_TO' THEN
2636: UPDATE HZ_CUST_ACCT_SITES_ALL
2637: SET BILL_TO_FLAG = p_flag
2638: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2639: ELSIF p_site_use_code = 'SHIP_TO' THEN
2640: UPDATE HZ_CUST_ACCT_SITES_ALL

Line 2640: UPDATE HZ_CUST_ACCT_SITES_ALL

2636: UPDATE HZ_CUST_ACCT_SITES_ALL
2637: SET BILL_TO_FLAG = p_flag
2638: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2639: ELSIF p_site_use_code = 'SHIP_TO' THEN
2640: UPDATE HZ_CUST_ACCT_SITES_ALL
2641: SET SHIP_TO_FLAG = p_flag
2642: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2643: ELSIF p_site_use_code = 'MARKET' THEN
2644: UPDATE HZ_CUST_ACCT_SITES_ALL

Line 2644: UPDATE HZ_CUST_ACCT_SITES_ALL

2640: UPDATE HZ_CUST_ACCT_SITES_ALL
2641: SET SHIP_TO_FLAG = p_flag
2642: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2643: ELSIF p_site_use_code = 'MARKET' THEN
2644: UPDATE HZ_CUST_ACCT_SITES_ALL
2645: SET MARKET_FLAG = p_flag
2646: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2647: END IF;
2648: