APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2404: 'HZ_CUST_ACCT_SITES_ALL',

2400: /*
2401: per HLD,mosr record should not be created for copy case, since old osr is still active
2402: hz_orig_system_ref_pvt.create_mosr_for_merge(
2403: FND_API.G_FALSE,
2404: 'HZ_CUST_ACCT_SITES_ALL',
2405: p_cust_acct_site_rec.cust_acct_site_id,
2406: x_return_status,
2407: l_msg_count,
2408: l_msg_data);

Line 2439: l_bill_to_flag HZ_CUST_ACCT_SITES_ALL.bill_to_flag%TYPE;

2435: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
2436: l_party_site_id NUMBER;
2437: l_party_site_use_id NUMBER;
2438: l_cust_account_profile_id NUMBER;
2439: l_bill_to_flag HZ_CUST_ACCT_SITES_ALL.bill_to_flag%TYPE;
2440: l_ship_to_flag HZ_CUST_ACCT_SITES_ALL.ship_to_flag%TYPE;
2441: l_market_flag HZ_CUST_ACCT_SITES_ALL.market_flag%TYPE;
2442:
2443: BEGIN

Line 2440: l_ship_to_flag HZ_CUST_ACCT_SITES_ALL.ship_to_flag%TYPE;

2436: l_party_site_id NUMBER;
2437: l_party_site_use_id NUMBER;
2438: l_cust_account_profile_id NUMBER;
2439: l_bill_to_flag HZ_CUST_ACCT_SITES_ALL.bill_to_flag%TYPE;
2440: l_ship_to_flag HZ_CUST_ACCT_SITES_ALL.ship_to_flag%TYPE;
2441: l_market_flag HZ_CUST_ACCT_SITES_ALL.market_flag%TYPE;
2442:
2443: BEGIN
2444:

Line 2441: l_market_flag HZ_CUST_ACCT_SITES_ALL.market_flag%TYPE;

2437: l_party_site_use_id NUMBER;
2438: l_cust_account_profile_id NUMBER;
2439: l_bill_to_flag HZ_CUST_ACCT_SITES_ALL.bill_to_flag%TYPE;
2440: l_ship_to_flag HZ_CUST_ACCT_SITES_ALL.ship_to_flag%TYPE;
2441: l_market_flag HZ_CUST_ACCT_SITES_ALL.market_flag%TYPE;
2442:
2443: BEGIN
2444:
2445: p_cust_site_use_rec.created_by_module := 'HZ_TCA_CUSTOMER_MERGE';

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

2555: X_ORG_ID => p_org_id
2556: );
2557:
2558: -- If this is a active bill_to or ship_to or market,
2559: -- set the appropriate denormalized flag in hz_cust_acct_sites_all.
2560:
2561: IF p_cust_site_use_rec.site_use_code IN ('BILL_TO', 'SHIP_TO', 'MARKET' ) THEN
2562: ----Bug No.5211233
2563: IF p_cust_site_use_rec.primary_flag = 'Y' THEN

Line 2592: FROM HZ_CUST_ACCT_SITES_ALL

2588: p_customer_profile_rec.created_by_module := p_cust_site_use_rec.created_by_module;
2589: p_customer_profile_rec.application_id := p_cust_site_use_rec.application_id;
2590:
2591: SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
2592: FROM HZ_CUST_ACCT_SITES_ALL
2593: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
2594:
2595: create_customer_profile (
2596: p_customer_profile_rec => p_customer_profile_rec,

Line 2642: UPDATE HZ_CUST_ACCT_SITES_ALL

2638: BEGIN
2639:
2640:
2641: IF p_site_use_code = 'BILL_TO' THEN
2642: UPDATE HZ_CUST_ACCT_SITES_ALL
2643: SET BILL_TO_FLAG = p_flag
2644: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2645: ELSIF p_site_use_code = 'SHIP_TO' THEN
2646: UPDATE HZ_CUST_ACCT_SITES_ALL

Line 2646: UPDATE HZ_CUST_ACCT_SITES_ALL

2642: UPDATE HZ_CUST_ACCT_SITES_ALL
2643: SET BILL_TO_FLAG = p_flag
2644: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2645: ELSIF p_site_use_code = 'SHIP_TO' THEN
2646: UPDATE HZ_CUST_ACCT_SITES_ALL
2647: SET SHIP_TO_FLAG = p_flag
2648: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2649: ELSIF p_site_use_code = 'MARKET' THEN
2650: UPDATE HZ_CUST_ACCT_SITES_ALL

Line 2650: UPDATE HZ_CUST_ACCT_SITES_ALL

2646: UPDATE HZ_CUST_ACCT_SITES_ALL
2647: SET SHIP_TO_FLAG = p_flag
2648: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2649: ELSIF p_site_use_code = 'MARKET' THEN
2650: UPDATE HZ_CUST_ACCT_SITES_ALL
2651: SET MARKET_FLAG = p_flag
2652: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2653: END IF;
2654: