APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_CUST_SITE_USES

Line 3173: UPDATE HZ_CUST_SITE_USES_ALL

3169: p_prefix=>l_debug_prefix,
3170: p_msg_level=>fnd_log.level_procedure);
3171: END IF;
3172:
3173: UPDATE HZ_CUST_SITE_USES_ALL
3174: SET PRIMARY_FLAG = 'Y',
3175: last_update_date = hz_utility_v2pub.last_update_date,
3176: last_updated_by = hz_utility_v2pub.last_updated_by,
3177: last_update_login = hz_utility_v2pub.last_update_login,

Line 3276: l_site_use_id HZ_CUST_SITE_USES.SITE_USE_ID%TYPE;

3272: l_msg_count NUMBER;
3273: l_msg_data VARCHAR2(2000);
3274: l_debug_prefix VARCHAR2(30) := '';
3275: /* Bug 4515314 */
3276: l_site_use_id HZ_CUST_SITE_USES.SITE_USE_ID%TYPE;
3277: l_site_use_code HZ_CUST_SITE_USES.SITE_USE_CODE%TYPE;
3278: /* c_prim will pick the candidate acct site uses to be marked as primary
3279: once the acct sites sharing the p_party_site_id are made inactive
3280: even for multiple accounts sharing p_party_site_id */

Line 3277: l_site_use_code HZ_CUST_SITE_USES.SITE_USE_CODE%TYPE;

3273: l_msg_data VARCHAR2(2000);
3274: l_debug_prefix VARCHAR2(30) := '';
3275: /* Bug 4515314 */
3276: l_site_use_id HZ_CUST_SITE_USES.SITE_USE_ID%TYPE;
3277: l_site_use_code HZ_CUST_SITE_USES.SITE_USE_CODE%TYPE;
3278: /* c_prim will pick the candidate acct site uses to be marked as primary
3279: once the acct sites sharing the p_party_site_id are made inactive
3280: even for multiple accounts sharing p_party_site_id */
3281: cursor c_prim is

Line 3283: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b

3279: once the acct sites sharing the p_party_site_id are made inactive
3280: even for multiple accounts sharing p_party_site_id */
3281: cursor c_prim is
3282: SELECT MIN(b.site_use_id) , site_use_code
3283: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b
3284: WHERE a.cust_account_id in (select cust_account_id
3285: from hz_cust_acct_sites_all cas
3286: where cas.party_site_id = p_party_site_id)
3287: AND a.cust_acct_site_id = b.cust_acct_site_id

Line 3305: UPDATE HZ_CUST_SITE_USES_ALL

3301: END IF;
3302:
3303: -- check whether record has been updated by another user. If not, lock it.
3304: BEGIN
3305: UPDATE HZ_CUST_SITE_USES_ALL
3306: SET STATUS = p_new_status,
3307: primary_flag = 'N', --Bug 3370874
3308: last_update_date = hz_utility_v2pub.last_update_date,
3309: last_updated_by = hz_utility_v2pub.last_updated_by,